| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40G: Grower Management |
1 | F40G032 | Harvest Estimate Freeze Detail | 22 | FD | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
2 | F4101 | Item Master | 56 | IM | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
3 | F4101A | Item File | 36 | IM | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 71 | SZ | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
5 | F41UI001 | Inventory Transactions Detail File | 162 | IT | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
TOP41F: Apparel Management |
6 | FCW09 | Item Revisions Work File | 18 | WR | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
7 | FCW33 | Price List Header | 12 | PH | PLEV | Level - Sales Base Price | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC H40 / PL (Sales Base Price Level) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 1 | Item Only | | N |
2 | 2 | Item/Branch Only | | N |
3 | 3 | Item/Branch/Location/Lot | | N |