| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVCMIS_U_PLIST | CMIS Upg: Piece list administration | 6 | CRE_TIME | Time | nvarchar | 6 | 0 | | |
2 | CNVMBTDELPARAMS | Parameter for the generic deletion program | 16 | CRE_TIME | Time | nvarchar | 6 | 0 | | |
3 | CNVMBTDELREFTECH | Technical info about the reorganization like job and log | 9 | CRE_TIME | Modification time | nvarchar | 6 | 0 | | |
4 | MSPT_OIGS | TD Shipment Header to store deleted records | 63 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
5 | MSPT_OIGSI | Shipment Item to store deleted records | 9 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
TOPBusiness Service Functions |
6 | RTXTH | Header Table for Report Texts | 9 | CRE_TIME | | nvarchar | 6 | 0 | | |
TOPDate Rules |
7 | TIMERULEH | Date Rules (Header) | 6 | CRE_TIME | Creation Time of Date Rule | decimal | 15 | 0 | | |
8 | TIMERUSH | Shadow Table for Transport Date Rule (Header) | 6 | CRE_TIME | Creation Time of Date Rule | decimal | 15 | 0 | | |
TOPDownstream |
9 | OIGSJ1BH | Brazilian Taxes for Delivery Header | 10 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
10 | OIGSJ1BI | Brazilian Taxes for Delivery Item | 12 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
TOPEnd User Technology |
11 | RSRA_BP_RTXTH | Report Agent BP Transport Copy/Versioning of rtxth | 9 | CRE_TIME | | nvarchar | 6 | 0 | | |
TOPTariffs, Duties and Permits |
12 | OIH_J1B_TCH | Tax Calculation Commands Header | 8 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
TOPTraders and Schedulers Workbench |
13 | OIGSV | TD Vehicles in Transport/Shipment | 63 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
14 | OIJEC | TD-Transport Unit Master Data Events | 21 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
15 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 24 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
16 | OIJNE | Nomination Events | 23 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
17 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 21 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
18 | OIJ_STAGES | TSW (&TD) Shipment Stages | 10 | CRE_TIME | Time of creation | nvarchar | 6 | 0 | | |
TOPTransport Organizer |
19 | E070CREATE | Change & Transport System: Creation Date of Request | 3 | CRE_TIME | Last changed at | nvarchar | 6 | 0 | | |
TOPTransportation and Distribution |
20 | OIGS | TD Shipment Header | 63 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
21 | OIGSE | TD Events | 20 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
22 | OIGSH | TD Shipment History | 17 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
23 | OIGSI | Shipment Item | 9 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
24 | OIGSM | TD Material Allocated to a Shipment | 19 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
25 | OIGSMS | TD Material Samples on a Shipment | 11 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
26 | OIGSMV | TD Material Balance on Vehicle | 13 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
27 | OIGSS | TD Shipment Stages | 10 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
28 | OIGSVC | TD Transport Unit in Shipment | 23 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
29 | OIGSVCC | TD Compartment in Shipment | 15 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
30 | OIGSVCS | TD Vehicle Seals on Transport Units | 10 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
31 | OIGSVD | TD Driver per Vehicle on a Shipment | 7 | CRE_TIME | Entry time | nvarchar | 6 | 0 | | |
32 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 28 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |
33 | OIGSVMQM | TD On Board Movements References | 11 | CRE_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | | |