| Columns | 
| Name | 
Description | 
Datatype ¿? | 
Allow Null | 
| unit_s | 
Asset  | 
CHAR(10) | 
no | 
| unique_l | 
Record number (value is always 1)  | 
NUMBER(10) | 
no | 
| stamp_l | 
Record modification stamp  | 
NUMBER(10) | 
no | 
| ger1_s | 
Additional method of depreciation 1  | 
CHAR(4) | 
yes | 
| ger2_s | 
Additional method of depreciation 2  | 
CHAR(4) | 
yes | 
| ger1_mtd_d | 
Depreciation M-T-D additional 1  | 
NUMBER(15,2) | 
yes | 
| ger1_ytd_d | 
Depreciation Y-T-D additional 1  | 
NUMBER(15,2) | 
yes | 
| ger1_ltd_d | 
Depreciation L-T-D additional 1  | 
NUMBER(15,2) | 
yes | 
| ger2_mtd_d | 
Depreciation M-T-D additional 2  | 
NUMBER(15,2) | 
yes | 
| ger2_ytd_d | 
Depreciation Y-T-D additional 2  | 
NUMBER(15,2) | 
yes | 
| ger2_ltd_d | 
Depreciation L-T-D additional 2  | 
NUMBER(15,2) | 
yes | 
| eq_add2_s | 
Equipment street address 2  | 
VARCHAR2(36) | 
yes | 
| sub_dlr_s | 
Collateral substitution dealer  | 
CHAR(9) | 
yes | 
| d_sub_s | 
Collateral substitution date  | 
DATE | 
yes | 
| sub_miles_l | 
Collateral substitution mileage  | 
NUMBER(10) | 
yes | 
| ext_war_mnths_l | 
Extended warranty months  | 
NUMBER(10) | 
yes | 
| ext_war_miles_l | 
Extended warranty miles  | 
NUMBER(10) | 
yes | 
| war_miles_l | 
Warranty mileage allowance  | 
NUMBER(10) | 
yes | 
| days_p_repo_l | 
Total days in pending repossesion  | 
NUMBER(10) | 
yes | 
| color_s | 
Vehicle color  | 
CHAR(10) | 
yes | 
| cd_key_s | 
Manufacturers key code  | 
CHAR(6) | 
yes | 
| lic_st_s | 
State of license plate issue  | 
CHAR(2) | 
yes | 
| lien_hldr_claim_c | 
Lien holder claim  | 
CHAR(1) | 
yes | 
| repo_invst_d | 
Repossesion investments  | 
NUMBER(15,2) | 
yes | 
| repair_d | 
Repair charges  | 
NUMBER(15,2) | 
yes | 
| beauty_d | 
App recon charges  | 
NUMBER(15,2) | 
yes | 
| incentive_d | 
Incentive charges  | 
NUMBER(15,2) | 
yes | 
| transprt_d | 
Transportation cost  | 
NUMBER(15,2) | 
yes | 
| sale_fee_d | 
Sales fee charges  | 
NUMBER(15,2) | 
yes | 
| dmv_d | 
DMV/title charges  | 
NUMBER(15,2) | 
yes | 
| rep_labor_d | 
Repairs/labor charges  | 
NUMBER(15,2) | 
yes | 
| storage_rec_d | 
Storage charges recovery  | 
NUMBER(15,2) | 
yes | 
| storage_rem_d | 
Storage charges remarketing  | 
NUMBER(15,2) | 
yes | 
| other_cr_d | 
Other credits  | 
NUMBER(15,2) | 
yes | 
| gr_proc_d | 
Gross proceeds  | 
NUMBER(15,2) | 
yes | 
| pre_gap_d | 
Pre gap payments due  | 
NUMBER(15,2) | 
yes | 
| perm_st_c | 
Permanent state status (Y/N)  | 
CHAR(1) | 
yes | 
| part_num_s | 
Part number  | 
VARCHAR2(25) | 
yes | 
| sub_count_l | 
Number of sub-assets on an asset  | 
NUMBER(10) | 
yes | 
| d_ins_can_s | 
Insurance cancellation date  | 
DATE | 
yes | 
| d_ins_exp_s | 
Insurance expiration date  | 
DATE | 
yes | 
| ins_bank_s | 
Insurance bank code  | 
CHAR(3) | 
yes | 
| ins_can_s | 
Insurance cancellation reason  | 
CHAR(4) | 
yes | 
| ins_unit_c | 
Insurance asset (Y/N)  | 
CHAR(1) | 
yes | 
| p_dim_val_d | 
Diminishing value rate  | 
NUMBER(15,5) | 
yes | 
| p_ins_d | 
Insurance percentage  | 
NUMBER(15,5) | 
yes | 
| ue_ins_inc_d | 
Unearned insurance income  | 
NUMBER(15,2) | 
yes | 
| ltd_ins_pay_d | 
Life-to-date insurance payable  | 
NUMBER(15,2) | 
yes | 
| ltd_ins_com_d | 
Life-to-date insurance commission  | 
NUMBER(15,2) | 
yes | 
| ltd_ins_inc_d | 
Life-to-Date insurance income  | 
NUMBER(15,2) | 
yes | 
| ins_pay_refund_d | 
Refund insurance payable  | 
NUMBER(15,2) | 
yes | 
| ins_com_refund_d | 
Refund insurance commission  | 
NUMBER(15,2) | 
yes | 
| ins_inc_refund_d | 
Refund insurance income  | 
NUMBER(15,2) | 
yes | 
| pmt_sch_meth_c | 
Payment schedule adjustment method
  A=Amount T=Term  | 
