Freshmark replication server

freshmark-canonical

Program drill-down

CS_AUDITS

COLD STORAGE AUDITS. Type DSP, base table TROLLEY_MAST.

Field inventory

43

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C -1 651, 541
$SCMD_FOCUS  O:BACKCOLOR;C\RUN;YELLOW    $SELECT    I:I\AGENT;<>;  A:CONST;$I\AGENT$;I\ORGS    I:I\MARKET;=;18  DO(01)  I:I\SELECT;<>;6  DO(6)  I:I\DUMP;<>;Y  'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_CS_AUDITS;$I\MARKET$,$I\FROM_DATE$,$I\TO_DATE$,$I\SELECT$,$I\ORGS$,$I\ROOM$,S  E:$GBLROOT$LEGEND\PROJ_F
1 0.0 H -1 1, 25
  
1 0.0 Work 11 I -1 331, 325
  
1 0.0 Work 1 I -1 331, 469
$SELECT    I:I\AGENT;<>;  S:SUPPLIER_MAST1;I\SUPPLIER;I\ORG    I:I\AGENT;=;  S:SUPPLIER_MAST;I\SUPPLIER      $VALIDATE    'ZERO FILL THIS FIELD TO SIX DIGITS IF IT IS NOT NULL  A:ZEROFILL;I\SUPPLIER,6;I\SUPPLIER      I:I\SUPPLIER;<>;  DO(1)    F:SUPPLIER_MAST;Y;;;SUM_SUPPL = '$I\SUPPLIER$';I\SUPPLIER  DOEND(1)    I:I\M
1 0.0 Work 1 I -1 481, 289
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  C:UCASE      I:I\AGENT;<>;  F:AGENT_MAST;Y;AM_CODE;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 Label 2 T -1 401, 289
  
1 0.0 Work 2 I -1 331, 433
$SELECT  'S:CONSIGNMENT22;I\CONSIGN;I\AGENT  S:CONS_NO;I\CONSIGN;I\MARKET;I\AGENT    $VALIDATE  I:I\CONSIGN;<>;  DO(1)    'F:LOC_TRANS;Y;;;LT_MARKET='$I\MARKET$' AND LT_CONSIGNO = '$I\CONSIGN$' AND LT_CONFIRMED = 'Y' AND LT_DELIND <> 'Y' AND LT_PRQTY_AVAIL > '0';I\CONSIGN    'CHANGED BY JD 20131126 - VERY WRONG LOOKUP 
1 0.0 MARKET I 0 31, 109
$DEFAULT  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\RUN    'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\DELNO_BY_AGENT=CM_DEL_BY_AGENT    'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL  C:MCASE;;T\MARKET    A:DATE;DD MMM YYYY;T\DATE  A:TIME;
1 0.0 ORGS I 0 91, 109
$DEFAULT  A:ORGS;;I\ORGS    'I:I\ORGS;<>;  'DO(PAS)  '  O:DISABLEINPUT;C\RUN,C\COMPLETE  '  D:AGENTS MAY NOT RUN THIS SCREEN;ERRORM;  'DOEND(PAS)    'I:I\ORGS;=;  'DO(PAS)  '  O:ENABLEINPUT;C\RUN,C\COMPLETE  'DOEND(PAS)
1 0.0 Work 1 I -1 331, 253
$VALIDATE    V:1;2;3;4;5;6    'I:I\SELECT;=;2  'DO(02)  'A:CONST;;I\END_ITEM  'O:HIDE;I\END_ITEM,T\END_ITEM  'DOEND(02)      'I:I\SELECT;<>;2  'O:SHOW;I\END_ITEM,T\END_ITEM    'I:I\SELECT;<>;3  'DO(03)  'A:CONST;;I\START_SUPPL,I\END_SUPPL  'O:HIDE;I\START_SUPPL,T\START_SUPPL,I\END_SUPPL,T\END_SUPPL  'DOEND(03)      'I:
1 0.0 ROOM I -1 331, 397
$VALIDATE  C:UCASE    'I:I\ROOM;<>;  V:M;A    'I:I\ROOM;<>;  'F:LOCATION_MAST;Y;;;LM_CODE='$I\ROOM$'    'I:I\MARKET;=;18  'DO(01)   'O:SETFOCUS;C\RUN   'O:BACKCOLOR;C\RUN;YELLOW  'DOEND(01)  
1 0.0 Work 12 I -1 331, 361
$VALIDATE    I:I\FROM_DATE;=;  A:CONST;;I\TO_DATE    I:I\FROM_DATE;<>;  'A:CONST;$T\DATE$;I\TO_DATE    I:I\TO_DATE;<>;   DO(03)    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   DOEND(03)      'O:SETFOCUS;C\RUN  'O:BACKCOLOR;C\RUN;YELLOW    
1 0.0 Work 15 I 0 391, 553
  
1 0.0 Work 3 I -1 331, 505
$VALIDATE    I:I\MARKET;=;11  DO(11)  O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW  DOEND(11)    
1 0.0 Work 2 I -1 331, 289
$VALIDATE    C:UCASE  I:I\DUMP;=;  A:CONST;N;I\DUMP  V:Y;N    A:ORGS;;I\ORGS    'I:I\MARKET;=;18  'O:SETFOCUS;I\FROM_DATE    I:I\DUMP;=;Y  DO(DUMP)  O:SHOW;I\AGENT,T\AGENT,C\AGN,T\AGENT_NAME  O:ENABLEINPUT;I\AGENT,C\AGN  DOEND(DUMP)    I:I\DUMP;=;N  DO(DUMP)  O:HIDE;I\AGENT,T\AGENT,C\AGN,T\AGENT_NAME  O:DISABLEINPUT;I\
1 0.0 Label 1 T -1 181, 289
  
1 0.0 Label 2 T -1 181, 469
  
1 0.0 Label 1 T -1 291, 217
  
1 0.0 Label 1 T -1 181, 433
  
1 0.0 Label 1 T -1 291, 169
  
1 0.0 Label 2 T -1 291, 193
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 311, 49
  
1 0.0 Label 5 T -1 621, 25
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 8 T -1 671, 49
  
1 0.0 Label 9 T -1 1, 25
  
1 0.0 Label 6 T -1 181, 253
  
1 0.0 Label 4 T -1 291, 97
  
1 0.0 Label 5 T -1 291, 121
  
1 0.0 Label 13 T -1 181, 325
  
1 0.0 Label 9 T -1 181, 397
  
1 0.0 Label 14 T -1 181, 361
  
1 0.0 Label 5 T -1 291, 145
  
1 0.0 Label 2 T -1 181, 505
  
1 0.0 CMD 4 C -1 451, 289
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Label 5 T -1 531, 289
  
10 0.0 ZX_PRINT Z 0 1, 25
  
10 0.0 ZX_SELECT Z 0 1, 25
  
10 0.0 ZX_DELETE Z 0 1, 25
  
10 0.0 ZX_UPDATE Z 0 1, 25
  
10 0.0 ZX_EXIT Z 0 1, 25