CDN Payroll Paycode Master (CPY10060)

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_Income

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PIncomeCode SearchP_Income_CodeX_STR06_UpperString6
2PMatchingOvertimePayCode SearchP_Matching_Overtime_Pay_CodeX_STR06_UpperString6
3PPayrollCodeType SearchP_Payroll_Code_TypeX_Payroll_Code_TypeInteger0
4PDescription SearchP_DescriptionX_STR30String30
5PCalculationBasedOn SearchP_Calculation_Based_OnX_DDL_Calc_Based_OnInteger0
6PFurtherIdentification SearchP_Further_IdentificationX_Further_Identification_DDLInteger0
7PPaycodeReference SearchP_Paycode_ReferenceX_Paycode_ReferenceInteger0
8PBankedAccrualUnits SearchP_Banked_Accrual_UnitsX_Banked_Accrual_UnitsInteger0
9PDebitAccountIndex SearchP_Debit_Account_IndexLI_14Long Integer14
10PCreditAccountIndex SearchP_Credit_Account_IndexLI_14Long Integer14
11PDistribute SearchP_DistributeX_VS_YNInteger0
12PAffBenDist SearchP_Affect_Benefit_DistributionX_VS_YNInteger0
13PDepartment SearchP_DepartmentX_STR06_UpperString6
14PUnits SearchP_UnitsX_AccumulatedLong Integer10
15PEIInsHoursPerUnit SearchP_EI_Insurable_Hours_Per_UnitX_LINT_U06Long Integer6
16PRate SearchP_RateX_RateCurrency14
17PRateFactor SearchP_Rate_FactorX_LINT9_U5Long Integer9
18PTax SearchP_TaxX_VS_YNInteger0
19PCPP SearchP_CPPX_VS_YNInteger0
20PUIC SearchP_UICX_VS_YNInteger0
21PEI SearchP_EIX_VS_YNInteger0
22PNWT SearchP_NWTX_VS_YNInteger0
23PNU SearchP_NUX_VS_YNInteger0
24PPQ SearchP_PQX_VS_YNInteger0
25PEHTQHIP SearchP_EHT_QHIPX_VS_YNInteger0
26PWCB SearchP_WCBX_VS_YNInteger0
27PVacation SearchP_VacationX_VS_YNInteger0
28PGST SearchP_GSTX_VS_YNInteger0
29PGSTPerc SearchP_GST%X_Percent_PosLong Integer8
30PPaycodePercentage SearchP_Paycode_PercentageX_Percent_PosLong Integer8
31PPaycodePercentageNG SearchP_Paycode_Percentage_NGX_DDL_Paycode_PercentageInteger0
32PGroupIncomeFactor SearchP_Group_Income_FactorX_LINT9_U5Long Integer9
33PExcludeAmount SearchP_Exclude_AmountX_DLR11_2Currency14
34PExcludePercentage SearchP_Exclude_PercentageX_Percent_PosLong Integer8
35PRoundUpTo SearchP_Round_Up_ToX_Integer_FactorLong Integer8
36PRatePerRoundUpTo SearchP_Rate_Per_Round_Up_ToX_RateCurrency14
37PMinimum SearchP_MinimumX_DLR11_2Currency14
38PMaximum SearchP_MaximumX_DLR11_2Currency14
39PYearlyMaximum SearchP_Yearly_MaximumX_DLR11_2Currency14
40PExemptAmount SearchP_Exempt_AmountX_DLR11_2Currency14
41PExemptAmountNG SearchP_Exempt_Amount_NGX_Net_GrossInteger0
42PExemptAmountBA SearchP_Exempt_Amount_BAX_Before_AfterInteger0
43PExemptPercentage SearchP_Exempt_PercentageX_Percent_PosLong Integer8
44PExemptPercentageNG SearchP_Exempt_Percentage_NGX_Net_GrossInteger0
45PExemptPercentageBA SearchP_Exempt_Percentage_BAX_Before_AfterInteger0
46PBreakpointUnits SearchP_Breakpoint_UnitsX_AccumulatedLong Integer10
47PBreakpointAmount SearchP_Breakpoint_AmountX_DLR11_2Currency14
48PBreakpointUnitsYTD SearchP_Breakpoint_Units_YTDX_AccumulatedLong Integer10
49PBreakpointDollarsYTD SearchP_Breakpoint_Dollars_YTDX_DLR11_2Currency14
50PCombinedAmount SearchP_Combined_AmountX_DLR11_2Currency14
51PAdjustFactor SearchP_Adjust_FactorX_LINT9_U5Long Integer9
52PPercentageTaxable SearchP_Percentage_TaxableX_Percent_PosLong Integer8
53PPercentageTaxablePQ SearchP_Percentage_Taxable_PQX_Percent_PosLong Integer8
54PT4Box1 SearchP_T4_Box1X_INT_U02Integer2
55PT4Box2 SearchP_T4_Box2X_INT_U02Integer2
56PPQReleve1BoxNumber1 SearchP_PQ_Releve_1_Box_Number_1X_STR02_UpperString2
57PPQReleve1BoxNumber2 SearchP_PQ_Releve_1_Box_Number_2X_STR02_UpperString2
58PShortDescription SearchP_Short_DescriptionX_STR15String15
59PUserNumericFieldIndex SearchP_User_Numeric_Field_IndexX_INT_UserInteger2
60PVacationAccrualUnits SearchP_Vacation_Accrual_UnitsX_LINT9_5Long Integer9
61PUnpdVacAccUnts SearchP_Unpaid_Vacation_Accrual_UnitsX_LINT9_U5Long Integer9
62PSickAccrualUnits SearchP_Sick_Accrual_UnitsX_LINT9_U5Long Integer9
63PPaidBy SearchP_Paid_ByX_Paid_By_DDLInteger0
64PPayType SearchP_Pay_TypeX_Pay_Type_DDLInteger0
65PAddToCheck SearchP_Add_To_CheckX_VS_YNInteger0
66PT4Box50 SearchP_T4_Box_50X_CB_T4_Box_50Boolean0
67PAllowTransactionEntry SearchP_Allow_Transaction_EntryX_VS_YNInteger0
68PAutoSelect SearchP_Auto_SelectX_VS_YNInteger0
69PStartDate SearchP_Start_DateX_DateDate0
70PCutoffDate SearchP_Cutoff_DateX_DateDate0
71PNetDeductionSequence SearchP_Net_Deduction_SequenceX_SequenceInteger3
72PUnionCode SearchP_Union_CodeX_STR15_LBAUString15
73PUnitAccountIndex SearchP_Unit_Account_IndexLI_14Long Integer14
74PShift SearchP_ShiftX_ShiftInteger0
75PResponsibility SearchP_ResponsibilityX_DDL_ResponsibilityInteger0
76PPostToUnitAccount SearchP_Post_To_Unit_AccountX_VS_YNInteger0
77PDeductCPP SearchP_Deduct_CPPX_VS_YNInteger0
78PAddToReportValue SearchP_Add_To_Report_ValueX_VS_YNInteger0
79PComment SearchP_CommentX_STR30String30
80PAdditionalPaycode SearchP_Additional_PaycodeX_STR06_UpperString6
81PSpecialPensionType SearchP_Special_Pension_TypeX_DDL_Special_PensionInteger0
82PServiceDays SearchP_Service_DaysX_DLR14_U5Currency14
83PServiceDollars SearchP_Service_DollarsX_DLR14_U5Currency14
84PServiceHours SearchP_Service_HoursX_DLR14_U5Currency14
85PServicePayPeriods SearchP_Service_Pay_PeriodsX_DLR14_U5Currency14
86PLAPP SearchP_LAPPX_CB_LAPPBoolean0
87POMERS SearchP_OMERSX_CB_OMERSBoolean0
88PSeniorityUnitsPerUnit SearchP_Seniority_Units_Per_UnitX_DLR14_U5Currency14
89PPCIsERSide SearchP_Paycode_Is_Employer_SideX_VS_YNInteger0
90POwedFromEEAcctIndex SearchP_Owed_From_Employee_Account_IndexLI_14Long Integer14
91PAllowBankableDeductions SearchP_Allow_Bankable_DeductionsX_VS_YNInteger0
92PBankedDeductionPaycode SearchP_Banked_Deduction_PaycodeX_STR06_UpperString6
93PProtectedIncome SearchP_Protected_IncomeX_VS_YNInteger0
94PBankDedPostingMethod SearchP_BankDed_Posting_MethodX_DDL_BankDed_Posting_MethodInteger0
95PBankDedBankingMethod SearchP_BankDed_Banking_MethodX_DDL_BankDed_BankRec_MethodInteger0
96PBankDedRecoveryMethod SearchP_BankDed_Recovery_MethodX_DDL_BankDed_BankRec_MethodInteger0
97PBankDedPercOfOrigAmt SearchP_BankDed_Percent_Of_Original_AmountX_Percent_PosLong Integer8
98PBankDedRank SearchP_BankDed_RankX_RankInteger3
99PPaycodeType SearchP_Paycode_TypeX_DDL_Paycode_TypeInteger0
100PCountedUnits SearchP_Counted_UnitsX_VS_YNInteger0
101PSlipToUse SearchP_Slip_To_UseX_VS_Slip_To_UseInteger0
102PT4ABox1 SearchP_T4A_Box1X_INT_U02Integer2
103PActivationUnitsMTD SearchP_Activation_Units_MTDX_AccumulatedLong Integer10
104PActivationDollarsMTD SearchP_Activation_Dollars_MTDX_DLR11_2Currency14
105PExclActUnitsMTD SearchP_Exclude_Activation_Units_MTDX_CB_Exclude_Activation_Units_MTDBoolean0
106PExclActDollarsMTD SearchP_Exclude_Activation_Dollars_MTDX_CB_Exclude_Activation_Dollars_MTDBoolean0
107PUseActMethodMTD SearchP_Use_Activation_Method_MTDX_DDL_Use_Activation_MethodInteger0
108PActivationUnitsQTD SearchP_Activation_Units_QTDX_AccumulatedLong Integer10
109PActivationDollarsQTD SearchP_Activation_Dollars_QTDX_DLR11_2Currency14
110PExclActUnitsQTD SearchP_Exclude_Activation_Units_QTDX_CB_Exclude_Activation_Units_QTDBoolean0
111PExclActDollarsQTD SearchP_Exclude_Activation_Dollars_QTDX_CB_Exclude_Activation_Dollars_QTDBoolean0
112PUseActMethodQTD SearchP_Use_Activation_Method_QTDX_DDL_Use_Activation_MethodInteger0
113PActivationUnitsLTD SearchP_Activation_Units_LTDX_AccumulatedLong Integer10
114PActivationDollarsLTD SearchP_Activation_Dollars_LTDX_DLR11_2Currency14
115PExclActUnitsLTD SearchP_Exclude_Activation_Units_LTDX_CB_Exclude_Activation_Units_LTDBoolean0
116PExclActDollarsLTD SearchP_Exclude_Activation_Dollars_LTDX_CB_Exclude_Activation_Dollars_LTDBoolean0
117PUseActMethodLTD SearchP_Use_Activation_Method_LTDX_DDL_Use_Activation_MethodInteger0
118PMTDMinimum SearchP_MTD_MinimumX_DLR11_2Currency14
119PMTDMaximum SearchP_MTD_MaximumX_DLR11_2Currency14
120PCeilingUnits SearchP_Ceiling_UnitsX_AccumulatedLong Integer10
121PCeilingDollars SearchP_Ceiling_DollarsX_DLR11_2Currency14
122NOTEINDX SearchNote IndexDLR14Currency14
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'].NOTEINDX
123PFrequencyPaycode SearchP_Frequency_PaycodeX_DDL_Frequency_PaycodeInteger0
124PPPIP SearchP_PPIPX_VS_YNInteger0
125PT4ABox2 SearchP_T4A_Box2X_INT_U3Integer3
126PPQReleve1BoxOSource SearchP_PQ_Releve_1_BoxO_SourceX_STR02_UpperString2

Leave a Reply

Your email address will not be published. Required fields are marked *