Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

LMLEASE


                              LMLEASE FILE

The Lease file stores the main lease information, including information
needed for the FAS13 test. This file is populated by Lease (LM21.1).

REFERENCED BY

AM115     AM125     AM135     AM145     AM15.1    AM15.2
AM15.3    AM15.4    AM154     AM170     AM190     AM192
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM21.1    AM21.2    AM21.3    AM21.4    AM21.5    AM21.6
AM220     AM221     AM222     AM223     AM225     AM230
AM235     AM240     AM245     AM250     AM255     AM260
AM265     AM267     AM275     AM278     AM280     AM281
AM287     AM30.1    AM30.2    AM30.3    AM330     AM35.1
AM40.1    AM40.2    AM40.3    AM40.4    AM41.1    AM41.2
AM45.1    AM500     AM51.1    AM551     AM70.1    AM75.1
AM80.1    AM85.1    AM88.7    AM90.1    AM90.4    AM90.5
AM91.1    AM91.4    AM91.5    AM93.1    AM95.1    AM95.4
AM95.5    AM95.6    AM96.1    AM97.1    AM98.1    MX123
MX202     MX223

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LSE-COMPANY            Numeric 4
Element: Company       This field contains the name of the
                       lessor company; it must be a valid
                       company in the Accounts Payable system.

LSE-LEASE              Alpha 19
Element: Lease         This field contains the lease ID
                       defined on LM21.1 (Lease).

LSE-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field contains the lease
                       description defined on Lease (LM21.1).

LSE-STATUS             Numeric 1
Element: Status        This field contains the status of the
                       lease. Valid values are:
                       0 = Unreleased
                       1 = Released
                       2 = Closed
                       9 = Retired

LSE-LEASE-CLASS        Alpha 1
Element: Lease ClassifiThis field contains the lease
                       classification. An operating lease is
                       processed as an expense; a capital lease
                       is processed as an asset. You can enter
                       the classification or let the FAS13 test
                       supply it automatically. Valid values
                       are:
                       O = Operating
                       C = Capital

LSE-LEASE-TYPE         Alpha 10
Element: Lease Type    This field contains the user-defined
                       lease type, defined on Lease Types
                       (LM06.1). Types are classifications
                       created by the users for reporting
                       purposes only. For example, EQUIPMENT,
                       or VEHICLES.

LSE-CURRENCY-CODE      Alpha 5
Element: Lease CurrencyThis field contains the currency used
                       for the lease transactions.

LSE-CURR-ND            Numeric 1
Currency Lease Nbr     This field contains the number of
of Decimals            decimals defined for the currency used
                       in the lease transaction.

LSE-BASE-CURRENCY      Alpha 5
Element: Base Currency

LSE-BASE-CURR-RATE     Signed 12.6
Base Currency
Exchange Rate

LSE-BASE-ND            Numeric 1
Base Currency Nbr
of Decimals

LSE-SIMULATED          Alpha 1
Element: Simulated     This field specifies whether the lease
                       is simulated or real. Simulated leases
                       can be used to run various lease
                       scenarios without impacting the books.
                       Valid values are:
                       Y = Yes
                       N = No

LSE-BEGIN-DATE         Numeric 8  (yyyymmdd)
Element: Lease BeginninThis field contains the date on which
                       the lease begins.

LSE-END-DATE           Numeric 8  (yyyymmdd)
Element: Lease End DateThis field contains the date on which
                       the lease ends.

LSE-TERMINATE-DATE     Numeric 8  (yyyymmdd)
Lease Termination      This field contains the date on which a
Date                   lease was closed or retired.

LSE-OWNERSHIP-FLAG     Alpha 1
Element: Ownership StatThis field indicates whether lease
                       ownership will transfer to the lessor at
                       the end of the lease. Valid  values are:
                       Y = Yes
                       N = No
                       If Yes, the lease class must be Capital.

LSE-GUARANTEED-AMT     Signed 15.2
Element: Guaranteed AmoThis field contains the estimated fair
                       value of the leased item at the end of
                       the lease. Also called guaranteed
                       residual value.

