rsp Table: Customer Service User Profile
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rsp Table: Customer Service User Profile

Indexes

Name Segment 1
rsp_idx0 opr_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
opr_s
Operator initials
CHAR(3) no
stamp_l
Record modification stamp
NUMBER(10) no
s_cus_mod_c
User may access corresponding customer service
  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 customer service user accounts (Y/N)
CHAR(1) yes
sign_s
Default signature name
VARCHAR2(36) yes
title_s
Default signature title
VARCHAR2(25) 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_lse_num_l
WS sort order - lease number
NUMBER(10) yes
ws_les_num_l
WS sort order - lessee number
NUMBER(10) yes
ws_shrt_name_l
WS sort order - short name
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
supervisor_c
Supervisor (Y/N)
CHAR(1) yes
xsl_filename_s
XSL file name
VARCHAR2(25) yes
email_s
Email address
VARCHAR2(50) yes
fax_s
Fax dial number
CHAR(10) yes
phn_s
Phone number
CHAR(10) yes