Freshmark replication server

freshmark-canonical

Program drill-down

MONTHLY_SAAGA_DUMP

MONTHLY SAAGA LEVY DUMP. Type DSP, base table TROLLEY_MAST.

Field inventory

32

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 5 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT  A:CONST;PROCESSING !!!;T\PROG  U:SUPPL_APMLCLEVY_DUMP;DUMP  A:CONST;DONE !!!;T\PROG  O:SETFOCUS;I\SUPPLIER_CODE  A:CONST;;I\AGENT,D\SELECT,T\DESC,I\FROM_DATE,I\TO_DATE,I\EXIST,I\EXIST_LEVY,I\SUPPLIER_CODE,T\SUPPLNAME
1 0.0 Label 1 T -1 311, 253
  
1 0.0 CMD 8 C -1 411, 109
$SELECT  S:SUPPLIER_CODE3;I\SUPPLIER_CODE
1 0.0 Drop 7 D -1 311, 145
$DEFAULT  'ADDS THE SPECIFIED ITEMS TO THE COMBOBOX  B:ADDITEM;D\SELECT;AV = AVOCADO,PL = PINEAPPLE,ML = MANGO,LL = LICHIE,CL = CACTUS    $VALIDATE  A:CONST;;T\DESC  C:UCASE  M:    'CHECKS THAT ONLY THE ADDED ITEMS ARE ENTERED  I:D\SELECT;=;AV = AVOCADO    DO(AV)     'TAKE THE LEFT MOST CHARACTER     A:LEFT;D\SELECT,2;
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 441, 469
  
1 0.0 Work 1 I 0 401, 469
  
1 0.0 TO_DATE I -1 311, 217
$VALIDATE    I:I\TO_DATE;=;  A:CONST;$T\DATE$;I\TO_DATE    A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE      O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW    
1 0.0 FROM_DATE I -1 311, 181
$VALIDATE    I:I\FROM_DATE;<>;   DO(FDTE)    O:SETFOCUS;I\TO_DATE   DOEND(FDTE)    I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE
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 Work 1 I 0 261, 481
  
1 0.0 Work 2 I 0 201, 481
  
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 SUPPLIER_CODE I -1 311, 109
$DEFAULT  'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE      $SELECT  S:SUPPLIER_CODE3;I\SUPPLIER_CODE      $VALIDATE  A:CONST;;I\EXIST_LEVY,I\EXIST  'M:    C:UCASE    I:I\SUPPLIER_CODE;<>;  F:SUPPLIER_MAST;Y;;T\SUPPLNAME=SUM_NAME;SUM_SUPPL='$I\SUPPLIER_CODE$' AND SUM
1 0.0 Label 9 T -1 191, 109
  
1 0.0 Label 1 T -1 411, 145
  
1 0.0 Label 4 T -1 191, 217
  
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 4 T -1 271, 49
  
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 11 T -1 671, 49
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 2 T -1 191, 181
  
1 0.0 Label 1 T -1 191, 145
  
1 0.0 Label 10 T -1 441, 109
  
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
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0