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

LMDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS

LMDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS

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