CBRECPTHDR – Cash Receipt Deposit

System: Cash Ledger (CB)
Prefix: CBP
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-NBR
Fields: 30
Updated by: 7 programs
Referenced by: 96 programs

CBRECPTHDR is the Cash Receipt Deposit table in Lawson Cash Ledger (prefix CBP). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-NBR (CBPSET1); alternate indexes: CBPSET2. It is related 1:1 to CBBANKENT, CBBANKINST, CBCASHCODE, CBCPYCASH and CBRCHDBOD and 1:M to CBRECPTDTL. It is updated by CB10.1, CB10.3, CB10.5, CB150, CB180, CB300 and CB543 and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 88 more. The table has 30 fields, 2 indexes and 6 documented relations.

About CBRECPTHDR

The Cash Receipt file contains cash receipt deposit header records.

Fields (30)

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

Field / column	Type	Description & values	Updated by
`CBP-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.1, CB543
`CBP-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.1, CB543
`CBP-TRANS-NBR` PK TRANS_NBR	Alpha 10 (Right Justified)	A unique number assigned to the deposit.	CB10.1, CB543
`CBP-TRANS-TYPE` TRANS_TYPE	Alpha 1	Determines if amounts or units are processed in each transaction. " " = Manual `1` Wire `3` Lockbox	CB10.1, CB543
`CBP-USER-FIELD1` USER_FIELD1	Alpha 30	This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.	CB10.1, CB543
`CBP-USER-FIELD2` USER_FIELD2	Alpha 30	This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.	CB10.1, CB543
`CBP-USER-FIELD3` USER_FIELD3	Alpha 30	This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.	CB10.1, CB543
`CBP-USER-FIELD4` USER_FIELD4	Alpha 30	This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.	CB10.1, CB543
`CBP-DEPOSIT-AMOUNT` DEPOSIT_AMOUNT	Signed 18.2	The amount of the deposit in the currency of the bank account.	CB10.1, CB543
`CBP-BASE-AMOUNT` BASE_AMOUNT	Signed 18.2	The amount of the deposit in the company base currency.	CB10.1, CB543
`CBP-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal places defined for the currency of the bank account.	CB10.1, CB543
`CBP-BASE-ND` BASE_ND	Numeric 1	The number of decimal places defined for the company base currency.	CB10.1, CB543
`CBP-COMPANY` COMPANY	Numeric 4	The company number associated with the deposit. Must be a valid record in the General Ledger Company file and a valid relationship record in the Company-Cash Code Relationship file.	CB10.1, CB543
`CBP-PROC-LEVEL` PROC_LEVEL	Alpha 5	If using cash receipt process levels, this field contains the process level associated with the cash receipt deposit. Must be a valid record in the Cash Receipt Process Level file.	CB10.1, CB543
`CBP-DEPOSIT-DATE` DEPOSIT_DATE	Numeric 8 (yyyymmdd)	The date the funds will be deposited. If left blank, the system date defaults.	CB10.1, CB543
`CBP-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	The date used for posting the cash receipt deposit to the general ledger. If left blank, the Deposit Date defaults.	CB10.1, CB543
`CBP-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	The bank account currency defined for the cash code.	CB10.1, CB543
`CBP-EXCHANGE-RATE` EXCHANGE_RATE	Signed 14.7	The currency exchange rate used to convert the bank account currency deposit amount to the company base currency.	CB10.1, CB543
`CBP-DEP-APPL-AMT` DEP_APPL_AMT	Signed 18.2	The total cash receipt distribution amount in the currency of the bank account.	CB10.3, CB10.5, CB543
`CBP-BASE-APPL-AMT` BASE_APPL_AMT	Signed 18.2	The total cash receipt distribution amount in the company base currency.	CB10.3, CB10.5, CB543
`CBP-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the cash receipt deposit.	CB10.1, CB543
`CBP-LAST-DIST-SEQ` LAST_DIST_SEQ	Numeric 4	The last system-assigned sequence number assigned to distributions for the cash receipt deposit.	CB10.3, CB10.5, CB180, CB543
`CBP-REC-STATUS` REC_STATUS	Numeric 1	The status of the cash receipt deposit. Valid values are: `0` Unreleased. `1` Released.	CB10.1, CB150, CB543
`CBP-ACTIVITY` ACTIVITY	Alpha 15	The activity assigned to the cash receipt deposit. Must be a valid record in the Activity 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. The Activity Management system stores information such as responsibility and schedule for each activity. The breakdown of activity costs and revenues is defined by account categories. An activity must belong to an activity group.	CB10.1
`CBP-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The account category assigned to the cash receipt header. 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. Set up account categories for an activity before you do any budgeting or transaction processing. Using account categories, you can sort and combine incoming amounts into groups for reporting and inquiry on activities.	CB10.1
`CBP-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the cash receipt deposit. Must be a valid record in the Journal Book Header file.	CB10.1, CB543
`CBP-RECON-STMT-NBR` RECON_STMT_NBR	Numeric 12	The reconciliation statement number assigned to the cash receipt deposit. Used only for cash codes that require reconciliation statements.	CB10.1, CB543
`CBP-JBK-SEQ-NBR` JBK_SEQ_NBR	Numeric 10	The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).	CB10.1, CB543
`CBP-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.1
`CBP-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	CB10.1, CB543

