Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00500
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM_CheckbookList
Physical Name: CM00500
Technical Name: CM_CheckbookList_ViewSeq 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
['CM_CheckbookList'].CHEKBKID AS 'CM_CheckbookList-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM00500 AS ['CM_CheckbookList']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM_CheckbookList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID2 DSCRIPTN Description String STR30 30 3 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM_CheckbookList'].CURNCYID AS 'CM_CheckbookList-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CM00500 AS ['CM_CheckbookList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM_CheckbookList'].CURNCYID = ['Currency Setup'].CURNCYID4 INACTIVE Inactive Boolean CB_Inactive 0 5 CURRBLNC Current Balance Currency DLR19_RBS0_STR$ 19 6 BANKID Bank ID String STR15_Bank_ID 15 7 CMUSRDF1 CM User Defined 1 String STR20 20 8 CMUSRDF2 CM User Defined 2 String STR20 20 9 Last_Reconciled_Balance Last Reconciled Balance Currency DLR19_$S2 19 10 Last_Reconciled_Date Last Reconciled Date Date DT 8 11 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM_CheckbookList'].CURRNIDX AS 'CM_CheckbookList-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CM00500 AS ['CM_CheckbookList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM_CheckbookList'].CURRNIDX = ['Currency Setup'].CURRNIDX