| 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 | | |