CBRECLOAD – Cash Receipt Conversion/Import

System
Cash Ledger (CB)
Prefix
CRC
Primary key
RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR
Fields
41
Updated by
2 programs
Referenced by
0 programs

CBRECLOAD is the Cash Receipt Conversion/Import table in Lawson Cash Ledger (prefix CRC). It is indexed by RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR (CRCSET1). It is updated by CB43.1 and CB543. The table has 41 fields, 1 index and 0 documented relations.

About CBRECLOAD

No description in the Lawson data dictionary.

Fields (41)

Column = COBOL field name without the CRC- 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
#CRC-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.CB43.1
#CRC-CASH-CODE PK
CASH_CODE		Alpha 4A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.CB43.1
#CRC-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.CB43.1
#CRC-TRANS-NBR PK
TRANS_NBR		Alpha 10 (Right Justified)A unique, user-defined value used to identify the transaction.CB43.1, CB543
#CRC-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.CB43.1
#CRC-TRANS-TYPE
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.
  • 1 Wire
  • 2 Credit Card
  • 3 Lockbox
  • 4 EFT Extract
CB43.1, CB543
#CRC-REC-STATUS
REC_STATUS		Numeric 1The record status.
  • 0 Unreleased
  • 1 Released
CB43.1
#CRC-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.CB43.1
#CRC-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.CB43.1
#CRC-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.CB43.1, CB543
#CRC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.CB43.1, CB543
#CRC-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.CB43.1
#CRC-ACH-PRENOTE
ACH_PRENOTE		Alpha 1—
  • N Not Prenotified
  • A Accepted
CB43.1, CB543
#CRC-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.CB43.1
#CRC-RECON-STMT-NBR
RECON_STMT_NBR		Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB43.1
#CRC-CUST-NAME
CUST_NAME		Alpha 30—CB43.1
#CRC-CUST-BANK
CUST_BANK		Alpha 15Represents a bank institution location.CB43.1
#CRC-CUST-ACCOUNT
CUST_ACCOUNT		Alpha 35The bank-assigned account number identification to be used for the cash code.CB43.1
#CRC-VBANK-IDENT
VBANK_IDENT		Alpha 1" " = Standard Account Number
  • Y IBAN Account Number
CB43.1
#CRC-USER-FIELD1
USER_FIELD1		Alpha 30This 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.CB43.1
#CRC-USER-FIELD2
USER_FIELD2		Alpha 30This 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.CB43.1
#CRC-USER-FIELD3
USER_FIELD3		Alpha 30This 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.CB43.1
#CRC-USER-FIELD4
USER_FIELD4		Alpha 30This 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.CB43.1
#CRC-RCPT-COMPANY
RCPT_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.CB43.1, CB543
#CRC-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15A classification of items for determining taxes using the VERTEX system in Lawson Order Entry system or the cash receipts programs in the Lawson Cash Ledger system.CB43.1
#CRC-RCPT-ACCT-UNIT
RCPT_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.CB43.1, CB543
#CRC-RCPT-ACCOUNT
RCPT_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.CB43.1, CB543
#CRC-RCPT-SUB-ACCT
RCPT_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.CB43.1, CB543
#CRC-RECEIPT-AMOUNT
RECEIPT_AMOUNT		Signed 18.2—CB43.1, CB543
#CRC-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.CB43.1, CB543
#CRC-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2—CB43.1, CB543
#CRC-TAX-AMOUNT
TAX_AMOUNT		Signed 18.2—CB43.1, CB543
#CRC-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.CB43.1, CB543
#CRC-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruCB43.1, CB543
#CRC-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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.CB43.1, CB543
#CRC-SOURCE-CODE
SOURCE_CODE		Alpha 2A two character code assigned to a transaction to identify where the transaction was created.CB43.1, CB543
#CRC-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4—CB43.1
#CRC-CM-CONTRACT
CM_CONTRACT		Numeric 15—CB43.1
#CRC-REBATE-TYPE
REBATE_TYPE		Alpha 25—CB43.1
#CRC-REBATE-DUE-DTE
REBATE_DUE_DTE		Numeric 8 (yyyymmdd)—CB43.1
#CRC-PAYMENT-NBR
PAYMENT_NBR		Alpha 10 (Right Justified)——

Indexes (1)

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
CRCSET1
  1. RUN-GROUP
  2. CASH-CODE
  3. BANK-INST-CODE
  4. TRANS-NBR
  5. SEQ-NBR
PrimaryCB43.1, CB543

Programs

Updated by (2)