| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | MSPT_OIGS | TD Shipment Header to store deleted records | 66 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
2 | MSPT_OIGSI | Shipment Item to store deleted records | 12 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
TOPDate Rules |
3 | TIMERULEH | Date Rules (Header) | 8 | CHA_TIME | Last Change Time of Date Rule | decimal | 15 | 0 | | |
4 | TIMERUSH | Shadow Table for Transport Date Rule (Header) | 8 | CHA_TIME | Last Change Time of Date Rule | decimal | 15 | 0 | | |
TOPDownstream |
5 | OIGSJ1BH | Brazilian Taxes for Delivery Header | 13 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
6 | OIGSJ1BI | Brazilian Taxes for Delivery Item | 15 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
TOPRegulatory reporting for insurance companies |
7 | TISSR_CHA_MDATA | Aufzeichnung von Aktivitaeten zur Stammdatenaenderung | 5 | CHA_TIME | Systemzeit | nvarchar | 6 | 0 | | |
TOPTariffs, Duties and Permits |
8 | OIH_J1B_TCH | Tax Calculation Commands Header | 11 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
9 | OIH_J1B_TCHH | Tax Calculation Commands Header History | 8 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
TOPTraders and Schedulers Workbench |
10 | OIGSV | TD Vehicles in Transport/Shipment | 66 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
11 | OIJEC | TD-Transport Unit Master Data Events | 25 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
12 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 28 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
13 | OIJNE | Nomination Events | 26 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
14 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 24 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
15 | OIJ_STAGES | TSW (&TD) Shipment Stages | 13 | CHA_TIME | Time of day the record was changed | nvarchar | 6 | 0 | | |
TOPTranslation Tools |
16 | TRMIDX | Log Entries for TRM Processing Runs | 15 | CHA_TIME | Last changed at | nvarchar | 6 | 0 | | |
TOPTransportation and Distribution |
17 | OIGS | TD Shipment Header | 66 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
18 | OIGSE | TD Events | 23 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
19 | OIGSH | TD Shipment History | 20 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
20 | OIGSI | Shipment Item | 12 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
21 | OIGSM | TD Material Allocated to a Shipment | 22 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
22 | OIGSMS | TD Material Samples on a Shipment | 14 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
23 | OIGSMV | TD Material Balance on Vehicle | 16 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
24 | OIGSS | TD Shipment Stages | 13 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
25 | OIGSVC | TD Transport Unit in Shipment | 26 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
26 | OIGSVCC | TD Compartment in Shipment | 18 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
27 | OIGSVCS | TD Vehicle Seals on Transport Units | 13 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
28 | OIGSVD | TD Driver per Vehicle on a Shipment | 10 | CHA_TIME | Time last change was made | nvarchar | 6 | 0 | | |
29 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 31 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |
30 | OIGSVMQM | TD On Board Movements References | 14 | CHA_TIME | Time of Change | nvarchar | 6 | 0 | | |