LMLEASE – Lease Information
- System
- LM (LM)
- Prefix
LSE- Primary key
COMPANY,LEASE- Fields
- 90
- Updated by
- 0 programs
- Referenced by
- 0 programs
LMLEASE is the Lease Information table in Lawson LM (prefix LSE). It is indexed by COMPANY, LEASE (LSESET1); alternate indexes: LSESET2, LSESET3, LSESET6 and LSESET7. It is related 1:1 to APCOMPANY, APVENMAST, CUCODES and LMLEASESEG and 1:M to AMASSET, LMINVOICE, LMLSEMXVAL, LMPAYDTL and LMTRANS. The table has 90 fields, 5 indexes and 9 documented relations.
About LMLEASE
The Lease file stores the main lease information, including information needed for the FAS13 test. This file is populated by Lease (LM21.1).
Fields (90)
Column = COBOL field name without the LSE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
LSE-COMPANY PKCOMPANY | Numeric 4 | This field contains the name of the lessor company; it must be a valid company in the Accounts Payable system. | — |
LSE-LEASE PKLEASE | Alpha 19 | This field contains the lease ID defined on LM21.1 (Lease). | — |
LSE-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the lease description defined on Lease (LM21.1). | — |
LSE-STATUSSTATUS | Numeric 1 | This field contains the status of the lease. Valid values are:
| — |
LSE-LEASE-CLASSLEASE_CLASS | Alpha 1 | 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:
| — |
LSE-LEASE-TYPELEASE_TYPE | Alpha 10 | 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-CODECURRENCY_CODE | Alpha 5 | This field contains the currency used for the lease transactions. | — |
LSE-CURR-NDCURR_ND | Numeric 1 | This field contains the number of decimals defined for the currency used in the lease transaction. | — |
LSE-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | The company base currency. | — |
LSE-BASE-CURR-RATEBASE_CURR_RATE | Signed 14.7 | — | — |
LSE-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | — |
LSE-SIMULATEDSIMULATED | Alpha 1 | 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:
| — |
LSE-BEGIN-DATEBEGIN_DATE | Numeric 8 (yyyymmdd) | This field contains the date on which the lease begins. | — |
LSE-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | This field contains the date on which the lease ends. | — |
LSE-TERMINATE-DATETERMINATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date on which a lease was closed or retired. | — |
LSE-OWNERSHIP-FLAGOWNERSHIP_FLAG | Alpha 1 | This field indicates whether lease ownership will transfer to the lessor at the end of the lease. Valid values are: If Yes, the lease class must be Capital.
| — |
LSE-GUARANTEED-AMTGUARANTEED_AMT | Signed 18.2 | This field contains the estimated fair value of the leased item at the end of the lease. Also called guaranteed residual value. | — |
LSE-UNGUARANTD-AMTUNGUARANTD_AMT | Signed 18.2 | This field contains the unguarantedd estimated fair market value of the property at lease end. | — |
LSE-BARG-PURCH-AMTBARG_PURCH_AMT | Signed 18.2 | This field contains the bargain 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-VALUENET_PRES_VALUE | Signed 18.2 | This field contains the net present value of the lease amount. Calculated by the FAS13 test. | — |
LSE-FAIR-MKT-VALUEFAIR_MKT_VALUE | Signed 18.2 | This field contains the fair market value of the leased item at the inception of the lease. | — |
LSE-LEASE-OBLIGLEASE_OBLIG | Signed 18.2 | This lease contains the total lease obligation. | — |
LSE-LAND-ONLY-FLAGLAND_ONLY_FLAG | Alpha 1 | This field indicates whether the lease involves only land. Valid values are:
| — |
LSE-LAND-BLDG-FLAGLAND_BLDG_FLAG | Alpha 1 | This field indicates whether the lease involves both land and buildings. Valid values are:
| — |
LSE-LAND-VALUELAND_VALUE | Signed 18.2 | This field contains the fair market value of any land included in the lease. | — |
LSE-BLDG-VALUEBLDG_VALUE | Signed 18.2 | This field contains the fair market value of any buildings included in the lease. | — |
LSE-TAX-CREDIT-AMTTAX_CREDIT_AMT | Signed 18.2 | This field contains the lessor's investment tax credit amount. Used in FAS13 calculations. | — |
LSE-TOTAL-LIFETOTAL_LIFE | Numeric 4 | This field contains the total life of the leased property expressed as a number of periods. | — |
LSE-REMAINING-LIFEREMAINING_LIFE | Numeric 4 | This field contains the remaining life of the leased property expressed as a number of periods. | — |
LSE-LESSORLESSOR | Alpha 9 (Right Justified) | This field contains the lessor identification. Must be a valid vendor in the Accounts Payable system. | — |
LSE-TERMTERM | Numeric 3 | This field contains the number of periods for which the property is leased. | — |
LSE-PMTS-PER-YEARPMTS_PER_YEAR | Numeric 2 | This field contains the number of lease payments per year. | — |
LSE-PMT-TIMINGPMT_TIMING | Alpha 1 | 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:
| — |
LSE-INTEREST-RATEINTEREST_RATE | Signed 7.5 | 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-RATEIMPLICIT_RATE | Signed 7.5 | This field contains the lessor's interest rate. If not known, the FAS13 test can calculate it. | — |
LSE-FIRST-PMT-DATEFIRST_PMT_DATE | Numeric 8 (yyyymmdd) | This field contains the date of the first lease payment. | — |
LSE-LAST-PMT-DATELAST_PMT_DATE | Numeric 8 (yyyymmdd) | This field contains the date of the most recent payment posted. | — |
LSE-LAST-PMT-AMTLAST_PMT_AMT | Signed 18.2 | This field contains the amount of the most recent payment posted. | — |
LSE-SEGMENT-FLAGSEGMENT_FLAG | Alpha 1 | 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:
| — |
LSE-FAS13-FLAGFAS13_FLAG | Alpha 1 | This field indicates whether an FAS13 test will be run when the lease is added or changed. Valid values are: The FAS13 test is an optional test that automates the decision to classify a lease as Capital or Operating.
| — |
LSE-LAST-RUN-DATELAST_RUN_DATE | Numeric 8 (yyyymmdd) | This field contains the date when the FAS13 test was last run. | — |
LSE-LAST-RUN-TIMELAST_RUN_TIME | Numeric 6 (hhmmss) | This field contains the time of the day when the FAS13 test was last run. | — |
LSE-TEST-7ATEST_7A | Alpha 1 | This field contains the results of FAS13 test 7A. Valid results are: If the result is Yes, the lease is classified as Capital.
| — |
LSE-TEST-7BTEST_7B | Alpha 1 | This field contains the results of FAS13 test 7B. Valid results are: If the result is Yes, the lease is classified as Capital.
| — |
LSE-TEST-7CTEST_7C | Alpha 1 | This field contains the results of FAS13 test 7C, if applicable. Valid results are: If the result is Yes, the lease is classified as Capital.
| — |
LSE-TEST-7DTEST_7D | Alpha 1 | This field contains the results of FAS13 test 7D, if applicable. Valid results are: If the result is yes, the lease is classified as Capital.
| — |
LSE-OBJ-IDOBJ_ID | Numeric 12 | 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-ACTIVITYACTIVITY | Alpha 15 | 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-CATEGORYACCT_CATEGORY | Alpha 5 | 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. Valid account category types are: cost revenue accrual pass thru | — |
LSE-BASE-GUAR-AMTBASE_GUAR_AMT | Signed 18.2 | The guaranteed amount in base company currency. | — |
LSE-BASE-UNGAR-AMTBASE_UNGAR_AMT | Signed 18.2 | The unguaranteed amount in base company currency. | — |
LSE-BASE-BARG-AMTBASE_BARG_AMT | Signed 18.2 | The bargain amount in base company currency. | — |
LSE-BASE-NET-VALUEBASE_NET_VALUE | Signed 18.2 | The net value in base company currency. | — |
LSE-BASE-MKT-VALUEBASE_MKT_VALUE | Signed 18.2 | The fair market value in base company currency. | — |
LSE-BASE-LSE-OBLIGBASE_LSE_OBLIG | Signed 18.2 | The lease obligation in base company currency. | — |
LSE-BASE-LAND-VALBASE_LAND_VAL | Signed 18.2 | The land value in base company currency. | — |
LSE-BASE-BLDG-VALBASE_BLDG_VAL | Signed 18.2 | The building value in base company currency. | — |
LSE-BASE-TX-CREDITBASE_TX_CREDIT | Signed 18.2 | The tax credit in base company currency. | — |
LSE-DEBT-COMPANYDEBT_COMPANY | Numeric 4 | 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-UNITDEBT_ACCT_UNIT | Alpha 15 | 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-ACCOUNTDEBT_ACCOUNT | Numeric 6 | 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-ACCTDEBT_SUB_ACCT | Numeric 4 | 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-ACTIVITYDEBT_ACTIVITY | Alpha 15 | This field contains the optional activity to which debt amounts may be posted. | — |
LSE-DEBT-ACCT-CATDEBT_ACCT_CAT | Alpha 5 | This field contains the account category to which debt amounts may be posted. | — |
LSE-INT-COMPANYINT_COMPANY | Numeric 4 | 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-UNITINT_ACCT_UNIT | Alpha 15 | If the lease is classified as Capital, this field contains the accounting unit to which the interest expense is posted. | — |
LSE-INT-ACCOUNTINT_ACCOUNT | Numeric 6 | If the lease is classified as Capital, this field contains the account to which the interest expense is posted. | — |
LSE-INT-SUB-ACCTINT_SUB_ACCT | Numeric 4 | If the lease is classified as Capital, this field contains the sub-account to which the interest expense is posted. | — |
LSE-INT-ACTIVITYINT_ACTIVITY | Alpha 15 | This field contains the optional activity to which interest expense may be posted. | — |
LSE-INT-ACCT-CATINT_ACCT_CAT | Alpha 5 | This field contains the optional account category to which interest expense may be posted. | — |
LSE-DRILL-INT-RATEDRILL_INT_RATE | Derived | This field contains the computed interest rate. | — |
LSE-DRILL-IMP-RATEDRILL_IMP_RATE | Derived | This field contains the computed implicit interest rate. | — |
LSE-DEF-COMPANYDEF_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
LSE-DEF-ACCT-UNITDEF_ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | — |
LSE-DEF-ACCOUNTDEF_ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | — |
LSE-DEF-SUB-ACCTDEF_SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | — |
LSE-DEF-RENT-BALDEF_RENT_BAL | Signed 18.2 | — | — |
LSE-DEF-RNT-OVRDDEF_RNT_OVRD | Alpha 1 | — | — |
LSE-ALLOC-CDALLOC_CD | Alpha 12 | — | — |
LSE-ALLOC-CD-TYPEALLOC_CD_TYPE | Alpha 1 | —
| — |
LSE-ACC-COMPANYACC_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
LSE-ACC-ACCT-UNITACC_ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | — |
LSE-ACC-ACCOUNTACC_ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | — |
LSE-ACC-SUB-ACCTACC_SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | — |
LSE-DOWN-PAYMENTDOWN_PAYMENT | Signed 18.2 | — | — |
LSE-BASE-DOWN-PMNTBASE_DOWN_PMNT | Signed 18.2 | — | — |
LSE-SEC-DEPOSITSEC_DEPOSIT | Signed 18.2 | — | — |
LSE-BASE-SEC-DEPSTBASE_SEC_DEPST | Signed 18.2 | — | — |
LSE-INV-PREFIXINV_PREFIX | Alpha 16 | — | — |
LSE-ACTUAL-DAYSACTUAL_DAYS | Alpha 1 | — | — |
Indexes (5)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
LSESET1 | COMPANY, LEASE | Primary | AC160, AM115, AM117, AM125, AM135, AM145, AM15.1, AM15.2 +22 more (list truncated in source) | |
LSESET2 | LEASE-TYPE, COMPANY, LEASE | KeyChange | — | |
LSESET3 | OBJ-ID | KeyChange | MX123, MX202, MX223, MX500 | |
LSESET6 | LEASE, COMPANY | MX123, MX500 | ||
LSESET7 | ALLOC-CD, STATUS, COMPANY, LEASE | KeyChange | — |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apcompany | APCOMPANY | Required | LSE-COMPANY → CPY-COMPANY (CPYSET1) | |
| 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 |
One to many (5) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | ||
| Lmtrans | LMTRANS | LSE-COMPANY → LMT-COMPANY, LSE-LEASE → LMT-LEASE, LMT-SEQ-NBR |
Programs
No Lawson programs are documented as updating or referencing this table.