Program drill-down
ACTIVE_SUPP_DUMP
ACTIVE SUPPLIERS FOR 12 MONTHS. Type DSP, base table CLIENT_MAST.
Field inventory
26
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 9 | C | -1 | 301, 241 | $SELECT A:CONST;IN PROGRESS...;T\PROG U:ACTIVE_SUPPLIERS_IN_12;CREATE_CSV A:CONST;COMPLETE !!!;T\PROG I:I\ORGS;<>; O:SETFOCUS;I\FDATE I:I\ORGS;=; DO(ORGS) O:SETFOCUS;I\AGENT A:CONST;;I\AGENT,T\AGENT_NAME DOEND(ORGS) A:DATE;DD MMM YYYY;I\FDATE |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 1 | I | 0 | 1, 97 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MKT A:ORGS;;I\ORGS I:I\ORGS;<>; DO(DLE) A:VAR;I\ORGS;I\AGENT F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\ORGS$';I\AGENT O |
|
| 1 | 0.0 | Work 2 | I | 0 | 1, 121 | $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 | 1, 169 | $DEFAULT A:USERIP;I\IP |
|
| 1 | 0.0 | Work 3 | I | 0 | 1, 145 | $DEFAULT A:USERID;I\USERID |
|
| 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 | 621, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 231, 49 | ||
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 8 | T | -1 | 281, 277 | ||
| 1 | 0.0 | Work 1 | I | -1 | 301, 157 | $SELECT S:AGENT_CODE;I\AGENT $CALCULATE C:UCASE I:I\AGENT;<>; F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT A:CONST;;T\PROG |
|
| 1 | 0.0 | Work 3 | I | 0 | 1, 85 | ||
| 1 | 0.0 | Label 2 | T | -1 | 201, 157 | ||
| 1 | 0.0 | Work 1 | I | -1 | 301, 193 | $VALIDATE I:I\FDATE;=; A:DATE;DD MMM YYYY;I\FDATE O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Label 5 | T | -1 | 411, 157 | ||
| 1 | 0.0 | CMD 4 | C | -1 | 371, 157 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | Label 2 | T | -1 | 201, 193 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | 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_EXIT | Z | 0 | 0, 0 |