Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME27619
Product: MICR for Canadian Payroll (2916)
Series: Purchasing
Display Name: ME_Pinacle_SETP
Physical Name: ME27619
Technical Name: ME_Pinacle_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CHEKBKID 
Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['ME_Pinacle_SETP'].CHEKBKID AS 'ME_Pinacle_SETP-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME27619 AS ['ME_Pinacle_SETP']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ME_Pinacle_SETP'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 ME_Repetitive_GB ME_Repetitive_GB GB Integer 0 3 ME_Bank_Account_Number ME_Bank_Account_Number STR350 String 35 4 ME_Bank_Company_Name ME_Bank_Company_Name STR23_LBAU String 23 5 ME_Wire_Transfer_File ME_Wire_Transfer_File STR255 String 255 6 ME_Wire_Transfer_Freefor ME_Wire_Transfer_Freeform_File STR255 String 255 7 resvstr1 ME_Transit_Number STR25 String 25