Freshmark replication server

freshmark-canonical

Program drill-down

CHECK_MISS_DELNO

CHECK MISSING DELIVERY NUMBERS. Type DSP, base table STK_MAST.

Field inventory

24

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 5 T -1 1, 25
  
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        A:VAR;I\MARKET;I\TM_MARKET      $AFTER_READ  A:VAR;I\MARKET;I\TM_MARKET
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 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 Work 1 I -1 341, 217
$SELECT  S:DELIVERY_NO4;I\TO_DELNO;I\MARKET      $VALIDATE  'M:    'ZEROFILL  'A:SUB;"2";I\DEL_LEN;I\DEL_LEN  A:ZEROFILL;I\TO_DELNO,I\DEL_LEN;I\TO_DELNO    I:I\FROM_DELNO;<>;  M:      I:I\TO_DELNO;<>;  F:STK_MAST;Y;;;SM_DELNO='$I\TO_DELNO$' AND SM_MARKET='$I\MARKET$';I\TO_DELNO    I:I\FROM_DELNO;=;  A:CONST;;I\TO_DELNO
1 0.0 Label 2 T -1 221, 217
  
1 0.0 CMD 5 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_CHECK_DELIVERY;$I\MARKET$,$I\FROM_DELNO$,$I\TO_DELNO$,S  A:CONST;;I\FROM_DELNO,I\TO_DELNO              
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 4 T -1 241, 49
  
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 351, 397
  
1 0.0 DELNO I -1 341, 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:DELIVERY_NO4;I\FROM_DELNO;I\MARKET      $VALIDATE  'M:    'ZEROFILL  'A:SUB;"2";I\DEL_LEN;I\DEL_LEN  A:ZEROFILL;I\FROM_DELNO,I\DEL_LEN;I\
1 0.0 Label 1 T -1 221, 181
  
1 0.0 CMD 3 C -1 441, 181
$SELECT  S:DELIVERY_NO4;I\FROM_DELNO;I\MARKET
1 0.0 Work 1 I 0 401, 397
  
1 0.0 CMD 3 C -1 441, 217
$SELECT  S:DELIVERY_NO4;I\TO_DELNO;I\MARKET
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