Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00201
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM Merchant Checkbook Store
Physical Name: CM00201
Technical Name: cmMerchantCheckbookStoreSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MerchantID 
MerchantID String STR16_MerchantID 16 2 StoreNumber StoreNumber String STR65_StoreNumber 10 3 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CM Merchant Checkbook Store'].CHEKBKID AS 'CM Merchant Checkbook Store-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM00201 AS ['CM Merchant Checkbook Store']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM Merchant Checkbook Store'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID4 EFTUserID EFTUserID String STR32 32