ColumnsIndexessp1Parentsp2rpa

rpay Table: Portfolio 2
Sybase DBMS

Specifies the columns and rows with Sybase 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	integer
Record modification stamp	timestamp	timestamp
Gross receivable balance (Y/N)	grs_rec1_s	char	length 40
Net outstanding balance (Y/N)	net_out1_s	char	length 40
Gross outstanding balance (Y/N)	grs_out1_s	char	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	integer
Automatic unsuspended days	auto_unsusp_l	integer
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	double	scale 2
Collection tolerance amount	coll_tol_d	double	scale 2
Assumption fee tolerance amount	asmf_tol_d	double	scale 2
Property tax tolerance amount	prtx_tol_d	double	scale 2
Legal fee tolerance amount	legf_tol_d	double	scale 2
Payment extension tolerance amount	pext_tol_d	double	scale 2
Lease extension tolerance amount	lext_tol_d	double	scale 2
ITC fee tolerance amount	itcf_tol_d	double	scale 2
Federal HWY use tax tolerance amount	fhut_tol_d	double	scale 2
Lease rewrite fee tolerance amount	lsrw_tol_d	double	scale 2
Other fee tolerance amount	othf_tol_d	double	scale 2
Sales/use tax tolerance amount	stax_tol_d	double	scale 2
Recurring charge tolerance amount [1]	rcr1_tol_d	double	scale 2
Recurring charge tolerance amount [2]	rcr2_tol_d	double	scale 2
Recurring charge tolerance amount [3]	rcr3_tol_d	double	scale 2
Recurring charge tolerance amount [4]	rcr4_tol_d	double	scale 2
Recurring charge tolerance amount [5]	rcr5_tol_d	double	scale 2
Recurring charge tolerance amount [6]	rcr6_tol_d	double	scale 2
Recurring charge tolerance amount [7]	rcr7_tol_d	double	scale 2
Recurring charge tolerance amount [8]	rcr8_tol_d	double	scale 2
Recurring charge tolerance amount [9]	rcr9_tol_d	double	scale 2
Recurring charge tolerance amount [10]	rcr10_tol_d	double	scale 2
Recurring charge tolerance amount [11]	rcr11_tol_d	double	scale 2
Recurring charge tolerance amount [12]	rcr12_tol_d	double	scale 2
Recurring charge tolerance amount [13]	rcr13_tol_d	double	scale 2
Recurring charge tolerance amount [14]	rcr14_tol_d	double	scale 2
Recurring charge tolerance amount [15]	rcr15_tol_d	double	scale 2
Maximum months that may be added via payment def/ext FIN	max_mths_add_fin_l	integer
Maximum months that may be added via payment def/ext OPR	max_mths_add_opr_l	integer
Reversal suspense limit in days	rev_susp_l	integer
Recurring charge for payoff invoice	payoff_invo_rcr_l	integer
Insurance finance (Y/N)	ins_fin_c	char	length 1
Insurance policy fee	ins_pol_fee_d	double	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	integer
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	integer
Template directory	template_path_s	char	length 120
Document directory	doc_path_s	char	length 120
Credit report directory	crd_rpt_path_s	char	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	integer
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	datetime	format YYYYMMDD
Client assessment name 1	client_asm_name1_s	char	length 20
Client assessment name 2	client_asm_name2_s	char	length 20
Client assessment name 3	client_asm_name3_s	char	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 Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

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

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

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 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.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
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 number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

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.