| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RK_PERM | Personal Characteristics | 7 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
2 | P2RU_DNRCT | Payroll Results: Retro Differences 1042S -DNRCT- (USA) | 5 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
3 | P2RU_NRCT | US Tax 1042S Processing | 5 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
4 | P2RU_PERM | Personal Characteristics | 8 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
5 | P2RU_TCRT | Payroll results: Tax accumulation (USA) | 5 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
6 | T5UMR | Cross month retro-calculations | 3 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
TOPBenefit Integration |
7 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
8 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
9 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
10 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
11 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
12 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
TOPCanada |
13 | T5K0P | Personnel Area/Sub Area (Canada) | 16 | TXCMP | Tax area - Canada | nvarchar | 4 | 0 | | |
14 | T5KTL | Tax area - Canada | 2 | TXCMP | Tax area - Canada | nvarchar | 4 | 0 | | |
15 | T5URC | HR payee for taxes derived from wage types via tax attr. | 4 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
16 | T5UTL | Tax Company | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
TOPTax Reporter |
17 | T51T4 | Evaluated tax form reporting periods | 5 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
18 | T51T6 | Evaluated payroll time units | 5 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
19 | T51TX | Transfer to be Evaluated | 6 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
20 | T5UQR | Cross quarter retro-calculations | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
21 | T5UT1 | Tax Interface Table: Payroll results | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
22 | T5UT2 | Deposited taxes, that have to be reported in tax forms | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
23 | T5UT9 | User Variants | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
24 | T5UX1 | Tax Reporter Employee Index | 3 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
25 | T5UX6 | W-2/W-2C Puerto Rico Control Number | 3 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
26 | T5UX9 | Tax Reporting Additional Information | 3 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
27 | T5UXY | Tax Reporter Control Record | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
28 | T5UYY | TR Monitor | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
TOPThird Party Remittance |
29 | T7US3PR_TXSYMKO | Posting of tax wage types | 3 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
TOPUSA |
30 | PA0446 | | 32 | TXCMP | | nvarchar | 4 | 0 | | |
31 | PA0447 | US Federal Tax MTD | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
32 | PA0448 | US Federal Tax QTD | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
33 | PA0449 | HR Master Record: Infotype 0449 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
34 | PA0450 | HR Master Record: Infotype 0450 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
35 | PA0451 | HR Master Record: Infotype 0451 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
36 | PA0452 | HR Master Record: Infotype 0452 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
37 | PA0453 | HR Master Record: Infotype 0453 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
38 | PA0454 | HR Master Record: Infotype 0454 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
39 | PA0455 | HR Master Record: Infotype 0455 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
40 | PA0456 | HR Master Record: Infotype 0456 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
41 | PA0457 | HR Master Record: Infotype 0457 | 32 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
42 | PA0894 | HR Master Record: Infotype 0894 | 24 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
43 | PA0895 | HR Master Record: Infotype 0895 | 24 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
44 | T5U0P | Additional organizational data for personnel area/subarea | 16 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
45 | T5U8A | Transfer ext.payroll result: Tax cumulation data (USA) | 6 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
46 | T5UCP_COMPM | Common Paymaster Relationship | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
47 | T5UP2 | Establishment/stores for tip processing | 14 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
48 | T5UTI | Tax identification number and successor enterprise | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
49 | T5UTLA | Timedependent Attributes of Taxcompany on Taxauthority Level | 2 | TXCMP | Tax Company or Tax Company Group Match | nvarchar | 4 | 0 | | |
50 | T5UTRC | Payroll USA: Tax Reciprocity Attributes | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |
51 | T5UTV | Unemployment Insurance Work Sites/NC-9901 Locations | 2 | TXCMP | Tax company | nvarchar | 4 | 0 | | |