Freshmark replication server

freshmark-canonical

Program drill-down

CLEAR_UNCONF_CS_DEP

CLEAR UNCONFIRMED COLD STORAGE DEPOSITS. Type DSP, base table LOC_TRANS.

Field inventory

29

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 7 T -1 191, 49
  
1 0.0 Label 8 T -1 211, 181
  
1 0.0 Label 9 T -1 211, 217
  
1 0.0 Label 10 T -1 331, 313
  
1 0.0 Work 11 I -1 351, 181
$SELECT    S:AGN_CODE;I\AGENT    $VALIDATE  A:CONST;;I\CONF,T\PROG  I:I\AGENT;<>;  DO(1)  C:UCASE  F:AGENT_MAST;;;W\ACCTYPE=AM_TYPE,T\NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    I:T\NAME;=;  D:AGENT $I\AGENT$ DOES NOT EXIST;ERRORM;I\AGENT  DOEND(1)
1 0.0 Work 12 I -1 351, 217
$SELECT  I:I\AGENT;=;  S:CLEAR_CS_DEP;I\DEPNO    I:I\AGENT;<>;  S:CLEAR_CSDEP_AGN;I\DEPNO;I\AGENT      $VALIDATE    I:I\DEPNO;<>;  DO(AGN)  I:I\AGENT;<>;  F:LOC_TRANS INNER JOIN STK_DETS ON LT_CONSIGNO=SD_CONSIGN AND LT_DELDATE=SD_DATE;;;W\CODE=LT_AGENT;LT_DEPNO='$I\DEPNO$' AND LT_AGENT='$I\AGENT$' AND LT_CONFIRMED<>'Y
1 0.0 Work 13 I 0 1, 73
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD AGENT CODE  A:ORGS;;I\ORGS    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME  C:MCASE;;T\MKT
1 0.0 Work 14 I 0 1, 97
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000
1 0.0 CMD 15 C -1 331, 277
$SELECT  A:CONST;;I\CONF  I:I\AGENT;=;  DO(2)  I:I\DEPNO;=;  U:DEP_MESSAGE;MESSAGE  DOEND(2)    I:I\AGENT;<>;  DO(3)  I:I\DEPNO;=;  U:DEP_MESSAGE2;MESSAGE  DOEND(3)    I:I\AGENT;=;  DO(4)  I:I\DEPNO;<>;  U:DEP_MESSAGE3;MESSAGE  DOEND(4)    I:I\AGENT;<>;  DO(5)  I:I\DEPNO;<>;  U:DEP_MESSAGE3;MESSAGE  DOEND(5)    I:I\CON
1 0.0 Work 2 I 0 1, 145
  
1 0.0 Work 1 I 0 1, 121
  
1 0.0 Work 3 I 0 1, 169
  
1 0.0 Work 1 I 0 1, 193
  
1 0.0 CMD 4 C -1 451, 217
$SELECT  I:I\AGENT;=;  S:CLEAR_CS_DEP;I\DEPNO    I:I\AGENT;<>;  S:CLEAR_CSDEP_AGN;I\DEPNO;I\AGENT
1 0.0 Work 1 I 0 1, 277
  
1 0.0 Work 1 I 0 1, 241
  
1 0.0 CMD 3 C -1 451, 181
$SELECT    S:AGN_CODE;I\AGENT
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_PRINT 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