Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
por_s |
Portfolio |
CHAR(2) |
no |
com_s |
Company |
CHAR(2) |
no |
reg_s |
Region |
CHAR(2) |
no |
off_s |
Office |
CHAR(3) |
no |
lse_s |
Lease |
CHAR(10) |
no |
unit_s |
Asset |
CHAR(10) |
no |
stamp_l |
Record modification stamp |
NUMBER(10) |
no |
id_s |
Asset identification |
CHAR(25) |
no |
pur_ord_s |
Purchase order number |
CHAR(25) |
no |
dlr_s |
Vendor |
CHAR(9) |
no |
app_s |
Application |
CHAR(10) |
no |
d_acq_s |
Equipment acquisition date |
DATE |
yes |
d_act_s |
Ownership certificate activity date |
DATE |
yes |
d_fhut_s |
FHUT date of first use |
DATE |
yes |
d_boo_s |
System booking date |
DATE |
yes |
d_eqt_s |
Equipment activity status date |
DATE |
yes |
d_serv_s |
In-service date |
DATE |
yes |
d_insp_s |
Inspection date |
DATE |
yes |
d_bok_s |
Book depreciation start date |
DATE |
yes |
d_itc_s |
ITC accrued to date |
DATE |
yes |
d_addon_s |
Add-on date |
DATE |
yes |
d_po_s |
P.O. date |
DATE |
yes |
d_cor_s |
Correction sent date |
DATE |
yes |
d_lien_s |
Last lien date |
DATE |
yes |
cls_s |
Class (CLASS code) |
CHAR(4) |
yes |
itc_s |
ITC take/bypass code |
CHAR(4) |
yes |
etc_s |
ETC take/bypass code |
CHAR(4) |
yes |
txb_s |
Tax benefit owner code |
CHAR(4) |
yes |
eqt_s |
Equipment activity status |
CHAR(4) |
yes |
mnf_s |
Asset manufacturer code |
CHAR(10) |
yes |
mdl_s |
Asset model code |
CHAR(10) |
yes |
yr_s |
Asset year (YYYY) |
CHAR(4) |
yes |
bkd_s |
Book depreciation method |
CHAR(4) |
yes |
fed_s |
Federal method of depreciation |
CHAR(4) |
yes |
std_s |
State method of depreciation |
CHAR(4) |
yes |
st_s |
State code (RST.ST_S code) |
CHAR(2) |
yes |
ct_s |
County location code |
CHAR(4) |
yes |
cy_s |
City location code |
CHAR(4) |
yes |
txp_s |
Tax payment code (TXP code) |
CHAR(4) |
yes |
co_s |
Ownership certificate code |
CHAR(4) |
yes |
hw_s |
Federal highway use tax code |
CHAR(4) |
yes |
eqt_pay_s |
Equipment status at payoff |
CHAR(4) |
yes |
fed_amt_s |
Federal AMT method |
CHAR(4) |
yes |
itc_meth_s |
ITC accrual method |
CHAR(4) |
yes |
eqt_stat_s |
Asset status |
CHAR(4) |
yes |
eqt_inv_s |
Activity status prior to booking |
CHAR(4) |
yes |
tax_type_s |
Tax type |
CHAR(4) |
yes |
bk_acct_s |
Book accounting method |
CHAR(4) |
yes |
upf_st_s |
Upfront sales tax - state |
CHAR(2) |
yes |
upf_ct_s |
Upfront sales tax - county |
CHAR(4) |
yes |
upf_cy_s |
Upfront sales tax - city |
CHAR(4) |
yes |
corr_s |
Required correction code |
CHAR(4) |
yes |
pay_st_s |
Payoff/sale state location code |
CHAR(2) |
yes |
pay_ct_s |
Payoff/sale county location code |
CHAR(4) |
yes |
pay_cy_s |
Payoff/sale city location code |
CHAR(4) |
yes |
pay_meth_s |
Asset payoff method |
CHAR(4) |
yes |
new_c |
New/used (N/U) |
CHAR(1) |
yes |
copt_c |
Auto options at lease commencement (Y/N) |
VARCHAR2(30) |
yes |
topt_c |
Auto options at lease termination (Y/N) |
VARCHAR2(30) |
yes |
war_c |
Warranty insurance (Y/N) |
CHAR(1) |
yes |
res_ins_c |
Residual insurance (Y/N) |
CHAR(1) |
yes |
unt_pay_c |
An asset payoff was done (Y/N) |
CHAR(1) |
yes |
off_c |
Off-lease (Y/N) |
CHAR(1) |
yes |
rpt_ptax_c |
Report property tax (Y/N) |
CHAR(1) |
yes |
pre_inv_c |
Pre-inventory (Y/N) |
CHAR(1) |
yes |
tax_rptg_c |
Asset appears on tax reports (Y/N) |
CHAR(1) |
yes |
term_rev_c |
Allow termination reversal (Y/N) |
CHAR(1) |
yes |
gp_typ_c |
Gross profit type (R/U)
R - related
U - unrelated |
CHAR(1) |
yes |
upf_stax_c |
Upfront sales tax (Y/N) |
CHAR(1) |
yes |
eq_add_s |
Equipment street address |
VARCHAR2(36) |
yes |
eq_cty_s |
Equipment city |
VARCHAR2(25) |
yes |
eq_st_s |
Equipment state |
CHAR(2) |
yes |
eq_zip_s |
Equipment zip |
CHAR(9) |
yes |
desc_s |
Equipment description |
VARCHAR2(36) |
yes |
opr_nam_s |
Operator name |
VARCHAR2(36) |
yes |
lic_s |
License (auto) |
CHAR(9) |
yes |
stock_s |
Stock number |
CHAR(7) |
yes |
nxt_ln_s |
Next asset in loan |
CHAR(10) |
yes |
prv_ln_s |
Previous asset in loan |
CHAR(10) |
yes |
frst_loan_s |
First loan for asset |
CHAR(11) |
yes |
last_loan_s |
Last loan for asset |
CHAR(11) |
yes |
cashier_chk_s |
Cashier's check number |
CHAR(6) |
yes |
sus_s |
Suspense item number written |
CHAR(6) |
yes |
sus_clr_s |
Suspense item number cleared |
CHAR(6) |
yes |
asset_s |
Associated asset |
CHAR(10) |
yes |
ini_cur_s |
Clerk when asset removed from collateral tracking |
CHAR(3) |
yes |
chk_ref_s |
Check reference |
VARCHAR2(36) |
yes |
sup_nam_s |
Supplier name |
VARCHAR2(36) |
yes |
sup_add_s |
Supplier address |
VARCHAR2(36) |
yes |
sup_add2_s |
Supplier address 2 |
VARCHAR2(36) |
yes |
sup_cty_s |
Supplier city |
VARCHAR2(25) |
yes |
sup_st_s |
Supplier state |
CHAR(2) |
yes |
sup_zip_s |
Supplier zip |
CHAR(9) |
yes |
bun_s |
DMV bundle number |
VARCHAR2(25) |
yes |
snum_s |
DMV suspense receipt number |
VARCHAR2(25) |
yes |
adj_depr_life_l |
Adjustment depreciable life |
NUMBER(10) |
yes |
codm_l |
Odometer reading at lease commencement |
NUMBER(10) |
yes |
todm_l |
Odometer reading at lease termination |
NUMBER(10) |
yes |
weight_l |
FHUT asset weight (pounds) |
NUMBER(10) |
yes |
mil_aam_l |
Average yearly allowable mileage |
NUMBER(10) |
yes |
p_sch_d |
Percentage of schedule amount |
NUMBER(15,5) |
yes |
p_con_unit_d |
Asset yield |
NUMBER(15,7) |
yes |
upf_strt_d |
Upfront sales tax - state rate |
NUMBER(15,5) |
yes |
upf_ctrt_d |
Upfront sales tax - county rate |
NUMBER(15,5) |
yes |
upf_cyrt_d |
Upfront sales tax - city rate |
NUMBER(15,5) |
yes |
pay_st_rate_d |
Payoff/sale state rate |
NUMBER(15,5) |
yes |
pay_ct_rate_d |
Payoff/sale county rate |
NUMBER(15,5) |
yes |
pay_cy_rate_d |
Payoff/sale city rate |
NUMBER(15,5) |
yes |
st_rate_d |
State tax rate |
NUMBER(15,5) |
yes |
ct_rate_d |
County tax rate |
NUMBER(15,5) |
yes |
cy_rate_d |
City tax rate |
NUMBER(15,5) |
yes |
tax_d |
Portfolio tax rate |
NUMBER(15,5) |
yes |
org_d |
Original acquisition cost |
NUMBER(15,2) |
yes |
other_d |
Other charges |
NUMBER(15,2) |
yes |
res_d |
Residual amount |
NUMBER(15,2) |
yes |
strt_d |
Starting asset cost |
NUMBER(15,2) |
yes |
inven_d |
Inventoried value |
NUMBER(15,2) |
yes |
acc_pay_d |
Accounts payable |
NUMBER(15,2) |
yes |
lst_d |
List price |
NUMBER(15,2) |
yes |
lic_d |
License fees |
NUMBER(15,2) |
yes |
pre_d |
Warranty insurance premium |
NUMBER(15,2) |
yes |
rep_d |
Repair cost |
NUMBER(15,2) |
yes |
gas_d |
Gas cost |
NUMBER(15,2) |
yes |
rec_ytd_gross_d |
Gross receipts Y-T-D |
NUMBER(15,2) |
yes |
unit_rec_ltd_d |
Asset change in L-T-D receipts |
NUMBER(15,2) |
yes |
oth_ytd_d |
Other income Y-T-D |
NUMBER(15,2) |
yes |
oth_ltd_d |
Other income L-T-D |
NUMBER(15,2) |
yes |
taxbasis_d |
Starting book value for depreciation |
NUMBER(15,2) |
yes |
itcbasis_d |
Starting book value for ITC |
NUMBER(15,2) |
yes |
sal_bkd_d |
Book value salvage value |
NUMBER(15,2) |
yes |
sal_st_d |
State salvage value |
NUMBER(15,2) |
yes |
mtd_bkd_d |
Depreciation M-T-D book |
NUMBER(15,2) |
yes |
ytd_bkd_d |
Depreciation Y-T-D book |
NUMBER(15,2) |
yes |
ltd_bkd_d |
Depreciation L-T-D book |
NUMBER(15,2) |
yes |
mtd_fed_d |
Depreciation M-T-D federal |
NUMBER(15,2) |
yes |
ytd_fed_d |
Depreciation Y-T-D federal |
NUMBER(15,2) |
yes |
ltd_fed_d |
Depreciation L-T-D federal |
NUMBER(15,2) |
yes |
mtd_st_d |
Depreciation M-T-D state |
NUMBER(15,2) |
yes |
ytd_st_d |
Depreciation Y-T-D state |
NUMBER(15,2) |
yes |
ltd_st_d |
Depreciation L-T-D state |
NUMBER(15,2) |
yes |
org_bkd_ltd_d |
Original L-T-D book depreciation |
NUMBER(15,2) |
yes |
itc_org_d |
Original ITC |
NUMBER(15,2) |
yes |
itc_sus_d |
ITC sustained |
NUMBER(15,2) |
yes |
itc_mtd_d |
ITC M-T-D |
NUMBER(15,2) |
yes |
itc_ytd_d |
ITC Y-T-D |
NUMBER(15,2) |
yes |
itc_ltd_d |
ITC L-T-D |
NUMBER(15,2) |
yes |
etc_mtd_d |
ETC M-T-D |
NUMBER(15,2) |
yes |
etc_ytd_d |
ETC Y-T-D |
NUMBER(15,2) |
yes |
etc_ltd_d |
ETC L-T-D |
NUMBER(15,2) |
yes |
nbv_pay_d |
Net book value at payoff/termination |
NUMBER(15,2) |
yes |
ytd_loss_d |
Y-T-D loss on termination |
NUMBER(15,2) |
yes |
ytd_gain_d |
Y-T-D gain on termination |
NUMBER(15,2) |
yes |
std_pay_d |
State book value at payoff |
NUMBER(15,2) |
yes |
fed_pay_d |
Federal book value at payoff |
NUMBER(15,2) |
yes |
res_pay_d |
Residual at payoff |
NUMBER(15,2) |
yes |
strt_pay_d |
Starting cost at payoff |
NUMBER(15,2) |
yes |
asm_pay_d |
Assessments outstanding for payoff |
NUMBER(15,2) |
yes |
pmt_pay_d |
Payments outstanding for payoff |
NUMBER(15,2) |
yes |
unit_rec_d |
Asset receivable |
NUMBER(15,2) |
yes |
chg_rec_d |
Asset change in receivable |
NUMBER(15,2) |
yes |
unit_prn_d |
Asset principal |
NUMBER(15,2) |
yes |
unit_l_ue_d |
Asset lessor unearned |
NUMBER(15,2) |
yes |
d_ue_d |
Asset vendor unearned |
NUMBER(15,2) |
yes |
unit_i_ue_d |
Asset investor unearned |
NUMBER(15,2) |
yes |
unit_l_ue_org_d |
Asset lessor unearned original |
NUMBER(15,2) |
yes |
d_ue_org_d |
Asset vendor unearned original |
NUMBER(15,2) |
yes |
unit_i_ue_org_d |
Asset investor unearned original |
NUMBER(15,2) |
yes |
sch_basis_d |
Schedule percentage basis |
NUMBER(15,2) |
yes |
fed_amt_ltd_d |
Federal AMT L-T-D amount |
NUMBER(15,2) |
yes |
bk_basis_d |
Book tax basis |
NUMBER(15,2) |
yes |
itc_org_ue_d |
Original ITC unearned |
NUMBER(15,2) |
yes |
itc_cur_ue_d |
Current ITC unearned |
NUMBER(15,2) |
yes |
itc_in_ytd_d |
ITC income Y-T-D |
NUMBER(15,2) |
yes |
itc_in_cur_d |
ITC current month income |
NUMBER(15,2) |
yes |
man_bas_d |
Manufacturer's depreciation basis |
NUMBER(15,2) |
yes |
pmt_acc_d |
Payment amount accrued Y-T-D |
NUMBER(15,2) |
yes |
pmt_amt_d |
Asset payment amount |
NUMBER(15,2) |
yes |
l_in_ytd_d |
Lessor income Y-T-D |
NUMBER(15,2) |
yes |
ast_cst_d |
Original asset cost |
NUMBER(15,2) |
yes |
org_bk_basis_d |
Original book basis |
NUMBER(15,2) |
yes |
adj_bk_basis_d |
Adjustment to book basis |
NUMBER(15,2) |
yes |
unit_r_ue_d |
Asset unearned residual |
NUMBER(15,2) |
yes |
rec_ytd_chg_d |
Asset change in Y-T-D receipts |
NUMBER(15,2) |
yes |
etc_org_d |
ETC original total |
NUMBER(15,2) |
yes |
upf_bamt_d |
Upfront sales tax - base amount |
NUMBER(15,2) |
yes |
upf_samt_d |
Upfront sales tax - sales tax amount |
NUMBER(15,2) |
yes |
idc_ytd_d |
IDC Y-T-D amount - book |
NUMBER(15,2) |
yes |
idc_tax_ytd_d |
IDC Y-T-D amount - tax |
NUMBER(15,2) |
yes |
fed_amt_ytd_d |
Federal AMT Y-T-D amount |
NUMBER(15,2) |
yes |
pay_tax_amt_d |
Payoff/sale taxable amount |
NUMBER(15,2) |
yes |
amt_pay_d |
Federal AMT book value at payoff |
NUMBER(15,2) |
yes |
r_in_ytd_d |
Residual income Y-T-D |
NUMBER(15,2) |
yes |
unit_r_ue_org_d |
Asset original unearned residual |
NUMBER(15,2) |
yes |
allow_ptx_c |
Allow property tax assessment (Y/N) |
CHAR(1) |
yes |
note_s |
Note attached to asset |
CHAR(10) |
yes |
gst_vendor_payable_d |
GST vendor payable |
NUMBER(15,2) |
yes |
ap_reduced_comm_d |
A/P reduce at commencement
for partial deductions module |
NUMBER(15,2) |
yes |
d_disp_s |
Asset disposition date |
DATE |
yes |
ins_prem_cost_d |
Insurance premium cost |
NUMBER(15,2) |
yes |
ytd_bkd_pay_d |
Depreciation Y-T-D book at payoff |
NUMBER(15,2) |
yes |
ytd_fed_pay_d |
Depreciation Y-T-D federal at payoff |
NUMBER(15,2) |
yes |
ytd_st_pay_d |
Depreciation Y-T-D state at payoff |
NUMBER(15,2) |
yes |
fed_amt_ytd_pay_d |
Federal AMT Y-T-D at payoff |
NUMBER(15,2) |
yes |
msi_chg_key_c |
Change lease key is in progress |
CHAR(1) |
yes |
prop_tax_basis_d |
Property tax basis |
NUMBER(15,2) |
yes |
warranty_c |
Warranty |
CHAR(1) |
yes |
title_status_s |
Title status |
CHAR(4) |
yes |
can_cr_lif1_c |
Cancel credit life insurance 1 |
CHAR(1) |
yes |
can_cr_lif2_c |
Cancel credit life insurance 2 |
CHAR(1) |
yes |
can_cr_dis1_c |
Cancel credit disability insurance 1 |
CHAR(1) |
yes |
can_cr_dis2_c |
Cancel credit disability insurance 2 |
CHAR(1) |
yes |
can_warranty_c |
Cancel warranty insurance |
CHAR(1) |
yes |