LSE-UNGUARANTD-AMT     Signed 15.2
Element: Unguaranteed AThis field contains the unguarantedd
                       estimated fair market value of the
                       property at lease end.

LSE-BARG-PURCH-AMT     Signed 15.2
Bargain Purchase       This field contains the bargain
Amount                 purchase amount. That is the amount a
                       lessor would pay to purchase the amount
                       at the end of the lease if a bargain
                       purchase option is included in the
                       lease. If this amount is not zero, the
                       lease type must be Capital.

LSE-NET-PRES-VALUE     Signed 15.2
Element: Net Present VaThis field contains the net present
                       value of the lease amount.  Calculated
                       by the FAS13 test.

LSE-FAIR-MKT-VALUE     Signed 15.2
Element: Fair market VaThis field contains the fair market
                       value of the leased item at the
                       inception of the lease.

LSE-LEASE-OBLIG        Signed 15.2
Element: Lease ObligatiThis lease contains the total lease
                       obligation.

LSE-LAND-ONLY-FLAG     Alpha 1
Element: Land Only FlagThis field indicates whether the lease
                       involves only land. Valid values are:
                       Y = Yes
                       N = No

LSE-LAND-BLDG-FLAG     Alpha 1
Land and Building      This field indicates whether the lease
Flag                   involves both land and buildings. Valid
                       values are:
                       Y = Yes
                       N = No

LSE-LAND-VALUE         Signed 15.2
Element: Land Value    This field contains the fair market
                       value of any land included in the lease.

LSE-BLDG-VALUE         Signed 15.2
Element: Building ValueThis field contains the fair market
                       value of any buildings included in the
                       lease.

LSE-TAX-CREDIT-AMT     Signed 15.2
Element: Tax Credit AmoThis field contains the lessor's
                       investment tax credit amount. Used in
                       FAS13 calculations.

LSE-TOTAL-LIFE         Numeric 4
Element: Total Asset LiThis field contains the total life of
                       the leased property expressed as a
                       number of periods.

LSE-REMAINING-LIFE     Numeric 4
Element: Asset RemaininThis field contains the remaining life
                       of the leased property expressed as a
                       number of periods.

LSE-LESSOR             Alpha 9  (Right Justified)
Element: Lessor        This field contains the lessor
                       identification.  Must be a valid vendor
                       in the Accounts Payable system.

LSE-TERM               Numeric 3
Element: Lease Terms   This field contains the number of
                       periods for which the property is
                       leased.

LSE-PMTS-PER-YEAR      Numeric 2
Element: Payments per YThis field contains the number of lease
                       payments per year.

LSE-PMT-TIMING         Alpha 1
Element: Payment TimingThis field indicates whether payments
                       are made at the beginning or the end of
                       a lease period. This information is
                       required for the FAS test. Valid values
                       are:
                       B = Beginning of Period
                       E = End of Period

LSE-INTEREST-RATE      Signed 7.5
Element: Interest Rate This field contains the lessee's
                       interest rate. Also known as the
                       incremental borrowing rate. This is the
                       interest rate the lessee would pay if
                       borrowing the money to finance the
                       lease.

LSE-IMPLICIT-RATE      Signed 7.5
Implicit Interest      This field contains the lessor's
Rate                   interest rate. If not known, the FAS13
                       test can calculate it.

LSE-FIRST-PMT-DATE     Numeric 8  (yyyymmdd)
Element: First Payment This field contains the date of the
                       first lease payment.

LSE-LAST-PMT-DATE      Numeric 8  (yyyymmdd)
Element: Last Payment DThis field contains the date of the
                       most recent payment posted.

LSE-LAST-PMT-AMT       Signed 15.2
Element: Last Payment AThis field contains the amount of the
                       most recent payment posted.

LSE-SEGMENT-FLAG       Alpha 1
Element: Segment Flag  This field indicates whether a user
                       analysis value is associated with the
                       lease. User analysis values are used by
                       the Strategic Ledger system to provide
                       online profitability analysis. Valid
                       values are:
                       Y = Yes
                       N = No

