Program drill-down
CONS_PALL_MAN
ADD TO PALLET CONSIGNMENT. Type MAN, base table STK_DETS.
Field inventory
59
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 6 | T | -1 | 121, 217 | ||
| 1 | 0.0 | Label 8 | T | -1 | 121, 253 | ||
| 1 | 0.0 | Label 5 | T | -1 | 121, 145 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | STK_DETS | SD_CONSIGN | I | -1 | 271, 109 | $SELECT S:PALL_CONS;I\SD_CONSIGN;I\MARKET;I\ORGS $VALIDATE M: 'ZEROFILL A:ZEROFILL;I\SD_CONSIGN,W\ZEROFILL;I\SD_CONSIGN F:STK_DETS;;;I\DEL_DATE=SD_DATE;SD_CONSIGN='$I\SD_CONSIGN$' AND ISNULL(SD_CDATE) AND SD_STK_TAKE <> 'Y' A:VAR;I\DEL_DATE;I\DEL_DATE;;YYYY/MM/DD F:PALL_DETS;;;I\PALL_CODE=PD_PALL;PD_C |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | T | -1 | 121, 109 | |
| 1 | 0.0 | Label 2 | T | -1 | 121, 181 | ||
| 1 | 0.0 | Work 3 | I | -1 | 271, 181 | ||
| 1 | 0.0 | Work 7 | I | -1 | 271, 217 | ||
| 1 | 0.0 | Work 4 | I | -1 | 271, 145 | ||
| 1 | 0.0 | Work 9 | I | -1 | 271, 253 | ||
| 1 | 0.0 | Label 10 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 11 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 12 | T | -1 | 251, 49 | ||
| 1 | 0.0 | Label 13 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 14 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 16 | T | -1 | 671, 49 | ||
| 1 | 0.0 | CMD 17 | C | -1 | 391, 109 | $SELECT S:PALL_CONS;I\SD_CONSIGN;I\MARKET;I\ORGS |
|
| 1 | 0.0 | Label 18 | T | -1 | 491, 109 | ||
| 1 | 0.0 | Work 19 | I | -1 | 641, 109 | ||
| 1 | 0.0 | Label 20 | T | -1 | 461, 181 | ||
| 1 | 0.0 | Label 21 | T | -1 | 461, 145 | ||
| 1 | 0.0 | Label 22 | T | -1 | 461, 217 | ||
| 1 | 0.0 | Label 23 | T | -1 | 461, 253 | ||
| 1 | 0.0 | Label 1 | T | -1 | 461, 301 | ||
| 1 | 0.0 | Label 33 | T | -1 | 121, 301 | ||
| 1 | 0.0 | Label 38 | T | -1 | 121, 349 | ||
| 1 | 0.0 | Work 2 | I | 0 | 21, 73 | $DEFAULT 'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 |
|
| 1 | 0.0 | Work 3 | I | 0 | 101, 73 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | Work 4 | I | 0 | 41, 73 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN A:ADD;"2";W\ZEROFILL;W\ZEROFILL 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET |
|
| 1 | 0.0 | Work 5 | I | 0 | 81, 73 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | Work 6 | I | 0 | 61, 73 | $DEFAULT A:ORGS;;I\ORGS F:AGENT_MAST;;;I\TMP_OWN_POOL=AM_OWN_PALL_POOL;AM_MARKET = '$I\MARKET$' AND AM_CODE='$I\ORGS$' 'U:ALLOC_PALL_TO_CONS;AGN_POOL_CHECK I:I\TMP_ALLOWED;=;N DO(LSW) O:HIDEUPDATE O:DISABLEINPUT;I\PALL_CODE,I\QTY_ALLOC,I\SD_CONSIGN DOEND(LSW) I:I\TMP_ALLOWED;<>;N DO(LSW) O:S |
|
| 1 | 0.0 | Work 7 | I | 0 | 41, 577 | ||
| 1 | 0.0 | Work 8 | I | 0 | 101, 577 | ||
| 1 | 0.0 | Label 9 | T | 0 | 1, 577 | ||
| 1 | 0.0 | Work 10 | I | 0 | 81, 577 | ||
| 1 | 0.0 | Work 11 | I | 0 | 61, 577 | ||
| 1 | 0.0 | Work 12 | I | 0 | 121, 577 | ||
| 1 | 0.0 | Work 13 | I | 0 | 141, 577 | ||
| 1 | 0.0 | Work 14 | I | 0 | 101, 553 | ||
| 1 | 0.0 | Work 15 | I | 0 | 81, 553 | ||
| 1 | 0.0 | Work 16 | I | 0 | 61, 553 | ||
| 1 | 0.0 | Work 17 | I | 0 | 41, 553 | ||
| 1 | 0.0 | Label 18 | T | 0 | 1, 553 | ||
| 1 | 0.0 | Work 19 | I | 0 | 141, 553 | ||
| 1 | 0.0 | Work 20 | I | 0 | 121, 553 | ||
| 1 | 0.0 | Work 21 | I | 0 | 161, 553 | ||
| 1 | 0.0 | Work 22 | I | 0 | 181, 553 | ||
| 1 | 0.0 | Work 23 | I | 0 | 161, 577 | ||
| 1 | 0.0 | Work 1 | I | 0 | 701, 529 | $BEFORE_WRITE U:ALLOC_PALL_TO_CONS;UPDATE_TABLES |
|
| 1 | 0.0 | Work 1 | I | 0 | 211, 553 | ||
| 1 | 1.0 | Work 26 | I | -1 | 271, 301 | $SELECT 'S:PALLET_CODE;I\PALL_CODE LP10022010 ON CHRISTO'S REQUEST S:PALL_POOL2;I\PALL_CODE;I\MARKET;I\ORGS;I\SECTION;I\ORGS $CALCULATE M: C:UCASE F:PALL_MAST;Y;;I\PALL_DESC=PM_DESC;PM_PALL='$I\PALL_CODE$';I\PALL_CODE I:I\TMP_OWN_POOL;=;1 U:ALLOC_PALL_TO_CONS;AGENT_PALLS_AVAILABLE I:I\TMP_OWN_POOL;<>;1 U |
|
| 1 | 1.0 | Work 29 | I | -1 | 271, 349 | $CALCULATE M: I:I\QTY_ALLOC;>;I\QTY_AVAIL D:NOT ENOUGH PALLETS AVAILABLE;ERRORM;I\QTY_ALLOC |
|
| 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 | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 |