Program drill-down
DLY_SMAN_DETAILED_NW
DAILY SMAN DETAILED. Type DSP, base table STK_TRANS.
Field inventory
34
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 14 | C | -1 | 461, 205 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | CMD 15 | C | -1 | 461, 313 | $SELECT I:I\AGENT;<>; S:SALESMAN_AGENT;I\SMAN;I\AGENT I:I\AGENT;=; S:SALESMAN;I\SMAN |
|
| 1 | 0.0 | CMD 16 | C | -1 | 331, 373 | $SELECT A:CONST;;I\ALLOW I:I\FDATE;=; D:PLEASE ENTER A FROM DATE;ERRORM;I\FDATE I:I\TDATE;=; D:PLEASE ENTER A TO DATE;ERRORM;I\TDATE I:I\AGENT;<>; F:AGENT_MAST;Y;;;AM_CODE = '$I\AGENT$';I\AGENT I:I\SMAN;<>; F:SALESMAN_MAST;Y;;;SLS_CODE='$I\SMAN$';I\SMAN A:DATEDIFF;I\TDATE;I\DATEDIFF;I\FDATE I:I\D |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 2 | I | -1 | 351, 349 | $VALIDATE C:UCASE V:N;Y O:SETFOCUS;C\GO O:BACKCOLOR;C\GO;YELLOW |
|
| 1 | 0.0 | Work 1 | I | 0 | 121, 361 | ||
| 1 | 0.0 | AGENT | I | -1 | 351, 205 | $SELECT S:AGENT_CODE;I\AGENT $CALCULATE C:UCASE O:SHOW;T\ANAME I:I\AGENT;<>; F:AGENT_MAST;Y;AM_CODE;T\ANAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT I:I\AGENT;=; A:CONST;ALL;T\ANAME O:SETFOCUS |
|
| 1 | 0.0 | FDATE | I | -1 | 351, 241 | $CALCULATE M: |
|
| 1 | 0.0 | TDATE | I | -1 | 351, 277 | $CALCULATE A:CONST;;I\ALLOW M: A:DATEDIFF;I\TDATE;I\DATEDIFF;I\FDATE I:I\DATEDIFF;<;0 D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TDATE I:I\CM_ALLOW_MNTH_REPORT;<>;1 DO(CHK) U:FIX_LOC_TRANS;REPORTS_TIME_CHECK;I\FDATE,I\TDATE I:I\ALLOW;=;N DO(01) O:SETFOCUS;I\FDATE DOEND(01) DOEND(CHK |
|
| 1 | 0.0 | SMAN | I | -1 | 351, 313 | $SELECT I:I\AGENT;<>; S:SALESMAN_AGENT;I\SMAN;I\AGENT I:I\AGENT;=; S:SALESMAN;I\SMAN $CALCULATE I:I\SMAN;=; A:CONST;ALL;T\SNAME I:I\SMAN;<>; DO(K22) I:I\AGENT;<>; F:SALESMAN_MAST;Y;;T\SNAME=SLS_NAME;SLS_CODE='$I\SMAN$' AND SLS_AGENT='$I\AGENT$';I\SMAN I:I\AGENT;=; F:SALESMAN_MAST;Y;;T\SNAME |
|
| 1 | 0.0 | Work 1 | I | 0 | 151, 361 | ||
| 1 | 0.0 | Work 21 | I | 0 | 21, 61 | '$DEFAULT 'A:ORGS;;I\ORGS 'I:I\ORGS;<>; 'DO(LAM) ' A:VAR;I\ORGS;I\AGENT ' F:AGENT_MAST;;;T\ANAME = AM_NAME;AM_CODE = '$I\AGENT$' ' O:DISABLEINPUT;I\AGENT,C\AGN 'DOEND(LAM) |
|
| 1 | 0.0 | MARKET | I | 0 | 1, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET 'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS A:DATE;DD MMM YYYY; |
|
| 1 | 0.0 | Work 2 | I | 0 | 181, 361 | ||
| 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 | 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 | Label 8 | T | -1 | 231, 205 | ||
| 1 | 0.0 | Label 9 | T | -1 | 231, 241 | ||
| 1 | 0.0 | Label 10 | T | -1 | 231, 277 | ||
| 1 | 0.0 | Label 11 | T | -1 | 231, 313 | ||
| 1 | 0.0 | Label 12 | T | -1 | 511, 205 | ||
| 1 | 0.0 | Label 13 | T | -1 | 511, 313 | ||
| 1 | 0.0 | Label 1 | T | -1 | 231, 349 | ||
| 1 | 0.0 | Label 23 | T | -1 | 331, 409 | ||
| 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 |