rau Table: Application User Profile
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rau Table: Application User Profile

Indexes

Name Segment 1
rau_idx0 opr_s

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