| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P01PF_PFBB_DIR | PO Rebuild: Transfer Garnishable Amount Directly | 4 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
2 | P2RA_CMASS | Payroll Result: Garnishment (A) - Net Parts | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
3 | P2RA_GRDLG | Payroll Result: Garnishment (A) - Bases | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
4 | P2RA_GUTHA | Payroll Result: Garnishment (A) - Credit | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
5 | P2RA_MASSE | Payroll Result: Garnishment (A) - Net Parts with Differences | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
6 | P2RA_STAUS | Payroll Result: Garnishment (A) - Compensation Payment | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
7 | P2RA_STPFB | Payroll Result: Garnishment (A) - Garnishable Amt (Mst.Data) | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
8 | P2RA_STPSO | Payroll Result: Garnishment (A) - Special Condition | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
9 | P2RD_APFBT | Payroll Result: Garnishment D - Garnishable Amount | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
10 | P2RD_APFGR | Payroll Result: Garnishment D - Garnishment Bases | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
11 | P2RD_GUTHA | Payroll Result: Garnishment D - Cluster Key DP | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
12 | P2RD_STAUS | Payroll Result: Garnishment D - Settlement Payment | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
13 | P2RD_STLGA | Payroll Result: Garnishment D - Spec. Cond. Wage Types | 6 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
14 | P2TH_PFUND | Payroll Results : Provident Fund TH | 8 | PFNUM | Provident Fund Number (TH) | nvarchar | 20 | 0 | | |
15 | T7UNPF_HR_STFHD | Staff Member Header Table | 5 | PFNUM | Pension Number | nvarchar | 6 | 0 | | |
TOPAustria |
16 | PA0131 | HR Master Record: Infotype 0131 (Garnishment/Cession A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
17 | PA0132 | HR Master Record: Infotype 0132 (Garnishment Claim A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
18 | PA0133 | HR Master Record: Infotype 0133 (Garn. Interest A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
19 | PA0134 | HR Master Record: Infotype 0134 (Garnishment Amount A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
20 | PA0135 | HR Master Record: Infotype 0135 (Spec. Garn. Cond. A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
21 | PA0136 | HR Master Record: Infotype 0136 (Garn. Transfer A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
22 | PA0137 | HR Master Record: Infotype 0137 (Garn. Compensation A) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
TOPGarnishmentCession |
23 | P01PF_TILG | Garnishment of Principle of Origin: Repayment Amounts | 5 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
TOPGermany |
24 | PA0111 | HR Master Record: Infotype 0111 (Garnishment/Cession - D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
25 | PA0112 | HR Master Record: Infotype 0112 (Garnishment Claim - D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
26 | PA0113 | HR Master Record: Infotype 0113 (Garnish. Interest - D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
27 | PA0114 | HR Master Record: Infotype 0114 (Garnishment Amount D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
28 | PA0115 | HR Master Record: Infotype 0115 (Garnishment Wages D ) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
29 | PA0116 | HR Master Record: Infotype 0116 (Garn. Transfer D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
30 | PA0117 | HR Master Record: Infotype 0117 (Garn. Compensation D) | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
31 | PA0904 | HR Master Record Infotype 0904 | 25 | PFNUM | Garnishment Number | nvarchar | 3 | 0 | | |
TOPNon Profit Organizations |
32 | PA0961 | HR Master Record: Infotype 0961 | 28 | PFNUM | Pension Fund Number | nvarchar | 20 | 0 | | |
TOPThailand |
33 | PA0366 | Provident Fund THAILAND | 24 | PFNUM | Provident Fund Number (TH) | nvarchar | 20 | 0 | | |