LMDISTRIB

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
Element: Lease Company
Numeric 4
This field contains the Accounts Payable company associated with the invoice.
DIS-LEASE
Element: Lease
Alpha 19
This field contains the lease number.
DIS-PMT-VENDOR
Element: Payment Vendor
Alpha 9 (Right Justified)
This field contains the vendor who receives the payment.
DIS-PMT-NBR
Element: Payment Number
Numeric 6
This is the unique number assigned to the payment. Together with the lease number, it forms the invoice number.
DIS-DIST-SEQ-NBR
Distribution
Sequence Number
Numeric 6
This field contains a unique sequence number assigned to the distribution record.
DIS-INVOICE
Element: Invoice
Alpha 22
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
Element: Suffix
Numeric 3
This field contains the invoice suffix used to make a recurring invoice instance unique.
DIS-CANCEL-SEQ
Cancellation
Sequence Number
Numeric 4
An automatically assigned sequence number.
AP30.4
DIS-EXEC-CODE
Element: Executory Cost Code
Alpha 6
This represents the executory code associated with the payment.
DIS-PT-COMPANY
Debt/Operating
Expense Company
Numeric 4
This field contains the company where the debt (capital lease) or expense (operating lease) distribution is posted.
DIS-ACCT-UNIT
Debt/Expense
Accounting Unit
Alpha 15
This field contains the accounting unit where the debt (capital lease) or expense (operating lease) distribution is posted.
DIS-ACCOUNT
Element: Debt/Expense Account
Numeric 6
This field contains the account where the debt (capital lease) or expense (operating lease) distribution is posted.
DIS-SUB-ACCOUNT
Debt/Expense
Subaccount
Numeric 4
This field contains the subaccount where the debt (capital lease) or expense (operating lease) distribution is posted.
DIS-ACTIVITY
Debt/Expense
Activity
Alpha 15
This field contains the activity where the debt (capital lease) or expense (operating lease) distributions are tracked.
DIS-ACCT-CATEGORY
Debt/Expense
Account Category
Alpha 5
This field contains the account category for the activity where debt (capital lease) or expense (operating lease) distributions are tracked.
DIS-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
DIS-SEGMENT-BLOCK
Element: User Analysis Values
Alpha 103
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
Lease Currency
Distrib Amount
Signed 18.2
This field contains the amount of the invoice distribution in the currency of the invoice (which is also the lease currency).
DIS-PCT-TRAN-AMT
Element: Intl Amt
Signed 18.2
DIS-PRINCIPAL-AMT
Lease Currency
Principal Amt
Signed 18.2
This is the principal portion of the payment in lease currency.
DIS-INTEREST-AMT
Lease Currency
Interest Amount
Signed 18.2
This is the interest portion of the payment in lease currency.
DIS-ORIG-BASE-AMT
Base Currency
Distrib Amount
Signed 18.2
This the total payment amount in company base currency.
DIS-PCT-BASE-AMT
Element: Intl Amt
Signed 18.2
DIS-BASE-PRINC-AMT
Base Currency
Principal Amount
Signed 18.2
This is the principal payment amount in company base currency.
DIS-BASE-INT-AMT
Base Currency
Interest Amount
Signed 18.2
This is the interest payment amount in company base currency.
DIS-TO-BASE-CURR
Debt Company
Currency
Alpha 5
This field contains the base currency of the debt company.
DIS-TO-BASE-ND
Element: Number of Decimals
Numeric 1
This field indicates the number of decimal positions defined for the debt company currency conversions.
DIS-TO-BASE-RATE
Debt Co Currency
Exchange Rate
Signed 14.7
This is the debt company currency exchange rate.
DIS-TO-BASE-AMT
Debt Co Currency
Paymt Amount
Signed 18.2
This is the payment amount in debt company currency.
DIS-GLT-PRN-OBJ-ID
Principal Amount
Object ID
Numeric 12
This is the object ID used to drill around hrough principal transactions..
DIS-INT-CALC-FL
Interst Calculation
Flag
Alpha 1
This flag indicates whether interest should be calculated. If the lease is a capital lease, the interest calculation flag is set to Yes.
DIS-INT-CALC-DATE
Interest
Calculation Date
Numeric 8 (yyyymmdd)
This field contains the date when interest was calculated.
DIS-INT-CANCEL-FL
Interest
Calculation Cancel Fl
Alpha 1
This flag indicates whether the interest 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
Element: Lease Invoice Status
Numeric 1
This field indicates whether the lease is posted. Valid values are: 9 = Posted 0 = Unposted
DIS-INV-FISCAL-YR
Element: Invoice Fiscal year
Derived
This field contains the lease invoice fiscal year.
DIS-INV-PERIOD
Element: Invoice Period
Derived
This field contains the lease invoice period.
DIS-ALLOC-CD
Element: Exp Alloc Code
Alpha 12
DIS-TAX-POINT
Element: All Flag
Alpha 1
DIS-TAX-INDICATOR
Element: Tax Indicator
Numeric 1
DIS-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
DIS-TAX-TYPE
Element: Tax Type
Alpha 1
The type of tax.
DIS-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
DIS-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
Charge rate by month.
DIS-TRAN-TAXABLE
Element: Intl Amt
Signed 18.2
DIS-TAX-LANDED-FL
Element: All Flag
Alpha 1


LMDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DISSET1 COMPANY
PMT-VENDOR
LEASE
PMT-NBR
CANCEL-SEQ
DIST-SEQ-NBR
AP30.4
DISSET2 COMPANY
LEASE
PMT-VENDOR
PMT-NBR
PT-COMPANY
ACCT-UNIT
DIST-SEQ-NBR
KeyChange, Subset
WhereCANCEL-SEQ =Zeroes


LMDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

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


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

Home
Contact Us



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