LeasePak 5.1a Database Reference (Sybase)

HomeTableIndexes

rmp Table: Maturing Lease User Profile

Description Column Datatype
Operator initials opr_s char (3)
Sybase timestamp timestamp timestamp
Maturing lease options (Y/N) s_mat_mod_c char (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 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 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 integer
WS sort order - short name ws_shrt_name_l integer
WS sort order - lease number ws_lse_num_l integer
WS sort order - residual amount ws_res_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
WS sort order - dealer name ws_dlr_name_l integer

rmp Indexes:

Index name Piece 1
rmp_idx0 opr_s


HomeTableIndexes

(c) Copyright 2004 McCue Systems, Inc.