| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| app_s | 
Application  | 
 | 
 | 
| unique_l | 
Record number (value is always 1)  | 
 | 
 | 
 | 
Record modification stamp  | 
 | 
 | 
| stg_eqty_d | 
Staged equity amount  | 
 | 
 | 
| lvr_c | 
Leveraged (Y/N)  | 
 | 
 | 
| d_lvr_com_s | 
Leveraged commencement date  | 
 | 
 | 
| d_lst_lvr_s | 
Date of last leveraged table download  | 
 | 
 | 
| lvr_trm_l | 
Leveraged term  | 
 | 
 | 
| stg_eqty_pay_to_s | 
Staged equity fund payable to  | 
 | 
 | 
| npyr_min_d | 
Non-pyramiding late charge minimum payment due  | 
 | 
 | 
| note_follow_up_l | 
Notebook follow-up days  | 
 | 
 | 
| d_fasb13_test_s | 
FASB 13 test date  | 
 | 
 | 
| fasb13_test_c | 
FASB 13 test result (P/F/' ')
  P - Pass
  F - Fail
  ' ' - Untested  | 
 | 
 | 
| orig_intfc_s | 
Originating interface
  MBT - Microbilt
  MPR - mPower
  STM - SuperTrump  | 
 | 
 | 
| metro2_s | 
Metro2 file format code  | 
 | 
 | 
| invo_format_s | 
Invoice format code  | 
 | 
 | 
| non_comm_d | 
Non commission amount  | 
 | 
 | 
| opt_res_d | 
Optional residual  | 
 | 
 | 
| p_opt_res_d | 
Optional residual percentage  | 
 | 
 | 
| revolving_drawdown_c | 
Revolving drawdown credit (Y/N)  | 
 | 
 | 
| stax_exempt_s | 
Sales/use tax exempt code  | 
 | 
 | 
| oper_drawdown_d | 
Operating lease application drawdown amount  | 
 | 
 | 
| dlr_rec_pmts_d | 
Dealer-received payments  | 
 | 
 | 
| prn_write_down_c | 
Principal write down (Y/N)  | 
 | 
 | 
| float_bus_or_cal_c | 
Set float rate on business or calendar day (P/F/C)
  P - previous business day
  F - following business day
  C - calendar day  | 
 | 
 | 
| float_frq_s | 
Frequency of float rate setting
  DAY - daily
  MON - monthly
  QTR - quarterly
  SEMI - semiannually
  ANNL - annually
  NONE - rate setting functionality is disabled  | 
 | 
 | 
| float_day_l | 
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.  | 
 | 
 | 
| float_mon_l | 
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  | 
 | 
 | 
| p_float_base_d | 
Float base rate percentage  | 
 | 
 | 
| calendar_s | 
Calendar to use for determining business days  | 
 | 
 | 
| dlr_pmt_bank_code_s | 
Dealer payment bank code  | 
 | 
 | 
| d_cntr_end_s | 
Contract end date  | 
 | 
 | 
| dlr_pmt_applied_c | 
Dealer payments applied (Y/N)  | 
 | 
 | 
| rcr_pmt_sched_c | 
Has recurring charge payment schedule (Y/N)  | 
 | 
 | 
| rcr_synch_c | 
Recurring charge payment schedule in synch with lease (Y/N)  | 
 | 
 | 
| asset_lvl_c | 
Has asset level payment schedule (Y/N)  | 
 | 
 | 
| assmt_desc_c | 
Has assessment description (Y/N)  | 
 | 
 | 
| p_unused_fee_d | 
Unused drawdown fee rate  | 
 | 
 | 
| unused_fee_thresh_d | 
Unused drawdown fee threshold  | 
 | 
 | 
| d_unused_fee_start_s | 
Start date of unused drawdown fee assessment  | 
 | 
 | 
| d_unused_fee_next_s | 
Next date of unused drawdown fee assessment  | 
 | 
 | 
| unused_fee_frq_s | 
Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL)  | 
 | 
 | 
| pmt_hier_s | 
Payment hierarchy  | 
 | 
 | 
| pool_id_s | 
Pool ID  | 
 | 
 | 
| inst_id_s | 
PAP institution/ACH transit ID  | 
 | 
 | 
| payer_acct_s | 
PAP account number  | 
 | 
 | 
| payer_acct_nam_s | 
PAP bank account name  | 
 | 
 | 
| d_pap_eff_s | 
PAP effective date  | 
 | 
 | 
| vtx_o_c | 
Use Vertex O (Y/N/NULL)
  Y - Vertex O is used
  N or NULL - Vertex O is not used  | 
 | 
 | 
| int_free_mths_l | 
Interest free months  | 
 | 
 | 
| prepaid_c | 
Prepaid lease (Y/N)  | 
 | 
 | 
| auto_pay_interval_l | 
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  | 
 | 
 | 
| idc8_d | 
Guaranteed reserves IDC8  | 
 | 
 | 
| idc9_d | 
Guaranteed reserves IDC9  | 
 | 
 | 
| idca_d | 
Guaranteed reserves IDCA  | 
 | 
 | 
| idcb_d | 
Guaranteed reserves IDCB  | 
 | 
 | 
| idcc_d | 
Guaranteed reserves IDCC  | 
 | 
 | 
| idcd_d | 
Guaranteed reserves IDCD  | 
 | 
 | 
| idce_d | 
Guaranteed reserves IDCE  | 
 | 
 | 
| idcf_d | 
Guaranteed reserves IDCF  | 
 | 
 | 
| idcg_d | 
Guaranteed reserves IDCG  | 
 | 
 | 
| idch_d | 
Guaranteed reserves IDCH  | 
 | 
 | 
| idc_asc842_d | 
Total IDC ASC 842 initial direct cost amount  | 
 | 
 | 
| accrual_cycle_c | 
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_book_accting_c | 
IDC book accounting method (I/A/B)
  I - Income
  A - Amortization
  B - Alternative amortization  | 
 | 
 | 
| pmt_source_s | 
Payment source  | 
 | 
 | 
| auto_pay_c | 
Auto-pay through a Payment Service (Y/N)  | 
 | 
 | 
| d_auto_pay_start_s | 
Auto-pay start date  | 
 | 
 | 
| d_auto_pay_stop_s | 
Auto-pay stop date  | 
 | 
 | 
| auto_pay_amt_type_c | 
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_amt_d | 
Auto-pay other amount  | 
 | 
 |