| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 31P: Engineer To Order | ||||||||||
| 1 | F31P10 | Project Quote Header | 15 | PQ | QTSU | Quote Status | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 31P / QP (Project Quote Status) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Q1 | Quote Pending | 1 | N |
| 2 | Q2 | Quote Active | 2 | N |
| 3 | Q3 | Quote Inactive | 3 | N |
| 4 | Q4 | Quote Current | 4 | N |
| 5 | Q5 | Quote Complete | 5 | N |