| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_OIGS | Fill Header for Delivery Documents (IS-OIL) | 3 | SHNUMBER | TDMS for IS-OIL TD Shipment number | nvarchar | 10 | 0 | | |
2 | MSPT_OIGS | TD Shipment Header to store deleted records | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
3 | MSPT_OIGSI | Shipment Item to store deleted records | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
4 | WSPT_LIKP | Documents For Portugal Webservice | 24 | SHNUMBER | Shipping Document no for IS-OIL | nvarchar | 10 | 0 | | |
TOPDownstream |
5 | OIGSJ1BH | Brazilian Taxes for Delivery Header | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
6 | OIGSJ1BI | Brazilian Taxes for Delivery Item | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
TOPInterface to Terminal Automation System |
7 | OIK37 | IS OIL: Shadow table for SD document processing | 11 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
8 | OIKDCP | Delivery confirmation | 6 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
9 | OIKLOG01 | Log Table for Shipment planning | 1 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
10 | OIKSD | TAS/TPI: Shipment scheduling | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
11 | OIKTT | TPI:Trip planning times-for customer use (Enhancem.OIKSHPSV) | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
12 | OIGSV | TD Vehicles in Transport/Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
13 | TOIJ_SHCA | OIL-TSW: Shipment change authorization | 3 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
14 | OIGCMH | TD Transport Unit Meter History file | 9 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
15 | OIGFIIQ | TD-F Assignment of document quantities | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
16 | OIGFIIQS | TD-F assignment of quantities to stages | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
17 | OIGRMH | TD Rack Meter History file | 9 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
18 | OIGS | TD Shipment Header | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
19 | OIGSE | TD Events | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
20 | OIGSH | TD Shipment History | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
21 | OIGSI | Shipment Item | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
22 | OIGSM | TD Material Allocated to a Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
23 | OIGSMS | TD Material Samples on a Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
24 | OIGSMV | TD Material Balance on Vehicle | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
25 | OIGSS | TD Shipment Stages | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
26 | OIGSVC | TD Transport Unit in Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
27 | OIGSVCC | TD Compartment in Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
28 | OIGSVCS | TD Vehicle Seals on Transport Units | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
29 | OIGSVD | TD Driver per Vehicle on a Shipment | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
30 | OIGSVIIS | TD Shipment Assignment of Document Items to Stages | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
31 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
32 | OIGSVMQM | TD On Board Movements References | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
33 | OIGSVMQO1 | TD Quantity Item Calculation Parameters | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |
34 | OIGSVMQO2 | TD Quantity Item Additional Quantities | 2 | SHNUMBER | TD shipment number | nvarchar | 10 | 0 | | |