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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CBD-CASH-CODE PK
CASH_CODE		Alpha 4The 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 3The 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 10A 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 SET2
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 3The 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 2Identifies 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 SET4
COMPANY		Numeric 4The 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 4Contains a system-assigned sequence number.AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
#CBD-DIST-COMPANY SET2
DIST_COMPANY		Numeric 4The 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 1The 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 1Identifies 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 SET4
REC_STATUS		Numeric 1The 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 SET2
DIS_ACCT_UNIT		Alpha 15The 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 SET2
DIS_ACCOUNT		Numeric 6The 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 SET2
DIS_SUB_ACCT		Numeric 4The 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.7The 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.2The 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.2The 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.2The 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.2The 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 15The 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 10The 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.2The 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 1If 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 1The 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 1The 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 1The 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 1The 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 SET2
GLT_OBJ_ID		Numeric 12This 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 SET3
ACT_OBJ_ID		Numeric 12This 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 5The 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 32Currently not in use.CB145, CB20.1, CB20.6, CB30.1
#CBD-RECON-STMT-NBR
RECON_STMT_NBR		Numeric 12The 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CBDSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
  4. DIST-TYPE
  5. SEQ-NBR
PrimaryAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBDSET2
  1. DIST-COMPANY
  2. DIS-ACCT-UNIT
  3. DIS-ACCOUNT
  4. DIS-SUB-ACCT
  5. GLT-OBJ-ID
  6. CASH-CODE
  7. TRANS-NBR
  8. BANK-INST-CODE
  9. DIST-TYPE
  10. SEQ-NBR
  11. TRANS-IDENT
KeyChangeCB55.1
CBDSET3
  1. ACT-OBJ-ID
  2. CASH-CODE
  3. BANK-INST-CODE
  4. TRANS-IDENT
  5. DIST-TYPE
  6. SEQ-NBR
KeyChange, SubsetWhere ACT-OBJ-ID != Zeroes—
CBDSET4
  1. COMPANY
  2. REC-STATUS
  3. CASH-CODE
  4. BANK-INST-CODE
  5. TRANS-IDENT
  6. DIST-TYPE
  7. SEQ-NBR
KeyChangeCB150, CB175, CB180, CB191, CB195, CB20.1, CB30.1, CB45.1 +1 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBBANKENTCBCASHCODECBSEGBLOCKCBSTATEMNTCBTRANSGLMASTERGLNAMESGLSYSTEMCBSTMTDTLCBDISTRIB

One to one (9) — lookups and parents

RelationTableRulesConditionField map
CbbankentCBBANKENTRequired
CBC-BANK-ENTITY→CBE-BANK-ENTITY
CbcashcodeCBCASHCODERequired
CBD-CASH-CODE→CBC-CASH-CODE
CbsegblockCBSEGBLOCKRequired
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
CbstatemntCBSTATEMNTNot RequiredValid When CBD-RECON-STMT-NBR != Zeroes
CBD-CASH-CODE→CSM-CASH-CODE
CBD-RECON-STMT-NBR→CSM-RECON-STMT-NBR
CbtransCBTRANSRequired
CBD-BANK-INST-CODE→CBT-BANK-INST-CODE
CBD-TRANS-IDENT→CBT-TRANS-IDENT
GlmasterGLMASTERRequired
CBD-DIST-COMPANY→GLM-COMPANY
CBD-DIS-ACCT-UNIT→GLM-ACCT-UNIT
CBD-DIS-ACCOUNT→GLM-ACCOUNT
CBD-DIS-SUB-ACCT→GLM-SUB-ACCOUNT
GlnamesGLNAMESRequired
CBD-DIST-COMPANY→GLN-COMPANY
CBD-DIS-ACCT-UNIT→GLN-ACCT-UNIT
GlsystemGLSYSTEMRequired
CBD-DIST-COMPANY→GLS-COMPANY
Glsystem OrigGLSYSTEMRequired
CBD-COMPANY→GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
CbstmtdtlCBSTMTDTL
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)

Referenced by (5)