| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CTRID | ID of Transport Order Data of Order Item | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | ORGFD | OU of the Patient Transport Service | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | TPAE | Transport Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | ORGAG | Pick-Up OU (OU where Pick-Up Takes Place) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BAUAG | Pick-up Room for a Transport Order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ORGZL | Destination Org. Unit (Drop-Off) for Transport Order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | BAUZL | Destination (Drop-off) Room for a Transport Order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | TPTYP | Transport Category | char | 1 | 0 | | | | Allow NULL? |
| 10 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | TRANS | Means of Transport | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | TRAVA | Means of Transport Is Available | char | 1 | 0 | | | | Allow NULL? |
| 17 | TRDONE | Transport Request Completed for Dispatcher Work Station | char | 1 | 0 | | | | Allow NULL? |