CBADJUST – Reconciliation Adjustment

System
Cash Ledger (CB)
Prefix
CBJ
Primary key
BANK-INST-CODE, TRANS-IDENT
Fields
18
Updated by
5 programs
Referenced by
28 programs

CBADJUST is the Reconciliation Adjustment table in Lawson Cash Ledger (prefix CBJ). It is indexed by BANK-INST-CODE, TRANS-IDENT (CBJSET1); alternate indexes: CBJSET2, CBJSET3 and CBJSET4. It is related 1:M to CBDISTRIB. It is updated by CB185, CB30.1, CB300, CB80.1 and CB82.1 and referenced by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 20 more. The table has 18 fields, 4 indexes and 1 documented relation.

About CBADJUST

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.

Fields (18)

Column = COBOL field name without the CBJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CBJ-CASH-CODE
CASH_CODE		Alpha 4The cash code. Represents a bank account. Must be a valid record in the Cash Code file.CB185, CB80.1, CB82.1
CBJ-TRANS-NBR
TRANS_NBR		Alpha 10 (Right Justified)The transaction number. Represents a unique value used to identify the transaction.CB185, CB80.1, CB82.1
CBJ-SUFFIX
SUFFIX		Numeric 3The transaction suffix number. Represents the occurrence value of the transaction.CB185, CB80.1, CB82.1
CBJ-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3The 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 PK
TRANS_IDENT		Numeric 10A unique system-generated identification value assigned to the transaction to make this record unique.CB185, CB80.1, CB82.1
CBJ-COMPANY
COMPANY		Numeric 4The 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
ISSUE_BNK_AMT		Signed 18.2The issued amount of the transaction in the currency of the bank account.CB185, CB80.1, CB82.1
CBJ-RECON-BNK-AMT
RECON_BNK_AMT		Signed 18.2The 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
ISSUE_BASE_AMT		Signed 18.2The issued amount of the transaction in the company base currency.CB185, CB80.1, CB82.1
CBJ-RECON-BASE-AMT
RECON_BASE_AMT		Signed 18.2The reconciled amount of the transaction in the company base currency.CB185, CB80.1, CB82.1
CBJ-RECON-CNV-RATE
RECON_CNV_RATE		Signed 14.7The 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
DIST_APPLIED		Signed 18.2The 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_APPLIED		Signed 18.2The amount of general ledger distributions that have been applied to the reconciliation adjustment in the company base currency.CB30.1
CBJ-RECON-DATE
RECON_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
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
REC_STATUS		Numeric 1The record status. Valid values are:
  • 0 Unreleased (Unreconciled).
  • 1 Released (Reconciled).
CB185, CB30.1
CBJ-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book associated with the transaction reconciliation adjustment.CB185, CB80.1, CB82.1
CBJ-RECON-STMT-NBR
RECON_STMT_NBR		Numeric 12The reconciliation statement number associated with the reconciliation adjustment. Used only for cash codes that require reconciliation statements.CB185, CB80.1, CB82.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CBJSET1BANK-INST-CODE, TRANS-IDENTPrimaryAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBJSET2CASH-CODE, REC-STATUS, BANK-INST-CODE, TRANS-NBR, SUFFIX, TRANS-IDENTKeyChange—
CBJSET3CASH-CODE, BANK-INST-CODE, TRANS-NBR, SUFFIX, TRANS-IDENTKeyChangeCB185, CB195, CB30.1, CB80.1, CB82.1, CB99.1
CBJSET4CASH-CODE, BANK-INST-CODE, TRANS-NBR, SUFFIX, TRANS-IDENTKeyChange, SubsetWhere REC-STATUS = ZeroesCB30.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
Adjust DistribCBDISTRIBCBJ-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

Programs

Updated by (5)

Referenced by (28)