Freshmark replication server

freshmark-canonical

Program drill-down

WAYBILL_DELIV

WAYBILL DELIVERY ENQUIRY. Type DSP, base table PROFORMA_SUPPL_AGENT.

Field inventory

23

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 16 G -1 261, 229
  
1 0.0 H -1 0, 0
  
1 0.0 I -1 341, 169
$SELECT  ''S:CONS;I\SD_CONSIGN;I\MARKET;I\ORGS    $VALIDATE  M:  'ZEROFILL  ''A:ZEROFILL;I\SD_CONSIGN,W\ZEROFILL;I\SD_CONSIGN        ''A:VAR;I\DEL_DATE;I\DEL_DATE;;YYYY/MM/DD    'F:STK_MAST;Y;;I\DEL_DATE=SM_DDATE,I\SUPPLIER=SM_SUPP,I\AGENT=SM_AGENT,I\SMAN=SM_SMAN,I\DELNO=SM_DELNO;SM_MARKET='$I\MARKET$' AND SM_WAYBILLNO
1 0.0 I -1 261, 229
  
1 0.0 I -1 381, 229
  
1 0.0 Work 18 I 0 1, 73
$DEFAULT  'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  ''A:DATE;DD MMM YYYY;I\PSA_EXP_DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    'INITIALISES THE GRID, AND FILLS IT WITH DATA  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\DELNO,I\DELDATE    
1 0.0 Work 19 I 0 1, 97
$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 Work 21 I 0 1, 133
$DEFAULT  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\DELNO,I\DELDATE  A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGENT    I:I\ORGS;<>;  DO(03)  'O:DISABLEINPUT;I\AGENT  'F:AGENT_MAST;;;T\NAME=AM_NAME,W\AGN_LIM_TOT=AM_PRO_LIMIT;AM_CODE='$I\ORGS$'  'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;I\PSA_AGN,I\PSA_AMT  DOEND(03)  
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 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 7 T -1 281, 49
  
1 0.0 Label 8 T -1 261, 169
  
1 0.0 Label 11 T -1 261, 205
  
1 0.0 Label 12 T -1 381, 205
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0