Freshmark replication server

freshmark-canonical

Program drill-down

SUPPL_TOVER_BY_SECT

SUPPLIER TURNOVER BY SECTION. Type DSP, base table STK_DETS.

Field inventory

46

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 21, 25
  
1 0.0 Label 2 T -1 621, 25
  
1 0.0 Label 3 T -1 671, 25
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 Label 5 T -1 671, 49
  
1 0.0 Label 6 T -1 291, 25
  
1 0.0 Label 7 T -1 261, 49
  
1 0.0 Label 8 T -1 211, 145
  
1 0.0 Label 9 T -1 211, 181
  
1 0.0 Label 10 T -1 211, 217
  
1 0.0 Label 11 T -1 211, 253
  
1 0.0 Label 12 T -1 211, 289
  
1 0.0 Label 13 T -1 211, 325
  
1 0.0 Work 14 I -1 321, 145
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE    'M:  C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT      $AFTER_READ  A:ORGS;I\AGENT  I:I\AGENT;<>;  F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'
1 0.0 Work 15 I -1 321, 181
$DEFAULT  'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$'    $SELECT  'S:SUPPLIER_CODE3;I\SUPPL_NO  S:SUPPLIER_CODE2;I\SUPPL_NO;I\MARKET;I\AGENT    $VALIDATE  'M:    I:I\SUPPL_NO;<>;    DO(SUPPL)     'ZEROFILL
1 0.0 Work 16 I -1 321, 217
$SELECT  S:PRODUCT;I\PRODUCT      $VALIDATE  I:I\PRODUCT;<>;  DO(CIA)     F:VAR_MAST;Y;;;VA_PRODUCT='$I\PRODUCT$';I\PRODUCT  DOEND(CIA)        
1 0.0 Work 17 I -1 321, 253
$VALIDATE    I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE
1 0.0 Work 18 I -1 321, 289
$VALIDATE  A:CONST;;I\ALLOW    I:I\TO_DATE;=;  A:CONST;$T\DATE$;I\TO_DATE    A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE        I:I\SUPPL_NO;=;  DO(NOS)    I:I\CM_ALLOW_MNTH_REPORT;<>;1    DO(CHK)      U:FIX_LOC_TRANS;REPORTS_TIME_CHECK;I\FROM_
1 0.0 Work 19 I -1 321, 325
$VALIDATE    'UPPERCASE  C:UCASE    V:N;Y    O:BACKCOLOR;C\CREATE;YELLOW  O:SETFOCUS;C\CREATE
1 0.0 Work 20 I 0 31, 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    'GETS BULK EMAIL PARAMETER  'A:PARM;1;I\BULK_EMAIL    A:VAR;I\MARKET;I\TM_MARKET    A
1 0.0 Work 21 I 0 61, 61
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  '''A:TIMER_ON;1000    A:CONST;$T\DATE$;I\FROM_DATE,I\TO_DATE  '$DEFAULT  A:ORGS;I\ORGS,I\AGENT  A:VAR;I\AGENT;I\ORGS  I:I\OGRS;<>;  DO(ORGS)  F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\ORGS$'  O:DISABLEINPUT;I\AGENT  DOEND(ORGS)    I
1 0.0 Work 22 I 0 111, 61
  
1 0.0 Label 23 T -1 461, 145
  
1 0.0 CMD 24 C -1 421, 145
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 25 C -1 421, 181
  
1 0.0 Label 26 T -1 461, 181
  
1 0.0 Work 27 I 0 111, 85
$DEFAULT  A:ORGS;I\ORGS,I\AGENT    A:VAR;I\ORGS;I\AGENT    F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'    I:I\ORGS;<>;   DO(AGENT)    O:DISABLEINPUT;I\AGENT,C\AGENT    O:SETFOCUS;I\SUPPL_NO   DOEND(AGENT)    I:I\ORGS;=;   DO(NO_AGENT)    O:ENABLEINPUT;I\AGENT,C\AGENT    O:SETFOCUS;I\AGENT   DOEND(NO_AGEN
1 0.0 CMD 28 C -1 421, 217
$SELECT  S:PRODUCT;I\PRODUCT
1 0.0 Label 29 T -1 461, 217
  
1 0.0 CMD 30 C -1 651, 553
$SCMD_FOCUS   O:BACKCOLOR;C\CREATE;YELLOW      $SELECT  A:CONST;;I\ALLOW      I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT      I:I\TO_DATE;=;  A:CONST;$T\DATE$;I\TO_DATE    I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE      A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE  I:I\DATEDIFF;<;0  
1 0.0 Label 31 T -1 301, 421
  
1 0.0 Work 32 I 0 41, 517
  
1 0.0 Work 33 I 0 81, 517
  
1 0.0 Work 34 I 0 121, 517
  
1 0.0 Work 35 I 0 161, 517
  
1 0.0 Work 36 I 0 201, 517
  
1 0.0 Work 37 I 0 241, 517
  
1 0.0 Work 38 I 0 281, 517
  
1 0.0 Work 39 I 0 321, 517
  
1 0.0 Work 1 I 0 361, 517
  
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