|
|
CBADJUST FILE
Reconciliation Adjustmentment
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 AR30.2 AR30.4
AR570 AR575 AR580 AR82.1 CB06.2 CB10.1
CB15.1 CB15.2 CB180 CB190 CB191 CB20.1
CB500 DT180 DT181 DT185 DT92.1 CB99.1
UPDATED BY
CB185 CB30.1 CB300 CB733 CB80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBJ-CASH-CODE Alpha 4 CB185 CB80.1
Cash Code The cash code. Represents a bank
account. Must be a valid record in the
Cash Code file.
CBJ-TRANS-NBR Alpha 10 (Right Justified) CB185 CB80.1
Transaction Number The transaction number. Represents a
unique value used to identify the
transaction.
CBJ-SUFFIX Numeric 3 CB185 CB80.1
Transaction Suffix The transaction suffix number.
Represents the occurrence value of the
transaction.
CBJ-BANK-INST-CODE Alpha 3 CB185 CB80.1
Transaction Code The transaction code. Represents the
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
Transaction ID A unique system-generated
identification value assigned to the
transaction to make this record unique.
CBJ-COMPANY Numeric 4 CB185 CB80.1
Company The company responsible for generating
the transaction. Must be a valid record
in the General Ledger Company file.
CBJ-ISSUE-BNK-AMT Signed 15.2 CB185 CB80.1
Acct Currency The issued amount of the transaction in
Issued Amount the currency of the bank account.
CBJ-RECON-BNK-AMT Signed 15.2 CB185 CB80.1
Acct Currency The reconciled amount of the
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 15.2 CB185 CB80.1
Base Currency The issued amount of the transaction in
Issued Amount the company base currency.
CBJ-RECON-BASE-AMT Signed 15.2 CB185 CB80.1
Base Currency The reconciled amount of the
Reconciled Amt transaction in the company base
currency.
CBJ-RECON-CNV-RATE Signed 12.6 CB185 CB30.1
Reconciliation The currency exchange rate used to CB80.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 15.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 15.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
Reconcilation Date The reconciliation date of the bank CB80.1
transaction. If left blank, the system
date defaults.
CBJ-POST-DATE Numeric 8 (yyyymmdd) CB185 CB30.1
Posting Date The date used for posting the CB80.1
reconciliation transactions to the
general ledger. If left blank, system
date defaults.
CBJ-REC-STATUS Numeric 1 CB30.1
Reconciliation The record status. Valid values are:
Status
0 = Unreleased (Unreconciled).
1 = Released (Reconciled).
CBJ-JRNL-BOOK-NBR Alpha 12 CB185 CB80.1
Journal Book Number The journal book associated with the
transaction reconciliation adjustment.
CBJ-RECON-STMT-NBR Numeric 12 CB185 CB80.1
Statement Number The reconciliation statement 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-CODEThis is the primary index used to keep AP170 AP180
TRANS-IDENT reconciliation variance adjustment AP181 AP190
records unique. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
...
CBJSET2 CASH-CODE This index is used to access
REC-STATUS reconciliation variance adjustment
BANK-INST-CODErecords by status.
TRANS-NBR
SUFFIX KeyChange, Duplicates
CBJSET3 CASH-CODE This index is used to find a CB185 CB30.1
BANK-INST-CODEreconciliation variance adjustment CB80.1 CB99.1
TRANS-NBR record for a specific bank transaction.
SUFFIX
KeyChange, Duplicates
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
|