CBPAYMENT – Cash Payment

System: Cash Ledger (CB)
Prefix: CBM
Primary key: CASH-CODE, BANK-INST-CODE, TRANS-IDENT
Fields: 67
Updated by: 17 programs
Referenced by: 85 programs

CBPAYMENT is the Cash Payment table in Lawson Cash Ledger (prefix CBM). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-IDENT (CBMSET1); alternate indexes: CBMSET2, CBMSET3, CBMSET4, CBMSET5, CBMSET6 and CBMSET7. It is related 1:1 to APRPTBLINC and CBPMTBOD and 1:M to CBDISTRIB. It is updated by AP150, AP155, AP160, AP161, AP170, AP190, AP265, AP30.3 and 9 more and referenced by AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 and 77 more. The table has 67 fields, 7 indexes and 3 documented relations.

About CBPAYMENT

No description in the Lawson data dictionary.

Fields (67)

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

Field / column	Type	Description & values	Updated by
`CBM-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.	AP150, AP160, AP161, CB55.1, CB554, ZA161
`CBM-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.	AP150, AP160, AP161, CB55.1, CB554, ZA161
`CBM-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	A unique system-generated identification value assigned to the transaction to make this record unique.	AP190, CB55.1, CB554
`CBM-REFERENCE-NO` REFERENCE_NO	Alpha 10 (Lower Case)	The reference number associated with the transaction.	CB55.1, CB554
`CBM-VOID-DATE` VOID_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	AP190
`CBM-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	A unique, user-defined value used to identify the transaction.	AP155, AP160, AP161, AP190, ZA161
`CBM-CHECK-DATE` CHECK_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	AP155, AP160, AP161, AP190, ZA161
`CBM-REC-STATUS` REC_STATUS	Numeric 1	The record status. `0` Unreleased `1` Released `2` Selected for Payment `3` System Generated `4` Cancel of posted released pmt `8` Voided `9` Historical	AP150, AP155, AP160, AP161, AP170, AP190, CB150, CB55.1 +3 more
`CBM-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.	CB55.1, CB554
`CBM-VENDOR` VENDOR	Alpha 9 (Right Justified)	The vendor's identification code.	CB55.1, CB554
`CBM-BANK-CHK-AMT` BANK_CHK_AMT	Signed 18.2	—	AP150, CB55.1, CB554
`CBM-BANK-ND` BANK_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AP150, CB55.1, CB554
`CBM-BASE-PMT-AMT` BASE_PMT_AMT	Signed 18.2	—	CB55.1, CB554
`CBM-BASE-ND` BASE_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	CB55.1, CB554
`CBM-BASE-CHK-AMT` BASE_CHK_AMT	Signed 18.2	—	AP150
`CBM-EXCHANGE-RATE` EXCHANGE_RATE	Signed 14.7	The currency rate.	CB55.1, CB554
`CBM-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the bank account currency defined for the cash code.	CB55.1, CB554
`CBM-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	CB55.1, CB554
`CBM-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-PAYEE-NAME` PAYEE_NAME	Alpha 80 (Lower Case)	Institution's legal name used on the GM269 and GM272 reports.	CB55.1, CB554
`CBM-PAYEE-ADDR1` PAYEE_ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB55.1, CB554
`CBM-PAYEE-ADDR2` PAYEE_ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB55.1, CB554
`CBM-PAYEE-ADDR3` PAYEE_ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB55.1, CB554
`CBM-PAYEE-ADDR4` PAYEE_ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB55.1, CB554
`CBM-PAYEE-ADDR5` PAYEE_ADDR5	Alpha 30 (Lower Case)	This field contains the first line of address information.	CB55.1, CB554
`CBM-PAYEE-ST-PROV` PAYEE_ST_PROV	Alpha 2	The state or province.	CB55.1, CB554
`CBM-PAY-POSTAL-CD` PAY_POSTAL_CD	Alpha 10 (Lower Case)	This field contains the postal code.	CB55.1, CB554
`CBM-PAY-COUNTY` PAY_COUNTY	Alpha 25 (Lower Case)	The county for the company address.	CB55.1, CB554
`CBM-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).	CB55.1, CB554
`CBM-VBANK-IDENT` VBANK_IDENT	Alpha 1	" " = Standard Account Number `Y` IBAN Account Number	CB55.1, CB554
`CBM-BANK-ACCT` BANK_ACCT	Alpha 35	The bank-assigned account number identification to be used for the cash code.	CB55.1, CB554
`CBM-BANK-ENTITY` BANK_ENTITY	Alpha 15	Represents a bank institution location.	CB55.1, CB554
`CBM-ACH-PRENOTE` ACH_PRENOTE	Alpha 1	— `N` Not Prenotified `P` Prenotified `A` Accepted	AP160, CB150, CB55.1, CB554
`CBM-VBANK-ACCT-TP` VBANK_ACCT_TP	Alpha 1	— `C` Current/Checking `S` Savings	CB55.1, CB554
`CBM-BUILD-SOC-REF` BUILD_SOC_REF	Alpha 18	This field holds an individual account number reference for the Building Society	CB55.1, CB554
`CBM-BUILD-ACCT-NM` BUILD_ACCT_NM	Alpha 18	—	CB55.1, CB554
`CBM-CROSS-IDENT` CROSS_IDENT	Alpha 1	This field is used to distinguish between SWIFT ID numbers and Routing numbers. `S` SWIFT `R` Routing	CB55.1, CB554
`CBM-SWIFT-ID` SWIFT_ID	Alpha 12	—	CB55.1, CB554
`CBM-PMT-CAT-CODE` PMT_CAT_CODE	Alpha 6	—	CB55.1, CB554
`CBM-NORM-EXP-CODE` NORM_EXP_CODE	Alpha 1	— `N` Normal `E` Express	CB55.1, CB554
`CBM-PMT-FORM` PMT_FORM	Alpha 2	—	CB55.1, CB554
`CBM-CHARGE-CODE` CHARGE_CODE	Alpha 1	—	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-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.	CB55.1, CB554
`CBM-LANGUAGE-CODE` LANGUAGE_CODE	Alpha 10	Language Code (LOCALE).	CB55.1, CB554
`CBM-TAX-FLAG` TAX_FLAG	Alpha 1	" " = Not Interfaced `I` Interfaced	CB554
`CBM-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	CB55.1, CB554
`CBM-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).	CB55.1, CB554
`CBM-LAST-DIST-SEQ` LAST_DIST_SEQ	Numeric 4	An automatically assigned sequence number.	AP170, AP190, CB150, CB55.1, CB554, CB57.1
`CBM-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	CB55.1, CB554
`CBM-PROC-LEVEL` PROC_LEVEL	Alpha 5	—	AP45.3, CB55.1, CB554, CB56.2
`CBM-INCOME-CODE` INCOME_CODE	Alpha 4	—	AP45.3, CB55.1, CB554, CB56.2
`CBM-TAX-ID` TAX_ID	Alpha 20	—	AP45.3, CB55.1, CB554, CB56.2
`CBM-REPORT-INC-AMT` REPORT_INC_AMT	Signed 18.2	—	AP45.3, CB55.1, CB554, CB56.2
`CBM-YEAR-PAID` YEAR_PAID	Numeric 4	—	AP170, AP190, CB56.2
`CBM-RIC-OBJ-ID` RIC_OBJ_ID	Numeric 12	—	AP170, AP190, CB56.2
`CBM-TIN-TYPE` TIN_TYPE	Numeric 1	—	AP45.3, CB55.1, CB554, CB56.2
`CBM-FOR-ECON-CODE` FOR_ECON_CODE	Alpha 10	—	CB55.1, CB554
`CBM-PAY-TAX-EXEMPT` PAY_TAX_EXEMPT	Alpha 1	—	—
`CBM-BANK-CURRENCY` BANK_CURRENCY	Alpha 5	—	CB55.1, CB554
`CBM-TEMP-HOLD` TEMP_HOLD	Alpha 1	— `S` Sent for Approval `A` Approved by Engine	AP150, CB55.1
`CBM-TAX-EXEMPT` TAX_EXEMPT	Alpha 1	—	AP170

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`CBMSET1`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`	Primary	AP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
`CBMSET2`	`CASH-CODE`, `BANK-INST-CODE`, `REFERENCE-NO`, `TRANS-IDENT`		AP150, AP160, CB150, CB195, CB55.1, CB56.2, CB57.1
`CBMSET3`	`CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `TRANS-IDENT`	KeyChange	CB255, CB56.1
`CBMSET4`	`PAY-GROUP`, `REC-STATUS`, `PROC-GRP`, `BANK-INST-CODE`, `TRANS-IDENT`, `CASH-CODE`	KeyChange	AP150, AP160, AP170, AP30.3, CB55.1
`CBMSET5`	`PAY-GROUP`, `BANK-INST-CODE`, `TRANS-IDENT`, `CASH-CODE`	KeyChange	AP150, AP155, AP160, AP161, AP190, ZA161
`CBMSET6`	`CHECK-DATE*`, `USER-FIELD1`, `CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`	KeyChange	CB56.1
`CBMSET7`	`REC-STATUS`, `CASH-CODE`, `BANK-INST-CODE`, `REFERENCE-NO`, `TRANS-IDENT`	KeyChange	CB55.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Aprptblinc	APRPTBLINC	Required		`"CB"` → `RIC-SOURCE`, `CBM-YEAR-PAID` → `RIC-YEAR-PAID`, `CBM-RIC-OBJ-ID` → `RIC-RIC-OBJ-ID`
Cbpmtbod	CBPMTBOD	Not Required, Delete Cascades	Valid When YBH- = CBM-	`CBM-CASH-CODE` → `YBH-CASH-CODE`, `CBM-BANK-INST-CODE` → `YBH-BANK-INST-CODE`, `CBM-TRANS-IDENT` → `YBH-TRANS-IDENT`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Cbdistrib	CBDISTRIB			`CBM-CASH-CODE` → `CBD-CASH-CODE`, `CBM-BANK-INST-CODE` → `CBD-BANK-INST-CODE`, `CBM-TRANS-IDENT` → `CBD-TRANS-IDENT`, → `CBD-DIST-TYPE`, → `CBD-SEQ-NBR`

Programs

Updated by (17)

AP150 Cash Requirements
AP155 Payment Forms Creation
AP160 Payment Tape Creation
AP161 Electronic Payment File Creation
AP170 Payment Closing
AP190 Invoice Reinstatement
AP265 Cash Payment Register
AP30.3 Payment Schedule Adjustment
AP45.3 Non-AP Reportable Income Adjustment
CB150 Mass Release
CB255 Payment Listing
CB300 History Purge
CB55.1 Payment Entry
CB554 Payment Load
CB56.2 CB Reportable Income Adjustments
CB57.1 Payment Cancel
ZA161 Electronic Payment File Creation

Referenced by (85)

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
AP151 Bill of Exchange Generation
AP16.1 Vendor Bank
AP16.2 Vendor Location Bank
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
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
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
CB10.1 Cash Receipt Deposit
CB170 Positive Pay File Creation
CB175 Bank Transaction Posting
CB186 Stale Dating Processing
CB187 Stale Dating Reopen Update
CB195 Company Period Close
CB286 Stale Dating and Escheatment Report
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