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 |