rcp Table: Collection User Profile
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rcp Table: Collection User Profile

Indexes

Name Segment 1
rcp_idx0 opr_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
opr_s
Operator initials
CHAR(3) no
stamp_l
Record modification stamp
NUMBER(10) no
s_col_mod_c
User may access corresponding collection 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
alpha_status_c
Alpha assign by status (X/' ')
  X - Allow access
VARCHAR2(26) yes
all_collect_c
Access all collection user accounts (Y/N)
CHAR(1) yes
alpha_snam_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_col_def_dayl_s
WS default days delinquent low - collection
CHAR(4) yes
ws_col_def_dayh_s
WS default days delinquent high - collection
CHAR(4) yes
ws_def_amtl_s
WS default amount low
CHAR(9) yes
ws_def_amth_s
WS default amount high
CHAR(9) yes
ws_def_stat_s
WS default status
CHAR(4) yes
ws_stat_l
WS sort order - status
NUMBER(10) yes
ws_col_days_l
WS sort order - days delinquent - collection
NUMBER(10) yes
ws_shrt_name_l
WS sort order - short name
NUMBER(10) yes
ws_les_num_l
WS sort order - lessee number
NUMBER(10) yes
ws_amt_l
WS sort order - reference 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
low_daysd_l
Low number of days delinquent to be assigned
NUMBER(10) yes
high_daysd_l
High number of days delinquent to be assigned
NUMBER(10) yes
low_amt_d
Low reference amount to be assigned
NUMBER(15,2) yes
high_amt_d
High reference amount to be assigned
NUMBER(15,2) yes
ws_def_cus_s
WS default customer
CHAR(9) yes
ws_weight_l
WS sort order weight
NUMBER(10) yes
call_c
Display accounts legal to call only (Y/N)
CHAR(1) yes
supervisor_c
Supervisor (Y/N)
CHAR(1) yes
ws_def_queue_s
WS default queue number
CHAR(4) yes
ws_bhv_scr_l
WS sort order - behavioral scoring number
NUMBER(10) 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