| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | CNTR1 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | STAT2 | Employment Status | char | 1 | 0 | | | | Allow NULL? |
| 9 | WRKAR | Province of employment | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | RESAR | Employment standard jurisdiction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | RCITY | Employment standard jurisdiction | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | REGNR | Registration Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 13 | ACNBF | Account number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | CGSTN | GST number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 15 | OPTIO | Option for tax calculation | char | 1 | 0 | | | | Allow NULL? |
| 16 | TOTCR | Total personal tax credit amount | decimal | 9 | 2 | | | | |
| 17 | CLAIM | Claim Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | TNIND | Total non-indexed personal tax credit amount | decimal | 9 | 2 | | | | |
| 19 | ADDTX | Additional tax | decimal | 9 | 2 | | | | |
| 20 | TEXHD | Designated area deduction | decimal | 9 | 2 | | | | |
| 21 | NODEP | No. of dependants under 18 yrs. | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | NODIS | No. of dependants 18 yrs. or older and disabled | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | MNTDE | Annual authorized federal deductions | decimal | 9 | 2 | | | | |
| 24 | OTXCR | Annual authorized federal tax credits | decimal | 9 | 2 | | | | |
| 25 | LBTCR | Amount paid for purchase of labour-sponsored funds | decimal | 9 | 2 | | | | |
| 26 | CRTDE | Court Order Deduction - Alimony Maintenance Payments | decimal | 9 | 2 | | | | |
| 27 | COMRE | Estimated total remuneration | decimal | 9 | 2 | | | | |
| 28 | COMEX | Estimated expenses | decimal | 9 | 2 | | | | |
| 29 | QCTXI | Taxation identification number - QC | nvarchar | 16 | 0 | | | | Allow NULL? |
| 30 | QGSTN | QST number - QC | nvarchar | 16 | 0 | | | | Allow NULL? |
| 31 | TOTCQ | Total personal tax credit amount - QC | decimal | 9 | 2 | | | | |
| 32 | CLAQC | Claim code Québec | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | ADDTQ | Additional tax deduction - Provincial | decimal | 9 | 2 | | | | |
| 34 | OTHDE | Other annual deductions and credits - QC | decimal | 9 | 2 | | | | |
| 35 | OTXCQ | Other annual authorized tax credits - QC | decimal | 9 | 2 | | | | |
| 36 | OTADE | Other annual authorized deductions - QC | decimal | 9 | 2 | | | | |
| 37 | COMEQ | Estimated annual net commission income - QC | decimal | 9 | 2 | | | | |
| 38 | MARRD | Married or equivalent-to-spouse | char | 1 | 0 | | | | Allow NULL? |
| 39 | LSTPY | Date of last irregular pay (for CPP/QPP exemption) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | PROVR | Province of residence | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | WNSBN | Business Number for WCB purposes | nvarchar | 15 | 0 | | | | Allow NULL? |
| 42 | TOTCP | Provincial total tax credits | decimal | 9 | 2 | | | | |
| 43 | OTXCP | Other provincial authorized tax credits | decimal | 9 | 2 | | | | |
| 44 | LBTCP | Provincial Labour-Sponsored Tax Credit | decimal | 9 | 2 | | | | |
| 45 | PVTAX | Province of taxation (CE) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | PHLTH | Province of Health Tax | nvarchar | 4 | 0 | | | | Allow NULL? |
