| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RK_GRORD | Payroll results Canada: Garnishment order | 25 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 2 | P2RU_GRDOC | Payroll Results: Garnishment for US Document | 12 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| TOPBenefits |
| 3 | T5UBA | Benefit plan | 7 | CRENR | Benefit provider | nvarchar | 8 | 0 | | |
| 4 | T5UBN | Benefit investment | 4 | CRENR | Benefit provider | nvarchar | 8 | 0 | | |
| 5 | T5UBW | Benefit provider | 3 | CRENR | Benefit provider | nvarchar | 8 | 0 | | |
| 6 | T74HQ | Benefit Information on Doctor Search via Internet | 3 | CRENR | Benefit provider | nvarchar | 8 | 0 | | |
| TOPCanada |
| 7 | PA0066 | HR Master data infotype 0066 - Canadian garnishment: order | 31 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 8 | T5KRC | Link HR tax payees to wage types via tax attributes | 7 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 9 | T5KRM | Canadian Tax Remittance Form PD7A Data | 5 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 10 | T5URA | HR payee derived from wage types via ZIP code | 7 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 11 | T5URB | HR payee derived from wage types via org. assignment | 8 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 12 | T5URC | HR payee for taxes derived from wage types via tax attr. | 7 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| TOPPayroll General Parts |
| 13 | PA0476 | HR master record infotype 0476 (Deductions Spain) | 54 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| TOPRussia |
| 14 | PA0296 | HR Master Record Infotype 0296 (Garnishment Document) | 27 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| TOPThird Party Remittance |
| 15 | T51R5 | Remittance accumulated posting data | 5 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 16 | T51R5_HIST | Remittance accumulated posting data history | 5 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 17 | T51RA | HR payee derived from wage type | 5 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 18 | T51RH | HR payee derived link to FI vendor | 3 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 19 | T51RL | HR payee link derived from HR payee | 3 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 20 | T51RS | HR payee derived link to remittance rule | 3 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 21 | T51RT | HR payee description | 4 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| 22 | T7US3PR_V0TYPE_T | Maintain wage types for other HR payees of V0 type 'T' | 5 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 23 | OIFSBLCD | Blocking Indicator for Business Locations | 5 | CRENR | Create new roles | nvarchar | 1 | 0 | | |
| TOPUSA |
| 24 | PA0194 | HR Master Record Infotype 0194 (Garnishment Document) | 26 | CRENR | HR payee number | nvarchar | 8 | 0 | | |
