| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RK_TAX1 | Payroll results - master data from infotypes 0461-0463 | 9 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
2 | P2RK_TAXO | Payroll results - master data from infotypes 0461-0463 | 9 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
3 | P2RK_TCRTI | Payroll Results - Look up table for Tax Cumulations | 5 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
TOPCanada |
4 | PA0221 | HR Master Record: Infotype 0221 (Manual Checks) | 169 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
5 | PA0224 | Tax information - infotype 0224 - Canada | 24 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
6 | PA0461 | HR Master Record: Infotype 0461 (Tax Assignment CA) | 24 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
7 | PA0462 | HR Master Record: Infotype 0462 | 24 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
8 | PA0464 | HR Master Record: Infotype 0464 | 24 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
9 | T5K8D | Tax key data for transfer of old payroll results | 3 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
10 | T5KAW | Work tax area - Canada | 1 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
11 | T5KRC | Link HR tax payees to wage types via tax attributes | 4 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
12 | T5KRM | Canadian Tax Remittance Form PD7A Data | 9 | WRKAR | Work Tax Area | nvarchar | 4 | 0 | | |
13 | T5KTC | Wage Type Tax Classifications (Canada) | 2 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
14 | T5KYH | Year end reporting History table | 3 | WRKAR | Province of employment | nvarchar | 4 | 0 | | |
TOPUSA |
15 | T5UTA | Resident Tax Areas | 7 | WRKAR | Work Tax Area | nvarchar | 4 | 0 | | |
16 | T5UTG | ZIP Code Ranges for Work Tax Areas | 2 | WRKAR | Work Tax Area | nvarchar | 4 | 0 | | |