Program drill-down
SUPPLIER_DUMP_FILE
SUPPLIER DUMP FILE. Type DSP, base table STK_DETS.
Field inventory
35
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 1 | C | -1 | 271, 325 | $SCMD O:BACKCOLOR;C\RUN;YELLOW $SELECT A:CONST;PROCESSING !!!;T\PROG U:SUPPLIER_DUMP;DUMP A:CONST;COMPLETE !!!;T\PROG I:I\ORGS;<>; DO(01) A:CONST;;I\SUPPLIER O:SETFOCUS;I\ORDERBY DOEND(01) I:I\ORGS;=; DO(02) A:CONST;;I\AGENT,T\AGENT2,I\SUPPLIER,I\PCODE,I\ITEM,T\NAME,I\ORDERBY,T\DESC O:SET |
|
| 1 | 0.0 | Label 1 | T | -1 | 221, 229 | ||
| 1 | 0.0 | Work 2 | I | -1 | 331, 229 | $SELECT S:ITEM_SEL;I\ITEM $VALIDATE C:UCASE A:SELPARM;2;I\TMP1 A:CON;I\ITEM;I\ITEM;I\TMP1 '$VALIDATE I:I\ITEM;<>; F:VAR_MAST;;;T\NAME=VA_DESC;VA_PRODUCT=LEFT('$I\ITEM$', 2) AND VA_VARIETY=RIGHT('$I\ITEM$', 2);I\ITEM |
|
| 1 | 0.0 | CMD 3 | C | -1 | 381, 157 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | MARKET | I | 0 | 1, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET A:ORGS;;I\AGENT A:ORGS;;I\ORGS F:AGENT_MAST;;;T\AGENT2=AM_NAME;AM_CODE='$I\ORGS$' 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME 'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL C:MCASE;;T\MARKET A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\T |
|
| 1 | 0.0 | CMD 5 | C | -1 | 431, 229 | $SELECT S:ITEM_SEL;I\ITEM |
|
| 1 | 0.0 | Label 7 | T | -1 | 471, 229 | ||
| 1 | 0.0 | Work 1 | I | -1 | 331, 193 | $VALIDATE C:UCASE V:;S;N |
|
| 1 | 0.0 | Label 2 | T | -1 | 221, 193 | ||
| 1 | 0.0 | Work 2 | I | 0 | 91, 61 | ||
| 1 | 0.0 | Work 1 | I | -1 | 331, 157 | $SELECT S:AGENT_CODE;I\AGENT $CALCULATE A:CONST;;T\AGENT2 'M: C:UCASE 'DISABLE AGENT FIELD FOR AGENTS I:I\AGENT;<>; F:AGENT_MAST;Y;;T\AGENT2=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT A:CONST;$T\DATE$;I\FROM_DATE A:VAR;I\FROM_DATE;I\FROM_DATE;;DD MMM YYYY A:CONST;1;K\PRINTAGENT I:I\AGENT;=; DO(01) O:SH |
|
| 1 | 0.0 | Label 3 | T | -1 | 221, 265 | ||
| 1 | 0.0 | Work 4 | I | -1 | 331, 265 | $SELECT S:AREA_CODE;I\PCODE $VALIDATE C:UCASE I:I\PCODE;<>; F:AREA_MAST;Y;;T\DESC=AR_DESC,I\PCODE=AR_CODE;AR_CODE='$I\PCODE$';I\PCODE O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Work 4 | I | 0 | 41, 61 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 61 | ||
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 311, 49 | ||
| 1 | 0.0 | Label 5 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 7 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 8 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 9 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 221, 157 | ||
| 1 | 0.0 | Label 2 | T | -1 | 421, 157 | ||
| 1 | 0.0 | Label 1 | T | -1 | 281, 361 | ||
| 1 | 0.0 | Work 10 | I | 0 | 1, 121 | ||
| 1 | 0.0 | Work 8 | I | 0 | 1, 97 | ||
| 1 | 0.0 | CMD 9 | C | -1 | 431, 265 | $SELECT S:AREA_CODE;I\PCODE |
|
| 1 | 0.0 | Label 11 | T | -1 | 471, 265 | ||
| 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 |