| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 26 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
2 | P2BR_BRTAX | Withholding Income Tax | 6 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
3 | P2CN_CNSP | Payroll result: Special Payment (CN) | 26 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
4 | P2CN_TAX | Payroll result: Income Tax (CN) | 35 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
5 | P2NZ_KIWCO | Kiwi Saver and Complying Fund Details | 7 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
6 | P2NZ_NZHPI | Payroll Result: Holiday Payment Information NZHPI - NZ | 9 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
7 | P2RG_WEARN | NI: payment history of affected wagetype | 10 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
8 | P2RJ_MST | Payroll result: Monthly socail insurance table | 10 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
9 | P2RJ_RETTAX | Payroll Results: Detailed Retirement Tax Infomation | 6 | PAYDT | Pay Date | nvarchar | 8 | 0 | | |
10 | P2RX_VERSC | Payroll Status Information | 23 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
11 | P2TN_NHI | Payroll Structure NHI Taiwan | 29 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
12 | PA3312 | HR Master Record: Infotype 3312 | 90 | PAYDT | Pay Date | nvarchar | 8 | 0 | | |
13 | PA3364 | HR Master Record: Infotype 3364 | 31 | PAYDT | Pay Date | nvarchar | 8 | 0 | | |
14 | T5Q_SUPERSTREAM | Super Stream Master Table | 13 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
15 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 20 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
16 | T77WWW_CLTRANSD | Cluster table for storing transaction data. | 15 | PAYDT | Payment Date | nvarchar | 8 | 0 | | |
17 | T77WWW_CLTRAN_BU | Backup Table for Storing Transaction Data | 15 | PAYDT | Payment Date | nvarchar | 8 | 0 | | |
18 | T7CNREW_APRPARS | Payroll result master table | 5 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
19 | T7HRJOPPD | JOPPD Form data - Intermediate table | 17 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
20 | T7TW7A | SNHI report history data record | 4 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPBenefits |
21 | PA0270 | HR Master Data Record: Infotype 0270 (COBRA Payments) | 24 | PAYDT | COBRA payment date | nvarchar | 8 | 0 | | |
TOPCanada |
22 | T5KYA | Year end reporting history table | 4 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
23 | DFKKCOLLPAYMLINK | Assignment of Collection Payments to Collection Units | 11 | PAYDT | Payment Date | nvarchar | 8 | 0 | | |
TOPDenmark |
24 | T5M58 | SAP-PBS Interface: Transfer Payroll Account (DK) | 3 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
25 | T5M7W | File Entries Assignment from T5M7V | 7 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
26 | T5M8G | Matchcode W Specifically for Payroll Step (DK) | 4 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
27 | T5M8H | PBS error table for importing error file | 4 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
28 | T5M8J | File entries for PBS file | 4 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
29 | T5M8Z | Employer Assignment in Original Period | 3 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
30 | T5M9H | Split Indicators for Wage Types Sent to PBS | 3 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
31 | T5MFD | Retrieval of Official Statistics for DA/DS and FA | 6 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
32 | T5MFH | Special Transfer Days for Wage Types | 6 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
33 | T5MFJ | Correct FA Absence Statistics | 6 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
34 | T5MP1 | General Messages for the PBS Remuneration Statement | 8 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
TOPExpenditure Certification |
35 | FMEUFEXP | Certified Expenditure Documents | 22 | PAYDT | Payment Date | nvarchar | 8 | 0 | | |
TOPHong Kong |
36 | T7HK04 | Control table for EOY Payment | 5 | PAYDT | Pay date for EOY payment | nvarchar | 8 | 0 | | |
TOPInterface to External Payroll Systems |
37 | T5UOT | Tax Services: Terminations and Inactives | 6 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPJapan |
38 | PA3204 | HR Master Record: Infotype 3204 | 24 | PAYDT | Pay Date | nvarchar | 8 | 0 | | |
TOPMalaysia |
39 | T5LES | ESS Malaysia: TP1 TP2 | 15 | PAYDT | Payment Date | nvarchar | 8 | 0 | | |
TOPPayroll |
40 | T7BGA2 | Changes of external transfers (IT11) | 4 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
41 | T7ROA5 | Changes of external transfers (IT11) | 4 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
42 | T7SIA0 | Annual tax - Paydays x Days of payments | 3 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
43 | T7SIA5 | History of repayments | 5 | PAYDT | | nvarchar | 8 | 0 | | |
44 | T7SIREK11A | State for REK field 011a | 4 | PAYDT | Datum izplacila za rezultat obracuna plac | nvarchar | 8 | 0 | | |
TOPPayroll General Parts |
45 | HRPY_RGDIR | Directory for Payroll Results | 24 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
46 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 24 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
47 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 7 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
48 | T558B | Payroll Account Transfer: Payroll Periods | 6 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPPersonnel Management |
49 | T7HR1R | R-Sm ID | 3 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
50 | T7HR1S | R-Sm ID | 4 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |
51 | T7HRA0 | Datum uplate - Napomene - GOD obrazac | 3 | PAYDT | | nvarchar | 8 | 0 | | |
TOPSingapore |
52 | PA0183 | HR Master Record: Infotype 0183 [Awards] (SG) | 28 | PAYDT | Pay date for awards | nvarchar | 8 | 0 | | |
TOPTax Reporter |
53 | T51T9 | Tax pay dates | 3 | PAYDT | Tax pay date | nvarchar | 6 | 0 | | |
54 | T5UT1 | Tax Interface Table: Payroll results | 7 | PAYDT | Tax pay date | nvarchar | 6 | 0 | | |
55 | T5UT2 | Deposited taxes, that have to be reported in tax forms | 6 | PAYDT | Tax pay date | nvarchar | 6 | 0 | | |
TOPUnited Kingdom |
56 | T5G_DTONI | National Insurance Data Take-on | 8 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | |