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