Freshmark replication server

freshmark-canonical

Program drill-down

CONSIGN_EDIT_PTA

EDIT CONSIGNMENT REMARKS. Type MAN, base table STK_DETS.

Field inventory

86

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 12 C -1 381, 457
$SELECT  S:COLOUR_ITEM;I\SD_COLOUR
1 0.0 SD_CONSIGN C -1 381, 169
$SELECT  S:CONSIGNMENT22;I\SD_CONSIGN;I\AGENT  
1 0.0 CMD 6 C -1 381, 277
$SELECT  'S:CLASS_NB2;I\SD_CLASS;  'S:COM_ENQ_CLASS;I\CO_CLASS;I\CO_PRODUCT;I\CO_VAR  S:CLASSZ;I\SD_CLASS;I\SD_PRODUCT;I\SD_VAR
1 0.0 CMD 3 C -1 381, 241
$SELECT  S:ITEM_NEW;I\SD_ITEM  
1 0.0 CMD 5 C -1 381, 349
$SELECT  'S:CONT_MAST_NB;I\SD_CONT;I\SD_PRODUCT  'S:COM_ENQ_CONT;I\CO_CONT;I\CO_PRODUCT;I\CO_VAR;I\CO_CLASS;I\CO_SIZE  S:CONT_MAST_NB;I\SD_CONT;I\SD_PRODUCT;I\SD_VAR
1 0.0 CMD 4 C -1 381, 313
$SELECT  'S:SIZE_NB2;I\SD_SIZE  'S:COM_ENQ_SIZE;I\CO_SIZE;I\CO_PRODUCT;I\CO_VAR;I\CO_CLASS  S:SIZEW;I\SD_SIZE;I\SD_PRODUCT;I\SD_CLASS;I\SD_VAR
1 0.0 CMD 8 C -1 381, 421
$SELECT  A:CON;I\SD_CLASS;I\TMP1;I\SD_SIZE  S:COUNT_MAST_CNT;I\SD_COUNT;I\SD_PRODUCT;I\TMP1;I\SD_CONT  
1 0.0 CMD 4 C -1 381, 385
$SELECT  S:PROVINCE;I\SD_PROV
1 0.0 H -1 0, 0
  
1 0.0 Work 7 I 0 31, 73
  
1 0.0 STK_DETS SD_COUNT I -1 271, 421
$SELECT  A:CON;I\SD_CLASS;I\TMP1;I\SD_SIZE  S:COUNT_MAST_CNT;I\SD_COUNT;I\SD_PRODUCT;I\TMP1;I\SD_CONT    $VALIDATE  A:CONST;;I\TMP5,I\TMP6  I:I\SD_COUNT;<>;  DO(001)    A:CON;I\CLASS_TMP;I\GRADE_TMP;I\SIZE_TMP    'A:CON;I\CLASS;I\TMP1;I\SIZE    A:CONST;$I\SD_CLASS$$I\SD_SIZE$;I\TMP6    '''F:COUNT_MAST;;CNT_COUNT;TMP5=C
1 0.0 Work 16 I 0 561, 421
  
1 0.0 STK_DETS SD_PROV I -1 271, 385
$SELECT  S:PROVINCE;I\SD_PROV    $VALIDATE  C:UCASE    A:VAR;I\SD_PROV;I\TMPPROV    I:I\SD_PROV;<>;  DO(001)    A:CONST;;I\TMP1    F:PROV_MAST;Y;PR_PROV;I\TMP1=PR_BLOCKED,T\PROV=PR_DESC;;I\SD_PROV    I:I\TMP1;=;Y    D:THIS PROVINCE HAS BEEN BLOCKED;ERRORM;I\SD_PROV  DOEND(001)
1 0.0 MARKET I 0 41, 49
$DEFAULT  'GET USERS MARKET CODE - ZU_MARKET IN ZU_USER  A:ORG;;I\MARKET  'GET MARKET NAME FROM CLIENT MASTER  'F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\SD_MARKET$'  F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\MARKET$'  'CONVERT TO FIRST CHARACTER UPPER CASE REST LOWER CASE  C:MCASE;;T\MARKET
1 0.0 Work 1 I 0 61, 73
  
1 0.0 Work 1 I 0 51, 517
  
1 0.0 STK_DETS SD_MARKET I 0 621, 217
  
