Freshmark replication server

freshmark-canonical

Program drill-down

MKT_SHARE_BY_ITEM

MARKET SHARE BY ITEM. Type DSP, base table STK_DETS.

Field inventory

40

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 15 C 0 31, 229
$SELECT  S:JHBGROUP2;
1 0.0 CMD 20 C -1 301, 409
$SELECT   I:I\SDATE;=;  D:PLEASE ENTER A STARTING DATE;ERRORM;I\SDATE    I:I\EDATE;=;  D:PLEASE ENTER AN ENDING DATE;ERRORM;I\EDATE    'I:I\MARKET;=;18  'DO(CR4)  ' U:DAILY_RUN_CHECK;CHECK  ' I:I\TMP_IND;=;Y  '  D:TEMPORARY! STATS MAY NOT BE RUN BEFORE DAILY;ERRORM;I\SDATE  'DOEND(CR4)    A:CONST;         COLLECTING DA
1 0.0 CMD 3 C -1 431, 217
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 H -1 0, 60
  
1 0.0 Work 2 I -1 331, 361
$VALIDATE  C:UCASE  V:N;Y;  I:I\DUMP;=;  DO(1)  A:CONST;N;I\DUMP  DOEND(1)    'I:I\MARKET;=;11  'DO(15)    O:SETFOCUS;C\RUN    O:BACKCOLOR;C\RUN;YELLOW  'DOEND(15)
1 0.0 Work 3 I 0 531, 397
  
1 0.0 IP I 0 61, 91
$DEFAULT  A:USERIP;;I\IP
1 0.0 AGENT Work 9 I 0 41, 91
'$DEFAULT  'A:ORGS;;I\ORGS    'O:ENABLEINPUT;I\AGENT    'I:I\ORGS;<>;  'DO(2)  '  A:VAR;I\ORGS;I\AGENT  '  O:DISABLEINPUT;I\AGENT  '  O:SETFOCUS;I\ORDER  'ENDDO(2)      'O:SETFOCUS;I\AGENT    
1 0.0 MARKET I 0 21, 91
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'I:I\MARKET;<>;11  'O:HIDE;I\DUMP,T\DUMP    A:CONST;N;I\DUMP  
1 0.0 Work 11 I 0 1, 91
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:DATE;DD MMM YYYY;I\SDATE  A:DATE;DD MMM YYYY;I\EDATE      A:ORGS;;I\ORGS    O:ENABLEINPUT;I\AGENT    I:I\ORGS;<>;  DO(2)    A:VAR;I\ORGS;I\AGENT    A:CONST;Y;I\AGN_TEST    O:DISABLEINPUT;I\AGENT,B\3    O:SETFOCUS;I\ORDER  ENDDO(2)    I:I\
1 0.0 USERID I 0 81, 91
$DEFAULT  A:USERID;;I\USERID
1 0.0 Work 17 I -1 331, 289
$CALCULATE  A:CONST;;T\PROG  I:I\SDATE;=;  A:CONST;$T\DATE$;I\SDATE    A:CONST;$I\SDATE$;I\EDATE
1 0.0 Work 18 I -1 331, 325
$CALCULATE  I:I\EDATE;=;  A:CONST;$T\DATE$;I\EDATE      'I:I\MARKET;<>;11  'DO(NOT_15)    'O:SETFOCUS;C\RUN   'O:BACKCOLOR;C\RUN;YELLOW  'OEND(NOT_15)
1 0.0 Work 19 I -1 331, 253
'$SELECT    $VALIDATE  C:UCASE  V:I;O;T  M:  
1 0.0 Work 4 I 0 400, 481
  
1 0.0 Work 2 I 0 241, 451
  
1 0.0 Work 1 I 0 351, 451
  
1 0.0 STK_DETS SD_AGENT I -1 331, 217
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE  'A:CONST;;T\PROG,T\NAME    C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    I:I\ORGS;=;  DO(1)    A:VAR;I\AGENT;I\ORGS  ENDDO(1)    O:SETFOCUS;I\ORDER
1 0.0 Label 1 T -1 201, 361
  
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 261, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 50
  
1 0.0 Label 7 T -1 671, 50
  
1 0.0 Label 12 T -1 201, 289
  
1 0.0 Label 13 T -1 201, 325
  
1 0.0 Label 14 T -1 201, 253
  
1 0.0 Label 1 T -1 201, 505
  
1 0.0 Label 2 T -1 201, 217
  
1 0.0 Label 1 T -1 221, 109
  
1 0.0 Label 2 T -1 221, 181
  
1 0.0 Label 3 T -1 221, 145
  
1 0.0 Work 2 I 0 511, 493
  
10 0.0 ZX_PRINT Z 0 0, 60
  
10 0.0 ZX_SELECT Z 0 0, 60
  
10 0.0 ZX_DELETE Z 0 0, 60
  
10 0.0 ZX_UPDATE Z 0 0, 60
  
10 0.0 ZX_EXIT Z 0 0, 60