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

Database Reference

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
opr_s
Operator initials
d_enter_trk_s
Date entered tracking
dt_fol_s
Follow-up date and time
prio_c
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
note_title_s
Title of the note
Record modification stamp
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