Program drill-down
RETAILERS_CAPTURE
CAPTURE RETAILER. Type DSP, base table FM_PED_MAST.
Field inventory
106
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 5 | C | 0 | 231, 481 | $SELECT I:I\TRNTYPE;<>; DO(CHK) A:CRLF;I\TMP;I\TMP 'A:CON;I\TMP;I\DONT_EXIST;I\TRANS 'U:DELETE_MV;DELETE_DESC;I\TRNTYPE,I\TRANS U:DELETE_MV;DELETE;I\TRNTYPE,I\TRANS DOEND(CHK) A:CONST;;I\TRNTYPE O:SETFOCUS;C\DEL;I\TRNTYPE |
|
| 1 | 0.0 | CMD 4 | C | 0 | 241, 445 | $SELECT S:AVAIL_TABLES;I\TRNTYPE |
|
| 1 | 0.0 | CMD 1 | C | -1 | 231, 85 | $SELECT S:PERMIT_HOLDERS;I\PERMITNO |
|
| 1 | 0.0 | CMD 1 | C | 0 | 651, 576 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 651, 548 | $SELECT U:PED_MAN;CAPTURE_PED;G\GRID,I\TRANS U:PED_MAN;ALLOCATE_TABLES;I\TRANS U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL A:CONST;1;I\TBL1 A:CONST;0;I\TBL_COUNT A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQT |
|
| 1 | 0.0 | Work 5 | I | -1 | 641, 229 | $SELECT S:PED_NUMBERS;I\PED_NO $VALIDATE I:I\PED_NO;<>; DO(1) F:FM_PED_MAST;Y;;;FM_PED_NUMBER='$I\PED_NO$';I\PED_NO O:SETFOCUS;W\DEL DOEND(1) |
|
| 1 | 0.0 | Work 64 | G | -1 | 11, 253 | ||
| 1 | 0.0 | H | -1 | 1, 61 | |||
| 1 | 0.0 | I | -1 | 11, 229 | $CALCULATE I:I\SEQ;=; DO(001) A:CONST;;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL O:DISABLEINPUT;G\GRID,I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL U:PED_MAN;SUM_QTY;G\GRID,I\RECQTY A:CONST;$I\TOT_REC$;I\QTY_TOT |
||
| 1 | 0.0 | TMP16 | I | 0 | 51, 541 | ||
| 1 | 0.0 | ORGS | I | 0 | 21, 49 | ||
| 1 | 0.0 | PROHIBIT_SALES | I | 0 | 101, 49 | ||
| 1 | 0.0 | TMP1 | I | 0 | 31, 541 | ||
| 1 | 0.0 | I | -1 | 131, 157 | $ESC U:PED_MAN;RESERT_PED U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL,I\PED_FROM A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQTY,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY A:C |
||
| 1 | 0.0 | STK_MAST | SM_MARKET | I | 0 | 1, 49 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\SM_MARKET A:ORGS;;I\ORGS A:PARM;1;I\SCREEN_TYPE I:I\SCREEN_TYPE;=;TM A:CONST;UNALLOCATED STOCK ALLOCATION;T\HEADER I:I\SCREEN_TYPE;=;CS A:CONST;PED CONFIRMATION;T\HEADER1 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN 'CHANGING |
| 1 | 0.0 | DEFAULT | I | 0 | 41, 49 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 A:USERIP;;I\IP A:USERID;;I\USER 'INITIALIZE CONSIGNMENT GRID U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$ |
|
| 1 | 0.0 | I | 0 | 621, 493 | |||
| 1 | 0.0 | Work 6 | I | 0 | 331, 541 | ||
| 1 | 0.0 | Work 7 | I | 0 | 301, 541 | ||
| 1 | 0.0 | Work 8 | I | 0 | 271, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 421, 541 | ||
| 1 | 0.0 | Work 4 | I | 0 | 11, 517 | ||
| 1 | 0.0 | Work 5 | I | -1 | 51, 229 | $SELECT S:FM_PRODUCTS;I\ITEM $CALCULATE M: C:UCASE F:FM_PRODUCT_MAST;Y;;I\ITEM_DESC=FM_ITEM_DESC;FM_NDA_ITEM='$I\ITEM$';I\ITEM |
|
| 1 | 0.0 | Work 6 | I | -1 | 251, 229 | $SELECT S:FM_CONTAINERS;I\CONT $CALCULATE M: C:UCASE 'LOOKUP FOR AN EXISTING CONTAINER, IF NOT FOUND DISPLAY ERROR MESSAGE AND IF BLOCKED DISPLAY ERROR MESSAGE I:I\CONT;<>; F:FM_CONT;Y;;I\CONT_DESC=FM_CONT_DESC;FM_CONTAINER = '$I\CONT$';I\CONT F:FM_COMMODITY;;;I\CONT_MASS=FM_CONT_MASS;FM_ITEM='$I\ITEM$' AND |
|
| 1 | 0.0 | Work 2 | I | 0 | 241, 541 | ||
| 1 | 0.0 | Work 4 | I | -1 | 131, 121 | $SELECT S:PED_NUMBERS;I\PED $VALIDATE A:CONST;;I\SEQ I:I\SCREEN_TYPE;=;CS U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM_DESC,I\ITEM:H,I\CONT_DESC,I\CONT:H,I\CONT_MASS,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY:H,I\ALLOCQTY:H I:I\SCREEN_TYPE;=;TM U:ZZGRID_SPLIT;INIT_GRI |
|
| 1 | 0.0 | Work 1 | I | 0 | 621, 517 | ||
| 1 | 0.0 | Work 2 | I | 0 | 621, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 211, 541 | ||
| 1 | 0.0 | TMP3 | I | 0 | 11, 541 | ||
| 1 | 0.0 | Work 2 | I | 0 | 81, 49 | ||
| 1 | 0.0 | IP | I | 0 | 61, 49 | ||
| 1 | 0.0 | Work 2 | I | -1 | 91, 229 | ||
| 1 | 0.0 | TMP2 | I | 0 | 71, 541 | ||
| 1 | 0.0 | I | -1 | 131, 85 | $SELECT S:PERMIT_HOLDERS;I\PERMITNO $VALIDATE A:CONST;;W\DELDATE,W\DELTIME,T\DELDATE U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL F:FM_PERMIT_HOLDERS;Y;;I\PERMITNO=FM_PERMITNO,I\FM_SUPPL=FM_SUPPL,T\FM_SUPPL_NAME=FM_SUPPL_NAME,I\FM_TRADER_ |
||
| 1 | 0.0 | Work 9 | I | 0 | 361, 541 | ||
| 1 | 0.0 | Work 11 | I | 0 | 501, 481 | ||
| 1 | 0.0 | I | -1 | 291, 229 | |||
| 1 | 0.0 | I | -1 | 541, 229 | $VALIDATE A:CONST;N;W\DEL 'CHECK CONSIGNMENT QTY I:I\RECQTY;<=;0;NUM D:DELIVERY QTY CANNOT BE LESS OR EQUAL TO ZERO;ERRORM;I\RECQTY |
||
| 1 | 0.0 | Work 3 | I | 0 | 21, 517 | ||
| 1 | 0.0 | Label 8 | T | -1 | 741, 205 | ||
| 1 | 0.0 | Work 1 | I | 0 | 621, 517 | $CALCULATE A:CONST;;I\TMP2 C:UCASE I:I\CONFQTY;<>;I\ALLOCQTY U:PED_MAN;CONRFIM_QTY;G\GRID I:I\TMP2;=;STOP D:VERIFY QTY;ERRORM;I\CONFQTY A:SUB;I\RECQTY;W\QTY_AVAIL;I\UNALLOCQTY A:MULT;I\CONFQTY;I\MASS;I\CONT_MASS;;#0.00 I:I\FM_TRADER_TYPE;IN;03,04 DO(9) A:MULT;I\CONFQTY;I\TOT_VAL;I |
|
| 1 | 0.0 | Work 17 | I | 0 | 101, 517 | ||
| 1 | 0.0 | Work 12 | I | 0 | 501, 409 | ||
| 1 | 0.0 | Work 15 | I | 0 | 191, 409 | ||
| 1 | 0.0 | Work 13 | I | 0 | 191, 445 | $SELECT S:AVAIL_TABLES;I\TRNTYPE $CALCULATE 'CONVERT TO UPPERCASE C:UCASE I:I\TRNTYPE;<>; F:FM_TABLES;;;W\TABLENO=FM_TABLENO,W\PEDNO=FM_PEDNO;FM_TABLENO='$I\TRNTYPE$';I\TRNTYPE I:W\TABLENO;=; D:TABLE NUMBER $I\TRNTYPE$ DOES NOT EXIST;ERRORM;I\TRNTYPE I:W\PEDNO;<>; D:TABLE ALREADY ALLOCATED TO PED NUMB |
|
| 1 | 0.0 | Work 3 | I | -1 | 491, 229 | ||
| 1 | 0.0 | Work 2 | I | 0 | 161, 517 | ||
| 1 | 0.0 | Work 2 | I | 0 | 451, 541 | ||
| 1 | 0.0 | Work 18 | I | 0 | 131, 517 | ||
| 1 | 0.0 | Work 13 | I | 0 | 41, 517 | ||
| 1 | 0.0 | Work 14 | I | 0 | 71, 517 | ||
| 1 | 0.0 | Work 3 | I | 0 | 281, 445 | ||
| 1 | 0.0 | Work 1 | I | 0 | 511, 541 | ||
| 1 | 0.0 | Work 2 | I | 0 | 481, 541 | ||
| 1 | 0.0 | Work 5 | I | 0 | 131, 49 | ||
| 1 | 0.0 | STK_MAST | SM_SUPP | T | 0 | 621, 493 | |
| 1 | 0.0 | Label 1 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 10 | T | 0 | 391, 481 | ||
| 1 | 0.0 | CONS | T | -1 | 541, 205 | ||
| 1 | 0.0 | T | -1 | 291, 205 | |||
| 1 | 0.0 | Label 1 | T | -1 | 101, 205 | ||
| 1 | 0.0 | Label 16 | T | 0 | 21, 409 | ||
| 1 | 0.0 | Label 11 | T | 0 | 21, 445 | ||
| 1 | 0.0 | Label 12 | T | 0 | 391, 409 | ||
| 1 | 0.0 | Label 1 | T | -1 | 21, 121 | ||
| 1 | 0.0 | Label 2 | T | -1 | 491, 205 | ||
| 1 | 0.0 | SD_SEQ | T | -1 | 11, 205 | ||
| 1 | 0.0 | T | -1 | 271, 157 | |||
| 1 | 0.0 | STK_MAST | SM_VREGNO | T | -1 | 21, 157 | |
| 1 | 0.0 | Label 19 | T | -1 | 271, 85 | ||
| 1 | 0.0 | Label 3 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | STK_MAST | SM_DELNO | T | -1 | 21, 85 | |
| 1 | 0.0 | Label 6 | T | -1 | 291, 49 | ||
| 1 | 0.0 | Work 7 | I | -1 | 741, 229 | $VALIDATE C:UCASE V:Y;N $CALCULATE C:UCASE I:I\SEQ;=;+ U:PED_MAN;LINE_NO;G\GRID 'SAVE SCREEN FIELDS VALUES TO GRID U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ 'CLEAR FIELDS A:CONST;;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL O:DISBABLEINPUT;G\GRID,I\ITEM,I\IT |
|
| 1 | 0.0 | Work 4 | I | 0 | 621, 493 | ||
| 1 | 0.0 | Work 5 | I | 0 | 621, 517 | ||
| 1 | 0.0 | Label 6 | T | 0 | 621, 409 | ||
| 1 | 0.0 | Work 3 | I | 0 | 621, 385 | ||
| 1 | 0.0 | Work 2 | I | 0 | 371, 109 | $SELECT S:AGENT_CODE;I\PED_AGENT $ESC U:PED_MAN;RESERT_PED U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL $VALIDATE 'M: I:I\PED_AGENT;<>; DO(TEST) F:AGENT_MAST;Y;;;AM_CODE='$I\PED_AGENT$';I\PED_AGENT I:I\PED_AGENT;=;X D:PLEA |
|
| 1 | 0.0 | Label 3 | T | 0 | 291, 109 | ||
| 1 | 0.0 | Label 1 | T | -1 | 51, 205 | ||
| 1 | 0.0 | Label 2 | T | -1 | 251, 205 | ||
| 1 | 0.0 | Label 2 | T | 0 | 521, 109 | ||
| 1 | 0.0 | Work 3 | I | 0 | 581, 109 | $VALIDATE 'M: I:I\PED_FROM;<>; DO(TEST) F:FM_PED_MAST;Y;;;FM_PED_NUMBER='$I\PED_FROM$' AND FM_PED_CONFIRMED = 'Y';I\PED_FROM I:I\PED_FROM;=;X D:PLEASE ENTER AN AGENT CODE OR A PED NUMBER;ERRORM;I\PED_FROM U:DELETE_MV;DUPLICATES;I\PED_FROM,I\PED_LIST,I\TMP10 I:I\TMP10;=;N D:THAT VALUE ALREADY |
|
| 1 | 0.0 | Work 4 | I | 0 | 461, 109 | ||
| 1 | 0.0 | Work 4 | I | 0 | 541, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 681, 109 | ||
| 1 | 0.0 | Work 2 | I | 0 | 711, 169 | ||
| 1 | 0.0 | Label 2 | T | -1 | 641, 205 | ||
| 1 | 0.0 | Work 3 | I | -1 | 601, 229 | $SELECT S:AGENT_CODE;I\AGN $VALIDATE I:I\AGN;<>; F:AGENT_MAST;Y;;;AM_CODE='$I\AGN$';I\AGN $ESP O:HIDE;I\PED_NO,T\PED_NO O:SHOW;I\AGN O:SETFOCUS;I\AGN |
|
| 1 | 0.0 | Work 4 | I | -1 | 131, 121 | $SELECT S:PED_NUMBERS;I\PED $VALIDATE A:CONST;;I\SEQ I:I\SCREEN_TYPE;=;CS U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM_DESC,I\ITEM:H,I\CONT_DESC,I\CONT:H,I\CONT_MASS,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY:H,I\ALLOCQTY:H I:I\SCREEN_TYPE;=;TM U:ZZGRID_SPLIT;INIT_GRI |
|
| 1 | 0.0 | Work 1 | I | 0 | 681, 169 | ||
| 1 | 0.0 | CMD 1 | C | 0 | 421, 109 | ||
| 1 | 0.0 | Label 1 | T | -1 | 601, 205 | ||
| 1 | 2.0 | NO_OF_LINES | I | 0 | 391, 541 | '$VALIDATE 'I:I\NO_OF_LINES;=; 'A:CONST;0;I\NO_OF_LINES 'I:I\NO_OF_LINES;<>;I\NO_LINES 'D:NUMBER OF LINES MUST BE EQUAL TO THE NUMBER OF ROWS IN THE GRID;ERRORM;I\NO_OF_LINES '$VALIDATE ''FOR PRE CHANGE 28062013 I:I\NO_LINES;=; ''D:ERROR - NO RECORDS IN THE GRID TO PROCESS;ERRORM;I\SD_SEQ |
|
| 1 | 2.0 | Label 67 | T | 0 | 91, 541 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 61 | $ESC U:PED_MAN;RESERT_PED U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL,I\PED_FROM A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQTY,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY A:C |
|
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 61 |