| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKEXC_B | Appendix to External Payment Information | 4 | PAYID | ID of External Payment | nvarchar | 35 | 0 | | |
2 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 17 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
3 | P2BG_BG_CUX | Difference table of payroll results | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
4 | P2BG_BG_DIF | Difference table of payroll results | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
5 | P2CO_COAVA | PC2CO_AVA | 42 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
6 | P2CO_COSEV | PC2CO_SEV | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
7 | P2FI_ST | Tax result structure for Finland | 23 | PAYID | Payer identification for bank transfer file | nvarchar | 9 | 0 | | |
8 | P2HK_RETI | Payroll structure for retroactive accounting | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
9 | P2HK_RETO | Payroll structure for retroactive accounting | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
10 | P2IS_RETI | Payroll structure for retroactive accounting | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
11 | P2IS_RETO | Payroll structure for retroactive accounting | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
12 | P2NZ_EMS | Payroll Result: Employer Monthly Schedule - NZ | 10 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
13 | P2NZ_LVACC | Payroll Result: Leave Accruals LVACC - NZ | 25 | PAYID | Parental Lve Flag - NZ | nvarchar | 1 | 0 | | |
14 | P2NZ_NZHPI | Payroll Result: Holiday Payment Information NZHPI - NZ | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
15 | P2RH_HU_NREN | P21PA | 24 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
16 | P2RM_MVAC | Payroll Structure MVAC: Leave Handling (DK) | 122 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
17 | P2RO_RO_CUX | Difference table of payroll results | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
18 | P2RO_RO_DIF | Difference table of payroll results | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
19 | P2RR_RM | Payroll Results: Table for Master data (SG) | 50 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
20 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 17 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
21 | P2RU_CLM | Overpayments Processing structure | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
22 | P2RU_CLM_PERSON | Overpayments Processing structure | 17 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
23 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 13 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
24 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 17 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
25 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 17 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
26 | P2RX_EVAL_PERIOD | Index for Payroll Results Periods | 14 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
27 | P2RX_VERSC | Payroll Status Information | 18 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
28 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
29 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
30 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
31 | PA3273 | HR Master Record: Infotype 3273 | 52 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
32 | PA9220 | HR Master Record: Infotype 9220 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
33 | PA9390 | Personal-Stammsatz Infotyp 9390 | 30 | PAYID | Abrechnungsidentifikator | nvarchar | 1 | 0 | | |
34 | PA9429 | Registro maestro de personal Infotipo 9429 | 30 | PAYID | Identificador de nómina | nvarchar | 1 | 0 | | |
35 | PA9640 | Personal-Stammsatz Infotyp 9640 | 30 | PAYID | Abrechnungsidentifikator | nvarchar | 1 | 0 | | |
36 | PA9701 | Personal-Stammsatz Infotyp 9701 | 30 | PAYID | Abrechnungsidentifikator | nvarchar | 1 | 0 | | |
37 | PA9725 | HR Master Record: Infotype 9725 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
38 | PA9741 | HR Master Record: Infotype 9741 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
39 | PA9742 | HR Master Record: Infotype 9742 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
40 | PA9825 | HR Master Record: Infotype 9825 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
41 | PA9990 | HR Master Record: Infotype 9990 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
42 | PA9991 | HR Master Record: Infotype 9991 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
43 | PA9992 | HR Master Record: Infotype 9992 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
44 | PA9993 | HR Master Record: Infotype 9993 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
45 | PA9995 | HR Master Record: Infotype 9995 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
46 | PA9996 | HR Master Record: Infotype 9996 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
47 | PA9997 | HR Master Record: Infotype 9997 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
48 | PA9998 | HR Master Record: Infotype 9998 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
49 | PYC_D_PY_MSG | PYC: payroll message | 16 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
50 | T5Q_SUPERSTREAM | Super Stream Master Table | 11 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
51 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 13 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
52 | T7CNREW_APRPARS | Payroll result master table | 10 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPArgentina |
53 | PA0551 | Termination of contract: General data | 93 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
54 | T7AR28 | Assignment of SIJP periods to settled payrolls | 4 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
55 | T7AR75 | Annual Extra Payment (SAC): Off-cycle payroll run data | 4 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPAustralia |
56 | PA0701 | HR Terminations Data Container : Infotype 0701 | 32 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPBenefit Integration |
57 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
58 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
59 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
60 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
61 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
62 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPBrazil |
63 | PA0738 | Alimony adjustment for Brazil | 34 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPCanada |
64 | PA0221 | HR Master Record: Infotype 0221 (Manual Checks) | 146 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPChina |
65 | T7CN29 | Social insurance | 7 | PAYID | Payment id for social insurance | nvarchar | 1 | 0 | | |
TOPCollectionsDisbursements |
66 | ITAGCYDEPDIFF | Additional Information About Deposits and Differences | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
67 | ITAGCYPAY | Payment Information | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
68 | ITAGCYPM_ADD | Agency Collections: Payt Method Info. Addtl Payt Methods | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
69 | ITAGCYPM_BANK | Payment Methods: Bank | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
70 | ITAGCYPM_CC | Payment Methods: Credit Card | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
71 | ITAGCYPM_CHECK | Payment Methods: Check | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
72 | ITAGCYWD | Table for Withdrawal Information | 2 | PAYID | Payment ID | varbinary | 16 | 0 | | |
TOPContract Accounts Receivable and Payable |
73 | DFKKEXC | External Payment Information | 4 | PAYID | ID of External Payment | nvarchar | 35 | 0 | | |
74 | DFKKEXC_CL | External Payment Information - Clearing Proposals | 4 | PAYID | ID of External Payment | nvarchar | 35 | 0 | | |
75 | DFKKEXC_PAYINFO | Information for Payment Medium | 4 | PAYID | ID of External Payment | nvarchar | 35 | 0 | | |
TOPDenmark |
76 | PA0074 | HR Master Record: Infotype 0074 (Leave Processing - DK) | 147 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
77 | PA0578 | HR Master Record: Infotype 0578 | 28 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
78 | T5M49 | Date Identifiers for Special Payroll | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
79 | T5M58 | SAP-PBS Interface: Transfer Payroll Account (DK) | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
80 | T5M5Y | Assignment of Year and PBS Track to an Original Payroll | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
81 | T5M6P | Default Values for Leave Accumulation | 128 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
82 | T5M7D | Status Line for Payroll Run | 34 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
83 | T5M7W | File Entries Assignment from T5M7V | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
84 | T5M8G | Matchcode W Specifically for Payroll Step (DK) | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
85 | T5M8H | PBS error table for importing error file | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
86 | T5M8J | File entries for PBS file | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
87 | T5M8Z | Employer Assignment in Original Period | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
88 | T5M9H | Split Indicators for Wage Types Sent to PBS | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
89 | T5MFD | Retrieval of Official Statistics for DA/DS and FA | 7 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
90 | T5MFH | Special Transfer Days for Wage Types | 7 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
91 | T5MFJ | Correct FA Absence Statistics | 7 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
92 | T5MP1 | General Messages for the PBS Remuneration Statement | 7 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPFinland |
93 | T7FI1P | Time-dependent information for personnel area/subarea | 10 | PAYID | Payer identification for bank transfer file | nvarchar | 9 | 0 | | |
TOPIndia |
94 | T7INTE | Form 24Q - TAN number lock | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPInterface to External Payroll Systems |
95 | T5UOT | Tax Services: Terminations and Inactives | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPJapan |
96 | PA3239 | HR Master Record: Infotype 3239 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
97 | T5J69 | HR Attributes to SYOYO payroll run JP | 4 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPLong-Term Incentives |
98 | PA0762 | HR Master Record: Infotype 0762 (LTI Exercising) | 35 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPNew Zealand |
99 | PA0312 | Leave History Adjustments NZ | 35 | PAYID | Parental Lve Flag - NZ | nvarchar | 1 | 0 | | |
100 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 73 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPOff-Cycle |
101 | T52OCG | Off-Cycle: Indicators for Batch: Payroll, Subsequent Program | 8 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
102 | T52OCMP | Off-Cycle Flag for Mass Processing | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPPayroll |
103 | PA3234 | HR master record, infotype 3234 | 39 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
104 | T5H84 | Payroll log | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
105 | T5HNR | HU_NREN payroll table data of the "current month" | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
106 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 55 | PAYID | Identifikátor zúctovania | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
107 | HRPY_RGDIR | Directory for Payroll Results | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
108 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
109 | PA0128 | HR Master Record: Infotype 0128 (Notifications) | 31 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
110 | PA0267 | HR Master Record: Infotype 0267 (One time Payment off-cycle) | 37 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
111 | PA0815 | HR Master Record for Infotype 0815 | 43 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
112 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
113 | PYTIMESCREEN | PNP900: Fields For Time Selection | 2 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
114 | T51G1 | Off-Cycle Batch Table | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
115 | T52RIC | Retroactive Changes to Off-Cycle Infotypes | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
116 | T558B | Payroll Account Transfer: Payroll Periods | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
117 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 52 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
118 | PA0402 | HR Master Data Infotype 0402 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
119 | PA0403 | HR Master Record for Infotype 0403 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
120 | PA0657 | HR Master Record: Infotype 0657 | 43 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
121 | PA0829 | HR master record for infotypes 0829 | 31 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
122 | PA0831 | HR master record for infotypes 0831 | 93 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
123 | PA0834 | HR master record for infotypes 0834 | 31 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
124 | T7COT3 | Payroll external results transfer: COSEV | 15 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
125 | T7COT8 | Payroll external results transfer: COAVA | 42 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPPersonnel Management |
126 | T7HR1R | R-Sm ID | 5 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
127 | T7HR1S | R-Sm ID | 6 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
128 | T7HRA0 | Datum uplate - Napomene - GOD obrazac | 5 | PAYID | Identifikator obracuna placa | nvarchar | 1 | 0 | | |
129 | T7HRA3 | IP Form - Earnings | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
130 | T7HRA3N | IP Form - Earnings - New (w. OIB) | 9 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
131 | T7HRA3O | IP Form - Earnings - with IDENT in key | 10 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
132 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 73 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPRecruitment |
133 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 52 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPReuse Services for Country Development |
134 | PA0262 | HR Master Record: Infotype 0262 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
135 | T5JOCC | Payroll Category for Payroll Reason | 2 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPUnited Kingdom |
136 | T5G_DTONI | National Insurance Data Take-on | 7 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
TOPUSA |
137 | PA0446 | | 30 | PAYID | | nvarchar | 1 | 0 | | |
138 | PA0447 | US Federal Tax MTD | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
139 | PA0448 | US Federal Tax QTD | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
140 | PA0449 | HR Master Record: Infotype 0449 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
141 | PA0450 | HR Master Record: Infotype 0450 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
142 | PA0451 | HR Master Record: Infotype 0451 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
143 | PA0452 | HR Master Record: Infotype 0452 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
144 | PA0453 | HR Master Record: Infotype 0453 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
145 | PA0454 | HR Master Record: Infotype 0454 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
146 | PA0455 | HR Master Record: Infotype 0455 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
147 | PA0456 | HR Master Record: Infotype 0456 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
148 | PA0457 | HR Master Record: Infotype 0457 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
149 | PA0458 | HR Master Record for Infotype 0458 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
150 | PA0459 | HR Master Record for Infotype 0459 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
151 | PA0460 | HR Master Record for Infotype 0460 | 30 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |
152 | PA0909 | HR Master Record: Infotype 0909 | 32 | PAYID | Payroll Identifier | nvarchar | 1 | 0 | | |