Freshmark replication server

freshmark-canonical

Program drill-down

AGENTS_TURNOVER

AGENTS TURNOVER. Type DSP, base table ADDR_TYPE.

Field inventory

24

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 30
  
1 0.0 MARKET I 0 141, 37
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT    'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL  C:MCASE;;T\MARKET    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  ''A:TIMER_ON;1000    A:CONST;N;I\DUMP 
1 0.0 START_DATE I -1 351, 211
$DEFAULT  A:DATE;DD MMM YYYY;I\D_DATE;    $AFTER_READ  A:DATE;DD MMM YYYY;I\D_DATE;    $CALCULATE  A:CONST;;I\ALLOW  A:VAR;I\C_DATE;I\C_DATE;;DD MMM YYYY  'A:VAR;I\D_DATE;I\D_DATE;;YYYY/MM/DD      A:DATEDIFF;I\D_DATE;I\DATEDIFF;I\C_DATE  I:I\DATEDIFF;<;0  D:END DATE CANNOT BE LESS THAN START DATE;ERRORM;I\D_DATE    I:I
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 5 T -1 621, 25
  
1 0.0 Work 2 I -1 351, 175
$DEFAULT  A:DATE;DD MMM YYYY;I\C_DATE;    $AFTER_READ  A:DATE;DD MMM YYYY;I\C_DATE;    $CALCULATE  A:VAR;I\C_DATE;I\C_DATE;;DD MMM YYYY    'A:VAR;I\C_DATE;I\C_DATE;;YYYY/MM/DD  
1 0.0 Work 1 I -1 351, 139
$VALIDATE  I:I\DUMP;<>;  DO(FFS)    C:UCASE    V:Y;N  DOEND(FFS)    I:I\DUMP;=;  A:CONST;N;I\DUMP
1 0.0 Work 1 I 0 211, 295
  
1 0.0 Work 1 I 0 241, 295
  
1 0.0 Work 2 I 0 271, 295
  
1 0.0 T -1 191, 211
  
1 0.0 Label 1 T -1 191, 175
  
1 0.0 Label 9 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 8 T -1 671, 49
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 3 T -1 311, 49
  
1 0.0 Label 2 T -1 191, 139
  
1 0.0 Label 3 T -1 321, 259
  
10 0.0 ZX_DELETE Z 0 0, 30
  
10 0.0 ZX_UPDATE Z 0 0, 30
  
10 0.0 ZX_PRINT Z 0 0, 30
  
10 0.0 ZX_SELECT Z 0 0, 30
  
10 0.0 ZX_EXIT Z 0 0, 30