CBRECPTDTL – Cash Receipt Detail

System: Cash Ledger (CB)
Prefix: CBA
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR
Fields: 23
Updated by: 5 programs
Referenced by: 3 programs

CBRECPTDTL is the Cash Receipt Detail table in Lawson Cash Ledger (prefix CBA). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR (CBASET1). It is related 1:1 to CBBANKINST, CBCASHCODE, CBCATEGORY, CBRECPTHDR, GLADDRESS, GLSYSTEM and POREBDIST. It is updated by CB10.1, CB10.3, CB10.5, CB300 and CB543 and referenced by CB150, CB195 and CB210. The table has 23 fields, 1 index and 9 documented relations.

About CBRECPTDTL

The Cash Receipt Detail file contains all itemized entries for a cash receipt deposit.

Fields (23)

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

Field / column	Type	Description & values	Updated by
`CBA-CASH-CODE` PK CASH_CODE	Alpha 4	The cash code. Represents the bank account you are depositing cash receipt funds to. Must be a valid record in the Cash Code file.	CB10.3, CB10.5, CB543
`CBA-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	The bank service transaction code. Represents a deposit for the cash code. Must be a valid bank service type transaction code record in the Bank Transaction Code file.	CB10.3, CB10.5, CB543
`CBA-TRANS-NBR` PK TRANS_NBR	Alpha 10 (Right Justified)	A unique number assigned to the deposit.	CB10.3, CB10.5, CB543
`CBA-SEQ-NBR` PK SEQ_NBR	Numeric 4	The sequence number assigned to cash receipt distribution.	CB10.3, CB10.5, CB543
`CBA-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	The cash receipt category. Used to default a general ledger account and optional tax code to the cash receipt distribution. Must be a valid record in the Cash Receipt Category file.	CB10.3, CB10.5, CB543
`CBA-RECEIPT-AMOUNT` RECEIPT_AMOUNT	Signed 18.2	The total receipt amount (distribution amount) including tax for the category in the currency of the bank account.	CB10.3, CB10.5, CB543
`CBA-BASE-RECPT-AMT` BASE_RECPT_AMT	Signed 18.2	The total receipt amount (distribution amount) including tax for the category in the company base currency.	CB10.3, CB10.5, CB543
`CBA-TO-RCPT-AMT` TO_RCPT_AMT	Signed 18.2	The total receipt amount (distribution amount) including tax for the category in the distribution company base currency.	CB10.3, CB10.5, CB543
`CBA-TAX-CODE` TAX_CODE	Alpha 10	The tax code to be applied to the cash receipt category distribution. Used to calculate tax information for the distribution. Must be a valid record in the Tax Code file. If left blank, the tax code assigned to the category, if assigned, defaults.	CB10.3, CB10.5, CB543
`CBA-RCPT-COMPANY` RCPT_COMPANY	Numeric 4	The company the cash receipt distribution should be posted to. Must be a valid record in the General Ledger Company file and a valid relationship must exist in the Intercompany Relationship file. If left blank, the Company assigned to the cash receipt defaults.	CB10.3, CB10.5, CB543
`CBA-RCPT-ACCT-UNIT` RCPT_ACCT_UNIT	Alpha 15	The general ledger accounting unit for the cash receipt distribution. Must be a valid record in the General Ledger Names file.	CB10.3, CB10.5, CB543
`CBA-RCPT-ACCOUNT` RCPT_ACCOUNT	Numeric 6	The general ledger account number for the cash receipt distribution. Must be a valid record in the General Ledger Account Master file.	CB10.3, CB10.5, CB543
`CBA-RCPT-SUB-ACCT` RCPT_SUB_ACCT	Numeric 4	The general ledger subaccount number for the cash receipt distribution. Must be a valid record in the General Ledger Account Master file.	CB10.3, CB10.5, CB543
`CBA-TAXABLE-AMT` TAXABLE_AMT	Signed 18.2	The taxable amount of the cash receipt distribution in the currency of the bank account.	CB10.3, CB10.5, CB543
`CBA-BASE-TXBL-AMT` BASE_TXBL_AMT	Signed 18.2	The taxable amount of the cash receipt distribution in the company base currency.	CB10.3, CB10.5, CB543
`CBA-TO-TXBL-AMT` TO_TXBL_AMT	Signed 18.2	The taxable amount of the cash receipt distribution in the distribution company base currency.	CB10.3, CB10.5, CB543
`CBA-TAX-AMOUNT` TAX_AMOUNT	Signed 18.2	The amount of tax for the cash receipt distribution in the currency of the bank account.	CB10.3, CB10.5, CB543
`CBA-BASE-TAX-AMT` BASE_TAX_AMT	Signed 18.2	The amount of tax for the cash receipt distribution in the company base currency.	CB10.3, CB10.5, CB543
`CBA-TO-TAX-AMT` TO_TAX_AMT	Signed 18.2	The amount of tax for the cash receipt distribution in the distribution company base currency.	CB10.3, CB10.5, CB543
`CBA-TAX-RATE` TAX_RATE	Percent 7.5 (Percent)	The tax rate defined for the tax code.	CB10.3, CB10.5, CB543
`CBA-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the cash receipt distribution. Must be a valid record in the Activity file. If left blank, the activity assigned to the cash receipt header or the category, if assigned, defaults. 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.	CB10.3, CB10.5, CB543
`CBA-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the cash receipt distribution. Must be a valid record in the Activity Account Category file. If left blank, the account category assigned to the cash receipt header or the category, if assigned, defaults. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting.	CB10.3, CB10.5, CB543
`CBA-SEGMENT-BLOCK` SEGMENT_BLOCK	Alpha 103	This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	CB10.3, CB10.5, CB543

