CDN Payroll Employer Master (CPY10010)

azurecurveProductsMICR for Canadian Payroll (2916)ProjectCDN Payroll Employer Master (CPY10010)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY10010

Product: MICR for Canadian Payroll (2916)
Series: Project

Display Name: CDN Payroll Employer Master
Physical Name: CPY10010
Technical Name: P_CPY_SETP_Employer_Number

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PEmployerNumber SearchP_Employer_NumberX_STR10_UpperString10
2PDescription SearchP_DescriptionX_STR30String30
3PERBusinessNum SearchP_Employer_Business_NumberX_STR17_LBAUString17
4PEICode SearchP_EI_CodeX_STR06_UpperString6
5PEIFactor SearchP_EI_FactorX_UIC_FactorLong Integer5
6PEIAcctIndex SearchP_EI_Account_IndexLI_14Long Integer14
7PAllowEIRebate SearchP_Allow_EI_RebateX_VS_YNInteger0
8PAllowEIRebateGLAccrual SearchP_Allow_EI_Rebate_GL_AccrualX_VS_YNInteger0
9PEIRebateExpenseIdx SearchP_EI_Rebate_Expense_Account_IndexLI_14Long Integer14
10PEIRebatePaycode SearchP_EI_Rebate_PaycodeX_STR06_UpperString6
11PX124 SearchP_ROE_Contact_NameSTR60String60
12PX125 SearchP_ROE_Contact_PhoneX_STR18_PhoneString18
13PROEContactFirstName SearchP_ROE_Contact_Name_FirstSTR18String18
14PROEContactMiddleName SearchP_ROE_Contact_Name_MiddleSTR18String18
15PROEContactLastName SearchP_ROE_Contact_Name_LastSTR50String50
16PX117 SearchP_ROE_Issuer_NameSTR60String60
17PX114 SearchP_ROE_Issuer_PhoneX_STR18_PhoneString18
18PEmployerAddress SearchP_Employer_AddressSTR60String60
19PEmployerCity SearchP_Employer_CityX_STR40String40
20PEmployerPostal SearchP_Employer_PostalX_STR10_UpperString10
21PTaxCode SearchP_Tax_CodeX_STR06_UpperString6
22PCPPCode SearchP_CPP_CodeX_STR06_UpperString6
23PCPPAccountIndex SearchP_CPP_Account_IndexLI_14Long Integer14
24PNWTCode SearchP_NWT_CodeX_STR06_UpperString6
25PNunavutCode SearchP_Nunavut_CodeX_STR06_UpperString6
26PGSTCodeBenefit SearchP_GST_Code_BenefitX_STR06_UpperString6
27PGSTCodeDeduction SearchP_GST_Code_DeductionX_STR06_UpperString6
28PEmployerEIDist SearchP_Employer_EI_DistributeX_VS_YNInteger0
29PEmployerCPPDist SearchP_Employer_CPP_DistributeX_VS_YNInteger0
30PEIRebatePayableIdx SearchP_EI_Rebate_Payable_Account_IndexLI_14Long Integer14
31PQPPDebitAcctIdx SearchP_QPP_Debit_Account_IndexLI_14Long Integer14
32PERQPPDist SearchP_Employer_QPP_DistributeX_VS_YNInteger0
33PQPPPaycode SearchP_QPP_PaycodeX_STR06_UpperString6
34PQuebecTaxCode SearchP_Quebec_Tax_CodeX_STR06_UpperString6
35POntHlthTaxPerc SearchP_Ontario_Health_Tax_PercentageX_Percent_PosLong Integer8
36POntHlthExpAcctInx SearchP_Ontario_Health_Expense_Account_IndexLI_14Long Integer14
37POntHlthPayAcctInx SearchP_Ontario_Health_Payable_Account_IndexLI_14Long Integer14
38PPQHealthTaxPercentage SearchP_PQ_Health_Tax_PercentageX_Percent_PosLong Integer8
39PPQHlthExpAcctInx SearchP_PQ_Health_Expense_Account_IndexLI_14Long Integer14
40PPQHlthPayAcctInx SearchP_PQ_Health_Payable_Account_IndexLI_14Long Integer14
41PMBHealthTaxPercentage SearchP_MB_Health_Tax_PercentageX_Percent_PosLong Integer8
42PMBHlthExpAcctInx SearchP_MB_Health_Expense_Account_IndexLI_14Long Integer14
43PMBHlthPayAcctInx SearchP_MB_Health_Payable_Account_IndexLI_14Long Integer14
44PDistributeHealthTax SearchP_Distribute_Health_TaxX_VS_YNInteger0
45PTaxCodeT4A SearchP_Tax_Code_T4AX_STR06_UpperString6
46PNFHlthExpAcctInx SearchP_Newfoundland_Health_Expense_Account_IndexLI_14Long Integer14
47PNFHlthPayAcctInx SearchP_Newfoundland_Health_Payable_Account_IndexLI_14Long Integer14
48PNFHlthTaxPerc SearchP_Newfoundland_Health_Tax_PercentageX_Percent_PosLong Integer8
49NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['CDN Payroll Employer Master'].NOTEINDX AS 'CDN Payroll Employer Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       CPY10010 AS ['CDN Payroll Employer Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['CDN Payroll Employer Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
50PPPIPCode SearchP_PPIP_CodeX_STR06_UpperString6
51PPPIPAccountIndex SearchP_PPIP_Account_IndexLI_14Long Integer14
52PEmployerPPIPDistribute SearchP_Employer_PPIP_DistributeX_VS_YNInteger0
53PEmployerCSSTDistribute SearchP_Employer_CSST_DistributeX_VS_YNInteger0
azurecurveProductsMICR for Canadian Payroll (2916)ProjectCDN Payroll Employer Master (CPY10010)

Leave a Reply

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