Lease

Record number (value is always 1)

Record modification stamp

Defer payment due date

Final payment due date

Turn-in date

Total tax credit

Remaining tax credit

Cumulative number of deferred months

Final monthly payment amount

Date of last payment reschedule

Date of last payment reschedule (RWT)

Date of last payment reschedule (DEF)

Number of payment reschedules (RWT)

Number of payment reschedules (DEF)

Maintenance fee (auditing only)

Second half of 24-month payment history profile
  See rxl.pmt_hist_profile_s for description of values

Activity substatus (ACTSUBSTAT code)

First payment default (Y/N)

Original MSRP amount

Loan type

Obligators liability

Previous repossesion (Y/N)

Write off reason

NSF counter

Dealer reserves SL depreciation basis

Acquisition fee SL depreciation basis

Estimated lessor income L-T-D

Alternate unearned IDC3

Alternate current IDC3

Alternate year to date IDC3

Alternate unearned IDC4

Alternate current IDC4

Alternate year to date IDC4

Alternate unearned IDC5

Alternate current IDC5

Alternate year to date IDC5

Alternate unearned IDR5

Alternate current IDR5

Alternate year to date IDR5

Alternate unearned IDR6

Alternate current IDR6

Alternate year to date IDR6

Alternate unearned IDRB

Alternate current IDRB

Alternate year to date IDRB

GL lessor income L-T-D

GL lessor income M-T-D

GL lessor income Y-T-D

Back payment applied (Y/N)

Revolving credit limit [1]

Revolving credit limit [2]

Revolving credit limit [3]

Revolving credit limit [4]

Revolving credit limit effective date [1]

Revolving credit limit effective date [2]

Revolving credit limit effective date [3]

Revolving credit limit effective date [4]

Revolving credit line fee

Customer yield

Insurance risk fee rate

Insurance risk fee code

Date of last insurance risk fee assessment

PAP bank account name

Deferred income amount

Deferred IDC amount

Deferred IDC1 amount

Deferred IDC2 amount

Deferred IDR1 amount

Deferred IDR2 amount

Deferred IDR3 amount

Deferred IDR4 amount

Number of payment reschedules (RSC)

Date of last leveraged table download

Leveraged commencement date

Leveraged (Y/N)

Number of leveraged table download

Leveraged term

Staged equity amount

Staged equity account payable

Taxable income Y-T-D amount

FSC exclusion Y-T-D amount

Interest expenses Y-T-D amount

Strategic grouping for behaviour scoring

Risk band for behavior scoring

Account behavior score

External strategy for behavior scoring

Staged equity fund payable to

Deferred tax YTD amount

Non-pyramiding late charge minimum payment due

IDC amortization add-on interest rate

IDC amortization interest rate

Schedule principal

Late charge date

Late charge assessed prior to last accrual (Y/N)

Invoice due date overlap (Y/N)

Valuation reserve

Recovery

Optional residual

Non commission amount

Security deposit refund amount

Principal write down (Y/N)

Metro2 file format code

Date of first delinquency

Invoice format code

Security deposit disbursal status (P/U/N)
  P - processed
  U - unprocessed
  N - n/a

Sales/use tax exempt code

Cash Control used (Y/N)

Last OFSA (Oracle Fin Svcs Apps) run date

Payoff quote preparation date

Custom payoff quote amount [1]

Custom payoff quote amount [2]

Custom payoff quote amount [3]

Custom payoff quote amount [4]

Custom payoff quote amount [5]

Ad hoc PAP amount

Ad hoc effective date

Set float rate on business or calendar day (P/F/C)
  P - previous business day
  F - following business day
  C - calendar day

Frequency of float rate setting
  DAY - daily
  MON - monthly
  QTR - quarterly
  SEMI - semiannually
  ANNL - annually
  NONE - rate setting functionality is disabled

Day of month on which float rate is set (1-31 or 0)
  A value of zero indicates that the rate setting
  functionality has been disabled.

