mwr Table: Recovery Work Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

mwr Table: Recovery Work Schedule

Indexes

Name Segment 1 Segment 2
mwr_idx0 queue_s lse_s
mwr_idx1 lse_s  

     
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
char(10) no
queue_s
Queue number
char(4) no
prio_c
Priority flag (1/2/3/4)
  1 - Lowest priority
  4 - Highest priority
char(1) yes
locked_c
Record locked (Y/N)
char(1) yes
ws_excl_c
Exclude from Work Schedule (Y/N)
char(1) yes
col_stat_s
Collection status
char(4) yes
team_asgn_s
Team from which the clerk was chosen
  Must be entered if how_asgn_c = (P, C, R, O, K, or L)
char(4) yes
ref_amt_d
Reference amount
double precision yes
d_enter_trk_s
Date entered tracking
datetime yes
dt_fol_s
Follow-up date and time
datetime yes
note_title_s
Title of the note
char(41) yes
timestamp
Record modification stamp
timestamp yes
weight_l
Weight
integer yes
opr_s
Operator initials
char(3) yes