Checkbook Index table (CB900011)

azurecurveProductsCashbook (1058)FinancialCheckbook Index table (CB900011)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900011

Product: Cashbook (1058)
Series: Financial

Display Name: Checkbook Index table
Physical Name: CB900011
Technical Name: CB_Checkbook_Index_SETP

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
       ['Checkbook Index table'].CHEKBKID AS 'Checkbook Index table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB900011 AS ['Checkbook Index table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Checkbook Index table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2CB_Checkbook_Index SearchCB_Checkbook_IndexINT4Integer24
azurecurveProductsCashbook (1058)FinancialCheckbook Index table (CB900011)

Leave a Reply

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