Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CPY30010
Product: MICR for Canadian Payroll (2916)
Series: Project
Display Name: CDN Payroll Batch Control Master
Physical Name: CPY30010
Technical Name: P_CPY_SETP_BatchSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 BCHCOMNT Batch Comment STR60 String 60 3 PStartDate P_Start_Date X_Date Date 0 4 PCutoffDate P_Cutoff_Date X_Date Date 0 5 PChequeDate P_Cheque_Date X_Date Date 0 6 PNumberofTRX P_Number_of_TRX X_Number_TRX Long Integer 6 7 PNumberofEmployees P_Number_of_Employees X_Number_TRX Long Integer 6 8 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['CDN Payroll Batch Control Master'].USERID AS 'CDN Payroll Batch Control Master-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CPY30010 AS ['CDN Payroll Batch Control Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['CDN Payroll Batch Control Master'].USERID = ['Users Master'].USERID9 PChequebookID P_Chequebook_ID X_STR15_LBAU String 15 10 POvertimeGenerated P_Overtime_Generated X_VS_YN Integer 0 11 PBatchCalculated P_Batch_Calculated X_VS_YN Integer 0 12 PChequesGenerated P_Cheques_Generated X_VS_YN Integer 0 13 PChequesPrinted P_Cheques_Printed X_VS_YN Integer 0 14 PPosterCreated P_Poster_Created X_VS_YN Integer 0 15 PBatchPosted P_Batch_Posted X_VS_YN Integer 0 16 PMastersUpdated P_Masters_Updated X_VS_YN Integer 0 17 PBatchAppended P_Batch_Appended X_VS_YN Integer 0 18 PJobsProcessed P_Jobs_Processed X_VS_YN Integer 0 19 PPayPeriods P_Pay_Periods X_Pay_Periods Integer 0 20 PBatchType P_Batch_Type X_Batch_Type Integer 0 21 PBatchStatus P_Batch_Status X_Batch_Status Integer 0 22 PDateCompleted P_Date_Completed X_Date Date 0 23 PBatchOther P_Batch_Other X_STR10 String 10 24 PErrorOccuredCalculation P_Error_Occured_Calculation X_Boolean Boolean 0 25 PErrorOccuredPosting P_Error_Occured_Posting X_Boolean Boolean 0 26 PDeveloperFlag_1 P_Developer_Flag[1] X_VS_YN Integer 0 27 PDeveloperFlag_2 P_Developer_Flag[2] X_VS_YN Integer 0 28 PDeveloperFlag_3 P_Developer_Flag[3] X_VS_YN Integer 0 29 PDeveloperFlag_4 P_Developer_Flag[4] X_VS_YN Integer 0 30 PDeveloperFlag_5 P_Developer_Flag[5] X_VS_YN Integer 0 31 PDeveloperDesc_1 P_Developer_Desc[1] X_STR15 String 15 32 PDeveloperDesc_2 P_Developer_Desc[2] X_STR15 String 15 33 PDeveloperDesc_3 P_Developer_Desc[3] X_STR15 String 15 34 PDeveloperDesc_4 P_Developer_Desc[4] X_STR15 String 15 35 PDeveloperDesc_5 P_Developer_Desc[5] X_STR15 String 15 36 PCalcPreventReclaims P_Calc_Prevent_Reclaims X_VS_YN Integer 0 37 PCalcPayVacationPay P_Calc_Pay_Vacation_Pay X_VS_DefYN Integer 0 38 PAutoSelectPaycodeMode P_Auto_Select_Paycode_Mode X_DDL_Auto_Select_Paycode_Mode Integer 0 39 PCalcAutoPayNegBankDed P_Calc_Auto_Pay_Negative_BankDed X_VS_YN Integer 0 40 PCalcPayEIRebate P_Calc_Pay_EI_Rebate X_VS_DefYN Integer 0 41 PCalcSecondBatch P_Calc_Second_Batch X_VS_YN Integer 0 42 PSecurityGroupID P_Security_Group_ID X_STR15_LBAU String 15 43 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CDN Payroll Batch Control Master'].NOTEINDX AS 'CDN Payroll Batch Control Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CPY30010 AS ['CDN Payroll Batch Control Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CDN Payroll Batch Control Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX44 PFrequencyBatch P_Frequency_Batch X_MSL_Frequency_Batch Long Integer 0