| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40350 | Preference Profiles - Conatiner Deposit/Rental | 17 | OQ | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 2 | F4101 | Item Master | 85 | IM | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| 3 | F4101A | Item File | 56 | IM | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| 4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 100 | SZ | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| 5 | F4102 | Item Branch File | 73 | IB | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| 6 | F41UI001 | Inventory Transactions Detail File | 86 | IT | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| TOP41F: Apparel Management |
| 7 | FCW09 | Item Revisions Work File | 14 | WR | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| 8 | FCW10 | Item Branch Work File | 17 | WB | SRNR | Serial Number Required | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 9 | F43121Z | Receiver workfile | 36 | PW | SRNR | Serial Number Required | 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 H41 / NR (Serial Number Required) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Serial Number Not Required | | N |
| 2 | 3 | Supplier Lot Required | | N |
| 3 | 4 | Supplier Lot, Memo Lot 1 Req | | N |
| 4 | 5 | Supplier Lot, Memo Lot 1 & 2 | | N |
| 5 | 6 | S&WM Non-Serialized Item | | Y |
| 6 | N | Serial Number Not Required | | N |
| 7 | Y | Serial Number Required | | N |
