| 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 | T000 | MANDT | Allow NULL? |
| 2 | CORDTYPID | IS-H: CORD/PREG: Identification of the Clinical Order Type | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N1COTID | Allow NULL? |
| 3 | LTDTR | IS-H: CORD/PREG: CORD Type: Order Fillers Restricted | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTLTDTR | Allow NULL? |
| 4 | LTDAV | IS-H: CORD/PREG: Clincical Order Type - Initiator Restricted | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTLTDAV | Allow NULL? |
| 5 | EXTGPA | IS-H: CORD/PREG: CORD Type - External Bus. Partner Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTEXTGPA | Allow NULL? |
| 6 | AVLWEB | IS-H: CORD/PREG: Clin. Order Type is Available in Internet | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTAVLWEB | Allow NULL? |
| 7 | FALAR | CORD/PREG: Clinical Order Type: Default Case Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTFALAR | Allow NULL? |
| 8 | CORDTPR | IS-H: CORD/PREG: CORD Type: Profile Type Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTPR | Allow NULL? |
| 9 | PREREG | Is-H: CORD/PREG: Clinical Order Item of Type "Preregistered" | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTPREREG | Allow NULL? |
| 10 | WLSTA | IS-H: CORD/PREG: CORD Type - Default Waiting List Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN42C | N1COTWLSTA | Allow NULL? |
| 11 | WLTYP | IS-H: CORD/PREG: CORD Type - Default Waiting List | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN42A | N1COTWLTYP | Allow NULL? |
| 12 | CASEOBL | IS-H: CORD/PREG: Clinical Order Type - Case Mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTCASEOBL | Allow NULL? |
| 13 | BEWTY | CORD/PREG: Clinical Order Type - Movement Category | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTBEWTY | Allow NULL? |
| 14 | BEGDT | IS-H: CORD/PREG: Clinical Order Type - Validity Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1COTBEGDT | Allow NULL? |
| 15 | ENDDT | IS-H: CORD/PREG: Clinical Order Type - Validity End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1COTENDDT | Allow NULL? |
| 16 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 17 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 18 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 19 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 20 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 21 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 22 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 23 | REQCOMP | IS-H: Equivalent Request Type (Migration) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | N1COTREQCOMP | Allow NULL? |
| 24 | CYINAC | ISHMED: Cycle Input Active | char | 1 | 0 | CHAR | (N' ') | Yes | | N1CCYINAC | Allow NULL? |
| 25 | STDCORDTYP | IS-H: CORD/PREG: Indicator for Standard Order Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1CORDSTDCORDTYP | Allow NULL? |
