Numbers Used (CB600066)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Numbers Used
Physical Name: CB600066
Technical Name: CB_Numbers

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Numbers Used'].CHEKBKID AS 'Numbers Used-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB600066 AS ['Numbers Used']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Numbers Used'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2CB_Number_Type SearchCB_Number_TypeSTR10String10
3CB_Next_Ref_No SearchCB_Next_Ref_NoSTR15String15
4CB_Number_Used SearchCB_Number_UsedBooleanBoolean0
5CB_Number_CTL SearchCB_Number_CTLSTR15String15

Leave a Reply

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