Database Reference Sybase DBMS
raq Table: Application Asset
Child Tables
| Name | Description |
|---|---|
| raqc | Application Asset Condition |
| raqp | Application Asset Payment Schedule |
| raqu | Application Asset UCC |
Indexes
| Name | Segment 1 | Segment 2 |
|---|---|---|
| raq_idx0 | app_s | unit_s |
| raq_idx1 | unit_s | |
| raq_idx2 | id_s | unit_s |
| raq_idx3 | dlr_s | unit_s |
| raq_idx4 | pur_ord_s | unit_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| unit_s | Asset |
char(10) | no |
| app_s | Application |
char(10) | no |
| timestamp | Record modification stamp |
timestamp | yes |
| id_s | Asset identification |
char(25) | no |
| dlr_s | Vendor |
char(9) | no |
| pur_ord_s | Purchase order number |
char(25) | 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_serv_s | In-service date |
datetime | yes |
| d_insp_s | Inspection date |
datetime | yes |
| d_bok_s | Book depreciation start date |
datetime | yes |
| d_po_s | P.O. 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 |
| 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 |
| hw_s | Federal highway use tax code |
char(4) | yes |
| fed_amt_s | Federal AMT method |
char(4) | yes |
| itc_meth_s | ITC accrual method |
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 |
| eqt_stat_s | Asset status |
char(4) | yes |
| tax_ent_s | CCA tax entity |
char(4) | yes |
| cca_cls_s | CCA class |
char(4) | yes |
| cca_acc_s | CCA accrual method |
char(4) | yes |
| cca_disp_s | CCA disposition method |
char(4) | yes |
| new_c | New/used (N/U) |
char(1) | yes |
| war_c | Warranty insurance (Y/N) |
char(1) | yes |
| res_ins_c | Residual insurance (Y/N) |
char(1) | yes |
| rpt_ptax_c | Report property tax (Y/N) |
char(1) | yes |
| tax_rptg_c | Asset appears on tax reports (Y/N) |
char(1) | yes |
| upf_stax_c | Upfront sales tax (Y/N) |
char(1) | yes |
| copt_c | Auto options at lease commencement (Y/N) |
char(30) | yes |
| ass_typ_c | CCA asset type L - Specified leasing property O - Separate class P - Asset in a pool ' ' - When CCA module not purchased |
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 |
| asset_s | Associated asset |
char(10) | 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 |
| codm_l | Odometer reading at lease commencement |
integer | yes |
| weight_l | FHUT asset weight (pounds) |
integer | yes |
| mil_aam_l | Average yearly allowable mileage |
integer | 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 |
| p_con_unit_d | Asset yield |
double precision | yes |
| p_cca_addon_d | CCA add-on rate For types L, O |
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 |
| 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 |
| sal_bkd_d | Book value salvage value |
double precision | yes |
| sal_st_d | State salvage value |
double precision | yes |
| bk_basis_d | Book tax basis |
double precision | yes |
| man_bas_d | Manufacturer's depreciation basis |
double precision | yes |
| pmt_amt_d | Asset payment amount |
double precision | yes |
| ast_cst_d | Original asset cost |
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 |
| gst_vendor_payable_d | GST vendor payable pending |
double precision | yes |
| cap_cost_d | CCA capital cost |
double precision | yes |
| cca_itc_d | CCA ITC (investment tax credit) |
double precision | yes |
| ins_prem_cost_d | Insurance premium cost |
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 |
| eq_add2_s | Equipment street address 2 |
char(36) | yes |
| ger1_s | Additional method of depreciation 1 |
char(4) | yes |
| ger2_s | Additional method of depreciation 2 |
char(4) | yes |
| war_miles_l | Warranty mileage allowance |
integer | 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 |
| taxbasis_d | Starting book value for depreciation |
double precision | yes |
| sub_count_l | Number of sub-assets on an asset |
integer | yes |
| part_num_s | Part number |
char(25) | yes |
| d_ins_exp_s | Insurance expiration date |
datetime | yes |
| ins_unit_c | Insurance asset (Y/N) |
char(1) | yes |
| p_dim_val_d | Diminishing value rate |
double precision | yes |
| lvr_c | Leveraged (Y/N) |
char(1) | yes |
| amt_life_l | AMT depreciation life |
integer | yes |
| fed_life_l | Federal depreciation life |
integer | yes |
| opt_res_d | Optional residual |
double precision | yes |
| ptax_exempt_s | Property tax exempt code |
char(4) | yes |
| d_ptax_last_used_s | Property tax last used date |
datetime | 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 |
| rec_d | Contract receivable |
double precision | yes |
| idc_d | Total initial direct costs |
double precision | yes |
| idc_rem_d | Unamortized IDC - book |
double precision | yes |
| idc1_ins_prem_ue_d | Insurance premium unearned IDC1 |
double precision | yes |
| idc1_ins_prem_susp_d | Insurance premium suspended IDC1 |
double precision | yes |
| idc2_notary_fee_d | Notary fee IDC2 |
double precision | yes |
| idc2_notary_fee_ue_d | Notary fee unearned IDC2 |
double precision | yes |
| idc2_notary_fee_susp_d | Notary fee suspended IDC2 |
double precision | yes |
| idr1_ins_fee_d | Insurance fee IDR1 |
double precision | yes |
| idr1_ins_fee_ue_d | Insurance fee unearned IDR1 |
double precision | yes |
| idr1_ins_fee_susp_d | Insurance fee suspended IDR1 |
double precision | yes |
| idr2_reg_fee_d | Registration fee IDR2 |
double precision | yes |
| idr2_reg_fee_ue_d | Registration fee unearned IDR2 |
double precision | yes |
| idr2_reg_fee_susp_d | Registration fee suspended IDR2 |
double precision | yes |
| idr3_dlr_subsidy_d | Dealer subsidy IDR3 |
double precision | yes |
| idr3_dlr_subsidy_ue_d | Dealer subsidy unearned IDR3 |
double precision | yes |
| idr3_dlr_subsidy_susp_d | Dealer subsidy suspended IDR3 |
double precision | yes |
| idr4_open_comm_d | Open commission IDR4 |
double precision | yes |
| idr4_open_comm_ue_d | Open commission unearned IDR4 |
double precision | yes |
| idr4_open_comm_susp_d | Open commission suspended IDR4 |
double precision | yes |
| sec_d | Security deposit |
double precision | yes |
| l_ue_d | Lessor unearned rental income |
double precision | yes |
| l_ue_org_d | Lessor orig unearned rental income |
double precision | yes |
| l_in_ptd_d | Lessor rental income accrued P-T-D |
double precision | yes |
| l_in_cur_d | Lessor current month rent income |
double precision | yes |
| susp_l_acc_d | Suspended lessor income accrued |
double precision | yes |
| prn_d | Accrued principal |
double precision | yes |
| dp_mly_d | Monthly rental depreciation |
double precision | yes |
| unrec_in_d | Unrecognized operating income |
double precision | yes |
| idc6_d | Dealer bonus IDC6 |
double precision | yes |
| idc6_pay_to_s | Payable to IDC6 |
char(9) | 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 |
| idc7_d | Dealer reserve IDC7 |
double precision | yes |
| p_dlr_res_prog_rate_d | Dealer reserve program rate |
double precision | yes |
| p_dlr_res_buy_rate_d | Dealer reserve buy rate |
double precision | yes |
| vtx_taid_s | Vertex tax area id |
char(10) | yes |
| eq_cnty_s | Equipment county |
char(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 |
| assmt_tax_cls_s | Assessment tax class (ASM.TAXCLS code) |
char(4) | yes |
| d_supp_depr_start_s | Supplemental depreciation start date |
datetime | yes |
| supp_depr_basis_d | Supplemental depreciation basis |
double precision | yes |
| supp_depr_sal_d | Supplemental depreciation salvage value |
double precision | yes |
| idc_asc842_d | Total IDC ASC 842 initial direct cost amount |
double precision | yes |
| idc_asc842_rem_d | Unamortized IDC ASC 842 amount -- book |
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 |
DBMS Platform Selector |
Database Reference |
LeasePak Database Objects |
Data Model |
Additional Information
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.