| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDownstream |
1 | S036BIW1 | S036BIW1 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX | 13 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
2 | S036BIW2 | S036BIW2 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX | 13 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
TOPExchanges |
3 | OIA01 | Exchange header (IS-Oil EXG standard/core object) | 3 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
4 | OIA05H | Quantity schedule header table - sales side | 10 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
5 | OIA06H | Quantity schedule header table - purchasing side | 10 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
6 | OIA08 | LIA Document: Item Data | 7 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
7 | S036 | LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG) | 13 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
8 | S036SAVE | Table to use with Exchanges Reporting and Copy Management | 13 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
9 | TOIA2 | Exchange types | 2 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
10 | TOIA2T | Exchange types Texts | 3 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
TOPTraders and Schedulers Workbench |
11 | TOI0_REL_DOCS | Select document types for relevance assignment | 5 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |
12 | TOIJ_EL_MVSCEN | TSW: Define Movement scenarios | 12 | EXGTYP | Exchange type | nvarchar | 4 | 0 | | |