rpay Table: Portfolio 2
Oracle DBMS

Specifies the columns and rows with Oracle data type information for the rpay Portfolio 2 table.

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

rpay Columns

Description	Column Name	Data Type ?	Characteristics ?
Portfolio	por_s	char	length 2
Record number	unique_l	number	precision 10
Record modification stamp	stamp_l	number	precision 10
Gross receivable balance (Y/N)	grs_rec1_s	varchar2	length 40
Net outstanding balance (Y/N)	net_out1_s	varchar2	length 40
Gross outstanding balance (Y/N)	grs_out1_s	varchar2	length 40
Reversed deferment fee to suspense (Y/N)	rev_def_c	char	length 1
Extension/deferment fee required (Y/N)	extdef_c	char	length 1
Allow deferment residual update (Y/N)	def_res_c	char	length 1
Dealer remittance bank code	dlr_rem_bank_s	char	length 3
Automatic suspended days	auto_susp_l	number	precision 10
Automatic unsuspended days	auto_unsusp_l	number	precision 10
Recognize suspended income at payment (Y/N)	susp_inc_c	char	length 1
Batch application status	batch_app_stat_s	char	length 4
Late charge tolerance amount	ltch_tol_d	number	precision 15, scale 2
Collection tolerance amount	coll_tol_d	number	precision 15, scale 2
Assumption fee tolerance amount	asmf_tol_d	number	precision 15, scale 2
Property tax tolerance amount	prtx_tol_d	number	precision 15, scale 2
Legal fee tolerance amount	legf_tol_d	number	precision 15, scale 2
Payment extension tolerance amount	pext_tol_d	number	precision 15, scale 2
Lease extension tolerance amount	lext_tol_d	number	precision 15, scale 2
ITC fee tolerance amount	itcf_tol_d	number	precision 15, scale 2
Federal HWY use tax tolerance amount	fhut_tol_d	number	precision 15, scale 2
Lease rewrite fee tolerance amount	lsrw_tol_d	number	precision 15, scale 2
Other fee tolerance amount	othf_tol_d	number	precision 15, scale 2
Sales/use tax tolerance amount	stax_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [1]	rcr1_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [2]	rcr2_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [3]	rcr3_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [4]	rcr4_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [5]	rcr5_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [6]	rcr6_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [7]	rcr7_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [8]	rcr8_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [9]	rcr9_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [10]	rcr10_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [11]	rcr11_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [12]	rcr12_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [13]	rcr13_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [14]	rcr14_tol_d	number	precision 15, scale 2
Recurring charge tolerance amount [15]	rcr15_tol_d	number	precision 15, scale 2
Maximum months that may be added via payment def/ext FIN	max_mths_add_fin_l	number	precision 10
Maximum months that may be added via payment def/ext OPR	max_mths_add_opr_l	number	precision 10
Reversal suspense limit in days	rev_susp_l	number	precision 10
Recurring charge for payoff invoice	payoff_invo_rcr_l	number	precision 10
Insurance finance (Y/N)	ins_fin_c	char	length 1
Insurance policy fee	ins_pol_fee_d	number	precision 15, scale 2
Include IDC and IDR in calculating IRR (Y/N)	idc_idr_in_irr_c	char	length 1
Include open commission in calculating IRR (Y/N)	open_comm_in_irr_c	char	length 1
Change book accounting and depreciation methods (Y/N)	chg_acct_bkd_c	char	length 1
Principal write down (Y/N)	prn_write_down_c	char	length 1
Automatic payoff of CSA leases (Y/N)	auto_payo_csa_c	char	length 1
Calculate book depreciation on suspended leases (Y/N)	susp_bkd_c	char	length 1
EOM pre-accrual and invoicing (Y/N)	eom_pre_acc_c	char	length 1
Prorate income, IDC/IDR and depreciation (Y/N)	prorate_inc_idc_depr_c	char	length 1
Take income on PRN payoff for suspended simple interest lease (Y/N)	take_incm_susp_prn_c	char	length 1
Take income on OPR payoff for suspended operating lease (Y/N)	take_incm_susp_opr_c	char	length 1
Take income on INV termination for suspended operating lease (Y/N)	take_incm_susp_inv_o_c	char	length 1
Use third-party payoff quote (Y/N)	use_quote_c	char	length 1
Default refund bank	refund_bank_s	char	length 3
Refund check date deferral	refund_defr_l	number	precision 10
Asset percentage calculation method	unit_pct_calc_c	char	length 1
Verify sum of payments (Y/N)	ver_sum_pmt_c	char	length 1
Off lease billing apply rent amount to base payoff (Y/N)	olb_rent_base_c	char	length 1
NSF assessment code	nsf_assmt_code_s	char	length 4
Post unbilled income to gain/loss (Y/N)	post_unb_gnls_c	char	length 1
Take unrecognized OPR income at payoff (Y/N)	unrec_opr_inc_payo_c	char	length 1
Notebook follow-up days	note_follow_up_l	number	precision 10
Template directory	template_path_s	varchar2	length 120
Document directory	doc_path_s	varchar2	length 120
Credit report directory	crd_rpt_path_s	varchar2	length 120
FASB 13 IRR for NPV calculation (A/B/C) A - use p_con_d B - use p_irr_d C - use p_irr_nr_d	fasb13_irr_c	char	length 1
Calculate payment history (Y/N)	calc_pmt_hist_c	char	length 1
Cost per use assessment code	cpu_assmt_code_s	char	length 4
Recurring charge code for American Lease Insurance	rcr_ali_s	char	length 4
Default bank code for security deposit disbursal	cc_sec_bank_s	char	length 3
Hold security deposit in payoff/termination (Y/N)	hold_sec_c	char	length 1
Period in days to hold security deposit before disbursal	hold_sec_days_l	number	precision 10
Cash Control used (Y/N)	cash_control_used_c	char	length 1
Lease level cost per use assessment code	lse_cpu_assmt_code_s	char	length 4
Batch application disbursal bank account GL vector	batch_app_disb_bank_s	char	length 3
Recurring charge code for IDR6	rcr_idr6_s	char	length 4
Recurring charge code for IDRB	rcr_idrb_s	char	length 4
Automatically calculate interim rent on applications (Y/N)	auto_calc_app_interim_rent_c	char	length 1
Accrue IBL interest after maturity (Y/N)	ibl_int_after_mat_c	char	length 1
Date of last Paynet export	d_last_paynet_export_s	date	format YYYYMMDD
Client assessment name 1	client_asm_name1_s	varchar2	length 20
Client assessment name 2	client_asm_name2_s	varchar2	length 20
Client assessment name 3	client_asm_name3_s	varchar2	length 20
Invoice asset detail (N/P/T) N - None P - Prorate T - Top Down	invo_unit_detl_c	char	length 1

rpay Indexes

Index Name	Piece 1	Piece 2
rpay_idx0	por_s	unique_l

Parent Table Listing

Table Name	Description
rpa	Portfolio

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.0b Documentation Suite

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