| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | QMNUM | Notification No | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | IO_EINHEIT | Installation Point: Unit | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | IO_ANSPAR | Installation Point: Contact Person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 5 | IO_PLZORT | Installation Point: Postal Code, City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 6 | IO_STRNR | Installation Point: Street, Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 7 | IO_STAAT | Installation Point: Country, State | nvarchar | 40 | 0 | | | | Allow NULL? |
| 8 | IO_SONSTG | Installation Point: Other Data | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | IO_TELNR | Installation Point: Telephone Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | IO_EMAIL | Installation Point: E-mail, Workflow | nvarchar | 40 | 0 | | | | Allow NULL? |
| 11 | IO_ALT | Geo location height | decimal | 9 | 3 | | | | |
| 12 | IO_WOKOOR | Geo location latitude | decimal | 15 | 12 | | | | |
| 13 | IO_SNKOOR | Geo location longitude | decimal | 15 | 12 | | | | |
| 14 | IO_BESANF | Installation Point, Detailed Information | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | IO_KOSYSTEM | Installation Point: Coordinate System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | TA_EINHEIT | Transportation Collection Point: Unit | nvarchar | 40 | 0 | | | | Allow NULL? |
| 17 | TA_ANSPAR | Transportation Collection Point: Contact Person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 18 | TA_PLZORT | Transportation Collection Point: Postal Code, City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 19 | TA_STRNR | Transportation Collection Point: Street, Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 20 | TA_STAAT | Transportation Collection Point: Country, State | nvarchar | 40 | 0 | | | | Allow NULL? |
| 21 | TA_SONSTG | Transportation Collection Point: Other Data | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | TA_TELNR | Transportation Collection Point: Telephone Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 23 | TA_EMAIL | Transportation Collection Point: E-mail, Workflow | nvarchar | 40 | 0 | | | | Allow NULL? |
| 24 | TA_ALT | Geo location height | decimal | 9 | 3 | | | | |
| 25 | TA_WOKOOR | Geo location latitude | decimal | 15 | 12 | | | | |
| 26 | TA_SNKOOR | Geo location longitude | decimal | 15 | 12 | | | | |
| 27 | TA_BESANF | Transportation Collection Point: Detailed Information | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | TA_KOSYSTEM | Transportation Collection Point: Coordinate System | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | TZ_EINHEIT | Transportation Destination Point: Unit | nvarchar | 40 | 0 | | | | Allow NULL? |
| 30 | TZ_ANSPAR | Transportation Destination Point: Contact Person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 31 | TZ_PLZORT | Transportation Destination Point: Postal Code, City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 32 | TZ_STRNR | Transportation Destination Point: Street, Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 33 | TZ_STAAT | Transportation Destination Point: Country, State | nvarchar | 40 | 0 | | | | Allow NULL? |
| 34 | TZ_SONSTG | Transportation Destination Point: Other Data | nvarchar | 40 | 0 | | | | Allow NULL? |
| 35 | TZ_TELNR | Transportation Destination Point: Telephone Number | nvarchar | 40 | 0 | | | | Allow NULL? |
| 36 | TZ_EMAIL | Transportation Destination Point: E-mail, Workflow | nvarchar | 40 | 0 | | | | Allow NULL? |
| 37 | TZ_ALT | Geo location height | decimal | 9 | 3 | | | | |
| 38 | TZ_WOKOOR | Geo location latitude | decimal | 15 | 12 | | | | |
| 39 | TZ_SNKOOR | Geo location longitude | decimal | 15 | 12 | | | | |
| 40 | TZ_BESANF | Transportation Destination Point: Detailed Information | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | TZ_KOSYSTEM | Transportation Destination Point: Coordinate System | nvarchar | 3 | 0 | | | | Allow NULL? |