Freshmark replication server

freshmark-canonical

Program drill-down

FARMERS_DELIV

SUPPLIER DETAILED LIST. Type DSP, base table STK_DETS.

Field inventory

43

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 9 I 0 11, 385
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT  
1 0.0 H -1 0, 0
  
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 301, 49
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 5 T -1 671, 49
  
1 0.0 Label 6 T -1 621, 25
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 8 T -1 181, 157
  
1 0.0 Label 9 T -1 181, 193
  
1 0.0 Label 10 T -1 181, 229
  
1 0.0 Label 11 T -1 181, 265
  
1 0.0 Label 12 T -1 181, 301
  
1 0.0 Label 13 T -1 181, 337
  
1 0.0 Label 15 T -1 181, 409
  
1 0.0 Label 14 T -1 181, 373
  
1 0.0 Work 18 I -1 301, 193
$VALIDATE  I:I\ENDDATE;=;  DO(01)    I:I\STDATE;<>;    A:DATE;DD MMM YYYY;I\ENDDATE  'O:DISABLEINPUT;I\ENDDATE  DOEND(01)
1 0.0 Work 17 I -1 301, 157
$VALIDATE  I:I\STDATE;=;  DO(01)  A:CONST;;I\ENDDATE  O:DISABLEINPUT;I\ENDDATE  DOEND(01)    I:I\STDATE;<>;  DO(01)    A:DATE;DD MMM YYYY;I\ENDDATE  O:ENABLEINPUT;I\ENDDATE  DOEND(01)
1 0.0 Work 19 I -1 301, 229
$SELECT    S:AGN_CODE;I\AGN    $VALIDATE    I:I\AGN;<>;    F:AGENT_MAST;Y;;W\ACC_TYPE=AM_TYPE,T\NAME=AM_NAME;AM_CODE='$I\AGN$';I\AGN   
1 0.0 Work 20 I -1 301, 265
$SELECT  S:COMM_LIST;I\PRODUCT    $VALIDATE    C:UCASE  I:I\PRODUCT;<>;  DO(1)    F:PRODUCT_MAST;Y;PR_PRODUCT;T\PROD=PR_DESC;;I\PRODUCT  O:ENABLEINPUT;I\VAR_CODE  DOEND(1)    I:I\PRODUCT;<>;  DO(01)   O:DISABLEINPUT;I\ITEM_SECT,C\ITEM_SECT  DOEND(01)
1 0.0 Work 21 I -1 301, 301
$SELECT    'S:VAR_CODE;I\VARIETY_CODE;I\PRODUCT_CODE  S:VARIETY_NB2;I\VAR_CODE;I\PRODUCT      $VALIDATE  A:CONST;;W\VARIETY   I:I\VAR_CODE;<>;  DO(1)  I:I\PRODUCT;=;    DO(2)     A:CONST;;I\VAR_CODE     D:ERROR-PLEASE SELECT A PRODUCT;ERRORM;I\PRODUCT        DOEND(2)  C:UCASE  F:VAR_MAST;Y;VA_VARIETY;W\VARIETY=VA_VARIE
1 0.0 Work 22 I -1 301, 337
$SELECT  S:ITEM_SECTION;I\ITEM_SECT
1 0.0 Work 23 I -1 301, 373
$SELECT  S:SALES_SECTION;I\SALES_SECT
1 0.0 Work 24 I -1 301, 409
$SELECT  S:AREA_CODE;I\AREA_CODE  $VALIDATE  O:SETFOCUS;C\RUN
1 0.0 CMD 1 C -1 401, 229
$SELECT    S:AGN_CODE;I\AGN  
1 0.0 CMD 2 C -1 401, 265
$SELECT  S:COMM_LIST;I\PRODUCT    $VALIDATE  M:I\PRODUCT='PRODUCT CODE'  C:UCASE  I:I\PRODUCT;<>;  DO(1)    F:PRODUCT_MAST;Y;PR_PRODUCT;T\PROD_DESC=PR_DESC;;I\PRODUCT_CODE  O:ENABLEINPUT;I\VAR_CODE  DOEND(1)
1 0.0 CMD 3 C -1 401, 301
$SELECT    'S:VAR_CODE;I\VARIETY_CODE;I\PRODUCT_CODE  S:VARIETY_NB2;I\VAR_CODE;I\PRODUCT  
1 0.0 CMD 4 C -1 401, 337
  
1 0.0 CMD 5 C -1 401, 373
  
1 0.0 CMD 6 C -1 401, 409
$SELECT  S:AREA_CODE;I\AREA_CODE
1 0.0 Label 1 T -1 301, 481
  
1 0.0 Work 8 I 0 11, 361
$DEFAULT    A:DATE;DD MMM YYYY;I\STDATE  A:DATE;DD MMM YYYY;I\ENDDATE      A:TIME,HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  A:TIMER_ON;1000  O:SETFOCUS;I\STDATE  'O:DISABLEINPUT;I\VAR_CODE
1 0.0 Work 7 I 0 11, 337
  
1 0.0 Work 10 I 0 11, 409
  
1 0.0 CMD 1 C -1 301, 457
$SELECT  A:CONST;IN PROGRESS . . .;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_SUPPL_DETAIL_LISTING;$I\MARKET$,$I\STDATE$,$I\ENDDATE$,$I\AGN$,$I\PRODUCT$,$I\VAR_CODE$,$I\ITEM_SECT$,$I\SALES_SECT$,$I\AREA_CODE$,S  A:CONST;COMPLETE ! ! ! !;T\PROG  I:I\ORGS;<>;  DO(AGN)  A:CONST;;I\PRODUCT,I\VAR_CODE,
1 0.0 Work 1 I 0 11, 433
$DEFAULT  A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGN    I:I\ORGS;<>;  DO(03)  O:DISABLEINPUT;I\AGN,C\AGENT  F:AGENT_MAST;;;T\NAME=AM_NAME;AM_CODE='$I\ORGS$'  DOEND(03)  
1 0.0 Label 1 T -1 441, 229
  
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