|
|
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
|