Indexes (1)

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
`CBASET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `SEQ-NBR`	Primary		CB10.1, CB10.3, CB10.5, CB150, CB195, CB210, CB300, CB543

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Field map
Cbbankinst	CBBANKINST	Required	`CBA-BANK-INST-CODE` → `CBI-BANK-INST-CODE`
Cbcashcode	CBCASHCODE	Required	`CBA-CASH-CODE` → `CBC-CASH-CODE`
Cbcategory	CBCATEGORY	Required	`CBP-COMPANY` → `CBG-COMPANY`, `CBP-PROC-LEVEL` → `CBG-PROC-LEVEL`, `CBA-PROD-TAX-CAT` → `CBG-PROD-TAX-CAT`
Cbrecpthdr	CBRECPTHDR	Required	`CBA-CASH-CODE` → `CBP-CASH-CODE`, `CBA-BANK-INST-CODE` → `CBP-BANK-INST-CODE`, `CBA-TRANS-NBR` → `CBP-TRANS-NBR`
Gladdress Dtl	GLADDRESS	Required	`CBA-RCPT-COMPANY` → `GAD-COMPANY`, `Spaces` → `GAD-ACCT-UNIT`
Gladdress Hdr	GLADDRESS	Required	`CBA-RCPT-COMPANY` → `GAD-COMPANY`, `Spaces` → `GAD-ACCT-UNIT`
Glsystem Dtl	GLSYSTEM	Required	`CBA-RCPT-COMPANY` → `GLS-COMPANY`
Glsystem Hdr	GLSYSTEM	Required	`CBP-COMPANY` → `GLS-COMPANY`
Porebdist	POREBDIST	Required	`CBA-CASH-CODE` → `RDS-CB-CASH-CODE`, `CBA-BANK-INST-CODE` → `RDS-CB-BANK-INST`, `CBA-TRANS-NBR` → `RDS-CB-TRANS-NBR`, `CBA-SEQ-NBR` → `RDS-DIST-SEQ-NBR`

Programs

Updated by (5)

CB10.1 Cash Receipt Deposit
CB10.3 Cash Receipt Entry
CB10.5 Cash Receipt Detail Rebate Option
CB300 History Purge
CB543 Receipts Load

Referenced by (3)

CB150 Mass Release
CB195 Company Period Close
CB210 Cash Receipt Deposit Listing