Name | Description |
---|---|
reqa | Asset 2 |
reqc | Asset Condition |
reqp | Asset Payment Schedule |
requ | Asset UCC |
Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 |
---|---|---|---|---|---|---|
req_idx0 | por_s | com_s | reg_s | off_s | lse_s | unit_s |
req_idx1 | unit_s | |||||
req_idx2 | id_s | unit_s | ||||
req_idx3 | pur_ord_s | unit_s | ||||
req_idx4 | dlr_s | unit_s | ||||
req_idx5 | app_s | unit_s | ||||
req_spec1_idx | lse_s | unit_s |
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 |
timestamp | Record modification stamp |
timestamp | yes |
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 |
datetime | yes |
d_act_s | Ownership certificate activity date |
datetime | yes |
d_fhut_s | FHUT date of first use |
datetime | yes |
d_boo_s | System booking date |
datetime | yes |
d_eqt_s | Equipment activity status date |
datetime | yes |
d_serv_s | In-service date |
datetime | yes |
d_insp_s | Inspection date |
datetime | yes |
d_bok_s | Book depreciation start date |
datetime | yes |
d_itc_s | ITC accrued to date |
datetime | yes |
d_addon_s | Add-on date |
datetime | yes |
d_po_s | P.O. date |
datetime | yes |
d_cor_s | Correction sent date |
datetime | yes |
d_lien_s | Last lien date |
datetime | 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) |
char(30) | yes |
topt_c | Auto options at lease termination (Y/N) |
char(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 |
char(36) | yes |
eq_cty_s | Equipment city |
char(25) | yes |
eq_st_s | Equipment state |
char(2) | yes |
eq_zip_s | Equipment zip |
char(9) | yes |
desc_s | Equipment description |
char(36) | yes |
opr_nam_s | Operator name |
char(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 |
char(36) | yes |
sup_nam_s | Supplier name |
char(36) | yes |
sup_add_s | Supplier address |
char(36) | yes |
sup_add2_s | Supplier address 2 |
char(36) | yes |
sup_cty_s | Supplier city |
char(25) | yes |
sup_st_s | Supplier state |
char(2) | yes |
sup_zip_s | Supplier zip |
char(9) | yes |
bun_s | DMV bundle number |
char(25) | yes |
snum_s | DMV suspense receipt number |
char(25) | yes |
adj_depr_life_l | Adjustment depreciable life |
integer | yes |
codm_l | Odometer reading at lease commencement |
integer | yes |
todm_l | Odometer reading at lease termination |
integer | yes |
weight_l | FHUT asset weight (pounds) |
integer | yes |
mil_aam_l | Average yearly allowable mileage |
integer | yes |
p_sch_d | Percentage of schedule amount |
double precision | yes |
p_con_unit_d | Asset yield |
double precision | yes |
upf_strt_d | Upfront sales tax - state rate |
double precision | yes |
upf_ctrt_d | Upfront sales tax - county rate |
double precision | yes |
upf_cyrt_d | Upfront sales tax - city rate |
double precision | yes |
pay_st_rate_d | Payoff/sale state rate |
double precision | yes |
pay_ct_rate_d | Payoff/sale county rate |
double precision | yes |
pay_cy_rate_d | Payoff/sale city rate |
double precision | yes |
st_rate_d | State tax rate |
double precision | yes |
ct_rate_d | County tax rate |
double precision | yes |
cy_rate_d | City tax rate |
double precision | yes |
tax_d | Portfolio tax rate |
double precision | yes |
org_d | Original acquisition cost |
double precision | yes |
other_d | Other charges |
double precision | yes |
res_d | Residual amount |
double precision | yes |
strt_d | Starting asset cost |
double precision | yes |
inven_d | Inventoried value |
double precision | yes |
acc_pay_d | Accounts payable |
double precision | yes |
lst_d | List price |
double precision | yes |
lic_d | License fees |
double precision | yes |
pre_d | Warranty insurance premium |
double precision | yes |
rep_d | Repair cost |
double precision | yes |
gas_d | Gas cost |
double precision | yes |
rec_ytd_gross_d | Gross receipts Y-T-D |
double precision | yes |
unit_rec_ltd_d | Asset change in L-T-D receipts |
double precision | yes |
oth_ytd_d | Other income Y-T-D |
double precision | yes |
oth_ltd_d | Other income L-T-D |
double precision | yes |
taxbasis_d | Starting book value for depreciation |
double precision | yes |
itcbasis_d | Starting book value for ITC |
double precision | yes |
sal_bkd_d | Book value salvage value |
double precision | yes |
sal_st_d | State salvage value |
double precision | yes |
mtd_bkd_d | Depreciation M-T-D book |
double precision | yes |
ytd_bkd_d | Depreciation Y-T-D book |
double precision | yes |
ltd_bkd_d | Depreciation L-T-D book |
double precision | yes |
mtd_fed_d | Depreciation M-T-D federal |
double precision | yes |
ytd_fed_d | Depreciation Y-T-D federal |
double precision | yes |
ltd_fed_d | Depreciation L-T-D federal |
double precision | yes |
mtd_st_d | Depreciation M-T-D state |
double precision | yes |
ytd_st_d | Depreciation Y-T-D state |
double precision | yes |
ltd_st_d | Depreciation L-T-D state |
double precision | yes |
org_bkd_ltd_d | Original L-T-D book depreciation |
double precision | yes |
itc_org_d | Original ITC |
double precision | yes |
itc_sus_d | ITC sustained |
double precision | yes |
itc_mtd_d | ITC M-T-D |
double precision | yes |
itc_ytd_d | ITC Y-T-D |
double precision | yes |
itc_ltd_d | ITC L-T-D |
double precision | yes |
etc_mtd_d | ETC M-T-D |
double precision | yes |
etc_ytd_d | ETC Y-T-D |
double precision | yes |
etc_ltd_d | ETC L-T-D |
double precision | yes |
nbv_pay_d | Net book value at payoff/termination |
double precision | yes |
ytd_loss_d | Y-T-D loss on termination |
double precision | yes |
ytd_gain_d | Y-T-D gain on termination |
double precision | yes |
std_pay_d | State book value at payoff |
double precision | yes |
fed_pay_d | Federal book value at payoff |
double precision | yes |
res_pay_d | Residual at payoff |
double precision | yes |
strt_pay_d | Starting cost at payoff |
double precision | yes |
asm_pay_d | Assessments outstanding for payoff |
double precision | yes |
pmt_pay_d | Payments outstanding for payoff |
double precision | yes |
unit_rec_d | Asset receivable |
double precision | yes |
chg_rec_d | Asset change in receivable |
double precision | yes |
unit_prn_d | Asset principal |
double precision | yes |
unit_l_ue_d | Asset lessor unearned |
double precision | yes |
d_ue_d | Asset vendor unearned |
double precision | yes |
unit_i_ue_d | Asset investor unearned |
double precision | yes |
unit_l_ue_org_d | Asset lessor unearned original |
double precision | yes |
d_ue_org_d | Asset vendor unearned original |
double precision | yes |
unit_i_ue_org_d | Asset investor unearned original |
double precision | yes |
sch_basis_d | Schedule percentage basis |
double precision | yes |
fed_amt_ltd_d | Federal AMT L-T-D amount |
double precision | yes |
bk_basis_d | Book tax basis |
double precision | yes |
itc_org_ue_d | Original ITC unearned |
double precision | yes |
itc_cur_ue_d | Current ITC unearned |
double precision | yes |
itc_in_ytd_d | ITC income Y-T-D |
double precision | yes |
itc_in_cur_d | ITC current month income |
double precision | yes |
man_bas_d | Manufacturer's depreciation basis |
double precision | yes |
pmt_acc_d | Payment amount accrued Y-T-D |
double precision | yes |
pmt_amt_d | Asset payment amount |
double precision | yes |
l_in_ytd_d | Lessor income Y-T-D |
double precision | yes |
ast_cst_d | Original asset cost |
double precision | yes |
org_bk_basis_d | Original book basis |
double precision | yes |
adj_bk_basis_d | Adjustment to book basis |
double precision | yes |
unit_r_ue_d | Asset unearned residual |
double precision | yes |
rec_ytd_chg_d | Asset change in Y-T-D receipts |
double precision | yes |
etc_org_d | ETC original total |
double precision | yes |
upf_bamt_d | Upfront sales tax - base amount |
double precision | yes |
upf_samt_d | Upfront sales tax - sales tax amount |
double precision | yes |
idc_ytd_d | IDC Y-T-D amount - book |
double precision | yes |
idc_tax_ytd_d | IDC Y-T-D amount - tax |
double precision | yes |
fed_amt_ytd_d | Federal AMT Y-T-D amount |
double precision | yes |
pay_tax_amt_d | Payoff/sale taxable amount |
double precision | yes |
amt_pay_d | Federal AMT book value at payoff |
double precision | yes |
r_in_ytd_d | Residual income Y-T-D |
double precision | yes |
unit_r_ue_org_d | Asset original unearned residual |
double precision | 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 |
double precision | yes |
ap_reduced_comm_d | A/P reduce at commencement for partial deductions module |
double precision | yes |
d_disp_s | Asset disposition date |
datetime | yes |
ins_prem_cost_d | Insurance premium cost |
double precision | yes |
ytd_bkd_pay_d | Depreciation Y-T-D book at payoff |
double precision | yes |
ytd_fed_pay_d | Depreciation Y-T-D federal at payoff |
double precision | yes |
ytd_st_pay_d | Depreciation Y-T-D state at payoff |
double precision | yes |
fed_amt_ytd_pay_d | Federal AMT Y-T-D at payoff |
double precision | yes |
msi_chg_key_c | Change lease key is in progress |
char(1) | yes |
prop_tax_basis_d | Property tax basis |
double precision | 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 |