ColumnsIndexessp1Childsp2rcgarcgbrcgfrcggrcglrcgurcgvrcgwrcgxrcgyrcgz

rcg Table: Custom General
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rcg Custom General table.

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

rcg Columns

Description	Column Name	Data Type ?	Characteristics ?
00 - Dummy key	cntl_rec_s	char	length 2
Record modification stamp	timestamp	timestamp
Lease/application numbering method	nxt_lse_s	char	length 4
Client numbering method	cln_num_s	char	length 4
Collection default status	col_statdef_s	char	length 4
Collection default note type	col_def_note_type_s	char	length 4
Application status [1]	app_stat1_s	char	length 4
Application status [2]	app_stat2_s	char	length 4
Application status [3]	app_stat3_s	char	length 4
Application status [4]	app_stat4_s	char	length 4
Application status [5]	app_stat5_s	char	length 4
Application status [6]	app_stat6_s	char	length 4
Application status [7]	app_stat7_s	char	length 4
Application status [8]	app_stat8_s	char	length 4
Application status [9]	app_stat9_s	char	length 4
Application status [10]	app_stat10_s	char	length 4
Application status [11]	app_stat11_s	char	length 4
Application status [12]	app_stat12_s	char	length 4
Application status [13]	app_stat13_s	char	length 4
Application status [14]	app_stat14_s	char	length 4
Application status [15]	app_stat15_s	char	length 4
Application status [16]	app_stat16_s	char	length 4
Application status [17]	app_stat17_s	char	length 4
Application status [18]	app_stat18_s	char	length 4
Application status [19]	app_stat19_s	char	length 4
Application status [20]	app_stat20_s	char	length 4
Application status [21]	app_stat21_s	char	length 4
Application status [22]	app_stat22_s	char	length 4
Application status [23]	app_stat23_s	char	length 4
Application status [24]	app_stat24_s	char	length 4
Application status [25]	app_stat25_s	char	length 4
Application status [26]	app_stat26_s	char	length 4
Application status [27]	app_stat27_s	char	length 4
Application status [28]	app_stat28_s	char	length 4
Application status [29]	app_stat29_s	char	length 4
Application status [30]	app_stat30_s	char	length 4
Application status [31]	app_stat31_s	char	length 4
Application status [32]	app_stat32_s	char	length 4
Application status [33]	app_stat33_s	char	length 4
Application status [34]	app_stat34_s	char	length 4
Application status [35]	app_stat35_s	char	length 4
Application status [36]	app_stat36_s	char	length 4
Application status [37]	app_stat37_s	char	length 4
Microfiche (Y/N)	micro_c	char	length 1
End of Day journaling (Y/N)	s_eod_jou_c	char	length 1
End of Month journaling (Y/N)	s_eom_jou_c	char	length 1
Spawn or attach subprocesses (S/A)	sub_prcs_c	char	length 1
Collection automatic-reassignment (Y/N)	col_auto_c	char	length 1
Collection work schedule amount type (D/G/N/R) D - Delinquent amount outstanding G - Gross outstanding amount N - Net outstanding amount R - Gross receivable amount	col_wsa_c	char	length 1
Credit limit base (R/N/G) R - gross receivable N - net outstanding G - gross outstanding	credit_base_c	char	length 1
Skip collection module in next EOP (Y/N)	col_eop_skip_c	char	length 1
Run collection module only in EOM (Y/N)	col_monthly_c	char	length 1
Portfolio alias - full	f_por_s	char	length 10
Company alias - full	f_com_s	char	length 10
Region alias - full	f_reg_s	char	length 10
Office alias - full	f_off_s	char	length 10
Vendor alias - full	f_dlr_s	char	length 10
Lease alias - full	f_lse_s	char	length 10
Customer alias - full	f_cus_s	char	length 10
Asset alias - full	f_unit_s	char	length 10
Application alias - full	f_app_s	char	length 11
Client alias - full	f_cln_s	char	length 10
Lessee alias - full	f_les_s	char	length 10
Guarantor alias - full	f_grn_s	char	length 10
Broker alias - full	f_brk_s	char	length 10
Investor alias - full	f_inv_s	char	length 10
Supplier alias - full	f_sup_s	char	length 10
Portfolio alias - 5 char	s_por_s	char	length 5
Company alias - 5 char	s_com_s	char	length 5
Region alias - 5 char	s_reg_s	char	length 5
Office alias - 5 char	s_off_s	char	length 5
Vendor alias - 5 char	s_dlr_s	char	length 5
Lease alias - 5 char	s_lse_s	char	length 5
Customer alias - 5 char	s_cus_s	char	length 5
Asset alias - 5 char	s_unit_s	char	length 5
Application alias - 5 char	s_app_s	char	length 5
Client alias - 5 char	s_cln_s	char	length 5
Lessee alias - 5 char	s_les_s	char	length 5
Guarantor alias - 5 char	s_grn_s	char	length 5
Broker alias - 5 char	s_brk_s	char	length 5
Investor alias - 5 char	s_inv_s	char	length 5
Supplier alias - 5 char	s_sup_s	char	length 5
Portfolio alias - 3 char	ss_por_s	char	length 3
Company alias - 3 char	ss_com_s	char	length 3
Region alias - 3 char	ss_reg_s	char	length 3
Office alias - 3 char	ss_off_s	char	length 3
Vendor alias - 3 char	ss_dlr_s	char	length 3
Lease alias - 3 char	ss_lse_s	char	length 3
Customer alias - 3 char	ss_cus_s	char	length 3
Asset alias - 3 char	ss_unit_s	char	length 3
Application alias - 3 char	ss_app_s	char	length 3
Client alias - 3 char	ss_cln_s	char	length 3
Lessee alias - 3 char	ss_les_s	char	length 3
Guarantor alias - 3 char	ss_grn_s	char	length 3
Broker alias - 3 char	ss_brk_s	char	length 3
Investor alias - 3 char	ss_inv_s	char	length 3
Supplier alias - 3 char	ss_sup_s	char	length 3
Portfolio FMS default	por_dfms_s	char	length 2
Company FMS default	com_dfms_s	char	length 2
Region FMS default	reg_dfms_s	char	length 2
Office FMS default	off_dfms_s	char	length 3
Operator user name	opr_usr_s	char	length 25
Temporary note type	tnt_typ_s	char	length 3
Application description	stat_desc1_s	char	length 200
Application description	stat_desc2_s	char	length 200
Application description	stat_desc3_s	char	length 200
Application description	stat_desc4_s	char	length 140
Suggested maximum journal file size (in blocks)	jou_blk_l	integer
Months before temporary notes deleted	tnt_del_l	integer
Next group method	nxt_grp_s	char	length 4
Group alias - full	f_grp_s	char	length 10
Group alias - 5 char	s_grp_s	char	length 5
Group alias - 3 char	ss_grp_s	char	length 3
Lender alias - Full	f_len_s	char	length 10
Lender alias - 5 char	s_len_s	char	length 5
Lender alias - 3 char	ss_len_s	char	length 3
Collateral default note type	kol_def_note_type_s	char	length 4
Maturing lease default note type	ml_def_note_type_s	char	length 4
Consolidate A/P checks (Y/N)	consolidate_ap_checks_c	char	length 1
Vertex run (Y/N/' ')	vertex_run_c	char	length 1
Vertex update date	d_vtx_upd_ymd_s	datetime	format YYYYMMDD
Alternative A/P checks screen (Y/N)	alt_ap_disb_c	char	length 1
Save RTR records (Y/N)	save_dtr_trans_c	char	length 1
Residual income Rule of 12/78ths (Y/N)	res_incm_rule78_c	char	length 1
Adjust asset original cost (Y/N)	adj_orig_cost_c	char	length 1
Interface to PTMS subsystem (Y/N)	ptms_c	char	length 1
Lease or invoice (L/I)	lse_or_invo_c	char	length 1
Asset percentage calculation method	unit_pct_calc_c	char	length 1
Run Vertex interface in next EOP (Y/N)	vertex_eop_run_c	char	length 1
Insurance default note type	ins_def_note_type_s	char	length 4
Run collection weight assessment in EOP (Y/N)	col_assess_weight_c	char	length 1
IBL payment option (A/B)	ibl_pmt_opt_c	char	length 1
Report lessees/guarantors to Credit Bureau (L/G)	cb_rptg_c	char	length 1
Credit Bureau reporting tolerance	cb_tol_d	double	scale 2
Force placed insurance carrier	frc_pl_ins_car_s	char	length 4
Number of months before cleaning up batch control	bc_del_l	integer
Alternate collection screens (Y/N)	alt_coll_scr_c	char	length 1
Alternate customer service screens (Y/N)	alt_cust_scr_c	char	length 1
Extension/Deferment eligibility (Y/N)	ext_def_elig_c	char	length 1
Assign collection by queue (Y/N)	asgn_col_by_q_c	char	length 1
Automatic collection status assignment (Y/N)	auto_col_stat_asgn_c	char	length 1
Multiple due day change restrictions (Y/N)	due_day_chg_rstrc_c	char	length 1
Unix Auditing (Y/N)	load_audit_trgrs_c	char	length 1
Master application status	mstr_app_stat_s	char	length 4
Recovery default note type	rec_def_note_type_s	char	length 4
Recovery minimum payment amount	rec_min_pmt_amt_d	double	scale 2
Run recovery tracking this EOP (Y/N)	run_rec_trck_c	char	length 1
Terms frequency (monthly)	term_freq_c	char	length 1
Update collection WS in real time	col_ws_real_time_c	char	length 1
Process leases this many days after due day	days_after_due_day_l	integer
Days till payoff invoice due date	payoff_invo_days_l	integer
# of invoice numbers to prefetch during [U0411]	nxtnum_prefetch_l	integer
Collection multiple process count	col_multi_proc_l	integer
EOP End multiple process count	eop_end_multi_proc_l	integer
Skip DAVOX in next EOP (Y/N)	davox_eop_skip_c	char	length 1
Track IBL invoice interest detail (Y/N)	ibl_invo_int_dtl_c	char	length 1
Display multiple notes on applications work schedule (Y/N)	multi_note_app_ws_c	char	length 1
Days till property tax due	ppt_due_l	integer
Credit gain on payoff (Y/N)	credit_gain_on_payoff_c	char	length 1
Alternate forecasting report (Y/N)	alt_fcst_rpt_c	char	length 1
DAVOX multi process count	davox_multi_proc_l	integer
Off lease billing to bill on lease due day (Y/N)	olb_invo_due_c	char	length 1
Create history for DLO updates (Y/N)	loc_his_c	char	length 1
Gain taken on IDC at payoff (Y/N)	idc_gain_on_payoff_c	char	length 1
Alternate R0301 report (Y/N)	alt_r0301_c	char	length 1
Compatibility identifier	compat_id_s	char	length 14
Invoice number type (A/N) A - Alphabetic N - Numeric	invo_num_typ_c	char	length 1
Previous compatibility identifier	prev_compat_id_s	char	length 14
Characters excluded from alphabetic invoice numbers	invo_excl_s	char	length 15
Maximum units on lease	max_units_on_lse_l	integer
XSL report template directory	xsl_rpt_template_path_s	char	length 120
Maximum historical passwords to store	max_hist_pwd_l	integer
Minimum special characters in password	min_spec_char_in_pwd_l	integer
Recalculate asset residual (Y/N)	recalc_unit_res_c	char	length 1
Enable vehicle tax rates (Y/N)	enable_veh_tax_rates_c	char	length 1
Minimum password length	min_pwd_length_l	integer
Minimum numeric characters in password	min_num_char_in_pwd_l	integer
Minimum uppercase characters in password	min_upper_char_in_pwd_l	integer
Paynet subscriber id	paynet_subscriber_id_s	char	length 8
Enable GL name history (Y/N)	gl_his_c	char	length 1
Allow duplicate adjacent characters in password (Y/N)	dup_adj_chars_in_pwd_c	char	length 1
Run custom program before EOP Suite processing (Y/N)	run_cstm_before_eop_c	char	length 1
Run custom program after EOP Suite processing (Y/N)	run_cstm_after_eop_c	char	length 1

rcg Indexes

Index Name	Piece 1
rcg_idx0	cntl_rec_s

Child Table Listing

Table Name	Description
rcga	Custom General Assessment
rcgb	Custom General 2
rcgf	Custom General Printer Form
rcgg	Custom General Letter Group
rcgl	Custom General Printer Device
rcgu	Custom General Field Name 1
rcgv	Custom General Field Name 2
rcgw	Custom General Field Name 3
rcgx	Custom General Field Name 4
rcgy	Custom General Field Name 5
rcgz	Custom General Field Name 6

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.