CHAR(1) | 
yes | 
| prev_ltd_bkd_d | 
Previous life-to-date depreciation  | 
NUMBER(15,2) | 
yes | 
| prev_taxbasis_d | 
Previous book depreciation basis  | 
NUMBER(15,2) | 
yes | 
| prev_sal_bkd_d | 
Previous book salvage value  | 
NUMBER(15,2) | 
yes | 
| depr_chg_l | 
Depreciation change counter  | 
NUMBER(10) | 
yes | 
| d_prev_bkd_s | 
Previous book depreciation start date  | 
DATE | 
yes | 
| prev_bkd_s | 
Previous book depreciation method  | 
CHAR(4) | 
yes | 
| fin_to_oper_c | 
Changed accounting method from FIN to OPER (Y/N)  | 
CHAR(1) | 
yes | 
| def_bkd_d | 
Deferred book depreciation amount  | 
NUMBER(15,2) | 
yes | 
| def_bkd_taken_c | 
Deferred book depreciation taken
  N - Not taken
  D - Taken by depreciation
  P - Taken by payoff
  S = Taken by sale of asset  | 
CHAR(1) | 
yes | 
| lvr_c | 
Leveraged (Y/N)  | 
CHAR(1) | 
yes | 
| amt_life_l | 
AMT depreciation life  | 
NUMBER(10) | 
yes | 
| fed_life_l | 
Federal depreciation life  | 
NUMBER(10) | 
yes | 
| dfrd_tax_ytd_d | 
Deferred tax YTD amount  | 
NUMBER(15,2) | 
yes | 
| fsc_ytd_d | 
FSC exclusion Y-T-D amount  | 
NUMBER(15,2) | 
yes | 
| int_expn_ytd_d | 
Interest expenses Y-T-D amount  | 
NUMBER(15,2) | 
yes | 
| olb_invo_d | 
Off lease billing invoice/rent amount  | 
NUMBER(15,2) | 
yes | 
| olb_stax_d | 
Off lease billing sales tax amount  | 
NUMBER(15,2) | 
yes | 
| tax_inc_ytd_d | 
Taxable income Y-T-D amount  | 
NUMBER(15,2) | 
yes | 
| prev_ytd_fed_amt_d | 
Previous Y-T-D federal AMT depreciation  | 
NUMBER(15,2) | 
yes | 
| prev_ytd_fed_d | 
Previous Y-T-D federal depreciation  | 
NUMBER(15,2) | 
yes | 
| prev_ytd_st_d | 
Previous Y-T-D state depreciation  | 
NUMBER(15,2) | 
yes | 
| opt_res_d | 
Optional residual  | 
NUMBER(15,2) | 
yes | 
| ptax_exempt_s | 
Property tax exempt code  | 
CHAR(4) | 
yes | 
| d_ptax_last_used_s | 
Property tax last used date  | 
DATE | 
yes | 
| stax_exempt_s | 
Sales/use tax exempt code  | 
CHAR(4) | 
yes | 
| utilize_veh_tax_rates_c | 
Utilize vehicle tax rates (Y/N)  | 
CHAR(1) | 
yes | 
| d_payoff_quote_s | 
Payoff quote preparation date  | 
DATE | 
yes | 
| custom_payoff_quote1_d | 
Custom payoff quote amount [1]  | 
NUMBER(15,2) | 
yes | 
| custom_payoff_quote2_d | 
Custom payoff quote amount [2]  | 
NUMBER(15,2) | 
yes | 
| custom_payoff_quote3_d | 
Custom payoff quote amount [3]  | 
NUMBER(15,2) | 
yes | 
| custom_payoff_quote4_d | 
Custom payoff quote amount [4]  | 
NUMBER(15,2) | 
yes | 
| custom_payoff_quote5_d | 
Custom payoff quote amount [5]  | 
NUMBER(15,2) | 
yes | 
| idc_d | 
Total initial direct costs  | 
NUMBER(15,2) | 
yes | 
| idc_cur_d | 
IDC current month amortization - book  | 
NUMBER(15,2) | 
yes | 
| idc_rem_d | 
Unamortized IDC - book  | 
NUMBER(15,2) | 
yes | 
| susp_idc_acc_d | 
Suspended IDC accrued  | 
NUMBER(15,2) | 
yes | 
| idc1_ins_prem_ue_d | 
Insurance premium unearned IDC1  | 
NUMBER(15,2) | 
yes | 
| idc1_ins_prem_susp_d | 
Insurance premium suspended IDC1  | 
NUMBER(15,2) | 
yes | 
| idc1_ins_prem_cur_d | 
Insurance premium current IDC1  | 
NUMBER(15,2) | 
yes | 
| idc1_ins_prem_ytd_d | 
Insurance premium year-to-date IDC1  | 
NUMBER(15,2) | 
yes | 
| idc2_notary_fee_d | 
Notary fee IDC2  | 
NUMBER(15,2) | 
yes | 
| idc2_notary_fee_ue_d | 
Notary fee unearned IDC2  | 
NUMBER(15,2) | 
yes | 
| idc2_notary_fee_susp_d | 
Notary fee suspended IDC2  | 
NUMBER(15,2) | 
yes | 
| idc2_notary_fee_cur_d | 
Notary fee current IDC2  | 
NUMBER(15,2) | 
yes | 
| idc2_notary_fee_ytd_d | 
Notary fee year-to-date IDC2  | 
NUMBER(15,2) | 
yes | 
| idr1_ins_fee_d | 
Insurance fee IDR1  | 
NUMBER(15,2) | 
yes | 
| idr1_ins_fee_ue_d | 
Insurance fee unearned IDR1  | 
NUMBER(15,2) | 
yes | 
| idr1_ins_fee_susp_d | 
Insurance fee suspended IDR1  | 
NUMBER(15,2) | 
yes | 
| idr1_ins_fee_cur_d | 
Insurance fee current IDR1  | 
NUMBER(15,2) | 
yes | 
| idr1_ins_fee_ytd_d | 
Insurance fee year-to-date IDR1  | 
NUMBER(15,2) | 
yes | 
| idr2_reg_fee_d | 
Registration fee IDR2  | 
NUMBER(15,2) | 
yes | 
| idr2_reg_fee_ue_d | 
Registration fee unearned IDR2  | 
NUMBER(15,2) | 
yes | 
| idr2_reg_fee_susp_d | 
Registration fee suspended IDR2  | 
NUMBER(15,2) | 
yes | 
| idr2_reg_fee_cur_d | 
Registration fee current IDR2  | 
NUMBER(15,2) | 
yes | 
| idr2_reg_fee_ytd_d | 
Registration fee year-to-date IDR2  | 
NUMBER(15,2) | 
yes | 
| idr3_dlr_subsidy_d | 
Dealer subsidy IDR3  | 
NUMBER(15,2) | 
yes | 
| idr3_dlr_subsidy_ue_d | 
Dealer subsidy unearned IDR3  | 
NUMBER(15,2) | 
yes | 
| idr3_dlr_subsidy_susp_d | 
Dealer subsidy suspended IDR3  | 
NUMBER(15,2) | 
yes | 
| idr3_dlr_subsidy_cur_d | 
Dealer subsidy current IDR3  | 
NUMBER(15,2) | 
yes | 
| idr3_dlr_subsidy_ytd_d | 
Dealer subsidy year-to-date IDR3  | 
NUMBER(15,2) | 
yes | 
| idr4_open_comm_d | 
Open commission IDR4  | 
NUMBER(15,2) | 
yes | 
| idr4_open_comm_ue_d | 
Open commission unearned IDR4  | 
NUMBER(15,2) | 
yes | 
| idr4_open_comm_susp_d | 
Open commission suspended IDR4  | 
NUMBER(15,2) | 
yes | 
| idr4_open_comm_cur_d | 
Open commission current IDR4  | 
NUMBER(15,2) | 
yes | 
| idr4_open_comm_ytd_d | 
Open commission year-to-date IDR4  | 
NUMBER(15,2) | 
yes | 
| sec_d | 
Security deposit  | 
NUMBER(15,2) | 
yes | 
| susp_l_acc_d | 
Suspended lessor income accrued  | 
NUMBER(15,2) | 
yes | 
| l_in_ptd_d | 
Lessor rental income accrued P-T-D  | 
NUMBER(15,2) | 
yes | 
| l_in_cur_d | 
Lessor current month rent income  | 
NUMBER(15,2) | 
yes | 
| dp_mly_d | 
Monthly rental depreciation  | 
NUMBER(15,2) | 
yes | 
| unrec_in_d | 
Unrecognized operating income  | 
NUMBER(15,2) | 
yes | 
| dfrd_residual_red_d | 
Deferred residual reduction  | 
NUMBER(15,2) | 
yes | 
| op_bill_adj_d | 
Operating lease princpal/income adjustment  | 
NUMBER(15,2) | 
yes | 
| payoff_fee_ltd_d | 
Payoff/termination fee/penalty L-T-D  | 
NUMBER(15,2) | 
yes | 
| d_taxbasis_s | 
Date of last tax depreciation basis update  | 
DATE | 
yes | 
| opr_taxbasis_s | 
Operator who last updated tax depreciation basis  | 
CHAR(3) | 
yes | 
| lse_act_at_payoff_s | 
Lease activity status at payoff/termination (ACT code)  | 
CHAR(4) | 
yes | 
| payoff_st_stax_d | 
State sales tax in payoff  | 
NUMBER(15,2) | 
yes | 
| payoff_ct_stax_d | 
County sales tax in payoff  | 
NUMBER(15,2) | 
yes | 
| payoff_cy_stax_d | 
City sales tax in payoff  | 
NUMBER(15,2) | 
yes | 
| recalc_payoff_stax_rev_c | 
Recalculate payoff sales tax in reversal (Y/N)  | 
CHAR(1) | 
yes | 
| last_eoy_year_s | 
Last year (YYYY) for which Clear YTD Fields has run  | 
CHAR(4) | 
yes | 
| sal_write_down_loss_d | 
Salvage value write-down loss  | 
NUMBER(15,2) | 
yes | 
| idc6_d | 
Dealer bonus IDC6  | 
NUMBER(15,2) | 
yes | 
| idc6_ap_d | 
Payable amount IDC6  | 
NUMBER(15,2) | 
yes | 
| idc6_pay_to_s | 
Payable to IDC6  | 
CHAR(9) | 
yes | 
| idc6_forfeit_d | 
Forfeit amount IDC6  | 
NUMBER(15,2) | 
yes | 
| idc7_d | 
Dealer reserve IDC7  | 
NUMBER(15,2) | 
yes | 
| idc7_ap_d | 
Payable amount IDC7  | 
NUMBER(15,2) | 
yes | 
| idc7_cb_amt_d | 
Chargeback amount IDC7  | 
NUMBER(15,2) | 
yes | 
| idc7_pay_to_s | 
Payable to IDC7  | 
CHAR(9) | 
yes | 
| idc7_dlr_plan_s | 
Dealer reserve plan code IDC7 (RDP.DLR_PLAN_S code)  | 
CHAR(4) | 
yes | 
| dlr_res_promo_s | 
Dealer reserve promotion number  | 
CHAR(15) | 
yes | 
| p_dlr_res_prog_rate_d | 
Dealer reserve program rate  | 
NUMBER(15,2) | 
yes | 
| p_dlr_res_buy_rate_d | 
Dealer reserve buy rate  | 
NUMBER(15,2) | 
yes | 
| vtx_taid_s | 
Vertex tax area id  | 
CHAR(10) | 
yes | 
| eq_cnty_s | 
Equipment county  | 
VARCHAR2(60) | 
yes | 
| tax_pmt_typ_s | 
Tax payment type (ST/UC/UR)
  ST - Stream
  UC - Upfront cost
  UR - Upfront rentals  | 
CHAR(2) | 
yes | 
| upf_ao_dlr_s | 
Upfront sales tax admin origin - vendor number  | 
CHAR(9) | 
yes | 
| pay_txp_s | 
Payoff/sale tax payment code (TXP code)  | 
CHAR(4) | 
yes | 
| assmt_tax_cls_s | 
Assessment tax class (ASM.TAXCLS code)  | 
CHAR(4) | 
yes | 
| seq_upd_skip_c | 
Skip during EOP sequential updates (Y/N)  | 
CHAR(1) | 
yes | 
| paid_off_ck_c | 
Lease change-keyed after payoff (Y/' ')
  Y - Lease was change-keyed
  ' ' - Lease was not change-keyed  | 
CHAR(1) | 
yes | 
| d_supp_depr_start_s | 
Supplemental depreciation start date  | 
DATE | 
yes | 
| d_supp_depr_last_eom_s | 
Supplemental depreciation last EOM date  | 
DATE | 
yes | 
| supp_depr_months_l | 
Number of months to depreciate supplemental  | 
NUMBER(10) | 
yes | 
| supp_depr_basis_d | 
Supplemental depreciation basis  | 
NUMBER(15,2) | 
yes | 
| supp_depr_sal_d | 
Supplemental depreciation salvage value  | 
NUMBER(15,2) | 
yes | 
| supp_depr_accumul_d | 
Accumulated supplemental depreciation  | 
NUMBER(15,2) | 
yes | 
| supp_depr_mtd_d | 
Month-to-date supplemental depreciation  | 
NUMBER(15,2) | 
yes | 
| supp_depr_ytd_d | 
Year-to-date supplemental depreciation  | 
NUMBER(15,2) | 
yes | 
| supp_depr_ltd_d | 
Life-to-date supplemental depreciation  | 
NUMBER(15,2) | 
yes | 
| acc_pay_tax_d | 
Accounts payable tax  | 
NUMBER(15,2) | 
yes | 
| idc_asc842_d | 
Total IDC ASC 842 initial direct cost amount  | 
NUMBER(15,2) | 
yes | 
| idc_asc842_rem_d | 
Unamortized IDC ASC 842 amount -- book  | 
NUMBER(15,2) | 
yes | 
| idc_asc842_cur_d | 
IDC ASC 842 current month amortization amount -- book  | 
NUMBER(15,2) | 
yes | 
| idc_asc842_ytd_d | 
IDC ASC 842 Y-T-D amount -- book  | 
NUMBER(15,2) | 
yes | 
| susp_idc_asc842_acc_d | 
Suspended IDC ASC 842 accrued  | 
NUMBER(15,2) | 
yes |