Program drill-down
BUYERS_SURETY_AGN
BUYERS SURETY MAINTENANCE. Type MAN, base table SURETY_BUYER.
Field inventory
40
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 16 | C | -1 | 191, 313 | 'SELECTING AGENT CODE FROM AGENT_MAST TABLE $SELECT S:AGENT_MAST;I\SB_AGN |
|
| 1 | 0.0 | CMD 18 | C | -1 | 451, 121 | 'SELECTING BUYER NUMBER FROM DEBTOR_MAST TABLE FOR F5 FUNCTION $SELECT S:BUYER NUMBER;I\DM_DEBTOR |
|
| 1 | 0.0 | Work 15 | G | -1 | 151, 337 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 3 | I | -1 | 221, 313 | ||
| 1 | 0.0 | SURETY_BUYER | SB_AGN | I | -1 | 151, 313 | $SELECT S:AGENT_MAST;I\SB_AGN $VALIDATE M: C:UCASE 'F:AGENT_MAST;Y;AM_CODE;I\AS_NAME=AM_NAME;AM_BLOCK<>'Y';I\SB_AGN F:AGENT_MAST;Y;AM_CODE;I\AS_NAME=AM_NAME;;I\SB_AGN U:GRID_DESC_LOAD;LOAD;G\GRID,I\SB_AGN,AM_NAME,AGENT_MAST,AM_CODE,I\AS_NAME,Y,I\SB_OSBAL |
| 1 | 0.0 | Label 2 | T | 0 | 591, 289 | ||
| 1 | 0.0 | SURETY_BUYER | SB_BLOCKED | I | -1 | 521, 313 | $VALIDATE C:UCASE V:Y;N; I:I\SB_BLOCKED;=; A:CONST;N;I\SB_BLOCKED |
| 1 | 0.0 | SURETY_BUYER | SB_DEBTOR | I | -1 | 331, 121 | 'SELECTING BUYER NUMBER FROM DEBTOR_MAST TABLE FOR F5 FUNCTION $SELECT S:BUYER NUMBER;I\SB_DEBTOR 'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD MANDATORY $VALIDATE M: C:UCASE 'LOOK UP FOR THE EXISTING DEBTOR NUMBER, IF DOES NOT EXISTS DISPLAY ERROR MESSAGE F:DEBTOR_MAST;Y;DM_DEBTOR;I\SB_DEBTOR=DM_DEBTOR, |
| 1 | 0.0 | SURETY_BUYER | SB_CRLIMIT | I | -1 | 371, 313 | $VALIDATE I:I\SB_CRLIMIT;=;.00 D:AMOUNT CANNOT BE ZERO - PLEASE RE-ENTER;ERRORM;I\SB_CRLIMIT |
| 1 | 0.0 | AGENT_SURETY | AS_AGREE_NO | I | 0 | 361, 253 | |
| 1 | 0.0 | I | -1 | 331, 145 | |||
| 1 | 0.0 | DM_OSBAL | I | -1 | 331, 193 | ||
| 1 | 0.0 | DEBTOR_MAST | DM_CRLIMIT | I | -1 | 331, 169 | |
| 1 | 0.0 | Work 25 | I | 0 | 131, 25 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 '$CALCULATE U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SB_AGN,I\AS_NAME,I\SB_CRLIMIT,I\SB_OSBAL:H,I\SB_BLOCKED |
|
| 1 | 0.0 | I | 0 | 211, 253 | |||
| 1 | 0.0 | I | 0 | 281, 253 | |||
| 1 | 0.0 | SURETY_BUYER | SB_MARKET | I | 0 | 101, 25 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\SB_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 | AGENT_SURETY | AS_AGENT | T | -1 | 151, 289 | |
| 1 | 0.0 | Label 1 | T | 0 | 361, 229 | ||
| 1 | 0.0 | AGENT_SURETY | AS_BLOCK | T | -1 | 521, 289 | |
| 1 | 0.0 | SURETY_BUYER | SB_DEBTOR | T | -1 | 171, 121 | |
| 1 | 0.0 | AGENT_SURETY | AS_SURETY | T | -1 | 371, 289 | |
| 1 | 0.0 | DEBTOR_MAST | DM_NAME | T | -1 | 171, 145 | |
| 1 | 0.0 | DEBTOR_MAST | DM_OSBAL | T | -1 | 171, 193 | |
| 1 | 0.0 | DEBTOR_MAST | DM_CRLIMIT | T | -1 | 171, 169 | |
| 1 | 0.0 | Label 17 | T | -1 | 221, 289 | ||
| 1 | 0.0 | Label 19 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 20 | T | -1 | 261, 49 | ||
| 1 | 0.0 | Label 21 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 22 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 23 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 24 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 27 | T | -1 | 1, 25 | ||
| 1 | 0.0 | I | 0 | 591, 313 | |||
| 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 | $UPDATE 'ADDED BY LP20100903 ON CHRISTO'S REQUEST U:GBL_AUDIT;ON |
|
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 |