LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rkp Table: Collateral User Profile

Description Column Datatype
Operator initials opr_s char (3)
Oracle row stamp stamp_l number (10)
Collateral options (Y/N) s_kol_mod_c varchar2 (30)
Display newer follow-up dates before old dates (Y/N) s_new_note_first_c char (1)
Access all collateral user accounts (Y/N) all_c char (1)
Alpha assign by short name (X/' ')
  X - Allow access
alpha_c varchar2 (26)
Default signature name sign_s varchar2 (36)
Default signature title title_s varchar2 (25)
Letter code
  This array contains only those letters
  to which the user has access.
let_cd_s varchar2 (80)
User option code
  This array contains only those user options
  to which the user has access.
usr_opt_s varchar2 (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 acquisition low - collateral ws_kol_def_dayl_s char (4)
WS default days acquisition high - collateral ws_kol_def_dayh_s char (4)
WS sort order - days acquisition - collateral ws_kol_days_l number (10)
WS sort order - short name ws_shrt_name_l number (10)
WS sort order - lease number ws_lse_nums_l number (10)
WS sort order - asset number ws_unit_num_l number (10)
WS sort order - user initials ws_opr_l number (10)
WS sort order - follow-up date ws_folw_l number (10)
WS sort order - note priority ws_prior_l number (10)
Alpha assign by tracking type alpha_type_c varchar2 (26)

rkp Indexes:

Index name Piece 1
rkp_idx0 opr_s


HomeTableIndexes