| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | CTRID | ID of Transport Order Data of Order Item | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N1CTRID | Allow NULL? |
| 3 | ORGFD | OU of the Patient Transport Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1ORGFD | Allow NULL? |
| 4 | TPAE | Transport Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | N1TPAE | Allow NULL? |
| 5 | ORGAG | Pick-Up OU (OU where Pick-Up Takes Place) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1ORGAG | Allow NULL? |
| 6 | BAUAG | Pick-up Room for a Transport Order | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1BAUAG | Allow NULL? |
| 7 | ORGZL | Destination Org. Unit (Drop-Off) for Transport Order | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1ORGZL | Allow NULL? |
| 8 | BAUZL | Destination (Drop-off) Room for a Transport Order | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1BAUZL | Allow NULL? |
| 9 | TPTYP | Transport Category | char | 1 | 0 | NUMC | (N'0') | Yes | | N1TPTYP | Allow NULL? |
| 10 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 11 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 12 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 13 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 14 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 15 | TRANS | Means of Transport | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1TRANS | N1TRANSP | Allow NULL? |
| 16 | TRAVA | Means of Transport Is Available | char | 1 | 0 | CHAR | (N' ') | Yes | | N1TRANSP_AVAILABLE | Allow NULL? |
| 17 | TRDONE | Transport Request Completed for Dispatcher Work Station | char | 1 | 0 | CHAR | (N' ') | Yes | | N1TRDONE | Allow NULL? |
