Program drill-down
BUYER_GROUP
BUYER GROUP MAINTENANCE. Type MDL, base table BUYER_GROUP.
Field inventory
27
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 14 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 13 | T | -1 | 291, 25 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Label 111 | T | -1 | 151, 169 | ||
| 1 | 0.0 | Label 112 | T | -1 | 261, 169 | ||
| 1 | 0.0 | BUYER_GROUP | BG_CODE | I | -1 | 151, 193 | 'SELECTING FROM THE BUYER_GROUP TABLE FOR F5 FUNCTION $SELECT S:BUYER_GROUP;I\BG_CODE 'CHANGE TEXT CASE INTO UPPER CASE AND SET THIS FIELD MANDATORY $VALIDATE M: C:UCASE 'A:ISNUMERIC;I\BG_CODE;W\TEMP3 'I:W\TEMP3;=;Y 'A:VAR;I\BG_CODE;I\BG_CODE;;00 F:BUYER_GROUP;;BG_CODE;I\TMP1=BG_CODE;BG_DELIND = 'Y' I:I\ |
| 1 | 0.0 | BUYER_GROUP | BG_DESC | I | -1 | 261, 193 | 'CHANGE TEXT CASE TO UPPER CASE AND SET THIS FIELD AS MANDATORY $VALIDATE M: C:UCASE 'CODE TO ENSURE THAT THE DESCRIPTION DOES NOT ALREADY EXIST IN THE GRID 'CLEAR FIELDS A:CONST;;W\TEMP1 A:CONST;;W\TEMP2 'CHECK IF CODE ALREADY EXISTS U:PALLET_TYPE;CODE_CHECK;I\BG_CODE,G\GRIDM,W\TEMP1,I\BG_DESC I:W\TEMP |
| 1 | 0.0 | CMD 116 | C | -1 | 231, 193 | 'SELECTING FROM THE BUYER_GROUP TABLE FOR F5 FUNCTION $SELECT S:BUYER_GROUP;I\BG_CODE |
|
| 1 | 0.0 | Label 118 | T | -1 | 281, 49 | ||
| 1 | 0.0 | Label 119 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 120 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 121 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 122 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Work 1 | G | -1 | 151, 217 | ||
| 1 | 0.0 | Work 2 | I | 0 | 31, 97 | $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\GRIDM;I\BG_CODE,I\BG_DESC U:ZZGRID_SPLIT;DB_TO_GRID;G\GRIDM;BUYER_GROUP,BG_DELIND<>'Y' $BEFORE_DELETE 'DONT ALLOW USER TO DELETE WHILE THERE IS EMPTY FIELDS I:I\BG_CODE;=; DO(001) I: |
|
| 1 | 0.0 | Work 1 | I | 0 | 71, 97 | $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 |
|
| 1 | 0.0 | Work 4 | I | 0 | 431, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 351, 481 | ||
| 1 | 0.0 | Work 3 | I | 0 | 391, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 91, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 471, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 511, 481 | ||
| 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 |