Program drill-down
BOARD_MAN
BOARD MAINTENANCE. Type MDL, base table BOARD_MAST.
Field inventory
46
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | BOARD_MAST | BM_CODE | I | -1 | 321, 121 | $SELECT 'DISPLAY A SELECTION WINDOW S:BOARD_CODE;I\BM_CODE $VALIDATE 'MAKE THIS FIELD MANDATORY M: 'CONVERT TO UPPERCASE C:UCASE 'DO A LOOK-UP FOR A RECORD F:LEVY_MAST;;;I\TMP3=LV_BOARD;LV_BOARD='$I\BM_CODE$' $AFTER_READ 'F:VAT_MAST;;;T\VAT_PERC=VT_RATE;VT_CODE='$I\BM_VATCD$';I\BM_VATCD 'A:VAR;T |
| 1 | 0.0 | BOARD_MAST | BM_CODE | T | -1 | 191, 121 | |
| 1 | 0.0 | CMD 2 | C | -1 | 361, 121 | $SELECT S:BOARD_CODE;I\BM_CODE |
|
| 1 | 0.0 | BOARD_MAST | BM_NAME | I | -1 | 321, 157 | $VALIDATE C:UCASE M: |
| 1 | 0.0 | BOARD_MAST | BM_NAME | T | -1 | 191, 157 | |
| 1 | 0.0 | BOARD_MAST | BM_ADDR1 | I | -1 | 321, 205 | $VALIDATE C:UCASE M: |
| 1 | 0.0 | BOARD_MAST | BM_ADDR1 | T | -1 | 191, 205 | |
| 1 | 0.0 | BOARD_MAST | BM_ADDR2 | I | -1 | 321, 229 | $VALIDATE C:UCASE |
| 1 | 0.0 | BOARD_MAST | BM_ADDR3 | I | -1 | 321, 253 | $VALIDATE C:UCASE |
| 1 | 0.0 | BOARD_MAST | BM_PCODE | I | -1 | 321, 277 | 'LP20091029 ON KASSIE'S REQUEST $SELECT S:AREA_CODE;I\BM_PCODE $VALIDATE M: A:LEN;I\BM_PCODE;W\LENGTH A:ISNUMERIC;I\BM_PCODE;I\NUMTST I:I\NUMTST;=;N D:ENTER A NUMBER ONLY - NOT $I\BM_PCODE$;ERRORM;I\BM_PCODE 'LP20091029 ON KASSIE'S REQUEST 'A:VAR;I\BM_PCODE;I\BM_PCODE;;0000 'ADDED BY LP20091029 O |
| 1 | 0.0 | BOARD_MAST | BM_PCODE | T | -1 | 191, 277 | |
| 1 | 0.0 | BOARD_MAST | BM_TELNO | I | -1 | 321, 325 | $VALIDATE 'I:I\BM_TELNO;<>; ' DO(01) ' 'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD ' A:LEN;I\BM_TELNO;I\TMP2 ' 'IF LENGTH IS < 10, DISPLAY AN ERROR ' I:I\TMP2;<;10;NUM ' D:PHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\BM_TELNO ' U:NUMBER_VALIDATE;TELL_CHK;I\BM_TELNO,0,I\TMP1 ' 'IF THE |
| 1 | 0.0 | BOARD_MAST | BM_TELNO | T | -1 | 191, 325 | |
| 1 | 0.0 | BOARD_MAST | BM_FAXNO | I | -1 | 321, 361 | $VALIDATE 'I:I\BM_FAXNO;<>; ' DO(02) ' 'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD ' A:LEN;I\BM_FAXNO;I\TMP2 ' 'IF LENGTH IS < 10, DISPLAY AN ERROR ' I:I\TMP2;<;10;NUM ' D:FAX NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\BM_FAXNO ' U:NUMBER_VALIDATE;TELL_CHK;I\BM_FAXNO,0,I\TMP2 |
| 1 | 0.0 | BOARD_MAST | BM_FAXNO | T | -1 | 191, 361 | |
| 1 | 0.0 | BOARD_MAST | BM_VATREG_NO | I | -1 | 321, 421 | $SELECT S:VAT;I\BM_VATCD $VALIDATE 'MAKE THIS FIELD MANDATORY M: 'CHECK IF THIS VALUE IS NUMERIC ================== MODIFIED BY LAZOLA 21 MAY 2008 'A:ISNUMERIC;I\BM_VATCD;I\NUMTST 'I:I\NUMTST;=;N 'D:ENTER A NUMBER ONLY - NOT $I\BM_VATCD$;ERRORM;I\BM_VATREG_NO 'ZERO FILL VATCODE TO WO DIGITS 'A:LEN; |
| 1 | 0.0 | BOARD_MAST | BM_VATCD | T | -1 | 191, 421 | |
| 1 | 0.0 | BOARD_MAST | BM_LEVYCD | I | 0 | 321, 457 | $SELECT 'DISPLAY A SELECTION WINDOW S:LEVY_MAN;I\BM_LEVYCD $CALCULATE 'MAKE TIS FIELD MANDAORY M: 'CONVERT TO UPPERCASE C:UCASE 'CHECK IF THIS VIELD IS NUMERIC A:ISNUMERIC;I\BM_VATCD;I\NUMTST I:I\NUMTST;=;N D:ENTER A NUMBER ONLY - NOT $I\BM_LEVYCD$;ERRORM;I\BM_LEVYCD 'ZERO FILL TO TWO DIGITS A:LEN; |
| 1 | 0.0 | BOARD_MAST | BM_LEVYCD | T | 0 | 191, 457 | |
| 1 | 0.0 | CMD 2 | C | 0 | 481, 421 | $SELECT S:VAT;I\BM_VATCD |
|
| 1 | 0.0 | CMD 3 | C | 0 | 361, 457 | $SELECT S:LEVY_MAN;I\BM_LEVYCD |
|
| 1 | 0.0 | VAT_PERC | T | 0 | 521, 421 | ||
| 1 | 0.0 | LEVY_DESC | T | 0 | 401, 457 | ||
| 1 | 0.0 | NUMTST | I | 0 | 41, 529 | ||
| 1 | 0.0 | Label 8 | T | -1 | 311, 49 | ||
| 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 | DEFAULT | I | 0 | 31, 97 | $DEFAULT A:DATE;DD MMM/YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 $BEFORE_DELETE 'CHECK FOR EMPTY FIELDS BEFORE YOU CAN DELETE A RECORD I:I\BM_CODE;=; D:CAN NOT DELETE - NO RECORD SELECTED;ERRORM;I\BM_CODE I:I\BM_NAME;=; DO(1) O:ENABLEINPUT;I\BM_NAME D:CAN NOT DELETE - NO RECORD SEL |
|
| 1 | 0.0 | Work 1 | I | 0 | 71, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 101, 529 | ||
| 1 | 0.0 | Work 6 | I | 0 | 71, 97 | $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 2 | I | 0 | 141, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 191, 505 | ||
| 1 | 0.0 | Work 2 | I | 0 | 231, 505 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 394, 277 | 'LP20091029 ON KASSIE'S REQUEST $SELECT S:AREA_CODE;I\BM_PCODE |
|
| 1 | 0.0 | Work 1 | I | 0 | 271, 505 | 'ADDED BY LP20091029 TO FORCE USERS TO ENTER 4 NUMBERS IN THE POSTAL CODE SCREEN |
|
| 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 |