| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
2 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 15 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
3 | J_1UF_TP_RESGRP | Information of Notification. Grouping | 39 | CNTR2 | Notification Number | nvarchar | 8 | 0 | | |
4 | P2AA_PS_SA | Payroll Result: Pension Data for KSA | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
5 | P2AR_ARIMP | Tax master data | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
6 | P2B2_AB | HCM Declustering B2 - Absences | 11 | CNTR2 | National split | varbinary | 1 | 0 | | |
7 | P2BR_BRIRRF | Withholding Incoming Tax: master data | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
8 | P2CL_CLTAX | Payroll Results: Tax (CL) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
9 | P2CN_CNREI | Payroll result: structure for retro difference details | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
10 | P2CN_CNREO | Payroll result: structure for retro difference details | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
11 | P2CN_TAX | Payroll result: Income Tax (CN) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
12 | P2CO_COAVA | PC2CO_AVA | 26 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
13 | P2FI_CST | Tax result table for Finland, cumulative | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
14 | P2FI_SCRT | Tax result table for Finland, cumulated wage type level | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
15 | P2FI_ST | Tax result structure for Finland | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
16 | P2HK_RETI | Payroll structure for retroactive accounting | 14 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
17 | P2HK_RETO | Payroll structure for retroactive accounting | 14 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
18 | P2HK_ST | HR-HK: Payroll structure for Tax - Period by period | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
19 | P2HR_CUF | Structure of difference table Croatia | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
20 | P2HR_CUP | Structure of difference table Croatia | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
21 | P2HR_DTF | Structure of difference table Croatia | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
22 | P2HR_DTP | Structure of difference table Croatia | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
23 | P2HR_HR_CUX | Structure of difference table for tax calculation | 6 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
24 | P2HR_HR_DPA | Structure of difference table for tax calculation | 6 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
25 | P2IN_CCO | Payroll India - Car and Conveyance | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
26 | P2IN_EXM | Payroll structure for exemptions | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
27 | P2IN_PTX | Payroll India - Professional Tax | 6 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
28 | P2IN_TAN | Company code cluster line item | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
29 | P2IS_RETI | Payroll structure for retroactive accounting | 14 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
30 | P2IS_RETO | Payroll structure for retroactive accounting | 14 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
31 | P2IS_TAX | Payroll Indonesia Tax Data | 5 | CNTR2 | Split Counter | nvarchar | 2 | 0 | | |
32 | P2KR_KRTAX | Payroll Result Korea : Tax | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
33 | P2KW_SI_KW | Payroll Result: PIFSS Data for Kuwait | 6 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
34 | P2KZ_FUP | Structure for Table FUP - Future Periods | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
35 | P2MX_TAX | Tax for calculation data included | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
36 | P2NZ_SALSAC | Salary Sacrifice Details | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
37 | P2PH_TAXP | HR-PH: Include for Tax structure - Philippines | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
38 | P2PL_ST | Payroll Result PL: Split 2, income tax | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
39 | P2QA_PS_QA | Payroll Result: Pension Data for QA | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
40 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
41 | P2RA_ST | Payroll Result: Tax (Austria) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
42 | P2RA_SV_ST | HR-AT: Transfer Data SI -> Tax for Special Payments | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
43 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 10 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
44 | P2RB_ST | Tax payroll Belgium | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
45 | P2RB_SV | Social Insurance payroll Belgium | 6 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
46 | P2RC_CHVS | HR-CH: Payroll result insurance | 34 | CNTR2 | C2 Split | varbinary | 1 | 0 | | |
47 | P2RC_ST | Payroll Results: Taxes (Switzerland) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
48 | P2RD_ST | Payroll Result: Tax (G) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
49 | P2RE_ST | Payroll result: Taxes (ES) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
50 | P2RH_ADO | Structure of table ADO | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
51 | P2RH_HU_HKIF | P21PB | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
52 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
53 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
54 | P2RJ_JP_SHUKKO | Shukko settlement information | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
55 | P2RJ_RET_INFO | Payroll Results: Retirement Information Table | 5 | CNTR2 | Tax Flag | varbinary | 1 | 0 | | |
56 | P2RL_TAX | Payroll result: Tax (Malaysia) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
57 | P2RN_ST | Payroll Results: Wage Tax (NL) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
58 | P2RP_DA | HR-PT: Payroll Results: Disability | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
59 | P2RP_SCRT | HR-PT: Cumulated result table (Legal entity dependent) | 6 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
60 | P2RP_TX | HR-PT: Payroll Results: Tax | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
61 | P2RQ_HT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
62 | P2RQ_NT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
63 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
64 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
65 | P2RQ_TAXP | Structure for tax routine (Australia) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
66 | P2RR_RM | Payroll Results: Table for Master data (SG) | 72 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
67 | P2RR_SRT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
68 | P2RR_ST | Payroll Results: Tax (Singapore) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
69 | P2RS_SSKAT | Payroll result: Tax (SE) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
70 | P2RT_ST | Structure of table ST - Tax CZ | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
71 | P2RV_ST | ST for Norway (Cluster for tax) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
72 | P2RW_BRS | Payroll Result: Bursaries | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
73 | P2RW_CBRS | Payroll Result: Bursaries | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
74 | P2RW_CDT | Payroll Result: Cumulated Directives (South Africa) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
75 | P2RW_CST | Payroll Result: Cumulated Tax Data for South Africa. | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
76 | P2RW_SCRT | Payroll Result: Cumulated Tax Results for South Africa | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
77 | P2RW_ST | Payroll Result: Tax Data for South Africa. | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
78 | P2RX_AB | Cluster RD/B2: Table AB | 9 | CNTR2 | National split | varbinary | 1 | 0 | | |
79 | P2RX_CODIST | Distribution opf Liabilities | 11 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
80 | P2RX_GRT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
81 | P2RX_MODIF | HR-PAY: Modifiers | 7 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
82 | P2RX_RT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
83 | P2RX_RT_PERSON | Results Table (Person) | 13 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
84 | P2SK_ST | Structure of table ST - Tax SK | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
85 | P2TH_TAX | Payroll Structure for TAX - TH | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
86 | P2TN_TAX | Payroll Structure Tax (Taiwan) | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
87 | P2TN_TWOT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
88 | P2UA_FUP | table FUP - future periods | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
89 | P2UA_TAX | Ukrainian Tax | 5 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
90 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
91 | P2UA_UART | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
92 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 13 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
93 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 13 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
94 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 13 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
95 | P2UN_HT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
96 | P2UN_NT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
97 | P2UR_FUP | table FUP - future periods | 12 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
98 | P2UR_RURT | Payroll Results: Results Table | 9 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
99 | P2VE_TAX | HRMS-VE: Income Tax Percentages | 5 | CNTR2 | Tax split | varbinary | 1 | 0 | | |
TOPAustria |
100 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 10 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
TOPDenmark |
101 | T5M9H | Split Indicators for Wage Types Sent to PBS | 10 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
TOPGermany |
102 | T5D0I | Fictitious Run Control: Wage Type Assignment | 14 | CNTR2 | Delete Indicator for Tax Split | nvarchar | 1 | 0 | | |
TOPGlobal Trade Services |
103 | /SAPSLL/PREGPPRO | GTS: Preference: Procedure Groups (Data Provider Upload) | 6 | CNTR2 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
104 | /SAPSLL/PRFPMRP | SLL: Preference: Log: product: Result of BOM Calc - Proc. | 6 | CNTR2 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
105 | /SAPSLL/PSVGPPRO | GTS: Preference: Procedure Groups (Manual Entry) | 6 | CNTR2 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
106 | /SAPSLL/SPLAUDK | Legal Control - SPL - Audit: Comments | 5 | CNTR2 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
107 | /SAPSLL/TPAGRA | Assignment of Partner Function to Partner Function Grouping | 3 | CNTR2 | 2-Digit Sequence Number | nvarchar | 2 | 0 | | |
TOPPayroll |
108 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 8 | CNTR2 | Národní rozdelení | varbinary | 1 | 0 | | |
109 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 8 | CNTR2 | National split | varbinary | 1 | 0 | | |
TOPPayroll General Parts |
110 | T558D | Transfer Wage Types with Split Indicator | 8 | CNTR2 | HR: Outsourcing: Split Indicator - 2 NOT USED | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
111 | T7COT8 | Payroll external results transfer: COAVA | 26 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
TOPPersonnel Management |
112 | /BKC/S21_EV | Sol21: Vergleich von Abrechnungsergebnissen | 10 | CNTR2 | Zuordnungskennzeichen National | varbinary | 1 | 0 | | |
113 | /BKC/S21_EV1 | Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR. | 9 | CNTR2 | Zuordnungskennzeichen National | varbinary | 1 | 0 | | |
114 | /BKC/S21_RT | C&T! - Table RT for the payroll comparison programs | 11 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
115 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 13 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
116 | /BKC/S21_RT_NOPN | C&T! - Table RT for the payroll comparison programs | 10 | CNTR2 | National assignment indicator | varbinary | 1 | 0 | | |
TOPTools |
117 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 10 | CNTR2 | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |