CBDISTRIB – Transaction Distribution

System: Cash Ledger (CB)
Prefix: CBD
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-IDENT, DIST-TYPE, SEQ-NBR
Fields: 38
Updated by: 38 programs
Referenced by: 5 programs

CBDISTRIB is the Transaction Distribution table in Lawson Cash Ledger (prefix CBD). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-IDENT, DIST-TYPE, SEQ-NBR (CBDSET1); alternate indexes: CBDSET2, CBDSET3 and CBDSET4. It is related 1:1 to CBBANKENT, CBCASHCODE, CBSEGBLOCK, CBSTATEMNT, CBTRANS, GLMASTER, GLNAMES and GLSYSTEM and 1:M to CBSTMTDTL. It is updated by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 30 more and referenced by CB221, CB245, CB246, CB255 and CB99.1. The table has 38 fields, 4 indexes and 10 documented relations.

About CBDISTRIB

The Transaction Distribution file contains all distribution records associated with a Cash Ledger transaction.

Fields (38)

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

Field / column	Type	Description & values	Updated by
`CBD-CASH-CODE` PK CASH_CODE	Alpha 4	The cash code. Represents a bank account. Must be a valid record in the Cash Code file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	The transaction code. Represents a type of cash payment, bill of exchange payment, or bank service transaction. Must be a valid record in the Bank Transaction Code file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	A unique system-generated identification value assigned to the transaction to make this record unique.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	The unique number used to identify the transaction. Must be a valid record in the Bank Transaction file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-SUFFIX` SUFFIX	Numeric 3	The transaction suffix number. Represents the occurrence value of the transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBD-SOURCE-CODE` SOURCE_CODE	Alpha 2	Identifies where the bank transaction was created. Must be a valid source code.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-COMPANY` COMPANY	Numeric 4	The company number that initiated or created the transaction. Must be a valid record in the General Ledger Company file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-SEQ-NBR` PK SEQ_NBR	Numeric 4	Contains a system-assigned sequence number.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBD-DIST-COMPANY` DIST_COMPANY	Numeric 4	The company number the bank transaction is to be posted to. Must be a valid record in the General Ledger Company file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-DIST-TYPE` PK DIST_TYPE	Alpha 1	The distribution type. Valid values are: `E` Entry. `R` Reconciliation. `V` Cash Ledger Void Update	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-RECORD-TYPE` RECORD_TYPE	Alpha 1	Identifies the type of distribution record. Valid values are: `C` Cash Account Distribution. `E` EFT Payment distribution. `P` CB Payment distribution. `O` Offset CB payment distribution `Blank` Not a cash account distribution.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-REC-STATUS` REC_STATUS	Numeric 1	The status of the transaction distribution. Valid values are: `0` Unreleased. `1` Released. `9` Posted.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +27 more
`CBD-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	The date for using to post the transaction to the general ledger.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBD-DIS-ACCT-UNIT` DIS_ACCT_UNIT	Alpha 15	The general ledger distribution accounting unit. Must be a valid record in the General Ledger Names file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-DIS-ACCOUNT` DIS_ACCOUNT	Numeric 6	The general ledger distribution account number. Must be a valid record in the General Ledger Account Master file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-DIS-SUB-ACCT` DIS_SUB_ACCT	Numeric 4	The general ledger distribution subaccount number. Must be a valid record in the General Ledger Account Master file.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-ACT-CNV-RATE` ACT_CNV_RATE	Signed 14.7	The currency exchange rate used to convert the bank account currency distribution amount to the company base currency.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-BANK-DIST-AMT` BANK_DIST_AMT	Signed 18.2	The distribution amount in the currency of the bank account.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-ORIG-BASE-AMT` ORIG_BASE_AMT	Signed 18.2	The distribution amount in the base currency of the originating company.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-DIST-BASE-AMT` DIST_BASE_AMT	Signed 18.2	The distribution amount in the base currency of the distribution company.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TO-BNK-DST-AMT` TO_BNK_DST_AMT	Signed 18.2	The distribution amount in the currency of the to bank account.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference value assigned to the transaction distribution. Used for informational purposes.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBD-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the transaction distribution.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the bank transaction distribution. Must be a valid record in the Activity Header file. Activities are the tasks that make up an activity group. Activities identify work being done, such as work orders, phases, products, and so on. A variety of costs, revenues, or both make up an activity.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TAX-CODE` TAX_CODE	Alpha 10	The tax code to be applied to the bank transaction distribution. Must be a valid record in the Tax Code file.	CB10.1, CB145, CB150, CB180, CB20.1, CB20.6, CB30.1, CB45.1 +5 more
`CBD-TRAN-TAXABLE` TRAN_TAXABLE	Signed 18.2	The taxable amount of the bank transaction distribution in the currency of the bank account.	CB10.1, CB145, CB150, CB180, CB20.1, CB20.6, CB30.1, CB45.1 +5 more
`CBD-TAX-TYPE` TAX_TYPE	Alpha 1	If a Tax Code is present, this field indicates the type of tax. Valid values are: included in the transaction amount. `I` Invoiced. The tax amount is	CB145, CB180, CB20.1, CB20.6, CB30.1, CB45.1, CB46.1, CB500 +1 more
`CBD-TO-BASE-ND` TO_BASE_ND	Numeric 1	The number of decimal places defined for the base currency of the distribution company.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TO-TRAN-ND` TO_TRAN_ND	Numeric 1	The number of decimal places defined for the currency of the to bank account.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal places defined for the bank account currency.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-BASE-ND` BASE_ND	Numeric 1	The number of decimal places defined for the currency of the originating company.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +25 more
`CBD-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +27 more
`CBD-ACT-OBJ-ID` ACT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +27 more
`CBD-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the bank transaction distribution. Must be a valid record in the Activity Account Category file. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting.	CB10.1, CB145, CB15.1, CB15.2, CB150, CB191, CB20.1, CB20.6 +8 more
`CBD-ANALYSIS-FLD` ANALYSIS_FLD	Alpha 32	Currently not in use.	CB145, CB20.1, CB20.6, CB30.1
`CBD-RECON-STMT-NBR` RECON_STMT_NBR	Numeric 12	The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.	CB145
`CBD-TAX-AMOUNT` TAX_AMOUNT	Signed 18.2	—	—
`CBD-BASE-TAX-AMT` BASE_TAX_AMT	Signed 18.2	—	—

