LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rmp Table: Maturing Lease User Profile

Description Column Datatype
Operator initials opr_s char (3)
Oracle row stamp stamp_l number (10)
Maturing lease options (Y/N) s_mat_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 maturity low ws_mat_def_dayl_s char (5)
WS default days maturity high ws_mat_def_dayh_s char (5)
WS sort order - days to maturity ws_mat_days_l number (10)
WS sort order - short name ws_shrt_name_l number (10)
WS sort order - lease number ws_lse_num_l number (10)
WS sort order - residual amount ws_res_amt_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)
WS sort order - dealer name ws_dlr_name_l number (10)

rmp Indexes:

Index name Piece 1
rmp_idx0 opr_s


HomeTableIndexes