Program drill-down
REGRADES_MAN
REGRADE CONSIGNMENT DELIVERIES. Type MAN, base table STK_MAST.
Field inventory
120
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 1 | T | 0 | 1, 541 | ||
| 1 | 0.0 | Work 5 | I | 0 | 611, 229 | ||
| 1 | 0.0 | Work 6 | I | 0 | 651, 229 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | STK_MAST | SM_WAYBILLNO | T | -1 | 351, 229 | |
| 1 | 0.0 | I | -1 | 111, 229 | |||
| 1 | 0.0 | Label 9 | T | -1 | 191, 169 | ||
| 1 | 0.0 | Label 10 | T | -1 | 191, 193 | ||
| 1 | 0.0 | I | -1 | 641, 145 | |||
| 1 | 0.0 | STK_MAST | SM_REFNO | T | -1 | 521, 145 | |
| 1 | 0.0 | Work 12 | G | -1 | 11, 349 | ||
| 1 | 0.0 | Label 16 | T | -1 | 91, 301 | ||
| 1 | 0.0 | I | -1 | 641, 193 | |||
| 1 | 0.0 | STK_MAST | SM_DELNO | T | -1 | 1, 109 | |
| 1 | 0.0 | I | -1 | 381, 109 | |||
| 1 | 0.0 | STK_MAST | SM_DTIME | T | -1 | 301, 109 | |
| 1 | 0.0 | I | -1 | 641, 109 | |||
| 1 | 0.0 | STK_MAST | SM_DDATE | T | -1 | 521, 109 | |
| 1 | 0.0 | STK_MAST | SM_MREFNO | T | -1 | 1, 229 | |
| 1 | 0.0 | Label 8 | T | -1 | 191, 145 | ||
| 1 | 0.0 | STK_MAST | SM_AREA | T | -1 | 521, 193 | |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | T | -1 | 11, 301 | |
| 1 | 0.0 | STK_DETS | SD_CONSIGN | I | -1 | 11, 325 | $SELECT S:G:G\GRID;I\SD_CONSIGN;R1 $CALCULATE C:UCASE F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$' A:ADD;"2";I\DEL_LEN;I\DEL_LEN A:ZEROFILL;I\SD_CONSIGN,I\DEL_LEN;I\SD_CONSIGN I:I\SD_CONSIGN;=; DO(SPO) '''A:CONST;;I\GRADE,I\SD_REGRDCD,I\SD_REGRDTE,I\ACTION,I\QTY_AVAIL '''O:DISABLEINPUT; |
| 1 | 0.0 | STK_MAST | SM_SUPP | T | -1 | 1, 145 | |
| 1 | 0.0 | I | -1 | 111, 169 | |||
| 1 | 0.0 | STK_MAST | SM_AGENT | T | -1 | 1, 169 | |
| 1 | 0.0 | I | -1 | 111, 193 | |||
| 1 | 0.0 | STK_MAST | SM_SMAN | T | -1 | 1, 193 | |
| 1 | 0.0 | STK_MAST | SM_DELNO | I | -1 | 111, 109 | $SELECT ''I:I\ORGS;=; ''S:DELIVERY_CONSIGN;I\SM_DELNO S:REGRADES;I\SM_DELNO 'JD 20081209 'I:I\ORGS;<>; 'S:DELIVERY_CONSIGN_AGN;I\SM_DELNO;I\ORGS $VALIDATE M: A:ZEROFILL;I\SM_DELNO,W\ZEROFILL,I\SM_DELNO I:I\ORGS;=; F:STK_MAST;Y;;I\SM_AGENT=SM_AGENT;SM_MARKET = '$I\MARKET$' AND SM_DELNO='$I\SM_DELN |
| 1 | 0.0 | STK_DETS | SD_ITEM | I | 0 | 601, 265 | |
| 1 | 0.0 | Work 3 | I | 0 | 41, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 81, 61 | ||
| 1 | 0.0 | I | -1 | 111, 145 | |||
| 1 | 0.0 | STK_MAST | SM_WAYBILLNO | I | -1 | 441, 229 | |
| 1 | 0.0 | STK_DETS | NOTHING | I | -1 | 91, 325 | |
| 1 | 0.0 | STK_DETS | SD_RECQTY | I | -1 | 211, 325 | |
| 1 | 0.0 | STK_DETS | SD_RECQTY | T | -1 | 211, 301 | |
| 1 | 0.0 | Label 19 | T | -1 | 271, 301 | ||
| 1 | 0.0 | Work 20 | I | -1 | 271, 325 | ||
| 1 | 0.0 | Label 21 | T | -1 | 371, 301 | ||
| 1 | 0.0 | Work100 | I | 0 | 391, 505 | $CALCULATE ^M: '''''''''$VALIDATE C:UCASE A:LEN;I\GRADE;I\TMP350 I:I\SD_CONSIGN;<>; DO(NDG) I:I\TMP350;<>;2;NUM D:GRADE MUST BE 2 CHARACTERS LONG;ERRORM;I\GRADE 'VALIDATION FOR THE CLASS - FIRST CHARACTER OF THIS FIELD - EXAMPLE THE 2 IN 2M I:I\GRADE;<>; DO(E2) A:VAR;I\GRADE;W\GRADE_TEMP |
|
| 1 | 0.0 | Work 2 | I | 0 | 751, 193 | ||
| 1 | 0.0 | Label 28 | T | -1 | 91, 277 | ||
| 1 | 0.0 | STK_DETS | SD_REGRDCD | T | -1 | 461, 301 | |
| 1 | 0.0 | STK_DETS | SD_REGRDTE | I | -1 | 641, 325 | $CALCULATE ^M: U:DATECHECKER;FUTURE;I\SD_REGRDTE |
| 1 | 0.0 | STK_DETS | SD_REGRDTE | T | -1 | 641, 301 | |
| 1 | 0.0 | Label 25 | T | -1 | 741, 301 | ||
| 1 | 0.0 | Work 26 | I | -1 | 741, 325 | $CALCULATE C:UCASE V:D; I:I\ACTION;=;D DO(81) I:I\TMP355;<>;Y D:MAY NOT DELETE A NEW ENTRY;ERRORM;I\ACTION U:REGRADES_ENTRY;DELETE_REGRADE A:VAR;I\OLD_CLASS;I\SD_CLASS A:VAR;I\OLD_SIZE;I\SD_SIZE DOEND(81) I:I\CDATE;<>; DO(D3M) A:VAR;T\DATE;I\TMP2;;YYYY/MM/DD A:VAR;I\CDATE;I\CDATE;;YYYY/MM/DD |
|
| 1 | 0.0 | Label 29 | T | -1 | 211, 277 | ||
| 1 | 0.0 | Label 30 | T | -1 | 271, 277 | ||
| 1 | 0.0 | Label 31 | T | -1 | 371, 277 | ||
| 1 | 0.0 | Label 32 | T | -1 | 461, 277 | ||
| 1 | 0.0 | Label 34 | T | -1 | 541, 301 | ||
| 1 | 0.0 | Work 35 | I | -1 | 541, 325 | ||
| 1 | 0.0 | Label 36 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 37 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 38 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 39 | T | -1 | 351, 49 | ||
| 1 | 0.0 | Label 40 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 41 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 42 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 43 | T | -1 | 1, 505 | ||
| 1 | 0.0 | Work 44 | I | -1 | 141, 505 | ||
| 1 | 0.0 | CMD 45 | C | -1 | 211, 109 | $SELECT 'I:I\ORGS;=; 'S:DELIVERY_CONSIGN;I\SM_DELNO 'I:I\ORGS;<>; 'S:DELIVERY_CONSIGN_AGN;I\SM_DELNO;I\ORGS S:REGRADES;I\SM_DELNO |
|
| 1 | 0.0 | Work 46 | I | 0 | 61, 541 | ||
| 1 | 0.0 | Work 47 | I | 0 | 51, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET A:ORGS;;I\ORGS 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;I\PROHIBIT_SALES=CM_PROHIBIT_SALES,T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN I:I\PROHIBIT_SALES;=;Y DO(LAM) O:DISABLEINPUT;I\SM_DELNO D:SALES ARE PROHIBITED, TRANSACTION CANNOT BE DONE;ERRORM;I\SM_DELNO DOE |
|
| 1 | 0.0 | Work 48 | I | 0 | 21, 61 | $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 ''U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\GRADE,I\COUNT,I\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\SD_CLASS:H,I\SD_SIZE:H,I\SD |
|
| 1 | 0.0 | Work 49 | I | 0 | 101, 541 | ||
| 1 | 0.0 | Work 50 | I | 0 | 81, 541 | ||
| 1 | 0.0 | Work 51 | I | 0 | 291, 505 | ||
| 1 | 0.0 | Work 52 | I | 0 | 321, 505 | ||
| 1 | 0.0 | Work 53 | I | 0 | 411, 577 | ||
| 1 | 0.0 | Work 55 | I | 0 | 201, 541 | ||
| 1 | 0.0 | Work 56 | I | 0 | 221, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 121, 565 | ||
| 1 | 0.0 | Work 2 | I | 0 | 101, 565 | ||
| 1 | 0.0 | Work 3 | I | 0 | 81, 565 | ||
| 1 | 0.0 | Work 4 | I | 0 | 141, 565 | ||
| 1 | 0.0 | Work 5 | I | 0 | 61, 565 | ||
| 1 | 0.0 | Work 6 | I | 0 | 41, 565 | ||
| 1 | 0.0 | Work 7 | I | 0 | 161, 565 | ||
| 1 | 0.0 | STK_DETS | SD_CLASS | I | -1 | 371, 325 | $SELECT S:CLASS_NB;I\SD_CLASS $CALCULATE C:UCASE I:I\SD_CLASS;=; D:ENTER A VALID CLASS;ERRORM;I\SD_CLASS I:I\SD_CLASS;<>; DO(VEV) F:COMMODITY_MAST;Y;;;CO_CLASS='$I\SD_CLASS$';I\SD_CLASS DOEND(VEV) |
| 1 | 0.0 | STK_DETS | SD_SIZE | I | -1 | 401, 325 | $SELECT S:SIZE_NB;I\SD_SIZE $CALCULATE C:UCASE I:I\SD_SIZE;=; 'D:ENTER A VALID SIZE;ERRORM;I\SD_SIZE 'VARIETY '$I\VARIETY$' DOES NOT EXIST FOR '$I\PROD$' PRODUCT;ERRORM;I\VARIETY I:I\SD_CLASS;<>; DO(SZ) I:I\SD_SIZE;<>; DO(GRD) F:COMMODITY_MAST;Y;;;CO_SIZE='$I\SD_SIZE$';I\SD_SIZE 'I:I\SD_SI |
| 1 | 0.0 | STK_DETS | SD_CONT | I | 0 | 631, 265 | |
| 1 | 0.0 | STK_DETS | SD_CONTMASS | I | 0 | 661, 265 | |
| 1 | 0.0 | Work 1 | I | 0 | 241, 541 | ||
| 1 | 0.0 | Work 2 | I | 0 | 551, 541 | ||
| 1 | 0.0 | Work 3 | I | 0 | 581, 541 | $BEFORE_WRITE '''A:CONST;;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\GRADE,I\COUNT,D\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\ACTION A:CONST;;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\SD_CLASS,I\SD_SIZE,I\COUNT,D\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\ACTION |
|
| 1 | 0.0 | Label 2 | T | 0 | 200, 385 | ||
| 1 | 0.0 | Work 1 | I | 0 | 481, 529 | ||
| 1 | 0.0 | STK_DETS | SD_PREVGRD | I | -1 | 321, 325 | |
| 1 | 0.0 | Work 4 | I | 0 | 181, 541 | ||
| 1 | 0.0 | Work 7 | I | 0 | 121, 541 | ||
| 1 | 0.0 | Label 2 | T | -1 | 321, 301 | ||
| 1 | 0.0 | T | -1 | 321, 277 | |||
| 1 | 0.0 | Label 2 | T | 0 | 1, 565 | ||
| 1 | 0.0 | Work 4 | I | 0 | 191, 61 | $DEFAULT A:USERID;;I\USERID A:USERIP;;I\IP |
|
| 1 | 0.0 | Work 5 | I | 0 | 221, 61 | ||
| 1 | 0.0 | Work 1 | I | 0 | 161, 541 | ||
| 1 | 0.0 | Work 2 | I | 0 | 141, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 181, 565 | ||
| 1 | 0.0 | Work 1 | I | 0 | 741, 265 | ||
| 1 | 0.0 | Work 2 | I | 0 | 761, 265 | ||
| 1 | 0.0 | ZERO FILL | I | 0 | 321, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 121, 253 | ||
| 1 | 0.0 | COMTST | I | 0 | 251, 349 | ||
| 1 | 0.0 | Label 2 | T | -1 | 431, 301 | ||
| 1 | 0.0 | STK_DETS | SD_COUNT | I | -1 | 431, 325 | $SELECT S:COUNT;I\COUNT;I\SD_PRODUCT;I\GRADE $CALCULATE I:I\CONTCHK;=;Y M: I:I\COUNT;<>; F:COUNT_MAST;Y;;;CNT_PRODUCT='$I\SD_PRODUCT$' AND CNT_GRADE='$I\GRADE$' AND CNT_COUNT='$I\COUNT$' AND CNT_CONTAINER = '$I\SD_CONT$';I\COUNT |
| 1 | 0.0 | CONTCHK | I | 0 | 401, 193 | ||
| 1 | 0.0 | STK_DETS | SD_REGRDCD | I | -1 | 461, 325 | $SELECT S:DEV_CODE;I\SD_REGRDCD $CALCULATE ^M: 'I:I\SD_CONSIGN;<>; I:I\SD_REGRDCD;<>; DO(NDF) C:UCASE F:DEVIATION_MAST;Y;AF_CODE;I\REAS=AF_DESC;AF_CODE='$I\SD_REGRDCD$';I\SD_REGRDCD DOEND(NDF) |
| 1 | 0.0 | CMD 2 | C | -1 | 511, 325 | $SELECT S:DEV_CODE;I\SD_REGRDCD |
|
| 1 | 0.0 | Work 4 | I | 0 | 381, 145 | ||
| 1 | 0.0 | CDATE | I | 0 | 11, 277 | ||
| 1 | 0.0 | Label 1 | T | 0 | 200, 355 | ||
| 1 | 0.0 | Work 3 | I | 0 | 261, 385 | ||
| 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 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 |