| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F49211 | Sales Order Detail File - Tag File | 126 | UD | ACGD | Actual Grade | String | UDC | 3 | 0 |
2 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 145 | S1 | ACGD | Actual Grade | String | UDC | 3 | 0 |
3 | F49219 | Sales Order Detail - Tag History File | 103 | UD | ACGD | Actual Grade | String | UDC | 3 | 0 |
TOP42B: Sales Order Entry |
4 | F49299 | S.O. Detail Tag Ledger File | 126 | UD | ACGD | Actual Grade | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
5 | F470371 | EDI Shipping Notice Detail - Outbound | 63 | SZ | ACGD | Actual 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 |