rcg Table: Custom General

Database Reference

rcg Table: Custom General

Child Tables

Name	Description
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

Indexes

Name	Segment 1
rcg_idx0	cntl_rec_s

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