A

Schedule Number

Unique identifier for a lease

Alphanumeric (1000)

Y

Y

B

Lease Start Date

The commencement date or takedown date. The date when the duration of the lease starts and therefore the payment schedule begins.

MM/DD/YYYY

Y

Y

C

Ledger

The set of books to which a schedule should be recorded. This may be one configured ledger or a list.

Must exactly match to configured list. See UI - Settings:  Ledger Name. 

Alphanumeric (100); multiple separated by comma

N

Y

D

Ledger Date

The date that transaction becomes known and should be recognized from an accounting perspective. If blank, lease will be recognized and accounting will start in the fiscal month containing the earlier of the Lease Start Date and current date.

MM/DD/YYYY

N

Y

E

Currency

Currency that lease financials are transacted in.

See Data Validation Below

Drop-down

Y

Y

F

Comments

Deal Level Comments. Comments will appear in Deal Summary, Details tile in UI.

Alphanumeric (2000)

N

N

G

PO Number

Internal Reference number that matches the client’s ERP Procurement Purchase Order Number to the Supplier’s.

Alphanumeric (1000)

N

N

H

Lease Type

Type of contractual agreement

See Data Validation Below

Drop-down

Y

Y

I

Frequency

Periodic nature of payments – monthly, quarterly, bi-monthly, annual, bi-annual, etc.

See Data Validation Below

Drop-down

Y

Y

J

Duration

Number of payments between commencement and original end of term. (Examples: 3-year lease paid monthly; Duration is 36. 3-year lease paid quarterly; Duration is 12.)

Must be positive number

Numeric (4)

Y

Y

K

Reasonably Certain Holding Period

Number of months that the assets contained in the lease are expected to be used. This may be shorter than Duration if assets are typically bought out early or may be longer than duration if renewal periods are typically exercised or evergreen is typically incurred.

Must be a positive number and must be a number of months regardless of Frequency

Numeric (4)

N

Y

L

LRF

Lease Rate Factor. Numeric factor expressed as a decimal used to calculate a payment, renewal or buyout amount by multiplying against the Original Equipment Cost. Can be calculated when payment is known by dividing the payment by the OEC.

Required if Payment not specified. Values accepted ≥ 0 and ≤ 4

Numeric

(Total Digits = 18, Precision = 12 to the right of the decimal)

Expressed as a decimal x.xxxxx

Y

N

M

Payment

Amount paid to lessor each period when due.

Required if LRF is not specified

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

N

FIIR

Funder Implicit Interest Rate, which is not ordinarily known by the Lessee.

Enter as a number (i.e. 5 not 0.05 for 5%)

Numeric

(Total Digits = 18, Precision = 12 to the right of the decimal)

Expressed as a decimal x.xxxxx

N

N

O

Rent Escalation Cap

Maximum increase that a rental payment may increase for a single measurement if floating rate lease.

Number ≥ 0 or Null (if None)

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

N

Y

P

Estimated GRV

The amount expected to be paid by Lessee to Lessor at end of lease because equipment FMV is less than contractual guaranteed residual.

Number ≥ 0 or Null (if None)

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

N

N

Q

Entity

Primary business entity which should match one of the entities listed on Companies Tab.

Must exactly match value from Companies Tab where Company Role Type = Entity

Alphanumeric (1000)

Y

N

R

BU

Operational group within client organization primarily used for management reporting.

Must exactly match value from Companies Tab where Company Role Type = BU

Alphanumeric (1000)

Y

N

S

IBR

Incremental Borrowing Rate

Will default to configuration value if blank. If populating, do not include % sign. Enter as a number (i.e. 5 not 0.05 for 5%)

Numeric

(Total Digits = 10, Precision = 6 to the right of the decimal) expressed as a percent ##.####

N

N

T

Repayment Mode

Advance or Arrears

See Data Validation below

Drop-down

Y

Y

U

Accounting Classification

For ASC840, Operating or Capital Leases. For ASC842 Capitalized Operating or Finance. For IFRS 16, Finance.

Leave blank to engage automated LA Classification Engine

Drop-down

N

N

V

Override Explanation

Explanation for accounting classification

Required if Accounting Classification is input

Alphanumeric (1000)

N

N

W

Lessee

