| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRPADNLP_LOGIMME | NL Pens: Immediate Payments - log for Payroll Process | 7 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
2 | P2BR_GRREC | Alimony record | 12 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
3 | P2CN_CNREI | Payroll result: structure for retro difference details | 16 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
4 | P2CN_CNREO | Payroll result: structure for retro difference details | 16 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
5 | P2CO_COAVA | PC2CO_AVA | 30 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
6 | P2HK_RETI | Payroll structure for retroactive accounting | 18 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
7 | P2HK_RETO | Payroll structure for retroactive accounting | 18 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
8 | P2IS_RETI | Payroll structure for retroactive accounting | 18 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
9 | P2IS_RETO | Payroll structure for retroactive accounting | 18 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
10 | P2MX_GRREC | Maintenance Payment payroll results | 16 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
11 | P2NZ_SALSAC | Salary Sacrifice Details | 15 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
12 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 16 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
13 | P2RB_BEEVL | Payroll Results: Belgium table for Evaluation | 14 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
14 | P2RE_GARNT | Payroll result: Garnishments (Spain) | 17 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
15 | P2RH_HU_HKIF | P21PB | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
16 | P2RI_IPCUM | RI cluster structure for cumulations (IPCUM) | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
17 | P2RI_ITIOT | RI cluster structure for retroactive accounting | 15 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
18 | P2RQ_HT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
19 | P2RQ_NT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
20 | P2RQ_SMTH | SMTH and SQTR for Superannuation (Australia) | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
21 | P2RQ_SQTR | SMTH and SQTR for Superannuation (Australia) | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
22 | P2RR_SRT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
23 | P2RX_BT | Payroll Results: Bank Transfers | 5 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
24 | P2RX_BT_PERSON | Payment-Related Information (Person) | 7 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
25 | P2RX_CODIST | Distribution opf Liabilities | 15 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
26 | P2RX_GRT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
27 | P2RX_RT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
28 | P2RX_RT_PERSON | Results Table (Person) | 17 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
29 | P2TN_TWOT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
30 | P2UA_UARF | Structure for Ukrainian social insurance(PF) calculation | 16 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
31 | P2UA_UART | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
32 | P2UA_UATI | Structure for Ukrainian social insurance(PF) calculation | 17 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
33 | P2UA_UATR | Structure for Ukrainian social insurance(PF) calculation | 17 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
34 | P2UA_UATS | Structure for Ukrainian social insurance(PF) calculation | 17 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
35 | P2UN_HT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
36 | P2UN_NT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
37 | P2UR_RURT | Payroll Results: Results Table | 13 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
38 | T5FDSNPAYM | Temp table for PAYFR_RESULT-PAYM | 12 | BTZNR | Affectation virements | varbinary | 1 | 0 | | |
39 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 22 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
TOPAustria |
40 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 14 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
TOPCompany Pension Scheme Germany |
41 | P01CBE | Active CPS Contributions | 14 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
42 | P01CBT | Transfer Records for Reimbursement of Contributions CPS | 4 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
43 | P01CKA | Funded Pension Rights CPS | 14 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
44 | P01CRP | Reimbursement Amounts CPS | 4 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
45 | P01VA_BE | Actual Contributions CPS for Pension Equalization Payment | 15 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
46 | P01VA_CBE | Reduction Amounts for Actual Contributions CPS | 15 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
47 | P01VA_CKA | Reduction Amounts for Funded Pension Rights CPS | 17 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
48 | P01VA_KA | Funded Pension Rights CPS for Pension Equalization Payment | 17 | BTZNR | Assignment of Reimbursement Transfers | nvarchar | 4 | 0 | | |
TOPData Transfer |
49 | PPMIX | Index Payroll Results Lines -> Posting Lines for Payment | 8 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
TOPDenmark |
50 | T5M9H | Split Indicators for Wage Types Sent to PBS | 14 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
TOPGermany |
51 | T5D0I | Fictitious Run Control: Wage Type Assignment | 18 | BTZNR | Delete Indicator for Bank Transfers | nvarchar | 1 | 0 | | |
TOPOff-Cycle |
52 | T52OCL | Off-cycle: Bank Transfer Replaced by Check or Reversed | 5 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
TOPPayment Transactions |
53 | PAYR | Payment Medium File | 56 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
54 | REGUH | Settlement data from payment program | 111 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | | |
TOPPayroll |
55 | T5TA1 | External transfers | 5 | BTZNR | Sequential number (field) | nvarchar | 2 | 0 | | |
56 | T7SKA1 | External transfers | 5 | BTZNR | Sequence number (four characters) | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
57 | T558D | Transfer Wage Types with Split Indicator | 12 | BTZNR | HR: Outsourcing: Transfer assignment | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
58 | T7COT8 | Payroll external results transfer: COAVA | 30 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
TOPPersonnel Management |
59 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 17 | BTZNR | Assignment of Bank Transfers | varbinary | 1 | 0 | | |
TOPTools |
60 | T532B | HR: Connection to Third-Party Payroll: Choice of Wage Types | 14 | BTZNR | Component 709: Entry field for field selection in PC207 | nvarchar | 1 | 0 | | |