Month in which float rate is set (1-12 or 0)
  0 - if frequency is NONE, MON or DAY
  1 to 3 - if frequency is QTR
  1 to 6 - if frequency is SEMI
  1 to 12 - if frequency is ANNL

Float base rate percentage

Calendar to use for determining business days

Original dealer-received payments

Dealer payments batch number

Contract end date

Has recurring charge payment schedule (Y/N)

Recurring charge payment schedule in synch with lease (Y/N)

Has asset level payment schedule (Y/N)

Has assessment description (Y/N)

Extension income on cash or accrual basis before
  payoff (C/A/N)
   C - Cash
   A - Accrual
   N - Not decided

Assumption fees manual assessment L-T-D

Collection fees manual assessment L-T-D

Federal highway use tax manual assessment L-T-D

ITC fees manual assessment L-T-D

Legal fees manual assessment L-T-D

Lease extension fees manual assessment L-T-D

Lease re-write fees manual assessment L-T-D

Late charges manual assessment L-T-D

Other fees manual assessment L-T-D

Payment extension fees manual assessment L-T-D

Property tax manual assessment L-T-D

Sales/Use tax manual assessment L-T-D

Recurring charge manual assessment L-T-D [1]

Recurring charge manual assessment L-T-D [2]

Recurring charge manual assessment L-T-D [3]

Recurring charge manual assessment L-T-D [4]

Recurring charge manual assessment L-T-D [5]

Recurring charge manual assessment L-T-D [6]

Recurring charge manual assessment L-T-D [7]

Recurring charge manual assessment L-T-D [8]

Recurring charge manual assessment L-T-D [9]

Recurring charge manual assessment L-T-D [10]

Recurring charge manual assessment L-T-D [11]

Recurring charge manual assessment L-T-D [12]

Recurring charge manual assessment L-T-D [13]

Recurring charge manual assessment L-T-D [14]

Recurring charge manual assessment L-T-D [15]

Last year (YYYY) for which Clear YTD Fields has run

Payment hierarchy

Pool ID

Date of last general ledger pool update

Time of last general ledger pool update

Dealer bonus IDC6

Current IDC6

Year to date IDC6

Reduction IDC6

Suspended IDC6

Unearned IDC6

Dealer reserve IDC7

Current IDC7

Year to date IDC7

Reduction IDC7

Suspended IDC7

Unearned IDC7

Use Vertex O (Y/N/' ')
  Y - Vertex O is used
  N or ' ' - Vertex O is not used

Interest free months

Skip during EOP sequential updates (Y/N)

Original portfolio

Original company

Original region

Original office

Assumed amount

Assumed term

Date assets were returned

Credit bureau account closed (Y/N)

Credit bureau account deleted (Y/N)

Compliance condition code (COMPL.COND code)
  XB - Account information disputed by consumer and
       investigation of dispute is in progress
  XC - Investigation of dispute has been completed, but
       consumer disagrees with outcome of investigation
  XH - Investigation of dispute has been completed
  XR - Removes previously reported CCC
  ' ' - Blank retains previously reported CCC, or no new
        CCC applies for this reporting period

Consumer information indicator (CONSU.INFO code)
  A - Chapter 7 bankruptcy petitioned
  B - Chapter 11 bankruptcy petitioned
  C - Chapter 12 bankruptcy petitioned
  D - Chapter 13 bankruptcy petitioned
  E - Chapter 7 bankruptcy discharged
  F - Chapter 11 bankruptcy discharged
  G - Chapter 12 bankruptcy discharged
  H - Chapter 13 bankruptcy discharged
  I - Chapter 7 bankruptcy dismissed
  J - Chapter 11 bankruptcy dismissed
  K - Chapter 12 bankruptcy dismissed
  L - Chapter 13 bankruptcy dismissed
  M - Chapter 7 bankruptcy withdrawn
  N - Chapter 11 bankruptcy withdrawn
  O - Chapter 12 bankruptcy withdrawn
  P - Chapter 13 bankruptcy withdrawn
  1A - Personal receivership
  2A - Lease assumption
  Q - Removes previously reported bankruptcy CII (A to P)
      or personal receivership CII (1A)
  S - Removes previously reported lease assumption CII (2A)
  ' ' - Blank retains previously reported CII, or no new
        CII applies for this reporting period

