| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | FCODE | Superannuation Fund Code NZ | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PNZ_FCODE | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SEQNR | Allow NULL? |
| 9 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | RAW | | Yes | | CNTRN | |
| 10 | SUPSC | Superannuation Salary Usage | char | 1 | 0 | CHAR | (N' ') | Yes | | PNZ_SUPSC | Allow NULL? |
| 11 | SUPES | Superannuation Annual Salary | decimal | 9 | 2 | CURR | ((0)) | Yes | | PNZ_SUPES | |
| 12 | EEPER | Default Employee Contribution percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | PNZ_EEPER | |
| 13 | EEAMT | Superannuation Employee Contribution Amount NZ | decimal | 9 | 2 | CURR | ((0)) | Yes | | PNZ_EEAMT | |
| 14 | ERPCT | Super. company contrib. fixed percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | PNZ_ERPCT | |
| 15 | ERAMT | Super. Company Contribution amount | decimal | 9 | 2 | CURR | ((0)) | Yes | | PNZ_ERAMT | |
| 16 | ERMUL | Super. company contrib. multiple of employee | decimal | 5 | 2 | DEC | ((0)) | Yes | | PNZ_ERMUL | |
| 17 | MEMNO | Superannuation Fund Membership Number NZ | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | PNZ_MEMNO | Allow NULL? |
| 18 | MESSG | Superannuation Fund Message Code NZ | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PNZ_MESSG | Allow NULL? |
| 19 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 20 | SUPBS | Estimated Salary for Slab rate for Super withholding Tax | decimal | 15 | 2 | CURR | ((0)) | Yes | | PNZ_SUPBS | |
| 21 | SUPWT | Superannuation Tax Method | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PNZ_SUPWT | Allow NULL? |
| 22 | SCRTE | Employer Superannuation tax rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | PNZ_SCRTE | |
| 23 | OPOUT | Opt Out Date Field | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PNZ_OPOUT | Allow NULL? |
| 24 | CNHOL | Existing KiwiSaver Employee | char | 1 | 0 | CHAR | (N' ') | Yes | | PNZ_CNHOL | Allow NULL? |
| 25 | EXKIW | Contributions Holiday End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PNZ_EXKIW | Allow NULL? |
| 26 | COEXC | Comp.cont Exception when Cont.Holiday | char | 1 | 0 | CHAR | (N' ') | Yes | | PNZ_COEXC | Allow NULL? |
| 27 | NEXMPT | Not ESCT Exempt | char | 1 | 0 | CHAR | (N' ') | Yes | | PNZ_EXEMPT | Allow NULL? |
