| 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 | CNTR2 | Tax split | varbinary | 1 | 0 | RAW | | Yes | | CNTR2 | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 8 | STAT2 | Employment Status | char | 1 | 0 | CHAR | (N' ') | Yes | | STAT2 | Allow NULL? |
| 9 | REGIO | Tax Region Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TAXRG | Allow NULL? |
| 10 | PFIND | Employment Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PFYND | Allow NULL? |
| 11 | TXSTA | Tax Status Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TYSTA | Allow NULL? |
| 12 | NODEP | Tax Number of Dependants | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NODEP | Allow NULL? |
| 13 | AGIND | Age Group Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AGIND | Allow NULL? |
| 14 | TXPRO | Tax Procedure Code | char | 1 | 0 | CHAR | (N' ') | Yes | | TYPRO | Allow NULL? |
| 15 | FLEXI | Flexi Remuneration Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FLEXI | Allow NULL? |
| 16 | DIRPC | Directive Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | DIRPC | |
| 17 | RBAMT | Tax rebate amount | decimal | 9 | 2 | DEC | ((0)) | Yes | | RBAMT | |
| 18 | EXAMT | Directive Amount | decimal | 9 | 2 | DEC | ((0)) | Yes | | EYAMT | |
| 19 | CSTKY | Tax split | varbinary | 1 | 0 | RAW | | Yes | | CNTR2 | |
| 20 | NAPER | Nature of Person Code | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_NAPER | Allow NULL? |
| 21 | DIRNO | Number of Tax Directive Issued on Regular Earnings | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | P16_DIRNO | Allow NULL? |
| 22 | REGNO | Old version - Use P16_REGNO_C instead | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | Yes | | P16_REGNO | Allow NULL? |
| 23 | RSCCD | Regional Services Council Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P16_RSCCD | Allow NULL? |
| 24 | NORSC | Employee is Exempt from RSC Levy | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_NORSC | Allow NULL? |
| 25 | REGNC | Registered Number for Trust, CC and Company for IRP5 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | P16_REGNO_C | Allow NULL? |
| 26 | FOINC | Foreign income period | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_FOINC | Allow NULL? |
| 27 | DDIRA | Directive Deemed Remuneration | decimal | 13 | 2 | CURR | ((0)) | Yes | | P16_DDIRA | |
| 28 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 29 | DCOMP | Latest Tax Year for which all Remuneration has been Paid | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P16_DCOMP | Allow NULL? |
| 30 | IRP30 | IRP30 (Labour Broker Exemption Certificate) | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_IRP30 | Allow NULL? |
| 31 | LABRK | Labour Broker Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_LABRK | Allow NULL? |
| 32 | EXFIN | Foreign income is exempt from tax | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_EXFIN | Allow NULL? |
| 33 | PAYNO | PAYE Reference Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | P16_PAYRF | Allow NULL? |
| 34 | XLOSE | Tax Year Open/Closed | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_TYCLO | Allow NULL? |
| 35 | XDATE | Date on which tax year is closed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P16_XDATE | Allow NULL? |
| 36 | UIFNO | UIF Reference Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P16_UPAYER | Allow NULL? |
| 37 | SDLNO | SDL Reference Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P16_SPAYER | Allow NULL? |
| 38 | TRVLC | Travel Allowance Check | char | 1 | 0 | CHAR | (N' ') | Yes | | P16_TRVLC | Allow NULL? |
