| 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 | CORDTAVID | IS-H: CORD/PREG: ID of Order Type-to-Initiator Assignment | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N1COTAVID | Allow NULL? |
| 3 | TYPE | IS-H: CORD/PREG: Type of Initiator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTAVTYP | Allow NULL? |
| 4 | GPART | IS-H: CORD/PREG: Initiating Business Partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | N1COTAVGPART | Allow NULL? |
| 5 | ORGID | IS-H: Initiating Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | N1COTAVORGID | Allow NULL? |
| 6 | CORDTYPID | IS-H: CORD/PREG: Identification of the Clinical Order Type | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | N1CORDTYP | N1COTID | Allow NULL? |
| 7 | BEGDT | IS-H: CORD/PREG: CORD Type-to-Initiator Asgmt Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1COTAVBEGDT | Allow NULL? |
| 8 | ENDDT | IS-H: CORD/PREG: CORD Type-to-Initiator Asgmt Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1COTAVENDDT | Allow NULL? |
| 9 | PRIO | Is-H: CORD/PREG: Priority of CORD Type-to-Initiator Asgmt | decimal | 3 | 0 | DEC | ((0)) | Yes | | N1COTAVPRIO | |
| 10 | HITLS | Restrict Services to Hit List | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTAVHITLS | Allow NULL? |
| 11 | SCHED | Appointment Allocation Order Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N1COTAVSCHED | Allow NULL? |