| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TOUR_SCENARIO | DSD CN: DSD Tour Scenario | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | CO_MAT | Check out material | char | 1 | 0 | | | | Allow NULL? |
| 5 | CO_PAYMENT | Check out payment | char | 1 | 0 | | | | Allow NULL? |
| 6 | CI_MAT | Check in material | char | 1 | 0 | | | | Allow NULL? |
| 7 | CI_PAYMENT | Check in payment | char | 1 | 0 | | | | Allow NULL? |
| 8 | SALES_ORDER | Sales order | char | 1 | 0 | | | | Allow NULL? |
| 9 | RETURN_ORDER | Return order | char | 1 | 0 | | | | Allow NULL? |
| 10 | FREE_ORDER | Free Order | char | 1 | 0 | | | | Allow NULL? |
| 11 | DELIVERY | Delivery | char | 1 | 0 | | | | Allow NULL? |
| 12 | RETURN_DELV | Return Delivery | char | 1 | 0 | | | | Allow NULL? |
| 13 | FREE_DELV | Free of charge delivery | char | 1 | 0 | | | | Allow NULL? |
| 14 | CREDIT_CHECK | Credit Check | char | 1 | 0 | | | | Allow NULL? |
| 15 | EXPENSE | Expense | char | 1 | 0 | | | | Allow NULL? |
| 16 | HH_COLLECTION | Collection | char | 1 | 0 | | | | Allow NULL? |
| 17 | INVENTORY_ADJ | Inventory adjustment | char | 1 | 0 | | | | Allow NULL? |
| 18 | END_ODOMETER | Odometer reading at end of tour | char | 1 | 0 | | | | Allow NULL? |
| 19 | EXTFLD1 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 20 | EXTFLD2 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 21 | EXTFLD3 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 22 | EXTFLD4 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 23 | EXTFLD5 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 24 | EXTFLD6 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 25 | EXTFLD7 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 26 | EXTFLD8 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 27 | EXTFLD9 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 28 | EXTFLD10 | Exention Field for Tour Scenarion Customizing | char | 1 | 0 | | | | Allow NULL? |
| 29 | RELOAD | Reload Process | char | 1 | 0 | | | | Allow NULL? |
| 30 | BARCODE | Barcode support | char | 1 | 0 | | | | Allow NULL? |
