CBPMTLOAD – Cash Payment Conversion/Import

System: Cash Ledger (CB)
Prefix: CLO
Primary key: RUN-GROUP, CASH-CODE, BANK-INST-CODE, REFERENCE-NO, SEQ-NBR
Fields: 64
Updated by: 2 programs
Referenced by: 0 programs

CBPMTLOAD is the Cash Payment Conversion/Import table in Lawson Cash Ledger (prefix CLO). It is indexed by RUN-GROUP, CASH-CODE, BANK-INST-CODE, REFERENCE-NO, SEQ-NBR (CLOSET1). It is updated by CB54.1 and CB554. The table has 64 fields, 1 index and 0 documented relations.

About CBPMTLOAD

No description in the Lawson data dictionary.

Fields (64)

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

Field / column	Type	Description & values	Updated by
`CLO-RUN-GROUP` PK RUN_GROUP	Alpha 15	Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.	CB54.1
`CLO-CASH-CODE` PK CASH_CODE	Alpha 4	A 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.	CB54.1
`CLO-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	CB54.1
`CLO-REFERENCE-NO` PK REFERENCE_NO	Alpha 10 (Lower Case)	The reference number associated with the transaction.	CB54.1
`CLO-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	CB54.1
`CLO-COMPANY` COMPANY	Numeric 4	Identifies 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.	CB54.1, CB554
`CLO-REC-STATUS` REC_STATUS	Numeric 1	The record status. `0` Unreleased `1` Released	CB54.1
`CLO-VENDOR` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	CB54.1, CB554
`CLO-TRANS-DATE` TRANS_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB54.1
`CLO-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	CB54.1, CB554
`CLO-PROC-GRP` PROC_GRP	Alpha 4 (Lower Case)	A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.	CB54.1, CB554
`CLO-PAY-GROUP` PAY_GROUP	Alpha 4	A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.	CB54.1, CB554
`CLO-OVERRIDE-COMP` OVERRIDE_COMP	Numeric 4	Identifies 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.	CB54.1, CB554
`CLO-PAYEE-NAME` PAYEE_NAME	Alpha 80 (Lower Case)	Institution's legal name used on the GM269 and GM272 reports.	CB54.1
`CLO-PAYEE-ADDR1` PAYEE_ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB54.1
`CLO-PAYEE-ADDR2` PAYEE_ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB54.1
`CLO-PAYEE-ADDR3` PAYEE_ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB54.1
`CLO-PAYEE-ADDR4` PAYEE_ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB54.1
`CLO-PAYEE-ADDR5` PAYEE_ADDR5	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB54.1
`CLO-PAYEE-ST-PROV` PAYEE_ST_PROV	Alpha 2	The state or province.	CB54.1
`CLO-PAY-POSTAL-CD` PAY_POSTAL_CD	Alpha 10 (Lower Case)	This field contains the postal code.	CB54.1
`CLO-PAY-COUNTY` PAY_COUNTY	Alpha 25 (Lower Case)	The county for the company address.	CB54.1
`CLO-PAY-CTRY-CODE` PAY_CTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	CB54.1
`CLO-VBANK-IDENT` VBANK_IDENT	Alpha 1	" " = Standard Account Number `Y` IBAN Account Number	CB54.1
`CLO-BANK-ACCT` BANK_ACCT	Alpha 35	The bank-assigned account number identification to be used for the cash code.	CB54.1
`CLO-BANK-ENTITY` BANK_ENTITY	Alpha 15	Represents a bank institution location.	CB54.1
`CLO-ACH-PRENOTE` ACH_PRENOTE	Alpha 1	— `N` Not Prenotified `A` Accepted	CB54.1, CB554
`CLO-VBANK-ACCT-TP` VBANK_ACCT_TP	Alpha 1	— `C` Current/Checking `S` Savings	CB54.1, CB554
`CLO-BUILD-SOC-REF` BUILD_SOC_REF	Alpha 18	This field holds an individual account number reference for the Building Society	CB54.1
`CLO-BUILD-ACCT-NM` BUILD_ACCT_NM	Alpha 18	—	CB54.1
`CLO-CROSS-IDENT` CROSS_IDENT	Alpha 1	This field is used to distinguish between SWIFT ID numbers and Routing numbers. `S` SWIFT `R` Routing	CB54.1
`CLO-SWIFT-ID` SWIFT_ID	Alpha 12	—	CB54.1
`CLO-PMT-CAT-CODE` PMT_CAT_CODE	Alpha 6	—	CB54.1
`CLO-NORM-EXP-CODE` NORM_EXP_CODE	Alpha 1	— `N` Normal `E` Express	CB54.1
`CLO-PMT-FORM` PMT_FORM	Alpha 2	—	CB54.1
`CLO-CHARGE-CODE` CHARGE_CODE	Alpha 1	—	CB54.1
`CLO-COMMENT1` COMMENT1	Alpha 60 (Lower Case)	The text associated with the sequence number.	CB54.1
`CLO-COMMENT2` COMMENT2	Alpha 60 (Lower Case)	The text associated with the sequence number.	CB54.1
`CLO-COMMENT3` COMMENT3	Alpha 60 (Lower Case)	The text associated with the sequence number.	CB54.1
`CLO-USER-FIELD1` USER_FIELD1	Alpha 20	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.	CB54.1
`CLO-USER-FIELD2` USER_FIELD2	Alpha 20	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.	CB54.1
`CLO-USER-FIELD3` USER_FIELD3	Alpha 20	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.	CB54.1
`CLO-USER-FIELD4` USER_FIELD4	Alpha 20	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.	CB54.1
`CLO-DIS-COMPANY` DIS_COMPANY	Numeric 4	Identifies 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.	CB54.1, CB554
`CLO-ACCT-UNIT` ACCT_UNIT	Alpha 15	The 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.	CB54.1, CB554
`CLO-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	CB54.1, CB554
`CLO-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	CB54.1, CB554
`CLO-DIST-AMOUNT` DIST_AMOUNT	Signed 18.2	—	CB54.1, CB554
`CLO-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	CB54.1
`CLO-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	CB54.1
`CLO-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account 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 thru	CB54.1, CB554
`CLO-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.	CB54.1, CB554
`CLO-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	CB54.1
`CLO-TRAN-TAXABLE` TRAN_TAXABLE	Signed 18.2	—	CB54.1
`CLO-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	CB54.1, CB554
`CLO-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	Language Code (LOCALE).	CB54.1
`CLO-PROC-LEVEL` PROC_LEVEL	Alpha 5	—	CB54.1
`CLO-INCOME-CODE` INCOME_CODE	Alpha 4	—	CB54.1
`CLO-TAX-ID` TAX_ID	Alpha 20	—	CB54.1
`CLO-REPORT-INC-AMT` REPORT_INC_AMT	Signed 18.2	—	CB54.1
`CLO-TIN-TYPE` TIN_TYPE	Numeric 1	—	CB54.1
`CLO-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	CB54.1
`CLO-PAY-TAX-EXEMPT` PAY_TAX_EXEMPT	Alpha 1	—	—
`CLO-BANK-CURRENCY` BANK_CURRENCY	Alpha 5	—	CB54.1

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
`CLOSET1`	`RUN-GROUP`, `CASH-CODE`, `BANK-INST-CODE`, `REFERENCE-NO`, `SEQ-NBR`	Primary		CB54.1, CB554

Programs

Updated by (2)

CB54.1 Payment Load Maintenance
CB554 Payment Load