Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              CBRECON FILE

                      Manual Reconciliation Entry

The Manual Reconciliation Entry file contains manually entered records of
reconciled transactions from a bank statement to be processed by the Bank Tape
Mass Reconciliation program.

When you run CB185 (Bank Tape Mass Reconciliation) with Data Input in the Run
Option field, the system reconciles the manual reconciliation entry records
against the transactions processed in the Lawson Accounts Payable, Accounts
Receivable, and Cash Ledger systems. The program deletes the records from this
file after it reconciles them.

UPDATED BY

CB185     CB25.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CBR-CASH-CODE        Alpha 4                                     CB25.1
Cash Code            The cash code. Represents a bank
                     account. Must be a valid record in the
                     Cash Code file.

CBR-BANK-INST-CODE   Alpha 3                                     CB25.1
Transaction Code     The transaction code. Represents a type
                     of cash payment, bill of exchange
                     payment, or bank service transaction.
                     Must be a valid record in the Bank
                     Transaction Code file.

CBR-TRANS-NBR        Alpha 10  (Right Justified)                 CB25.1
Transaction Number   The unique identification number
                     assigned to the transaction to be
                     reconciled.

CBR-TAPE-REC-STAT    Alpha 1
Tape Reconciliation  The reconciled status of the
Status               transaction. THIS FIELD IS NOT CURRENTLY
                     USED.

CBR-RECON-DATE       Numeric 8  (yyyymmdd)                       CB25.1
Reconciliation or    The date the transaction cleared the
Void Date            bank.

CBR-RECON-BNK-AMT    Signed 15.2                                 CB25.1
Acct Curr            The amount of the transaction
Reconciliation Amt   recognized by the bank in the currency
                     of the bank account.

                         CBRECON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBRSET1   CASH-CODE     This index is used to identify a bank    CB185   CB25.1
          BANK-INST-CODEtransaction on a bank statement.
          TRANS-NBR