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 TypeLength
1CHEKBKID SearchCheckbook IDStringSTR15_Checkbook_ID15
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 SearchDescriptionStringSTR3030
3CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 SearchInactiveBooleanCB_Inactive0
5CURRBLNC SearchCurrent BalanceCurrencyDLR19_RBS0_STR$19
6BANKID SearchBank IDStringSTR15_Bank_ID15
7CMUSRDF1 SearchCM User Defined 1StringSTR2020
8CMUSRDF2 SearchCM User Defined 2StringSTR2020
9Last_Reconciled_Balance SearchLast Reconciled BalanceCurrencyDLR19_$S219
10Last_Reconciled_Date SearchLast Reconciled DateDateDT8
11CURRNIDX SearchCurrency IndexIntegerINT33
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

Leave a Reply

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