Program drill-down
BUYER_STAT_EMAIL
BUYER STATEMENTS BULK EMAIL. Type DSP, base table STK_TRANS.
Field inventory
27
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 | MARKET | 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 | 621, 49 | ||
| 1 | 0.0 | DATE | T | -1 | 681, 25 | ||
| 1 | 0.0 | TIME | T | -1 | 681, 49 | ||
| 1 | 0.0 | STK_TRANS | ST_MARKET | I | 0 | 21, 49 | $DEFAULT 'A:ORGS;;I\AGENT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 'LOAD MARKET CODE A:ORG;;I\ST_MARKET '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:ORGS;;I\AGENT I:I\AGENT;<>; D:AGEN |
| 1 | 0.0 | Label 2 | T | -1 | 181, 217 | ||
| 1 | 0.0 | Label 3 | T | -1 | 511, 217 | ||
| 1 | 0.0 | START DATE | I | -1 | 381, 121 | $VALIDATE M: I:I\AGENT;<>; D:AGENTS ARE NOT ALLOWED TO RUN THIS SCREEN;ERRORM;I\SDATE '$BEFORE_WRITE 'I:I\AGENT;<>; 'D:AGENTS ARE NOT ALLOWED TO RUN THIS SCREEN;ERRORM;I\SDATE 'U:BUYER_STATEMENTS_BULK_EMAIL;GET_DATA |
|
| 1 | 0.0 | Work 1 | I | -1 | 381, 217 | $SELECT S:DEBTOR;I\BUYER $VALIDATE 'I:I\BUYER;<>; 'DO(MAL) ' F:DEBTOR_MAST;Y;;T\NAME=DM_NAME,I\TMP_TYPE=DM_ACCTYPE;DM_DEBTOR='$I\BUYER$';I\BUYER ' I:I\TMP_TYPE;<>;CR ' DO(DEQ) ' I:I\TMP_TYPE;<>;SC ' D:STATEMENTS ARE ONLY FOR SECURE CASH/CREDIT BUYERS;ERRORM;I\BUYER ' DOEND(DEQ) 'DOEND(MAL) I:I |
|
| 1 | 0.0 | CMD 1 | C | -1 | 321, 289 | $SELECT I:I\AGENT;<>; D:AGENTS ARE NOT ALLOWED TO RUN THIS SCREEN;ERRORM;I\SDATE A:CONST;GENERATING;T\PROG U:BUYER_STATEMENTS_BULK_EMAIL;GET_DATA A:CONST;COMPLETED!;T\PROG A:CONST;;I\BUYER,T\NAME O:SETFOCUS;I\SDATE |
|
| 1 | 0.0 | Label 12 | T | -1 | 181, 121 | ||
| 1 | 0.0 | Work 1 | I | -1 | 381, 169 | $VALIDATE M: '''F:CSV_DATE;;CSV_MARKET=;T\MARKET=CM_NAME ''F:CSV_DATE;;;I\CSVDATE=MAX(CSV_DATE);CSV_MARKET='$T\MARKET$' ''I:I\EDATE;>;I\CSVDATE ''D: |
|
| 1 | 0.0 | Label 2 | T | -1 | 181, 169 | ||
| 1 | 0.0 | AGENT CODE | I | 0 | 31, 109 | ||
| 1 | 0.0 | Work 4 | I | 0 | 561, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 41, 49 | ||
| 1 | 0.0 | Work 1 | I | 0 | 41, 73 | ||
| 1 | 0.0 | Label 2 | T | -1 | 321, 325 | ||
| 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 |