Program drill-down
CURRENCY_MAST
CURRENCY MAINTENANCE. Type MDL, base table CURRENCY_MAST.
Field inventory
30
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 15 | C | -1 | 261, 193 | $SELECT 'ALLOW THE USER TO PRESS LOOKUP BUTTON TO VIEW THE SELECTION WINDOW S:CURRENCY;I\CU_CODE |
|
| 1 | 0.0 | CURRENCY_MAST | CU_CODE | I | -1 | 211, 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\CU_CODE;=;. D:INVALID ENTRY - TRY AGAIN;ERRORM;I\CU_CODE I:I\CU_CODE |
| 1 | 0.0 | CURRENCY_MAST | CU_DESC | I | -1 | 291, 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\CU_DESC;I\CU_DESC 'CHECK IF CODE ALREAD |
| 1 | 0.0 | CURRENCY_MAST | CU_DESC | T | -1 | 291, 169 | |
| 1 | 0.0 | CURRENCY_MAST | CU_EXC_RATE | I | -1 | 491, 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\CU_EXC_RATE;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\CU_EX |
| 1 | 0.0 | CURRENCY_MAST | CU_USER | I | 0 | 71, 169 | $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\CU_CODE,I\CU_EXC_RATE,I\CU_DESC;W\CON $BEFORE_WRITE 'CHECK IF ANYTHING HAS BEEN CHANGED BY THE CURRENT USER A:CON;I\CU_CODE,I\CU_EXC_RATE,I\CU_DESC;W\CON2 I:W\C |
| 1 | 0.0 | Label 11 | T | -1 | 621, 25 | ||
| 1 | 0.0 | CURRENCY_MAST | CU_EXC_RATE | T | -1 | 491, 169 | |
| 1 | 0.0 | Work 6 | G | -1 | 211, 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 | CURRENCY_MAST | CU_CODE | T | -1 | 211, 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\CU_CODE,I\CU_DESC,I\CU_EXC_RATE U:ZZGRID_SPLIT;DB_TO_GRID;G\CURRENCY;CURRENCY_MAST 'NOT ALLOWING USERS TO DELETE WHILE THIS RECORD IS IN USE $BEFORE_DELETE 'LOOK UP FOR THIS RECORD IN CLIEN |
|
| 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 |