|
|
CBADJUST FILE
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 AR115 AR124 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR30.1 AR32.1 AR34.1
AR570 AR575 AR580 AR82.1 CB06.2 CB10.1
CB145 CB15.1 CB15.2 CB150 CB180 CB186
CB187 CB190 CB191 CB20.1 CB25.1 CB46.1
CB500 CB543 CB544 DT180 DT181 DT185
DT92.1 CB195 CB99.1
UPDATED BY
CB185 CB30.1 CB300 CB80.1 CB82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBJ-CASH-CODE Alpha 4 CB185 CB80.1
Element: Cash Code The cash code. Represents a bank CB82.1
account. Must be a valid record in the
Cash Code file.
CBJ-TRANS-NBR Alpha 10 (Right Justified) CB185 CB80.1
Element: Transaction NuThe transaction number. Represents a CB82.1
unique value used to identify the
transaction.
CBJ-SUFFIX Numeric 3 CB185 CB80.1
Element: Transaction SuThe transaction suffix number. CB82.1
Represents the occurrence value of the
transaction.
CBJ-BANK-INST-CODE Alpha 3 CB185 CB80.1
Element: Transaction CoThe transaction code. Represents the CB82.1
type of banking transaction. Must be a
valid transaction code record in the
Bank Transaction Code file.
CBJ-TRANS-IDENT Numeric 10 CB185 CB80.1
Element: Transaction IDA unique system-generated CB82.1
identification value assigned to the
transaction to make this record unique.
CBJ-COMPANY Numeric 4 CB185 CB80.1
Element: Company The company responsible for generating CB82.1
the transaction. Must be a valid record
in the General Ledger Company file.
CBJ-ISSUE-BNK-AMT Signed 18.2 CB185 CB80.1
Acct Currency The issued amount of the transaction in CB82.1
Issued Amount the currency of the bank account.
CBJ-RECON-BNK-AMT Signed 18.2 CB185 CB80.1
Acct Currency The reconciled amount of the CB82.1
Issued Amount transaction in the currency of the bank
account. This is the amount of the
transaction recognized by the bank.
CBJ-ISSUE-BASE-AMT Signed 18.2 CB185 CB80.1
Base Currency The issued amount of the transaction in CB82.1
Issued Amount the company base currency.
CBJ-RECON-BASE-AMT Signed 18.2 CB185 CB80.1
Base Currency The reconciled amount of the CB82.1
Reconciled Amt transaction in the company base
currency.
CBJ-RECON-CNV-RATE Signed 14.7 CB185 CB30.1
Reconciliation The currency exchange rate used to CB80.1 CB82.1
Exchange Rate 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.
CBJ-DIST-APPLIED Signed 18.2 CB30.1
Distribution The amount of general ledger
Applied Amount 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.
CBJ-BASE-APPLIED Signed 18.2 CB30.1
Base Distribution The amount of general ledger
Applied Amt distributions that have been applied to
the reconciliation adjustment in the
company base currency.
CBJ-RECON-DATE Numeric 8 (yyyymmdd) CB185 CB30.1
Element: Reconcile DateThe reconciliation date of the bank CB80.1 CB82.1
transaction. If left blank, the system
date defaults.
CBJ-POST-DATE Numeric 8 (yyyymmdd) CB185 CB30.1
Element: Post Date The date used for posting the CB80.1 CB82.1
reconciliation transactions to the
general ledger. If left blank, system
date defaults.
CBJ-REC-STATUS Numeric 1 CB30.1
Element: Reconcile StatThe record status. Valid values are:
0 = Unreleased (Unreconciled).
1 = Released (Reconciled).
CBJ-JRNL-BOOK-NBR Alpha 12 CB185 CB80.1
Element: Journal Book NThe journal book associated with the CB82.1
transaction reconciliation adjustment.
CBJ-RECON-STMT-NBR Numeric 12 CB185 CB80.1
Reconcile Statement The reconciliation statement number CB82.1
Number associated with the reconciliation
adjustment. Used only for cash codes
that require reconciliation statements.
CBADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBJSET1 BANK-INST-CODE AP170 AP180
TRANS-IDENT AP181 AP190
AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
...
CBJSET2 CASH-CODE KeyChange
REC-STATUS
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
CBJSET3 CASH-CODE KeyChange CB185 CB195
BANK-INST-CODE CB30.1 CB80.1
TRANS-NBR CB82.1 CB99.1
SUFFIX
TRANS-IDENT
CBADJUST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Adjust Distrib CBDISTRIB
CBJ-CASH-CODE -> CBD-CASH-CODE
CBJ-BANK-INST-CODE -> CBD-BANK-INST-CODE
CBJ-TRANS-IDENT -> CBD-TRANS-IDENT
"R" -> CBD-DIST-TYPE
CBD-SEQ-NBR
|
