reqa Table: Asset 2
Oracle DBMS
Specifies the columns and rows with Oracle data type information for the reqa Asset 2 table.
Parent-Child:
This table has a parent table--click here for a listing.
reqa Columns
| Description | Column Name | Data Type ? | Characteristics ? |
|---|---|---|---|
| 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 |
reqa Indexes
| Index Name | Piece 1 | Piece 2 |
|---|---|---|
| reqa_idx0 | unit_s | unique_l |
Parent Table Listing
| Table Name | Description |
|---|---|
| req | Asset |
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 McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, Inc. is prohibited.