| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F41011 | Bulk Item Master | 37 | PK | RTOB | Reconcile | Character | UDC | 1 | 0 |
| 2 | F41022 | Bulk Depot/Product Information | 24 | PN | RTOB | Reconcile | Character | UDC | 1 | 0 |
| 3 | F41500 | Tank Master File | 50 | PP | RTOB | Reconcile | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 4 | F4101B | Item Master Bulk Data | 45 | IM | RTOB | Reconcile | Character | UDC | 1 | 0 |
| 5 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 65 | SZ | RTOB | Reconcile | 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 41B / RF (Reconcile Flag) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0 | Do Not Reconcile | | N |
| 2 | 1 | Throughput Reconciliation | | N |
| 3 | 2 | Operational Reconciliation | | N |
| 4 | 3 | Both Reconciliations | | N |
| 5 | B | Both Reconciliations | | N |
| 6 | N | Do Not Reconcile | | N |
| 7 | O | Operational Reconciliation | | N |
| 8 | T | Throughput Reconciliation | | N |
