| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BR_GRDBT | Alimony debits | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
2 | P2BR_GRORD | Alimony order | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
3 | P2BR_GRPAY | Alimony calculations | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
4 | P2BR_GRREC | Alimony record | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
5 | P2MX_GRDBT | Maintenance Payment Debit | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
6 | P2MX_GRORD | Maintenance payment order | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
7 | P2MX_GRREC | Maintenance Payment payroll results | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
8 | P2RK_GRDBT | Payroll results Canada: Garnishment debt | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
9 | P2RK_GRORD | Payroll results Canada: Garnishment order | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
10 | P2RK_GRREC | Payroll results Canada: Garnishment record | 5 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
TOPBrazil |
11 | PA0736 | Alimony order for Brazil | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
12 | PA0737 | Alimony debit for Brazil | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
13 | PA0738 | Alimony adjustment for Brazil | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
TOPCanada |
14 | PA0066 | HR Master data infotype 0066 - Canadian garnishment: order | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
15 | PA0067 | HR master data infotype 0067 - Canadian garnishment: debt | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
16 | PA0068 | HR master data infotype 0068 - Canadian garnishment: adjust | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
TOPMexico |
17 | PA0426 | Garnishment | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
18 | PA0427 | Debts by garnishment | 24 | IONUM | Internal order number | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
19 | PA0476 | HR master record infotype 0476 (Deductions Spain) | 24 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | | |
20 | PA0477 | Personnel Master Record Infotype 0477: Debt (Garnishments) | 32 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | | |
21 | PA0478 | Personnel Master Record Infotype 0478: Adjustment (Garnish) | 24 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | | |
22 | PA0611 | HR Master Record: Infotype 0611 | 24 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | | |
23 | PA0612 | HR Master Record: Infotype 0612 | 24 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | | |