Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY10103
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: CDN Payroll Employee T4 File
Physical Name: CPY10103
Technical Name: P_CPY_Employee_T4_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PEmployeeID 
P_Employee_ID X_STR15_Employee_ID String 15 2 PEmployerNumber P_Employer_Number X_STR10_Upper String 10 3 PTaxableProvince P_Taxable_Province X_STR02_Upper String 2 4 PEmploymentIncome14 P_Employment_Income_14 X_DLR11_2 Currency 14 5 PCPPDeducted16 P_CPP_Deducted_16 X_DLR11_2 Currency 14 6 PEIDeducted18 P_EI_Deducted_18 X_DLR11_2 Currency 14 7 PRegisteredPension20 P_Registered_Pension_20 X_DLR11_2 Currency 14 8 PIncomeTaxDeducted22 P_Income_Tax_Deducted_22 X_DLR11_2 Currency 14 9 PEIInsEarnings24 P_EI_Insurable_Earnings_24 X_DLR11_2 Currency 14 10 PCPPPensionEarn26 P_CPP_Pensionable_Earnings_26 X_DLR11_2 Currency 14 11 PHousingBoardLodging30 P_Housing_Board_Lodging_30 X_DLR11_2 Currency 14 12 PDesignatedAreaTravel32 P_Designated_Area_Travel_32 X_DLR11_2 Currency 14 13 PPersonalAutoUse34 P_Personal_Auto_Use_34 X_DLR11_2 Currency 14 14 PInterestFreeLoan36 P_Interest_Free_Loan_36 X_DLR11_2 Currency 14 15 PStockOptionBen38 P_Stock_Option_Benefits_38 X_DLR11_2 Currency 14 16 POthTaxAll40 P_Other_Taxable_Allowances_40 X_DLR11_2 Currency 14 17 PCommissionIncome42 P_Commission_Income_42 X_DLR11_2 Currency 14 18 PUnionDues44 P_Union_Dues_44 X_DLR11_2 Currency 14 19 PCharitableDonate46 P_Charitable_Donations_46 X_DLR11_2 Currency 14 20 PRegistrationNumber50 P_Registration_Number_50 X_STR10_Upper String 10 21 PPensionAdjustment52 P_Pension_Adjustment_52 X_DLR11_2 Currency 14 22 PPreviousCPP P_Previous_CPP X_DLR11_2 Currency 14 23 PPreviousEI P_Previous_EI X_DLR11_2 Currency 14 24 PEmployerEIAmount P_Employer_EI_Amount X_DLR11_2 Currency 14 25 PEmployerCPPAmount P_Employer_CPP_Amount X_DLR11_2 Currency 14 26 PNWTTaxCalculationBase P_NWT_Tax_Calculation_Base X_DLR11_2 Currency 14 27 PNWTTaxAssessed P_NWT_Tax_Assessed X_DLR11_2 Currency 14 28 PNUTaxCalcBase P_NU_Tax_Calculation_Base X_DLR11_2 Currency 14 29 PNUTaxAssessed P_NU_Tax_Assessed X_DLR11_2 Currency 14 30 PNonPerTaxableIncome P_NonPer_Taxable_Income X_DLR11_2 Currency 14 31 PProvincialTax P_Provincial_Tax X_DLR11_2 Currency 14 32 PPPIPPremiums P_PPIP_Premiums X_DLR11_2 Currency 14 33 PPPIPEarnings P_PPIP_Earnings X_DLR11_2 Currency 14 34 PPreviousPPIP P_Previous_PPIP X_DLR11_2 Currency 14 35 PEmployerPPIPAmount P_Employer_PPIP_Amount X_DLR11_2 Currency 14 36 PSpecialWorksite31 P_Special_Worksite_31 X_DLR11_2 Currency 14 37 PMedicalTravel33 P_Medical_Travel_33 X_DLR11_2 Currency 14 38 PDeferredSecurity53 P_Deferred_Security_53 X_DLR11_2 Currency 14 39 PMunicipalOfficer70 P_Municipal_Officer_70 X_DLR11_2 Currency 14 40 PStatusIndian71 P_Status_Indian_71 X_DLR11_2 Currency 14 41 PWCBRepaid77 P_WCB_Repaid_77 X_DLR11_2 Currency 14 42 PPrivateHealth85 P_Private_Health_85 X_DLR11_2 Currency 14 43 PEligRetrngAllow P_Eligible_Retiring_Allow_66 X_DLR11_2 Currency 14 44 PNonEligRetrngAll P_Non_Eligible_Retiring_67 X_DLR11_2 Currency 14 45 PIndianEligRetrng P_Indian_Eligible_Retiring_68 X_DLR11_2 Currency 14 46 PIndianNonEligRetrng P_Indian_Non_Eligible_Retiring_69 X_DLR11_2 Currency 14 47 PStockOptionCashout P_Stock_Option_Cashout_86 X_DLR11_2 Currency 14 48 PVolunteerFirefighter87 P_Volunteer_Firefighter_87 X_DLR11_2 Currency 14