| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 44 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
2 | P2FI_CSI | Social ins & result structure for Finland | 11 | EMFSL | Pension insurance contract number | nvarchar | 11 | 0 | | |
3 | P2FI_SI | Social ins & result structure for Finland | 11 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
4 | P2RB_I0125 | Garnishment payroll Belgium | 22 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
5 | P2RG_COURT | Types of Court Order (GB) | 22 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
6 | P2RH_HU_MEMB | P21MB | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
7 | P2RL_EPF | Payroll result: EPF (Malaysia) | 22 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
8 | P2RL_SOCSO | Payroll result: SOCSO ( Malysian Social Insurance ) | 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
9 | P2RL_TAX | Payroll result: Tax (Malaysia) | 19 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
10 | P2RM_MGAR | Garnishments DK | 15 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
11 | P2RP_MF | HR-PT: Payroll Results: Membership fees | 9 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
12 | P2RX_BT | Payroll Results: Bank Transfers | 15 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
13 | P2RX_BT_PERSON | Payment-Related Information (Person) | 17 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
14 | P2VE_SEN | HRMS-VE: Information on Length of Service | 11 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
15 | T521C | Check Table for Payees | 5 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
16 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 32 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
17 | T7RU_521B | Payee Keys (Russia extension for T521B) | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPAustria |
18 | PA0136 | HR Master Record: Infotype 0136 (Garn. Transfer A) | 39 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
19 | PA0751 | HR Master Record: Infotype 0751 (Company Pension Plan AT) | 28 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
20 | T5A1U | Company Employee Pension Fund | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
21 | T5A9G | Company Number of Union | 3 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPBelgium |
22 | PA0125 | HR Master Record: Infotype 0125 (Garnishment B) | 28 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPBrazil |
23 | T7BR1B | Union | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
24 | T7BRB1 | Branch - general information | 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
25 | T7BRTA | Union dues | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPChile |
26 | PA3235 | HR Master Record: Infotype 3235 | 27 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
27 | T7CL28 | Company - Receptor | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
28 | T7CL29 | Code for each Institution | 3 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
29 | T7CL36 | Pension plan beneficiary information | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPCompany Pension Scheme Germany |
30 | P01CBT | Transfer Records for Reimbursement of Contributions CPS | 24 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPDenmark |
31 | PA0200 | HR Master Record, Infotype 0200 (Garnishments DK) | 41 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
32 | T5M7P | Garnishment Types in Danish Payroll (IT 200) | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPFinland |
33 | T7FI02 | Pension insurance table (Finland) | 5 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
34 | T7FI07 | Accident insurance table (Finland) | 5 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
35 | T7FITELME | TEL messages | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
36 | T7FITUP | Assignment of Payee to Trade Union / Local Finland | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPGermany |
37 | P01Y15 | PAISY: Management Table Subrecord Type 15 | 31 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
38 | PA0010 | HR Master Record: Infotype 0010 (Capital Formation) | 34 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
39 | PA0026 | HR Master Record: Infotype 0026 (Company Insurance) | 47 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
40 | PA0116 | HR Master Record: Infotype 0116 (Garn. Transfer D) | 38 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
41 | T5DRB | AVmG: Investment Institute | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPGreat Britain |
42 | PA0070 | HR Master Record: Infotype 0070 (Court Orders - GB) | 37 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
43 | T5G80 | HR-GB: Payee Keys | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPIndia |
44 | T7INT5 | Personnel subarea grouping for Tax | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
45 | T7INU3 | Slab codes for states | 12 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPMalaysia |
46 | T5LEP | Employee Provident fund for Malaysia | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
47 | T5LSP | Employer reference for SOCSO (Malaysia) | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
48 | T5LTP | Employer reference for tax | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPNorway |
49 | T5V2B | Union table | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
50 | T5V4C | Assignment of KID number to Payee Key | 3 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPPayroll |
51 | T5H8M | MNYP-kódok megfeleltetései | 2 | EMFSL | Átutalás fogadókulcsa | nvarchar | 8 | 0 | | |
52 | T5HVM | Magánnyugdíjpénztár adónem kódok | 2 | EMFSL | Átutalás fogadókulcsa | nvarchar | 8 | 0 | | |
53 | T5TA1 | External transfers | 26 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
54 | T5TPF | Configuration table for medium of pension funds | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
55 | T5TZP | Konfiguracní tabulka pro médium zivotního pojistení | 3 | EMFSL | Klíc príjemce pro financní prevody | nvarchar | 8 | 0 | | |
56 | T7BG10 | Insurance Bank transfer | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
57 | T7BG20 | Tax Bank transfer | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
58 | T7BGA1 | Bank transfer - interface table | 22 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
59 | T7BGE3 | Base for required amount | 3 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
60 | T7RO10 | Insurance institutions | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
61 | T7RO20 | Tax institutions | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
62 | T7ROA1 | Bank transfer - interface table | 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
63 | T7ROE3 | Base for required amount | 3 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
64 | T7SIA6 | Bank transfer - interface table | 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
65 | T7SIBU | Bank Units Slovenia | 14 | EMFSL | Kljuc prejemnika za nakazila | nvarchar | 8 | 0 | | |
66 | T7SIV1 | Voluntary healt insurance contributions | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
67 | T7SIV2 | Voluntary healt insurance contributions | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
68 | T7SKA1 | External transfers | 26 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
69 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 51 | EMFSL | Klúc príjemcu pre financné prevody | nvarchar | 8 | 0 | | |
70 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 38 | EMFSL | Klúc príjemcu pre financné prevody | nvarchar | 8 | 0 | | |
71 | T7UATAR | Tax Administration Properties | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
72 | T7UA_521B | Payee Keys (Ukranian extension for table T521B) | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPPension fund Netherlands |
73 | PA0665 | Personal-Stammsatz Infotyp 0665 | 28 | EMFSL | Ontvangercode voor overschrijvingen | nvarchar | 8 | 0 | | |
74 | T521B_PF | Ontvangercodes (extensie bij T521B voor PF) | 2 | EMFSL | Ontvangercode voor overschrijvingen | nvarchar | 8 | 0 | | |
TOPPension Fund Switzerland |
75 | PA3230 | Personnel Master Record for Infotype 3230 | 35 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
76 | T5CD3 | House Bank Pension Fund for Non-Recurring Payments | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
77 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 48 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
78 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 35 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
79 | PA0057 | HR Master Record: Infotype 0057 (Membership Fees) | 24 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
80 | PA0226 | Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.) | 36 | EMFSL | Empfängerschlüssel für Überweisungen | nvarchar | 8 | 0 | | |
81 | T521B | Payee Keys | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPPersonnel Management |
82 | T7HR10 | Insurance institutions | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
83 | T7HR20 | Tax Institution | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
84 | T7HR21C | Check Table Company code x Payees | 4 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
85 | T7HRA1 | Bank transfer - interface table | 10 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
86 | T7HRBPX | Conversion IT 9 to T521B proposal | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
87 | T7HRDO | Statutory deductions Croatia | 9 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
88 | T7HRDS | Control codes for stat. deductions and company codes Croatia | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
89 | T7HRKP | Control codes for payees Croatia | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
90 | T7HRMU | Municipality codes (Croatia) | 7 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
91 | T7HRMW | Control numbers - municipalities and company codes (Croatia) | 5 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
92 | T7HRPG | Control codes for payees Croatia | 6 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPProcess Controls -Automated Controls |
93 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 28 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPRecruitment |
94 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 48 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPReuse Services for Country Development |
95 | T799BPP05 | Connection Between Contribution and Receiver | 8 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPRussia |
96 | T7RU1B | Payee Keys of receiving orders (Russia standard) | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPSouth Africa |
97 | PA0151 | HR Master Record Infotype 0151 (Ext.Insurance South Africa) | 24 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPSpain |
98 | PA0887 | HR master record, infotype 0887 | 35 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
99 | T5E21 | Pension developer | 2 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPSwitzerland |
100 | PA0980 | HR Master Record Infotype 0980 | 51 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |
TOPVenezuela |
101 | PA0401 | HRMS-VE: Table for Benefits Infotype (IT401) | 27 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | |