Freshmark replication server

freshmark-canonical

Program drill-down

SUPPL_TOT_TOVER_EL

SUPPLIER TOTAL TURNOVER. Type DSP, base table STK_TRANS.

Field inventory

40

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 Label 1 T -1 11, 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 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Work 8 I 0 11, 61
$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    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'IN
1 0.0 Work 9 I 0 41, 61
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:DATE;DD MMM YYYY;I\FROM_DATE  A:DATE;DD MMM YYYY;I\TO_DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000
1 0.0 Work 10 I -1 351, 145
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE    C:UCASE    I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 Work 11 I -1 351, 181
$SELECT  S:SECTION;I\SECT    $VALIDATE  C:UCASE    'I:I\SECT;=;  'A:CONST;;T\SNAME    I:I\SECT;<>;  F:SECT_MAST;Y;;T\SNAME=SE_DESC;SE_SECT='$I\SECT$';I\SECT
1 0.0 Work 12 I -1 351, 217
$SELECT  S:COMM_LIST;I\ITEM    $VALIDATE    I\ITEM='PRODUCT CODE'  C:UCASE    I:I\ITEM;<>;  DO(1)    A:CONST;;T\PROG    F:PRODUCT_MAST;;;W\PROD_DESC=PR_DESC;PR_PRODUCT='$I\ITEM$';I\ITEM  DOEND(1)
1 0.0 Label 13 T -1 231, 145
  
1 0.0 Label 14 T -1 231, 181
  
1 0.0 Label 15 T -1 231, 217
  
1 0.0 Label 16 T -1 231, 253
  
1 0.0 Label 17 T -1 231, 289
  
1 0.0 Label 18 T -1 231, 325
  
1 0.0 Work 19 I -1 351, 253
$VALIDATE    I:I\FROM_DATE;=;  A:DATE;DD MMM YYYY;I\FROM_DATE
1 0.0 Work 20 I -1 351, 289
$VALIDATE      I:I\TO_DATE;=;  A:DATE;DD MMM YYYY;I\TO_DATE
1 0.0 Work 21 I -1 351, 325
$VALIDATE      V:1;2;;    
1 0.0 Label 22 T -1 231, 361
  
1 0.0 Work 23 I -1 351, 361
$VALIDATE    'UPPERCASE  C:UCASE    V:N;Y    O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN
1 0.0 Label 24 T -1 291, 457
  
1 0.0 CMD 25 C -1 281, 421
$SELECT      A:CONST;PROCESSING ...;T\PROG  'PATH THEN FOLLOWED BY PRINTING NAME THEN FOLLOWED BY PARAMETERS THEN LASTLY THE OUTPUT TYPE IE: S OR P OR Y  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_SUPPL_TOT_TOVER_BY_ITEM_SECT_EL;$I\MARKET$,$I\AGENT$,$I\SECT$,$I\ITEM$,$I\FROM_DATE$,$I\TO_DATE$,$I\GROUP_BY$
1 0.0 CMD 29 C -1 451, 181
$SELECT  S:SECTION;I\SECT
1 0.0 Label 30 T -1 491, 181
  
1 0.0 Label 27 T -1 491, 145
  
1 0.0 CMD 26 C -1 451, 145
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Work 28 I 0 11, 97
  
1 0.0 Label 31 T 0 491, 217
  
1 0.0 CMD 32 C -1 451, 217
$SELECT  S:COMM_LIST;I\ITEM
1 0.0 Work 1 I 0 11, 121
  
1 0.0 Work 2 I 0 11, 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