| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTraders and Schedulers Workbench |
1 | OIGCC | TD Compartment | 4 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
2 | OIGVTU | TD Vehicle - Transport Unit Assignment | 4 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
3 | OIJHUOM | OIL-TSW: Ticket additional units of measure | 6 | SEQ_NMBR | TSW: Sequence number | nvarchar | 5 | 0 | | |
4 | OIJ_EL_DOC_FLOW | OIL TSW: Document flow | 6 | SEQ_NMBR | TSW: Sequence number | nvarchar | 5 | 0 | | |
5 | OIJ_EL_ERROR_LOG | OIL-TSW: Error log for ticketing process | 6 | SEQ_NMBR | TSW: Sequence number | nvarchar | 5 | 0 | | |
6 | OIJ_EL_TCKET_UOM | Universal ticket additional units of measure | 4 | SEQ_NMBR | TSW: Sequence number | nvarchar | 5 | 0 | | |
TOPTransportation and Distribution |
7 | OIGSMS | TD Material Samples on a Shipment | 8 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
8 | OIGSVCC | TD Compartment in Shipment | 6 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
9 | OIGSVCS | TD Vehicle Seals on Transport Units | 7 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
10 | OIGSVMQ | TD Quantity Item for Material on Vehicle | 9 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |
11 | OIGSVMQM | TD On Board Movements References | 6 | SEQ_NMBR | TD master data sequence number | nvarchar | 3 | 0 | | |