The legal party to the agreement leasing the equipment or renting the real estate. Real estate leases may refer to this as the Tenant.

Must exactly match a Lessee listed on the Companies Tab with the Company Role Type = Lessee 

Alphanumeric (1000)

Y

Y

X

Funder

Also referred to as Lessor, they provide the cash to finance the equipment purchase through a lease agreement. Real Estate leases may refer to this as the Landlord.

Must exactly match a Funder listed on the Companies Tab with the Company Role Type = Funder 

Alphanumeric (1000)

Y

N

Y

Lessor Reference Number

A unique tracking identifier within the Lessor systems.

Alphanumeric (200)

N

N

Z

ShipTo Company

If ALL assets are at a single location, then ENTER the location. If ALL assets ARE NOT at the same location, then enter the most common address or the Entity address. System will auto-populate locations to Asset Details.

Must exactly match value on Addresses Tab where Address Role Type = ShipTo

Alphanumeric (1000)

N

N

AA

ShipTo Address1

Mailing address line 1 of ShipTo Company

Alphanumeric (1000)

N

N

AB

ShipTo Address2

Mailing address line 2 of ShipTo Company

Alphanumeric (1000)

N

N

AC

ShipTo City

Mailing address City of ShipTo Company

Alphanumeric (1000)

Y

N

AD

ShipTo State

Mailing address State of ShipTo Company. (May be Province where appropriate) See Country Province List in Valid Values Glossary.

See Data Validation List

Alphanumeric (1000)

N

N

AE

ShipTo Zip

Mailing address Postal Code of ShipTo Company

Alphanumeric (1000)

N

N

AF

ShipTo Country

Mailing address Country of ShipTo Company

See Data Validation List

Drop-down

Y

N

AG

Facility Code

Client code which may be used instead of any of the ShipTo fields.

Code must exist in system already, having been configured with an Address Bulk Import from the CIW.

Alphanumeric (100)

N

N

AH

Geo

Country Name that governs the accounting and tax rules for a transaction.

See Country Data Validation Below

Drop-down

Y

Y

AH

Reporting Area

Participant used to drive internal management reporting which is typically used for geographic region but may be used for other reporting requirements.

Must exactly match value on Companies Tab where Company Role Type = Reporting Area

Alphanumeric (1000)

N

N

AI

Asset Owner

Name or employee responsible from organization/fiduciary perspective.

Must exactly match value on People Tab where People Role Type = Asset Owner

Alphanumeric (1000)

Y

N

AJ

Asset User

Name of employee with custodial responsibility.

Must exactly match value on People Tab where People Role Type = Asset User

Alphanumeric (1000)

N

N

AK

Vendor

A company providing a service related to the leased asset.  Often used for providers of IDCs, Lease Incentives, or other real estate expenses such as insurance.

Must exactly match value on Companies Tab where Company Role Type = Vendor

Alphanumeric (1000)

N

N

AL

Order Administrator

Name of employee responsible for procurement.

Must exactly match value on People Tab where People Role Type = Order Administrator

Alpha (1000)

N

N

AM

Treasury Approver

Name of employees responsible for approving deal from Finance organization.

Must exactly match value on People Tab where People Role Type = Treasury Approver

Alpha (1000)

Y

N

AN

Analyst

Name of employee

Must exactly match value on People tab where People Role Type = Analyst

Alpha (1000)

N

N

AO

Deal Tag

An identifier for leases that meet certain criteria and can be grouped together at the schedule-level. LeaseAccelerator has three standard Deal Tags configured in the system but does allow for each client to add their own Deal Tags. A user-defined Deal Tag must be configured in the UI/Settings/Tags screen prior to being imported with a lease on a PIW or selected when entering a lease in the UI.

Deal Tag must exist in the system. The three standard Deal Tags are Intercompany Schedule, Land Not Separated and Schedule Reviewed.

Alphanumeric (100)

N

N

AP

Is Sub-Leased

Flag to identify if part or all of leased premises/equipment is sublet to another party, i.e., lessee is acting as a landlord/lessor to another party controlling the asset.

Drop-down

N

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Product Category

Grouping of assets by type

See Data Validation Below

Drop-down

Y

Y

C

External Id

Unique identifier defined by the user.

Used to identify parent/child relationships (if any) for a group of assets.

Also, used to identify assets with split asset allocation.

If using External Id for either parent/child or split asset allocation then all rows must contain a value for this field, cannot be left blank.

Parent Asset has sequential whole number and child asset has sequential decimal that relates to parent asset. (Ex: 1 for parent and 1.1, 1.2, 1.3 for children)

If using for asset allocation, then the External Id must be the same value for the asset with split asset allocation for each allocation percentage value. (Example: 1 asset with 50/50 split EXID1 for each percentage line.) A percentage must be provided for each External Id when splitting allocation.

May also be used with parent /child assets. (Ex: EXID1 for parent and EXID1.1 for child)

Alphanumeric (1000)

N

N

D

Allocation Percent

Percent of allocation split for the asset on the same row expressed as a number, not a percentage. When splitting allocation of an asset the total allocation for one asset must equal 100. Allocation splitting will only apply to allocation level attributes, i.e., Cost Center, GL Code or Project)

Must be >0 and ≤100 if splitting allocation and using External Id; when no External Id is used in any row and if blank, system assumes 100 (see rules for Column C above).

If using External Id then all rows must contain a value for this field, cannot be left blank.

Numeric (Total Digits = 13, Precision =10 to the right of the decimal)

N

N

E

Product Number

A unique identifier for equipment typically used to delineate the type of equipment in the manufacturer’s product catalogue.

Alphanumeric (1000)

N

N

F

Manufacturer

Company Name. This field may be used to identify the Real Estate Developer for a real estate lease.

Alpha (1000)

N

N

G

Description

Description of equipment or real estate which may include model year, make, lot number, parcel number, and other descriptors.

Alphanumeric (1000)

N

N

H

Cost Center

Department code asset is assigned to for responsibility/management reporting.

Required if part of General Ledger String

Alphanumeric (100)

Y

Y

I

Project

Project code asset is assigned for responsibility/management reporting.

Required if part of General Ledger String

Alphanumeric (1000)

N

N

J

GL Code

GL Coding Convention ruleset that maps to the series of account codes where accounting transactions are recorded for this asset.

Must exactly match value set during GL Configuration in UI; Settings: Ledger Number: Set of Books Edit: GL Code (Coding Convention)

Alphanumeric (1000)

Y

Y

K

Available for Use Date

Date the asset becomes available for use by the Lessee. This date is used to define the effective dates for factors used in lease classification.

Enter only if different than Lease Start Date

MM/DD/YYYY

N

Y

L

Depreciation Start Date

The date that assets should begin to depreciate.

Enter only if different than Lease Start Date or Available for Use Date

MM/DD/YYYY

N

Y

M

Default Disposition at EOT

Asset Level designation for the end-of-term treatment for the specific asset.

Enter only if different than the default treatment for the product category

Drop-down

N

N

N

Reference Number

Free form field which may be used for any number of reference numbers desired.

Alphanumeric (1000)

N

N

O

Quantity

Number of units

Must be >0; If blank, system assumes 1

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

P

Unit Price

Original equipment cost per unit in local currency

Must be >0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

Q

Observable Price

The price at which the Lessee would purchase the lease or non-lease component separately. The relative percent for each component is used to allocate the total consideration of lease payments to each component for accounting purposes. If the observable standalone prices are not readily available, the Lessee shall estimate the standalone prices, maximizing the use of observable information. If observable price is entered for one asset, it should be entered for all assets, even if the observable price is the same as the unit price. The accounting standards prescribe the use of the SOP. This field should be entered if the explicit SOP or an estimate is used.  However, LeaseAccelerator does not REQUIRE the field since the system has default rules-based estimates.

Must be > 0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

N

R

Unit Rent

A specific rental or payment amount defined in the lease agreement for the specific asset or lease component. If the standalone observable price is not provided, this amount will be used as the estimate for allocating the total payments to each individual component and/or asset (if provided). If unit rent is specified for one asset, it must be specified for all assets on schedule. The accounting standards prescribe the use of the SOP.

This field should be entered if the explicit SOP or an estimate is used.  However, LeaseAccelerator does not REQUIRE the field since the system has default rules-based estimates.

Must be > 0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

N

S

Serial Number

Unique identifier for each asset

Alphanumeric (1000)

N

N

T

Asset Tag

A field available to clients to group assets.

Alphanumeric (1000)

N

N

U

Comments

Free form field for user comments

Alphanumeric (1000)

N

N

V

Asset Owner

Name of employee responsible from organization/fiduciary perspective.

Must exactly match value on People Tab where Person Role Type = Asset Owner.

If Blank, system defaults to value entered on Schedule Tab

Alphanumeric (1000)

N

N

W

Asset User

Name of employee with custodial responsibility.

Must exactly match value on People Tab where Person Role Type = Asset User.

If Blank, system defaults to value entered on Schedule Tab

Alphanumeric (1000)

N

N

X

Property Tax Authority

The municipality that assesses and collects property or real estate taxes.

Must exactly match value on Companies Tab where Company Role Type = Property Tax Authority

Alphanumeric (1000)

N

N

Y

ShipTo Company

This must be the individual location name where the asset is physically located.

Must exactly match value on Addresses Tab where Address Role Type = ShipTo.

If Blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

Z

ShipTo Address1

Line 1 of mailing address of the physical location of asset. May or may not be the same address as defined on the Schedule tab.

If blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

AA

ShipTo Address2

Line 2 of mailing address of the physical location of asset. May or may not be the same address as defined on the Schedule tab.

If blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

AB

ShipTo City

City of mailing address of the physical location of asset. May or may not be the same as defined on the Schedule tab.

If blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

AC

ShipTo State

State or province of the mailing address of the physical location of asset. May or may not be the same as defined on the Schedule tab. See Country Province List in Valid Values Glossary.

If blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

AD

ShipTo Zip

Zip Code or Postal Code of mailing address of the physical location of asset. May or may not be the same as defined on the Schedule tab.

If blank, system defaults to value entered on Schedule

Alphanumeric (1000)

N

N

AE

ShipTo Country

Country of mailing address of the physical location of asset. May or may not be the same address used on the Schedule tab.

If blank, system defaults to value entered on Schedule

Drop-down

N

N

AF

Facility Code

Client code which may be used instead of any of the ShipTo fields.

Code must exist in system already, having been configured with an Address Bulk Import from the CIW.

Alphanumeric (100)

N

N

AG

MAC Address

Description field often used for IT-related equipment.

Alphanumeric (1000)

N

N

AH

IP Address

Description field used for identifying the Internet Points of Presence (POPs).

Alphanumeric (1000)

N

N

AI

Common Name

Description field

Alphanumeric (1000)

N

N

AJ

Fully Qualified Name

Description field

Alphanumeric (1000)

N

N

AK

Units

The unit of measure for area (currently used for real estate leases).

Required if payments are utility-based calculations (versus a specified amount)

Drop-down

N

N

AL

Total Space

The amount of total space leased.

Required based on selection in Utility Pricing basis

Numeric (10)

N

N

AM

Usable Space

The amount of space that can be used in the leased premises, generally measured from wall to wall.

Required based on selection in Utility Pricing basis

Numeric (10)

N

N

AN

Rentable Space

Refers to the usable space, plus a proportional share of common areas of the building, such as the main lobby, elevator lobbies and hallways, and bathrooms that are outside a tenant’s leased space and available for use by other tenants, etc.

Required based on selection in Utility Pricing basis

Numeric (10)

N

N

AO

Price Per Utilized Unit

Rate used to determine rental payment.

Required if Utility Based payment; Amount >0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

N

AP

Utility Pricing Basis

The type of space factor used to identify the quantity of space rented.

Required if Utility based pricing. See Data Validation Below

Drop-down

N

N

AQ

Service State

A description field often used by clients to define the work state of an asset. Examples may include: Out for Repair, Under Construction, In Service

Alphanumeric (1000)

N

N

A

Schedule Number

Unique identifier for a lease 

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Timing

Defines whether the option is a mid-term or end of term option.

See Data Validation Below

Drop-down

Y

Y

C

Option Type

Defines the type of option. For example: renewal, buyout, or return.

See Data Validation Below

Drop-down

Y

Y

D

Reasonably Certain EOT Option

Flag used to define whether the option is the expected option to be exercised. You may enter multiple renewal options that are Reasonably Certain, but they must be contiguous terms without any overlap.

See Data Validation Below

Drop-down

N

Y

E

Effective Month

The month in the lease term that the option is available to be exercised

Number >2

Number (4)

Y

Y

F

Min Days

Notice

Smallest number of days required per lease agreement to provide notification to Lessor of the expected action to occur. If an option can be exercised by the lessee with no advance notice, the Min Days Notice column should be populated with zero. However, if the option will be exercised by default without any initiation by the lessee (e.g. automatic buyout or automatic evergreen), then Min Days Notice should be left blank (as should Max Days Notice). This provides the system with identification of which options are automatically exercised vs. which ones require explicit action by the lessee, with some or no advance notice to the lessor required.

Number >0; may be blank but LA will assume this option is automatic if left blank

Note: Automatic return or buyout options for a valued parent asset and non-valued child asset will terminate all children for that schedule.

Numeric (4)

N

N

G

Max Days

Notice

Largest number of days required per lease agreement to provide notification to Lessor of the expected action to occur.

Number >0; may be blank

Numeric (4)

N

N

H

Exercisable by Lessee

Flag denoting whether the option is exercisable by the Lessee. Used in real estate. If left blank, system will assume and default to Yes. Best practice is to populate.

See Data Validation Below

Drop-down

N

N

I

Description

Contractual language pertaining to each EOT option.

Alphanumeric (4000)

N

N

J

Purchase Amount

Amount that assets may be bought, in local currency. If you leave this field blank on a buyout option, LA will assume FMV and an exact purchase amount may be entered when exercising the option.

Required if Option = Buyout and is not an FMV purchase. If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 16, Precision = 2 to the right of the decimal)

N

Y

K

Buyout Ceiling

Maximum amount that buyout cost may be if structured as FMV rather than as a stated amount.

If Option = Buyout

Number ≥ 0, may be blank. If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 16, Precision = 2 to the right of the decimal)

N

N

L

Buyout Floor

Minimum amount that buyout cost may be if structured as an FMV rather than as a stated amount.

If Option = Buyout

Number ≥ 0, may be blank. If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 16, Precision = 2 to the right of the decimal)

N

N

M

Renewal Term

Number of months from End of Original Term (or latest Renewal) to end of this Renewal Period.  Represents number of months even if the original deal frequency is not monthly. Example: 1-year renewal with quarterly payments is entered as 12. If left blank, LA will assume month to month and an exact term may be entered when exercising the option.

Required if Option = Renewal;

Number >0

Numeric (4)

N

Y

N

Renewal Payment

Amount of Renewal Payment. If left blank, LA will assume FMV and an exact amount will be entered when exercising the option.

If Option = Renewal Number >0 or may be calculated based on LRF or Price Per Utilized Unit and Utility Units as appropriate. If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 16, Precision = 2 to the right of the decimal)

N

N

O

Renewal Payment LRF

Factor applied to OEC (Original Equipment Cost) to determine Renewal Payment.

If Option = Renewal Number >0. Numeric factor expressed as a decimal. May be left blank.

Numeric

(Total Digits = 18, Precision = 12 to the right of the decimal)

N

N

P

Price Per Utilized Unit

The rate used to determine the rental amount during the renewal period if utility-based pricing applies.

If Option = Renewal Number >0; only required if Renewal Payment is Utilization-based and Renewal Payment is blank

Numeric

(Total Digits = 18, Precision =2 to the right of the decimal)

N

N

Q

Utility Units

The unit of measure used to determine the pricing during the renewal period if utility-based pricing applies.

If Option = Renewal;

only required if Renewal Payment is Utilization-based and Renewal Payment is blank

Drop-down

N

N

R

Return Fee

The total fee required to be paid by Lessee to return equipment or real estate to the Lessor/Landlord.  This does not include refurbishment costs or other costs that Lessee may incur to return asset to required condition. In the case where a Guaranteed Residual Value (GRV) is present in the lease, this includes the Contractual GRV which is used in Lease Classification testing after applying any Limit Fee.

If Option = Return; Number ≥ 0, may be blank. If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 18, Precision =2 to the right of the decimal)

N

N

S

Early Penalty

Amount paid by Lessee for terminating lease prior to expiration.

If Option = Return; Number ≥ 0, may be blank.  If entered with a “%” Suffix, amount is interpreted as “percent of” versus the absolute value entered

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

N

N

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

N

B

Number Days

Number of days prior to a notification due date that an email notification should be sent.

Number ≥ 0

Numeric (6)

Y

N

C

Timing

Indicator defining whether the number of days is counted before or after the specified Milestone for when the notification email request should be sent.

See Data Validation Below

Drop-down

Y

N

D

Milestone

The contractual milestone that drives the notification due date.

See Data Validation Below

Drop-down

Y

N

E

Option Type

Defines the type of option. For example: renewal, buyout, or return.

See Data Validation Below

Drop-down

Y

Y

F

Effective Month

The month in the lease term that the option is available to be exercised

Number >2

Number (4)

Y

Y

G

Min Days Notice

Smallest number of days required per lease agreement to provide notification to Lessor of the expected action to occur. If an option can be exercised by the lessee with no advance notice, the Min Days Notice column should be populated with zero. However, if the option will be exercised by default without any initiation by the lessee (e.g. automatic buyout or automatic evergreen), then Min Days Notice should be left blank (as should Max Days Notice). This provides the system with identification of which options are automatically exercised vs. which ones require explicit action by the lessee, with some or no advance notice to the lessor required.

Number >0; may be blank but LA will assume this option is automatic if left blank

Numeric (4)

N

N

H

Frequency

How often the notification should be sent.

See Data Validation Below

Drop-down

Y

N

I

Recurring

Indicator to determine how often a recurring notification should be sent. Used in conjunction with ‘Units’.

Number ≥ 0

Numeric (6)

N

N

J

Units

Unit of measure determining how many times and for how long the recurring notification should be sent.

See Data Validation Below

Drop-down

N

N

K

Until Days

Number of units that the recurring notification should be sent. This sets an end date for these notifications.

Number ≥ 0

Numeric (6)

N

N

L

Send To

The Lessee Role that the Notification should be sent to. Enter multiple roles only separated by a comma and no space: TreasuryApprover,AssetOwner

See Data Validation Below, may enter multiple roles

Alphanumeric (1000)

N

N

M

Template Name

Name of template to be sent. This is required for any EOT Notification to function.

Must exactly match Template Name on Configuration Tab: EOT Templates

Alphanumeric (1000)

Y

N

N

Action Required Days

Number of days that user must perform action.

Number ≥ 0

Numeric (6)

N

N

O

Consequences

Client-specified information to the recipient of the notification.

Alphanumeric (1000)

N

N

P

Enqueue

Workflow event to be added.

See Data Validation Below

Drop-down

N

N

Q

Enqueue To

User role that workflow event is set to.

See Data Validation Below

Drop-down

N

N

R

Message

Detail text to be included in email notifications.

Alphanumeric (1000)

N

N

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Interim Rent Type

Type of Interim Rent which denotes how and when to apply the rent to the payment schedule.

See Data Validation Below

Drop-down

Y

Y

C

Interim Rent Basis

The basis for the rent charge

See Data Validation Below

Drop-down

Y

Y

D

Interim Rate

The interest rate benchmark if Interim Rent Basis = Floating. Also required for Fixed.

Number >0

Numeric (Total = 18, Precision = 12)

N

N

E

Interim Spread

An increment/decrement to the Interim Rate to determine the final Interim Rent.

Number; may be positive or negative.

Numeric

(Total Digits = 18, Precision = 12 to the right of the decimal)

N

N

F

Interim Index Type

The public index to which the interim floating rate is tied

See Data Validation Below

Drop-down

N

N

XYZ

1

6

0

XYZ

7

6

1000

XYZ

13

6

1100

XYZ

19

6

1200

XYZ

25

6

1300

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Starting Payment Number

