Program drill-down
DAILY_STATS_BY_ALL
DAILY STATS BY ALL. Type DSP, base table STK_DETS.
Field inventory
49
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 30 | |||
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 261, 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 | -1 | 201, 121 | ||
| 1 | 0.0 | Label 13 | T | -1 | 201, 157 | ||
| 1 | 0.0 | Label 14 | T | -1 | 201, 193 | ||
| 1 | 0.0 | CMD 15 | C | -1 | 471, 193 | $SELECT S:COMM_LIST;I\PROD |
|
| 1 | 0.0 | USERID | I | 0 | 81, 61 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | Work 17 | I | -1 | 361, 121 | $CALCULATE A:CONST;;T\PROG I:I\SDATE;=; A:DATE;DD MMM YYYY;I\SDATE A:DATE;DD MMM YYYY;I\EDATE |
|
| 1 | 0.0 | Work 18 | I | -1 | 361, 157 | $CALCULATE I:I\EDATE;=; A:CONST;$T\DATE$;I\EDATE |
|
| 1 | 0.0 | Work 19 | I | -1 | 361, 193 | $SELECT S:COMM_LIST;I\PROD $CALCULATE A:CONST;;W\VARIETY,W\ITEM C:UCASE I:I\PROD;<>; DO(OPA) F:PRODUCT_MAST;Y;;;PR_PRODUCT = '$I\PROD$';I\PROD DOEND(OPA) |
|
| 1 | 0.0 | CMD 20 | C | -1 | 371, 481 | $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 C:UCASE A:CONST;;W\VARIETY,W\ITEM C:UCASE I:I\PROD;<>; DO(OPA) F:PRODUCT_MAST;Y;;;PR_PRODUCT = '$I\PROD$';I\PROD DOEND(OPA) I:I\PROD;=; DO(1) I:I\VARIETY;<>; D:ENTER PRODU |
|
| 1 | 0.0 | Work 5 | I | 0 | 651, 529 | ||
| 1 | 0.0 | Label 1 | T | -1 | 201, 445 | ||
| 1 | 0.0 | Check 2 | K | -1 | 361, 445 | $CALCULATE O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Work 1 | I | 0 | 61, 145 | ||
| 1 | 0.0 | Work 2 | I | 0 | 1, 121 | ||
| 1 | 0.0 | Label 1 | T | -1 | 321, 505 | ||
| 1 | 0.0 | Work 13 | I | -1 | 361, 229 | $SELECT S:VARIETY;I\VARIETY;I\PROD $VALIDATE C:UCASE;I\VARIETY I:I\PROD;=; DO(1) I:I\VARIETY;<>; D:ENTER PRODUCT;ERRORM;I\PROD DOEND(1) I:I\VARIETY;<>; DO(2) I:I\PROD;<>; F:VAR_MAST;;;W\VARIETY=VA_VARIETY;VA_PRODUCT='$I\PROD$' AND VA_VARIETY ='$I\VARIETY$' I:W\VARIETY;=; D:VARIETY '$I\VARIETY$' DOES N |
|
| 1 | 0.0 | Work 14 | I | -1 | 361, 265 | $SELECT S:CONT_MAST;I\CONTAINER;I\PROD $VALIDATE C:UCASE;I\CONTAINER I:I\CONTAINER;<>; DO(PRD) I:I\PROD;=; F:CONT_MAST;Y;;;CN_CONT='$I\CONTAINER$';I\CONTAINER I:I\PROD;<>; DO(PRD1) F:CONT_MAST;;;W\CONT=CN_CONT;CN_PRODUCT='$I\PROD$' AND CN_CONT ='$I\CONTAINER$' I:W\CONT;=; D:CONTAINER '$I\CONT |
|
| 1 | 0.0 | Label 12 | T | -1 | 201, 409 | ||
| 1 | 0.0 | Label 7 | T | -1 | 201, 229 | ||
| 1 | 0.0 | Label 8 | T | -1 | 201, 265 | ||
| 1 | 0.0 | Label 9 | T | -1 | 201, 301 | ||
| 1 | 0.0 | Label 10 | T | -1 | 201, 337 | ||
| 1 | 0.0 | Label 11 | T | -1 | 201, 373 | ||
| 1 | 0.0 | Work 15 | I | -1 | 361, 301 | $CALCULATE C:UCASE I:I\PROVINCE;<>; DO(PRD1) I:I\PROD;=; F:PROV_MAST;Y;;;PR_PROV = '$I\PROVINCE$';I\PROVINCE DOEND(PRD1) |
|
| 1 | 0.0 | Work 16 | I | -1 | 361, 337 | $CALCULATE C:UCASE I:I\CLASS;<>; DO(OPA) F:COMMODITY_MAST;Y;;;CO_CLASS = '$I\CLASS$';I\CLASS DOEND(OPA) |
|
| 1 | 0.0 | Work 17 | I | -1 | 361, 373 | $CALCULATE C:UCASE I:I\SIZE;<>; DO(OPA) F:COMMODITY_MAST;Y;;;CO_SIZE = '$I\SIZE$';I\SIZE DOEND(OPA) A:CON;I\CLASS,I\SIZE;W\GRADE |
|
| 1 | 0.0 | Work 18 | I | -1 | 361, 409 | $VALIDATE I:I\COUNT;<>; F:COMMODITY_MAST;Y;;;CO_CLASS = '$I\CLASS$';I\CLASS DO(PRD) |
|
| 1 | 0.0 | Work 1 | I | 0 | 1, 97 | ||
| 1 | 0.0 | Work 1 | I | 0 | 61, 121 | ||
| 1 | 0.0 | Work 2 | I | 0 | 61, 97 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 471, 229 | $SELECT S:VARIETY;I\VARIETY;I\PROD |
|
| 1 | 0.0 | CMD 2 | C | -1 | 471, 265 | $SELECT S:CONT_MAST;I\CONTAINER;I\PROD |
|
| 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 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 30 |