| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_CD2_C | CD Posting: GL item settings | 3 | PAYTY | Type of Posting for Collections/Disbursements Document | nvarchar | 1 | 0 | | |
2 | /GSINS/INH_CD3_C | CD Posting: BP item settings | 3 | PAYTY | Type of Posting for Collections/Disbursements Document | nvarchar | 1 | 0 | | |
3 | /GSINS/INH_CD4_C | CD Posting: Variant-Type of Posting | 3 | PAYTY | Type of Posting for Collections/Disbursements Document | nvarchar | 1 | 0 | | |
4 | /GSINS/INH_RIDI | HCM-FSCD: List of HCM Pernr Items to be posted | 9 | PAYTY | Type of Posting for Collections/Disbursements Document | nvarchar | 1 | 0 | | |
5 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 16 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
6 | P2BG_BG_CUX | Difference table of payroll results | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
7 | P2BG_BG_DIF | Difference table of payroll results | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
8 | P2CO_COAVA | PC2CO_AVA | 41 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
9 | P2CO_COSEV | PC2CO_SEV | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
10 | P2HK_RETI | Payroll structure for retroactive accounting | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
11 | P2HK_RETO | Payroll structure for retroactive accounting | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
12 | P2IS_RETI | Payroll structure for retroactive accounting | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
13 | P2IS_RETO | Payroll structure for retroactive accounting | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
14 | P2KR_KRSP2 | Payroll Results Korea: Separation payroll II | 6 | PAYTY | Payment type | nvarchar | 2 | 0 | | |
15 | P2MX_GRORD | Maintenance payment order | 10 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
16 | P2NZ_NZHPI | Payroll Result: Holiday Payment Information NZHPI - NZ | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
17 | P2RH_HU_NREN | P21PA | 23 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
18 | P2RK_GRORD | Payroll results Canada: Garnishment order | 11 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
19 | P2RM_MVAC | Payroll Structure MVAC: Leave Handling (DK) | 121 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
20 | P2RO_RO_CUX | Difference table of payroll results | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
21 | P2RO_RO_DIF | Difference table of payroll results | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
22 | P2RR_RM | Payroll Results: Table for Master data (SG) | 49 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
23 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 16 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
24 | P2RU_CLM | Overpayments Processing structure | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
25 | P2RU_CLM_PERSON | Overpayments Processing structure | 16 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
26 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 12 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
27 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 21 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
28 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 16 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
29 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 16 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
30 | P2RX_EVAL_PERIOD | Index for Payroll Results Periods | 13 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
31 | P2RX_VERSC | Payroll Status Information | 17 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
32 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
33 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
34 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
35 | PA0556 | HR Master Record: Infotype 0556 | 31 | PAYTY | Payment type | nvarchar | 4 | 0 | | |
36 | PA3273 | HR Master Record: Infotype 3273 | 51 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
37 | PA9220 | HR Master Record: Infotype 9220 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
38 | PA9390 | Personal-Stammsatz Infotyp 9390 | 29 | PAYTY | Abrechnungstyp | nvarchar | 1 | 0 | | |
39 | PA9429 | Registro maestro de personal Infotipo 9429 | 29 | PAYTY | Tipo de nómina | nvarchar | 1 | 0 | | |
40 | PA9640 | Personal-Stammsatz Infotyp 9640 | 29 | PAYTY | Abrechnungstyp | nvarchar | 1 | 0 | | |
41 | PA9701 | Personal-Stammsatz Infotyp 9701 | 29 | PAYTY | Abrechnungstyp | nvarchar | 1 | 0 | | |
42 | PA9725 | HR Master Record: Infotype 9725 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
43 | PA9741 | HR Master Record: Infotype 9741 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
44 | PA9742 | HR Master Record: Infotype 9742 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
45 | PA9825 | HR Master Record: Infotype 9825 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
46 | PA9990 | HR Master Record: Infotype 9990 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
47 | PA9991 | HR Master Record: Infotype 9991 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
48 | PA9992 | HR Master Record: Infotype 9992 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
49 | PA9993 | HR Master Record: Infotype 9993 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
50 | PA9995 | HR Master Record: Infotype 9995 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
51 | PA9996 | HR Master Record: Infotype 9996 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
52 | PA9997 | HR Master Record: Infotype 9997 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
53 | PA9998 | HR Master Record: Infotype 9998 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
54 | PYC_D_PY_MSG | PYC: payroll message | 15 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
55 | T5FDSNPAYM | Temp table for PAYFR_RESULT-PAYM | 15 | PAYTY | Paie : Code type groupe rubriques | nvarchar | 5 | 0 | | |
56 | T5Q_SUPERSTREAM | Super Stream Master Table | 10 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
57 | T5UTLAVK | Additional Attributes of Tax Company on Tax Authority Level | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
58 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 12 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
59 | TFKKBRINRETCOD | Brazil: Receivables Return Codes Conversion | 2 | PAYTY | Receivables: Payment Type | nvarchar | 12 | 0 | | |
TOPArgentina |
60 | PA0551 | Termination of contract: General data | 92 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
61 | T7AR28 | Assignment of SIJP periods to settled payrolls | 11 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
62 | T7AR75 | Annual Extra Payment (SAC): Off-cycle payroll run data | 3 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPBenefit Integration |
63 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
64 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
65 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
66 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
67 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
68 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPBrazil |
69 | PA0738 | Alimony adjustment for Brazil | 33 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
70 | T7BRG1 | Alimony: calculation models | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPCanada |
71 | PA0221 | HR Master Record: Infotype 0221 (Manual Checks) | 145 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPDenmark |
72 | PA0074 | HR Master Record: Infotype 0074 (Leave Processing - DK) | 146 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
73 | PA0578 | HR Master Record: Infotype 0578 | 27 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
74 | T5M49 | Date Identifiers for Special Payroll | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
75 | T5M58 | SAP-PBS Interface: Transfer Payroll Account (DK) | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
76 | T5M5Y | Assignment of Year and PBS Track to an Original Payroll | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
77 | T5M6P | Default Values for Leave Accumulation | 127 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
78 | T5M7D | Status Line for Payroll Run | 33 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
79 | T5M7W | File Entries Assignment from T5M7V | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
80 | T5M8G | Matchcode W Specifically for Payroll Step (DK) | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
81 | T5M8H | PBS error table for importing error file | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
82 | T5M8J | File entries for PBS file | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
83 | T5M8Z | Employer Assignment in Original Period | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
84 | T5M9H | Split Indicators for Wage Types Sent to PBS | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
85 | T5MFD | Retrieval of Official Statistics for DA/DS and FA | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
86 | T5MFH | Special Transfer Days for Wage Types | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
87 | T5MFJ | Correct FA Absence Statistics | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
88 | T5MP1 | General Messages for the PBS Remuneration Statement | 6 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPHong Kong |
89 | T7HK04 | Control table for EOY Payment | 6 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
90 | T7HK4A | Events & reasons for LSP/Severance payments | 4 | PAYTY | Payment type for long services and severance | nvarchar | 1 | 0 | | |
91 | T7HK4B | Factor & constants for LSP/severance payments | 3 | PAYTY | Payment type for long services and severance | nvarchar | 1 | 0 | | |
TOPIndia |
92 | T7INTE | Form 24Q - TAN number lock | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPInterface to External Payroll Systems |
93 | T5UOT | Tax Services: Terminations and Inactives | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPJapan |
94 | PA3239 | HR Master Record: Infotype 3239 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
95 | T5J69 | HR Attributes to SYOYO payroll run JP | 3 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPKorea |
96 | T7KRS2 | Separation payment average calculation period | 2 | PAYTY | Payment type | nvarchar | 2 | 0 | | |
97 | T7KRS6 | Cumulation method | 2 | PAYTY | Payment type | nvarchar | 2 | 0 | | |
TOPNew Zealand |
98 | PT2001 | HR Time Record: Infotype 2001 (Absences) | 72 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
99 | T7NZLP | Leave Payment Rule Table - NZ | 7 | PAYTY | Leave Pay Type. | nvarchar | 1 | 0 | | |
TOPOff-Cycle |
100 | T52OCC | Categories for Off-Cycle Reasons | 3 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
101 | T52OCG | Off-Cycle: Indicators for Batch: Payroll, Subsequent Program | 7 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPPayroll |
102 | PA3234 | HR master record, infotype 3234 | 38 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
103 | T5H84 | Payroll log | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
104 | T5HNR | HU_NREN payroll table data of the "current month" | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
105 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 54 | PAYTY | Typ zúctovania | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
106 | HRPY_RGDIR | Directory for Payroll Results | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
107 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
108 | PA0128 | HR Master Record: Infotype 0128 (Notifications) | 28 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
109 | PA0267 | HR Master Record: Infotype 0267 (One time Payment off-cycle) | 36 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
110 | PA0815 | HR Master Record for Infotype 0815 | 42 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
111 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 1 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
112 | PYTIMESCREEN | PNP900: Fields For Time Selection | 1 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
113 | T51G1 | Off-Cycle Batch Table | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
114 | T52BX | Valid Special Payroll Runs for Countries | 2 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
115 | T52RIC | Retroactive Changes to Off-Cycle Infotypes | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
116 | T558B | Payroll Account Transfer: Payroll Periods | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
117 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 51 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
118 | PA0402 | HR Master Data Infotype 0402 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
119 | PA0403 | HR Master Record for Infotype 0403 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
120 | PA0657 | HR Master Record: Infotype 0657 | 42 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
121 | PA0829 | HR master record for infotypes 0829 | 30 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
122 | PA0831 | HR master record for infotypes 0831 | 92 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
123 | PA0834 | HR master record for infotypes 0834 | 30 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
124 | T7COT3 | Payroll external results transfer: COSEV | 14 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
125 | T7COT8 | Payroll external results transfer: COAVA | 41 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPPersonnel Management |
126 | T7HR1R | R-Sm ID | 4 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
127 | T7HR1S | R-Sm ID | 5 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
128 | T7HRA0 | Datum uplate - Napomene - GOD obrazac | 4 | PAYTY | Tip obracuna placa | nvarchar | 1 | 0 | | |
129 | T7HRA3 | IP Form - Earnings | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
130 | T7HRA3N | IP Form - Earnings - New (w. OIB) | 8 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
131 | T7HRA3O | IP Form - Earnings - with IDENT in key | 9 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPPersonnel Time Management |
132 | PA2001 | HR Time Record: Infotype 2001 (Absences) | 72 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPPublic Sector |
133 | T5QPBS4A | Payment Type for terminations & redundancies | 2 | PAYTY | Payment Type for Terminations & Redundancies | nvarchar | 4 | 0 | | |
134 | T5QPBS4AT | Text for Payment Type for terminations & redundancies | 3 | PAYTY | Payment Type for Terminations & Redundancies | nvarchar | 4 | 0 | | |
135 | T5QPBS4B | Termination Payment Type | 3 | PAYTY | Payment Type for Terminations & Redundancies | nvarchar | 4 | 0 | | |
TOPRecruitment |
136 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 51 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPReuse Services for Country Development |
137 | PA0262 | HR Master Record: Infotype 0262 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPUnited Kingdom |
138 | T5G_DTONI | National Insurance Data Take-on | 6 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
TOPUSA |
139 | PA0446 | | 29 | PAYTY | | nvarchar | 1 | 0 | | |
140 | PA0447 | US Federal Tax MTD | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
141 | PA0448 | US Federal Tax QTD | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
142 | PA0449 | HR Master Record: Infotype 0449 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
143 | PA0450 | HR Master Record: Infotype 0450 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
144 | PA0451 | HR Master Record: Infotype 0451 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
145 | PA0452 | HR Master Record: Infotype 0452 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
146 | PA0453 | HR Master Record: Infotype 0453 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
147 | PA0454 | HR Master Record: Infotype 0454 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
148 | PA0455 | HR Master Record: Infotype 0455 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
149 | PA0456 | HR Master Record: Infotype 0456 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
150 | PA0457 | HR Master Record: Infotype 0457 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
151 | PA0458 | HR Master Record for Infotype 0458 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
152 | PA0459 | HR Master Record for Infotype 0459 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
153 | PA0460 | HR Master Record for Infotype 0460 | 29 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |
154 | PA0909 | HR Master Record: Infotype 0909 | 31 | PAYTY | Payroll type | nvarchar | 1 | 0 | | |