Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LMDISTRIB


                             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 6
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 6
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           An automatically assigned sequence
Sequence Number        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-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

DIS-TAX-POINT          Alpha 1
Element: All Flag

DIS-TAX-INDICATOR      Numeric 1
Element: Tax Indicator

DIS-TAX-USAGE-CD       Alpha 10
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

DIS-TAX-TYPE           Alpha 1
Element: Tax Type      The type of tax.

DIS-TAX-CODE           Alpha 10
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


DIS-TAX-RATE           Percent 7.5  (Percent)
Element: Chrg Rate     Charge rate by month.

DIS-TRAN-TAXABLE       Signed 18.2
Element: Intl Amt

DIS-TAX-LANDED-FL      Alpha 1
Element: All Flag

                         LMDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DISSET1   COMPANY                                                AP30.4
          PMT-VENDOR
          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