| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVHCM_COMPARLOG | TDMS4HCM: Protocoll information for payroll compare | 6 | INPER | TDMS4HCM: In-period for payroll | nvarchar | 6 | 0 | | |
2 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
3 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
4 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 12 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
5 | HRPADDE_D_DN_CI | Dest. Rep. Data: Const. "Business Complete" Information | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
6 | P01PF_PFBB_DIR | PO Rebuild: Transfer Garnishable Amount Directly | 6 | INPER | In-period for garnishments | nvarchar | 6 | 0 | | |
7 | P2CO_COAVA | PC2CO_AVA | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
8 | P2CO_COBTR | PC2CO_BTR | 19 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
9 | P2CO_COGAR | PC2CO_GAR | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
10 | P2CO_COSSA | PC2CO_SSA | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
11 | P2KZ_FUP | Structure for Table FUP - Future Periods | 5 | INPER | Payroll period | nvarchar | 6 | 0 | | |
12 | P2NZ_EMS | Payroll Result: Employer Monthly Schedule - NZ | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
13 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
14 | P2RC_WHTP | PC2CH02 | 7 | INPER | In-Period | nvarchar | 6 | 0 | | |
15 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 9 | INPER | XDEC: In Pay Period (YYYYPP) | nvarchar | 6 | 0 | | |
16 | P2RG_WEARN | NI: payment history of affected wagetype | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
17 | P2RH_HU_CDIF | Differences spanning over year-limit | 7 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
18 | P2RH_HU_DDIF | Differences spanning over year-limit | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
19 | P2RH_HU_JKOR | Differences spanning over year-limit | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
20 | P2RH_HU_KDIF | Differences spanning over year-limit | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
21 | P2RH_HU_NRBE | Irregular incomes from infotype 3234 | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
22 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 9 | INPER | XDEC: In Pay Period (YYYYPP) | nvarchar | 6 | 0 | | |
23 | P2RX_EVAL_PERIOD | Index for Payroll Results Periods | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
24 | P2RX_VERSC | Payroll Status Information | 15 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
25 | P2UA_FUP | table FUP - future periods | 5 | INPER | Payroll period | nvarchar | 6 | 0 | | |
26 | P2UR_FUP | table FUP - future periods | 5 | INPER | Payroll period | nvarchar | 6 | 0 | | |
27 | T449U | Settings for Collective Display of MRP List | 20 | INPER | Internal period indicator | nvarchar | 1 | 0 | | |
28 | T5FDSNAB_FR | Temp table for PAYFR_RESULT-AB_FR | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
29 | T5FDSNACTI | Temp table for PAYFR_RESULT-ACTI | 6 | INPER | Période courante de la paie | nvarchar | 6 | 0 | | |
30 | T5FDSNCT | Temp table for PAYFR_RESULT-CT | 6 | INPER | Période courante de la paie | nvarchar | 6 | 0 | | |
31 | T5FDSNFPERS | Temp table for PAYFR_RESULT-FPERS | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
32 | T5FDSNPAYM | Temp table for PAYFR_RESULT-PAYM | 6 | INPER | Période courante de la paie | nvarchar | 6 | 0 | | |
33 | T5FDSNREM | Temp table for PAYFR_RESULT-REM | 6 | INPER | Période courante de la paie | nvarchar | 6 | 0 | | |
34 | T5FDSNSUSPENSION | Temp table for PAYFR_RESULT-SUSPENSION | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
35 | T5H7V | K100 data | 4 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
36 | T5Q_SUPERSTREAM | Super Stream Master Table | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
37 | T5TPENSAV | Data for pension savings | 3 | INPER | Reported in period | nvarchar | 6 | 0 | | |
38 | T5TPENSAV_YS | Pension savings - annual reporting | 3 | INPER | Reported in period | nvarchar | 6 | 0 | | |
39 | T5UMR | Cross month retro-calculations | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
40 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
41 | T7ROA8 | Contr. G - Deducted Amount | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
42 | UMD01 | Default values for MRP | 16 | INPER | Internal period indicator | nvarchar | 1 | 0 | | |
TOPAustria |
43 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
44 | T5A71 | L16 Consolidation File | 122 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | | |
45 | T5A72 | BGN(GKK) Consolidation File | 47 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | | |
46 | T5A73 | BGN(BVA) Consolidation File | 51 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | | |
47 | T5A74 | E18 Consolidation File | 69 | INPER | Last In-Period of Payroll in the Record | nvarchar | 6 | 0 | | |
TOPCanada |
48 | T5KRM | Canadian Tax Remittance Form PD7A Data | 20 | INPER | Payroll period IP | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
49 | PDBKAD | CI: Social Fund Procedure: Records Management | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
50 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
51 | PDBKAU | Construction Industry Social Fund Proced: AUMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
52 | PDBKBE | Constr. Ind. Social Fund Procedure: BEMEL (PerNo) Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
53 | PDBKBESUM | Constr. Ind. Social Fund Procedure: BEMEL Records (Total) | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
54 | PDBKLO | Construction Industry Social Fund Proced: LOMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
55 | PDBKNE | Construction Industry Social Fund Proced: NEMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
56 | PDBKNW | Construction Industry Social Fund Proced: Employee Statement | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
57 | PDBKRA | Construction Industry Social Fund Proced: RAMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
58 | PDBKUR | Construction Industry Social Fund Proced: URMEL Data Records | 3 | INPER | In-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
TOPGarnishmentCession |
59 | P01PF_RT_EP | Garnishment Pr. of Origin: Results of Garnishment Calc. | 3 | INPER | In-period for garnishments | nvarchar | 6 | 0 | | |
60 | P01PF_TILG | Garnishment of Principle of Origin: Repayment Amounts | 3 | INPER | In-period for garnishments | nvarchar | 6 | 0 | | |
TOPItaly |
61 | PA3206 | HR Master Record: Infotype 3206 | 29 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
62 | T5ITF24 | Archive F24 | 4 | INPER | Year/Month | nvarchar | 6 | 0 | | |
63 | T5ITF24A | Archive F24 Administration | 4 | INPER | Year/Month | nvarchar | 6 | 0 | | |
64 | T5ITPOS_A | Header table for traceability | 3 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPNew Zealand |
65 | HNZLVPAY | Table for modified LVPAY cluster table records | 4 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPPayroll |
66 | T5H83 | Data of other legal relationships | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
67 | T5HNR | HU_NREN payroll table data of the "current month" | 3 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
68 | T5HPBS_HAVIBONT | Comm. - payments monthly breakdown by persons | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
69 | T5HS1 | HR-H: Havi bevallás - bevallási adatok | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
70 | T5HS4 | HR-H: Havi bevallás - Élesben futtatott hónapok (bárkód) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
71 | T5HS7 | HR-H: Havi bevallás - bevallási adatok - adózónként | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
72 | T5HS8 | HR-H: Havi bevallás - adózót terhelo egyéb kötelezettségek | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
73 | T5HSE | 12. lap Önellenorzés | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
74 | T5HSH | HR-H: Havi bevallás - Kijelölés helyesbítésre | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
75 | T5HSJ | Havi bevallás - bevallási adatok - munkavállalónként | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
76 | T5HSK | Havi bevallás - külso bevallási adatok - adózónként | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
77 | T5HSM | Havi bevallás - külso bevallási adatok magánszemély (I.né) | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
78 | T5HSN | Havi bevallás - külso bevallási adatok - adózó (I.né) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
79 | T5HSR | HR-H: Havi bevallás - nemnegatív járulékbérelemek | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
80 | T5HSS | Havi bevallás - külso-belso adatok összesítve - adózó | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
81 | T5HST | Havi bevallás- külso-belso adatok összesítve - személy | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
82 | T5HSV | HR-H: Havi bevallás - bevallási adatok (negyedéves) | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
83 | T5HSW | HR-H: Havi bevallás - bevallási adatok - adózó (n.éves) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
84 | T5HSX | Havi bevallás - külso-belso adatok összesítve adózó I. né | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
85 | T5HSY | Havi bevallás- külso-belso adatok összesítve személy I.né | 4 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
86 | T5HV0I | Havi adóbevallás adatainak (T5HV0) index táblája | 5 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
87 | T5HV0I_BCK | Havi adóbevallás adatainak (T5HV0) index táblája backup | 5 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
88 | T5HV4 | Élesben futtatott hónapok (BAR-kód) (havi adóbevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
89 | T5HV7 | Bevallási adatok adózónként (havi adóbevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
90 | T5HV8 | Vállalati összesíto egyéb adatok (havi bevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
91 | T5HVH | Kijelölés helyesbítésre (havi bevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
92 | T5HVK | Külso bevallási adatok adózónként (havi bevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
93 | T5HVR | Nemnegatív járulékbérelemek (havi bevallás) | 3 | INPER | Bérszámfejtés tárgyperiódusa | nvarchar | 6 | 0 | | |
94 | T7ROA3 | Insurance result table - Person 1:1 with RGDIR | 10 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
95 | T7ROA6 | Contr. H - received/deducted amount from the authorities | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
96 | T7ROER | HR Cluster 2 - ER Insurances | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPPayroll General Parts |
97 | HRPY_RGDIR | Directory for Payroll Results | 10 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
98 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 10 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
99 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 2 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPPersonnel Administration |
100 | T7COT2 | Payroll external results transfer: COSSA | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
101 | T7COT5 | Payroll external results transfer: COBTR | 19 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
102 | T7COT6 | Payroll external results transfer: COGAR | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
103 | T7COT8 | Payroll external results transfer: COAVA | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPPersonnel Management |
104 | /BKC/S21_EV | Sol21: Vergleich von Abrechnungsergebnissen | 4 | INPER | Inperiode der Abrechnung | nvarchar | 6 | 0 | | |
105 | /BKC/S21_EV1 | Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR. | 3 | INPER | Inperiode der Abrechnung | nvarchar | 6 | 0 | | |
106 | /BKC/S21_RT | C&T! - Table RT for the payroll comparison programs | 4 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
107 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 4 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
108 | /BKC/S21_RT_NOPN | C&T! - Table RT for the payroll comparison programs | 3 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPPersonnel Time Management |
109 | T559M | Reduction Rules for Absence Quota Generation | 8 | INPER | Reference period to determine inactive days | nvarchar | 1 | 0 | | |
TOPPublic Sector |
110 | PDPBSZV363 | Estimated Tax-Free Contributions (Acc. to Sec.3 No.63) | 6 | INPER | In-Period for Payroll | nvarchar | 6 | 0 | | |
111 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 9 | INPER | In-Period for Payroll | nvarchar | 6 | 0 | | |
TOPPublic sector Sweden |
112 | T5SA0_CE | Alecta | 11 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
113 | T5SK0_CE | KPA events | 5 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
114 | T5SK1_CE | KPA absences | 6 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
115 | T5SK2_CE | KPA income | 4 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
116 | T5SP0_CE | PA91 periods | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
117 | T5SP1_CE | PA91 absence | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
118 | T5SP2_CE | PA91 income | 7 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
119 | T5SS0_CE | PA03 periods | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
120 | T5SS1_CE | PA03 absences | 10 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
121 | T5SS2_CE | PA03 income | 7 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
122 | T5SS3_CE | PA03 pernr | 7 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPTax Reporter |
123 | T51TX | Transfer to be Evaluated | 9 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
124 | T5UQR | Cross quarter retro-calculations | 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |
TOPUSA |
125 | PA0909 | HR Master Record: Infotype 0909 | 29 | INPER | In-period for payroll | nvarchar | 6 | 0 | | |