| 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 | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
2 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 13 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
3 | P2AR_ARDIV | Correction of days according to month divisor | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
4 | P2AR_ARWPBP | Information annexed to WPBP table | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
5 | P2B2_AB | HCM Declustering B2 - Absences | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
6 | P2B2_WPBP | HCM Declustering B2 - Payroll Results Work Center/Basic Pay | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
7 | P2BR_BRCGC | Employment/basic pay: additional information | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
8 | P2BR_LADIV | Structure with information for process table Div30 | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
9 | P2CN_CNREI | Payroll result: structure for retro difference details | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
10 | P2CN_CNREO | Payroll result: structure for retro difference details | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
11 | P2CO_COAVA | PC2CO_AVA | 24 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
12 | P2CO_COBTR | PC2CO_BTR | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
13 | P2CO_COSEV | PC2CO_SEV | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
14 | P2CO_COSSA | PC2CO_SSA | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
15 | P2CO_COSSP | PC2CO_SSP | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
16 | P2CO_LADIV | Structure with Information for Div30 Process Table | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
17 | P2HK_RETI | Payroll structure for retroactive accounting | 12 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
18 | P2HK_RETO | Payroll structure for retroactive accounting | 12 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
19 | P2IN_EPF | Payroll structure for Provident Fund Infotype | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
20 | P2IN_GRY | Payroll structure for Gratuity | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
21 | P2IN_LWF | Payroll India - Labor Welfare Fund | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
22 | P2IN_PTX | Payroll India - Professional Tax | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
23 | P2IN_SAN | Payroll structure for Superannuation | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
24 | P2IS_RETI | Payroll structure for retroactive accounting | 12 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
25 | P2IS_RETO | Payroll structure for retroactive accounting | 12 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
26 | P2KR_BEN_BPS | Payroll result for benefit point request | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
27 | P2KZ_FUP | Structure for Table FUP - Future Periods | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
28 | P2KZ_KZAV | Cumulations for Calculation of Averages | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
29 | P2NZ_SALSAC | Salary Sacrifice Details | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
30 | P2PL_ZLAGROSS | Gross of wagetypes for PLZLA operation | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
31 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
32 | P2RA_SV_ST | HR-AT: Transfer Data SI -> Tax for Special Payments | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
33 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
34 | P2RB_CI | Payroll Result: Complementary Indemnity- CI (BE) | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
35 | P2RB_CIP | Payroll Result: Complementary Indemnity Payments (BE) | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
36 | P2RD_DOC0 | Payroll Results; Additional Data C0 (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
37 | P2RD_DOWP | Payroll Results; Additional Data WPBP (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
38 | P2RF_FPWP | PC2LF | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
39 | P2RF_WPE | Payroll results; additional WPBP data | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
40 | P2RH_HU_HKIF | P21PB | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
41 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
42 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
43 | P2RJ_JWPKJ | Add to working place and basic pay (Japan) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
44 | P2RK_DOC0 | Payroll Results: Additional C0 Data (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
45 | P2RK_DOWP | Payroll Results: Additional WPBP Data (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
46 | P2RP_LADIV | Structure with Information for Div30 Process Table | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
47 | P2RQ_HT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
48 | P2RQ_NT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
49 | P2RQ_QSUP | Superannuation structure for Australia | 22 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
50 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
51 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
52 | P2RQ_SUPCOM | Superable salary components | 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
53 | P2RR_RM | Payroll Results: Table for Master data (SG) | 70 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
54 | P2RR_SRT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
55 | P2RU_CLM | Overpayments Processing structure | 33 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
56 | P2RU_CLM_PERSON | Overpayments Processing structure | 35 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
57 | P2RU_DOC0 | Payroll Results: Additional C0 Data (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
58 | P2RU_DOWP | Payroll Results: Additional WPBP Data (PSG) | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
59 | P2RU_TAXPR | Authorities tax prorates | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
60 | P2RX_AB | Cluster RD/B2: Table AB | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
61 | P2RX_ABC | Cumulation of Absence Classes | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
62 | P2RX_ACCR | Payroll Result: Month End Accruals | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
63 | P2RX_C0 | Cost Distribution | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
64 | P2RX_CODIST | Distribution opf Liabilities | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
65 | P2RX_FUND | Accounting Structure for Funds Management | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
66 | P2RX_GRT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
67 | P2RX_LIDI | Cost-Distributed Liabilities | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
68 | P2RX_MODIF | HR-PAY: Modifiers | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
69 | P2RX_RT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
70 | P2RX_RT_PERSON | Results Table (Person) | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
71 | P2RX_WPBP | Payroll Results: Work Center/Basic Pay | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
72 | P2TN_TWOT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
73 | P2UA_FUP | table FUP - future periods | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
74 | P2UA_UAAV | HR-PAY: Cumulations for calculation of averages | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
75 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
76 | P2UA_UART | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
77 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
78 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
79 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
80 | P2UN_DSBP | Duty Station basic pay split extension | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
81 | P2UN_HT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
82 | P2UN_NT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
83 | P2UN_RS | UN Rental Subsidy internal structure | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
84 | P2UN_SUPCOM | Superable salary components For NPO | 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
85 | P2UR_FUP | table FUP - future periods | 10 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
86 | P2UR_RUAVE | Cumulations for calculation of averages | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
87 | P2UR_RURT | Payroll Results: Results Table | 7 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
88 | P2UR_RUSTA | Russian Statuses | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
TOPAustria |
89 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
TOPGermany |
90 | T5D0I | Fictitious Run Control: Wage Type Assignment | 12 | APZNR | Delete Indicator for WPBP Split | nvarchar | 1 | 0 | | |
TOPPayroll |
91 | T5T558_AB | HRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP | 6 | APZNR | Prirazení PC205 | varbinary | 1 | 0 | | |
92 | T7SK558_AB | Transfer absences (supplement to T558D) - SK | 6 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
TOPPayroll General Parts |
93 | T558D | Transfer Wage Types with Split Indicator | 6 | APZNR | HR: Outsourcing: Split Indicator - PC205 Assignment | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
94 | T7COT2 | Payroll external results transfer: COSSA | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
95 | T7COT3 | Payroll external results transfer: COSEV | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
96 | T7COT5 | Payroll external results transfer: COBTR | 5 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
97 | T7COT8 | Payroll external results transfer: COAVA | 24 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
TOPPersonnel Management |
98 | /BKC/S21_EV | Sol21: Vergleich von Abrechnungsergebnissen | 8 | APZNR | Zuordnung PC205 | varbinary | 1 | 0 | | |
99 | /BKC/S21_EV1 | Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR. | 7 | APZNR | Zuordnung PC205 | varbinary | 1 | 0 | | |
100 | /BKC/S21_RT | C&T! - Table RT for the payroll comparison programs | 9 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
101 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 11 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |
102 | /BKC/S21_RT_NOPN | C&T! - Table RT for the payroll comparison programs | 8 | APZNR | PC205 assignment | varbinary | 1 | 0 | | |