CBADJUST

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


UPDATED BY
CB185 CB30.1 CB300 CB80.1 CB82.1 CB195
CB99.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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBJSET1 BANK-INST-CODE
TRANS-IDENT
...
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB300 CB46.1
CB500 CB543
CB544 CB80.1
CBJSET2 CASH-CODE
REC-STATUS
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
CBJSET3 CASH-CODE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange
CB185 CB195
CB30.1 CB80.1
CB82.1 CB99.1
CBJSET4 CASH-CODE
BANK-INST-CODE
TRANS-NBR
SUFFIX
TRANS-IDENT
KeyChange, Subset
WhereREC-STATUS =Zeroes
CB30.1


CBADJUST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:48:20 2016

Home
Contact Us



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