Program drill-down
PALL_CONS_AMEND
EDIT PALLET CONSIGNMENT. Type DSP, base table STK_DETS.
Field inventory
42
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 3 | C | -1 | 491, 217 | $SELECT S:CONSIGN_NO_PALL;I\CONSIGN;I\AGENT |
|
| 1 | 0.0 | Label 4 | T | -1 | 351, 433 | ||
| 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 | STK_DETS | SD_CONSIGN | I | -1 | 391, 217 | $SELECT S:CONSIGN_NO_PALL;I\CONSIGN;I\AGENT $VALIDATE M: A:VAR;I\CONSIGN;I\CONSIGN;;00000000 A:CONST;;I\PROG F:STK_DETS;Y;SD_CONSIGN;I\DEL_DATE=SD_DATE,I\DELNO=SD_DELNO;SD_MARKET='$I\MARKET$' AND SD_AGENT='$I\AGENT$' AND ISNULL(SD_CDATE);I\CONSIGN A:VAR;I\DEL_DATE;I\DEL_DATE;;YYYY/MM/DD F:PALL_DETS;Y;P |
| 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 | 391, 289 | $VALIDATE I:I\QTY_DELIV;<;I\QTY_SOLD DO(001) D:QUANTITY CAN NOT BE LESS THAN SOLD QUANTITY;ERRORM;I\QTY_DELIV DOEND(001) O:SETFOCUS;C\UPD O:BACKCOLOR;C\UPD;YELLOW |
||
| 1 | 0.0 | CMD 1 | C | -1 | 351, 457 | $SELECT A:CONST;IN PROGRESS........;I\PROG U:PALL_CONSIGN_AUDIT;UPDATE A:CONST;;I\CONSIGN,I\QTY_DELIV,I\QTY_RET,I\QTY_SOLD,I\QTY_AVAIL,I\PALL_CODE,I\QTY_RETURN I:I\ORGS;<>; DO(0001) O:SETFOCUS;I\CONSIGN DOEND(0001) I:I\ORGS;=; DO(0001) O:SETFOCUS;I\AGENT A:CONST;;T\AGN_MNAME DOEND(0001) A:CONST;FIN |
|
| 1 | 0.0 | Work 2 | I | 0 | 1, 265 | ||
| 1 | 0.0 | I | -1 | 391, 253 | |||
| 1 | 0.0 | I | -1 | 391, 181 | $SELECT S:AGENT_CODE;I\AGENT $VALIDATE M: C:UCASE F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT A:CONST;;I\PROG |
||
| 1 | 0.0 | CMD 5 | C | -1 | 491, 181 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | Label 6 | T | -1 | 521, 181 | ||
| 1 | 0.0 | Work 8 | I | 0 | 1, 73 | ||
| 1 | 0.0 | Label 4 | T | -1 | 271, 289 | ||
| 1 | 0.0 | T | -1 | 271, 217 | |||
| 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 | 271, 253 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 121 | ||
| 1 | 0.0 | Label 1 | T | -1 | 271, 181 | ||
| 1 | 0.0 | Label 2 | T | -1 | 271, 325 | ||
| 1 | 0.0 | Label 3 | T | -1 | 271, 361 | ||
| 1 | 0.0 | Work 4 | I | -1 | 391, 325 | ||
| 1 | 0.0 | Work 5 | I | -1 | 391, 361 | ||
| 1 | 0.0 | Label 6 | T | -1 | 271, 397 | ||
| 1 | 0.0 | Work 7 | I | -1 | 391, 397 | ||
| 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 |