|
|
LMINTEREST FILE
UPDATED BY
AP30.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LEI-COMPANY Numeric 4
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.
LEI-PMT-VENDOR Alpha 9 (Right Justified)
Element: Vendor The vendor's identification code.
LEI-LEASE Alpha 19
Element: Lease
LEI-PMT-NBR Numeric 6
Element: Pmt Nbr
LEI-CANCEL-SEQ Numeric 4 AP30.4
Element: Seq Nbr An automatically assigned sequence
number.
LEI-DIST-SEQ-NBR Numeric 6
Element: Dist Seq Nbr A unique sequence number.
LEI-INT-SEQ-NBR Numeric 4
Element: Seq Nbr An automatically assigned sequence
number.
LEI-INT-COMPANY Numeric 4
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.
LEI-INT-ACCT-UNIT Alpha 15
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.
LEI-INT-ACCOUNT Numeric 6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
LEI-INT-SUB-ACCT Numeric 4
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.
LEI-INT-ACTIVITY Alpha 15
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.
LEI-INT-ACCT-CAT Alpha 5
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
LEI-INTEREST-AMT Signed 18.2
Element: Intl Amt
LEI-BASE-INT-AMT Signed 18.2
Element: Intl Amt
LEI-TO-BASE-AMT Signed 18.2
Element: Intl Amt
LEI-TO-BASE-PRINC Signed 18.2
Element: Intl Amt
LEI-TO-BASE-INT Signed 18.2
Element: Intl Amt
LEI-TO-BSE-INT-CUR Alpha 5
Element: To Bse Int Cur
LEI-TO-BSE-INT-ND Numeric 2
Element: To Bse Int Nd
LEI-TO-BSE-INT-RAT Signed 14.7
Element: Curr Rate The currency rate.
LEI-GLT-INT-OBJ-ID Numeric 12
Element: Glt Int Obj Id
LMINTEREST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LEISET1 COMPANY AP30.4
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
INT-SEQ-NBR
LMINTEREST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lmdistrib LMDISTRIB Not Required
LEI-COMPANY -> DIS-COMPANY
LEI-PMT-VENDOR -> DIS-PMT-VENDOR
LEI-LEASE -> DIS-LEASE
LEI-PMT-NBR -> DIS-PMT-NBR
LEI-CANCEL-SEQ -> DIS-CANCEL-SEQ
LEI-DIST-SEQ-NBR -> DIS-DIST-SEQ-NBR
|
