ColumnsIndexessp1Parentsp2rhq

rhqa Table: Historical Asset for Lease Extension/Reversal 2
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rhqa Historical Asset for Lease Extension/Reversal 2 table.

Parent-Child: This table has a parent table--click here for a listing.

rhqa Columns

Description	Column Name	Data Type ?	Characteristics ?
Lease	lse_s	char	length 10
Extension	ext_num_s	char	length 2
Asset	unit_s	char	length 10
Record number	unique_l	number	precision 10
Record modification stamp	stamp_l	number	precision 10
Additional method of depreciation 1	ger1_s	char	length 4
Additional method of depreciation 2	ger2_s	char	length 4
Depreciation M-T-D additional 1	ger1_mtd_d	number	precision 15, scale 2
Depreciation Y-T-D additional 1	ger1_ytd_d	number	precision 15, scale 2
Depreciation L-T-D additional 1	ger1_ltd_d	number	precision 15, scale 2
Depreciation M-T-D additional 2	ger2_mtd_d	number	precision 15, scale 2
Depreciation Y-T-D additional 2	ger2_ytd_d	number	precision 15, scale 2
Depreciation L-T-D additional 2	ger2_ltd_d	number	precision 15, scale 2
Equipment street address 2	eq_add2_s	varchar2	length 36
Collateral substitution dealer	sub_dlr_s	char	length 9
Collateral substitution date	d_sub_s	date	format YYYYMMDD
Collateral substitution mileage	sub_miles_l	number	precision 10
Extended warranty months	ext_war_mnths_l	number	precision 10
Extended warranty miles	ext_war_miles_l	number	precision 10
Warranty mileage allowance	war_miles_l	number	precision 10
Total days in pending repossesion	days_p_repo_l	number	precision 10
Vehicle color	color_s	char	length 10
Manufacturers key code	cd_key_s	char	length 6
State of license plate issue	lic_st_s	char	length 2
Lien holder claim	lien_hldr_claim_c	char	length 1
Repossesion investments	repo_invst_d	number	precision 15, scale 2
Repair charges	repair_d	number	precision 15, scale 2
App recon charges	beauty_d	number	precision 15, scale 2
Incentive charges	incentive_d	number	precision 15, scale 2
Transportation cost	transprt_d	number	precision 15, scale 2
Sales fee charges	sale_fee_d	number	precision 15, scale 2
DMV/title charges	dmv_d	number	precision 15, scale 2
Repairs/labor charges	rep_labor_d	number	precision 15, scale 2
Storage charges recovery	storage_rec_d	number	precision 15, scale 2
Storage charges remarketing	storage_rem_d	number	precision 15, scale 2
Other credits	other_cr_d	number	precision 15, scale 2
Gross proceeds	gr_proc_d	number	precision 15, scale 2
Pre gap payments due	pre_gap_d	number	precision 15, scale 2
Permanent state status (Y/N)	perm_st_c	char	length 1
Part number	part_num_s	varchar2	length 25
Number of sub-assets on an asset	sub_count_l	number	precision 10
Insurance cancellation date	d_ins_can_s	date	format YYYYMMDD
Insurance expiration date	d_ins_exp_s	date	format YYYYMMDD
Insurance bank code	ins_bank_s	char	length 3
Insurance cancellation reason	ins_can_s	char	length 4
Insurance asset (Y/N)	ins_unit_c	char	length 1
Diminishing value rate	p_dim_val_d	number	precision 15, scale 5
Insurance percentage	p_ins_d	number	precision 15, scale 5
Unearned insurance income	ue_ins_inc_d	number	precision 15, scale 2
Life-to-date insurance payable	ltd_ins_pay_d	number	precision 15, scale 2
Life-to-date insurance commission	ltd_ins_com_d	number	precision 15, scale 2
Life-to-Date insurance income	ltd_ins_inc_d	number	precision 15, scale 2
Refund insurance payable	ins_pay_refund_d	number	precision 15, scale 2
Refund insurance commission	ins_com_refund_d	number	precision 15, scale 2
Refund insurance income	ins_inc_refund_d	number	precision 15, scale 2
Payment schedule adjustment method A=Amount T=Term	pmt_sch_meth_c	char	length 1
Previous life-to-date depreciation	prev_ltd_bkd_d	number	precision 15, scale 2
Previous book depreciation basis	prev_taxbasis_d	number	precision 15, scale 2
Previous book salvage value	prev_sal_bkd_d	number	precision 15, scale 2
Depreciation change counter	depr_chg_l	number	precision 10
Previous book depreciation start date	d_prev_bkd_s	date	format YYYYMMDD
Previous book depreciation method	prev_bkd_s	char	length 4
Changed accounting method from FIN to OPER (Y/N)	fin_to_oper_c	char	length 1
Deferred book depreciation amount	def_bkd_d	number	precision 15, scale 2
Deferred book depreciation taken N - Not taken D - Taken by depreciation P - Taken by payoff S = Taken by sale of asset	def_bkd_taken_c	char	length 1
Leveraged (Y/N)	lvr_c	char	length 1
AMT depreciation life	amt_life_l	number	precision 10
Federal depreciation life	fed_life_l	number	precision 10
Deferred tax YTD amount	dfrd_tax_ytd_d	number	precision 15, scale 2
FSC exclusion Y-T-D amount	fsc_ytd_d	number	precision 15, scale 2
Interest expenses Y-T-D amount	int_expn_ytd_d	number	precision 15, scale 2
Off lease billing invoice/rent amount	olb_invo_d	number	precision 15, scale 2
Off lease billing sales tax amount	olb_stax_d	number	precision 15, scale 2
Taxable income Y-T-D amount	tax_inc_ytd_d	number	precision 15, scale 2
Previous Y-T-D federal AMT depreciation	prev_ytd_fed_amt_d	number	precision 15, scale 2
Previous Y-T-D federal depreciation	prev_ytd_fed_d	number	precision 15, scale 2
Previous Y-T-D state depreciation	prev_ytd_st_d	number	precision 15, scale 2
Optional residual	opt_res_d	number	precision 15, scale 2
Property tax exempt code	ptax_exempt_s	char	length 4
Property tax last used date	d_ptax_last_used_s	date	format YYYYMMDD
Sales/use tax exempt code	stax_exempt_s	char	length 4
Utilize vehicle tax rates (Y/N)	utilize_veh_tax_rates_c	char	length 1
Payoff quote preparation date	d_payoff_quote_s	date	format YYYYMMDD
Custom payoff quote amount [1]	custom_payoff_quote1_d	number	precision 15, scale 2
Custom payoff quote amount [2]	custom_payoff_quote2_d	number	precision 15, scale 2
Custom payoff quote amount [3]	custom_payoff_quote3_d	number	precision 15, scale 2
Custom payoff quote amount [4]	custom_payoff_quote4_d	number	precision 15, scale 2
Custom payoff quote amount [5]	custom_payoff_quote5_d	number	precision 15, scale 2
Total initial direct costs	idc_d	number	precision 15, scale 2
IDC current month amortization - book	idc_cur_d	number	precision 15, scale 2
Unamortized IDC - book	idc_rem_d	number	precision 15, scale 2
Suspended IDC accrued	susp_idc_acc_d	number	precision 15, scale 2
Insurance premium unearned IDC1	idc1_ins_prem_ue_d	number	precision 15, scale 2
Insurance premium suspended IDC1	idc1_ins_prem_susp_d	number	precision 15, scale 2
Insurance premium current IDC1	idc1_ins_prem_cur_d	number	precision 15, scale 2
Insurance premium year-to-date IDC1	idc1_ins_prem_ytd_d	number	precision 15, scale 2
Notary fee IDC2	idc2_notary_fee_d	number	precision 15, scale 2
Notary fee unearned IDC2	idc2_notary_fee_ue_d	number	precision 15, scale 2
Notary fee suspended IDC2	idc2_notary_fee_susp_d	number	precision 15, scale 2
Notary fee current IDC2	idc2_notary_fee_cur_d	number	precision 15, scale 2
Notary fee year-to-date IDC2	idc2_notary_fee_ytd_d	number	precision 15, scale 2
Insurance fee IDR1	idr1_ins_fee_d	number	precision 15, scale 2
Insurance fee unearned IDR1	idr1_ins_fee_ue_d	number	precision 15, scale 2
Insurance fee suspended IDR1	idr1_ins_fee_susp_d	number	precision 15, scale 2
Insurance fee current IDR1	idr1_ins_fee_cur_d	number	precision 15, scale 2
Insurance fee year-to-date IDR1	idr1_ins_fee_ytd_d	number	precision 15, scale 2
Registration fee IDR2	idr2_reg_fee_d	number	precision 15, scale 2
Registration fee unearned IDR2	idr2_reg_fee_ue_d	number	precision 15, scale 2
Registration fee suspended IDR2	idr2_reg_fee_susp_d	number	precision 15, scale 2
Registration fee current IDR2	idr2_reg_fee_cur_d	number	precision 15, scale 2
Registration fee year-to-date IDR2	idr2_reg_fee_ytd_d	number	precision 15, scale 2
Dealer subsidy IDR3	idr3_dlr_subsidy_d	number	precision 15, scale 2
Dealer subsidy unearned IDR3	idr3_dlr_subsidy_ue_d	number	precision 15, scale 2
Dealer subsidy suspended IDR3	idr3_dlr_subsidy_susp_d	number	precision 15, scale 2
Dealer subsidy current IDR3	idr3_dlr_subsidy_cur_d	number	precision 15, scale 2
Dealer subsidy year-to-date IDR3	idr3_dlr_subsidy_ytd_d	number	precision 15, scale 2
Open commission IDR4	idr4_open_comm_d	number	precision 15, scale 2
Open commission unearned IDR4	idr4_open_comm_ue_d	number	precision 15, scale 2
Open commission suspended IDR4	idr4_open_comm_susp_d	number	precision 15, scale 2
Open commission current IDR4	idr4_open_comm_cur_d	number	precision 15, scale 2
Open commission year-to-date IDR4	idr4_open_comm_ytd_d	number	precision 15, scale 2
Security deposit	sec_d	number	precision 15, scale 2
Suspended lessor income accrued	susp_l_acc_d	number	precision 15, scale 2
Lessor rental income accrued P-T-D	l_in_ptd_d	number	precision 15, scale 2
Lessor current month rent income	l_in_cur_d	number	precision 15, scale 2
Monthly rental depreciation	dp_mly_d	number	precision 15, scale 2
Unrecognized operating income	unrec_in_d	number	precision 15, scale 2
Deferred residual reduction	dfrd_residual_red_d	number	precision 15, scale 2
Operating lease princpal/income adjustment	op_bill_adj_d	number	precision 15, scale 2

rhqa Indexes

Index Name	Piece 1	Piece 2	Piece 3	Piece 4
rhqa_idx0	lse_s	ext_num_s	unit_s	unique_l

Parent Table Listing

Table Name	Description
rhq	Historical Asset for Lease Extension/Reversal

Data Type Definitions and Characteristics

Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.

char

Oracle fixed length character string. Typically used to store short-length string data such as keys, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

date

Oracle date and time, containing century, year, month, day, hour, minute, and second information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

number

Oracle numeric data type. Used for all numbers.
Characteristics:

• precision - The magnitude and fractional granularity together, meaning the maximum number of places available to both the left and right of the decimal point. Use precision minus scale to determine the maximum number of places available to the left of the decimal point.
• scale - The fractional granularity, meaning the maximum number of places available to the right of the decimal point.

varchar2

Oracle variable length character string. Typically used to store medium and long-length string data such as names, addresses, descriptions, and notebook entries.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

LeasePak Documentation Suite

© by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the 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; 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.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.