Freshmark replication server

freshmark-canonical

Program drill-down

MARKET_SALES_SUMMARY

MARKET SALES SUMMARY. Type DSP, base table STK_TRANS.

Field inventory

25

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Check 6 K 0 371, 253
  
1 0.0 H -1 0, 0
  
1 0.0 MARKET T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 DATE T -1 671, 49
  
1 0.0 TIME T -1 671, 25
  
1 0.0 STK_TRANS ST_MARKET I 0 21, 49
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    I:I\DATE;=;  A:VAR;T\DATE;I\DATE    'LOAD MARKET CODE  A:ORG;;I\ST_MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    A:ORGS;;I\ORGS  A:VAR;I\ORGS;I\AGENT    I:I\AGENT;<>;  DO(AGN)    F:AGENT_MAST;;;T\AM_NAME=AM_NAME
1 0.0 CMD 4 C -1 411, 145
  
1 0.0 Work 2 I -1 371, 217
$VALIDATE  U:MARKET_SALES_SUMMARY;GET_DATA    I:I\ORGS;<>;  DO(0)    A:DATE;DD MMM YYYY;I\DATEF    A:DATE;DD MMM YYYY;I\DATET    O:SETFOCUS;I\DATEF  DOEND(0)    I:I\ORGS;=;  DO(1)    A:CONST;;I\AGENT,T\AM_NAME    A:DATE;DD MMM YYYY;I\DATEF    A:DATE;DD MMM YYYY;I\DATET    O:SETFOCUS;I\AGENT  DOEND(1)
1 0.0 START DATE I -1 371, 181
$VALIDATE  M:    $CALCULATE  A:VAR;I\DATEF;I\DATET  
1 0.0 Work 1 I 0 61, 49
  
1 0.0 Label 1 T -1 211, 217
  
1 0.0 Label 12 T -1 211, 181
  
1 0.0 Work 1 I 0 41, 49
  
1 0.0 Work 2 I -1 371, 145
$VALIDATE    I:I\AGENT;<>;  F:AGENT_MAST;;;T\AM_NAME=AM_NAME;AM_MARKET='$I\ST_MARKET$' AND AM_CODE='$I\AGENT$';I\AGENT
1 0.0 Label 5 T -1 451, 145
  
1 0.0 Label 3 T -1 211, 145
  
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