Portfolio

Company

Region

Office

Application

Record modification stamp

Vendor

Broker

Investor

Lessee number

Lease

Lease date

Lease commencement date

Disbursement date

Maturity date

Custom date 1

Document sent date

Approval expiration date

Documentation completion date

Line of credit start date
  Date the line of credit was created.
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')

Original line of credit expiration date
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')

Current line of credit expiration date
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')

Accrual method lessor

Accrual method vendor

Accrual method investor

Lease source

Lease form code

Delinquency watch code

Broker payment code

Late charge assess

Lease type code

Custom code 1

Custom code 2

Custom code 3

Purchase option billing method

Purchase option

Reasons/conditions [1]

Reasons/conditions [2]

Reasons/conditions [3]

Reasons/conditions [4]

Reasons/conditions [5]

Reasons/conditions [6]

Purchase option owner

Market code

Account code

Application type

Rate plan

Upfront sales tax code

Documentation type code

Prime rate bank number

Late charge index

Product type code

CCA accrual method

Business/personal (B/P)

Type of lease, open or closed (O/C)

Assumed payment (Y/N)

Residual income separated (Y/N)

Refundable (Y/N)

PAP-ACH option (Y/N/1/2/3)
  Y - PAP-ACH is on. Rules are based upon U0212 Current
      Payment Only setting.
  N - PAP-ACH is off.
  1 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'Y' of the U0212 Current
      Payment Only setting.
  2 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'N' of the U0212 Current
      Payment Only setting.
  3 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'O' of the U0212 Current
      Payment Only setting.

Billing level (C/L/I)
  C - Customer
  L - Lessee
  I - Individual

Funding interest modified by user (Y/N)

IDC modified by user (Y/N)

Tax IDC modified by user (Y/N)

Statement code (I/C/F/N/' ')
  I - individual invoice format
  C - coupon books
  F - group invoice format
  N - billing method outside of LeasePak

Normal/master/sub application (N/M/S)
  N - Normal
  M - Master
  S - Sub (part of Master)

CCA fixed rate (Y/N)

Automatic charge off (Y/N/D)
  Y - Lease will be automatically charged off after
      delinquent for more than 120 days.
  N - No automatic charge off.
  D - Lease will defer charge off for 1 month.

General description

Custom string 1

Custom string 2

Trade-in description

Vendor contact name

Vendor phone number

Broker contact name

Broker phone number

Lease address name

Lease address

Lease address 2

Lease address city

Lease address state

Lease address zip code

Default application

Billing address name

Billing address

Billing address 2

Billing address city

Billing address state

Billing address zip code

Group number

Master application number
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a sub-application.
  (i.e. norm_mas_sub_c = 'S')

Vendor factor

Lease term

Estimated lease term

Payment due day

Grace period in days

Lessor yield

Vendor yield

Investor yield factor

Cost of funds

NPV discount rate

IRR (yield)

IRR (yield) without residual

Bad debt percentage

Custom integer 1

Custom integer 2

Lease factor

Residual percentage
  If entered by the user, tot_res_d is also
  calculated and stored.

Lessor rental simple rate

Lessor rental rate add-on

Contract rental rate add-on

Investor rental simple rate

Investor rental rate add-on

Vendor rental simple rate

Rate of participation

Maximum interest rate - lease level

Minimum interest rate - lease level

Total acquisition cost

Other charges

Security deposit

Down payment

Documentation fee

Interim rent

Broker fees

Total initial direct costs

Residual amount
  If tot_res_d is entered by the user, the value of p_res_d
  is erased.

Guaranteed portion of residual

Mark up

In-house fee

Funding interest owed (-) or earned (+)

NPV of payment stream

Titling tax paid up-front

Custom float 1

Custom float 2

Custom float 3

Custom float 4

Custom float 5

Fixed price purchase

Compensation amount

Upfront sales tax on cost

Trade-in

Advanced money received

Tax IDC

Acquisition cost at approval
  for field security tolerance

Down payment at approval
  for field security tolerance

Documentation fee at approval
  for field security tolerance

Residual amount at approval
  for field security tolerance

Payment amount at approval
  for field security tolerance
  regular payment schedules only

Security deposit at approval
  for field security tolerance

Drawdown amount at application approval/book

Credit limit amount
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')

Credit balance amount
  This field is part of the drawdown enhancement
  module. It only has values if the portfolio for
  this application has drawdown tracking turned on
  (rpa.drawdown_tracking_c = 'Y') AND the application
  is a normal or a master application.
  (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')

Payment frequency code (regular payment schedules)

Payment amount (regular payment schedules)

Advanced payments begin

Advanced payments end

Capitalize IBL interest (Y/N/' ')

Insurance premium cost

Notary fee payable to

Insurance premium payable to

Insurance fee income

Notary fee cost

Registration fee income

Dealer subsidy income

Open commission income

Last status history date

Last status history time

Last status history status code

Last status history owner

Last status history transfered by (initials)

Date entered

Time entered (HHMMSS)

Change lease key is in progress

Fixed rate reserves IDC3

Standard reserves IDC4

Guaranteed reserves IDC5

Subvention IDR5

Dealer buy down ID6

Credit life insurance 1 IDR7

Credit life insurance 2 IDR8

Credit disability insurance 1 IDR9

Credit disability insurance 2 IDRA

Acquisition fee IDRB

Warranty insurance IDRC

Excess MSRP

Estimated unearned

Informational down payment amount

Trade-in make

Trade-in model

Trade-in year

Trade-in gross allowance

Trade-in outstanding debt

Trade-in net allowance

Trade-in cash down

Down payment tax

Dealer recourse

Credit quality

Optional insurance

Account type (P/L/I)
  P - Prestige Buyer
  L - Lease
  I - Retail Installment

Purchase option fee

Transfer of equity (Y/N)

Cost of funds 2 (For FCT)

Dealer reserves SL depreciation basis

Acquisition fee SL depreciation basis

Original credit limit

Check number

Revolving credit limit

Revolving credit line fee

Customer yield

Insurance risk fee rate

Insurance risk fee code

Total tax credit

Sum of payments

Calculated total of payments