Freeze credit bureau field (Y/N)
  Position and corresponding fields:
    1 - Account status and payment rating
    2 - Current balance
    3 - Amount past due
    4 - Date of first delinquency

Frozen CB account status (CB.ACCSTAT code)

Frozen CB payment rating

Frozen CB current balance

Frozen CB amount past due

Frozen CB date of first delinquency

Next payment history monthly entry

Prepaid lease (Y/N)

Recalculate payment history profile (Y/N)

Reason credit bureau reporting was stopped (STOP.CB.RP code)

Special comment code (SP.COMMENT code)

Bankruptcy chapter (BKRPT.CHAP code)

Bankruptcy filing date

Bankruptcy plan confirmed (Y/N)

Deleted account status for CB reporting (CB.DELSTAT code)
  If rlsb.cb_deleted_c is N and rlsb.cb_deleted_stat_s is
  DA or DF, it is a request to delete the account using the
  specified delete status. If rlsb.cb_deleted_c is Y,
  rlsb.cb_deleted_stat_s contains the actual status (DA/DF)
  with which the account was deleted.

Auto-pay invoice due date for current billing cycle

Auto-pay interval frequency (0/1/2/4)
  0 - defined in rjp (Automatic Payment Interval Schedule)
  1 - once per billing cycle
  2 - twice per billing cycle
  4 - four times per billing cycle

Number of auto-pay payments made in current billing cycle

Previous auto-pay amount for current billing cycle

Broker fee accounts payable tax

Insurance premium accounts payable IDC1 tax

Notary fee accounts payable IDC2 tax

Total IDC ASC 842 initial direct cost amount

IDC ASC 842 current month amortization amount -- book

IDC ASC 842 interest portion amount

IDC ASC 842 reduction amount

Unamortized IDC ASC 842 amount -- book

IDC ASC 842 Y-T-D amount -- book

Suspended IDC ASC 842 accrued

Deferred IDC ASC 842 amount

Accrual/billing cycle (M/S/B/W)
  M - Monthly (12 per year)
  S - Semi-monthly (24 per year)
  B - Bi-weekly (26 per year)
  W - Weekly (52 per year)

IDC ASC 842 accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization

IDC book accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization

IDC1-9, IDCA-H accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization

IDR1-9, IDRA-H accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization

Payment source

Auto-pay through a Payment Service (Y/N)

Auto-pay start date

Auto-pay stop date

Most recent date lease was evaluated for auto-pay inclusion

Auto-pay amount type (A/B/C/D/T/P/O/' ')
  A - Total outstanding on current invoice (apply lease)
  B - Total outstanding on current invoice (apply invoice)
  C - Payment and tax outstanding on current invoice (apply
      lease)
  D - Payment and tax outstanding on current invoice (apply
      invoice)
  T - Total outstanding on lease
  P - Payment and tax outstanding on lease
  O - Other specified amount
  ' ' - n/a

Auto-pay other amount

Estimated property tax processed (Y/N)

Lease original commencement date
  Commencement date specified at most recent extension,
  or at booking if there are no extensions. Note that
  calculations are not based on rlsb.d_org_com_s.
  Instead, they are based on rls.d_com_s.

Number of accrual/billing cycle changes
  rlsb.cycle_changes_l is set to zero at booking and whenever
  an extension occurs. It is incremented by 1 whenever an
  accrual/billing cycle change occurs.

Number of SKIP payments to insert into next payment schedule
  that will be accrued for an automatic payment reschedule

Where to insert SKIP payments into next payment schedule
  that will be accrued for an automatic payment reschedule

Last payment effective date before billing frequency change