Freshmark replication server

freshmark-canonical

Program drill-down

DAILY_SALESMAN_NEW

DAILY SALESMAN REPORT. Type DSP, base table STK_TRANS.

Field inventory

29

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 11 C -1 471, 181
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 12 C -1 301, 337
$SELECT  A:CONST;;I\ALLOW  A:CONST;Y;I\COMMIND    A:DATEDIFF;I\TDATE;I\DATEDIFF;I\FDATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TDATE      I:I\CM_ALLOW_MNTH_REPORT;<>;1  DO(CHK)   U:FIX_LOC_TRANS;REPORTS_TIME_CHECK;I\FDATE,I\TDATE   I:I\ALLOW;=;N   DO(01)    O:SETFOCUS;I\FDATE   DOEND(01)  D
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 91, 385
  
1 0.0 Work 2 I 0 111, 385
  
1 0.0 COMMIND I 0 611, 529
  
1 0.0 AGENT I -1 361, 181
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  C:UCASE    I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    I:I\AGENT;=;  A:CONST;ALL;T\NAME
1 0.0 FDATE I -1 361, 229
$CALCULATE  M:    
1 0.0 TDATE I -1 361, 277
$CALCULATE  A:CONST;;I\ALLOW  M:        A:DATEDIFF;I\TDATE;I\DATEDIFF;I\FDATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TDATE      I:I\CM_ALLOW_MNTH_REPORT;<>;1  DO(CHK)   U:FIX_LOC_TRANS;REPORTS_TIME_CHECK;I\FDATE,I\TDATE   I:I\ALLOW;=;N   DO(01)    O:SETFOCUS;I\FDATE   DOEND(01)  DOEND(CHK) 
1 0.0 Work 3 I 0 131, 385
  
1 0.0 MARKET I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:CONST;Y;I\COMMIND    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS
1 0.0 Work 1 I 0 21, 61
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 Label 5 T -1 291, 49
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 8 T -1 241, 181
  
1 0.0 Label 9 T -1 241, 229
  
1 0.0 Label 10 T -1 241, 277
  
1 0.0 Label 17 T -1 511, 181
  
1 0.0 Label 18 T -1 311, 385
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0