| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | No | TNK01 | TARID | Allow NULL? |
| 4 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | No | NTPK | TARLS | Allow NULL? |
| 5 | APRI | Prioritization for Request/Movement (Internal) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1APRI_D | Allow NULL? |
| 6 | DAUER | IS-H*MED: Duration in Minutes | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1DAUER_MIN | Allow NULL? |
| 7 | IFG | Degree of Infection - Internal Format | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | N1IFG_INT | Allow NULL? |
| 8 | ANERF | Anesthetist Required (Master Data) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ANERFORD | Allow NULL? |
| 9 | PATEIN | Consent of Patient (for Master Data) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PATEIN2 | Allow NULL? |
| 10 | PATNUE | Patient Fasting Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PATNUE | Allow NULL? |
| 11 | LIDI | Position ID Internal | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1LID_INT | Allow NULL? |
| 12 | VORBZEIT | Preparation Time for a Service | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1VORBZEIT | Allow NULL? |
| 13 | NACHBZEIT | Clean-Up Time for a Service | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1NACHBZEIT | Allow NULL? |
| 14 | WLTYP | Waiting List Type | nvarchar | 6 | 0 | CHAR | (N' ') | No | | N1WLTYP | Allow NULL? |
| 15 | AZVKG | Number of Preregistrations Displayed | nvarchar | 2 | 0 | NUMC | (N'00') | No | | N1AZVKG | Allow NULL? |
| 16 | APCH | Request Profile Changeable | char | 1 | 0 | CHAR | (N' ') | Yes | | N1APCH | Allow NULL? |
| 17 | KM | Contrast Medium Application | char | 1 | 0 | CHAR | (N' ') | Yes | | N1KM | Allow NULL? |
| 18 | SM | Pacemaker | char | 1 | 0 | CHAR | (N' ') | Yes | | N1SM | Allow NULL? |
| 19 | MI | Metal Implants | char | 1 | 0 | CHAR | (N' ') | Yes | | N1METIMP | Allow NULL? |
| 20 | LOK | Entry of Localization in the Request | char | 1 | 0 | CHAR | (N' ') | Yes | | N1LOKINP | Allow NULL? |
| 21 | TDRAD | Techn. Examination Data of the Radiology Obligat. | char | 1 | 0 | CHAR | (N' ') | Yes | | N1TDRAD | Allow NULL? |
| 22 | MTRAD | Material Must Be Entered | char | 1 | 0 | CHAR | (N' ') | Yes | | N1MTRAD | Allow NULL? |
| 23 | ORGAN | Description of an Organ | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | N1ORGAN | N1ORGAN_DE | Allow NULL? |
| 24 | BILD | Image-Producing Process | char | 1 | 0 | CHAR | (N' ') | Yes | | N1BILD | Allow NULL? |
| 25 | WLRELEVANT | Not Relevant to Worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | N1RELEVANT | Allow NULL? |
| 26 | REQ_SER | Contains No Requestable Services | char | 1 | 0 | CHAR | (N' ') | Yes | | N1REQ_SER | Allow NULL? |
