Program drill-down
BUYER_SLS_ENQ
BUYER SALES ENQUIRY. Type DSP, base table STK_TRANS.
Field inventory
43
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 | 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 | Work 8 | I | 0 | 61, 61 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | Work 9 | I | 0 | 41, 61 | $DEFAULT A:USERID;;I\USER U:MENU_GROUP;LOOKUP |
|
| 1 | 0.0 | Work 10 | I | 0 | 21, 61 | $DEFAULT A:ORGS;;I\ORGS I:I\ORGS;<>; DO(SQS) A:VAR;I\ORGS;I\AGENT O:DISABLEINPUT;I\AGENT O:DISABLEINPUT;C\AGN F:AGENT_MAST;;;T\AGN_NAME=AM_NAME;AM_CODE = '$I\ORGS$' DOEND(SQS) I:I\ORGS;=; DO(SQS) O:ENABLEINPUT;I\AGENT O:ENABLEINPUT;C\AGN DOEND(SQS) |
|
| 1 | 0.0 | Work 11 | 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,I\CM_REP_RUN_TIME=CM_REPORT_RUN_TIME,I\CM_ALLOWED_DATE_RANGE=CM_ALLOWED_DATE_RANGE; 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET |
|
| 1 | 0.0 | Label 12 | T | -1 | 261, 145 | ||
| 1 | 0.0 | AGENT | I | -1 | 371, 145 | $SELECT S:AGENT_CODE;I\AGENT $CALCULATE C:UCASE I:I\AGENT;<>; F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT |
|
| 1 | 0.0 | CMD 14 | C | -1 | 471, 181 | $SELECT S:SUBS;I\BUYER |
|
| 1 | 0.0 | BUYER | T | -1 | 261, 181 | ||
| 1 | 0.0 | BUYER | I | -1 | 371, 181 | $SELECT S:SUBS;I\BUYER $CALCULATE I:I\BUYER;<>; DO(CHK) F:DEBTOR_MAST;Y;;T\NAME=DM_NAME;DM_DEBTOR='$I\BUYER$';I\BUYER 'SEARCH FOR SUB BUYERS CARDS F:DEBTOR_MAST;;;I\TMP1=DM_DEBTOR;DM_MAIN_DEBTOR='$I\BUYER$' DOEND(CHK) 'I:I\TMP1;=; 'D:THIS BUYER HAS NO SUB CARDS;ERRORM;I\BUYER |
|
| 1 | 0.0 | CMD 17 | C | -1 | 471, 145 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | SELDATE | T | -1 | 261, 253 | ||
| 1 | 0.0 | SELDATE | I | -1 | 371, 253 | $CALCULATE M: I:I\MARKET;<>;11 DO(NOT11) I:I\MARKET;<>;23 U:DATECHECKER;FUTURE;I\FROM_DATE DOEND(NOT11) |
|
| 1 | 0.0 | Label 1 | T | -1 | 261, 325 | ||
| 1 | 0.0 | CMD 20 | C | -1 | 641, 541 | $SELECT 'I:I\BUYER;=; 'D:PLEASE ENTER A BUYER;ERRORM;I\BUYER I:I\FROM_DATE;=; D:PLEASE ENTER A DATE;ERRORM;I\FROM_DATE I:I\TO_DATE;=; D:PLEASE ENTER A DATE;ERRORM;I\TO_DATE A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE I:I\DATEDIFF;<;0 D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE A:DATED |
|
| 1 | 0.0 | Label 1 | T | -1 | 261, 217 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 217 | $VALIDATE I:I\BUYER;=; DO(NB) I:I\TAXINV;<>; F:STK_TRANS;Y;;;ST_TAXINV='$I\TAXINV$';I\TAXINV DOEND(NB) I:I\BUYER;<>; DO(B) I:I\TAXINV;<>; DO(INV) F:STK_TRANS;;;I\INVCHK=ST_TAXINV;ST_TAXINV='$I\TAXINV$' AND ST_DEBTOR='$I\BUYER$';I\TAXINV I:I\INVCHK;=; D:TAX INVOICE $I\TAXINV$ DOES NOT EXIST FOR THIS BU |
|
| 1 | 0.0 | Label 22 | T | -1 | 511, 145 | ||
| 1 | 0.0 | Label 21 | T | -1 | 511, 181 | ||
| 1 | 0.0 | TMP1 | I | 0 | 11, 481 | ||
| 1 | 0.0 | Work 3 | I | 0 | 1, 85 | ||
| 1 | 0.0 | Label 1 | T | -1 | 261, 289 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 289 | $VALIDATE I:I\TO_DATE;=; A:DATE;DD MMM YYYY;I\TO_DATE A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE I:I\DATEDIFF;<;0 D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE A:DATEDIFF;I\TO_DATE;I\NEW_DATE;I\FROM_DATE A:TIME;HH:MM;I\TMP_TIME I:I\MARKET;=;11 DO(11) I:I\TMP_TIME;<;I\CM_REP_RUN_TIME |
|
| 1 | 0.0 | Work 1 | I | 0 | 61, 121 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 325 | $VALIDATE 'UPPERCASE C:UCASE V:N;Y O:BACKCOLOR;C\GO;YELLOW O:SETFOCUS;C\GO |
|
| 1 | 0.0 | Work 1 | I | 0 | 1, 217 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 121 | ||
| 1 | 0.0 | Work 1 | I | 0 | 21, 121 | ||
| 1 | 0.0 | Work 2 | I | 0 | 41, 121 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 169 | ||
| 1 | 0.0 | Work 2 | I | 0 | 1, 193 | ||
| 1 | 0.0 | Work 3 | I | 0 | 21, 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 |