| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F41022 | Bulk Depot/Product Information | 11 | PN | BCAT | Blend Categories | String | UDC | 3 | 0 |
| TOP41: Inventory Management |
| 2 | F4101B | Item Master Bulk Data | 42 | IM | BCAT | Blend Categories | String | UDC | 3 | 0 |
| 3 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 86 | SZ | BCAT | Blend Categories | String | UDC | 3 | 0 |
| TOP41B: Bulk Stock Management |
| 4 | F41501 | Blend Category File | 3 | PD | BCAT | Blend Categories | 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 41B / BC (Blend Categories) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | blank valid | | N |
| 2 | DYE | Dyed Oils | | N |
| 3 | GO | Gear Oils | | N |
| 4 | HYD | Hydraulic Oils | | N |
| 5 | IBB | Inline Blender-Base Oils | | N |
| 6 | IBF | Inline Blender-Finished Prod | | N |
| 7 | MAR | Marine Oils | | N |
| 8 | MOT | Motor Oils | | N |
