| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | TMS_C_TRA | Ext. Transport Manag.: Determination of Transfer Relev. TRA | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPConditions |
| 2 | A805 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 3 | A810 | ShipmntTyp/ServcAgent/TfZn P.Dep/Tf zn.dest/FreightCl. | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 4 | A815 | ShipmntTyp/ServcAgent/TfZn P.Dep/FreightCl. | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 5 | A816 | ShipmntTyp/ServcAgent/TargPostCd | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 6 | A817 | ShipmntTyp/ServcAgent/TargPostCd/FreightCl. | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 7 | A818 | ShipmntTyp/ServcAgent/DepPostCde | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 8 | A819 | ShipmntTyp/ServcAgent/DepPostCde/FreightCl. | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 9 | B017 | Transport Type | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 10 | B022 | TrspPlPoint and Shipment Type | 5 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPDangerous Goods Management |
| 11 | TDGB7 | DG: Assign DG check schemata for transport documents | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPData Collection |
| 12 | S050 | Shipment | 9 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 13 | S050E | S050 - Structural Information | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 14 | S051 | Shipment routes | 9 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 15 | S051E | S051 - Structural Information | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 16 | S052 | Means of transportation | 9 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 17 | S052E | S052 - Structural Information | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 18 | S054 | Stages of shipment | 9 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 19 | S054E | S054 - Structural Information | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 20 | S055 | Shipment: materials | 9 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 21 | S055E | S055 - Structural Information | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPDirect Store Delivery |
| 22 | /DSD/C_OC_PRCDEF | Def. of Sales Doc. Type & Item Usage for Price Determination | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPDownloadUpload |
| 23 | /DSD/HH_DRVTXT | DSD: Download HH - Driver Messages | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 24 | /DSD/HH_TRADAT | DSD: Download HH - Volume of the Transferred Shipment Data | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPDSD Connector |
| 25 | /DSD/ME_ES_CUST | DSD CN: Assign signer role and sequence to documents | 3 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | |
| 26 | /DSD/ME_TOUR_SCN | Tour Scenario Settings for Mobile Devices | 3 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | |
| 27 | /DSD/ME_TOUR_SHP | DSD CN: Assignment of Shipment Types to DSD Tour Scenarios | 3 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | |
| TOPFreight Processing |
| 28 | TVFAP | Shipment Cost Information Profile Data | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPGoods Receipt Process |
| 29 | BORRTTS | Route schedule header (new) | 11 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPInterface to Terminal Automation System |
| 30 | OIKEDPP1 | OIL-TPI: Configuration data for EDP logical system | 5 | SHTYP | OIL-TPI: Default Bulk Shipment Type for Inbound Shipments | nvarchar | 4 | 0 | | |
| 31 | OIKTTDS | OIL-TPI: Transportation planning point additional data | 4 | SHTYP | OIL-TPI: Default Bulk Shipment Type for Inbound Shipments | nvarchar | 4 | 0 | | |
| TOPLoading Units |
| 32 | /BEV1/LUT907 | Shipment Types for which Load. Unit Determination Is Allowed | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 33 | /BEV1/LUTT | LU: Permitted Document Types Transport | 5 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPLogistics - General |
| 34 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 29 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPPicking |
| 35 | /VSO/P_HU_CREATE | Control Automatic Creation of Handling Units (VSO) | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 36 | /BEV1/RSCOBART | Difference Document Types for Check-Out | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 37 | /BEV1/RSZABSTA | Route Settlement - Permiss. Settlem. Types per Shipment Type | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 38 | /DSD/LD_CR_STAT | DSD - LD: Load Delivery Shipment Status | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 39 | /DSD/LD_DFTVAL | DSD - LD: Load Delivery Standard Value | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPRemote Logistics Management |
| 40 | OIO_SH_VGTYP | Voyage types | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPRoute Settlement |
| 41 | /DSD/SL_ASL_EXCL | DSD: Control of Automatic Settlement | 7 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 42 | /DSD/SL_TGFIND | DSD Settlement: Tolerance Group Determination | 5 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | |
| 43 | /DSD/SL_TGSEARCH | DSD Settlement: Tolerance Group Search Criteria | 6 | SHTYP | Specific Shipment Type Seach for Tolerance Grp Determination | nvarchar | 1 | 0 | | |
| 44 | /DSD/SL_TSLTYASM | DSD Route Settlement: Settlement Type Determ. for Shipments | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPTour Status |
| 45 | /DSD/ST_CSCEN_SH | Assignment shipment <-> delivery scenario | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 46 | /DSD/ST_CTYPE_SH | Shipment relevant for DSD | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 47 | /DSD/ST_STATUS | Current tour status | 11 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 48 | OIJNOMH | Nomination Header | 26 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 49 | OIJNOMHVERS | Nomination Header Version Table | 28 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 50 | OIJ_EL_TICKET_I | Universal ticket item table | 87 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 51 | OIJ_SCHED | Planned Schedule Lines | 34 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPTransportation |
| 52 | B045 | Shipment Type/Transportation Service Agent | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 53 | TVARS | Archiving Control Shipment | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 54 | TVTK | Shipment Types | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 55 | TVTKT | Transport Type: Description | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 56 | TVT_CA_SDELI_R | Restriction of Fwdg Agent Selection Variants for Deliveries | 3 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 57 | TVT_CA_TRA | Transportation Basis Data for Forwarding Agent | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 58 | VTCFPP | Freight Planning Transfer Profile | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 59 | VTDSTC | Condition of Deliveries for Freight Planning by Fwdng Agent | 23 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| 60 | VTTK | Shipment Header | 4 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPTransportation and Distribution |
| 61 | TOIGS | TD Shipment Types | 2 | SHTYP | TD shipment type | nvarchar | 4 | 0 | | |
| 62 | TOIGST | TD Shipment Type Description | 3 | SHTYP | TD shipment type | nvarchar | 4 | 0 | | |
| 63 | TOIGTXT | Default Texts For Shipment Header | 4 | SHTYP | TD shipment type | nvarchar | 4 | 0 | | |
| TOPTransportation Planning |
| 64 | /DSD/RP_SHP_NOSA | Shipment Type without Single Sales Area Check | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
| TOPVisit Control |
| 65 | /DSD/VC_V7_PRN | DSD: Message Types for Print Output for Shipment | 2 | SHTYP | Shipment type | nvarchar | 4 | 0 | | |
