| Description | Column | Datatype |
|---|---|---|
| Operator initials | opr_s | char (3) |
| Oracle row stamp | stamp_l | number (10) |
| Field security code [1] | fld_sec1_s | char (4) |
| Field security code [2] | fld_sec2_s | char (4) |
| Field security code [3] | fld_sec3_s | char (4) |
| Field security code [4] | fld_sec4_s | char (4) |
| Field security code [5] | fld_sec5_s | char (4) |
| Field security code [6] | fld_sec6_s | char (4) |
| Field security code [7] | fld_sec7_s | char (4) |
| Field security code [8] | fld_sec8_s | char (4) |
| Field security code [9] | fld_sec9_s | char (4) |
| Field security code [10] | fld_sec10_s | char (4) |
| Field security code [11] | fld_sec11_s | char (4) |
| Field security code [12] | fld_sec12_s | char (4) |
| Field security code [13] | fld_sec13_s | char (4) |
| Field security code [14] | fld_sec14_s | char (4) |
| Field security code [15] | fld_sec15_s | char (4) |
| Field security code [16] | fld_sec16_s | char (4) |
| Field security code [17] | fld_sec17_s | char (4) |
| Field security code [18] | fld_sec18_s | char (4) |
| Field security code [19] | fld_sec19_s | char (4) |
| Field security code [20] | fld_sec20_s | char (4) |
| Field security code [21] | fld_sec21_s | char (4) |
| Field security code [22] | fld_sec22_s | char (4) |
| Field security code [23] | fld_sec23_s | char (4) |
| Field security code [24] | fld_sec24_s | char (4) |
| Field security code [25] | fld_sec25_s | char (4) |
| Field security code [26] | fld_sec26_s | char (4) |
| Field security code [27] | fld_sec27_s | char (4) |
| Field security code [28] | fld_sec28_s | char (4) |
| Field security code [29] | fld_sec29_s | char (4) |
| Field security code [30] | fld_sec30_s | char (4) |
| Field security code [31] | fld_sec31_s | char (4) |
| Field security code [32] | fld_sec32_s | char (4) |
| Field security code [33] | fld_sec33_s | char (4) |
| Field security code [34] | fld_sec34_s | char (4) |
| Field security code [35] | fld_sec35_s | char (4) |
| Field security code [36] | fld_sec36_s | char (4) |
| Field security code [37] | fld_sec37_s | char (4) |
| Application flow code | flow_s | char (4) |
| Application letter code
This array contains only those letters to which the user has access. |
app_let_s | varchar2 (80) |
| User option code
This array contains only those user options to which the user has access. |
usr_opt_s | varchar2 (20) |
| 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) |
| Default application status for DR option | dr_def_new_status_s | char (4) |
| Application modules (Y/N)
This array contains switches that determines if the user has access to a given application menu option/screen. |
s_app_mod_c | varchar2 (30) |
| Modify address information (Y/N) | s_mod_addr_c | char (1) |
| Modify document list (Y/N/R)
Y - can modify all list elements N - cannot modify any list elements R - can modify only unrestricted list elements |
s_mod_doc_c | char (1) |
| Override rate plan (Y/N) | s_over_rplan_c | char (1) |
| Auto-approval privilege (Y/N) | s_appr_priv_c | char (1) |
| Change approval expiration date (Y/N) | s_mod_exp_c | char (1) |
| Modify effective date (Y/N) | s_mod_eff_c | char (1) |
| WS default application/vendor (A/V) | s_app_vend_c | char (1) |
| Approval based on total exposure (Y/N) | s_apprv_tot_exp_c | char (1) |
| Display newer follow-up dates before old dates (Y/N) | s_new_note_first_c | char (1) |
| Application status for new applications | new_app_stat_s | char (4) |
| Default next owner initials [1] | def_nxt_own1_s | char (3) |
| Default next owner initials [2] | def_nxt_own2_s | char (3) |
| Default next owner initials [3] | def_nxt_own3_s | char (3) |
| Default next owner initials [4] | def_nxt_own4_s | char (3) |
| Default next owner initials [5] | def_nxt_own5_s | char (3) |
| Default next owner initials [6] | def_nxt_own6_s | char (3) |
| Default next owner initials [7] | def_nxt_own7_s | char (3) |
| Default next owner initials [8] | def_nxt_own8_s | char (3) |
| Default next owner initials [9] | def_nxt_own9_s | char (3) |
| Default next owner initials [10] | def_nxt_own10_s | char (3) |
| Default next owner initials [11] | def_nxt_own11_s | char (3) |
| Default next owner initials [12] | def_nxt_own12_s | char (3) |
| Default next owner initials [13] | def_nxt_own13_s | char (3) |
| Default next owner initials [14] | def_nxt_own14_s | char (3) |
| Default next owner initials [15] | def_nxt_own15_s | char (3) |
| Default next owner initials [16] | def_nxt_own16_s | char (3) |
| Default next owner initials [17] | def_nxt_own17_s | char (3) |
| Default next owner initials [18] | def_nxt_own18_s | char (3) |
| Default next owner initials [19] | def_nxt_own19_s | char (3) |
| Default next owner initials [20] | def_nxt_own20_s | char (3) |
| Default next owner initials [21] | def_nxt_own21_s | char (3) |
| Default next owner initials [22] | def_nxt_own22_s | char (3) |
| Default next owner initials [23] | def_nxt_own23_s | char (3) |
| Default next owner initials [24] | def_nxt_own24_s | char (3) |
| Default next owner initials [25] | def_nxt_own25_s | char (3) |
| Default next owner initials [26] | def_nxt_own26_s | char (3) |
| Default next owner initials [27] | def_nxt_own27_s | char (3) |
| Default next owner initials [28] | def_nxt_own28_s | char (3) |
| Default next owner initials [29] | def_nxt_own29_s | char (3) |
| Default next owner initials [30] | def_nxt_own30_s | char (3) |
| Default next owner initials [31] | def_nxt_own31_s | char (3) |
| Default next owner initials [32] | def_nxt_own32_s | char (3) |
| Default next owner initials [33] | def_nxt_own33_s | char (3) |
| Default next owner initials [34] | def_nxt_own34_s | char (3) |
| Default next owner initials [35] | def_nxt_own35_s | char (3) |
| Default next owner initials [36] | def_nxt_own36_s | char (3) |
| Default next owner initials [37] | def_nxt_own37_s | char (3) |
| Default letter1 [1] | def_letter1_1_s | char (6) |
| Default letter1 [2] | def_letter1_2_s | char (6) |
| Default letter1 [3] | def_letter1_3_s | char (6) |
| Default letter1 [4] | def_letter1_4_s | char (6) |
| Default letter1 [5] | def_letter1_5_s | char (6) |
| Default letter1 [6] | def_letter1_6_s | char (6) |
| Default letter1 [7] | def_letter1_7_s | char (6) |
| Default letter1 [8] | def_letter1_8_s | char (6) |
| Default letter1 [9] | def_letter1_9_s | char (6) |
| Default letter1 [10] | def_letter1_10_s | char (6) |
| Default letter1 [11] | def_letter1_11_s | char (6) |
| Default letter1 [12] | def_letter1_12_s | char (6) |
| Default letter1 [13] | def_letter1_13_s | char (6) |
| Default letter1 [14] | def_letter1_14_s | char (6) |
| Default letter1 [15] | def_letter1_15_s | char (6) |
| Default letter1 [16] | def_letter1_16_s | char (6) |
| Default letter1 [17] | def_letter1_17_s | char (6) |
| Default letter1 [18] | def_letter1_18_s | char (6) |
| Default letter1 [19] | def_letter1_19_s | char (6) |
| Default letter1 [20] | def_letter1_20_s | char (6) |
| Default letter1 [21] | def_letter1_21_s | char (6) |
| Default letter1 [22] | def_letter1_22_s | char (6) |
| Default letter1 [23] | def_letter1_23_s | char (6) |
| Default letter1 [24] | def_letter1_24_s | char (6) |
| Default letter1 [25] | def_letter1_25_s | char (6) |
| Default letter1 [26] | def_letter1_26_s | char (6) |
| Default letter1 [27] | def_letter1_27_s | char (6) |
| Default letter1 [28] | def_letter1_28_s | char (6) |
| Default letter1 [29] | def_letter1_29_s | char (6) |
| Default letter1 [30] | def_letter1_30_s | char (6) |
| Default letter1 [31] | def_letter1_31_s | char (6) |
| Default letter1 [32] | def_letter1_32_s | char (6) |
| Default letter1 [33] | def_letter1_33_s | char (6) |
| Default letter1 [34] | def_letter1_34_s | char (6) |
| Default letter1 [35] | def_letter1_35_s | char (6) |
| Default letter1 [36] | def_letter1_36_s | char (6) |
| Default letter1 [37] | def_letter1_37_s | char (6) |
| Default letter2 [1] | def_letter2_1_s | char (6) |
| Default letter2 [2] | def_letter2_2_s | char (6) |
| Default letter2 [3] | def_letter2_3_s | char (6) |
| Default letter2 [4] | def_letter2_4_s | char (6) |
| Default letter2 [5] | def_letter2_5_s | char (6) |
| Default letter2 [6] | def_letter2_6_s | char (6) |
| Default letter2 [7] | def_letter2_7_s | char (6) |
| Default letter2 [8] | def_letter2_8_s | char (6) |
| Default letter2 [9] | def_letter2_9_s | char (6) |
| Default letter2 [10] | def_letter2_10_s | char (6) |
| Default letter2 [11] | def_letter2_11_s | char (6) |
| Default letter2 [12] | def_letter2_12_s | char (6) |
| Default letter2 [13] | def_letter2_13_s | char (6) |
| Default letter2 [14] | def_letter2_14_s | char (6) |
| Default letter2 [15] | def_letter2_15_s | char (6) |
| Default letter2 [16] | def_letter2_16_s | char (6) |
| Default letter2 [17] | def_letter2_17_s | char (6) |
| Default letter2 [18] | def_letter2_18_s | char (6) |
| Default letter2 [19] | def_letter2_19_s | char (6) |
| Default letter2 [20] | def_letter2_20_s | char (6) |
| Default letter2 [21] | def_letter2_21_s | char (6) |
| Default letter2 [22] | def_letter2_22_s | char (6) |
| Default letter2 [23] | def_letter2_23_s | char (6) |
| Default letter2 [24] | def_letter2_24_s | char (6) |
| Default letter2 [25] | def_letter2_25_s | char (6) |
| Default letter2 [26] | def_letter2_26_s | char (6) |
| Default letter2 [27] | def_letter2_27_s | char (6) |
| Default letter2 [28] | def_letter2_28_s | char (6) |
| Default letter2 [29] | def_letter2_29_s | char (6) |
| Default letter2 [30] | def_letter2_30_s | char (6) |
| Default letter2 [31] | def_letter2_31_s | char (6) |
| Default letter2 [32] | def_letter2_32_s | char (6) |
| Default letter2 [33] | def_letter2_33_s | char (6) |
| Default letter2 [34] | def_letter2_34_s | char (6) |
| Default letter2 [35] | def_letter2_35_s | char (6) |
| Default letter2 [36] | def_letter2_36_s | char (6) |
| Default letter2 [37] | def_letter2_37_s | char (6) |
| Default manager initials for a higher credit approval | def_mgr_s | char (3) |
| Default signature name | def_sign_s | varchar2 (36) |
| Default signature title | def_sign_title_s | varchar2 (25) |
| WS default for ALL (X/' ') | ws_def_all_c | char (1) |
| WS default user initials | ws_def_user_s | char (3) |
| WS default team | ws_def_team_s | char (4) |
| WS default status | ws_def_stat_s | char (4) |
| WS sort order - status | ws_stat_l | number (10) |
| WS sort order - outstanding time | ws_time_l | number (10) |
| WS sort order - short name | ws_shrt_name_l | number (10) |
| WS sort order - application/lease number | ws_number_l | number (10) |
| WS sort order - application amount | ws_amt_l | number (10) |
| WS sort order - user initials | ws_opr_l | number (10) |
| WS sort order - follow-up date | ws_folw_l | number (10) |
| WS sort order - note priority | ws_prior_l | number (10) |
| Percent tolerance for exceeding credit line | perc_tolerance_d | number (15,1) |
| Approval credit limit | appr_lim_d | number (15,2) |
| Dollar tolerance for exceeding credit line | dollar_tolerance_d | number (15,2) |
| Acquisition cost dollar tolerance | acq_doll_tol_d | number (15,2) |
| Acquistion cost percent tolerance | acq_per_tol_d | number (15,1) |
| Documentation fee dollar tolerance | doc_doll_tol_d | number (15,2) |
| Documentation fee percent tolerance | doc_per_tol_d | number (15,1) |
| Down payment dollar tolerance | down_doll_tol_d | number (15,2) |
| Down payment percent tolerance | down_per_tol_d | number (15,1) |
| Payment amount dollar tolerance | pay_doll_tol_d | number (15,2) |
| Payment amount percent tolerance | pay_per_tol_d | number (15,1) |
| Residual dollar tolerance | res_doll_tol_d | number (15,2) |
| Residual percent tolerance | res_per_tol_d | number (15,1) |
| Security deposit dollar tolerance | sec_doll_tol_d | number (15,2) |
| Security deposit percent tolerance | sec_per_tol_d | number (15,1) |
| Delete document file (Y/N) | del_doc_file_c | char (1) |
| Index name | Piece 1 |
|---|---|
| rau_idx0 | opr_s |
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.