| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 17 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 2 | P2BG_BG_CUX | Difference table of payroll results | 12 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 3 | P2BG_BG_DIF | Difference table of payroll results | 12 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 4 | P2CN_CNREI | Payroll result: structure for retro difference details | 18 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 5 | P2CN_CNREO | Payroll result: structure for retro difference details | 18 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 6 | P2CO_COAVA | PC2CO_AVA | 32 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 7 | P2HK_ENT | HR-HK: Payroll structure for the MPF/ORSO Entitlement | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 8 | P2HK_RETI | Payroll structure for retroactive accounting | 20 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 9 | P2HK_RETO | Payroll structure for retroactive accounting | 20 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 10 | P2IS_RETI | Payroll structure for retroactive accounting | 20 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 11 | P2IS_RETO | Payroll structure for retroactive accounting | 20 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 12 | P2KZ_FUP | Structure for Table FUP - Future Periods | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 13 | P2NZ_SALSAC | Salary Sacrifice Details | 17 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 14 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 61 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 15 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 61 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 16 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 61 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 17 | P2RA_BZU | Payroll Result: Organizational Assignments (A) | 5 | V0TYP | HR payroll: type of variable split | nvarchar | 1 | 0 | | |
| 18 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 18 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 19 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 20 | P2RD_XIT | Payroll Results: Extended IT | 10 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 21 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 22 | P2RH_HU_GYER | Children data | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 23 | P2RH_HU_HKIF | P21PB | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 24 | P2RH_HU_MEMB | P21MB | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 25 | P2RH_HU_NREN | P21PA | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 26 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 27 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 17 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 28 | P2RO_RO_CUX | Difference table of payroll results | 12 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 29 | P2RO_RO_DIF | Difference table of payroll results | 12 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 30 | P2RP_SCRT | HR-PT: Cumulated result table (Legal entity dependent) | 8 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 31 | P2RQ_HT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 32 | P2RQ_NT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 33 | P2RQ_QSUP | Superannuation structure for Australia | 23 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 34 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 35 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 36 | P2RR_SRT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 37 | P2RS_SEXC | Payroll result: Exceptions (SE) | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 38 | P2RS_SINL | Payroll result: Garnishment (SE) | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 39 | P2RS_SOPIS | Payroll result: OPIS (SE) | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 40 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 41 | P2RV_SCRT | SCRT Norway | 7 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 42 | P2RX_ARRRS | Payroll Results: Arrears Table | 11 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 43 | P2RX_CODIST | Distribution opf Liabilities | 17 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 44 | P2RX_DDNTK | Payroll Results: Deductions Not Effected | 7 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 45 | P2RX_GRT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 46 | P2RX_RT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 47 | P2RX_RT_PERSON | Results Table (Person) | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 48 | P2RX_V0 | Variable Assignment | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 49 | P2TN_TWOT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 50 | P2UA_FUP | table FUP - future periods | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 51 | P2UA_UAILL | struc.UAILL - information about sick-list compensation calc. | 5 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 52 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 18 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 53 | P2UA_UART | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 54 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 55 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 56 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 57 | P2UN_HT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 58 | P2UN_NT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 59 | P2UR_FUP | table FUP - future periods | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 60 | P2UR_RURES | Russian Statuses | 6 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 61 | P2UR_RURT | Payroll Results: Results Table | 15 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| 62 | T77PAYRU_TAXWT | Alternative tax wage types to tax classes | 4 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPAustria |
| 63 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPCompany Pension Scheme Germany |
| 64 | PDAVRT | Result Table: Data for Future Pension Rights | 9 | V0TYP | Variable Assignment Type | nvarchar | 2 | 0 | | |
| TOPDenmark |
| 65 | T5M9H | Split Indicators for Wage Types Sent to PBS | 16 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPGermany |
| 66 | T5D0I | Fictitious Run Control: Wage Type Assignment | 20 | V0TYP | Delete Indicator for Type of Variable Assignment | nvarchar | 1 | 0 | | |
| TOPInterface to External Payroll Systems |
| 67 | T558E | Transfer External Payroll-Arrears Results (International) | 6 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPPayroll |
| 68 | T7RO558_V0 | Transfer family members (supplement to T558D) | 4 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPPayroll General Parts |
| 69 | T558D | Transfer Wage Types with Split Indicator | 14 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPPersonnel Administration |
| 70 | T7COT8 | Payroll external results transfer: COAVA | 32 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPPersonnel Management |
| 71 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 19 | V0TYP | Variable assignment type | nvarchar | 1 | 0 | | |
| TOPTools |
| 72 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 16 | V0TYP | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |
