| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
1 | TNCH11 | IS-H CH: Canton Tariff-to-Geographical Area Assignment | 5 | TARCDE | IS-H CH: Canton Tariff | nvarchar | 3 | 0 | | |
2 | TNCH12 | IS-H CH: Canton Tariff | 3 | TARCDE | IS-H CH: Canton Tariff | nvarchar | 3 | 0 | | |
3 | TNCH12T | IS-H CH: Canton Tariff - Texts | 4 | TARCDE | IS-H CH: Canton Tariff | nvarchar | 3 | 0 | | |
4 | TNCH52 | IS-h CH: Determination of Billing Agreements | 5 | TARCDE | IS-H CH: Canton Tariff | nvarchar | 3 | 0 | | |
5 | TNWCH74 | IS-H CH: Vertragstypen Zuordnungstabelle | 4 | TARCDE | IS-H CH: Listino prezzi cantone | nvarchar | 3 | 0 | | |
6 | TNWCH75 | IS-H CH: Zuordnung KÜ-Verfahren <<->> Kantonstarif | 4 | TARCDE | IS-H CH: Listino prezzi cantone | nvarchar | 3 | 0 | | |
7 | TNWCH79 | IS-H CH: Zuordnung KÜ-Verfahren => Kantonstarif | 6 | TARCDE | IS-H CH: Listino prezzi cantone | nvarchar | 3 | 0 | | |