1 0.0 Work 5 I 0 1, 313
  
1 0.0 STK_DETS SD_CONSIGN I -1 271, 169
$SELECT  S:CONSIGNMENT22;I\SD_CONSIGN;I\AGENT    $VALIDATE   A:CONST;;W\DELDATE,W\DELNO,W\FINALDATE    I:I\ORGS;<>;  DO(8888)  U:NEW_DELIV_ALLOW;TEST  I:I\ALLOW_NEW_DELIV;<>;  DO(5558)  I:I\ALLOW_NEW_DELIV;<>;Y  D:YOU ARE NOT ALLOWED TO AMEND CONSIGNMENTS;ERRORM;I\SD_CONSIGN  DOEND(5558)  DOEND(8888)    A:VAR;I\CONSIGN
1 0.0 STK_DETS SD_DATE I -1 271, 205
  
1 0.0 DEFAULT I 0 1, 49
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:ORGS;;I\AGENT    A:CONST;Y;I\UPDATE  A:USERIP;;I\IP  A:USERID;;I\USERID
1 0.0 STK_DETS SD_CONT I -1 271, 349
$SELECT  S:CONT_MAST_NB;I\SD_CONT;I\SD_PRODUCT;I\SD_VAR  'S:COM_ENQ_CONT;I\CO_CONT;I\CO_PRODUCT;I\CO_VAR;I\CO_CLASS;I\CO_SIZE    $VALIDATE  'M:  C:UCASE  ^F:CONT_MAST;Y;CN_CONT;I\SD_CONTMASS=CN_MASS,T\CONT_NAME=CN_DESC,W\BLOCKED=CN_BLOCKED;CN_PRODUCT='$I\SD_PRODUCT$' AND CN_VAR='$I\SD_VAR$';I\SD_CONT    I:W\BLOCKED;=;Y
1 0.0 STK_DETS SD_CLASS I -1 271, 277
$SELECT  'S:CLASS_NB2;I\SD_CLASS;  'S:COM_ENQ_CLASS;I\CO_CLASS;I\CO_PRODUCT;I\CO_VAR  S:CLASSZ;I\SD_CLASS;I\SD_PRODUCT;I\SD_VAR    $VALIDATE  'M: 21 MAY 2008 LAZOLA  C:UCASE  I:I\SD_CLASS;<>;  DO(01)  F:COMMODITY_MAST;Y;;W\BLOCKED=CO_BLOCKED;CO_PRODUCT='$I\SD_PRODUCT$' AND CO_VAR='$I\SD_VAR$' AND CO_CLASS='$I\SD_CLASS$
1 0.0 STK_DETS SD_SIZE I -1 271, 313
$SELECT  'S:SIZE_NB2;I\SD_SIZE  S:SIZEW;I\SD_SIZE;I\SD_PRODUCT;I\SD_CLASS;I\SD_VAR    $VALIDATE  'M: 21 MAY 2008 LAZOLA  C:UCASE  I:I\SD_SIZE;<>;  DO(02)  F:COMMODITY_MAST;Y;;W\BLOCKED2=CO_BLOCKED;CO_PRODUCT='$I\SD_PRODUCT$' AND CO_VAR='$I\SD_VAR$' AND CO_CLASS='$I\SD_CLASS$' AND CO_SIZE='$I\SD_SIZE$';I\SD_SIZE  I:W\BL
1 0.0 STK_DETS SD_ITEM I -1 271, 241
'$SELECT  'S:ITEM_NEW;I\SD_ITEM    $SELECT  S:ITEM_SEL;I\SD_ITEM    $VALIDATE  A:LEN;I\SD_ITEM;I\TMP133  I:I\TMP133;<;4;NUM  D:PLEASE ENTER A FULL LENGTH ITEM CODE;ERRORM;I\SM_DELNO    C:UCASE  A:LEFT;I\SD_ITEM,2;I\SD_PRODUCT  A:RIGHT;I\SD_ITEM,2;I\SD_VAR    F:VAR_MAST;Y;;T\ITEM_DESC=VA_DESC;VA_PRODUCT='$I\SD_PRODUCT$'
1 0.0 Work 7 I 0 1, 349
  
1 0.0 Work 8 I 0 11, 241
  
1 0.0 Work 9 I 0 71, 241
  
