Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBRECON


                              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
Accounts Receivable    The cash code. Represents a bank
Code                   account. Must be a valid record in the
                       Cash Code file.

CBR-BANK-INST-CODE     Alpha 3                                   CB25.1
Element: Transaction CoThe 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
Element: Transaction NuThe unique identification number
                       assigned to the transaction to be
                       reconciled.

CBR-TRANS-IDENT        Numeric 10                                CB25.1
Element: Trans Ident   A unique system-generated
                       identification value assigned to the
                       transaction to make this record unique.

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
          TRANS-IDENT