| Description | Column | Datatype |
|---|---|---|
| Operator initials | opr_s | char (3) |
| Sybase timestamp | timestamp | timestamp |
| 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 | char (80) |
| User option code
This array contains only those user options to which the user has access. |
usr_opt_s | char (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 | char (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 | char (36) |
| Default signature title | def_sign_title_s | char (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 | integer |
| WS sort order - outstanding time | ws_time_l | integer |
| WS sort order - short name | ws_shrt_name_l | integer |
| WS sort order - application/lease number | ws_number_l | integer |
| WS sort order - application amount | ws_amt_l | integer |
| WS sort order - user initials | ws_opr_l | integer |
| WS sort order - follow-up date | ws_folw_l | integer |
| WS sort order - note priority | ws_prior_l | integer |
| Percent tolerance for exceeding credit line | perc_tolerance_d | double precision |
| Approval credit limit | appr_lim_d | double precision |
| Dollar tolerance for exceeding credit line | dollar_tolerance_d | double precision |
| Acquisition cost dollar tolerance | acq_doll_tol_d | double precision |
| Acquistion cost percent tolerance | acq_per_tol_d | double precision |
| Documentation fee dollar tolerance | doc_doll_tol_d | double precision |
| Documentation fee percent tolerance | doc_per_tol_d | double precision |
| Down payment dollar tolerance | down_doll_tol_d | double precision |
| Down payment percent tolerance | down_per_tol_d | double precision |
| Payment amount dollar tolerance | pay_doll_tol_d | double precision |
| Payment amount percent tolerance | pay_per_tol_d | double precision |
| Residual dollar tolerance | res_doll_tol_d | double precision |
| Residual percent tolerance | res_per_tol_d | double precision |
| Security deposit dollar tolerance | sec_doll_tol_d | double precision |
| Security deposit percent tolerance | sec_per_tol_d | double precision |
| Delete document file (Y/N) | del_doc_file_c | char (1) |
| Override drawdown credit balance and expiration date (Y/N) | override_drawdown_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.
This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.
If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.
If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.
If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.