ColumnsIndexessp1Childsp2raparapdraphrappraprraps

rap Table: Application
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rap Application table.

Parent-Child: This table has one or more child tables--click here for a listing.

rap Columns

Description	Column Name	Data Type ?	Characteristics ?
Portfolio	por_s	char	length 2
Company	com_s	char	length 2
Region	reg_s	char	length 2
Office	off_s	char	length 3
Application	app_s	char	length 10
Record modification stamp	stamp_l	number	precision 10
Vendor	dlr_s	char	length 9
Broker	brk_s	char	length 9
Investor	inv_s	char	length 9
Lessee number	les_s	char	length 9
Lease	lse_s	char	length 10
Lease date	d_lsd_s	date	format YYYYMMDD
Lease commencement date	d_com_s	date	format YYYYMMDD
Disbursement date	d_dis_s	date	format YYYYMMDD
Maturity date	d_mat_s	date	format YYYYMMDD
Custom date 1	d_cus1_s	date	format YYYYMMDD
Document sent date	d_doc_sent_s	date	format YYYYMMDD
Approval expiration date	d_exp_s	date	format YYYYMMDD
Documentation completion date	d_doc_comp_s	date	format YYYYMMDD
Line of credit start date Date the line of credit was created. This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')	d_start_s	date	format YYYYMMDD
Original line of credit expiration date This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')	d_orig_exp_s	date	format YYYYMMDD
Current line of credit expiration date This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')	d_curr_exp_s	date	format YYYYMMDD
Accrual method lessor	acc_l_s	char	length 4
Accrual method vendor	acc_d_s	char	length 4
Accrual method investor	acc_i_s	char	length 4
Lease source	dir_s	char	length 4
Lease form code	frm_s	char	length 4
Delinquency watch code	del_s	char	length 4
Broker payment code	brk_pay_s	char	length 4
Late charge assess	late_s	char	length 4
Lease type code	ls_typ_s	char	length 4
Custom code 1	c_cus1_s	char	length 4
Custom code 2	c_cus2_s	char	length 4
Custom code 3	c_cus3_s	char	length 4
Purchase option billing method	po_meth_s	char	length 4
Purchase option	pur_opt_s	char	length 4
Reasons/conditions [1]	dec1_s	char	length 4
Reasons/conditions [2]	dec2_s	char	length 4
Reasons/conditions [3]	dec3_s	char	length 4
Reasons/conditions [4]	dec4_s	char	length 4
Reasons/conditions [5]	dec5_s	char	length 4
Reasons/conditions [6]	dec6_s	char	length 4
Purchase option owner	pur_opt_owner_s	char	length 4
Market code	mkt_s	char	length 4
Account code	acc_code_s	char	length 4
Application type	typ_s	char	length 4
Rate plan	rp_s	char	length 4
Upfront sales tax code	stax_cd_s	char	length 4
Documentation type code	doc_cd_s	char	length 4
Prime rate bank number	prim_num_s	char	length 4
Late charge index	lat_ind_s	char	length 4
IDC accounting method	idc_acct_s	char	length 4
Product type code	prd_s	char	length 4
CCA accrual method	cca_acc_s	char	length 4
Business/personal (B/P)	bus_c	char	length 1
Type of lease, open or closed (O/C)	opn_c	char	length 1
Assumed payment (Y/N)	a_pmt_c	char	length 1
Residual income separated (Y/N)	res_inc_c	char	length 1
Refundable (Y/N)	refund_c	char	length 1
Pre-authorize switch (Y/N)	pap_pmt_c	char	length 1
Billing level (C/L/I) C - Customer L - Lessee I - Individual	b_lvl_c	char	length 1
Funding interest modified by user (Y/N)	stub_amt_mod_c	char	length 1
IDC modified by user (Y/N)	idc_mod_c	char	length 1
Tax IDC modified by user (Y/N)	idc_tax_mod_c	char	length 1
Statement code (I/C/F/N/' ') I - individual invoice format C - coupon books F - group invoice format N - billing method outside of LeasePak	stmt_c	char	length 1
Normal/master/sub application (N/M/S) N - Normal M - Master S - Sub (part of Master)	norm_mas_sub_c	char	length 1
CCA fixed rate (Y/N)	cca_fix_c	char	length 1
Automatic charge off (Y/N/D) Y - Lease will be automatically charged off after delinquent for more than 120 days. N - No automatic charge off. D - Lease will defer charge off for 1 month.	auto_charge_c	char	length 1
General description	desc_s	varchar2	length 36
Custom string 1	s_cus1_s	char	length 10
Custom string 2	s_cus2_s	char	length 10
Trade-in description	trd_desc_s	varchar2	length 36
Vendor contact name	dlr_cont_s	varchar2	length 36
Vendor phone number	dlr_phn_s	char	length 10
Broker contact name	brk_cont_s	varchar2	length 36
Broker phone number	brk_phn_s	char	length 10
Lease address name	lse_nam_s	varchar2	length 36
Lease address	lse_add_s	varchar2	length 36
Lease address 2	lse_add2_s	varchar2	length 36
Lease address city	lse_cty_s	varchar2	length 25
Lease address state	lse_st_s	char	length 2
Lease address zip code	lse_zip_s	char	length 9
Default application	def_appln_s	char	length 10
Billing address name	bill_nam_s	varchar2	length 36
Billing address	bill_add_s	varchar2	length 36
Billing address 2	bill_add2_s	varchar2	length 36
Billing address city	bill_cty_s	varchar2	length 25
Billing address state	bill_st_s	char	length 2
Billing address zip code	bill_zip_s	char	length 9
Group number	grp_s	char	length 3
Master application number This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a sub-application. (i.e. norm_mas_sub_c = 'S')	master_app_s	char	length 10
Vendor factor	p_dlr_d	number	precision 15, scale 5
Lease term	trm_l	number	precision 10
Estimated lease term	est_trm_l	number	precision 10
Payment due day	due_l	number	precision 10
Grace period in days	grc_l	number	precision 10
Lessor yield	p_con_d	number	precision 15, scale 7
Vendor yield	p_dly_d	number	precision 15, scale 7
Investor yield factor	p_inv_yld_d	number	precision 15, scale 7
Cost of funds	p_fund_d	number	precision 15, scale 5
NPV discount rate	p_erly_pay_d	number	precision 15, scale 5
IRR (yield)	p_irr_d	number	precision 15, scale 7
IRR (yield) without residual	p_irr_nr_d	number	precision 15, scale 7
Bad debt percentage	bad_debt_d	number	precision 15, scale 5
Custom integer 1	i_cus1_l	number	precision 10
Custom integer 2	i_cus2_l	number	precision 10
Lease factor	factor_d	number	precision 15, scale 7
Residual percentage If entered by the user, tot_res_d is also calculated and stored.	p_res_d	number	precision 15, scale 5
Lessor rental simple rate	p_rent_d	number	precision 15, scale 5
Lessor rental rate add-on	p_byrt_d	number	precision 15, scale 5
Contract rental rate add-on	p_cntr_d	number	precision 15, scale 5
Investor rental simple rate	p_rent_i_d	number	precision 15, scale 5
Investor rental rate add-on	p_inv_d	number	precision 15, scale 5
Vendor rental simple rate	p_rent_d_d	number	precision 15, scale 5
Rate of participation	p_part_d	number	precision 15, scale 5
Maximum interest rate - lease level	p_max_d	number	precision 15, scale 5
Minimum interest rate - lease level	p_min_d	number	precision 15, scale 5
Total acquisition cost	tot_org_d	number	precision 15, scale 2
Other charges	tot_other_d	number	precision 15, scale 2
Security deposit	sec_d	number	precision 15, scale 2
Down payment	cap_d	number	precision 15, scale 2
Documentation fee	up_d	number	precision 15, scale 2
Interim rent	pro_d	number	precision 15, scale 2
Broker fees	brk_fee_d	number	precision 15, scale 2
Total initial direct costs	idc_d	number	precision 15, scale 2
Residual amount If tot_res_d is entered by the user, the value of p_res_d is erased.	tot_res_d	number	precision 15, scale 2
Guaranteed portion of residual	res_guar_d	number	precision 15, scale 2
Mark up	mrk_up_d	number	precision 15, scale 2
In-house fee	in_fee_d	number	precision 15, scale 2
Funding interest owed (-) or earned (+)	stub_fund_amt_d	number	precision 15, scale 2
NPV of payment stream	npv_d	number	precision 15, scale 2
Titling tax paid up-front	tax_paid_d	number	precision 15, scale 2
Custom float 1	f_cus1_d	number	precision 15, scale 2
Custom float 2	f_cus2_d	number	precision 15, scale 2
Custom float 3	f_cus3_d	number	precision 15, scale 2
Custom float 4	f_cus4_d	number	precision 15, scale 2
Custom float 5	f_cus5_d	number	precision 15, scale 2
Fixed price purchase	fp_amt_d	number	precision 15, scale 2
Compensation amount	comm_d	number	precision 15, scale 2
Upfront sales tax on cost	stax_d	number	precision 15, scale 2
Trade-in	trade_in_d	number	precision 15, scale 2
Advanced money received	adv_rec_d	number	precision 15, scale 2
Tax IDC	idc_tax_d	number	precision 15, scale 2
Acquisition cost at approval for field security tolerance	apprv_org_d	number	precision 15, scale 2
Down payment at approval for field security tolerance	apprv_cap_d	number	precision 15, scale 2
Documentation fee at approval for field security tolerance	apprv_up_d	number	precision 15, scale 2
Residual amount at approval for field security tolerance	apprv_res_d	number	precision 15, scale 2
Payment amount at approval for field security tolerance regular payment schedules only	apprv_pmt_d	number	precision 15, scale 2
Security deposit at approval for field security tolerance	apprv_sec_d	number	precision 15, scale 2
Drawdown amount at application approval/book	drawdown_amt_d	number	precision 15, scale 2
Credit limit amount This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')	credit_lim_d	number	precision 15, scale 2
Credit balance amount This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M')	credit_bal_d	number	precision 15, scale 2
Payment frequency code (regular payment schedules)	pmt_cd_reg_s	char	length 4
Payment amount (regular payment schedules)	pmt_amt_reg_d	number	precision 15, scale 2
Advanced payments begin	adv_beg_l	number	precision 10
Advanced payments end	adv_end_l	number	precision 10
Capitalize IBL interest (Y/N/' ')	capitalize_interest_c	char	length 1
Insurance premium cost	ins_prem_cost_d	number	precision 15, scale 2
Notary fee payable to	notary_fee_pay_to_s	char	length 9
Insurance premium payable to	ins_prem_pay_to_s	char	length 9
Insurance fee income	ins_fee_incm_d	number	precision 15, scale 2
Notary fee cost	notary_fee_cost_d	number	precision 15, scale 2
Registration fee income	reg_fee_incm_d	number	precision 15, scale 2
Dealer subsidy income	dlr_subsidy_incm_d	number	precision 15, scale 2
Open commission income	open_comm_incm_d	number	precision 15, scale 2
Last status history date	d_his_s	date	format YYYYMMDD
Last status history time	t_his_s	char	length 6
Last status history status code	his_stat_s	char	length 4
Last status history owner	his_owner_s	char	length 3
Last status history transfered by (initials)	his_xfer_s	char	length 3
Date entered	d_ent_s	date	format YYYYMMDD
Time entered (HHMMSS)	t_ent_s	char	length 6
Change lease key is in progress	msi_chg_key_c	char	length 1
Fixed rate reserves IDC3	idc3_d	number	precision 15, scale 2
Standard reserves IDC4	idc4_d	number	precision 15, scale 2
Guaranteed reserves IDC5	idc5_d	number	precision 15, scale 2
Subvention IDR5	idr5_d	number	precision 15, scale 2
Dealer buy down ID6	idr6_d	number	precision 15, scale 2
Credit life insurance 1 IDR7	idr7_d	number	precision 15, scale 2
Credit life insurance 2 IDR8	idr8_d	number	precision 15, scale 2
Credit disability insurance 1 IDR9	idr9_d	number	precision 15, scale 2
Credit disability insurance 2 IDRA	idra_d	number	precision 15, scale 2
Acquisition fee IDRB	idrb_d	number	precision 15, scale 2
Warranty insurance IDRC	idrc_d	number	precision 15, scale 2
Excess MSRP	x_msrp_d	number	precision 15, scale 2
Estimated unearned	l_est_ue_d	number	precision 15, scale 2
Informational down payment amount	inf_dwn_pmt_d	number	precision 15, scale 2
Trade-in make	trade_in_make_s	char	length 15
Trade-in model	trade_in_model_s	char	length 15
Trade-in year	trade_in_year_l	number	precision 10
Trade-in gross allowance	trade_in_gross_allow_d	number	precision 15, scale 2
Trade-in outstanding debt	trade_in_outst_debt_d	number	precision 15, scale 2
Trade-in net allowance	trade_in_net_allow_d	number	precision 15, scale 2
Trade-in cash down	trade_in_cash_dwn_d	number	precision 15, scale 2
Down payment tax	dwn_pmt_tax_d	number	precision 15, scale 2
Dealer recourse	rec_s	char	length 4
Credit quality	cred_quality_s	char	length 4
Optional insurance	opt_ins_s	char	length 4
Account type (P/L/I) P - Prestige Buyer L - Lease I - Retail Installment	acct_type_c	char	length 1
Purchase option fee	purch_option_fee_d	number	precision 15, scale 2
Transfer of equity (Y/N)	tran_eqty_c	char	length 1
Cost of funds 2 (For FCT)	p_fund2_d	number	precision 15, scale 5
Dealer reserves SL depreciation basis	idc_depr_l	number	precision 10
Acquisition fee SL depreciation basis	idrb_depr_l	number	precision 10
Original credit limit	orig_credit_lim_d	number	precision 15, scale 2
Check number	chk_num_s	char	length 10
Revolving credit limit	revolving_limit_d	number	precision 15, scale 2
Revolving credit line fee	p_revolving_line_fee_d	number	precision 15, scale 5
Customer yield	p_cus_d	number	precision 15, scale 7
Insurance risk fee rate	p_ins_risk_fee_d	number	precision 15, scale 5
Insurance risk fee code	ins_risk_fee_s	char	length 4
Total tax credit	orig_tax_crd_d	number	precision 15, scale 2
Sum of payments	sum_pmt_d	number	precision 15, scale 2
Calculated total of payments	calc_pmt_d	number	precision 15, scale 2

rap Indexes

Index Name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5
rap_idx0	por_s	com_s	reg_s	off_s	app_s
rap_idx1	app_s
rap_idx2	dlr_s	app_s
rap_idx3	brk_s	app_s
rap_idx4	inv_s	app_s
rap_idx5	les_s	app_s

Child Table Listing

Table Name	Description
rapa	Application 2
rapd	Application Document
raph	Application Status History
rapp	Application Payment Schedule
rapr	Application Recurring Charge
raps	Application Salesperson

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.