| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BR_GRORD | Alimony order | 7 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
2 | P2MX_GRORD | Maintenance payment order | 6 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
3 | P2RK_GRORD | Payroll results Canada: Garnishment order | 6 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
TOPBrazil |
4 | PA0736 | Alimony order for Brazil | 25 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
5 | T7BRG0 | Calculation rule characteristics | 2 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
TOPCanada |
6 | PA0066 | HR Master data infotype 0066 - Canadian garnishment: order | 25 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
7 | T5KG9 | Garnishee fee | 2 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
TOPMexico |
8 | PA0426 | Garnishment | 25 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
TOPPayroll General Parts |
9 | PA0476 | HR master record infotype 0476 (Deductions Spain) | 25 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
10 | T52G0 | Jurisdiction | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
11 | T52G1 | Description of the jurisdiction | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
12 | T52G6 | Remittance rule | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
13 | T52GF | Calculation rule | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
14 | T52GG | Description of the calculation rule | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
15 | T52GH | Calculation rule characteristics | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
16 | T52GI | Garnishee fee | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
17 | T52GJ | Description of garnishee fee | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
18 | T53G0 | Jurisdiction | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
19 | T53G0T | Description of the jurisdiction | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
20 | T53G4 | Debt Types for Garnishments | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
21 | T53G4T | Description of the debt | 5 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
22 | T53GQ | Service Charge | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
23 | T53GR | Service Charge Description | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
24 | T53GS | Service Charge Characterisitics | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
25 | T53GT | Priority of debts | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
26 | T53GU | Calculation Model | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
27 | T53GV | Description of the calculation model | 4 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
28 | T53GW | Characteristics of the Calculation Rule | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
29 | T53GY | Garnishments Elements | 3 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |
TOPSpain |
30 | T5EG9 | Garnishee fee | 2 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | | |