| 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 | RETYP | IS-H: Usage of the Decision Rule | nvarchar | 2 | 0 | CHAR | (N' ') | No | | REGELTYP | Allow NULL? |
| 4 | GRTAR | IS-H: Source Svce Catalog for Svce Cat. Determ. (In-House) | nvarchar | 2 | 0 | CHAR | (N' ') | No | TNK01 | VON_TARID | Allow NULL? |
| 5 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | No | NTPK | TARLS | Allow NULL? |
| 6 | TAGRU | IS-H: Service Category | nvarchar | 9 | 0 | CHAR | (N' ') | No | TN20 | TAGRUPPE | Allow NULL? |
| 7 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | No | NGPA | KH_KOSTR | Allow NULL? |
| 8 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | CHAR | (N' ') | No | TN18 | KOSTR_ART | Allow NULL? |
| 9 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | CHAR | (N' ') | No | TN21 | ABRART | Allow NULL? |
| 10 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ENDDT | Allow NULL? |
| 11 | ABTAR | IS-H: Identification of Billing Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | AB_TARID | Allow NULL? |
| 12 | ZOTYP | IS-H: Type of Service Assignment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNT0 | ISH_ZUOTYP | Allow NULL? |
| 13 | REGEL | IS-H: name of an additional decision rule | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | REGELNAM | Allow NULL? |
| 14 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 15 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 16 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |