| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TOUR_ID | DSD Connecter: Tour ID | nvarchar | 11 | 0 | CHAR | (N' ') | No | | /DSD/ME_TOURID | Allow NULL? |
| 3 | SHIP_TYPE | DSD Connector: Shipment Type (Doc Type) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_SHIPTYP | Allow NULL? |
| 4 | DOC_TYPE | DSD Connector: Document Type (BAPI) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_DOCTYPE | Allow NULL? |
| 5 | DRIVER_ID1 | DSD Connector: Driver | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_DRIVER | Allow NULL? |
| 6 | DRIVER_ID2 | DSD Connector: Driver | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_DRIVER | Allow NULL? |
| 7 | CARRIER | DSD Connector: Carrier ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_CARRIER | Allow NULL? |
| 8 | VEHICLE_ID | DSD Connector: Vehicle ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_VEHICLE | Allow NULL? |
| 9 | TRAILER_ID | DSD Connector: Trailer ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_TRAILERID | Allow NULL? |
| 10 | ROUTE | DSD Connector: Route ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_ROUTE | Allow NULL? |
| 11 | ROUTE_DESC | DSD Connector: Description 40 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_DESC40 | Allow NULL? |
| 12 | DISTANCE | DSD Connector: Distance | decimal | 6 | 0 | DEC | ((0)) | Yes | | /DSD/ME_DISTANCE | |
| 13 | BEG_MILE | DSD Connector: Begin Mile | decimal | 8 | 0 | DEC | ((0)) | Yes | | /DSD/ME_BEGMILE | |
| 14 | END_MILE | DSD Connector: End Mile | decimal | 8 | 0 | DEC | ((0)) | Yes | | /DSD/ME_ENDMILE | |
| 15 | PSTART_DATE | DSD Connector: Planned Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /DSD/ME_PSDATE | Allow NULL? |
| 16 | PSTART_TIME | DSD Connector: Planned Start Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /DSD/ME_PSTIME | Allow NULL? |
| 17 | PEND_DATE | DSD Connector: Planned End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /DSD/ME_PEDATE | Allow NULL? |
| 18 | PEND_TIME | DSD Connector: Planned End Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /DSD/ME_PETIME | Allow NULL? |
| 19 | ASTART_DATE | DSD Connector: Actual Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /DSD/ME_ASDATE | Allow NULL? |
| 20 | ASTART_TIME | DSD Connector: Actual Start Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /DSD/ME_ASTIME | Allow NULL? |
| 21 | AEND_DATE | DSD Connector: Actual End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /DSD/ME_AEDATE | Allow NULL? |
| 22 | AEND_TIME | DSD Connector: Actual End Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /DSD/ME_AETIME | Allow NULL? |
| 23 | TOUR_STAT | DSD Connector: Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_STAT | Allow NULL? |
| 24 | ME_ACTION | DSD Connector: Action Flag for ME | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_ACTION | Allow NULL? |
| 25 | DRIVER_NAME1 | DSD Connector: Driver Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_DRIVER_NAME | Allow NULL? |
| 26 | EXTI1 | DSD Connector: External Identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_EXTI | Allow NULL? |
| 27 | UPLOADED | DSD Connector: Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/ME_STAT | Allow NULL? |
| 28 | SUPPLIER_GLN | International Location Number(GLN) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | EANE_ILN | Allow NULL? |
