Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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    AM35.1    AM40.1
AM40.2    AM40.3    AM40.4    AM41.1    AM41.2    AM45.1
AM500     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    AM98.1    MX123     MX202     MX223

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LSE-COMPANY          Numeric 4
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
Lease                This field contains the lease ID
                     defined on LM21.1 (Lease).

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

LSE-STATUS           Numeric 1
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
Lease Classification This 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
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
Lease Currency Code  This 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
Base Currency        The company base currency.

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

LSE-BASE-ND          Numeric 1
Base Currency Nbr    The number of decimal positions defined
of Decimals          for the company base currency.

LSE-SIMULATED        Alpha 1
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)
Lease Beginning Date This field contains the date on which
                     the lease begins.

LSE-END-DATE         Numeric 8  (yyyymmdd)
Lease End Date       This 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
Ownership Status     This 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
Guaranteed Amount    This 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
Unguaranteed Amount  This 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
Net Present Value    This field contains the net present
                     value of the lease amount.  Calculated
                     by the FAS13 test.

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

LSE-LEASE-OBLIG      Signed 15.2
Lease Obligation     This lease contains the total lease
                     obligation.

LSE-LAND-ONLY-FLAG   Alpha 1
Land Only Flag       This 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
Land Value           This field contains the fair market
                     value of any land included in the lease.

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

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

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

LSE-REMAINING-LIFE   Numeric 4
Asset Remaining Life This field contains the remaining life
                     of the leased property expressed as a
                     number of periods.

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

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

LSE-PMTS-PER-YEAR    Numeric 2
Payments per Year    This field contains the number of lease
                     payments per year.

LSE-PMT-TIMING       Alpha 1
Payment Timing       This 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
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)
First Payment Date   This field contains the date of the
                     first lease payment.

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

LSE-LAST-PMT-AMT     Signed 15.2
Last Payment Amount  This field contains the amount of the
                     most recent payment posted.

LSE-SEGMENT-FLAG     Alpha 1
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
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)
Last Test Run Date   This field contains the date when the
                     FAS13 test was last run.

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

LSE-TEST-7A          Alpha 1
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
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
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
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
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
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
Account Category     Account 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
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
Debt Accounting Unit If 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
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
Debt Subaccount      If 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
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
Interest Company     If 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
Interest Account     If the lease is classified as Capital,
                     this field contains the account to which
                     the interest  expense is posted.

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

LSE-INT-ACTIVITY     Alpha 15
Interest Activity    This 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