LSE-FAS13-FLAG         Alpha 1
Element: FAS 13 Flag   This field indicates whether an FAS13
                       test will be run when the lease is added
                       or changed. Valid values are:
                       Y = Yes
                       N = No
                       The FAS13 test is an optional test that
                       automates the decision to classify a
                       lease as Capital or Operating.

LSE-LAST-RUN-DATE      Numeric 8  (yyyymmdd)
Element: Last Test Run This field contains the date when the
                       FAS13 test was last run.

LSE-LAST-RUN-TIME      Numeric 6  (hhmmss)
Element: Last Test Run This field contains the time of the day
                       when the FAS13 test was last run.

LSE-TEST-7A            Alpha 1
Element: Test 7A       This field contains the results of
                       FAS13 test 7A. Valid results are:
                       Y = Yes
                       N = No
                       If the result is Yes, the lease is
                       classified as Capital.

LSE-TEST-7B            Alpha 1
Element: Test 7B       This field contains the results of
                       FAS13 test 7B. Valid results are:
                       Y = Yes
                       N = No
                       If the result is Yes, the lease is
                       classified as Capital.

LSE-TEST-7C            Alpha 1
Element: Test 7C       This field contains the results of FAS13
                       test 7C, if applicable. Valid results
                       are:
                       Y = Yes
                       N = No
                       A = not Applicable
                       If the result is Yes, the lease is
                       classified as Capital.

LSE-TEST-7D            Alpha 1
Element: Test 7D       This field contains the results of FAS13
                       test 7D, if applicable. Valid results
                       are:
                       Y = Yes
                       N = No
                       A = Not Applicable
                       If the result is yes, the lease is
                       classified as Capital.

LSE-OBJ-ID             Numeric 12
Element: Object ID     This is the object identifier. It is
                       used to relate Activity Management
                       commitments or posted transactions back
                       to the Lease Management system. Each
                       Lease Management transaction is assigned
                       an object identifier. The object
                       identifier is a unique key used to
                       create Drill Around links between
                       Activity Management and Lease
                       Management.

LSE-ACTIVITY           Alpha 15
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


LSE-ACCT-CATEGORY      Alpha 5
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

LSE-BASE-GUAR-AMT      Signed 15.2
Guaranteed Amt Base    The guaranteed amount in base company
Currency               currency.

LSE-BASE-UNGAR-AMT     Signed 15.2
Unguaranteed Amt       The unguaranteed amount in base company
Base Currency          currency.

LSE-BASE-BARG-AMT      Signed 15.2
Bargain Purchase       The bargain amount in base company
Amt Base Curr          currency.

LSE-BASE-NET-VALUE     Signed 15.2
Net Value Base         The net value in base company currency.
Currency

LSE-BASE-MKT-VALUE     Signed 15.2
Fair Market Value      The fair market value in base company
Base Curr              currency.

LSE-BASE-LSE-OBLIG     Signed 15.2
Lease Obligation       The lease obligation in base company
Base Currency          currency.

LSE-BASE-LAND-VAL      Signed 15.2
Land Value Base        The land value in base company currency.
Currency

LSE-BASE-BLDG-VAL      Signed 15.2
Building Value Base    The building value in base company
Currency               currency.

LSE-BASE-TX-CREDIT     Signed 15.2
Tax Credit Base        The tax credit in base company currency.
Currency

LSE-DEBT-COMPANY       Numeric 4
Element: Debt Company  If the lease is classified as Capital,
                       this field contains the  company to
                       which the capital debt is posted.

                       If the lease is classified as
                       Operating, this field contains the
                       company to which the operating expense
                       is posted.

                       If no company is specified, the
                       lessor's Accounts Payable company is
                       assumed.

LSE-DEBT-ACCT-UNIT     Alpha 15
Element: Debt AccountinIf the lease is classified as Capital,
                       this field contains the accounting unit
                       to which the capital debt is posted.

                       If the lease is classified as
                       Operating, this field contains the
                       accounting unit to which the operating
                       expense is posted.

LSE-DEBT-ACCOUNT       Numeric 6
Element: Debt Account  If the lease is classified as Capital,
                       this field contains the account to which
                       the capital debt is posted.

                       If the lease is classified as
                       Operating, this field contains the
                       account to which the operating expense
                       is posted.

