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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp yes
s_col_mod_c
User may access corresponding collection menu option (Y/N)
char(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
char(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
char(26) yes
sign_s
Default signature name
char(36) yes
title_s
Default signature title
char(25) yes
let_cd_s
Letter code
  This array contains only those letters
  to which the user has access.
char(80) yes
usr_opt_s
User option code
  This array contains only those user options
  to which the user has access.
char(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
integer yes
ws_col_days_l
WS sort order - days delinquent - collection
integer yes
ws_shrt_name_l
WS sort order - short name
integer yes
ws_les_num_l
WS sort order - lessee number
integer yes
ws_amt_l
WS sort order - reference amount
integer yes
ws_opr_l
WS sort order - user initials
integer yes
ws_folw_l
WS sort order - follow-up date
integer yes
ws_prior_l
WS sort order - note priority
integer yes
low_daysd_l
Low number of days delinquent to be assigned
integer yes
high_daysd_l
High number of days delinquent to be assigned
integer yes
low_amt_d
Low reference amount to be assigned
double precision yes
high_amt_d
High reference amount to be assigned
double precision yes
ws_def_cus_s
WS default customer
char(9) yes
ws_weight_l
WS sort order weight
integer 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
integer yes
xsl_filename_s
XSL file name
char(25) yes
email_s
Email address
char(50) yes
fax_s
Fax dial number
char(10) yes
phn_s
Phone number
char(10) yes