| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 40: Inventory/OP Base | ||||||||||
| 1 | F41011 | Bulk Item Master | 4 | PK | DNTB | Density Table | String | UDC | 4 | 0 |
| 41: Inventory Management | ||||||||||
| 2 | F4101B | Item Master Bulk Data | 11 | IM | DNTB | Density Table | String | UDC | 4 | 0 |
| 3 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 42 | SZ | DNTB | Density Table | String | UDC | 4 | 0 |
| 41B: Bulk Stock Management | ||||||||||
| 4 | F41012 | Conversion Table Interface File | 1 | VA | DNTB | Density Table | String | UDC | 4 | 0 |
| 41F: Apparel Management | ||||||||||
| 5 | FCW59 | Bulk Item Master (F41011) Work File | 6 | WF | DNTB | Density Table | 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 / DN (Density Table) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | No density table defined | N | ||
| 2 | 23A | Rel Density, 60 F - Gen Crude | Y | |
| 3 | 23B | Rel Density, 60 F - Gen Prod | Y | |
| 4 | 23D | Rel Density, 60 F - Gen Lube | Y | |
| 5 | 24C | Rel Density, 60F - Special App | Y | |
| 6 | 53A | Density KG/M3, 15 C -Gen Crude | Y | |
| 7 | 53B | Density KG/M3, 15 C - Gen Prod | Y | |
| 8 | 53D | Density, 15 C - Gen Lube Oils | Y | |
| 9 | 5A | API Gravity, 60 F - Gen Crude | Y | |
| 10 | 5B | API Gravity, 60 F - Gen Prod | Y | |
| 11 | 5D | API Gravity, 60 F - Gen Lube | Y | |
| 12 | BIT | KG/M3 Den 15C Bitumen/Asphalt | N | |
| 13 | LPG | LPG | Y |