LSE-DEBT-SUB-ACCT      Numeric 4
Element: Debt SubaccounIf the lease is classified as Capital,
                       this field contains the sub-account to
                       which the capital debt is posted.

                       If the lease is classified as
                       Operating, this field contains the
                       sub-account to which the operating
                       expense is posted.

LSE-DEBT-ACTIVITY      Alpha 15
Element: Debt Activity This field contains the optional
                       activity to which debt amounts may be
                       posted.

LSE-DEBT-ACCT-CAT      Alpha 5
Debt Account           This field contains the account category
Category               to which debt amounts may be posted.

LSE-INT-COMPANY        Numeric 4
Element: Interest CompaIf the lease is classified as Capital,
                       this field contains the company to which
                       the interest expense is posted.

                       If no company is specified, the
                       lessor's Accounts Payable company is
                       assumed.

LSE-INT-ACCT-UNIT      Alpha 15
Interest Accounting    If the lease is classified as Capital,
Unit                   this field contains the accounting unit
                       to which the interest  expense is
                       posted.

LSE-INT-ACCOUNT        Numeric 6
Element: Interest AccouIf the lease is classified as Capital,
                       this field contains the account to which
                       the interest  expense is posted.

LSE-INT-SUB-ACCT       Numeric 4
Element: Interest SubacIf the lease is classified as Capital,
                       this field contains the sub-account to
                       which the interest expense is posted.

LSE-INT-ACTIVITY       Alpha 15
Element: Interest ActivThis field contains the optional
                       activity to which interest expense may
                       be posted.

LSE-INT-ACCT-CAT       Alpha 5
Interest Account       This field contains the optional account
Category               category to which interest expense may
                       be posted.

LSE-DRILL-INT-RATE     Derived
Computed Interest      This field contains the computed
Rate                   interest rate.

LSE-DRILL-IMP-RATE     Derived
Computed Implicit      This field contains the computed
Interst Rate           implicit interest rate.

                         LMLEASE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LSESET1   COMPANY       This index retrieves lease records by    AM115   AM125
          LEASE         company ID and lease ID.                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM220   AM221
                                                                 AM222   AM223
                                                                 AM225   AM230
                                                                 ...

LSESET2   LEASE-TYPE    This index retrieves lease records by
          COMPANY       lease type, company ID, and lease ID.
          LEASE         KeyChange

LSESET3   OBJ-ID        This index retrieves lease records by    MX123   MX202
                        Object ID, Company ID, and Lease ID.     MX223
                        KeyChange

LSESET4   COMPANY       This index retrieves lease records by
          END-DATE      debt posting company and account, lease
          LESSOR        company, and lease ID.
          LEASE         KeyChange

LSESET6   LEASE                                                  MX123
          COMPANY

                         LMLEASE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            LSE-COMPANY          -> CPY-COMPANY

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            LSE-LESSOR           -> VEN-VENDOR

Cucodes        CUCODES      Required

                            LSE-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Lmleaseseg     LMLEASESEG   Not Required

                            LSE-OBJ-ID           -> LSG-OBJ-ID

                         LMLEASE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET

                            LSE-COMPANY          -> AST-LEASE-COMPANY
                            LSE-LEASE            -> AST-LEASE
                                                    AST-ASSET

Lminvoice      LMINVOICE

                            LSE-COMPANY          -> INV-COMPANY
                            LSE-LEASE            -> INV-LEASE
                                                    INV-PMT-NBR
                                                    INV-PMT-VENDOR
                                                    INV-CANCEL-SEQ

Lmlsemxval     LMLSEMXVAL

                            LSE-OBJ-ID           -> LXV-OBJ-ID
                                                    LXV-MATRIX-CAT

Lmpaydtl       LMPAYDTL

                            LSE-COMPANY          -> LPD-COMPANY
                            LSE-LEASE            -> LPD-LEASE
                                                    LPD-PMT-VENDOR
                                                    LPD-PMT-NBR
                                                    LPD-EXEC-CODE