|
|
LMDISTRIB FILE
Invoice Distributitions
This file stores distribution information for invoices generated from a lease
payment schedule.
UPDATED BY
AP30.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIS-COMPANY Numeric 4
Element: Lease Company This field contains the Accounts
Payable company associated with the
invoice.
DIS-LEASE Alpha 19
Element: Lease This field contains the lease number.
DIS-PMT-VENDOR Alpha 9 (Right Justified)
Element: Payment VendorThis field contains the vendor who
receives the payment.
DIS-PMT-NBR Numeric 3
Element: Payment NumberThis is the unique number assigned to
the payment. Together with the lease
number, it forms the invoice number.
DIS-DIST-SEQ-NBR Numeric 4
Distribution This field contains a unique sequence
Sequence Number number assigned to the distribution
record.
DIS-INVOICE Alpha 22
Element: Invoice This field contains the unique invoice
number associated with the lease. It
consists of the lease number with the
payment number as a suffix.
DIS-SUFFIX Numeric 3
Element: Suffix This field contains the invoice suffix
used to make a recurring invoice
instance unique.
DIS-CANCEL-SEQ Numeric 4 AP30.4
Cancellation The sequence number assigned upon a
Sequence Number cancellation of a distributed invoice.
The first sequence assigned is 9999.
DIS-EXEC-CODE Alpha 6
Element: Executory CostThis represents the executory code
associated with the payment.
DIS-PT-COMPANY Numeric 4
Debt/Operating This field contains the company where
Expense Company the debt (capital lease) or expense
(operating lease) distribution is
posted.
DIS-ACCT-UNIT Alpha 15
Debt/Expense This field contains the accounting unit
Accounting Unit where the debt (capital lease) or
expense (operating lease) distribution
is posted.
DIS-ACCOUNT Numeric 6
Element: Debt/Expense AThis field contains the account where
the debt (capital lease) or expense
(operating lease) distribution is
posted.
DIS-SUB-ACCOUNT Numeric 4
Debt/Expense This field contains the subaccount where
Subaccount the debt (capital lease) or expense
(operating lease) distribution is
posted.
DIS-ACTIVITY Alpha 15
Debt/Expense This field contains the activity where
Activity the debt (capital lease) or expense
(operating lease) distributions are
tracked.
DIS-ACCT-CATEGORY Alpha 5
Debt/Expense This field contains the account category
Account Category for the activity where debt (capital
lease) or expense (operating lease)
distributions are tracked.
DIS-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
DIS-SEGMENT-BLOCK Alpha 103
Element: User Analysis 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.
DIS-ORIG-TRAN-AMT Signed 18.2
Lease Currency This field contains the amount of the
Distrib Amount invoice distribution in the currency of
the invoice (which is also the lease
currency).
DIS-PCT-TRAN-AMT Signed 18.2
Element: Intl Amt
DIS-PRINCIPAL-AMT Signed 18.2
Lease Currency This is the principal portion of the
Principal Amt payment in lease currency.
DIS-INTEREST-AMT Signed 18.2
Lease Currency This is the interest portion of the
Interest Amount payment in lease currency.
DIS-ORIG-BASE-AMT Signed 18.2
Base Currency This the total payment amount in company
Distrib Amount base currency.
DIS-PCT-BASE-AMT Signed 18.2
Element: Intl Amt
DIS-BASE-PRINC-AMT Signed 18.2
Base Currency This is the principal payment amount in
Principal Amount company base currency.
DIS-BASE-INT-AMT Signed 18.2
Base Currency This is the interest payment amount in
Interest Amount company base currency.
DIS-TO-BASE-CURR Alpha 5
Debt Company This field contains the base currency of
Currency the debt company.
DIS-TO-BASE-ND Numeric 1
Element: Number of DeciThis field indicates the number of
decimal positions defined for the debt
company currency conversions.
DIS-TO-BASE-RATE Signed 14.7
Debt Co Currency This is the debt company currency
Exchange Rate exchange rate.
DIS-TO-BASE-AMT Signed 18.2
Debt Co Currency This is the payment amount in debt
Paymt Amount company currency.
DIS-GLT-PRN-OBJ-ID Numeric 12
Principal Amount This is the object ID used to drill
Object ID around hrough principal transactions..
DIS-INT-CALC-FL Alpha 1
Interst Calculation This flag indicates whether interest
Flag should be calculated. If the lease is a
capital lease, the interest calculation
flag is set to Yes.
DIS-INT-CALC-DATE Numeric 8 (yyyymmdd)
Interest This field contains the date when
Calculation Date interest was calculated.
DIS-INT-CANCEL-FL Alpha 1
Interest This flag indicates whether the interest
Calculation Cancel Fl calculations have been canceled. Values
are:
Y = Yes
N = No
If a lease payment invoice is canceled
in AP and interest calculations have
already been performed for the payment,
the next time LM180 is run, the
interest calculation is reversed and
this flag is set to Yes.
DIS-STATUS Numeric 1
Element: Lease Invoice This field indicates whether the lease
is posted. Valid values are:
9 = Posted
0 = Unposted
DIS-INV-FISCAL-YR Derived
Element: Invoice FiscalThis field contains the lease invoice
fiscal year.
DIS-INV-PERIOD Derived
Element: Invoice PeriodThis field contains the lease invoice
period.
DIS-ALLOC-CD Alpha 12
Element: Exp Alloc Code
LMDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DISSET1 COMPANY This index is used to access and create AP30.4
PMT-VENDOR unique distribution records.
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
DISSET2 COMPANY KeyChange, Subset
LEASE Where CANCEL-SEQ = Zeroes
PMT-VENDOR
PMT-NBR
PT-COMPANY
ACCT-UNIT
DIST-SEQ-NBR
LMDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
DIS-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Not Required
DIS-ACTIVITY -> ACV-ACTIVITY
Apcompany APCOMPANY Not Required
DIS-COMPANY -> CPY-COMPANY
Lminvoice LMINVOICE Not Required
DIS-COMPANY -> INV-COMPANY
DIS-LEASE -> INV-LEASE
DIS-PMT-NBR -> INV-PMT-NBR
DIS-PMT-VENDOR -> INV-PMT-VENDOR
DIS-CANCEL-SEQ -> INV-CANCEL-SEQ
Pt Company GLSYSTEM Not Required
DIS-PT-COMPANY -> GLS-COMPANY
LMDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lminterest LMINTEREST
DIS-COMPANY -> LEI-COMPANY
DIS-PMT-VENDOR -> LEI-PMT-VENDOR
DIS-LEASE -> LEI-LEASE
DIS-PMT-NBR -> LEI-PMT-NBR
DIS-CANCEL-SEQ -> LEI-CANCEL-SEQ
DIS-DIST-SEQ-NBR -> LEI-DIST-SEQ-NBR
LEI-INT-SEQ-NBR
|
