Reconciliation Adjustment

The Reconciliation Adjustment file contains Cash Ledger transaction reconciliation adjustment records. The system creates these records when the reconciled amount of a transaction is higher or lower than the transaction amount beyond the accepted tolerance. The reconciliation adjustment must be approved and released before the transaction is considered reconciled.

REFERENCED BY

AP170	AP180	AP181	AP190	AP255	AP265
AP81.1	AP90.5	CB06.2	CB10.1	CB145	CB15.1
CB15.2	CB150	CB180	CB186	CB187	CB190
CB191	CB20.1	CB20.6	CB25.1	CB46.1	CB500
CB543	CB544	CB195	CB99.1

UPDATED BY

CB185

CB30.1

CB300

CB80.1

CB82.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CBJ-CASH-CODE Element: Cash Code	Alpha 4 The cash code. Represents a bank account. Must be a valid record in the Cash Code file.	CB185 CB80.1 CB82.1
CBJ-TRANS-NBR Element: Transaction Number	Alpha 10 (Right Justified) The transaction number. Represents a unique value used to identify the transaction.	CB185 CB80.1 CB82.1
CBJ-SUFFIX Element: Transaction Suffix	Numeric 3 The transaction suffix number. Represents the occurrence value of the transaction.	CB185 CB80.1 CB82.1
CBJ-BANK-INST-CODE Element: Transaction Code	Alpha 3 The transaction code. Represents the type of banking transaction. Must be a valid transaction code record in the Bank Transaction Code file.	CB185 CB80.1 CB82.1
CBJ-TRANS-IDENT Element: Transaction ID	Numeric 10 A unique system-generated identification value assigned to the transaction to make this record unique.	CB185 CB80.1 CB82.1
CBJ-COMPANY Element: Company	Numeric 4 The company responsible for generating the transaction. Must be a valid record in the General Ledger Company file.	CB185 CB80.1 CB82.1
CBJ-ISSUE-BNK-AMT Acct Currency Issued Amount	Signed 18.2 The issued amount of the transaction in the currency of the bank account.	CB185 CB80.1 CB82.1
CBJ-RECON-BNK-AMT Acct Currency Issued Amount	Signed 18.2 The reconciled amount of the transaction in the currency of the bank account. This is the amount of the transaction recognized by the bank.	CB185 CB80.1 CB82.1
CBJ-ISSUE-BASE-AMT Base Currency Issued Amount	Signed 18.2 The issued amount of the transaction in the company base currency.	CB185 CB80.1 CB82.1
CBJ-RECON-BASE-AMT Base Currency Reconciled Amt	Signed 18.2 The reconciled amount of the transaction in the company base currency.	CB185 CB80.1 CB82.1
CBJ-RECON-CNV-RATE Reconciliation Exchange Rate	Signed 14.7 The currency exchange rate used to convert the transaction amount from the bank account currency to the company base currency. This is the rate in effect at the time the bank recognized the bank transaction.	CB185 CB30.1 CB80.1 CB82.1
CBJ-DIST-APPLIED Distribution Applied Amount	Signed 18.2 The amount of general ledger distributions that have been applied to the reconciliation adjustment in the currency of the bank account. The reconciliation adjustment can not be released until the reconciliation difference matches this distribution applied amount value.	CB30.1
CBJ-BASE-APPLIED Base Distribution Applied Amt	Signed 18.2 The amount of general ledger distributions that have been applied to the reconciliation adjustment in the company base currency.	CB30.1
CBJ-RECON-DATE Element: Reconcile Date	Numeric 8 (yyyymmdd) The reconciliation date of the bank transaction. If left blank, the system date defaults.	CB185 CB30.1 CB80.1 CB82.1
CBJ-POST-DATE Element: Post Date	Numeric 8 (yyyymmdd) The date used for posting the reconciliation transactions to the general ledger. If left blank, system date defaults.	CB185 CB30.1 CB80.1 CB82.1
CBJ-REC-STATUS Element: Reconcile Status	Numeric 1 The record status. Valid values are: 0 = Unreleased (Unreconciled). 1 = Released (Reconciled).	CB185 CB30.1
CBJ-JRNL-BOOK-NBR Element: Journal Book Number	Alpha 12 The journal book associated with the transaction reconciliation adjustment.	CB185 CB80.1 CB82.1
CBJ-RECON-STMT-NBR Reconcile Statement Number	Numeric 12 The reconciliation statement number associated with the reconciliation adjustment. Used only for cash codes that require reconciliation statements.	CB185 CB80.1 CB82.1

CBADJUST FILE INDEX

CBADJUST FILE RELATIONS

ONE TO MANY RELATIONS

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