mws Table: Customer Service Work Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mws Table: Customer Service Work Schedule

Indexes

Name Segment 1 Segment 2 Segment 3
mws_idx0 opr_s lse_s note_type_s
mws_idx1 lse_s note_type_s  

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
char(10) no
opr_s
Operator initials
char(3) no
d_enter_trk_s
Date entered tracking
datetime yes
dt_fol_s
Follow-up date and time
datetime yes
prio_c
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
char(1) yes
note_title_s
Title of the note
char(41) yes
timestamp
Record modification stamp
timestamp yes
note_type_s
Note type
  For unprocessed notes, note type must start with:
  A - Application
  M - Maturing Lease
  C - Collection
  K - Collateral
  S - Customer Service
char(4) no