| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_CNREI | Payroll result: structure for retro difference details | 25 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
2 | P2CN_CNREO | Payroll result: structure for retro difference details | 25 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
3 | P2CO_COAVA | PC2CO_AVA | 39 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
4 | P2HK_RETI | Payroll structure for retroactive accounting | 27 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
5 | P2HK_RETO | Payroll structure for retroactive accounting | 27 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
6 | P2IN_S89 | Payroll structure for section 89(1) | 9 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
7 | P2IS_RETI | Payroll structure for retroactive accounting | 27 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
8 | P2IS_RETO | Payroll structure for retroactive accounting | 27 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
9 | P2KR_KRSP2 | Payroll Results Korea: Separation payroll II | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
10 | P2KZ_FUP | Structure for Table FUP - Future Periods | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
11 | P2KZ_KZAV | Cumulations for Calculation of Averages | 18 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
12 | P2MX_LNCT | MX Loans Processing | 12 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
13 | P2NZ_RETP | Payroll structure NZ: RETP Table | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
14 | P2NZ_SALSAC | Salary Sacrifice Details | 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
15 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 25 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
16 | P2RB_DAYDET | Daydetails for payroll outsourcing (B) | 16 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
17 | P2RG_MSA | Maternity and Sickness Absences (GB) | 13 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
18 | P2RH_HU_ADIF | Differences spanning over year-limit | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
19 | P2RH_HU_CDIF | Differences spanning over year-limit | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
20 | P2RH_HU_DDIF | Differences spanning over year-limit | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
21 | P2RH_HU_EDIF | Differences spanning over year-limit | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
22 | P2RH_HU_HKIF | P21PB | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
23 | P2RH_HU_JKOR | Differences spanning over year-limit | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
24 | P2RH_HU_KDIF | Differences spanning over year-limit | 9 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
25 | P2RH_HU_ODIF | Differences spanning over year-limit | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
26 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
27 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 24 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
28 | P2RJ_HEIT | Payroll Results: Hei Ran Results Table | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
29 | P2RJ_KGT | Kijungai time occured in for-period with Position info | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
30 | P2RJ_MAT | Cumulation Table for Flexible Payroll | 9 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
31 | P2RJ_MST | Payroll result: Monthly socail insurance table | 9 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
32 | P2RK_GRCUM | Cumulation for garnishment results | 14 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
33 | P2RK_TCRT | Payroll Results - Fed. and Prov. Tax Cumulations | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
34 | P2RP_MF | HR-PT: Payroll Results: Membership fees | 14 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
35 | P2RP_SCRT | HR-PT: Cumulated result table (Legal entity dependent) | 14 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
36 | P2RP_VA | HR-PT: Payroll Results: Vacation allowance grouping (VA) | 20 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
37 | P2RQ_HT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
38 | P2RQ_NT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
39 | P2RQ_PASUM | Payment summary components | 14 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
40 | P2RQ_RETP | Payroll Structure: RETP Table | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
41 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
42 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
43 | P2RR_SRT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
44 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
45 | P2RU_GRCUM | Cumulation for garnishment results | 14 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
46 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
47 | P2RU_UTIPS | Payroll Results: Cumulated tips result | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
48 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
49 | P2RV_RETP | RETP Structure Norway | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
50 | P2RV_SCRT | SCRT Norway | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
51 | P2RX_CRT | Payroll Results: Cumulated Results Table | 9 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
52 | P2RX_CRT_PERSON | Cumulated Results Table (Person) | 11 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
53 | P2RX_GRT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
54 | P2RX_LS | Payroll Results: Subsequent Time Tickets | 23 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
55 | P2RX_RT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
56 | P2RX_RT_GP | Payroll Result: Payroll for Global Employees | 13 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
57 | P2RX_RT_PERSON | Results Table (Person) | 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
58 | P2TN_TWOT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
59 | P2UA_FUP | table FUP - future periods | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
60 | P2UA_UAAV | HR-PAY: Cumulations for calculation of averages | 16 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
61 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 25 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
62 | P2UA_UART | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
63 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
64 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
65 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 26 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
66 | P2UN_HT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
67 | P2UN_NT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
68 | P2UR_FUP | table FUP - future periods | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
69 | P2UR_RUAVE | Cumulations for calculation of averages | 16 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
70 | P2UR_RURT | Payroll Results: Results Table | 22 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPAustralia |
71 | T5QGO | Group Certificate Overrides | 7 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPAustria |
72 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 23 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPPayroll |
73 | T5T4045 | Výsledky RZD pro prevzetí do výpoctu - MD /404 a /405 | 10 | AMT_CURR | Zúctování mezd a pl.: Cástka | decimal | 15 | 2 | | |
74 | T5TA3 | Results of annual tax calculation for RPCALC | 8 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
75 | T7SKA3 | Results of annual tax calculation for RPCALC | 10 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPPersonnel Administration |
76 | T7COT8 | Payroll external results transfer: COAVA | 39 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPPersonnel Management |
77 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 23 | AMT_CURR | Currency Key | nvarchar | 5 | 0 | | |