P2RK_TAXO

Payroll results - master data from infotypes 0461-0463 | #transactional | Component: Canada
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
💲 Currency Key (T500C.WAERS):
TOTCR Total personal tax credit amount
TNIND Total non-indexed personal tax credit amount
ADDTX Additional tax
TEXHD Designated area deduction
MNTDE Annual authorized federal deductions
OTXCR Annual authorized federal tax credits
LBTCR Amount paid for purchase of labour-sponsored funds
CRTDE Court Order Deduction - Alimony Maintenance Payments
COMRE Estimated total remuneration
COMEX Estimated expenses
TOTCQ Total personal tax credit amount - QC
ADDTQ Additional tax deduction - Provincial
OTHDE Other annual deductions and credits - QC
OTXCQ Other annual authorized tax credits - QC
OTADE Other annual authorized deductions - QC
COMEQ Estimated annual net commission income - QC
TOTCP Provincial total tax credits
OTXCP Other provincial authorized tax credits
LBTCP Provincial Labour-Sponsored Tax Credit
BPA Basic Personal Amount value
BPAP Provincial Basic Personal Amount value
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
LSTPY Date of last irregular pay (for CPP/QPP exemption)
Column Name Description
OPTIO Option for tax calculation Show values
BPA_FROM_TD1 Flags if BPA value comes from TD1 form Show values
BPA_FROM_TD1P Flags if BPA value comes from provincial TD1 form Show values
Column Name Description Domain name
CNTR1 National assignment indicator RAW1
STAT2 Employment Status STATA
WRKAR Province of employment PCA_WRKAR
RESAR Employment standard jurisdiction PCA_WRKAR
RCITY Employment standard jurisdiction PCA_WRKAR
REGNR Registration Number NUMC09
ACNBF Account number PCA_ACNBF
CGSTN GST number PCA_CGSTN
CLAIM Claim Code PCA_CLAIM
NODEP No. of dependants under 18 yrs. PCA_NODEP
NODIS No. of dependants 18 yrs. or older and disabled PCA_NODEP
QCTXI Taxation identification number - QC PCA_QCTXI
QGSTN QST number - QC PCA_QGSTN
CLAQC Claim code Québec PCA_CLAQC
MARRD Married or equivalent-to-spouse PCA_MARRD
PROVR Province of residence PCA_WRKAR
WNSBN Business Number for WCB purposes PCA_CBUSN
PVTAX Province of taxation (CE) PCA_PVTAX
PHLTH Province of Health Tax PCA_WRKAR