| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPExchanges |
| 1 | OIA12 | Exchange assignment for bulk shipments | 2 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| TOPInterface to Terminal Automation System |
| 2 | OIK02B | IS-OIL/TAS: Status of processed functions - messages | 20 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 3 | OIK29 | IS-OIL/TPI: Status of processed inbound IDoc OILSHI01 | 8 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 4 | OIK29C | IS-OIL/TPI: Status of processed functions - messages | 19 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 5 | OIK29D | IS-OIL/TPI: Status of processed inbound IDoc OILSHI01 | 9 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 6 | OIJNOMC | OIL-TSW: Nomination copy table | 36 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 7 | OIJNOMH | Nomination Header | 49 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 8 | OIJNOMI | Nomination Item | 36 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 9 | OIJNOMIVERS | Nomination Item Version Table | 38 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
| 10 | OIJNOM_FIELDST | Nomination field status locking | 6 | SHNUM | Boolean Variable (X=True, -=False, Space=Unknown) | nvarchar | 1 | 0 | | |
| 11 | OIJ_SCHED | Planned Schedule Lines | 87 | SHNUM | TD shipment number | nvarchar | 10 | 0 | | |
