Import Numbers Used Temp (CBDEP001)

azurecurveProductsCashbook (1058)FinancialImport Numbers Used Temp (CBDEP001)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Import Numbers Used Temp
Physical Name: CBDEP001
Technical Name: CB_Import_Numbers_Temp

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
       ['Import Numbers Used Temp'].CHEKBKID AS 'Import Numbers Used Temp-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBDEP001 AS ['Import Numbers Used Temp']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Import Numbers Used Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2CB_Number_Type SearchCB_Number_TypeSTR10String1210
3CB_Next_Ref_No SearchCB_Next_Ref_NoSTR15String1615
4CB_Number_Used SearchCB_Number_UsedBooleanBoolean20
5CB_Number_CTL SearchCB_Number_CTLSTR15String1615
azurecurveProductsCashbook (1058)FinancialImport Numbers Used Temp (CBDEP001)

Leave a Reply

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