Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CFM00101
Product: Cash Flow Management (1632)
Series:
Display Name: CFM_Forecast_MSTR_CheckBookID
Physical Name: CFM00101
Technical Name: CFM_Forecast_MSTR_CheckBookIDSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EBS_Forecast_ID 
Forecast ID String STR15_Forecast_ID 15 2 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CFM_Forecast_MSTR_CheckBookID'].CHEKBKID AS 'CFM_Forecast_MSTR_CheckBookID-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CFM00101 AS ['CFM_Forecast_MSTR_CheckBookID']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CFM_Forecast_MSTR_CheckBookID'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID3 CFM_Exchange_Rate CFM Exchange Rate Currency CFM Exchange Rate 14 4 CFM_Calc_Method CFM Calc Method Integer CFM Calc Method 0