| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BR_GRDBT | Alimony debits | 7 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
2 | P2MX_GRDBT | Maintenance Payment Debit | 7 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
3 | P2MX_GRREC | Maintenance Payment payroll results | 10 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
4 | P2RK_GRDBT | Payroll results Canada: Garnishment debt | 7 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
5 | P2RK_GRREC | Payroll results Canada: Garnishment record | 10 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
TOPBrazil |
6 | PA0737 | Alimony debit for Brazil | 25 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
7 | T7BRG0 | Calculation rule characteristics | 4 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
TOPCanada |
8 | PA0067 | HR master data infotype 0067 - Canadian garnishment: debt | 25 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
9 | T5KG9 | Garnishee fee | 7 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
TOPMexico |
10 | PA0427 | Debts by garnishment | 25 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
11 | T7MXG0 | Maintenance payment debt Mexico | 3 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
12 | PA0477 | Personnel Master Record Infotype 0477: Debt (Garnishments) | 34 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
13 | T52G7 | Debt | 4 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
14 | T52G8 | Description of the debt | 5 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
15 | T52GF | Calculation rule | 5 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
16 | T52GG | Description of the calculation rule | 6 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
17 | T52GH | Calculation rule characteristics | 5 | DBCOD | Debt code | nvarchar | 2 | 0 | | |
18 | T53G4 | Debt Types for Garnishments | 5 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
19 | T53G4T | Description of the debt | 6 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
20 | T53GT | Priority of debts | 5 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
21 | T53GU | Calculation Model | 5 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
22 | T53GV | Description of the calculation model | 6 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
23 | T53GW | Characteristics of the Calculation Rule | 5 | DBCOD | Debt Code | nvarchar | 2 | 0 | | |
TOPSpain |
24 | T5EG9 | Garnishee fee | 7 | DBCOD | Debt code | nvarchar | 2 | 0 | | |