Program drill-down
SURETY_BUYERS_REPORT
SURETY BUYERS REPORT. Type DSP, base table DEBT_ADDR.
Field inventory
25
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 | 251, 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 | 1, 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 '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 |
|
| 1 | 0.0 | Label 9 | T | -1 | 231, 121 | ||
| 1 | 0.0 | Work 10 | I | -1 | 351, 121 | $SELECT S:SURETY_BUYER;I\BUYER;I\MARKET $CALCULATE M: C:UCASE A:CONST;;T\PROG 'MAKE SURE THE BUYER EXISTS F:DEBTOR_MAST;Y;;I\MAIN=DM_MAIN_DEBTOR,I\SURETY=DM_SURETY_BUYER,T\NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\BUYER$';I\BUYER 'CHECK IF SURETY BUYER I:I\SURETY;<>;Y D:ONLY SURETY BUYERS MA |
|
| 1 | 0.0 | Label 11 | T | -1 | 231, 157 | ||
| 1 | 0.0 | Work 12 | I | -1 | 351, 157 | $SELECT S:STATEMENT_PAY_DATE;I\SDATE;I\BUYER $CALCULATE M: 'FORMAT THE DATE FOR SQL USAGE A:VAR;I\SDATE;I\SDATE;;YYYY/MM/DD 'MAKE SURE THE DATE EXISTS F:SURETY_STATEMENT_TRANS;Y;;;SST_DEBTOR='$I\BUYER$' AND SST_TRDATE='$I\SDATE$';I\SDATE O:BACKCOLOR;C\RUN;YELLOW O:SETFOCUS;C\RUN |
|
| 1 | 0.0 | CMD 13 | C | -1 | 461, 121 | $SELECT S:SURETY_BUYER;I\BUYER;I\MARKET |
|
| 1 | 0.0 | CMD 14 | C | -1 | 461, 157 | ||
| 1 | 0.0 | Label 15 | T | -1 | 511, 121 | ||
| 1 | 0.0 | CMD 16 | C | -1 | 341, 217 | $SELECT I:I\BUYER;=; D:PLEASE ENTER A BUYER NUMBER;ERRORM;I\BUYER I:I\SDATE;=; D:PLEASE ENTER A TRANSACTION DATE;ERRORM;I\SDATE A:CONST; RUNNING;T\PROG E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_SURETY_BUYER_PMTS;$I\BUYER$,$I\SDATE$,S A:CONST;COMPLETE;T\PROG A:CONST;;I\BUYER,T\NAME,I\SDATE |
|
| 1 | 0.0 | Label 17 | T | -1 | 341, 253 | ||
| 1 | 0.0 | Work 19 | I | 0 | 621, 121 | ||
| 1 | 0.0 | Work 20 | I | 0 | 651, 121 | ||
| 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 |