Program drill-down
STATS_REPORT
STATS REPORT. Type MAN, base table STK_TRANS.
Field inventory
31
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | DATETO | I | -1 | 391, 289 | $VALIDATE M: CUCASE |
|
| 1 | 0.0 | Work 3 | I | -1 | 391, 361 | $SELECT S:PROD_SECT_GROUPING;I\GROUPING $CALCULATE 'POPULATES THE GRID ACCORDING TO THE CODE ENTERED F:SECT_GROUP;;;I\SEC_DESC=SG_DESC;SG_CODE = '$I\GROUPING$' $VALIDATE 'MAKE THIS FIELD A MANDATORY FIELD 'M: C:UCASE I:I\GROUPING;<>;"" DO(S) O:SETFOCUS;I\GROUPING 'A:VAR;;I\GROUPING;; |
|
| 1 | 0.0 | Work 1 | I | -1 | 391, 325 | $SELECT S:ITEM_VARIETY;I\ITEM $VALIDATE 'UPPERCASE C:UCASE I:I\ITEM;<>;"" DO(SED) 'CHECK IF ITEM IS VALID F:PRODUCT_MAST;Y;;;PR_PRODUCT='$I\ITEM$' O:DISABLEINPUT;I\GROUPING U:REPORTS;STATS A:DATE;DD MMM YYYY;I\DATEFROM A:DATE;DD MMM YYYY;I\DATETO A:CONST;;I\ITEM A:CONST;;I\GROUPING O:SETFOCUS;I |
|
| 1 | 0.0 | Work 2 | I | 0 | 61, 61 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | Work 1 | I | 0 | 81, 61 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | DATEFROM | I | -1 | 391, 253 | $VALIDATE M: CUCASE |
|
| 1 | 0.0 | CMD 2 | C | -1 | 511, 361 | $SELECT S:PROD_SECT_GROUPING;I\GROUPING |
|
| 1 | 0.0 | CMD 3 | C | -1 | 511, 325 | $SELECT S:ITEM_VARIETY;I\ITEM |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 5 | I | 0 | 1, 61 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME 'A:TIMER_ON;1000 |
|
| 1 | 0.0 | Work 4 | 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 A:VAR;0;I\TEST_MKT 'PRETORIA ID 11 I:I\MARKET;<>;11 DO(S) O:DISABLEINPUT;I\GROUPING A:VAR;1;I\TEST_MKT DOEND(S) |
|
| 1 | 0.0 | Work 3 | I | 0 | 41, 61 | $DEFAULT A:ORGS;;I\ORGS |
|
| 1 | 0.0 | Work 10 | I | 0 | 11, 541 | ||
| 1 | 0.0 | STK_TRANS | ST_AGENT | I | 0 | 121, 565 | |
| 1 | 0.0 | Work 1 | I | 0 | 101, 61 | ||
| 1 | 0.0 | Label 2 | T | -1 | 271, 325 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 2 | T | -1 | 281, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 301, 49 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 271, 289 | ||
| 1 | 0.0 | Label 1 | T | -1 | 271, 361 | ||
| 1 | 0.0 | Label 6 | T | -1 | 271, 253 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 10 | 0.0 | ZX_EXIT | 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_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 |