| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVCMIS_U_PLIST | CMIS Upg: Piece list administration | 5 | CRE_DATE | Date | nvarchar | 8 | 0 | | |
2 | CNVMBTDELPARAMS | Parameter for the generic deletion program | 15 | CRE_DATE | Date | nvarchar | 8 | 0 | | |
3 | CNVMBTDELREFTECH | Technical info about the reorganization like job and log | 8 | CRE_DATE | Modification date | nvarchar | 8 | 0 | | |
4 | MSPT_OIGS | TD Shipment Header to store deleted records | 62 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
5 | MSPT_OIGSI | Shipment Item to store deleted records | 8 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
TOPBusiness Service Functions |
6 | RTXTH | Header Table for Report Texts | 8 | CRE_DATE | | nvarchar | 8 | 0 | | |
TOPData Transfer |
7 | KCD_TYVPES_ADM | Ext. Data Transfer: Creation Date of Entries in KCD_TYVPES | 3 | CRE_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
TOPDownstream |
8 | OIGSJ1BH | Brazilian Taxes for Delivery Header | 9 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
9 | OIGSJ1BI | Brazilian Taxes for Delivery Item | 11 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
TOPEnd User Technology |
10 | RSRA_BP_RTXTH | Report Agent BP Transport Copy/Versioning of rtxth | 8 | CRE_DATE | | nvarchar | 8 | 0 | | |
TOPKANBAN |
11 | PKHD | Control Cycle | 56 | CRE_DATE | Creation Date of Control Cycle | nvarchar | 8 | 0 | | |
TOPRemote Logistics Management |
12 | OIO_VMIS_RESC | RLM VMIS: Rescue Material on Vehicle | 4 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
TOPTariffs, Duties and Permits |
13 | OIH_J1B_TCH | Tax Calculation Commands Header | 7 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
TOPTraders and Schedulers Workbench |
14 | OIGCC | TD Compartment | 12 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
15 | OIGCCMA | Compartment Meter Assignment Table | 6 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
16 | OIGCM | TD Vehicle Meter | 12 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
17 | OIGCMA | TD Transport Unit Meter Assignment | 6 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
18 | OIGSV | TD Vehicles in Transport/Shipment | 61 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
19 | OIGV | TD Vehicle Header | 51 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
20 | OIGVTU | TD Vehicle - Transport Unit Assignment | 5 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
21 | OIJEC | TD-Transport Unit Master Data Events | 20 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
22 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 23 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
23 | OIJNE | Nomination Events | 22 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
24 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 20 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
25 | OIJ_STAGES | TSW (&TD) Shipment Stages | 9 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
TOPTransport Organizer |
26 | E070CREATE | Change & Transport System: Creation Date of Request | 2 | CRE_DATE | Date of Last Change | nvarchar | 8 | 0 | | |
TOPTransportation and Distribution |
27 | OIGC | TD Transport unit | 22 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
28 | OIGD | TD Driver | 8 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
29 | OIGDH | TD Driver Shift | 6 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
30 | OIGDL | TD Driver's license data | 7 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
31 | OIGRM | TD Rack Meter Master Table | 17 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
32 | OIGRMM | TD Rack Meter / Material Assignment | 4 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
33 | OIGRMPS | TD Rack Meter / Storage Location Assignment | 5 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
34 | OIGS | TD Shipment Header | 62 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
35 | OIGSE | TD Events | 19 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
36 | OIGSH | TD Shipment History | 15 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
37 | OIGSI | Shipment Item | 8 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
38 | OIGSM | TD Material Allocated to a Shipment | 18 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
39 | OIGSMS | TD Material Samples on a Shipment | 10 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
40 | OIGSMV | TD Material Balance on Vehicle | 12 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
41 | OIGSS | TD Shipment Stages | 9 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
42 | OIGSVC | TD Transport Unit in Shipment | 21 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
43 | OIGSVCC | TD Compartment in Shipment | 13 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
44 | OIGSVCS | TD Vehicle Seals on Transport Units | 9 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
45 | OIGSVD | TD Driver per Vehicle on a Shipment | 6 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
46 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 27 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
47 | OIGSVMQM | TD On Board Movements References | 10 | CRE_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | |
48 | OIGVL | TD Licenses Needed for Vehicle | 4 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |
49 | TOIGUS | TD - User Screens for Master Data | 9 | CRE_DATE | Created On | nvarchar | 8 | 0 | | |