| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 40: Inventory/OP Base | ||||||||||
| 1 | F41011 | Bulk Item Master | 5 | PK | STCN | Standard Temp Conv Table For Inventory | String | UDC | 4 | 0 |
| 41: Inventory Management | ||||||||||
| 2 | F4101B | Item Master Bulk Data | 12 | IM | STCN | Standard Temp Conv Table For Inventory | String | UDC | 4 | 0 |
| 3 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 43 | SZ | STCN | Standard Temp Conv Table For Inventory | String | UDC | 4 | 0 |
| 41B: Bulk Stock Management | ||||||||||
| 4 | F41012 | Conversion Table Interface File | 9 | VA | STCN | Standard Temp Conv Table For Inventory | String | UDC | 4 | 0 |
| 41F: Apparel Management | ||||||||||
| 5 | FCW59 | Bulk Item Master (F41011) Work File | 7 | WF | STCN | Standard Temp Conv Table For Inventory | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 41B / TT (Temperature Conversion Table) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | No Specification | N | ||
| 2 | 24A | 60 F - Gen Crude Oil(Rel Dens) | Y | |
| 3 | 24B | 60 F - Gen Products (Rel Dens) | Y | |
| 4 | 24C | 60 F - Special Appl (Rel Dens) | Y | |
| 5 | 24D | 60 F - Gen Lube. Oil(Rel Dens) | Y | |
| 6 | 54A | 15 C - Gen Crude Oil(Den KG/M3 | Y | |
| 7 | 54B | 15 C - Gen Products (Den KG/M3 | Y | |
| 8 | 54C | 15 C - Special Applications | Y | |
| 9 | 54D | 15 C - Gen Lubricating Oils | Y | |
| 10 | 6A | 60F - Gen Crude Oil (API Grav) | Y | |
| 11 | 6B | 60 F - Gen Products (API Grav) | Y | |
| 12 | 6C | 60F - Special Appl (API Grav) | Y | |
| 13 | 6D | 60F - Gen Lube Oil (API Grav) | Y | |
| 14 | BIT | 15 C - Bitumen/Asphalt | Y | |
| 15 | LPG | LPG | Y |