Freshmark replication server

freshmark-canonical

Program drill-down

PSA_TOP_PRODUCER

TOP SUPPLIERS LISTING BY TURNOVER. Type DSP, base table STK_MAST.

Field inventory

45

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C 0 101, 109
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 4 C 0 101, 133
$SELECT  S:DELIVERY_NO2;I\DELNO;I\MARKET;I\AGENT  
1 0.0 CMD 5 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW        $SELECT    A:CONST;COLLECTING DATA....................;T\PROG    I:K\PSA;=;0  U:PRINT_TOP_PSASUPPL_TURNOVER;ALL_PRODUCTS    I:K\PSA;=;1  U:PRINT_TOP_PSASUPPL_TURNOVER;PSA    A:CONST;DONE !!!!!!!!!!!!!!!!!;T\PROG    A:CONST;;I\FDATE1,I\TDATE1,I\FDATE2,I\TDATE2,I\FDATE3,I\T
1 0.0 Label 1 T -1 271, 133
  
1 0.0 Work 2 I -1 391, 133
$VALIDATE  A:CONST;;T\DESC  I:I\PROD;<>;  DO(PROD)    A:LEN;I\PROD;I\TMPLEN    I:I\TMPLEN;<>;2    D:PRODUCT CODE MUST BE TWO CHARACTERS;ERRORM;I\PROD      F:PRODUCT_MAST;Y;;T\DESC=PR_DESC;PR_PRODUCT='$I\PROD$'  DOEND(PROD)  
1 0.0 CMD 3 C 0 101, 157
$SELECT  'S:SUPPLIER_CODE3;I\SUPPL_NO  S:SUPPLIER_CODE2;I\SUPPL_NO;I\MARKET;I\AGENT
1 0.0 H -1 0, 0
  
1 0.0 MARKET I 0 111, 37
$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    'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE
1 0.0 DEFAULT I 0 141, 37
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    
1 0.0 Label 1 T -1 441, 133
  
1 0.0 AGENT I 0 51, 109
  
1 0.0 Work 2 I -1 391, 169
$VALIDATE  A:CONST;;T\PROG  M:
1 0.0 Work 2 I -1 391, 313
$VALIDATE    I:I\FDATE3;<>;  DO(0)    I:I\FDATE2;=;    DO(01)      A:CONST;;I\FDATE3      D:THE START DATE FOR PERIOD2 CAN NOT BE BLANK;ERRORM;I\FDATE2    DOEND(01)  DOEND(0)  
1 0.0 Work 2 I 0 581, 121
  
1 0.0 SUPPL_NO I 0 1, 157
    
1 0.0 Work 7 I -1 391, 241
$VALIDATE    
1 0.0 Work 8 I -1 391, 265
$VALIDATE  
1 0.0 Work 1 I -1 391, 193
$VALIDATE  I\FDATE1,I\TDATE1
1 0.0 Work 2 I -1 391, 337
$VALIDATE  O:SETFOCUS;C\CREATE
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 11 T -1 671, 49
  
1 0.0 Label 10 T 0 21, 157
  
1 0.0 Label 9 T 0 11, 157
  
1 0.0 Label 1 T -1 271, 169
  
1 0.0 Label 1 T -1 271, 313
  
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 4 T -1 291, 49
  
1 0.0 Label 1 T 0 1, 133
  
1 0.0 Label 1 T 0 1, 181
  
1 0.0 Label 5 T -1 271, 241
  
1 0.0 Label 6 T -1 271, 265
  
1 0.0 Label 2 T -1 271, 193
  
1 0.0 Label 3 T -1 321, 385
  
1 0.0 Label 1 T -1 271, 337
  
1 0.0 Work 2 I 0 400, 415
  
1 0.0 Check 3 K -1 391, 97
$VALIDATE  I:K\PSA;=;1  DO(1)    A:CONST;PO;I\PROD    O:DISABLEINPUT;I\PROD  DOEND(1)    I:K\PSA;=;0  DO(2)    A:CONST;;I\PROD    O:ENABLEINPUT;I\PROD  DOEND(2)
1 0.0 Label 4 T -1 271, 97
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0