| 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) |
| Index name | Piece 1 |
|---|---|
| rau_idx0 | opr_s |