LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

mws Table: Customer Service Work Schedule

Description Column Datatype
Lease lse_s char (10)
Operator initials opr_s char (3)
Date entered tracking d_enter_trk_s date
Follow-up date and time dt_fol_s timestamp (3)
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
prio_c char (1)
Title of the note note_title_s varchar2 (41)
Oracle row stamp stamp_l number (10)
Note type
  For unprocessed notes, note type must start with:
  A - Application
  M - Maturing Lease
  C - Collection
  K - Collateral
  S - Customer Service
note_type_s char (4)

mws Indexes:

Index name Piece 1 Piece 2 Piece 3
mws_idx0 opr_s lse_s note_type_s
mws_idx1 lse_s note_type_s


HomeTableIndexes