|
|
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 ID
LEI-LEASE Alpha 19
Element: Lease
LEI-PMT-NBR Numeric 3
Element: Pmt Nbr
LEI-CANCEL-SEQ Numeric 4 AP30.4
Element: Sequence NumbeThe sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
LEI-DIST-SEQ-NBR Numeric 4
Distribution A unique sequence number.
Sequence Number
LEI-INT-SEQ-NBR Numeric 4
Element: Sequence Number
LEI-INT-COMPANY Numeric 4
Element: Company
LEI-INT-ACCT-UNIT Alpha 15
Element: Accounting Unit
LEI-INT-ACCOUNT Numeric 6
Element: Account
LEI-INT-SUB-ACCT Numeric 4
Element: Subaccount
LEI-INT-ACTIVITY Alpha 15
Element: Activity
LEI-INT-ACCT-CAT Alpha 5
Element: Account Category
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: 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
|
