|
|
CBPMTLOAD FILE
Cash Payment Conversion/Import
UPDATED BY
CB54.1 CB554
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLO-RUN-GROUP Alpha 15 CB54.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
CLO-CASH-CODE Alpha 4 CB54.1
Element: Cash Code 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.
CLO-BANK-INST-CODE Alpha 3 CB54.1
Element: Bank Inst CodeA transaction code represents a type of
cash payment, bill of exchange payment,
or bank service transaction.
CLO-REFERENCE-NO Alpha 10 (Lower Case) CB54.1
Element: Reference The reference number associated with
the transaction.
CLO-SEQ-NBR Numeric 4 CB54.1
Element: Seq Nbr An automatically assigned sequence
number.
CLO-COMPANY Numeric 4 CB54.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.
CLO-REC-STATUS Numeric 1 CB54.1
Element: Rec Status The record status.
0 = Unreleased
1 = Released
CLO-VENDOR Alpha 9 (Right Justified) CB54.1 CB554
Element: Vendor The vendor's identification code.
CLO-TRANS-DATE Numeric 8 (yyyymmdd) CB54.1
Element: Date This field displays the system date
when this was created.
CLO-DESCRIPTION Alpha 30 (Lower Case) CB54.1 CB554
Element: Description This field displays the description.
CLO-PROC-GRP Alpha 4 (Lower Case) CB54.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.
CLO-PAY-GROUP Alpha 4 CB54.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.
CLO-OVERRIDE-COMP Numeric 4 CB54.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.
CLO-PAYEE-NAME Alpha 80 (Lower Case) CB54.1
Element: Legal Name Institution's legal name used on the
GM269 and GM272 reports.
CLO-PAYEE-ADDR1 Alpha 30 (Lower Case) CB54.1
Element: Addr1 This field contains the first line of
address information.
CLO-PAYEE-ADDR2 Alpha 30 (Lower Case) CB54.1
Element: Addr1 This field contains the first line of
address information.
CLO-PAYEE-ADDR3 Alpha 30 (Lower Case) CB54.1
Element: Addr1 This field contains the first line of
address information.
CLO-PAYEE-ADDR4 Alpha 30 (Lower Case) CB54.1
Element: Addr1 This field contains the first line of
address information.
CLO-PAYEE-ADDR5 Alpha 30 (Lower Case) CB54.1
Element: Addr1 This field contains the first line of
address information.
CLO-PAYEE-ST-PROV Alpha 2 CB54.1
Element: State Prov The state or province.
CLO-PAY-POSTAL-CD Alpha 10 (Lower Case) CB54.1
Element: Postal Code This field contains the postal code.
CLO-PAY-COUNTY Alpha 25 (Lower Case) CB54.1
Element: County The county for the company address.
CLO-PAY-CTRY-CODE Alpha 2 CB54.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CLO-VBANK-IDENT Alpha 1 CB54.1
Element: Alphadata1 " " = Standard Account Number
Y = IBAN Account Number
CLO-BANK-ACCT Alpha 35 CB54.1
Element: Bank Acct Nbr The bank-assigned account number
identification to be used for the cash
code.
CLO-BANK-ENTITY Alpha 15 CB54.1
Element: Bank Entity Represents a bank institution location.
CLO-ACH-PRENOTE Alpha 1 CB54.1 CB554
Element: Ach Prenot N = Not Prenotified
A = Accepted
CLO-VBANK-ACCT-TP Alpha 1 CB54.1 CB554
Element: Vbank Acct Tp C = Current/Checking
S = Savings
CLO-BUILD-SOC-REF Alpha 18 CB54.1
Element: Build Soc Ref This field holds an individual account
number reference for the Building
Society
CLO-BUILD-ACCT-NM Alpha 18 CB54.1
Element: Account Name
CLO-CROSS-IDENT Alpha 1 CB54.1
Element: Cross Ident This field is used to distinguish
between SWIFT ID numbers and Routing
numbers.
S = SWIFT
R = Routing
CLO-SWIFT-ID Alpha 12 CB54.1
Element: Swift Id
CLO-PMT-CAT-CODE Alpha 6 CB54.1
Element: Pmt Cat Code
CLO-NORM-EXP-CODE Alpha 1 CB54.1
Element: Charge Code N = Normal
E = Express
CLO-PMT-FORM Alpha 2 CB54.1
Element: Pmt Form
CLO-CHARGE-CODE Alpha 1 CB54.1
Element: Charge Code
CLO-COMMENT1 Alpha 60 (Lower Case) CB54.1
Element: Cmt Text The text associated with the sequence
number.
CLO-COMMENT2 Alpha 60 (Lower Case) CB54.1
Element: Cmt Text The text associated with the sequence
number.
CLO-COMMENT3 Alpha 60 (Lower Case) CB54.1
Element: Cmt Text The text associated with the sequence
number.
CLO-USER-FIELD1 Alpha 30 CB54.1
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.
CLO-USER-FIELD2 Alpha 30 CB54.1
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.
CLO-USER-FIELD3 Alpha 30 CB54.1
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.
CLO-USER-FIELD4 Alpha 30 CB54.1
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.
CLO-DIS-COMPANY Numeric 4 CB54.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.
CLO-ACCT-UNIT Alpha 15 CB54.1 CB554
Element: Acct Unit 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.
CLO-ACCOUNT Numeric 6 CB54.1 CB554
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
CLO-SUB-ACCOUNT Numeric 4 CB54.1 CB554
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
CLO-DIST-AMOUNT Signed 18.2 CB54.1 CB554
Element: Intl Amt
CLO-REFERENCE Alpha 10 (Lower Case) CB54.1
Element: Reference The reference number associated with
the transaction.
CLO-ACTIVITY Alpha 15 CB54.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
CLO-ACCT-CATEGORY Alpha 5 CB54.1 CB554
Element: Acct Category 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
CLO-SEGMENT-BLOCK Alpha 103 CB54.1 CB554
Element: Segment Block 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.
CLO-TAX-CODE Alpha 10 CB54.1
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CLO-TRAN-TAXABLE Signed 18.2 CB54.1
Element: Intl Amt
CLO-SOURCE-CODE Alpha 2 CB54.1 CB554
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CLO-LANGUAGE-CODE Alpha 10 CB54.1
Element: Language Code Language Code (LOCALE).
CBPMTLOAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLOSET1 RUN-GROUP CB54.1 CB554
CASH-CODE
BANK-INST-CODE
REFERENCE-NO
SEQ-NBR
|
