rkp Table: Collateral User Profile
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rkp Table: Collateral User Profile

Indexes

Name Segment 1
rkp_idx0 opr_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
opr_s
Operator initials
CHAR(3) no
stamp_l
Record modification stamp
NUMBER(10) no
s_kol_mod_c
User may access corresponding collateral menu option (Y/N)
VARCHAR2(30) yes
s_new_note_first_c
Display newer follow-up dates before old dates (Y/N)
CHAR(1) yes
all_c
Access all collateral user accounts (Y/N)
CHAR(1) yes
alpha_c
Alpha assign by short name (X/' ')
  X - Allow access
VARCHAR2(26) yes
sign_s
Default signature name
VARCHAR2(36) yes
title_s
Default signature title
VARCHAR2(25) yes
let_cd_s
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
ws_def_all_c
WS default for ALL (X/' ')
CHAR(1) yes
ws_def_team_s
WS default team
CHAR(4) yes
ws_def_user_s
WS default user initials
CHAR(3) yes
ws_kol_def_dayl_s
WS default days acquisition low - collateral
CHAR(4) yes
ws_kol_def_dayh_s
WS default days acquisition high - collateral
CHAR(4) yes
ws_kol_days_l
WS sort order - days acquisition - collateral
NUMBER(10) yes
ws_shrt_name_l
WS sort order - short name
NUMBER(10) yes
ws_lse_nums_l
WS sort order - lease number
NUMBER(10) yes
ws_unit_num_l
WS sort order - asset number
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
alpha_type_c
Alpha assign by tracking type
VARCHAR2(26) yes
email_s
Email address
VARCHAR2(50) yes
fax_s
Fax dial number
CHAR(10) yes
phn_s
Phone number
CHAR(10) yes