|
|
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 AR34.1 AR570
AR575 AR580 AR82.1 CB06.2 CB10.1 CB15.1
CB15.2 CB180 CB190 CB191 CB20.1 CB25.1
CB500 DT180 DT181 DT185 DT92.1 CB195
CB99.1
UPDATED BY
CB185 CB30.1 CB300 CB80.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
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
unique value used to identify the
transaction.
CBJ-SUFFIX Numeric 3 CB185 CB80.1
Element: Transaction SuThe transaction suffix number.
Represents the occurrence value of the
transaction.
CBJ-BANK-INST-CODE Alpha 3 CB185 CB80.1
Element: Transaction CoThe 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
Element: Transaction IDA unique system-generated
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
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
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
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
Issued Amount the company base currency.
CBJ-RECON-BASE-AMT Signed 18.2 CB185 CB80.1
Base Currency The reconciled amount of the
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
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
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
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
transaction reconciliation adjustment.
CBJ-RECON-STMT-NBR Numeric 12 CB185 CB80.1
Reconcile Statement The reconciliation statement number
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
AR34.1 AR570
AR575 AR580
AR82.1 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
CB191 CB20.1
...
CBJSET2 CASH-CODE This index is used to access
REC-STATUS reconciliation variance adjustment
BANK-INST-CODErecords by status.
TRANS-NBR KeyChange
SUFFIX
TRANS-IDENT
CBJSET3 CASH-CODE This index is used to find a CB185 CB195
BANK-INST-CODEreconciliation variance adjustment CB30.1 CB80.1
TRANS-NBR record for a specific bank transaction. CB99.1
SUFFIX KeyChange
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
|
