Program drill-down
HIST_SALES2
HIST SALES JD. Type DSP, base table ADDR_TYPE.
Field inventory
37
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | CMD 1 | C | -1 | 341, 373 | $SELECT I:I\AGENT;=; DO(ALA) D:ONLY AN AGENT MAY RUN THIS REPORT;ERRORM;I\SELDATE A:CONST;;I\SELDATE DOEND(ALA) U:REPORTS_DATA_CHECK;HIST_SALES I:I\IND;=;N D:NO DATA TO PRINT;ERRORM;I\SELDATE A:CONST;IN PROGRESS;T\PROG E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_HIST_SALES;$I\MARKET$,$I\S |
|
| 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 | 311, 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 | Label 8 | T | -1 | 261, 193 | ||
| 1 | 0.0 | Work 9 | I | -1 | 381, 193 | $CALCULATE M: |
|
| 1 | 0.0 | Work 10 | 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 12 | I | 0 | 1, 61 | $DEFAULT 'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 A:VAR;T\DATE;I\SELDATE A:VAR;T\DATE;I\TODATE |
|
| 1 | 0.0 | Work 13 | I | 0 | 81, 61 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | Work 14 | I | 0 | 41, 61 | $DEFAULT A:ORGS;;I\ORGS I:I\ORGS;<>; DO(SQL) O:DISABLEINPUT;I\AGENT,C\3 A:VAR;I\ORGS;I\AGENT F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE = '$I\AGENT$';I\AGENT DOEND(SQL) |
|
| 1 | 0.0 | Work 15 | I | 0 | 61, 61 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | Label 1 | T | -1 | 261, 229 | ||
| 1 | 0.0 | Work 2 | I | -1 | 381, 229 | ||
| 1 | 0.0 | Label 3 | T | -1 | 261, 265 | ||
| 1 | 0.0 | Work 4 | I | -1 | 381, 265 | $SELECT S:SUPPLIER_CODE;I\SUPPL $CALCULATE I:I\SUPPL;<>; DO(SPL) A:VAR;I\SUPPL;I\SUPPL;;000000 F:SUPPLIER_MAST;Y;;T\SUPPLNAME=SUM_NAME;SUM_SUPPL=$I\SUPPL$;I\SUPPL DOEND(SPL) |
|
| 1 | 0.0 | CMD 5 | C | -1 | 481, 265 | $SELECT S:SUPPLIER_CODE;I\SUPPL |
|
| 1 | 0.0 | Label 6 | T | -1 | 531, 265 | ||
| 1 | 0.0 | Label 1 | T | -1 | 261, 301 | ||
| 1 | 0.0 | Work 2 | I | -1 | 381, 301 | $SELECT S:PRODUCT;I\PROD $CALCULATE I:I\PROD;<>; DO(LAM) C:UCASE F:PRODUCT_MAST;Y;;T\PRODNAME=PR_DESC;PR_PRODUCT='$I\PROD$';I\PROD DOEND(LAM) O:SETFOCUS;C\CREATE O:BACKCOLOR;C\CREATE;YELLOW |
|
| 1 | 0.0 | Label 3 | T | -1 | 531, 301 | ||
| 1 | 0.0 | CMD 4 | C | -1 | 481, 301 | $SELECT S:PRODUCT;I\PROD |
|
| 1 | 0.0 | Work 1 | I | 0 | 611, 529 | ||
| 1 | 0.0 | Work 1 | I | -1 | 381, 157 | $SELECT S:AGENT_CODE;I\AGENT $CALCULATE M: C:UCASE F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE = '$I\AGENT$';I\AGENT A:VAR;I\AGENT;I\ORGS |
|
| 1 | 0.0 | Label 2 | T | -1 | 261, 157 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 481, 157 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | Label 4 | T | -1 | 531, 157 | ||
| 1 | 0.0 | Label 2 | T | -1 | 341, 409 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | $PRINT I:I\AGENT;=; DO(ALA) D:ONLY AN AGENT MAY RUN THIS REPORT;ERRORM;I\SELDATE A:CONST;;I\SELDATE DOEND(ALA) U:REPORTS_DATA_CHECK;HIST_SALES I:I\IND;=;N D:NO DATA TO PRINT;ERRORM;I\SELDATE E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_HIST_SALES;$I\MARKET$,$I\SELDATE$,$I\TODATE$,$I\AGENT$, |
|
| 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 |