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