|
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
Element: 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
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 18.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
|