| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2NZ_NZSUP | Payroll Result: Superannuation (NZSUP) - NZ | 17 | MEMNO | Superannuation Fund Membership Number NZ | nvarchar | 20 | 0 | | |
| 2 | P2RQ_QSPR | HR-AU-PS: Payroll structure for Superannuation | 17 | MEMNO | Superannuation Fund Membership Number Australia | nvarchar | 20 | 0 | | |
| 3 | P2RQ_QSUP | Superannuation structure for Australia | 17 | MEMNO | Superannuation Fund Membership Number Australia | nvarchar | 20 | 0 | | |
| 4 | P2UN_QSPR | HR-UN: Payroll structure for Superannuation | 17 | MEMNO | Superannuation Fund Membership Number Australia | nvarchar | 20 | 0 | | |
| TOPAustralia |
| 5 | PA0220 | Superannuation (Australia) | 25 | MEMNO | Superannuation Fund Membership Number Australia | nvarchar | 20 | 0 | | |
| TOPBank Customer Accounts |
| 6 | BCA_US_MEM_ITEMS | Memo item table | 3 | MEMNO | Memo item number | nvarchar | 12 | 0 | | |
| TOPFinland |
| 7 | T7FI1P | Time-dependent information for personnel area/subarea | 15 | MEMNO | Empolyer membership number used in stat. reporting | nvarchar | 5 | 0 | | |
| TOPHong Kong |
| 8 | PA0346 | HR Master Record: Infotype 0346 (Contribution plan) | 25 | MEMNO | Plan account no. | nvarchar | 20 | 0 | | |
| 9 | PA0347 | HR Master Record: Infotype 0347 (Entitlement plan) | 25 | MEMNO | Plan account no. | nvarchar | 20 | 0 | | |
| TOPNew Zealand |
| 10 | PA0310 | Superannuation NZ | 25 | MEMNO | Superannuation Fund Membership Number NZ | nvarchar | 20 | 0 | | |
| TOPUse Subcomponents |
| 11 | SODM | SAPoffice: distribution list contents | 7 | MEMNO | Object in distribution list: number from the ID | nvarchar | 12 | 0 | | |
