Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY10060
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: CDN Payroll Paycode Master
Physical Name: CPY10060
Technical Name: P_CPY_SETP_IncomeSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PIncomeCode 
P_Income_Code X_STR06_Upper String 6 2 PMatchingOvertimePayCode P_Matching_Overtime_Pay_Code X_STR06_Upper String 6 3 PPayrollCodeType P_Payroll_Code_Type X_Payroll_Code_Type Integer 0 4 PDescription P_Description X_STR30 String 30 5 PCalculationBasedOn P_Calculation_Based_On X_DDL_Calc_Based_On Integer 0 6 PFurtherIdentification P_Further_Identification X_Further_Identification_DDL Integer 0 7 PPaycodeReference P_Paycode_Reference X_Paycode_Reference Integer 0 8 PBankedAccrualUnits P_Banked_Accrual_Units X_Banked_Accrual_Units Integer 0 9 PDebitAccountIndex P_Debit_Account_Index LI_14 Long Integer 14 10 PCreditAccountIndex P_Credit_Account_Index LI_14 Long Integer 14 11 PDistribute P_Distribute X_VS_YN Integer 0 12 PAffBenDist P_Affect_Benefit_Distribution X_VS_YN Integer 0 13 PDepartment P_Department X_STR06_Upper String 6 14 PUnits P_Units X_Accumulated Long Integer 10 15 PEIInsHoursPerUnit P_EI_Insurable_Hours_Per_Unit X_LINT_U06 Long Integer 6 16 PRate P_Rate X_Rate Currency 14 17 PRateFactor P_Rate_Factor X_LINT9_U5 Long Integer 9 18 PTax P_Tax X_VS_YN Integer 0 19 PCPP P_CPP X_VS_YN Integer 0 20 PUIC P_UIC X_VS_YN Integer 0 21 PEI P_EI X_VS_YN Integer 0 22 PNWT P_NWT X_VS_YN Integer 0 23 PNU P_NU X_VS_YN Integer 0 24 PPQ P_PQ X_VS_YN Integer 0 25 PEHTQHIP P_EHT_QHIP X_VS_YN Integer 0 26 PWCB P_WCB X_VS_YN Integer 0 27 PVacation P_Vacation X_VS_YN Integer 0 28 PGST P_GST X_VS_YN Integer 0 29 PGSTPerc P_GST% X_Percent_Pos Long Integer 8 30 PPaycodePercentage P_Paycode_Percentage X_Percent_Pos Long Integer 8 31 PPaycodePercentageNG P_Paycode_Percentage_NG X_DDL_Paycode_Percentage Integer 0 32 PGroupIncomeFactor P_Group_Income_Factor X_LINT9_U5 Long Integer 9 33 PExcludeAmount P_Exclude_Amount X_DLR11_2 Currency 14 34 PExcludePercentage P_Exclude_Percentage X_Percent_Pos Long Integer 8 35 PRoundUpTo P_Round_Up_To X_Integer_Factor Long Integer 8 36 PRatePerRoundUpTo P_Rate_Per_Round_Up_To X_Rate Currency 14 37 PMinimum P_Minimum X_DLR11_2 Currency 14 38 PMaximum P_Maximum X_DLR11_2 Currency 14 39 PYearlyMaximum P_Yearly_Maximum X_DLR11_2 Currency 14 40 PExemptAmount P_Exempt_Amount X_DLR11_2 Currency 14 41 PExemptAmountNG P_Exempt_Amount_NG X_Net_Gross Integer 0 42 PExemptAmountBA P_Exempt_Amount_BA X_Before_After Integer 0 43 PExemptPercentage P_Exempt_Percentage X_Percent_Pos Long Integer 8 44 PExemptPercentageNG P_Exempt_Percentage_NG X_Net_Gross Integer 0 45 PExemptPercentageBA P_Exempt_Percentage_BA X_Before_After Integer 0 46 PBreakpointUnits P_Breakpoint_Units X_Accumulated Long Integer 10 47 PBreakpointAmount P_Breakpoint_Amount X_DLR11_2 Currency 14 48 PBreakpointUnitsYTD P_Breakpoint_Units_YTD X_Accumulated Long Integer 10 49 PBreakpointDollarsYTD P_Breakpoint_Dollars_YTD X_DLR11_2 Currency 14 50 PCombinedAmount P_Combined_Amount X_DLR11_2 Currency 14 51 PAdjustFactor P_Adjust_Factor X_LINT9_U5 Long Integer 9 52 PPercentageTaxable P_Percentage_Taxable X_Percent_Pos Long Integer 8 53 PPercentageTaxablePQ P_Percentage_Taxable_PQ X_Percent_Pos Long Integer 8 54 PT4Box1 P_T4_Box1 X_INT_U02 Integer 2 55 PT4Box2 P_T4_Box2 X_INT_U02 Integer 2 56 PPQReleve1BoxNumber1 P_PQ_Releve_1_Box_Number_1 X_STR02_Upper String 2 57 PPQReleve1BoxNumber2 P_PQ_Releve_1_Box_Number_2 X_STR02_Upper String 2 58 PShortDescription P_Short_Description X_STR15 String 15 59 PUserNumericFieldIndex P_User_Numeric_Field_Index X_INT_User Integer 2 60 PVacationAccrualUnits P_Vacation_Accrual_Units X_LINT9_5 Long Integer 9 61 PUnpdVacAccUnts P_Unpaid_Vacation_Accrual_Units X_LINT9_U5 Long Integer 9 62 PSickAccrualUnits P_Sick_Accrual_Units X_LINT9_U5 Long Integer 9 63 PPaidBy P_Paid_By X_Paid_By_DDL Integer 0 64 PPayType P_Pay_Type X_Pay_Type_DDL Integer 0 65 PAddToCheck P_Add_To_Check X_VS_YN Integer 0 66 PT4Box50 P_T4_Box_50 X_CB_T4_Box_50 Boolean 0 67 PAllowTransactionEntry P_Allow_Transaction_Entry X_VS_YN Integer 0 68 PAutoSelect P_Auto_Select X_VS_YN Integer 0 69 PStartDate P_Start_Date X_Date Date 0 70 PCutoffDate P_Cutoff_Date X_Date Date 0 71 PNetDeductionSequence P_Net_Deduction_Sequence X_Sequence Integer 3 72 PUnionCode P_Union_Code X_STR15_LBAU String 15 73 PUnitAccountIndex P_Unit_Account_Index LI_14 Long Integer 14 74 PShift P_Shift X_Shift Integer 0 75 PResponsibility P_Responsibility X_DDL_Responsibility Integer 0 76 PPostToUnitAccount P_Post_To_Unit_Account X_VS_YN Integer 0 77 PDeductCPP P_Deduct_CPP X_VS_YN Integer 0 78 PAddToReportValue P_Add_To_Report_Value X_VS_YN Integer 0 79 PComment P_Comment X_STR30 String 30 80 PAdditionalPaycode P_Additional_Paycode X_STR06_Upper String 6 81 PSpecialPensionType P_Special_Pension_Type X_DDL_Special_Pension Integer 0 82 PServiceDays P_Service_Days X_DLR14_U5 Currency 14 83 PServiceDollars P_Service_Dollars X_DLR14_U5 Currency 14 84 PServiceHours P_Service_Hours X_DLR14_U5 Currency 14 85 PServicePayPeriods P_Service_Pay_Periods X_DLR14_U5 Currency 14 86 PLAPP P_LAPP X_CB_LAPP Boolean 0 87 POMERS P_OMERS X_CB_OMERS Boolean 0 88 PSeniorityUnitsPerUnit P_Seniority_Units_Per_Unit X_DLR14_U5 Currency 14 89 PPCIsERSide P_Paycode_Is_Employer_Side X_VS_YN Integer 0 90 POwedFromEEAcctIndex P_Owed_From_Employee_Account_Index LI_14 Long Integer 14 91 PAllowBankableDeductions P_Allow_Bankable_Deductions X_VS_YN Integer 0 92 PBankedDeductionPaycode P_Banked_Deduction_Paycode X_STR06_Upper String 6 93 PProtectedIncome P_Protected_Income X_VS_YN Integer 0 94 PBankDedPostingMethod P_BankDed_Posting_Method X_DDL_BankDed_Posting_Method Integer 0 95 PBankDedBankingMethod P_BankDed_Banking_Method X_DDL_BankDed_BankRec_Method Integer 0 96 PBankDedRecoveryMethod P_BankDed_Recovery_Method X_DDL_BankDed_BankRec_Method Integer 0 97 PBankDedPercOfOrigAmt P_BankDed_Percent_Of_Original_Amount X_Percent_Pos Long Integer 8 98 PBankDedRank P_BankDed_Rank X_Rank Integer 3 99 PPaycodeType P_Paycode_Type X_DDL_Paycode_Type Integer 0 100 PCountedUnits P_Counted_Units X_VS_YN Integer 0 101 PSlipToUse P_Slip_To_Use X_VS_Slip_To_Use Integer 0 102 PT4ABox1 P_T4A_Box1 X_INT_U02 Integer 2 103 PActivationUnitsMTD P_Activation_Units_MTD X_Accumulated Long Integer 10 104 PActivationDollarsMTD P_Activation_Dollars_MTD X_DLR11_2 Currency 14 105 PExclActUnitsMTD P_Exclude_Activation_Units_MTD X_CB_Exclude_Activation_Units_MTD Boolean 0 106 PExclActDollarsMTD P_Exclude_Activation_Dollars_MTD X_CB_Exclude_Activation_Dollars_MTD Boolean 0 107 PUseActMethodMTD P_Use_Activation_Method_MTD X_DDL_Use_Activation_Method Integer 0 108 PActivationUnitsQTD P_Activation_Units_QTD X_Accumulated Long Integer 10 109 PActivationDollarsQTD P_Activation_Dollars_QTD X_DLR11_2 Currency 14 110 PExclActUnitsQTD P_Exclude_Activation_Units_QTD X_CB_Exclude_Activation_Units_QTD Boolean 0 111 PExclActDollarsQTD P_Exclude_Activation_Dollars_QTD X_CB_Exclude_Activation_Dollars_QTD Boolean 0 112 PUseActMethodQTD P_Use_Activation_Method_QTD X_DDL_Use_Activation_Method Integer 0 113 PActivationUnitsLTD P_Activation_Units_LTD X_Accumulated Long Integer 10 114 PActivationDollarsLTD P_Activation_Dollars_LTD X_DLR11_2 Currency 14 115 PExclActUnitsLTD P_Exclude_Activation_Units_LTD X_CB_Exclude_Activation_Units_LTD Boolean 0 116 PExclActDollarsLTD P_Exclude_Activation_Dollars_LTD X_CB_Exclude_Activation_Dollars_LTD Boolean 0 117 PUseActMethodLTD P_Use_Activation_Method_LTD X_DDL_Use_Activation_Method Integer 0 118 PMTDMinimum P_MTD_Minimum X_DLR11_2 Currency 14 119 PMTDMaximum P_MTD_Maximum X_DLR11_2 Currency 14 120 PCeilingUnits P_Ceiling_Units X_Accumulated Long Integer 10 121 PCeilingDollars P_Ceiling_Dollars X_DLR11_2 Currency 14 122 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CDN Payroll Paycode Master'].NOTEINDX AS 'CDN Payroll Paycode Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CPY10060 AS ['CDN Payroll Paycode Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CDN Payroll Paycode Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX123 PFrequencyPaycode P_Frequency_Paycode X_DDL_Frequency_Paycode Integer 0 124 PPPIP P_PPIP X_VS_YN Integer 0 125 PT4ABox2 P_T4A_Box2 X_INT_U3 Integer 3 126 PPQReleve1BoxOSource P_PQ_Releve_1_BoxO_Source X_STR02_Upper String 2