Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY20100
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: CDN Payroll Control Master
Physical Name: CPY20100
Technical Name: P_CPY_ControlSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PDescription 
P_Description X_STR30 String 30 2 PNextComputerTRXNumber P_Next_Computer_TRX_Number X_LI8_U0 Long Integer 8 3 PNextDirectDepositTRXID P_Next_Direct_Deposit_TRX_ID X_STR20_LBAU String 20 4 PNextChequeNumber P_Next_Cheque_Number X_STR20_LBAU String 20 5 PNextCashNumber P_Next_Cash_Number X_STR20_LBAU String 20 6 PCurrencyID P_Currency_ID X_STR15 String 15 7 PChequebookID P_Chequebook_ID X_STR15_LBAU String 15 8 PDDChequebookID P_DD_Chequebook_ID X_STR15_LBAU String 15 9 PCashChequebookID P_Cash_Chequebook_ID X_STR15_LBAU String 15 10 PChequeFormat P_Cheque_Format X_Cheque_Format Integer 0 11 PPostingMethod P_Posting_Method X_Posting_Method Integer 0 12 PPostDetailSummary P_Post_Detail_Summary X_DDL_Detail_Summary Integer 0 13 PAllowBankedOT P_Allow_Banked_Overtime X_VS_YN Integer 0 14 PAllowBankedOTGLAccrual P_Allow_Banked_Overtime_GL_Accrual X_VS_YN Integer 0 15 PBankedOTPayableAccIdx P_Banked_Overtime_Payable_Account_Index LI_14 Long Integer 14 16 PBankedOTGainAcctIdx P_Banked_Overtime_Gain_Account_Index LI_14 Long Integer 14 17 PAllowBankedStatPay P_Allow_Banked_Stat_Pay X_VS_YN Integer 0 18 PAllBnkStatPayGLAcc P_Allow_Banked_Stat_Pay_GL_Accrual X_VS_YN Integer 0 19 PBankedStatPayableAcctId P_Banked_Stat_Payable_Account_Index LI_14 Long Integer 14 20 PBnkStatLossAcctInx P_Banked_Stat_Loss_Account_Index LI_14 Long Integer 14 21 PAllowBankedSickPay P_Allow_Banked_Sick_Pay X_VS_YN Integer 0 22 PAllBnkSckPayAcc P_Allow_Banked_Sick_Pay_GL_Accrual X_VS_YN Integer 0 23 PBankedSickPayableAccId P_Banked_Sick_Payable_Account_Index LI_14 Long Integer 14 24 PBnkSickLossAcctInx P_Banked_Sick_Loss_Account_Index LI_14 Long Integer 14 25 PAllowAccrueSickUnits P_Allow_Accrue_Sick_Units X_VS_YN Integer 0 26 PSickAccrualUnitIn P_Sick_Accrual_Unit_In X_DDL_Accrual_Unit_In Integer 0 27 PAllowBankedLeavePay P_Allow_Banked_Leave_Pay X_VS_YN Integer 0 28 PAllowBnkdLeavePayGLAc P_Allow_Banked_Leave_Pay_GL_Accrual X_VS_YN Integer 0 29 PBankedLeavePayableIdx P_Banked_Leave_Payable_Account_Index LI_14 Long Integer 14 30 PBankedLeaveGainIdx P_Banked_Leave_Gain_Account_Index LI_14 Long Integer 14 31 PAllowPaymentByCash P_Allow_Payment_By_Cash X_VS_YN Integer 0 32 PAllPayByDirDepst P_Allow_Payment_By_Direct_Deposit X_VS_YN Integer 0 33 PAllowPayrollPostingToGL P_Allow_Payroll_Posting_To_GL X_VS_YN Integer 0 34 PVacPayPayAcctInx P_Vacation_Pay_Payable_Account_Index LI_14 Long Integer 14 35 PAllowVacationPay P_Allow_Vacation_Pay X_VS_YN Integer 0 36 PAllowVacationGLAccrual P_Allow_Vacation_GL_Accrual X_VS_YN Integer 0 37 PVacationCode P_Vacation_Code X_STR06_Upper String 6 38 PVacationPayPercent P_Vacation_Pay% X_Percent_Pos Long Integer 8 39 PAllAccVacUnts P_Allow_Accrue_Vacation_Units X_VS_YN Integer 0 40 PVacationAccrualUnitIn P_Vacation_Accrual_Unit_In X_DDL_Accrual_Unit_In Integer 0 41 PVacGainLossAcctInx P_Vacation_Gain_Loss_Account_Index LI_14 Long Integer 14 42 PAllowJobEntry P_Allow_Job_Entry X_VS_YN Integer 0 43 PAllowArrearsAmount P_Allow_Arrears_Amount X_VS_YN Integer 0 44 PArrearsReceivableAccId P_Arrears_Receivable_Account_Index LI_14 Long Integer 14 45 PArrearsReclaimCode P_Arrears_Reclaim_Code X_STR06_Upper String 6 46 PCashAccountIndex P_Cash_Account_Index LI_14 Long Integer 14 47 PChequeingAccountIndex P_Chequeing_Account_Index LI_14 Long Integer 14 48 PDirectAccountIndex P_Direct_Account_Index LI_14 Long Integer 14 49 PAdvanceReclaimCode P_Advance_Reclaim_Code X_STR06_Upper String 6 50 PBonusCode P_Bonus_Code X_STR06_Upper String 6 51 PBankedSickCode P_Banked_Sick_Code X_STR06_Upper String 6 52 PBankedStatCode P_Banked_Stat_Code X_STR06_Upper String 6 53 PBankedOvertimeCode P_Banked_Overtime_Code X_STR06_Upper String 6 54 PBankedOTReliefCode P_Banked_OT_Relief_Code X_STR06_Upper String 6 55 PBankedLeaveCode P_Banked_Leave_Code X_STR06_Upper String 6 56 PDistributeWCB P_Distribute_WCB X_VS_YN Integer 0 57 PBenOffsetAcctInx P_Benefit_Offset_Account_Index LI_14 Long Integer 14 58 PEmpBnkCustNum P_Employer_Bank_Customer_Number X_Employer_Customer_Number String 10 59 PBankName P_Bank_Name X_DDL_Bank_Name Integer 0 60 PNxtDirDepstFileNum P_Next_Direct_Deposit_File_Number X_Employer_File_Creation_Number String 4 61 PBankDataCenterNumber P_Bank_Data_Center_Number X_Data_Center_Number String 5 62 POriginatorShortName P_Originator_Short_Name X_STR15 String 15 63 POriginatorLongName P_Originator_Long_Name X_STR30 String 30 64 PReturnInstitutionCode P_Return_Institution_Code X_Return_Institution_Code String 3 65 PRtnBrnchTranNum P_Return_Branch_Transit_Number X_Data_Center_Number String 5 66 PReturnAccountNumber P_Return_Account_Number X_STR12_Upper String 12 67 PUserPrompt1 P_User_Prompt1 X_STR15 String 15 68 PUserPrompt2 P_User_Prompt2 X_STR15 String 15 69 PUserMiscPrompts_1 P_User_Misc_Prompts[1] X_STR30 String 30 70 PUserMiscPrompts_2 P_User_Misc_Prompts[2] X_STR30 String 30 71 PUserMiscPrompts_3 P_User_Misc_Prompts[3] X_STR30 String 30 72 PUserMiscPrompts_4 P_User_Misc_Prompts[4] X_STR30 String 30 73 PUserMiscPrompts_5 P_User_Misc_Prompts[5] X_STR30 String 30 74 PUserMiscPrompts_6 P_User_Misc_Prompts[6] X_STR30 String 30 75 PUserMiscPrompts_7 P_User_Misc_Prompts[7] X_STR30 String 30 76 PUserMiscPrompts_8 P_User_Misc_Prompts[8] X_STR30 String 30 77 PUserMiscPrompts_9 P_User_Misc_Prompts[9] X_STR30 String 30 78 PUserMiscPrompts_10 P_User_Misc_Prompts[10] X_STR30 String 30 79 PBasicPersonalAmount P_Basic_Personal_Amount X_DLR11_2 Currency 14 80 PQuebecMR19Base P_Quebec_MR19_Base X_DLR11_2 Currency 14 81 PLimitImcome P_Limit_Income X_INT_U02 Integer 2 82 PLimitBenefit P_Limit_Benefit X_INT_U02 Integer 2 83 PLimitDeduction P_Limit_Deduction X_INT_U02 Integer 2 84 PLimitDirect P_Limit_Direct X_Boolean Boolean 0 85 PNotForResale P_Not_For_Resale X_Boolean Boolean 0 86 PRegKey P_Reg_Key X_Reg_Key String 20 87 PRegKeyTwo P_Reg_Key_Two X_Reg_Key String 20 88 PDeletePassword P_Delete_Password X_STR10_Upper String 10 89 PFilePassword P_File_Password X_STR10_Upper String 10 90 PDistributionAcct_1 P_Distribution_Account:Account_Segment_Pool1 Account_Segment_Pool1 String 6 91 PDistributionAcct_2 P_Distribution_Account:Account_Segment_Pool2 Account_Segment_Pool2 String 6 92 PDistributionAcct_3 P_Distribution_Account:Account_Segment_Pool3 Account_Segment_Pool3 String 6 93 PDistributionAcct_4 P_Distribution_Account:Account_Segment_Pool4 Account_Segment_Pool4 String 6 94 PDistributionAcct_5 P_Distribution_Account:Account_Segment_Pool5 Account_Segment_Pool5 String 6 95 PDistributionAcct_6 P_Distribution_Account:Account_Segment_Pool6 Account_Segment_Pool6 String 6 96 PDistributionAcct_7 P_Distribution_Account:Account_Segment_Pool7 Account_Segment_Pool7 String 6 97 PDistributionAcct_8 P_Distribution_Account:Account_Segment_Pool8 Account_Segment_Pool8 String 6 98 PDistributionAcct_9 P_Distribution_Account:Account_Segment_Pool9 Account_Segment_Pool9 String 6 99 PDistributionAcct_10 P_Distribution_Account:Account_Segment_Pool10 Account_Segment_Pool10 String 6 100 PAllowMasterPaycodes P_Allow_Master_Paycodes X_VS_YN Integer 0 101 PAllowMasterNumMods P_Allow_Master_Num_Mods X_VS_YN Integer 0 102 PAllowEntryNumMods P_Allow_Entry_Num_Mods X_VS_YN Integer 0 103 PDisplayEntryRates P_Display_Entry_Rates X_VS_YN Integer 0 104 PPostEmployeeCount P_Post_Employee_Count X_VS_YN Integer 0 105 PAllowVoidCheques P_Allow_Void_Cheques X_VS_YN Integer 0 106 PAutoFallback P_Auto_Fallback X_VS_YN Integer 0 107 PWennSoftIntegration P_WennSoft_Integration X_VS_YN Integer 0 108 PInfoHRIntegration P_InfoHR_Integration X_VS_YN Integer 0 109 PGPSHRLink P_GPS_HR_Link X_VS_YN Integer 0 110 PRptNameChequeStub P_RptName_Cheque_Stub X_STR79_Rpt_Name String 79 111 PRptNameDetailAdvice P_RptName_Detail_Advice X_STR79_Rpt_Name String 79 112 PRptNameSummaryAdvice P_RptName_Summary_Advice X_STR79_Rpt_Name String 79 113 PRTableCodePrompt1 P_RTable_Code_Prompt1 X_STR15 String 15 114 PRTableCodePrompt2 P_RTable_Code_Prompt2 X_STR15 String 15 115 PRTableCodePrompt3 P_RTable_Code_Prompt3 X_STR15 String 15 116 PAllowVacationPooling P_Allow_Vacation_Pooling X_VS_YN Integer 0 117 PAccruedAvailableAfter P_Accrued_Available_After_Date X_Date Date 0 118 PAvailablePayoutAfter P_Available_Payout_After_Date X_Date Date 0 119 PAllowEIRebate P_Allow_EI_Rebate X_VS_YN Integer 0 120 PAllowEIRebateGLAccrual P_Allow_EI_Rebate_GL_Accrual X_VS_YN Integer 0 121 PSettlementInstID P_Settlement_Inst_ID X_Return_Institution_Code String 3 122 PSettlementTransitNum P_Settlement_Transit_Number X_Data_Center_Number String 5 123 PSettlementAccount P_Settlement_Account X_STR12_Upper String 12 124 PUseChequeMarkoff P_Use_Cheque_Markoff X_VS_YN Integer 0 125 POwedFromEEAcctIndex P_Owed_From_Employee_Account_Index LI_14 Long Integer 14 126 PEmployeeARAcctIndex P_Employee_AR_Account_Index LI_14 Long Integer 14 127 PAllowBankableDeductions P_Allow_Bankable_Deductions X_VS_YN Integer 0 128 PTreat2652As2753 P_Treat_2652_As_2753 X_VS_YN Integer 0 129 PAllowEELevelSec P_Allow_Employee_Level_Security X_VS_YN Integer 0 130 PFrequencyItems_1 P_Frequency_Items[1] STR20 String 20 131 PFrequencyItems_2 P_Frequency_Items[2] STR20 String 20 132 PFrequencyItems_3 P_Frequency_Items[3] STR20 String 20 133 PFrequencyItems_4 P_Frequency_Items[4] STR20 String 20 134 PFrequencyItems_5 P_Frequency_Items[5] STR20 String 20 135 PFrequencyItems_6 P_Frequency_Items[6] STR20 String 20 136 PFrequencyItems_7 P_Frequency_Items[7] STR20 String 20 137 PFrequencyItems_8 P_Frequency_Items[8] STR20 String 20 138 PFrequencyItems_9 P_Frequency_Items[9] STR20 String 20 139 PFrequencyItems_10 P_Frequency_Items[10] STR20 String 20 140 PFrequencyItems_11 P_Frequency_Items[11] STR20 String 20 141 PFrequencyItems_12 P_Frequency_Items[12] STR20 String 20 142 PFrequencyItems_13 P_Frequency_Items[13] STR20 String 20 143 PFrequencyItems_14 P_Frequency_Items[14] STR20 String 20 144 PFrequencyItems_15 P_Frequency_Items[15] STR20 String 20 145 PFrequencyItems_16 P_Frequency_Items[16] STR20 String 20 146 PLTDActionOptions P_LTD_Action_Options X_DDL_LTD_Action_Options Integer 0 147 PProvBasicPerAmt_1 P_Provincial_Basic_Personal_Amount[1] X_DLR11_2 Currency 14 148 PProvBasicPerAmt_2 P_Provincial_Basic_Personal_Amount[2] X_DLR11_2 Currency 14 149 PProvBasicPerAmt_3 P_Provincial_Basic_Personal_Amount[3] X_DLR11_2 Currency 14 150 PProvBasicPerAmt_4 P_Provincial_Basic_Personal_Amount[4] X_DLR11_2 Currency 14 151 PProvBasicPerAmt_5 P_Provincial_Basic_Personal_Amount[5] X_DLR11_2 Currency 14 152 PProvBasicPerAmt_6 P_Provincial_Basic_Personal_Amount[6] X_DLR11_2 Currency 14 153 PProvBasicPerAmt_7 P_Provincial_Basic_Personal_Amount[7] X_DLR11_2 Currency 14 154 PProvBasicPerAmt_8 P_Provincial_Basic_Personal_Amount[8] X_DLR11_2 Currency 14 155 PProvBasicPerAmt_9 P_Provincial_Basic_Personal_Amount[9] X_DLR11_2 Currency 14 156 PProvBasicPerAmt_10 P_Provincial_Basic_Personal_Amount[10] X_DLR11_2 Currency 14 157 PProvBasicPerAmt_11 P_Provincial_Basic_Personal_Amount[11] X_DLR11_2 Currency 14 158 PProvBasicPerAmt_12 P_Provincial_Basic_Personal_Amount[12] X_DLR11_2 Currency 14 159 PProvBasicPerAmt_13 P_Provincial_Basic_Personal_Amount[13] X_DLR11_2 Currency 14 160 PProvBasicPerAmt_14 P_Provincial_Basic_Personal_Amount[14] X_DLR11_2 Currency 14 161 PDefaultLastYear P_Default_Last_Year X_INT4_RU0 Integer 4 162 PAdvancedWCB P_Advanced_WCB X_VS_YN Integer 0 163 PLaserROE P_Laser_ROE X_VS_YN Integer 0 164 PLaserROEVersion P_Laser_ROE_Version X_STR7_Laser_ROE_Version String 7 165 PPAYPERBIWKLY P_Pay_Periods_Biweekly X_Pay_Periods_Biweekly Integer 0 166 PPAYPERWKLY P_Pay_Periods_Weekly X_Pay_Periods_Weekly Integer 0 167 RL1AuthNo RL1_Authorization_Number STR30 String 30 168 LastUpDate Last Updated Date DATE Date 6