rcg Table: Custom General
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

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