| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPeriodical Sales and Distribution |
1 | JSPLZZUOUPDA | Change Records PCd 4-/6-Digit (Postal Data CH) | 19 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | | |
TOPSAP Media |
2 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 29 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | | |
3 | J_1SPLZPRO | IS-M/SD CH/S: CH Postal Codes | 11 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | | |
4 | J_1SPLZZUO | Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data) | 15 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | | |
5 | J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 34 | KANTON | IS-M: CH: Canton | nvarchar | 2 | 0 | | |
TOPSwitzerland |
6 | T5CZC | HR-CH: Counting Class for Children for Fam.Allow. | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
7 | T5CZO | HR-CH: Amount of Child Benefit | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
8 | T5CZP | HR-CH: Amount of Bonus Paid after Birth of Child | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
9 | T5CZQ | HR-CH: Calculation Rule for Child Benefit | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
10 | T5CZR | HR-CH: Calculation Rule for Bonus Paid after Birth of Child | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
11 | T5CZS | HR-CH: Calculation Rule for Household Allowance | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
12 | T5CZT | HR-CH: FAK Contribution | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
13 | T5CZU | HR-CH: Different Payment of Family-Related Bonuses | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |
14 | T5CZV | HR-CH: Differing Reduction Rules | 2 | KANTON | Family Equalization Fund (FAK) | nvarchar | 2 | 0 | | |