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 |