Freshmark replication server

freshmark-canonical

Program drill-down

SUPPLIER_LISTING_EL

SUPPLIER LISTING BY PROVINCE BY CATEGORY. Type DSP, base table SUPPLIER_MAST.

Field inventory

31

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 8 T -1 1, 25
  
1 0.0 Label 9 T -1 291, 25
  
1 0.0 Label 10 T -1 221, 49
  
1 0.0 Label 11 T -1 671, 25
  
1 0.0 Label 12 T -1 621, 25
  
1 0.0 Label 13 T -1 671, 49
  
1 0.0 Label 14 T -1 621, 49
  
1 0.0 Label 15 T -1 221, 169
  
1 0.0 Label 16 T -1 221, 277
  
1 0.0 Label 17 T -1 221, 313
  
1 0.0 Work 18 I -1 341, 169
$SELECT    S:SUPPLIER_CODE2;I\SUPPL      $VALIDATE    C:UCASE    I:I\SUPPL;<>;    DO(SUPPL)      'ZEROFILL       A:ZEROFILL;I\SUPPL,6;I\SUPPL         F:SUPPLIER_MAST;Y;;T\SUPPL_NAME=SUM_NAME;SUM_SUPPL='$I\SUPPL$';I\SUPPL    DOEND(SUPPL)
1 0.0 Work 19 I -1 341, 277
  
1 0.0 Work 20 I -1 341, 313
  
1 0.0 Label 21 T -1 221, 205
  
1 0.0 Work 22 I -1 341, 205
$SELECT    'DISPLAY A SELECTION WINDOW  S:PROV_GROUP;I\PROV      $VALIDATE    'CONVERT TO UPPERCASE  C:UCASE    I:I\PROV;<>;  F:PROV_MAST;Y;;;PR_GROUPING='$I\PROV$';I\PROV  
1 0.0 CMD 23 C -1 441, 169
  
1 0.0 Label 24 T -1 221, 241
  
1 0.0 Work 25 I -1 341, 241
$VALIDATE      C:UCASE    I:I\CATEGORY;<>;  F:SUPPLIER_MAST;Y;;I\CATEGORY=SUM_CATEGORY;SUM_SUPPL='$I\SUPPL$';I\CATEGORY
1 0.0 CMD 26 C -1 441, 205
$SELECT    'DISPLAY A SELECTION WINDOW  S:PROV_GROUP;I\PROV
1 0.0 CMD 28 C -1 441, 241
  
1 0.0 CMD 29 C -1 281, 361
  
1 0.0 Label 30 T -1 251, 397
  
1 0.0 Work 31 I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  'A:ORGS;;I\ORGS    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME  C:MCASE;;T\MARKET      A:CONST;$T\DATE$;I\FROM_DATE,I\TO_DATE
1 0.0 Work 32 I 0 31, 61
$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 481, 169
  
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