Indexes (2)

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
`CBPSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`	Primary		AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
`CBPSET2`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`	Subset	Where REC-STATUS = Zeroes	CB195, CB221

Relations

One to one (5) — lookups and parents

Relation	Table	Rules	Field map
Cbbankent	CBBANKENT	Required	`CBC-BANK-ENTITY` → `CBE-BANK-ENTITY`
Cbbankinst	CBBANKINST	Required	`CBP-BANK-INST-CODE` → `CBI-BANK-INST-CODE`
Cbcashcode	CBCASHCODE	Required	`CBP-CASH-CODE` → `CBC-CASH-CODE`
Cbcpycash	CBCPYCASH	Required	`CBP-COMPANY` → `CBY-COMPANY`, `CBP-CASH-CODE` → `CBY-CASH-CODE`
Cbrchdbod	CBRCHDBOD	Not Required, Delete Cascades	`CBP-CASH-CODE` → `YBJ-CASH-CODE`, `CBP-BANK-INST-CODE` → `YBJ-BANK-INST-CODE`, `CBP-TRANS-NBR` → `YBJ-TRANS-NBR`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Cbrecptdtl	CBRECPTDTL			`CBP-CASH-CODE` → `CBA-CASH-CODE`, `CBP-BANK-INST-CODE` → `CBA-BANK-INST-CODE`, `CBP-TRANS-NBR` → `CBA-TRANS-NBR`, → `CBA-SEQ-NBR`

Programs

Updated by (7)

CB10.1 Cash Receipt Deposit
CB10.3 Cash Receipt Entry
CB10.5 Cash Receipt Detail Rebate Option
CB150 Mass Release
CB180 Cash Ledger Void Update
CB300 History Purge
CB543 Receipts Load

Referenced by (96)

AP10.1 Vendor
AP10.2 Vendor Location
AP100 Vendor Group Copy
AP109 Vendor Current Address Update
AP110 Mass Vendor Update
AP111 Vendor Deletion
AP115 Vendor Merge
AP125 Batch Release
AP126 Mass Invoice Release
AP14.1 Vendor Contact
AP14.2 Vendor Contact Address
AP14.5 1099 Tax Identification Information
AP150 Cash Requirements
AP151 Bill of Exchange Generation
AP16.1 Vendor Bank
AP16.2 Vendor Location Bank
AP160 Payment Tape Creation
AP161 Electronic Payment File Creation
AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP193 Recurring Invoice Update
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.6 Prepayment
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP28.1 Bill of Exchange Acceptance by Vendor
AP28.2 Bill of Exchange Acceptance by Date
AP30.1 Invoice Maintenance
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
AP300 Invoice and Vendor History Purge
AP305 Accounts Payable Company Purge
AP510 Vendor Conversion
AP520 Invoice Interface
AP590 AP Vendor CSV
API1.1 Add Invoice
API2.1 Add Invoice
CB00.1 Bank
CB06.2 Bank Statement Detail Entry
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB195 Company Period Close
CB20.1 Bank Transaction Entry
CB210 Cash Receipt Deposit Listing
CB221 Bank Transaction Listing
CB43.1 Receipts Load Maintenance
CB44.1 Returned Payment Maintenance
CB544 Returned Payment Load
EE135 Mass Employee Release
EE20.1 Employee Advance
EE20.2 Employee Expense
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface
IC64.6 Global Location Number Assignment Vendor
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.1 Memo Line Detail - Purchase Order
MA42.2 Memo Line AOC Detail
MA43.1 Invoice Line Detail - Purchase Order
MA43.2 Purchase Order Lookup
MA43.3 Invoice Line Detail - Receipt
MA43.4 Invoice Line Detail - Service
MA43.6 Service Agreement Detail
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA60.2 Invoice Level Match
MA60.3 Detail Level Match
MA60.4 Invoice Match Reference Adjustment
MA61.1 Match Invoice Approval
MA64.6 Message Detail by Invoice
MA64.9 PO Cost Message Accept Upload
MA65.1 Invoice Line Adjustment
MA66.1 Review Invoice Message
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA67.3 Detail Match from frontend
MA68.2 Invoice Level Match - Prepaid
MA68.4 Invoice Match Reference Adjustment
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAED.1 Vendor
MAI1.1 Invoke for MAMATCH Object