1 0.0 STK_DETS SD_COLOUR I -1 271, 457
$SELECT  S:COLOUR_ITEM;I\SD_COLOUR    $VALIDATE  C:UCASE  I:I\SD_COLOUR;<>;  F:COLOUR_MAST;Y;CLR_COLOUR;;;I\SD_COLOUR  F:COLOUR_MAST;;;T\COLOUR=CLR_DESC;CLR_COLOUR='$I\SD_COLOUR$';I\SD_COLOUR
1 0.0 STK_DETS SD_COMMENT I -1 271, 493
'ADDED BY LP20121112 ON JANET'S REQUEST FOR PRETORIA MARKET  $VALIDATE  M:  C:UCASE        
1 0.0 Work 14 I 0 531, 385
  
1 0.0 STK_DETS SD_CONTMASS I 0 281, 517
  
1 0.0 STK_DETS SD_AGENT I 0 651, 217
  
1 0.0 STK_DETS SD_SECT I 0 531, 241
  
1 0.0 STK_DETS SD_COMMP I 0 11, 205
  
1 0.0 Work 15 I 0 531, 421
  
1 0.0 Work 1 I 0 591, 445
  
1 0.0 Work 2 I 0 591, 469
  
1 0.0 Work 2 I 0 91, 517
  
1 0.0 TMP_DELDATE I 0 541, 181
  
1 0.0 Work 3 I 0 131, 517
  
1 0.0 CONSIGN I 0 681, 181
  
1 0.0 Work 4 I 0 11, 181
  
1 0.0 Work 1 I 0 61, 133
  
1 0.0 Work 2 I 0 11, 157
  
1 0.0 Work 6 I 0 11, 133
  
1 0.0 SM_AGENT I 0 421, 169
  
1 0.0 TMP133 I 0 641, 241
  
1 0.0 Work 8 I 0 1, 73
  
1 0.0 Work 2 I 0 481, 145
  
1 0.0 Work 1 I 0 481, 109
  
1 0.0 I 0 541, 277
  
1 0.0 I 0 571, 277
  
1 0.0 Work 3 I 0 541, 301
  
1 0.0 Work 1 I 0 101, 97
  
1 0.0 Work 2 I 0 1, 97
  
1 0.0 Label 9 T -1 421, 421
  
1 0.0 Label 10 T -1 141, 457
  
1 0.0 Label 1 T -1 141, 493
  
1 0.0 Label 6 T -1 421, 313
  
1 0.0 Label 4 T -1 141, 349
  
1 0.0 STK_DETS SD_CONSIGN T -1 141, 169
  
1 0.0 STK_DETS SD_DATE T -1 141, 205
  
1 0.0 Label 8 T -1 241, 49
  
1 0.0 Label 1 T -1 281, 25
  
1 0.0 MARKET T -1 1, 25
  
1 0.0 Label 3 T -1 611, 25
  
1 0.0 Label 4 T -1 611, 49
  
1 0.0 Label 5 T -1 661, 25
  
1 0.0 Label 6 T -1 661, 49
  
1 0.0 STK_DETS SD_ITEM T -1 141, 241
  
1 0.0 Label 2 T -1 141, 277
  
1 0.0 Label 3 T -1 141, 313
  
1 0.0 Label 6 T -1 141, 421
  
1 0.0 Label 10 T -1 421, 349
  
1 0.0 Label 2 T -1 421, 241
  
1 0.0 Label 13 T -1 421, 457
  
1 0.0 Label 5 T -1 421, 385
  
1 0.0 Label 3 T -1 141, 385
  
1 0.0 Label 3 T 0 11, 397
  
1 0.0 Label 5 T 0 11, 433
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z -1 0, 0
$BEFORE_WRITE     A:VAR;I\SD_DATE;I\SD_DATE;;YYYY/MM/DD    U:UPD_COMMPERC  A:CONST;$I\SD_COMMP$;I\COMM_PERC    I:I\COMM_PERC;>;0  DO(COM)    'U:CONS_COMM_CHANGES;UPDATE_COMM  DOEND(COM)    $AFTER_WRITE      'U:CONSIGN_LEVY_RECALCULATE;CALC  A:CONST;;I\DT_FLAG
10 0.0 ZX_EXIT Z 0 0, 0