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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CBM-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.AP150, AP160, AP161, CB55.1, CB554, ZA161
#CBM-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.AP150, AP160, AP161, CB55.1, CB554, ZA161
#CBM-TRANS-IDENT PK
TRANS_IDENT		Numeric 10A unique system-generated identification value assigned to the transaction to make this record unique.AP190, CB55.1, CB554
#CBM-REFERENCE-NO SET2 SET7
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 SET3
TRANS_NBR		Alpha 10 (Right Justified)A unique, user-defined value used to identify the transaction.AP155, AP160, AP161, AP190, ZA161
#CBM-CHECK-DATE SET6
CHECK_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP155, AP160, AP161, AP190, ZA161
#CBM-REC-STATUS SET4 SET7
REC_STATUS		Numeric 1The 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 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.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 1The 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 1The 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.7The currency rate.CB55.1, CB554
#CBM-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This 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 SET4
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 SET4 SET5
PAY_GROUP		Alpha 4A 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 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.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 2The 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 2The 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 35The bank-assigned account number identification to be used for the cash code.CB55.1, CB554
#CBM-BANK-ENTITY
BANK_ENTITY		Alpha 15Represents 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 18This field holds an individual account number reference for the Building SocietyCB55.1, CB554
#CBM-BUILD-ACCT-NM
BUILD_ACCT_NM		Alpha 18—CB55.1, CB554
#CBM-CROSS-IDENT
CROSS_IDENT		Alpha 1This 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 SET6
USER_FIELD1		Alpha 20This 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 20This 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 20This 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 20This 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 10Language 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 12The journal book assigned to the transaction.CB55.1, CB554
#CBM-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The 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 4An automatically assigned sequence number.AP170, AP190, CB150, CB55.1, CB554, CB57.1
#CBM-SOURCE-CODE
SOURCE_CODE		Alpha 2A 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 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
CBMSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
PrimaryAP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
CBMSET2
  1. CASH-CODE
  2. BANK-INST-CODE
  3. REFERENCE-NO
  4. TRANS-IDENT
AP150, AP160, CB150, CB195, CB55.1, CB56.2, CB57.1
CBMSET3
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-NBR
  4. TRANS-IDENT
KeyChangeCB255, CB56.1
CBMSET4
  1. PAY-GROUP
  2. REC-STATUS
  3. PROC-GRP
  4. BANK-INST-CODE
  5. TRANS-IDENT
  6. CASH-CODE
KeyChangeAP150, AP160, AP170, AP30.3, CB55.1
CBMSET5
  1. PAY-GROUP
  2. BANK-INST-CODE
  3. TRANS-IDENT
  4. CASH-CODE
KeyChangeAP150, AP155, AP160, AP161, AP190, ZA161
CBMSET6
  1. CHECK-DATE ↓
  2. USER-FIELD1
  3. CASH-CODE
  4. BANK-INST-CODE
  5. TRANS-IDENT
KeyChangeCB56.1
CBMSET7
  1. REC-STATUS
  2. CASH-CODE
  3. BANK-INST-CODE
  4. REFERENCE-NO
  5. TRANS-IDENT
KeyChangeCB55.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APRPTBLINCCBPMTBODCBDISTRIBCBPAYMENT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AprptblincAPRPTBLINCRequired
"CB"→RIC-SOURCE
CBM-YEAR-PAID→RIC-YEAR-PAID
CBM-RIC-OBJ-ID→RIC-RIC-OBJ-ID
CbpmtbodCBPMTBODNot Required, Delete CascadesValid 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

RelationTableRulesConditionField map
CbdistribCBDISTRIB
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)

Referenced by (85)