| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP41: Inventory Management |
| 1 | F4101 | Item Master | 68 | IM | STDG | Standard Grade | String | UDC | 3 | 0 |
| 2 | F4101M | Item Manufacturing Data | 42 | IM | STDG | Standard Grade | String | UDC | 3 | 0 |
| 3 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 83 | SZ | STDG | Standard Grade | String | UDC | 3 | 0 |
| 4 | F4102 | Item Branch File | 49 | IB | STDG | Standard Grade | String | UDC | 3 | 0 |
| 5 | F41UI001 | Inventory Transactions Detail File | 115 | IT | STDG | Standard Grade | String | UDC | 3 | 0 |
| TOP47: Electronic Commerce |
| 6 | F47082 | EDI Price Sales Catalog Detail - Inbound | 50 | FY | STDG | Standard Grade | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40 / LG (Lot Grade) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Not Graded | | N |
| 2 | #1 | Premium Grade | | N |
| 3 | #2 | Average Grade | | N |
| 4 | #3 | Economy Grade | | N |
| 5 | 1 | Tolerance 1 | | N |
| 6 | 2 | Tolerance 2 | | N |
| 7 | 3 | Tolerance 3 | | N |
| 8 | 554 | Light Shade | | N |
| 9 | 555 | Standard Shade | | N |
| 10 | 556 | Dark Shade | | N |
| 11 | A | Clear (no knots, smooth) | | N |
| 12 | A01 | Food Grade | | N |
| 13 | A02 | High Quality Food Grade | | N |
| 14 | A03 | Premium Quality Food Grade | | N |
| 15 | A04 | Non-Food Grade | | N |
| 16 | A05 | Fifth Grade | | N |
| 17 | A06 | Sixth Grade | | N |
| 18 | B | Second Clear (tight knots) | | N |
| 19 | C | Rough (sawn texture) | | N |
