| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2BR_GRORD | Alimony order | 8 | GCATE | Code for category | nvarchar | 1 | 0 | | |
2 | P2CO_COGAR | PC2CO_GAR | 6 | GCATE | Garnishment category | nvarchar | 1 | 0 | | |
3 | P2MX_GRORD | Maintenance payment order | 7 | GCATE | Code for category | nvarchar | 1 | 0 | | |
4 | P2RK_GRORD | Payroll results Canada: Garnishment order | 7 | GCATE | Code for category | nvarchar | 1 | 0 | | |
5 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 9 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
6 | T7RUG2 | OBSOLETE Garnishmetn Document Category (Russia) | 3 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
7 | T7RUG2T | OBSOLETE: Garnishmetn Document Category (Russia): Texts | 4 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
TOPBrazil |
8 | PA0736 | Alimony order for Brazil | 26 | GCATE | Code for category | nvarchar | 1 | 0 | | |
9 | T7BRG0 | Calculation rule characteristics | 3 | GCATE | Code for category | nvarchar | 1 | 0 | | |
TOPCanada |
10 | PA0066 | HR Master data infotype 0066 - Canadian garnishment: order | 26 | GCATE | Code for category | nvarchar | 1 | 0 | | |
11 | T5KG9 | Garnishee fee | 3 | GCATE | Code for category | nvarchar | 1 | 0 | | |
TOPMexico |
12 | PA0426 | Garnishment | 26 | GCATE | Code for category | nvarchar | 1 | 0 | | |
13 | T7MXG0 | Maintenance payment debt Mexico | 2 | GCATE | Code for category | nvarchar | 1 | 0 | | |
TOPPayroll General Parts |
14 | PA0476 | HR master record infotype 0476 (Deductions Spain) | 26 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
15 | T52G2 | Garnishment category | 3 | GCATE | Code for category | nvarchar | 1 | 0 | | |
16 | T52G3 | Description of the garnishment category | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
17 | T52G6 | Remittance rule | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
18 | T52G7 | Debt | 3 | GCATE | Code for category | nvarchar | 1 | 0 | | |
19 | T52G8 | Description of the debt | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
20 | T52GF | Calculation rule | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
21 | T52GG | Description of the calculation rule | 5 | GCATE | Code for category | nvarchar | 1 | 0 | | |
22 | T52GH | Calculation rule characteristics | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
23 | T52GI | Garnishee fee | 4 | GCATE | Code for category | nvarchar | 1 | 0 | | |
24 | T52GJ | Description of garnishee fee | 5 | GCATE | Code for category | nvarchar | 1 | 0 | | |
25 | T53G1 | Garnishment Category | 3 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
26 | T53G1T | Description of the garnishment category | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
27 | T53G4 | Debt Types for Garnishments | 3 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
28 | T53G4T | Description of the debt | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
29 | T53GQ | Service Charge | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
30 | T53GR | Service Charge Description | 5 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
31 | T53GS | Service Charge Characterisitics | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
32 | T53GT | Priority of debts | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
33 | T53GU | Calculation Model | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
34 | T53GV | Description of the calculation model | 5 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
35 | T53GW | Characteristics of the Calculation Rule | 4 | GCATE | Code for Garnishment Category | nvarchar | 1 | 0 | | |
TOPPersonnel Administration |
36 | PA0835 | HR master record for infotypes 0835 | 25 | GCATE | Garnishment category | nvarchar | 1 | 0 | | |
37 | T7CO16 | Garnishment categories | 2 | GCATE | Garnishment category | nvarchar | 1 | 0 | | |
38 | T7CO16T | Garnishment category texts (CO) | 2 | GCATE | Garnishment category | nvarchar | 1 | 0 | | |
39 | T7COT6 | Payroll external results transfer: COGAR | 6 | GCATE | Garnishment category | nvarchar | 1 | 0 | | |
TOPRussia |
40 | PA0296 | HR Master Record Infotype 0296 (Garnishment Document) | 44 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
41 | T7RUG0 | HR: Garnishment Order Types | 4 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
42 | T7RUG1 | Garnishment Document Category | 2 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
43 | T7RUGX | HR: Garnishmetn Document Category (Russia) - TEXT table | 3 | GCATE | Garnishment Document Category | nvarchar | 1 | 0 | | |
TOPSpain |
44 | T5EG9 | Garnishee fee | 3 | GCATE | Code for category | nvarchar | 1 | 0 | | |
TOPUSA |
45 | PA0194 | HR Master Record Infotype 0194 (Garnishment Document) | 46 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
46 | T5UG0 | HR: Garnishment Order Types | 4 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
47 | T5UG1 | HR: Garnishment Document Category | 2 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
48 | T5UG6 | Government Service Charge | 4 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
49 | T5UG7 | Government Remittance Rule | 4 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
50 | T5UG8 | Company Remittance Rule | 5 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
51 | T5UGC | Service Charge | 4 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
52 | T5UGG | Company Service Charge | 5 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |
53 | T5UGI | Garnishment Letters | 4 | GCATE | Garnishment document category | nvarchar | 1 | 0 | | |