Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM50100
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_BR
Physical Name: CFM50100
Technical Name: CFM_BRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CHEKBKID 
Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CFM_BR'].CHEKBKID AS 'CFM_BR-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CFM50100 AS ['CFM_BR']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CFM_BR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 DSCRIPTN Description String STR30 30 3 Amount Amount Currency Currency_19_0 19