Indexes (4)

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

Index	Keys	Flags	Condition	Used in
`CBDSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`, `DIST-TYPE`, `SEQ-NBR`	Primary		AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
`CBDSET2`	`DIST-COMPANY`, `DIS-ACCT-UNIT`, `DIS-ACCOUNT`, `DIS-SUB-ACCT`, `GLT-OBJ-ID`, `CASH-CODE`, `TRANS-NBR`, `BANK-INST-CODE`, `DIST-TYPE`, `SEQ-NBR`, `TRANS-IDENT`	KeyChange		CB55.1
`CBDSET3`	`ACT-OBJ-ID`, `CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`, `DIST-TYPE`, `SEQ-NBR`	KeyChange, Subset	Where ACT-OBJ-ID != Zeroes	—
`CBDSET4`	`COMPANY`, `REC-STATUS`, `CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`, `DIST-TYPE`, `SEQ-NBR`	KeyChange		CB150, CB175, CB180, CB191, CB195, CB20.1, CB30.1, CB45.1 +1 more

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbbankent	CBBANKENT	Required		`CBC-BANK-ENTITY` → `CBE-BANK-ENTITY`
Cbcashcode	CBCASHCODE	Required		`CBD-CASH-CODE` → `CBC-CASH-CODE`
Cbsegblock	CBSEGBLOCK	Required		`CBD-CASH-CODE` → `CBK-CASH-CODE`, `CBD-BANK-INST-CODE` → `CBK-BANK-INST-CODE`, `CBD-TRANS-IDENT` → `CBK-TRANS-IDENT`, `CBD-DIST-TYPE` → `CBK-DIST-TYPE`, `CBD-SEQ-NBR` → `CBK-SEQ-NBR`
Cbstatemnt	CBSTATEMNT	Not Required	Valid When CBD-RECON-STMT-NBR != Zeroes	`CBD-CASH-CODE` → `CSM-CASH-CODE`, `CBD-RECON-STMT-NBR` → `CSM-RECON-STMT-NBR`
Cbtrans	CBTRANS	Required		`CBD-BANK-INST-CODE` → `CBT-BANK-INST-CODE`, `CBD-TRANS-IDENT` → `CBT-TRANS-IDENT`
Glmaster	GLMASTER	Required		`CBD-DIST-COMPANY` → `GLM-COMPANY`, `CBD-DIS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `CBD-DIS-ACCOUNT` → `GLM-ACCOUNT`, `CBD-DIS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glnames	GLNAMES	Required		`CBD-DIST-COMPANY` → `GLN-COMPANY`, `CBD-DIS-ACCT-UNIT` → `GLN-ACCT-UNIT`
Glsystem	GLSYSTEM	Required		`CBD-DIST-COMPANY` → `GLS-COMPANY`
Glsystem Orig	GLSYSTEM	Required		`CBD-COMPANY` → `GLS-COMPANY`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Cbstmtdtl	CBSTMTDTL			`CBD-BANK-INST-CODE` → `CSD-BANK-INST-CODE`, `CBD-RECON-STMT-NBR` → `CSD-RECON-STMT-NBR`, `CBD-TRANS-NBR` → `CSD-PAYMENT-NBR`, `"G"` → `CSD-TRANS-TYPE`, `CBD-CASH-CODE` → `CSD-CASH-CODE`, → `CSD-LINE-NBR`

Programs

Updated by (38)

AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP255 Bank Account Payment History
AP265 Cash Payment Register
AP81.1 Manual Forms Reservation
AP90.5 Cash Payment Inquiry
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB145 EFT Extract Update
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB150 Mass Release
CB175 Bank Transaction Posting
CB180 Cash Ledger Void Update
CB185 Bank Tape Mass Reconciliation
CB186 Stale Dating Processing
CB187 Stale Dating Reopen Update
CB190 Bank Period Close
CB191 Bank Statement Close
CB195 Company Period Close
CB20.1 Bank Transaction Entry
CB20.6 Bank Transaction DIstribution
CB25.1 Manual Reconciliation Entry
CB30.1 Reconciliation Variance Adjustment
CB300 History Purge
CB45.1 EFT/CC Extract Entry
CB46.1 Returned Payment Entry
CB500 Bank Transaction Interface
CB543 Receipts Load
CB544 Returned Payment Load
CB55.1 Payment Entry
CB554 Payment Load
CB57.1 Payment Cancel
CB80.1 Bank Transaction Adjustment
CB82.1 Statement Reconciliation
TX101 Journal File Create

Referenced by (5)

CB221 Bank Transaction Listing
CB245 EFT Extract Listing
CB246 Return Payment Listing
CB255 Payment Listing
CB99.1 Bank Account Balance Update