| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MSPT_OIGS | TD Shipment Header to store deleted records | 65 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
2 | MSPT_OIGSI | Shipment Item to store deleted records | 11 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
TOPDownstream |
3 | OIGSJ1BH | Brazilian Taxes for Delivery Header | 12 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
4 | OIGSJ1BI | Brazilian Taxes for Delivery Item | 14 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
TOPRegulatory reporting for insurance companies |
5 | TISSR_CHA_MDATA | Aufzeichnung von Aktivitaeten zur Stammdatenaenderung | 4 | CHA_DATE | Datum | nvarchar | 8 | 0 | | |
TOPRemote Logistics Management |
6 | OIO_VMIS_RESC | RLM VMIS: Rescue Material on Vehicle | 6 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
TOPTariffs, Duties and Permits |
7 | OIH_J1B_TCH | Tax Calculation Commands Header | 10 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
8 | OIH_J1B_TCHH | Tax Calculation Commands Header History | 7 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
TOPTraders and Schedulers Workbench |
9 | OIGCC | TD Compartment | 14 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
10 | OIGCCMA | Compartment Meter Assignment Table | 8 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
11 | OIGCM | TD Vehicle Meter | 14 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
12 | OIGCMA | TD Transport Unit Meter Assignment | 8 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
13 | OIGSV | TD Vehicles in Transport/Shipment | 64 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
14 | OIGV | TD Vehicle Header | 53 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
15 | OIGVTU | TD Vehicle - Transport Unit Assignment | 7 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
16 | OIJEC | TD-Transport Unit Master Data Events | 24 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
17 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 27 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
18 | OIJNE | Nomination Events | 25 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
19 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 23 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
20 | OIJ_STAGES | TSW (&TD) Shipment Stages | 12 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
TOPTranslation Tools |
21 | TRMIDX | Log Entries for TRM Processing Runs | 14 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
TOPTransportation and Distribution |
22 | OIGC | TD Transport unit | 24 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
23 | OIGD | TD Driver | 10 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
24 | OIGDH | TD Driver Shift | 8 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
25 | OIGDL | TD Driver's license data | 9 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
26 | OIGRM | TD Rack Meter Master Table | 19 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
27 | OIGRMM | TD Rack Meter / Material Assignment | 6 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
28 | OIGRMPS | TD Rack Meter / Storage Location Assignment | 7 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
29 | OIGS | TD Shipment Header | 65 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
30 | OIGSE | TD Events | 22 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
31 | OIGSH | TD Shipment History | 18 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
32 | OIGSI | Shipment Item | 11 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
33 | OIGSM | TD Material Allocated to a Shipment | 21 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
34 | OIGSMS | TD Material Samples on a Shipment | 13 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
35 | OIGSMV | TD Material Balance on Vehicle | 15 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
36 | OIGSS | TD Shipment Stages | 12 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
37 | OIGSVC | TD Transport Unit in Shipment | 24 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
38 | OIGSVCC | TD Compartment in Shipment | 16 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
39 | OIGSVCS | TD Vehicle Seals on Transport Units | 12 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
40 | OIGSVD | TD Driver per Vehicle on a Shipment | 9 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
41 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 30 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
42 | OIGSVMQM | TD On Board Movements References | 13 | CHA_DATE | Changed On | nvarchar | 8 | 0 | | |
43 | OIGVL | TD Licenses Needed for Vehicle | 6 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
44 | TOIGUS | TD - User Screens for Master Data | 11 | CHA_DATE | Date of Last Change | nvarchar | 8 | 0 | | |