302Lookup / Code Tables
The values of every code table.
Try it
All code tables
Each type is a small list; other masters store the code (e.g. holiday.holiday_type = 'PUBLIC')| # | Type | Code | Name (English) | Name (Thai) | Extra | Sort order | Status | |
|---|---|---|---|---|---|---|---|---|
| 1 | UNIT_TYPE - Unit type | LENGTH | Length | ความยาว | — | 1 | Active | ✏️ |
| 2 | UNIT_TYPE - Unit type | WEIGHT | Weight | น้ำหนัก | — | 2 | Active | ✏️ |
| 3 | UNIT_TYPE - Unit type | VOLUME | Volume | ปริมาตร | — | 3 | Active | ✏️ |
| 4 | UNIT_TYPE - Unit type | AREA | Area | พื้นที่ | — | 4 | Active | ✏️ |
| 5 | UNIT_TYPE - Unit type | COUNT | Count | จำนวนนับ | — | 5 | Active | ✏️ |
| 6 | UNIT_TYPE - Unit type | TIME | Time | เวลา | — | 6 | Active | ✏️ |
| 7 | HOLIDAY_TYPE - Holiday type | PUBLIC | Public holiday | วันหยุดราชการ | #dc2626 | 1 | Active | ✏️ |
| 8 | HOLIDAY_TYPE - Holiday type | SUBSTITUTE | Substitution day | วันหยุดชดเชย | #f97316 | 2 | Active | ✏️ |
| 9 | HOLIDAY_TYPE - Holiday type | COMPANY | Company holiday | วันหยุดบริษัท | #2563eb | 3 | Active | ✏️ |
| 10 | TAX_TYPE - Tax type | VAT | Value added tax | ภาษีมูลค่าเพิ่ม | — | 1 | Active | ✏️ |
| 11 | TAX_TYPE - Tax type | WHT | Withholding tax | ภาษีหัก ณ ที่จ่าย | — | 2 | Active | ✏️ |
| 12 | TAX_TYPE - Tax type | EXCISE | Excise tax | ภาษีสรรพสามิต | — | 3 | Active | ✏️ |
| 13 | TH_REGION - Thai region | CENTRAL | Central | ภาคกลาง | — | 1 | Active | ✏️ |
| 14 | TH_REGION - Thai region | NORTH | North | ภาคเหนือ | — | 2 | Active | ✏️ |
| 15 | TH_REGION - Thai region | NORTHEAST | Northeast | ภาคตะวันออกเฉียงเหนือ | — | 3 | Active | ✏️ |
Showing 1–15 of 43
🎓 Learn: how this master is built table lookup_value
Key points
- UNIQUE (lookup_type_id, code): the same code may exist in different types.
Code
- Entity
domain/LookupValue.java- Repository
repo/LookupValueRepository.java- Definition
MasterRegistry: "lookup-values"- Page / form
web/MasterController.java- Try-it panel
templates/tools/lookup-overview.html- REST API
GET /api/lookups/GENDER
SQL to try in SSMS (database MasterDataLabDB)
SELECT * FROM lookup_value WHERE lookup_type_id = (SELECT id FROM lookup_type WHERE code = 'GENDER');