Program drill-down
DIRECT_CONS_AMD_PRE
DIRECT SALE AMENDMENT. Type DSP, base table STK_DETS.
Field inventory
73
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 3 | T | -1 | 211, 409 | ||
| 1 | 0.0 | Work 4 | I | -1 | 321, 409 | $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$'; I:I\SDD_PRICE;>; |
|
| 1 | 0.0 | Work 20 | I | 0 | 1, 361 | ||
| 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 | Work 2 | I | -1 | 321, 457 | ||
| 1 | 0.0 | Work 23 | I | 0 | 1, 433 | ||
| 1 | 0.0 | Work 14 | I | -1 | 321, 433 | $CALCULATE I:I\USED_PRICE;<=;0 DO(PRICE15) D:PRICE MUST BE GREATER THAN ZERO;ERRORM;I\USED_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_C |
|
| 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 | 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 8 | T | -1 | 281, 49 | ||
| 1 | 0.0 | Label 1 | T | -1 | 281, 25 | ||
| 1 | 0.0 | T | -1 | 211, 121 | |||
| 1 | 0.0 | MARKET | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 471, 385 | ||
| 1 | 0.0 | Work 4 | I | -1 | 591, 385 | ||
| 1 | 0.0 | Work 15 | I | 0 | 1, 289 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 97 | ||
| 1 | 0.0 | Label 4 | T | -1 | 351, 541 | ||
| 1 | 0.0 | Label 4 | T | -1 | 211, 169 | ||
| 1 | 0.0 | Label 3 | T | -1 | 611, 25 | ||
| 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 5 | I | -1 | 321, 169 | ||
| 1 | 0.0 | Work 13 | I | -1 | 321, 361 | $CALCULATE M: I:I\SDD_CONQTY;<=;0;NUM DO(99) D:QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\SDD_CONQTY DOEND(99) U:DIRECT_DELIVERY_PRE;DIRECTMKTAVE |
|
| 1 | 0.0 | Work 24 | I | 0 | 1, 457 | ||
| 1 | 0.0 | Work 6 | I | -1 | 321, 481 | ||
| 1 | 0.0 | Work 4 | I | -1 | 591, 457 | ||
| 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 | CMD 1 | C | -1 | 351, 517 | $SELECT A:CONST;IN PROGRESS........;I\PROG U:AMEND_DD_CONSIGN_PRE;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_VAL A:C |
|
| 1 | 0.0 | CMD 5 | C | -1 | 421, 97 | $SELECT S:CONSIGN_DIRECT;I\CONSIGN |
|
| 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_INV_PRICE=SDD_INV_PRICE,I\SDD_ITEM=SDD_ITEM,I\SDD_CLASS=SDD_CLASS,I\SDD_SIZE=SDD_SIZE,I\SDD_CONT=SDD_CONT,I\SDD_CONTMASS=SDD_CONTMASS,I\SDD_PROV=SDD_PROV,I\SDD_COUNT=SDD_COUNT,I\SD |
|
| 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 | 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 6 | T | -1 | 211, 361 | ||
| 1 | 0.0 | Label 7 | T | -1 | 211, 433 | ||
| 1 | 0.0 | Label 16 | T | -1 | 211, 313 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 457 | ||
| 1 | 0.0 | Label 3 | T | -1 | 471, 457 | ||
| 1 | 0.0 | Label 5 | T | -1 | 211, 481 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 337 | ||
| 1 | 0.0 | Work 2 | I | -1 | 321, 337 | ||
| 1 | 0.0 | Label 1 | T | -1 | 211, 385 | ||
| 1 | 0.0 | Work 2 | I | -1 | 321, 385 | $CALCULATE I:I\SDD_INV_PRICE;<>; DO(MZ) I:I\SDD_INV_PRICE;<=;0 DO(PRICE15) D:PRICE MUST BE GREATER THAN ZERO;ERRORM;I\SDD_INV_PRICE DOEND(PRICE15) A:DIV;I\SDD_INV_PRICE;I\INV_PER_KG;I\SDD_CONTMASS;;#0.00 A:VAR;I\INV_PER_KG;I\INV_PER_KG;;#0.00 DOEND(MZ) I:I\INV_PRICE;=; A:CONST;0.00;I\SDD_INV_PRICE I:I |
|
| 1 | 0.0 | Work 1 | I | 0 | 11, 517 | ||
| 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 |