Columns |
Name |
Description |
Datatype ¿? |
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 |