| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_EXGNO | Fill Header for Material Documents (IS-OIL) | 3 | EXGNUM | Character 10 | nvarchar | 10 | 0 | | |
TOPDownstream |
2 | S036BIW1 | S036BIW1 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX | 14 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
3 | S036BIW2 | S036BIW2 * LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EX | 14 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
TOPExchanges |
4 | OIA01 | Exchange header (IS-Oil EXG standard/core object) | 2 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
5 | OIA02 | Exchange item data - sales side | 2 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
6 | OIA03 | Exchange item data - purchasing side | 2 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
7 | OIA08 | LIA Document: Item Data | 8 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
8 | OIA10E | Index table to find netting docs. by exchange number | 2 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
9 | S036 | LIS: Exchange balance 'Lifts/Receipts' (IS-Oil EXG) | 14 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |
10 | S036SAVE | Table to use with Exchanges Reporting and Copy Management | 14 | EXGNUM | Exchange agreement number | nvarchar | 10 | 0 | | |