Program drill-down
STATS_ENQ_UPDSLS
UNPAID STATISTICS ENQUIRY. Type DSP, base table STK_DETS.
Field inventory
85
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 4 | T | 0 | 621, 97 | ||
| 1 | 0.0 | H | -1 | 0, 30 | |||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 321, 49 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | IP | I | 0 | 61, 61 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | AGENT | Work 9 | I | 0 | 41, 61 | $DEFAULT A:ORGS;;I\AGENT |
| 1 | 0.0 | MARKET | I | 0 | 21, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET |
|
| 1 | 0.0 | Work 11 | I | 0 | 1, 61 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 A:DATE;DD MMM YYYY;I\SDATE A:DATE;DD MMM YYYY;I\EDATE |
|
| 1 | 0.0 | Label 12 | T | 0 | 1, 133 | ||
| 1 | 0.0 | Label 13 | T | 0 | 1, 109 | ||
| 1 | 0.0 | Label 14 | T | -1 | 241, 109 | ||
| 1 | 0.0 | CMD 15 | C | -1 | 451, 109 | $SELECT S:ITEM_NEW;I\ITEM |
|
| 1 | 0.0 | USERID | I | 0 | 81, 61 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | Work 17 | I | 0 | 111, 133 | '$VALIDATE 'A:CONST;;T\PROG 'I:I\SDATE;=; 'A:CONST;$T\DATE$;I\SDATE |
|
| 1 | 0.0 | Work 18 | I | 0 | 111, 109 | '$VALIDATE 'I:I\EDATE;=; 'A:CONST;$T\DATE$;I\EDATE 'A:CONST;COLLECTING DATA...;T\PROG 'U:STATISTICS 'O:SETFOCUS;I\ITEM 'A:CONST;DATA COLLECTION COMPLETE;T\PROG |
|
| 1 | 0.0 | Work 19 | I | -1 | 351, 109 | $SELECT S:ITEM_NEW;I\ITEM $VALIDATE A:CONST;;I\LPRICE,I\HPRICE,I\AVPRICE,I\QTY,I\MASS,I\VALUE,T\DESC,I\GRADE,I\CONT,I\COUNT,I\PROV,I\COLOUR,T\PROV_DESC,T\COLOR_DESC A:CONST;;I\LPRICE_WK,I\HPRICE_WK,I\AVPRICE_WK,I\QTY_WK,I\MASS_WK,I\VALUE_WK A:CONST;;I\LPRICE_MTH,I\HPRICE_MTH,I\AVPRICE_MTH,I\QTY_MTH,I\MASS_MTH,I\ |
|
| 1 | 0.0 | CMD 20 | C | 0 | 601, 505 | '$SELECT 'I:I\SDATE;=; 'D:PLEASE ENTER A STARTING DATE;ERRORM;I\SDATE 'I:I\EDATE;=; 'D:PLEASE ENTER AN ENDING DATE;ERRORM;I\EDATE 'A:CONST;COLLECTING DATA...;T\PROG 'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=DAILY_STATS_BY_PROV;$I\MARKET$,$I\SDATE$,$I\EDATE$,$I\ITEM$,S 'A:CONST;DATA COLLECTION COMP |
|
| 1 | 0.0 | Label 1 | T | 0 | 291, 481 | ||
| 1 | 0.0 | Label 7 | T | -1 | 241, 205 | ||
| 1 | 0.0 | Work 5 | I | -1 | 351, 133 | $SELECT S:GRADE_ITEM2;I\GRADE;I\ITEM A:SELPARM;1;I\TMP1 A:SELPARM;2;I\GRADE A:CONST;$I\GRADE$;I\TPM2 A:CONST;$I\TMP1$$I\GRADE$;I\GRADE $VALIDATE A:CONST;;I\TMP1,I\TMP2,I\TMP3 C:UCASE I:I\GRADE;<>; DO(GRD) A:LEN;I\GRADE;I\LEN I:I\LEN;<>;1 DO(GRADE) A:LEFT;I\GRADE,1;I\TMP1 A:RIGHT;I\GRA |
|
| 1 | 0.0 | Work 6 | I | -1 | 351, 157 | $SELECT S:CONT_PR_NODEL;I\CONT;I\PROD;I\VAR;I\TMP1;I\TMP2 $VALIDATE C:UCASE I:I\CONT;<>; F:CONT_MAST;Y;;;CN_PRODUCT='$I\PROD$' AND CN_VAR='$I\VAR$' AND CN_CONT='$I\CONT$';I\CONT |
|
| 1 | 0.0 | Label 3 | T | -1 | 241, 157 | ||
| 1 | 0.0 | Label 4 | T | -1 | 241, 133 | ||
| 1 | 0.0 | Label 1 | T | -1 | 241, 181 | ||
| 1 | 0.0 | Work 2 | I | -1 | 351, 181 | $SELECT S:COUNT_MAST_CNT;I\COUNT;I\PROD;I\GRADE;I\CONT $VALIDATE C:UCASE I:I\COUNT;<>; F:COUNT_MAST;Y;;;CNT_PRODUCT='$I\PROD$' AND CNT_GRADE = '$I\GRADE$' AND CNT_CONTAINER='$I\CONT$' AND CNT_COUNT = '$I\COUNT$';I\COUNT |
|
| 1 | 0.0 | Work 8 | I | -1 | 351, 205 | $SELECT S:PROVINCE;I\PROV $VALIDATE C:UCASE I:I\PROV;<>; F:PROV_MAST;Y;;T\PROV_DESC=PR_DESC;PR_PROV='$I\PROV$' AND PR_BLOCKED <> 'Y';I\PROV |
|
| 1 | 0.0 | Label 9 | T | -1 | 241, 229 | ||
| 1 | 0.0 | Work 10 | I | -1 | 351, 229 | $SELECT S:COLOUR_ITEM;I\COLOUR $VALIDATE C:UCASE I:I\COLOUR;<>; DO(01) F:COLOUR_MAST;Y;;T\COLOR_DESC=CLR_DESC;CLR_COLOUR='$I\COLOUR$' AND (CLR_BLOCKED <> 'Y' OR ISNULL(CLR_BLOCKED));I\COLOUR DOEND(01) A:CONST;COLLECTING DATA...;T\PROG U:STATISTICS_UNPAID_SALES O:SETFOCUS;I\ITEM 'A |
|
| 1 | 0.0 | CMD 11 | C | -1 | 451, 133 | $SELECT S:GRADE_ITEM2;I\GRADE;I\ITEM A:SELPARM;1;I\TMP1 A:SELPARM;2;I\GRADE A:CONST;$I\GRADE$;I\TPM2 A:CONST;$I\TMP1$$I\GRADE$;I\GRADE |
|
| 1 | 0.0 | CMD 12 | C | -1 | 451, 157 | $SELECT S:CONT_PR_NODEL;I\CONT;I\PROD;I\VAR;I\TMP1;I\TMP2 |
|
| 1 | 0.0 | CMD 13 | C | -1 | 451, 181 | $SELECT S:COUNT_MAST_CNT;I\COUNT;I\PROD;I\GRADE;I\CONT |
|
| 1 | 0.0 | CMD 14 | C | -1 | 451, 205 | $SELECT S:PROVINCE;I\PROV |
|
| 1 | 0.0 | CMD 15 | C | -1 | 451, 229 | $SELECT S:COLOUR_ITEM;I\COLOUR |
|
| 1 | 0.0 | Work 19 | I | -1 | 371, 397 | ||
| 1 | 0.0 | Work 20 | I | -1 | 371, 421 | ||
| 1 | 0.0 | Work 21 | I | -1 | 371, 445 | ||
| 1 | 0.0 | Work 18 | I | -1 | 371, 373 | ||
| 1 | 0.0 | Label 22 | T | -1 | 211, 445 | ||
| 1 | 0.0 | Work 17 | I | -1 | 371, 349 | ||
| 1 | 0.0 | Work 16 | I | -1 | 371, 325 | ||
| 1 | 0.0 | Label 23 | T | -1 | 211, 421 | ||
| 1 | 0.0 | Label 24 | T | -1 | 211, 397 | ||
| 1 | 0.0 | Label 25 | T | -1 | 211, 373 | ||
| 1 | 0.0 | Label 26 | T | -1 | 211, 349 | ||
| 1 | 0.0 | Label 27 | T | -1 | 211, 325 | ||
| 1 | 0.0 | Work 3 | I | 0 | 651, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 611, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 571, 529 | ||
| 1 | 0.0 | Work 4 | I | 0 | 541, 529 | ||
| 1 | 0.0 | Label 5 | T | -1 | 481, 109 | ||
| 1 | 0.0 | Work 6 | I | 0 | 491, 529 | ||
| 1 | 0.0 | Work 7 | I | 0 | 451, 529 | ||
| 1 | 0.0 | Label 8 | T | -1 | 481, 205 | ||
| 1 | 0.0 | Label 9 | T | -1 | 481, 229 | ||
| 1 | 0.0 | Work 5 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Work 6 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Work 7 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Work 8 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Work 9 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Work 10 | I | 0 | 621, 181 | ||
| 1 | 0.0 | Label 1 | T | -1 | 361, 289 | ||
| 1 | 0.0 | Label 2 | T | 0 | 621, 181 | ||
| 1 | 0.0 | Label 3 | T | 0 | 621, 145 | ||
| 1 | 0.0 | Work 11 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 12 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 13 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 14 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 15 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 16 | I | 0 | 621, 145 | ||
| 1 | 0.0 | Work 17 | I | 0 | 621, 97 | ||
| 1 | 0.0 | Work 18 | I | 0 | 621, 97 | ||
| 1 | 0.0 | Work 19 | I | 0 | 621, 97 | ||
| 1 | 0.0 | Work 20 | I | 0 | 621, 97 | ||
| 1 | 0.0 | Work 21 | I | 0 | 621, 97 | ||
| 1 | 0.0 | Work 22 | I | 0 | 621, 97 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 30 |