| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 14 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
2 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 10 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
3 | P2RU_DNRCT | Payroll Results: Retro Differences 1042S -DNRCT- (USA) | 6 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
4 | P2RU_NRCT | US Tax 1042S Processing | 6 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
5 | P2RU_TAX | Payroll Results: Tax (U.S.) | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
6 | P2RU_TAXPR | Authorities tax prorates | 8 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
7 | P2RU_TAXR | Payroll result: Tax authorities of resident/unemployment(US) | 5 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
8 | P2RU_TCRT | Payroll results: Tax accumulation (USA) | 6 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
9 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 14 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
10 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 14 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
TOPCanada |
11 | PA0095 | HR Master Record: Infotype 0095 (Tax Canada) | 25 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
12 | T5KIN | Tax indicators - Canada | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
13 | T5KIT | Tax indicator texts - Canada | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
14 | T5KMX | Tax model / Taxation authorities - Canada | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
15 | T5KOT | Taxing authorities - texts - Canada | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
16 | T5KTO | Taxation authorities - Canada | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
17 | T5U8C | Transfer external payroll results (USA) | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
18 | T5URC | HR payee for taxes derived from wage types via tax attr. | 5 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
TOPTaiwan |
19 | T7TW2D | Tax Authority Code | 2 | TAXAU | Tax Authority Code | nvarchar | 3 | 0 | | |
20 | T7TW2DT | Tax Authority Code | 3 | TAXAU | Tax Authority Code | nvarchar | 3 | 0 | | |
TOPTax Reporter |
21 | T51T2 | Definitions, how tax datas will be reported | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
22 | T51T4 | Evaluated tax form reporting periods | 6 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
23 | T51T5 | Events, on which form will be issued | 9 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
24 | T51T6 | Evaluated payroll time units | 6 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
25 | T51T8 | Definitions of a tax form | 17 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
26 | T51TX | Transfer to be Evaluated | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
27 | T5UT1 | Tax Interface Table: Payroll results | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
28 | T5UT2 | Deposited taxes, that have to be reported in tax forms | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
29 | T5UT3 | Data to be printed in a tax form | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
30 | T5UX1 | Tax Reporter Employee Index | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
31 | T5UX5 | Assign attributes to tax authority | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
32 | T5UX9 | Tax Reporting Additional Information | 5 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
33 | T5UXX | Evaluated tax form reporting periods | 4 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
TOPThird Party Remittance |
34 | T7US3PR_TXSYMKO | Posting of tax wage types | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
TOPUSA |
35 | PA0096 | HR Master Record: Infotype 0096 (Tax - USA) | 25 | TAXAU | BSI:Tax Authority Key | nvarchar | 11 | 0 | | |
36 | PA0209 | HR Master Record: Infotype 0209 (Unemployment Insurance USA) | 24 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
37 | PA0446 | | 33 | TAXAU | | nvarchar | 4 | 0 | | |
38 | PA0447 | US Federal Tax MTD | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
39 | PA0448 | US Federal Tax QTD | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
40 | PA0449 | HR Master Record: Infotype 0449 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
41 | PA0450 | HR Master Record: Infotype 0450 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
42 | PA0451 | HR Master Record: Infotype 0451 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
43 | PA0452 | HR Master Record: Infotype 0452 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
44 | PA0453 | HR Master Record: Infotype 0453 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
45 | PA0454 | HR Master Record: Infotype 0454 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
46 | PA0455 | HR Master Record: Infotype 0455 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
47 | PA0456 | HR Master Record: Infotype 0456 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
48 | PA0457 | HR Master Record: Infotype 0457 | 33 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
49 | T505X | Tax Authority Table | 3 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
50 | T505Y | Tax Authority Texts | 4 | TAXAU | Tax authority key | nvarchar | 4 | 0 | | |
51 | T5U8A | Transfer ext.payroll result: Tax cumulation data (USA) | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
52 | T5UFB | SAP to ADP tax authority mapping table | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
53 | T5UP1 | Minimum and cash wages for tip credit | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
54 | T5UP2 | Establishment/stores for tip processing | 7 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
55 | T5US0 | Priority for tax wagetypes | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
56 | T5US1 | SAP Taxability Matrix Table | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
57 | T5UT0 | SAP Taxability Matrix Table | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
58 | T5UTD | Default Tax Types | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
59 | T5UTE | Tax Authority / Tax Calculation Model | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
60 | T5UTI | Tax identification number and successor enterprise | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
61 | T5UTK | Marital Status | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
62 | T5UTLA | Timedependent Attributes of Taxcompany on Taxauthority Level | 3 | TAXAU | Tax Authority or Tax Authority Group Match | nvarchar | 4 | 0 | | |
63 | T5UTR | Tax Authorities per Resident Tax Area | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
64 | T5UTS | States without withholding tax | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
65 | T5UTU | Wage Base Continuity for Tax Authorities | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
66 | T5UTV | Unemployment Insurance Work Sites/NC-9901 Locations | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
67 | T5UTW | Tax Authorities per Work Tax Area | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
68 | T5UTX | Tax Ceilings and rates | 1 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
69 | T5UTZ | Tax Authorities | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
70 | T5UTZC | Tax Authority Attributes | 3 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
71 | T5UU0 | SAP Taxability Customized Table | 2 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |
72 | T77USPAY_COBASE | Cost distribution base configuration | 4 | TAXAU | Tax authority | nvarchar | 4 | 0 | | |