CM_CheckbookList (CM00500)

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_View

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
2DSCRIPTN SearchDescriptionSTR30String3230
3CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
4INACTIVE SearchInactiveCB_InactiveBoolean20
5CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
6BANKID SearchBank IDSTR15_Bank_IDString1615
7CMUSRDF1 SearchCM User Defined 1STR20String2220
8CMUSRDF2 SearchCM User Defined 2STR20String2220
9Last_Reconciled_Balance SearchLast Reconciled BalanceDLR19_$S2Currency1019
10Last_Reconciled_Date SearchLast Reconciled DateDTDate48
11CURRNIDX SearchCurrency IndexINT3Integer23
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
12DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *