LMINTEREST

UPDATED BY
AP30.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LEI-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.
LEI-PMT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
LEI-LEASE
Element: Lease
Alpha 19
LEI-PMT-NBR
Element: Pmt Nbr
Numeric 6
LEI-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP30.4
LEI-DIST-SEQ-NBR
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
LEI-INT-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
LEI-INT-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.
LEI-INT-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.
LEI-INT-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.
LEI-INT-SUB-ACCT
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.
LEI-INT-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.
LEI-INT-ACCT-CAT
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
LEI-INTEREST-AMT
Element: Intl Amt
Signed 18.2
LEI-BASE-INT-AMT
Element: Intl Amt
Signed 18.2
LEI-TO-BASE-AMT
Element: Intl Amt
Signed 18.2
LEI-TO-BASE-PRINC
Element: Intl Amt
Signed 18.2
LEI-TO-BASE-INT
Element: Intl Amt
Signed 18.2
LEI-TO-BSE-INT-CUR
Element: To Bse Int Cur
Alpha 5
LEI-TO-BSE-INT-ND
Element: To Bse Int Nd
Numeric 2
LEI-TO-BSE-INT-RAT
Element: Curr Rate
Signed 14.7
The currency rate.
LEI-GLT-INT-OBJ-ID
Element: Glt Int Obj Id
Numeric 12


LMINTEREST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LEISET1 COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
INT-SEQ-NBR
AP30.4


LMINTEREST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:19:32 2016

Home
Contact Us



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