LeasePak 5.2a Database Reference (Sybase)

HomeTableIndexes

rcp Table: Collection User Profile

Description Column Datatype
Operator initials opr_s char (3)
Sybase timestamp timestamp timestamp
Collection options (Y/N) s_col_mod_c char (30)
Display newer follow-up dates before old dates (Y/N) s_new_note_first_c char (1)
Alpha assign by status (X/' ')
  X - Allow access
alpha_status_c char (26)
Access all collection user accounts (Y/N) all_collect_c char (1)
Alpha assign by short name (X/' ')
  X - Allow access
alpha_snam_c char (26)
Default signature name sign_s char (36)
Default signature title title_s char (25)
Letter code
  This array contains only those letters
  to which the user has access.
let_cd_s char (80)
User option code
  This array contains only those user options
  to which the user has access.
usr_opt_s char (20)
WS default for ALL (X/' ') ws_def_all_c char (1)
WS default team ws_def_team_s char (4)
WS default user initials ws_def_user_s char (3)
WS default days delinquent low - collection ws_col_def_dayl_s char (4)
WS default days delinquent high - collection ws_col_def_dayh_s char (4)
WS default amount low ws_def_amtl_s char (9)
WS default amount high ws_def_amth_s char (9)
WS default status ws_def_stat_s char (4)
WS sort order - status ws_stat_l integer
WS sort order - days delinquent - collection ws_col_days_l integer
WS sort order - short name ws_shrt_name_l integer
WS sort order - lessee number ws_les_num_l integer
WS sort order - reference amount ws_amt_l integer
WS sort order - user initials ws_opr_l integer
WS sort order - follow-up date ws_folw_l integer
WS sort order - note priority ws_prior_l integer
Low number of days delinquent to be assigned low_daysd_l integer
High number of days delinquent to be assigned high_daysd_l integer
Low reference amount to be assigned low_amt_d double precision
High reference amount to be assigned high_amt_d double precision
WS default customer ws_def_cus_s char (9)
WS sort order weight ws_weight_l integer
Display accounts legal to call only (Y/N) call_c char (1)
Supervisor (Y/N) supervisor_c char (1)
WS default queue number ws_def_queue_s char (4)
WS sort order - behavioral scoring number ws_bhv_scr_l integer

rcp Indexes:

Index name Piece 1
rcp_idx0 opr_s


HomeTableIndexes