Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY10160
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: CDN Payroll Employee Paycode YTD
Physical Name: CPY10160
Technical Name: P_Employee_Paycode_YTDSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PEmployeeID 
P_Employee_ID X_STR15_Employee_ID String 15 2 BACHNUMB Batch Number STR15_LBAU String 15 3 PPayrollCodeType P_Payroll_Code_Type X_Payroll_Code_Type Integer 0 4 PIncomeCode P_Income_Code X_STR06_Upper String 6 5 PHasCurrent P_Has_Current X_Boolean Boolean 0 6 PPaycodeCurrentUnits P_Paycode_Current_Units X_Accumulated Long Integer 10 7 PPaycodeCurrentDollars P_Paycode_Current_Dollars X_DLR11_2 Currency 14 8 PPaycodeYTDUnits P_Paycode_YTD_Units X_Accumulated Long Integer 10 9 PPaycodeYTDDollars P_Paycode_YTD_Dollars X_DLR11_2 Currency 14 10 PCalcBaseUnitsYTD P_Calc_Base_Units_YTD X_Accumulated Long Integer 10 11 PCalcBaseDollarsYTD P_Calc_Base_Dollars_YTD X_DLR11_2 Currency 14 12 PRegistrationNumber50 P_Registration_Number_50 X_STR10_Upper String 10 13 PPaycodeMTDUnits_1 P_Paycode_MTD_Units[1] X_Accumulated Long Integer 10 14 PPaycodeMTDUnits_2 P_Paycode_MTD_Units[2] X_Accumulated Long Integer 10 15 PPaycodeMTDUnits_3 P_Paycode_MTD_Units[3] X_Accumulated Long Integer 10 16 PPaycodeMTDUnits_4 P_Paycode_MTD_Units[4] X_Accumulated Long Integer 10 17 PPaycodeMTDUnits_5 P_Paycode_MTD_Units[5] X_Accumulated Long Integer 10 18 PPaycodeMTDUnits_6 P_Paycode_MTD_Units[6] X_Accumulated Long Integer 10 19 PPaycodeMTDUnits_7 P_Paycode_MTD_Units[7] X_Accumulated Long Integer 10 20 PPaycodeMTDUnits_8 P_Paycode_MTD_Units[8] X_Accumulated Long Integer 10 21 PPaycodeMTDUnits_9 P_Paycode_MTD_Units[9] X_Accumulated Long Integer 10 22 PPaycodeMTDUnits_10 P_Paycode_MTD_Units[10] X_Accumulated Long Integer 10 23 PPaycodeMTDUnits_11 P_Paycode_MTD_Units[11] X_Accumulated Long Integer 10 24 PPaycodeMTDUnits_12 P_Paycode_MTD_Units[12] X_Accumulated Long Integer 10 25 PPaycodeMTDDollars_1 P_Paycode_MTD_Dollars[1] X_DLR11_2 Currency 14 26 PPaycodeMTDDollars_2 P_Paycode_MTD_Dollars[2] X_DLR11_2 Currency 14 27 PPaycodeMTDDollars_3 P_Paycode_MTD_Dollars[3] X_DLR11_2 Currency 14 28 PPaycodeMTDDollars_4 P_Paycode_MTD_Dollars[4] X_DLR11_2 Currency 14 29 PPaycodeMTDDollars_5 P_Paycode_MTD_Dollars[5] X_DLR11_2 Currency 14 30 PPaycodeMTDDollars_6 P_Paycode_MTD_Dollars[6] X_DLR11_2 Currency 14 31 PPaycodeMTDDollars_7 P_Paycode_MTD_Dollars[7] X_DLR11_2 Currency 14 32 PPaycodeMTDDollars_8 P_Paycode_MTD_Dollars[8] X_DLR11_2 Currency 14 33 PPaycodeMTDDollars_9 P_Paycode_MTD_Dollars[9] X_DLR11_2 Currency 14 34 PPaycodeMTDDollars_10 P_Paycode_MTD_Dollars[10] X_DLR11_2 Currency 14 35 PPaycodeMTDDollars_11 P_Paycode_MTD_Dollars[11] X_DLR11_2 Currency 14 36 PPaycodeMTDDollars_12 P_Paycode_MTD_Dollars[12] X_DLR11_2 Currency 14 37 PPaycodeQTDUnits_1 P_Paycode_QTD_Units[1] X_Accumulated Long Integer 10 38 PPaycodeQTDUnits_2 P_Paycode_QTD_Units[2] X_Accumulated Long Integer 10 39 PPaycodeQTDUnits_3 P_Paycode_QTD_Units[3] X_Accumulated Long Integer 10 40 PPaycodeQTDUnits_4 P_Paycode_QTD_Units[4] X_Accumulated Long Integer 10 41 PPaycodeQTDDollars_1 P_Paycode_QTD_Dollars[1] X_DLR11_2 Currency 14 42 PPaycodeQTDDollars_2 P_Paycode_QTD_Dollars[2] X_DLR11_2 Currency 14 43 PPaycodeQTDDollars_3 P_Paycode_QTD_Dollars[3] X_DLR11_2 Currency 14 44 PPaycodeQTDDollars_4 P_Paycode_QTD_Dollars[4] X_DLR11_2 Currency 14 45 PPaycodeLTDUnits P_Paycode_LTD_Units X_Accumulated Long Integer 10 46 PPaycodeLTDDollars P_Paycode_LTD_Dollars X_DLR11_2 Currency 14 47 PCalcBaseUnitsMTD12_1 P_Calc_Base_Units_MTD_12[1] X_Accumulated Long Integer 10 48 PCalcBaseUnitsMTD12_2 P_Calc_Base_Units_MTD_12[2] X_Accumulated Long Integer 10 49 PCalcBaseUnitsMTD12_3 P_Calc_Base_Units_MTD_12[3] X_Accumulated Long Integer 10 50 PCalcBaseUnitsMTD12_4 P_Calc_Base_Units_MTD_12[4] X_Accumulated Long Integer 10 51 PCalcBaseUnitsMTD12_5 P_Calc_Base_Units_MTD_12[5] X_Accumulated Long Integer 10 52 PCalcBaseUnitsMTD12_6 P_Calc_Base_Units_MTD_12[6] X_Accumulated Long Integer 10 53 PCalcBaseUnitsMTD12_7 P_Calc_Base_Units_MTD_12[7] X_Accumulated Long Integer 10 54 PCalcBaseUnitsMTD12_8 P_Calc_Base_Units_MTD_12[8] X_Accumulated Long Integer 10 55 PCalcBaseUnitsMTD12_9 P_Calc_Base_Units_MTD_12[9] X_Accumulated Long Integer 10 56 PCalcBaseUnitsMTD12_10 P_Calc_Base_Units_MTD_12[10] X_Accumulated Long Integer 10 57 PCalcBaseUnitsMTD12_11 P_Calc_Base_Units_MTD_12[11] X_Accumulated Long Integer 10 58 PCalcBaseUnitsMTD12_12 P_Calc_Base_Units_MTD_12[12] X_Accumulated Long Integer 10 59 PCalcBaseDollarsMTD12_1 P_Calc_Base_Dollars_MTD_12[1] X_DLR11_2 Currency 14 60 PCalcBaseDollarsMTD12_2 P_Calc_Base_Dollars_MTD_12[2] X_DLR11_2 Currency 14 61 PCalcBaseDollarsMTD12_3 P_Calc_Base_Dollars_MTD_12[3] X_DLR11_2 Currency 14 62 PCalcBaseDollarsMTD12_4 P_Calc_Base_Dollars_MTD_12[4] X_DLR11_2 Currency 14 63 PCalcBaseDollarsMTD12_5 P_Calc_Base_Dollars_MTD_12[5] X_DLR11_2 Currency 14 64 PCalcBaseDollarsMTD12_6 P_Calc_Base_Dollars_MTD_12[6] X_DLR11_2 Currency 14 65 PCalcBaseDollarsMTD12_7 P_Calc_Base_Dollars_MTD_12[7] X_DLR11_2 Currency 14 66 PCalcBaseDollarsMTD12_8 P_Calc_Base_Dollars_MTD_12[8] X_DLR11_2 Currency 14 67 PCalcBaseDollarsMTD12_9 P_Calc_Base_Dollars_MTD_12[9] X_DLR11_2 Currency 14 68 PCalcBaseDollarsMTD12_10 P_Calc_Base_Dollars_MTD_12[10] X_DLR11_2 Currency 14 69 PCalcBaseDollarsMTD12_11 P_Calc_Base_Dollars_MTD_12[11] X_DLR11_2 Currency 14 70 PCalcBaseDollarsMTD12_12 P_Calc_Base_Dollars_MTD_12[12] X_DLR11_2 Currency 14 71 PCalcBaseUnitsQTD4_1 P_Calc_Base_Units_QTD_4[1] X_Accumulated Long Integer 10 72 PCalcBaseUnitsQTD4_2 P_Calc_Base_Units_QTD_4[2] X_Accumulated Long Integer 10 73 PCalcBaseUnitsQTD4_3 P_Calc_Base_Units_QTD_4[3] X_Accumulated Long Integer 10 74 PCalcBaseUnitsQTD4_4 P_Calc_Base_Units_QTD_4[4] X_Accumulated Long Integer 10 75 PCalcBaseDollarsQTD4_1 P_Calc_Base_Dollars_QTD_4[1] X_DLR11_2 Currency 14 76 PCalcBaseDollarsQTD4_2 P_Calc_Base_Dollars_QTD_4[2] X_DLR11_2 Currency 14 77 PCalcBaseDollarsQTD4_3 P_Calc_Base_Dollars_QTD_4[3] X_DLR11_2 Currency 14 78 PCalcBaseDollarsQTD4_4 P_Calc_Base_Dollars_QTD_4[4] X_DLR11_2 Currency 14 79 PCalcBaseUnitsLTD P_Calc_Base_Units_LTD X_Accumulated Long Integer 10 80 PCalcBaseDollarsLTD P_Calc_Base_Dollars_LTD X_DLR11_2 Currency 14