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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#CBP-CASH-CODE PKCASH_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 PKBANK_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 PKTRANS_NBR | Alpha 10 (Right Justified) | A unique number assigned to the deposit. | CB10.1, CB543 |
#CBP-TRANS-TYPETRANS_TYPE | Alpha 1 | Determines if amounts or units are processed in each transaction. " " = Manual
| CB10.1, CB543 |
#CBP-USER-FIELD1USER_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-FIELD2USER_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-FIELD3USER_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-FIELD4USER_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-AMOUNTDEPOSIT_AMOUNT | Signed 18.2 | The amount of the deposit in the currency of the bank account. | CB10.1, CB543 |
#CBP-BASE-AMOUNTBASE_AMOUNT | Signed 18.2 | The amount of the deposit in the company base currency. | CB10.1, CB543 |
#CBP-TRAN-NDTRAN_ND | Numeric 1 | The number of decimal places defined for the currency of the bank account. | CB10.1, CB543 |
#CBP-BASE-NDBASE_ND | Numeric 1 | The number of decimal places defined for the company base currency. | CB10.1, CB543 |
#CBP-COMPANYCOMPANY | 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-LEVELPROC_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-DATEDEPOSIT_DATE | Numeric 8 (yyyymmdd) | The date the funds will be deposited. If left blank, the system date defaults. | CB10.1, CB543 |
#CBP-POST-DATEPOST_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-CODECURRENCY_CODE | Alpha 5 | The bank account currency defined for the cash code. | CB10.1, CB543 |
#CBP-EXCHANGE-RATEEXCHANGE_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-AMTDEP_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-AMTBASE_APPL_AMT | Signed 18.2 | The total cash receipt distribution amount in the company base currency. | CB10.3, CB10.5, CB543 |
#CBP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the cash receipt deposit. | CB10.1, CB543 |
#CBP-LAST-DIST-SEQLAST_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-STATUSREC_STATUS | Numeric 1 | The status of the cash receipt deposit. Valid values are:
| CB10.1, CB150, CB543 |
#CBP-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-NBRJRNL_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-NBRRECON_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-NBRJBK_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-BLOCKSEGMENT_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-CODESOURCE_CODE | Alpha 2 | A two character code assigned to a transaction to identify where the transaction was created. | CB10.1, CB543 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CBPSET1 |
| Primary | AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source) | |
CBPSET2 |
| Subset | Where REC-STATUS = Zeroes | CB195, CB221 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbbankent | CBBANKENT | Required |
| ||||||||||
| Cbbankinst | CBBANKINST | Required |
| ||||||||||
| Cbcashcode | CBCASHCODE | Required |
| ||||||||||
| Cbcpycash | CBCPYCASH | Required |
| ||||||||||
| Cbrchdbod | CBRCHDBOD | Not Required, Delete Cascades |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbrecptdtl | CBRECPTDTL |
|
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