|
|
LMLEASE FILE
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 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 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 API1.1 API2.1 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 MX123 MX500 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 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 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7 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 The company base currency.
LSE-BASE-CURR-RATE Signed 14.7
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
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 18.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 18.2
Element: Unguaranteed AThis field contains the unguarantedd
estimated fair market value of the
property at lease end.
LSE-BARG-PURCH-AMT Signed 18.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 18.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 18.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 18.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 18.2
Element: Land Value This field contains the fair market
value of any land included in the lease.
LSE-BLDG-VALUE Signed 18.2
Element: Building ValueThis field contains the fair market
value of any buildings included in the
lease.
LSE-TAX-CREDIT-AMT Signed 18.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 18.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.
Valid account category types are:
cost
revenue
accrual
pass thru
LSE-BASE-GUAR-AMT Signed 18.2
Guaranteed Amt Base The guaranteed amount in base company
Currency currency.
LSE-BASE-UNGAR-AMT Signed 18.2
Unguaranteed Amt The unguaranteed amount in base company
Base Currency currency.
LSE-BASE-BARG-AMT Signed 18.2
Bargain Purchase The bargain amount in base company
Amt Base Curr currency.
LSE-BASE-NET-VALUE Signed 18.2
Net Value Base The net value in base company currency.
Currency
LSE-BASE-MKT-VALUE Signed 18.2
Fair Market Value The fair market value in base company
Base Curr currency.
LSE-BASE-LSE-OBLIG Signed 18.2
Lease Obligation The lease obligation in base company
Base Currency currency.
LSE-BASE-LAND-VAL Signed 18.2
Land Value Base The land value in base company currency.
Currency
LSE-BASE-BLDG-VAL Signed 18.2
Building Value Base The building value in base company
Currency currency.
LSE-BASE-TX-CREDIT Signed 18.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.
LSE-DEF-COMPANY Numeric 4
Element: Company 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 Alpha 15
Element: Acct Unit 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 Numeric 6
Element: Account 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 Numeric 4
Element: Sub Acct 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 Signed 18.2
Element: Intl Amt
LSE-DEF-RNT-OVRD Alpha 1
Element: Flag
LSE-ALLOC-CD Alpha 12
Element: Exp Alloc Code
LSE-ALLOC-CD-TYPE Alpha 1
Element: Alloc Cd Type E = Expense
I = Interest
LSE-ACC-COMPANY Numeric 4
Element: Company 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 Alpha 15
Element: Acct Unit 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 Numeric 6
Element: Account 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 Numeric 4
Element: Sub Acct 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 Signed 18.2
Element: Intl Amt
LSE-BASE-DOWN-PMNT Signed 18.2
Element: Intl Amt
LSE-SEC-DEPOSIT Signed 18.2
Element: Intl Amt
LSE-BASE-SEC-DEPST Signed 18.2
Element: Intl Amt
LSE-INV-PREFIX Alpha 16
Element: Inv Prefix
LMLEASE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LSESET1 COMPANY AC160 AM115
LEASE AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 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
AM220 AM221
...
LSESET2 LEASE-TYPE KeyChange
COMPANY
LEASE
LSESET3 OBJ-ID KeyChange MX123 MX202
MX223 MX500
LSESET6 LEASE MX123 MX500
COMPANY
LSESET7 ALLOC-CD KeyChange
STATUS
COMPANY
LEASE
LMLEASE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 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
Lmtrans LMTRANS
LSE-COMPANY -> LMT-COMPANY
LSE-LEASE -> LMT-LEASE
LMT-SEQ-NBR
|
