Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFMTEMP
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_TEMP_CheckBook
Physical Name: CFMTEMP
Technical Name: CFM_TEMP_CheckBookSeq 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_TEMP_CheckBook'].CHEKBKID AS 'CFM_TEMP_CheckBook-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CFMTEMP AS ['CFM_TEMP_CheckBook']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CFM_TEMP_CheckBook'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 MKTOPROC Marked To Process Boolean CB 0 3 CFM_Exchange_Rate CFM Exchange Rate Currency CFM Exchange Rate 14 4 CFM_Calc_Method CFM Calc Method Integer CFM Calc Method 0