Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LMDISTRIB


                             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