|
|
CBPAYMENT FILE
Cash Payment
REFERENCED BY
AP265 CB170 CB175 CB186 CB187 CB255
CB286 CB56.1
UPDATED BY
AP150 AP155 AP160 AP161 AP170 AP190
CB150 CB300 CB55.1 CB554
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBM-CASH-CODE Alpha 4 AP160 AP161
Element: Cash Code A cash code represents a bank account. CB55.1 CB554
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.
CBM-BANK-INST-CODE Alpha 3 AP150 AP160
Element: Bank Inst CodeA transaction code represents a type of AP161 CB55.1
cash payment, bill of exchange payment, CB554
or bank service transaction.
CBM-TRANS-IDENT Numeric 10 AP190 CB55.1
Element: Trans Ident A unique system-generated CB554
identification value assigned to the
transaction to make this record unique.
CBM-REFERENCE-NO Alpha 10 (Lower Case) CB55.1 CB554
Element: Reference The reference number associated with
the transaction.
CBM-VOID-DATE Numeric 8 (yyyymmdd) AP190
Element: Date This field displays the system date
when this was created.
CBM-TRANS-NBR Alpha 10 (Right Justified) AP155 AP160
Element: Trans Nbr A unique, user-defined value used to AP161 AP190
identify the transaction.
CBM-CHECK-DATE Numeric 8 (yyyymmdd) AP155 AP160
Element: Date This field displays the system date AP161 AP190
when this was created.
CBM-REC-STATUS Numeric 1 AP150 AP155
Element: Rec Status The record status. AP160 AP161
0 = Unreleased AP170 AP190
1 = Released CB150 CB55.1
2 = Selected for Payment CB554
3 = System Generated
8 = Voided
9 = Historical
CBM-COMPANY Numeric 4 CB55.1 CB554
Element: Company 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.
CBM-VENDOR Alpha 9 (Right Justified) CB55.1 CB554
Element: Vendor The vendor's identification code.
CBM-BANK-CHK-AMT Signed 18.2 AP150 CB55.1
Element: Intl Amt CB554
CBM-BANK-ND Numeric 1 AP150 CB55.1
Element: Acct Nd The number of decimals assigned to a CB554
particular account as determined by the
account currency.
CBM-BASE-PMT-AMT Signed 18.2 CB55.1 CB554
Element: Intl Amt
CBM-BASE-ND Numeric 1 CB55.1 CB554
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CBM-BASE-CHK-AMT Signed 18.2 AP150
Element: Intl Amt
CBM-EXCHANGE-RATE Signed 14.7 CB55.1 CB554
Element: Curr Rate The currency rate.
CBM-CURRENCY-CODE Alpha 5 CB55.1 CB554
Element: Currency Code This field contains the bank account
currency defined for the cash code.
CBM-POST-DATE Numeric 8 (yyyymmdd) CB55.1 CB554
Element: Date This field displays the system date
when this was created.
CBM-DESCRIPTION Alpha 30 (Lower Case) CB55.1 CB554
Element: Description This field displays the description.
CBM-PROC-GRP Alpha 4 (Lower Case) CB55.1 CB554
Element: Proc Grp A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
CBM-PAY-GROUP Alpha 4 CB55.1 CB554
Element: Pay Group 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.
CBM-OVERRIDE-COMP Numeric 4 CB55.1 CB554
Element: Company 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.
CBM-PAYEE-NAME Alpha 80 (Lower Case) CB55.1 CB554
Element: Legal Name Institution's legal name used on the
GM269 and GM272 reports.
CBM-PAYEE-ADDR1 Alpha 30 (Lower Case) CB55.1 CB554
Element: Addr1 This field contains the first line of
address information.
CBM-PAYEE-ADDR2 Alpha 30 (Lower Case) CB55.1 CB554
Element: Addr1 This field contains the first line of
address information.
CBM-PAYEE-ADDR3 Alpha 30 (Lower Case) CB55.1 CB554
Element: Addr1 This field contains the first line of
address information.
CBM-PAYEE-ADDR4 Alpha 30 (Lower Case) CB55.1 CB554
Element: Addr1 This field contains the first line of
address information.
CBM-PAYEE-ADDR5 Alpha 30 (Lower Case) CB55.1 CB554
Element: Addr1 This field contains the first line of
address information.
CBM-PAYEE-ST-PROV Alpha 2 CB55.1 CB554
Element: State Prov The state or province.
CBM-PAY-POSTAL-CD Alpha 10 (Lower Case) CB55.1 CB554
Element: Postal Code This field contains the postal code.
CBM-PAY-COUNTY Alpha 25 (Lower Case) CB55.1 CB554
Element: County The county for the company address.
CBM-PAY-CTRY-CODE Alpha 2 CB55.1 CB554
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CBM-VBANK-IDENT Alpha 1 CB55.1 CB554
Element: Alphadata1 " " = Standard Account Number
Y = IBAN Account Number
CBM-BANK-ACCT Alpha 35 CB55.1 CB554
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
CBM-BANK-ENTITY Alpha 15 CB55.1 CB554
Element: Bank Entity Represents a bank institution location.
CBM-ACH-PRENOTE Alpha 1 AP160 CB150
Element: Ach Prenot N = Not Prenotified CB55.1 CB554
P = Prenotified
A = Accepted
CBM-VBANK-ACCT-TP Alpha 1 CB55.1 CB554
Element: Vbank Acct Tp C = Current/Checking
S = Savings
CBM-BUILD-SOC-REF Alpha 18 CB55.1 CB554
Element: Build Soc Ref This field holds an individual account
number reference for the Building
Society
CBM-BUILD-ACCT-NM Alpha 18 CB55.1 CB554
Element: Account Name
CBM-CROSS-IDENT Alpha 1 CB55.1 CB554
Element: Cross Ident This field is used to distinguish
between SWIFT ID numbers and Routing
numbers.
S = SWIFT
R = Routing
CBM-SWIFT-ID Alpha 12 CB55.1 CB554
Element: Swift Id
CBM-PMT-CAT-CODE Alpha 6 CB55.1 CB554
Element: Pmt Cat Code
CBM-NORM-EXP-CODE Alpha 1 CB55.1 CB554
Element: Charge Code N = Normal
E = Express
CBM-PMT-FORM Alpha 2 CB55.1 CB554
Element: Pmt Form
CBM-CHARGE-CODE Alpha 1 CB55.1 CB554
Element: Charge Code
CBM-USER-FIELD1 Alpha 30 CB55.1 CB554
Element: User Field1 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.
CBM-USER-FIELD2 Alpha 30 CB55.1 CB554
Element: User Field2 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.
CBM-USER-FIELD3 Alpha 30 CB55.1 CB554
Element: User Field1 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.
CBM-USER-FIELD4 Alpha 30 CB55.1 CB554
Element: User Field2 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.
CBM-LANGUAGE-CODE Alpha 10 CB55.1 CB554
Element: Language Code Language Code (LOCALE).
CBM-TAX-FLAG Alpha 1 CB554
Element: All Flag " " = Not Interfaced
I = Interfaced
CBM-JRNL-BOOK-NBR Alpha 12 CB55.1 CB554
Element: Jrnl Book Nbr The journal book assigned to the
transaction.
CBM-JBK-SEQ-NBR Numeric 10 CB55.1 CB554
Element: Jbk Seq Nbr 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).
CBM-LAST-DIST-SEQ Numeric 4 AP170 AP190
Element: Seq Nbr An automatically assigned sequence CB150 CB55.1
number. CB554
CBM-SOURCE-CODE Alpha 2 CB55.1 CB554
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CBPAYMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBMSET1 CASH-CODE AP150 AP155
BANK-INST-CODE AP160 AP170
TRANS-IDENT AP265 CB170
CB175 CB186
CB187 CB255
CB286 CB300
CBMSET2 CASH-CODE AP160 CB150
BANK-INST-CODE CB55.1
REFERENCE-NO
TRANS-IDENT
CBMSET3 CASH-CODE KeyChange CB255
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CBMSET4 PAY-GROUP KeyChange AP150 AP160
REC-STATUS AP170
PROC-GRP
BANK-INST-CODE
TRANS-IDENT
CASH-CODE
CBMSET5 PAY-GROUP KeyChange AP150 AP155
BANK-INST-CODE AP160 AP161
TRANS-IDENT AP190
CASH-CODE
CBMSET6 CHECK-DATE* KeyChange CB56.1
USER-FIELD1
CASH-CODE
BANK-INST-CODE
TRANS-IDENT
CBPAYMENT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
