Lease Information
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
| MX123 | MX500 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
|---|---|---|---|
| LSE-COMPANY Element: Company | Numeric 4 This field contains the name of the lessor company; it must be a valid company in the Accounts Payable system. |
|
|
| LSE-LEASE Element: Lease | Alpha 19 This field contains the lease ID defined on LM21.1 (Lease). |
|
|
| LSE-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the lease description defined on Lease (LM21.1). |
|
|
| LSE-STATUS Element: Status | Numeric 1 This field contains the status of the lease. Valid values are: 0 = Unreleased 1 = Released 2 = Closed 9 = Retired |
|
|
| LSE-LEASE-CLASS Element: Lease Classification | 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: O = Operating C = Capital |
|
|
| LSE-LEASE-TYPE Element: Lease 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-CODE Element: Lease Currency Code | Alpha 5 This field contains the currency used for the lease transactions. |
|
|
| LSE-CURR-ND Currency Lease Nbr of Decimals | Numeric 1 This field contains the number of decimals defined for the currency used in the lease transaction. |
|
|
| LSE-BASE-CURRENCY Element: Base Currency | Alpha 5 The company base currency. |
|
|
| LSE-BASE-CURR-RATE Base Currency Exchange Rate | Signed 14.7 |
|
|
| LSE-BASE-ND Base Currency Nbr of Decimals | Numeric 1 The number of decimal positions defined for the company base currency. |
|
|
| LSE-SIMULATED Element: Simulated | 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: Y = Yes N = No |
|
|
| LSE-BEGIN-DATE Element: Lease Beginning Date | Numeric 8 (yyyymmdd) This field contains the date on which the lease begins. |
|
|
| LSE-END-DATE Element: Lease End Date | Numeric 8 (yyyymmdd) This field contains the date on which the lease ends. |
|
|
| LSE-TERMINATE-DATE Lease Termination Date | Numeric 8 (yyyymmdd) This field contains the date on which a lease was closed or retired. |
|
|
| LSE-OWNERSHIP-FLAG Element: Ownership Status | Alpha 1 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 Element: Guaranteed Amount | 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-AMT Element: Unguaranteed Amount | Signed 18.2 This field contains the unguarantedd estimated fair market value of the property at lease end. |
|
|
| LSE-BARG-PURCH-AMT Bargain Purchase Amount | 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-VALUE Element: Net Present Value | Signed 18.2 This field contains the net present value of the lease amount. Calculated by the FAS13 test. |
|
|
| LSE-FAIR-MKT-VALUE Element: Fair market Value | Signed 18.2 This field contains the fair market value of the leased item at the inception of the lease. |
|
|
| LSE-LEASE-OBLIG Element: Lease Obligation | Signed 18.2 This lease contains the total lease obligation. |
|
|
| LSE-LAND-ONLY-FLAG Element: Land Only Flag | Alpha 1 This field indicates whether the lease involves only land. Valid values are: Y = Yes N = No |
|
|
| LSE-LAND-BLDG-FLAG Land and Building Flag | Alpha 1 This field indicates whether the lease involves both land and buildings. Valid values are: Y = Yes N = No |
|
|
| LSE-LAND-VALUE Element: Land Value | Signed 18.2 This field contains the fair market value of any land included in the lease. |
|
|
| LSE-BLDG-VALUE Element: Building Value | Signed 18.2 This field contains the fair market value of any buildings included in the lease. |
|
|
| LSE-TAX-CREDIT-AMT Element: Tax Credit Amount | Signed 18.2 This field contains the lessor's investment tax credit amount. Used in FAS13 calculations. |
|
|
| LSE-TOTAL-LIFE Element: Total Asset Life | Numeric 4 This field contains the total life of the leased property expressed as a number of periods. |
|
|
| LSE-REMAINING-LIFE Element: Asset Remaining Life | Numeric 4 This field contains the remaining life of the leased property expressed as a number of periods. |
|
|
| LSE-LESSOR Element: Lessor | Alpha 9 (Right Justified) This field contains the lessor identification. Must be a valid vendor in the Accounts Payable system. |
|
|
| LSE-TERM Element: Lease Terms | Numeric 3 This field contains the number of periods for which the property is leased. |
|
|
| LSE-PMTS-PER-YEAR Element: Payments per Year | Numeric 2 This field contains the number of lease payments per year. |
|
|
| LSE-PMT-TIMING Element: Payment 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: B = Beginning of Period E = End of Period |
|
|
| LSE-INTEREST-RATE Element: Interest 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-RATE Implicit Interest Rate | Signed 7.5 This field contains the lessor's interest rate. If not known, the FAS13 test can calculate it. |
|
|
| LSE-FIRST-PMT-DATE Element: First Payment Date | Numeric 8 (yyyymmdd) This field contains the date of the first lease payment. |
|
|
| LSE-LAST-PMT-DATE Element: Last Payment Date | Numeric 8 (yyyymmdd) This field contains the date of the most recent payment posted. |
|
|
| LSE-LAST-PMT-AMT Element: Last Payment Amount | Signed 18.2 This field contains the amount of the most recent payment posted. |
|
|
| LSE-SEGMENT-FLAG Element: Segment 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: Y = Yes N = No |
|
|
| LSE-FAS13-FLAG Element: FAS 13 Flag | Alpha 1 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 Element: Last Test Run Date | Numeric 8 (yyyymmdd) This field contains the date when the FAS13 test was last run. |
|
|
| LSE-LAST-RUN-TIME Element: Last Test Run Time | Numeric 6 (hhmmss) This field contains the time of the day when the FAS13 test was last run. |
|
|
| LSE-TEST-7A Element: Test 7A | Alpha 1 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 Element: Test 7B | Alpha 1 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 Element: Test 7C | Alpha 1 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 Element: Test 7D | Alpha 1 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 Element: Object 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-ACTIVITY Element: Activity | 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-CATEGORY Element: Account 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-AMT Guaranteed Amt Base Currency | Signed 18.2 The guaranteed amount in base company currency. |
|
|
| LSE-BASE-UNGAR-AMT Unguaranteed Amt Base Currency | Signed 18.2 The unguaranteed amount in base company currency. |
|
|
| LSE-BASE-BARG-AMT Bargain Purchase Amt Base Curr | Signed 18.2 The bargain amount in base company currency. |
|
|
| LSE-BASE-NET-VALUE Net Value Base Currency | Signed 18.2 The net value in base company currency. |
|
|
| LSE-BASE-MKT-VALUE Fair Market Value Base Curr | Signed 18.2 The fair market value in base company currency. |
|
|
| LSE-BASE-LSE-OBLIG Lease Obligation Base Currency | Signed 18.2 The lease obligation in base company currency. |
|
|
| LSE-BASE-LAND-VAL Land Value Base Currency | Signed 18.2 The land value in base company currency. |
|
|
| LSE-BASE-BLDG-VAL Building Value Base Currency | Signed 18.2 The building value in base company currency. |
|
|
| LSE-BASE-TX-CREDIT Tax Credit Base Currency | Signed 18.2 The tax credit in base company currency. |
|
|
| LSE-DEBT-COMPANY Element: Debt 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-UNIT Element: Debt Accounting 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-ACCOUNT Element: Debt 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-ACCT Element: Debt Subaccount | 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-ACTIVITY Element: Debt Activity | Alpha 15 This field contains the optional activity to which debt amounts may be posted. |
|
|
| LSE-DEBT-ACCT-CAT Debt Account Category | Alpha 5 This field contains the account category to which debt amounts may be posted. |
|
|
| LSE-INT-COMPANY Element: Interest 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-UNIT Interest Accounting 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-ACCOUNT Element: Interest 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-ACCT Element: Interest Subaccount | Numeric 4 If the lease is classified as Capital, this field contains the sub-account to which the interest expense is posted. |
|
|
| LSE-INT-ACTIVITY Element: Interest Activity | Alpha 15 This field contains the optional activity to which interest expense may be posted. |
|
|
| LSE-INT-ACCT-CAT Interest Account Category | Alpha 5 This field contains the optional account category to which interest expense may be posted. |
|
|
| LSE-DRILL-INT-RATE Computed Interest Rate | Derived This field contains the computed interest rate. |
|
|
| LSE-DRILL-IMP-RATE Computed Implicit Interst Rate | Derived This field contains the computed implicit interest rate. |
|
|
| LSE-DEF-COMPANY Element: 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-UNIT Element: 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-ACCOUNT Element: 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-ACCT Element: 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-BAL Element: Intl Amt | Signed 18.2 |
|
|
| LSE-DEF-RNT-OVRD Element: Flag | Alpha 1 |
|
|
| LSE-ALLOC-CD Element: Exp Alloc Code | Alpha 12 |
|
|
| LSE-ALLOC-CD-TYPE Element: Alloc Cd Type | Alpha 1 E = Expense I = Interest |
|
|
| LSE-ACC-COMPANY Element: 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-UNIT Element: 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-ACCOUNT Element: 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-ACCT Element: 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-PAYMENT Element: Intl Amt | Signed 18.2 |
|
|
| LSE-BASE-DOWN-PMNT Element: Intl Amt | Signed 18.2 |
|
|
| LSE-SEC-DEPOSIT Element: Intl Amt | Signed 18.2 |
|
|
| LSE-BASE-SEC-DEPST Element: Intl Amt | Signed 18.2 |
|
|
| LSE-INV-PREFIX Element: Inv Prefix | Alpha 16 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LSESET1 |
COMPANY LEASE |
|
|||||||||||
| LSESET2 |
LEASE-TYPE COMPANY LEASE |
|
|||||||||||
| LSESET3 |
OBJ-ID |
|
| ||||||||||
| LSESET6 |
LEASE COMPANY |
|
| ||||||||||
| LSESET7 |
ALLOC-CD STATUS COMPANY LEASE |
|
|||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY |
Required
| ||||||
| Apvenmast | APVENMAST |
Required
| ||||||
| Cucodes | CUCODES |
Required
| ||||||
| Lmleaseseg | LMLEASESEG |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amasset | AMASSET |
| |||||||||||||||
| Lminvoice | LMINVOICE |
| |||||||||||||||
| Lmlsemxval | LMLSEMXVAL |
| |||||||||||||||
| Lmpaydtl | LMPAYDTL |
| |||||||||||||||
| Lmtrans | LMTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.