|
|
LMDISTRIB FILE
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
Sequence Number
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-INT-COMPANY Numeric 4
Interest Expense This is the company to which interest
Company expense is posted.
DIS-INT-ACCT-UNIT Alpha 15
Interest Exp This is the accounting unit to which
Accounting Unit intererest expense is posted.
DIS-INT-ACCOUNT Numeric 6
Interest Expense This is the account to which interest
Account expense is posted.
DIS-INT-SUB-ACCT Numeric 4
Interest Expense This is the sibaccount to which interest
Subaccount expense is poted.
DIS-INT-ACTIVITY Alpha 15
Interest Expense This is the activity that keeps track of
Activity inteest expenses.
DIS-INT-ACCT-CAT Alpha 5
Interest Expense This is the account category that keeps
Acct Category track of interest expenses.
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 15.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-PRINCIPAL-AMT Signed 15.2
Lease Currency This is the principal portion of the
Principal Amt payment in lease currency.
DIS-INTEREST-AMT Signed 15.2
Lease Currency This is the interest portion of the
Interest Amount payment in lease currency.
DIS-ORIG-BASE-AMT Signed 15.2
Base Currency This the total payment amount in company
Distrib Amount base currency.
DIS-BASE-PRINC-AMT Signed 15.2
Base Currency This is the principal payment amount in
Principal Amount company base currency.
DIS-BASE-INT-AMT Signed 15.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 12.6
Debt Co Currency This is the debt company currency
Exchange Rate exchange rate.
DIS-TO-BASE-AMT Signed 15.2
Debt Co Currency This is the payment amount in debt
Paymt Amount company currency.
DIS-TO-BASE-PRINC Signed 15.2
Debt Co Currency This is the principal payment amount in
Principal Amt debt company currency.
DIS-TO-BASE-INT Signed 15.2
Interst Co Currncy This is the interest amount in the
Intest Amt interest company base currency.
DIS-TO-BSE-INT-CUR Alpha 5
Interest Company This is the base currency of the company
Base Currency to which interest expense is posted.
DIS-TO-BSE-INT-ND Numeric 2
Element: Number of DeciThis is the number of decimal positions
defined for interest currency
conversions.
DIS-TO-BSE-INT-RAT Signed 12.6
Interest Co This is the currency exchange rate for
Exchange Rate the interest 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-GLT-INT-OBJ-ID Numeric 12
Interest Amount This the object ID used to driall around
Object ID through interest 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.
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
DISSET3 COMPANY KeyChange, Subset
LEASE Where (EXEC-CODE != Spaces )
PMT-VENDOR And (CANCEL-SEQ = Zeroes )
PMT-NBR
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
|
