Program drill-down
TAG_MAST_MAN
TAG PRICE MAINTENANCE. Type MDL, base table TAG_MAST.
Field inventory
32
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 15 | C | -1 | 191, 193 | $SELECT 'ALLOW THE USER TO PRESS LOOKUP BUTTON TO VIEW THE SELECTION WINDOW 'S:CURRENCY;I\CU_CODE |
|
| 1 | 0.0 | TAG_MAST | TM_CODE | I | -1 | 141, 193 | $SELECT 'ALLOW THE USER TO PRESS F5 TO VIEW THE SELECTION WINDOW 'S:CURRENCY;I\CU_CODE $VALIDATE 'THIS FIELD A MANDATORY FIELD M: 'CONVERT THE VALUES ENTERED TO UPPERCASE C:UCASE 'DISPLAY ERROR MESSAGE OF AN INVALID ENTRY IS MADE I:I\TM_CODE;=;. D:INVALID ENTRY - TRY AGAIN;ERRORM;I\TM_CODE I:I\TM_COD |
| 1 | 0.0 | TAG_MAST | TM_DESC | I | -1 | 221, 193 | $VALIDATE 'MAKE THIS FIELD A MANDATORY FIELD M: 'CONVERT THE VALUES ENTERED TO UPPERCASE 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 'REMOVE EMPTY SPACES ON EOTHER SIDE A:TRIM;I\TM_DESC;I\TM_DESC 'CHECK IF CODE ALREAD |
| 1 | 0.0 | TAG_MAST | TM_DESC | T | -1 | 221, 169 | |
| 1 | 0.0 | TAG_MAST | TM_AMOUNT | I | -1 | 421, 193 | $VALIDATE 'THIS FIELD A MANDATORY FIELD M: 'CHECK IF THIS IS A NUMERIC VALUE AND PUT 'N' INTO SOME HIDDEN FIELD IF IT IS NOT A NUMERIC VALUE A:ISNUMERIC;I\TM_AMOUNT;W\TEMP_FIELD 'DISPLAY ERROR MESSAGE IF THIS IS NOT A NUMERIC VALUE I:W\TEMP_FIELD;=;N D:INVALID ENTRY - ENTER NUMERIC VALUES ONLY;ERRORM;I\TM_AMOU |
| 1 | 0.0 | TAG_MAST | TM_REORDER_LEVEL | I | -1 | 551, 193 | $VALIDATE I:I\TM_CODE;<>;TP DO(001) I:I\TM_REORDER_LEVEL;<>; D:RE-ORDER LEVEL IS ONLY FOR NORMAL TAGS;ERRORM;I\TM_REORDER_LEVEL DOEND(001) |
| 1 | 0.0 | Label 2 | T | -1 | 551, 169 | ||
| 1 | 0.0 | CU_USER | I | 0 | 71, 109 | $AFTER_READ 'GET THE USERNAME FROM THE GLOBAL USER FILE AND PUT IT INTO THE I\CU_USER HIDDEN FIELD I:I\CU_USER;=; A:USERID;;I\CU_USER A:CON;I\TM_CODE,I\TM_AMOUNT,I\TM_DESC;W\CON $BEFORE_WRITE 'CHECK IF ANYTHING HAS BEEN CHANGED BY THE CURRENT USER A:CON;I\TM_CODE,I\TM_AMOUNT,I\TM_DESC;W\CON2 I:W\CON;< |
|
| 1 | 0.0 | Label 11 | T | -1 | 621, 25 | ||
| 1 | 0.0 | TAG_MAST | TM_AMOUNT | T | -1 | 421, 169 | |
| 1 | 0.0 | Work 6 | G | -1 | 141, 217 | ||
| 1 | 0.0 | Label 7 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 291, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 621, 49 | ||
| 1 | 0.0 | TAG_MAST | TM_CODE | T | -1 | 141, 169 | |
| 1 | 0.0 | Work 14 | I | 0 | 201, 109 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 U:ZZGRID_SPLIT;INIT_GRID;G\CURRENCY;I\TM_CODE,I\TM_DESC,I\TM_AMOUNT,I\TM_REORDER_LEVEL U:ZZGRID_SPLIT;DB_TO_GRID;G\CURRENCY;TAG_MAST 'NOT ALLOWING USERS TO DELETE WHILE THIS RECORD IS IN USE $BEFORE_DELETE 'LOOK UP FOR THIS REC |
|
| 1 | 0.0 | Label 13 | T | -1 | 671, 25 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Label 12 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Work 1 | I | 0 | 231, 109 | ||
| 1 | 0.0 | Work 1 | I | 0 | 61, 445 | ||
| 1 | 0.0 | Work 2 | I | 0 | 111, 445 | ||
| 1 | 0.0 | Work 6 | I | 0 | 21, 73 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\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 'GET THE USERNAME FROM THE GLOBAL USER FILE AND PUT IT INTO THE I\CU_USER HIDDEN FIELD A:USERNAME;;I\CU_USER |
|
| 1 | 0.0 | Work 1 | I | 0 | 161, 445 | ||
| 1 | 0.0 | Work 1 | I | 0 | 161, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 61, 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 |