Payment Number with which new step payment begins. (i.e. Payment #1, Payment #13, Payment #25)

Number >0

Numeric (22)

Y

Y

C

Number Payments

How many payments the step payment applies to. The total number of payments should equal the duration of the lease.

Number >0

Numeric (14)

Y

Y

D

Payment Amount

Amount of Payment

Number >0

Numeric (Total Digits = 18, Precision = 12 to the right of the decimal)

Y

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

N

B

Product Category

Asset Type

See Data Validation Below

Drop-down

Y

N

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Product Category

Grouping of assets by type

See Data Validation Below

Drop-down

N

Y

C

Expense Type

A type of related expense specified in the contract as the responsibility of the Lessee. Payment may be made to the lessor/landlord or directly to the vendor.

See List in Data Validation

Drop-down

Y

Y

D

Expense SubType

A grouping of expenses within a category by function.

See List in Data Validation

Drop-down

N

Y

E

Payee

A company providing services related to the leased asset. Often used for providers of IDCs, Lease Incentives, or other real estate expenses such as Insurance.

Must exactly match value on Companies Tab where Company Role Type = Vendor

Alphanumeric (1000)

Y

N

F

Frequency

Recurring timing of expense

See List in Data Validation

Drop-down

Y

Y

G

Description

Description of expense

Alphanumeric (1000)

N

N

H

Benchmark Amount

Initial amount for the index against which adjustments will be made.

May be Required where Expense Type = CAMS or Other Related Expense and Lease Type = Gross Lease, Triple-Net, or Full Service.

Number >0, may be blank

Numeric (Total = 18, Precision = 2)

N

Y

I

Escalation Cap

Maximum amount of increase in related expense each year.

May be Required where Expense Type = CAMS or Other Related Expense and Lease Type = Gross Lease, Triple-Net, or Full Service.

Number >0, may be blank

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

Y

J

Ceiling

Maximum amount of total expense allowable to be charged.

May be Required where Expense Type = CAMS or Other Related Expense and Lease Type = Gross Lease, Triple-Net, or Full Service.

Number >0, may be blank

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

Y

K

1^st Scheduled Payment Date

Date that the expense is accrued/established. Cannot be prior to the Lease Start Date.

May be Required where Expense Type = CAMS or Other Related Expense and Lease Type = Gross Lease, Triple-Net, or Full Service.

MM/DD/YYYY

N

Y

L

Initial Payment Amount

First payment amount from which escalation caps are applied. Amount, if any, in addition to the base rent.

May be Required where Expense Type = CAMS or Other Related Expense and Lease Type = Gross Lease, Triple-Net, or Full Service. Number >0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

N

Y

M

Currency

Currency associated with Initial Payment Amount.

Please be aware that Lease Incentives, Initial Direct Costs (IDC), and ARO-End of Life Costs must be in the same transactional currency as the deal.

Required if Initial Payment Amount is not NULL

Drop-down

N

Y

N

Interest Bearing

For Deposits – if Lessor/Landlord/Vendor is required to apply interest to deposit when returned to Lessee.

Applies only if Category = Security Deposit or Special Deposit

Drop-down

N

Y

O

Deposit Interest Rate

Interest Rate applied to Deposits

Number >0, may be blank

Numeric (Total Digits = 18, Precision = 12 to the right of the decimal)

N

Y

P

Late Fee Interest Rate

Interest Rate applied to payments to determine Late Fees.

Number >0, may be blank

Numeric (Total Digits = 18, Precision = 12 to the right of the decimal)

N

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Product Category

Group of Assets by type

See Data Validation Below

Drop-down

N

Y

C

Expense Type

A type of related expense specified in the contract as the responsibility of the Lessee. Payment may be made to the Lessor/Landlord or directly to the Vendor.

See Data Validation Below

Drop-down

Y

Y

D

Expense SubType

A grouping of expenses within a category by function.

See Data Validation Below

Drop-down

N

Y

E

Payee

A company providing services related to the leased asset. Often used for providers of IDCs, Lease Incentives, or other real estate expenses such as insurance.

Must exactly match value on Companies Tab where Company Role Type = Vendor

Alphanumeric (1000)

Y

N

F

Description

Description of expense

Alphanumeric (1000)

N

N

G

Service Period Start

Beginning date for which services were provided for the expense.

By Expense/Sub-Expense Type

MM/DD/YYYY

N

Y

H

Service Period End

Ending date for which services were provided for the expense.

By Expense/Sub-Expense Type

MM/DD/YYYY

N

Y

I

Invoiced Amount

Amount of Expense

Number >0

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

J

Currency

Currency associated with Invoiced Amount

Please be aware that Lease Incentives, Initial Direct Costs (IDC), and ARO-End of Life Costs must be in the same transactional currency as the deal.

Drop-down

Y

Y

K

Invoice Date

Invoice Date per Vendor Invoice Artifact

MM/DD/YYYY

N

Y

L

Invoice Number

Reference Number assigned by Vendor

Alphanumeric (1000)

N

N

M

Payment or Receipt

Flag to define if expense is a payment or refund

See Data Validation Below

Drop-down

Y

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Product Category

Group of Assets by type

See Data Validation Below

Drop-down

N

Y

C

Expense Type

A type of related expense specified in the contract as the responsibility of the Lessee. Payment may be made to the Lessor/Landlord or directly to the Vendor.

See Data Validation Below

Drop-down

Y

Y

D

Expense SubType

A grouping of expenses within a category by function.

See Data Validation Below

Drop-down

N

Y

E

Payee

A company providing services related to the leased asset. Often used for providers of IDCs, Lease Incentives, or other real estate expenses such as insurance.

Must exactly match value on Companies Tab where Company Role Type = Vendor

Alphanumeric (1000)

Y

N

F

Description

Description of expense

Alphanumeric (1000)

N

N

G

Service Period Start

Beginning date for which services were provided for the expense.

By Expense/Sub-Expense Type

MM/DD/YYYY

N

Y

H

Service Period End

Ending date for which services were provided for the expense.

By Expense/Sub-Expense Type

MM/DD/YYYY

N

Y

I

Amount Paid

Amount of Expense

Number >0

Numeric (Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

J

Currency

Currency associated with Amount Paid

Please be aware that Lease Incentives, Initial Direct Costs (IDC), and ARO-End of Life Costs must be in the same transactional currency as the deal.

Drop-down

Y

Y

K

Payment Date

Date Paid or Received

Move to Paid Other Related

MM/DD/YYYY

Y

Y

L

Payment Reference Number

Reference Number of the Payment. For example: Check Number, Wire Transfer Number, or ACH Number.

Move to Paid Other Related

Alphanumeric (1000)

N

N

M

Invoice Date

Invoice Date per Vendor Invoice Artifact

MM/DD/YYYY

N

Y

N

Invoice Number

Reference Number assigned by Vendor.

Alphanumeric (1000)

N

N

O

Payment or Receipt

Flag to define if expense is a payment or refund.

See Data Validation Below

Drop-down

Y

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

Y

B

Remeasurement Effective Date

Date that the new payment adjustment is remeasured. If Remeasurement Effective Date is not specified, it will be recorded as the first day of the fiscal month containing the start of the first adjusted payment period or current date, whichever is earlier.

MM/DD/YYYY

N

N

C

Effective Date

Date that the new payment schedule is effective.

MM/DD/YYYY

Y

Y

D

Index Basis

The type of index to which a floating rate is tied.

See Data Validation Below

Drop-down

N

N

E

Rate

The floating rate

Number >0; Enter the interest rate as a % (i.e. 3.2 not 0.032) Do not use percent sign.

Numeric

(Total Digits = 18, Precision = 12 to the right of the decimal)

N

N

F

Amount

The new payment amount

Number >0

Numeric

(Total Digits = 18, Precision = 2 to the right of the decimal)

Y

Y

G

One-Time or Recurring

Defines whether the adjustment is applied to a single period or whether all future periods are adjusted.

One-Time or Recurring

Drop-down

Y

Y

H

Reason

The reason for the revised payment schedule.

See Data Validation Below

Drop-down

Y

Y

A

Schedule Number

Unique identifier for a lease

This field MUST MATCH EXACTLY WITH THE SAME VALUE ON THE SCHEDULE TAB

Alphanumeric (1000)

Y

N

B

Document Type

Category of Document

See Data Validation Below

Drop-down

Y

N

C

Document Number

Unique number used as client reference for the document. This is NOT the system defined artifact-ID. If left blank, system will assign number.

Alphanumeric (1000)

N

N

D

Document Status

Workflow state of document

See Data Validation Below

Drop-down

Y

N

E

File Name

File name of document including extension or address for external site.

It can also be used to add a URL to direct users to an external document storage location.

Must be in standard file format xxxxxx.ext. For links to external sites, the entire address must be used.

Alphanumeric (2000)

When specifying a URL (2048)

Y

N