Program drill-down
DIRECT_CONS_AMEND_PR
EDIT CONSIGNMENT. Type DSP, base table STK_DETS.
Field inventory
76
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 1 | C | -1 | 351, 505 | $SELECT A:CONST;IN PROGRESS........;I\PROG U:AMEND_DIRECT_DELIV_CONSIGN;UPDATE_STK_DETS_DIRECT A:CONST;;I\CONSIGN,I\QTY_DELIV,I\QTY_RET,I\QTY_SOLD,I\QTY_AVAIL,I\PALL_CODE,I\QTY_RETURN A:CONST;;I\SMD_DELNO,I\SDD_ITEM,I\SDD_CLASS,I\SDD_SIZE,I\SDD_CONT,I\SDD_PROV,I\SDD_COUNT,I\SDD_CONQTY,I\SDD_PRICE,I\SDD_TOT_VA |
|
| 1 | 0.0 | CMD 5 | C | -1 | 421, 97 | $SELECT S:CONSIGN_DIRECT;I\CONSIGN |
|
| 1 | 0.0 | CMD 6 | C | -1 | 421, 397 | $SELECT A:CON;I\CLASS;I\TMP1;I\SIZE S:COUNT_MAST_CNT;I\SDD_COUNT;I\PROD;I\;I\SDD_COUNT |
|
| 1 | 0.0 | CMD 5 | C | -1 | 421, 373 | $SELECT I:I\SM_MARKET;<>;40 S:PROVINCE_SUPPL;I\SDD_PROV;I\SMD_SUPP;I\PROD |
|
| 1 | 0.0 | CMD 1 | C | -1 | 421, 265 | $SELECT S:ITEM_SEL;I\SDD_ITEM A:SELPARM;2;I\TMP1 A:CON;I\SDD_ITEM;I\SDD_ITEM;I\TMP1 |
|
| 1 | 0.0 | CMD 2 | C | -1 | 421, 289 | $SELECT S:CLASS_ITEM;I\SDD_CLASS;I\PROD;I\VAR |
|
| 1 | 0.0 | CMD 3 | C | -1 | 421, 313 | $SELECT S:SIZE_ITEM;I\SDD_SIZE;I\PROD;I\VAR |
|
| 1 | 0.0 | CMD 4 | C | -1 | 421, 349 | $SELECT S:CONT_PR_NODEL;I\SDD_CONT;I\PROD;I\VAR;I\SDD_CLASS;I\SDD_SIZE |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 7 | I | 0 | 31, 73 | ||
| 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 | I | -1 | 321, 121 | |||
| 1 | 0.0 | Work 21 | I | 0 | 1, 385 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 97 | ||
| 1 | 0.0 | Work 2 | I | 0 | 1, 157 | ||
| 1 | 0.0 | Work 3 | I | 0 | 1, 193 | ||
| 1 | 0.0 | Work 4 | I | 0 | 1, 229 | ||
| 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:ORGS;;I\ORGS I:I\AGENT;<>; DO(12) ''''F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT O:DISABLEINPUT;I\AGENT,C\AGENT DOEND(12) A:CONST;Y;I\UPDATE A:USERIP;;I\IP A:USERID;;I\USERID |
|
| 1 | 0.0 | I | -1 | 321, 169 | |||
| 1 | 0.0 | Work 2 | I | 0 | 1, 265 | ||
| 1 | 0.0 | I | -1 | 321, 145 | |||
| 1 | 0.0 | SDD_CONSIGN | I | -1 | 321, 97 | $SELECT S:CONSIGN_DIRECT;I\CONSIGN $VALIDATE M: A:VAR;I\CONSIGN;I\CONSIGN;;00000000 F:STK_DETS_DIRECT;Y;;I\SMD_DELNO=SDD_DELNO,I\SDD_ITEM=SDD_ITEM,I\SDD_CLASS=SDD_CLASS,I\SDD_SIZE=SDD_SIZE,I\SDD_CONT=SDD_CONT,I\SDD_PROV=SDD_PROV,I\SDD_COUNT=SDD_COUNT,I\SDD_CONQTY=SDD_RECQTY,I\SDD_PRICE=SDD_PRICE,I\SDD_VAT=SDD_VA |
|
| 1 | 0.0 | Work 8 | I | 0 | 1, 73 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 121 | ||
| 1 | 0.0 | Work 4 | I | -1 | 321, 193 | ||
| 1 | 0.0 | Work 5 | I | -1 | 321, 217 | ||
| 1 | 0.0 | Work 7 | I | -1 | 321, 241 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_ITEM | I | -1 | 321, 265 | $SELECT S:ITEM_SEL;I\SDD_ITEM A:SELPARM;2;I\TMP1 A:CON;I\SDD_ITEM;I\SDD_ITEM;I\TMP1 $CALCULATE M: C:UCASE A:LEFT;I\SDD_ITEM,2;I\PROD A:MID;I\SDD_ITEM,3,2;I\VAR F:VAR_MAST;Y;;I\TMP1=VA_BLOCKED,I\PROV_REQ=VA_PROV_REQ;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I\VAR$';I\SDD_ITEM I:I\TMP1;=;Y D:THIS VARIETY HAS BE |
| 1 | 0.0 | I | -1 | 321, 289 | $SELECT S:CLASS_ITEM;I\SDD_CLASS;I\PROD;I\VAR $CALCULATE 'M: C:UCASE I:I\SDD_CLASS;<>; DO(001) A:CONST;;I\TMP1 F:CLASS_MAST;Y;CL_CLASS;I\TMP1=CL_BLOCKED;;I\SDD_CLASS I:I\TMP1;=;Y D:THIS CLASS HAS BEEN BLOCKED;ERRORM;I\SDD_CLASS DOEND(001) A:VAR;I\SD_CLASS;I\CLASS I:I\CLASS;=; A:CONST;0;I\CLASS |
||
| 1 | 0.0 | Work 10 | I | -1 | 321, 349 | $SELECT S:CONT_PR_NODEL;I\SDD_CONT;I\PROD;I\VAR;I\SDD_CLASS;I\SDD_SIZE $CALCULATE I:I\MARKET;<>;11 M: C:UCASE A:VAR;I\SD_CONT;I\TMPCONT A:CONST;;I\TMP1 I:I\MARKET;<>;11 F:COMMODITY_MAST;Y;CO_CONT;I\TMP1=CO_BLOCKED;CO_PRODUCT='$I\PROD$' AND CO_VAR='$I\VAR$' AND CO_CLASS='$I\SDD_CLASS$' AND CO_SIZE='$I\S |
|
| 1 | 0.0 | Work 11 | I | -1 | 321, 373 | $SELECT I:I\SM_MARKET;<>;40 S:PROVINCE_SUPPL;I\SDD_PROV;I\SMD_SUPP;I\PROD $CALCULATE C:UCASE I:I\MARKET;<>;11 M: '<<<<<<<<<<<< 2016-01-13 SIYA ADDED THE CHECK BELLOW ON JANET'S REQUEST JOB NUMBER - 23999 >>>>>>>>>>>>>>> F:SUPPL_PROD_PROV;;;I\TMP_SSP_PROV=SPP_PROV;SPP_CODE='$I\SMD_SUPP$' AND SPP_PROD='$I\P |
|
| 1 | 0.0 | Work 12 | I | -1 | 321, 397 | $DEFAULT DIM TMP5,TMP6 $SELECT A:CON;I\CLASS;I\TMP1;I\SIZE S:COUNT_MAST_CNT;I\SDD_COUNT;I\PROD;I\;I\SDD_COUNT $CALCULATE I:I\SDD_COUNT;<>; DO(001) A:CON;I\CLASS;I\TMP1;I\SIZE F:COUNT_MAST;;CNT_COUNT;TMP5=CNT_PRODUCT;CNT_PRODUCT='$I\PROD$' AND CNT_CONTAINER = '$I\SDD_CONT$' AND CNT_GRADE = '$I\TMP1$ |
|
| 1 | 0.0 | Work 13 | I | -1 | 321, 421 | $CALCULATE M: I:I\SDD_CONQTY;<=;0;NUM DO(99) D:QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\SDD_CONQTY DOEND(99) |
|
| 1 | 0.0 | Work 14 | I | -1 | 321, 445 | $CALCULATE I:I\SDD_PRICE;<=;0 DO(PRICE15) D:PRICE MUST BE GREATER THAN ZERO;ERRORM;I\SDD_PRICE DOEND(PRICE15) I:I\SDD_CONQTY;<=;0;NUM DO(99) D:QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\SDD_CONQTY DOEND(99) F:VAR_MAST;;;I\TMP1=VA_VATCD;VA_PRODUCT='$I\TMP$' AND VA_VARIETY='$I\TMP_VAR$'; A:MULT;I\SDD_CON |
|
| 1 | 0.0 | Work 22 | I | 0 | 1, 409 | ||
| 1 | 0.0 | Work 18 | I | 0 | 1, 313 | ||
| 1 | 0.0 | Work 19 | I | 0 | 1, 337 | ||
| 1 | 0.0 | Work 17 | I | -1 | 321, 313 | $SELECT S:SIZE_ITEM;I\SDD_SIZE;I\PROD;I\VAR $SELECT6 S:GRADE_ITEM;I\SDD_CLASS;I\PROD;I\VAR A:SELPARM;1;I\SDD_CLASS A:SELPARM;2;I\SDD_SIZE $CALCULATE 'M: C:UCASE I:I\SDD_SIZE;<>; DO(001) A:CONST;;I\TMP1 F:SIZE_MAST;Y;SZ_SIZE;I\TMP1=SZ_BLOCKED;;I\SDD_SIZE I:I\TMP1;=;Y D:THIS SIZE HAS BEEN BLOC |
|
| 1 | 0.0 | Work 20 | I | 0 | 1, 361 | ||
| 1 | 0.0 | Work 15 | I | 0 | 1, 289 | ||
| 1 | 0.0 | Work 2 | I | -1 | 431, 445 | ||
| 1 | 0.0 | Work 23 | I | 0 | 1, 433 | ||
| 1 | 0.0 | Work 24 | I | 0 | 1, 457 | ||
| 1 | 0.0 | Work 4 | I | -1 | 531, 445 | ||
| 1 | 0.0 | Work 6 | I | -1 | 631, 445 | ||
| 1 | 0.0 | Label 4 | T | -1 | 351, 529 | ||
| 1 | 0.0 | Label 4 | T | -1 | 211, 169 | ||
| 1 | 0.0 | T | -1 | 211, 121 | |||
| 1 | 0.0 | Label 8 | T | -1 | 261, 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 | Label 2 | T | -1 | 211, 145 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 97 | ||
| 1 | 0.0 | Label 2 | T | -1 | 211, 193 | ||
| 1 | 0.0 | Label 3 | T | -1 | 211, 217 | ||
| 1 | 0.0 | Label 6 | T | -1 | 211, 241 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 265 | ||
| 1 | 0.0 | Label 2 | T | -1 | 211, 289 | ||
| 1 | 0.0 | Label 3 | T | -1 | 211, 349 | ||
| 1 | 0.0 | Label 4 | T | -1 | 211, 373 | ||
| 1 | 0.0 | Label 5 | T | -1 | 211, 397 | ||
| 1 | 0.0 | Label 6 | T | -1 | 211, 421 | ||
| 1 | 0.0 | Label 7 | T | -1 | 211, 445 | ||
| 1 | 0.0 | Label 16 | T | -1 | 211, 313 | ||
| 1 | 0.0 | Label 1 | T | -1 | 431, 421 | ||
| 1 | 0.0 | Label 3 | T | -1 | 531, 421 | ||
| 1 | 0.0 | Label 5 | T | -1 | 631, 421 | ||
| 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 |
|
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 |