CBPAYMENT

Cash Payment

REFERENCED BY
AP10.1 AP10.2 AP100 AP109 AP110 AP111
AP115 AP125 AP126 AP14.1 AP14.2 AP14.5
AP151 AP16.1 AP16.2 AP180 AP181 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP28.1 AP28.2 AP300 AP305 AP510
AP520 AP590 API1.1 API2.1 CB00.1 CB10.1
CB170 CB175 CB186 CB187 CB286 EE135
EE20.1 EE20.2 EE35.1 EE35.2 EE520 IC64.6
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA44.1
MA44.2 MA60.2 MA60.3 MA60.4 MA61.1 MA64.6
MA64.9 MA65.1 MA66.1 MA66.2 MA66.3 MA67.3
MA68.2 MA68.4 MA70.1 MA75.1 MAED.1 MAI1.1
CB195


UPDATED BY
AP150 AP155 AP160 AP161 AP170 AP190
AP45.3 ZA161 CB150 CB300 CB55.1 CB554
CB56.2 CB57.1 AP265 AP30.3 CB255

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBM-CASH-CODE
Element: 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
Element: 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
Element: 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
Element: Reference		Alpha 10 (Lower Case)
The reference number associated with the transaction.
CB55.1 CB554
CBM-VOID-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP190
CBM-TRANS-NBR
Element: Trans Nbr		Alpha 10 (Right Justified)
A unique, user-defined value used to identify the transaction.
AP155 AP160
AP161 AP190
ZA161
CBM-CHECK-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP155 AP160
AP161 AP190
ZA161
CBM-REC-STATUS
Element: 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
CB554 CB57.1
ZA161
CBM-COMPANY
Element: 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
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
CB55.1 CB554
CBM-BANK-CHK-AMT
Element: Intl Amt		Signed 18.2
AP150 CB55.1
CB554
CBM-BANK-ND
Element: Acct 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
Element: Intl Amt		Signed 18.2
CB55.1 CB554
CBM-BASE-ND
Element: Acct 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
Element: Intl Amt		Signed 18.2
AP150
CBM-EXCHANGE-RATE
Element: Curr Rate		Signed 14.7
The currency rate.
CB55.1 CB554
CBM-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the bank account currency defined for the cash code.
CB55.1 CB554
CBM-POST-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB55.1 CB554
CBM-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
CB55.1 CB554
CBM-PROC-GRP
Element: 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
Element: 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
Element: 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-PAYEE-NAME
Element: Legal Name		Alpha 80 (Lower Case)
Institution's legal name used on the GM269 and GM272 reports.
CB55.1 CB554
CBM-PAYEE-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
CB55.1 CB554
CBM-PAYEE-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
CB55.1 CB554
CBM-PAYEE-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
CB55.1 CB554
CBM-PAYEE-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
CB55.1 CB554
CBM-PAYEE-ADDR5
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
CB55.1 CB554
CBM-PAYEE-ST-PROV
Element: State Prov		Alpha 2
The state or province.
CB55.1 CB554
CBM-PAY-POSTAL-CD
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code.
CB55.1 CB554
CBM-PAY-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
CB55.1 CB554
CBM-PAY-CTRY-CODE
Element: Country 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
Element: Alphadata1		Alpha 1

" " = Standard Account Number
Y = IBAN Account Number
CB55.1 CB554
CBM-BANK-ACCT
Element: Bank Acct Nbr		Alpha 35
The bank-assigned account number identification to be used for the cash code.
CB55.1 CB554
CBM-BANK-ENTITY
Element: Bank Entity		Alpha 15
Represents a bank institution location.
CB55.1 CB554
CBM-ACH-PRENOTE
Element: Ach Prenot		Alpha 1

N = Not Prenotified
P = Prenotified
A = Accepted
AP160 CB150
CB55.1 CB554
CBM-VBANK-ACCT-TP
Element: Vbank Acct Tp		Alpha 1

C = Current/Checking
S = Savings
CB55.1 CB554
CBM-BUILD-SOC-REF
Element: Build Soc Ref		Alpha 18
This field holds an individual account number reference for the Building Society
CB55.1 CB554
CBM-BUILD-ACCT-NM
Element: Account Name		Alpha 18
CB55.1 CB554
CBM-CROSS-IDENT
Element: 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
Element: Swift Id		Alpha 12
CB55.1 CB554
CBM-PMT-CAT-CODE
Element: Pmt Cat Code		Alpha 6
CB55.1 CB554
CBM-NORM-EXP-CODE
Element: Charge Code		Alpha 1

N = Normal
E = Express
CB55.1 CB554
CBM-PMT-FORM
Element: Pmt Form		Alpha 2
CB55.1 CB554
CBM-CHARGE-CODE
Element: Charge Code		Alpha 1
CB55.1 CB554
CBM-USER-FIELD1
Element: Usr Fld 01		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
Element: Usr Fld 02		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
Element: Usr Fld 03		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
Element: Usr Fld 04		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
Element: Language Code		Alpha 10
Language Code (LOCALE).
CB55.1 CB554
CBM-TAX-FLAG
Element: All Flag		Alpha 1

" " = Not Interfaced
I = Interfaced
CB554
CBM-JRNL-BOOK-NBR
Element: Jrnl Book Nbr		Alpha 12
The journal book assigned to the transaction.
CB55.1 CB554
CBM-JBK-SEQ-NBR
Element: 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
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AP170 AP190
CB150 CB55.1
CB554 CB57.1
CBM-SOURCE-CODE
Element: 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
Element: Process Level		Alpha 5
AP45.3 CB55.1
CB554 CB56.2
CBM-INCOME-CODE
Element: Income Code		Alpha 4
AP45.3 CB55.1
CB554 CB56.2
CBM-TAX-ID
Element: Tax Id		Alpha 20
AP45.3 CB55.1
CB554 CB56.2
CBM-REPORT-INC-AMT
Element: Intl Amt		Signed 18.2
AP45.3 CB55.1
CB554 CB56.2
CBM-YEAR-PAID
Element: Year		Numeric 4
AP170 AP190
CB56.2
CBM-RIC-OBJ-ID
Element: Obj Id		Numeric 12
AP170 AP190
CB56.2
CBM-TIN-TYPE
Element: Flag Num		Numeric 1
AP45.3 CB55.1
CB554 CB56.2
CBM-FOR-ECON-CODE
Element: Code		Alpha 10
CB55.1 CB554
CBM-PAY-TAX-EXEMPT
Element: Flag		Alpha 1
CBM-BANK-CURRENCY
Element: Currency Code		Alpha 5
CB55.1 CB554
CBM-TEMP-HOLD
Element: Temp Hold		Alpha 1

S = Sent for Approval
A = Approved by Engine
AP150 CB55.1
CBM-TAX-EXEMPT
Element: Tax Exempt Flg		Alpha 1
AP170


CBPAYMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBMSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
...
AP10.1 AP10.2
AP100 AP109
AP110 AP111
AP115 AP125
AP126 AP14.1
AP14.2 AP14.5
AP150 AP151
AP155 AP16.1
AP16.2 AP160
AP161 AP170
AP180 AP181
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
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


CBPAYMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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


CBPAYMENT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Thu Jun 09 02:12:06 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.