LMLEASE

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
AC160 AM115 AM117 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM154 AM155
AM170 AM19.1 AM19.2 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 AM22.1
AM22.2 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 AM502 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 AM92.1
AM93.1 AM95.1 AM95.4 AM95.5 AM95.6 AM96.1
AM97.1 AM98.1 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
MX123 MX500 MA126 MA180 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 MX202 MX223

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
LSE-ACTUAL-DAYS
Element: Flag
Alpha 1


LMLEASE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LSESET1 COMPANY
LEASE
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
AM170 AM19.1
AM19.2 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 AM22.1
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


LMLEASE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


LMLEASE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Lmtrans LMTRANS
LSE-COMPANY->LMT-COMPANY
LSE-LEASE->LMT-LEASE
  LMT-SEQ-NBR


File created: Thu Jun 09 02:21:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.