Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBABR08
Product: Cashbook (1058)
Series: Financial
Display Name: Bank Import Formula table
Physical Name: CBABR08
Technical Name: CB_ABR_FormulaSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_ABR_Formula_Field 
CB_ABR_Formula_Field STR10 String 10 2 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Bank Import Formula table'].CHEKBKID AS 'Bank Import Formula table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBABR08 AS ['Bank Import Formula table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Bank Import Formula table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID3 Formula Formula Formula Text 3000