CBPMTLOAD

Cash Payment Conversion/Import
UPDATED BY
CB54.1 CB554

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLO-RUN-GROUP
Element: 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
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.
CB54.1
CLO-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.
CB54.1
CLO-REFERENCE-NO
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
CB54.1
CLO-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
CB54.1
CLO-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.
CB54.1 CB554
CLO-REC-STATUS
Element: Rec Status
Numeric 1
The record status.
0 = Unreleased
1 = Released
CB54.1
CLO-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
CB54.1 CB554
CLO-TRANS-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
CB54.1
CLO-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
CB54.1 CB554
CLO-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.
CB54.1 CB554
CLO-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.
CB54.1 CB554
CLO-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.
CB54.1 CB554
CLO-PAYEE-NAME
Element: Legal Name
Alpha 80 (Lower Case)
Institution's legal name used on the GM269 and GM272 reports.
CB54.1
CLO-PAYEE-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
CB54.1
CLO-PAYEE-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
CB54.1
CLO-PAYEE-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
CB54.1
CLO-PAYEE-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
CB54.1
CLO-PAYEE-ADDR5
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
CB54.1
CLO-PAYEE-ST-PROV
Element: State Prov
Alpha 2
The state or province.
CB54.1
CLO-PAY-POSTAL-CD
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
CB54.1
CLO-PAY-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
CB54.1
CLO-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).
CB54.1
CLO-VBANK-IDENT
Element: Alphadata1
Alpha 1

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

N = Not Prenotified
A = Accepted
CB54.1 CB554
CLO-VBANK-ACCT-TP
Element: Vbank Acct Tp
Alpha 1

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

N = Normal
E = Express
CB54.1
CLO-PMT-FORM
Element: Pmt Form
Alpha 2
CB54.1
CLO-CHARGE-CODE
Element: Charge Code
Alpha 1
CB54.1
CLO-COMMENT1
Element: Cmt Text
Alpha 60 (Lower Case)
The text associated with the sequence number.
CB54.1
CLO-COMMENT2
Element: Cmt Text
Alpha 60 (Lower Case)
The text associated with the sequence number.
CB54.1
CLO-COMMENT3
Element: Cmt Text
Alpha 60 (Lower Case)
The text associated with the sequence number.
CB54.1
CLO-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.
CB54.1
CLO-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.
CB54.1
CLO-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.
CB54.1
CLO-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.
CB54.1
CLO-DIS-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.
CB54.1 CB554
CLO-ACCT-UNIT
Element: 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
Element: 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
Element: Sub Acct
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
Element: Intl Amt
Signed 18.2
CB54.1 CB554
CLO-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
CB54.1
CLO-ACTIVITY
Element: 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
Element: 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
Element: 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
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
CB54.1
CLO-TRAN-TAXABLE
Element: Intl Amt
Signed 18.2
CB54.1
CLO-SOURCE-CODE
Element: 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
Element: Language Code
Alpha 10
Language Code (LOCALE).
CB54.1
CLO-PROC-LEVEL
Element: Process Level
Alpha 5
CB54.1
CLO-INCOME-CODE
Element: Income Code
Alpha 4
CB54.1
CLO-TAX-ID
Element: Tax Id
Alpha 20
CB54.1
CLO-REPORT-INC-AMT
Element: Intl Amt
Signed 18.2
CB54.1
CLO-TIN-TYPE
Element: Flag Num
Numeric 1
CB54.1
CLO-FOR-ECON-CODE
Element: Code
Alpha 10
CB54.1
CLO-PAY-TAX-EXEMPT
Element: Flag
Alpha 1
CLO-BANK-CURRENCY
Element: Currency Code
Alpha 5
CB54.1


CBPMTLOAD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLOSET1 RUN-GROUP
CASH-CODE
BANK-INST-CODE
REFERENCE-NO
SEQ-NBR
CB54.1 CB554


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

Home
Contact Us



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