Program drill-down
LOCK_RELEASE_MAN
RELEASE LOCKED CONSIGNMENTS. Type DSP, base table STK_DETS.
Field inventory
29
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | STK_DETS | SD_MARKET | I | 0 | 41, 49 | $DEFAULT 'GET USERS MARKET CODE - ZU_MARKET IN ZU_USER A:ORG 'GET MARKET NAME FROM CLIENT MASTER F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\SD_MARKET$' 'CONVERT TO FIRST CHARACTER UPPER CASE REST LOWER CASE C:MCASE;;T\MARKET |
| 1 | 0.0 | STK_DETS | SD_AGENT | I | -1 | 271, 121 | $DEFAULT A:ORGS;;I\SD_AGENT I:I\SD_AGENT;<>; O:DISABLEINPUT;I\SD_AGENT $SELECT S:AGENT_MAST_MKT;I\SD_AGENT;I\SD_MARKET $VALIDATE C:UCASE 'LOAD OPTIONS FROM AGENT_MAST F:AGENT_MAST;Y;;T\AGENT_DESC=AM_NAME;AM_CODE='$I\SD_AGENT$' AND AM_MARKET='$I\SD_MARKET$';I\SM_AGENT A:LEFT;T\AGENT_DESC,30;T\AGENT_DESC |
| 1 | 0.0 | STK_DETS | SD_AGENT | T | -1 | 141, 121 | |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | I | -1 | 271, 169 | $SELECT S:CONS_AGENT_A;I\SD_CONSIGN;I\SD_AGENT $VALIDATE 'ZERO FILL THIS FIELD TO DELIVERY LENGTH + 2 F:AGENT_MAST;;;I\AM_DEL_LEN=AM_DEL_LEN;AM_MARKET='$I\SD_MARKET$' AND AM_CODE='$I\SD_AGENT$' A:ADD;I\AM_DEL_LEN,"2";I\AM_DEL_LEN A:ZEROFILL;I\SD_CONSIGN,I\AM_DEL_LEN;I\SD_CONSIGN F:STK_DETS;Y;SD_CONSIGN;I\S |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | T | -1 | 141, 169 | |
| 1 | 0.0 | STK_DETS | SD_DATE | I | -1 | 271, 205 | |
| 1 | 0.0 | STK_DETS | SD_DATE | T | -1 | 141, 205 | |
| 1 | 0.0 | STK_DETS | SD_ACTIVE | I | -1 | 271, 265 | |
| 1 | 0.0 | STK_DETS | SD_ACTIVE | T | -1 | 141, 265 | |
| 1 | 0.0 | Label 8 | T | -1 | 271, 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 | DEFAULT | I | 0 | 1, 49 | $DEFAULT A:DATE;DD MMM/YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 |
|
| 1 | 0.0 | AGENT_DESC | T | -1 | 361, 121 | ||
| 1 | 0.0 | SD_AGENT | C | -1 | 321, 121 | $SELECT S:AGENT_MAST_MKT;I\SD_AGENT;I\SD_MARKET |
|
| 1 | 0.0 | SD_CONSIGN | C | -1 | 351, 169 | $SELECT S:CONS_AGENT_A;I\SD_CONSIGN;I\SD_AGENT |
|
| 1 | 0.0 | RESET | C | -1 | 271, 313 | $SELECT A:VAR;I\SD_DATE;I\SD_DATE;;YYYY/MM/DD 'MAKE CONSIGNMENT AS ACTIVE A:CONST;N;I\TMP1 W:STK_DETS;;;SD_MARKET=I\SD_MARKET,SD_AGENT=I\SD_AGENT,SD_CONSIGN=I\SD_CONSIGN,SD_DATE=I\SD_DATE,SD_ACTIVE=I\TMP1;SD_MARKET='$I\SD_MARKET$' AND SD_AGENT='$I\SD_AGENT$' AND SD_CONSIGN='$I\SD_CONSIGN$' AND SD_DATE='$I\SD_DATE$' |
|
| 1 | 0.0 | TMP1 | I | 0 | 21, 385 | ||
| 1 | 0.0 | Work 1 | I | 0 | 381, 169 | ||
| 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 |