CBRECON

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
Element: Cash Code
Alpha 4
The cash code. Represents a bank account. Must be a valid record in the Cash Code file.
CB25.1
CBR-BANK-INST-CODE
Element: Transaction Code
Alpha 3
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.
CB25.1
CBR-TRANS-NBR
Element: Transaction Number
Alpha 10 (Right Justified)
The unique identification number assigned to the transaction to be reconciled.
CB25.1
CBR-TRANS-IDENT
Element: Trans Ident
Numeric 10
A unique system-generated identification value assigned to the transaction to make this record unique.
CB25.1
CBR-TAPE-REC-STAT
Tape Reconciliation
Status
Alpha 1
The reconciled status of the transaction. THIS FIELD IS NOT CURRENTLY USED.
CBR-RECON-DATE
Element: Recon Date
Numeric 8 (yyyymmdd)
The date the transaction cleared the bank.
CB25.1
CBR-RECON-BNK-AMT
Acct Curr
Reconciliation Amt
Signed 18.2
The amount of the transaction recognized by the bank in the currency of the bank account.
CB25.1


CBRECON FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBRSET1 CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CB185 CB25.1


File created: Thu Jun 09 11:11:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.