| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP41: Inventory Management |
| 1 | F4101 | Item Master | 62 | IM | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 2 | F4101A | Item File | 41 | IM | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 3 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 77 | SZ | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 4 | F4102 | Item Branch File | 42 | IB | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 5 | F41UI001 | Inventory Transactions Detail File | 126 | IT | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| TOP41F: Apparel Management |
| 6 | FCW09 | Item Revisions Work File | 22 | WR | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 7 | FCW10 | Item Branch Work File | 15 | WB | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| TOPH91: Design Tools |
| 8 | F98TC002 | Table Conversion Normalized 1 | 4 | TN | SRCE | Layer Code - Source | Character | UDC | 1 | 0 |
| 9 | F98TC01 | Table Conversion UnNormalized | 6 | TC | SRCE | Layer Code - Source | 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 / SR (Lot Source Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Lots are Optional | | N |
| 2 | 0 | Lots are Optional | | N |
| 3 | 1 | Lots Assigned using Date | | N |
| 4 | 2 | Lots Assigned with Next Number | | N |
| 5 | 3 | Lots must be Assigned Manually | | N |
| 6 | 4 | Serial No Optional | | N |
| 7 | 5 | Serial No Assigned Using Date | | N |
| 8 | 6 | Serial No Assign with Next No | | N |
| 9 | 7 | Serial No Assigned Manually | | N |
