Table Name | AETBLMST |
Long Name | Master Lookup Table |
Description | This file contains the information for all system look up tables. It stores the code and corresponding description, in addition to the security level for editing purposes. |
Prefix | TB |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
tm_tblid | 10 | char | Table Abbreviation | |
tm_code | 10 | char | Table Coded Value | |
tm_name | 150 | char | Table Description | |
tm_size | 5 | decimal | Field Size | |
tm_level | 5 | decimal | Security Level | |
tm_comment | 254 | char | Comment | |
tm_order | 3 | char | ||
tm_key | 10 | char | ||
tm_webiep | 1 | bit | ||
tm_altdesc | 16 | text | ||
tm_inactive | 1 | bit | ||
tm_webifsp | 1 | bit |