Program drill-down
LEVY_MAN
LEVY MAINTENANCE. Type MDL, base table LEVY_MAST.
Field inventory
47
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | LEVY_MAST | LV_TYPE | T | -1 | 281, 145 | |
| 1 | 0.0 | LEVY_MAST | LV_CALC_TYPE | I | -1 | 281, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:CT_CODE;I\LV_CALC_TYPE $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'PUT ZERO AS FIRST CHARACTER A:LEN;I\LV_CALC_TYPE;W\TEMP5 'I:W\TEMP5;=;1 ' DO(LP) ' A:ISNUMERIC;I\LV_CALC_TYPE;W\TEMP6 ' |
| 1 | 0.0 | LEVY_MAST | LV_DESC | T | -1 | 111, 145 | &VALIDATE C:UCASE |
| 1 | 0.0 | LEVY_MAST | LV_MRATE | T | -1 | 471, 145 | |
| 1 | 0.0 | H | -1 | 0, 90 | |||
| 1 | 0.0 | LEVY_MAST | LV_CODE | T | -1 | 21, 145 | |
| 1 | 0.0 | LEVY_MAST | LV_DESC | I | -1 | 111, 169 | $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'CONVERT THE DATA ENTERED IN THIS FIELD TO UPPERCASE C:UCASE 'REMOVE EMPTY SPACES ON EOTHER SIDE A:TRIM;I\LV_DESC;I\LV_DESC 'CLEAR FIELDS A:CONST;;W\TEMP1 A:CONST;;W\TEMP2 'CHECK IF CODE ALREADY EXISTS U:PALLET_TYPE;CO |
| 1 | 0.0 | LEVY_MAST | LV_MRATE | I | -1 | 471, 169 | $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'CHECK IF THE DATA ENTERED IS NUMERIC AND DISPLAY AN EROR IF IT IS ALPHANUMERIC A:ISNUMERIC;I\LV_MRATE;I\NUMTST I:I\NUMTST;=;N D:MARKET RATE MUST BE A NUMERIC VALUE;ERRORM;I\LV_MRATE 'FORMAT THE DATA TO 2 DECIMAL PLACES A:VAR |
| 1 | 0.0 | Label 8 | T | -1 | 321, 49 | ||
| 1 | 0.0 | LEVY_MAST | LV_CALC_TYPE | C | -1 | 341, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:CT_CODE;I\LV_CALC_TYPE |
| 1 | 0.0 | LEVY_MAST | LV_CODE | C | -1 | 81, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:LEVY_MAN;I\LV_CODE |
| 1 | 0.0 | LEVY_MAST | LV_VATCD | T | -1 | 581, 145 | |
| 1 | 0.0 | LEVY_MAST | LV_VATCD | I | -1 | 581, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:VAT;I\LV_VATCD $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'PUT ZERO AS FIRST CHARACTER A:LEN;I\LV_VATCD;W\TEMP7 I:W\TEMP7;=;1 DO(LP1) A:ISNUMERIC;I\LV_VATCD;W\TEMP8 I:W\TEMP8;=;Y A: |
| 1 | 0.0 | LEVY_MAST | LV_BOARD | T | -1 | 681, 145 | |
| 1 | 0.0 | LEVY_MAST | LV_BOARD | C | -1 | 751, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:BOARD_CODE;I\LV_BOARD |
| 1 | 0.0 | Work 1 | I | 0 | 361, 109 | ||
| 1 | 0.0 | NUMTST | I | 0 | 31, 553 | ||
| 1 | 0.0 | LEVY_MAST | LV_RATE | I | -1 | 371, 169 | $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'CHECK IF THE DATA ENTERED IS NUMERIC AND DISPLAY AN EROR IF IT IS ALPHANUMERIC A:ISNUMERIC;I\LV_RATE;I\NUMTST I:I\NUMTST;=;N D:LEVY RATE MUST BE A NUMERIC VALUE;ERRORM;I\LV_RATE 'FORMAT THE DATA TO TWO DECIMAL PLACES A:VAR;I |
| 1 | 0.0 | Label 1 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 49 | ||
| 1 | 0.0 | I | 0 | 11, 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\LV_CODE,I\LV_DESC,I\LV_CALC_TYPE,I\LV_RATE,I\LV_MRATE,I\LV_VATCD,I\LV_BOARD U:ZZGRID_SPLIT;DB_TO_GRID;G\GRIDM;LEVY_MAST |
||
| 1 | 0.0 | Work 2 | G | -1 | 21, 193 | ||
| 1 | 0.0 | LEVY_MAST | LV_VATCD | C | -1 | 651, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:VAT;I\LV_VATCD |
| 1 | 0.0 | LEVY_MAST | LV_BOARD | I | -1 | 681, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:BOARD_CODE;I\LV_BOARD $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'PUT ZERO AS FIRST CHARACTER A:LEN;I\LV_BOARD;W\TEMP9 I:W\TEMP9;=;1 DO(LP2) A:ISNUMERIC;I\LV_BOARD;W\TEMP10 I:W\TEMP10;=; |
| 1 | 0.0 | LEVY_MAST | LV_CODE | I | -1 | 21, 169 | $SELECT 'ALLOW THE USER TO PRESS F5/LOOKUP TO VIEW AND SELECT DATA S:LEVY_MAN;I\LV_CODE $VALIDATE 'THIS IS A MANDATORY FIELD, DISPLAY ERROR IF THE USER LEAVES IT BLANK M: 'CONVERT THE DATA ENTERED IN THIS FIELD TO UPPERCASE C:UCASE 'PUT ZERO AS FIRST CHARACTER A:LEN;I\LV_CODE;W\TEMP3 I:W\TEMP3;=;1 DO |
| 1 | 0.0 | LEVY_MAST | LV_RATE | T | -1 | 371, 145 | |
| 1 | 0.0 | Work 3 | I | 0 | 131, 517 | ||
| 1 | 0.0 | Work 4 | I | 0 | 171, 517 | ||
| 1 | 0.0 | Work 9 | I | 0 | 11, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME C:MCASE;;T\MARKET |
|
| 1 | 0.0 | Work 1 | I | 0 | 211, 517 | ||
| 1 | 0.0 | Work 2 | I | 0 | 251, 517 | ||
| 1 | 0.0 | Work 3 | I | 0 | 321, 517 | ||
| 1 | 0.0 | Work 4 | I | 0 | 281, 517 | ||
| 1 | 0.0 | Work 5 | I | 0 | 351, 517 | ||
| 1 | 0.0 | Work 6 | I | 0 | 391, 517 | ||
| 1 | 0.0 | Work 7 | I | 0 | 471, 517 | ||
| 1 | 0.0 | Work 8 | I | 0 | 431, 517 | ||
| 1 | 0.0 | Work 1 | I | 0 | 471, 109 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 90 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 90 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 90 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 90 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 90 |