rpd Table: Payoff Quote
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rpd Payoff Quote table.

rpd Columns

DescriptionColumn NameData Type ?Characteristics ?
Leaselse_sCHAR(10)
Record modification stampstamp_lNUMBER(10)
Assetunit_sCHAR(10)
Effective dated_eff_sDATE
FMV dated_fmv_sDATE
Quote dated_quote_sDATE
Quote timet_quote_sCHAR(6)
Good until dated_good_sDATE
Methodmethod_sCHAR(4)
Quote type (P/T)quote_type_cCHAR(1)
Future payments received (Y/N)pmt_recd_cCHAR(1)
FMV referenceref_sVARCHAR2(36)
Comments [1]commt1_sVARCHAR2(80)
Comments [2]commt2_sVARCHAR2(80)
Operator initialsopr_sCHAR(3)
Base ratebase_sCHAR(4)
Base payoff amount defaultbase_def_sCHAR(4)
Portfolio tax ratetax_dNUMBER(15,5)
Interest raterate_dNUMBER(15,5)
FMV quotefmv_dNUMBER(15,2)
Wear & tearwear_dNUMBER(15,2)
Excess mileagemileage_dNUMBER(15,2)
Base payoff amountbase_dNUMBER(15,2)
Payment delinquentpmt_dlnq_dNUMBER(15,2)
Payments currentpmt_curr_dNUMBER(15,2)
Assessments outstandingasm_outs_dNUMBER(15,2)
Fee/penaltyfee_dNUMBER(15,2)
Sales taxsales_tax_dNUMBER(15,2)
ITC recaptureditc_dNUMBER(15,2)
Additional chargesadd_dNUMBER(15,2)
Total quotequote_dNUMBER(15,2)
Security depositsec_dNUMBER(15,2)
Use taxuse_tax_dNUMBER(15,2)
Late chargeslate_dNUMBER(15,2)
ITC reverseditc_rev_dNUMBER(15,2)
Per diemdiem_dNUMBER(15,2)
Base amount for terminationbas_wo_dNUMBER(15,2)
Interest adjustmentint_adj_dNUMBER(15,2)
Base taxable amountbase_amt_dNUMBER(15,2)
Create payoff quote invoice (Y/N)invoice_cCHAR(1)
Credit life insurance 1 rebatecr_lif1_re_dNUMBER(15,2)
Credit life insurance 2 rebatecr_lif2_re_dNUMBER(15,2)
Credit disability insurance 1 rebatecr_dis1_re_dNUMBER(15,2)
Credit disability insurance 2 rebatecr_dis2_re_dNUMBER(15,2)
Exclude unguaranteed residual amountexcl_unguar_res_cCHAR(1)
Collection feescol_fee_dNUMBER(15,2)
Assumption feesass_fee_dNUMBER(15,2)
Legal feesleg_fee_dNUMBER(15,2)
Payment extension feespmt_ext_fee_dNUMBER(15,2)
Lease extension feeslse_ext_fee_dNUMBER(15,2)
Lease rewrite feeslsrw_fee_dNUMBER(15,2)
Other chargesother_dNUMBER(15,2)
Maintenance feemaint_dNUMBER(15,2)
Property taxprop_tax_dNUMBER(15,2)
Federal highway use tax feefhut_fee_dNUMBER(15,2)
Adjust payoff assessments (Y/N)adj_payoff_asm_cCHAR(1)
Recurring charge [1]rcr1_dNUMBER(15,2)
Recurring charge [2]rcr2_dNUMBER(15,2)
Recurring charge [3]rcr3_dNUMBER(15,2)
Recurring charge [4]rcr4_dNUMBER(15,2)
Recurring charge [5]rcr5_dNUMBER(15,2)
Recurring charge [6]rcr6_dNUMBER(15,2)
Recurring charge [7]rcr7_dNUMBER(15,2)
Recurring charge [8]rcr8_dNUMBER(15,2)
Recurring charge [9]rcr9_dNUMBER(15,2)
Recurring charge [10]rcr10_dNUMBER(15,2)
Recurring charge [11]rcr11_dNUMBER(15,2)
Recurring charge [12]rcr12_dNUMBER(15,2)
Recurring charge [13]rcr13_dNUMBER(15,2)
Recurring charge [14]rcr14_dNUMBER(15,2)
Recurring charge [15]rcr15_dNUMBER(15,2)
Total per diem amounttot_diem_dNUMBER(15,2)
Days of per diemdays_diem_lNUMBER(10)
Batch numberbatch_num_sCHAR(6)
Payoff quote level (L/A)
  L - Lease
  A - Asset		payoff_lvl_cCHAR(1)

rpd Indexes

Index NamePiece 1Piece 2Piece 3Piece 4Piece 5
rpd_idx0lse_sd_quote_st_quote_sbatch_num_sunit_s
rpd_idx1batch_num_sunit_slse_sd_quote_st_quote_s
rpd_idx2unit_sbatch_num_slse_sd_quote_st_quote_s

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 6.2a Documentation Suite

© 2010 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.