Freshmark replication server

freshmark-canonical

Program drill-down

CONSIGNMENT_BLOCK

CONSIGN BLOCK. Type DSP, base table STK_DETS.

Field inventory

48

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 22 C -1 481, 145
$SELECT  I:I\ORGS;=;  S:CONSDEL;I\CONSIGN    I:I\ORGS;<>;  S:CONSDEL1;I\CONSIGN;I\ORGS
1 0.0 CMD 1 C -1 641, 548
$SELECT  I:I\REASON;=;  D:REASON CODE IS A MANDATORY FIELD;ERRORM;I\REASON  U:CONSIGNMENT_BLOCK;UPDATE    O:SETFOCUS;I\CONSIGN    A:CONST;;I\BLOCK,I\DELDATE,I\CONSIGN,I\COMMODITY,I\QTY,I\SUPPL,I\AGENT,W\BLOCK,I\REASON,W\REASON,I\BLK_COMMENT  
1 0.0 Work 1 I 0 1, 205
  
1 0.0 Label 1 T -1 201, 469
  
1 0.0 H -1 0, 0
  
1 0.0 Label 9 T -1 201, 181
  
1 0.0 Label 10 T -1 201, 217
  
1 0.0 Work 15 I -1 381, 145
$SELECT  I:I\ORGS;=;  S:CONSDEL;I\CONSIGN    I:I\ORGS;<>;  S:CONSDEL1;I\CONSIGN;I\ORGS    $VALIDATE  M:  A:VAR;I\CONSIGN;I\CONSIGN;;00000000    F:STK_DETS;Y;;I\DELDATE=SD_DATE,I\AGENT=SD_AGENT,W\BLOCK=SD_BLOCK,I\BLOCK=SD_BLOCK;SD_MARKET='$I\MARKET$' AND SD_CONSIGN='$I\CONSIGN$' AND ISNULL(SD_CDATE) AND SD_STK_TAKE <> '
1 0.0 Work 2 I 0 1, 85
  
1 0.0 Work 16 I -1 381, 181
  
1 0.0 Work 17 I -1 381, 217
  
1 0.0 Work 18 I -1 381, 253
  
1 0.0 Work 19 I -1 381, 289
  
1 0.0 Work 20 I -1 381, 325
  
1 0.0 Work 21 I -1 381, 361
$VALIDATE  C:UCASE  I:I\BLOCK;=;  A:CONST;N;I\BLOCK  V:Y;N    I:I\BLOCK;=;Y  DO(1)  I:W\BLOCK;=;Y  D:CONSIGNMENT ALREADY BLOCKED;ERRORM;I\BLOCK  DOEND(1)    I:I\BLOCK;=;N  DO(1)  I:W\BLOCK;=;N  D:CONSIGNMENT ALREADY UNBLOCKED;ERRORM;I\BLOCK  DOEND(1)  
1 0.0 Label 1 T -1 201, 433
  
1 0.0 Work 2 I -1 381, 433
    
1 0.0 Work 2 I -1 381, 397
$VALIDATE  C:UCASE  M:  O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Work 5 I 0 1, 157
  
1 0.0 Work 24 I 0 1, 61
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    ''O:CAPTION_UPD;PROCESS  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE
1 0.0 Label 32 T -1 521, 181
  
1 0.0 Work 25 I 0 21, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;I\PROHIBIT_SALES=CM_PROHIBIT_SALES,T\MARKET=CM_NAME    I:I\PROHIBIT_SALES;=;Y  DO(LAM)    O:DISABLEINPUT;I\CONSIGN    D:SALES ARE PROHIBITED, TRANSACTION CANNOT BE DONE;ERRORM;I\CONSIGN  DOEND(LAM)    'CHANGING TEXT CASE FOR THE 
1 0.0 Label 11 T -1 201, 253
  
1 0.0 Label 12 T -1 201, 289
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 8 T -1 201, 145
  
1 0.0 Work 26 I 0 41, 61
$DEFAULT  A:ORGS;;I\ORGS  
1 0.0 Work 27 I 0 61, 61
$DEFAULT  A:USERIP;;I\IP
1 0.0 Work 28 I 0 81, 61
$DEFAULT  A:USERID;;I\USERID    
1 0.0 Work 3 I 0 1, 109
  
1 0.0 Label 14 T -1 201, 361
  
1 0.0 Label 13 T -1 201, 325
  
1 0.0 Label 1 T -1 201, 397
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Work 4 I 0 1, 133
  
1 0.0 Label 39 T -1 521, 217
  
1 0.0 Work 6 I 0 1, 181
  
1 0.0 Work 1 I -1 381, 469
  
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