Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB400077
Product: Cashbook (1058)
Series: Financial
Display Name: Print Chequebooks Temp
Physical Name: CB400077
Technical Name: CB_Print_CheckbooksSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Receipt_Next 
CB_Receipt_Next STR20 String 20 2 CB_Check_Format_String CB_Check_Format_String STR50 String 50 3 CB_Rate_Calc CB_Rate_Calc STR20 String 20 4 CB_Cash_Next CB_Cash_Next STR20 String 20 5 CB_Charges_Next CB_Charges_Next STR20 String 20 6 CB_Cheque_Next CB_Cheque_Next STR20 String 20 7 CB_Credit_Next CB_Credit_Next STR20 String 20 8 CB_Debit_Next CB_Debit_Next STR20 String 20 9 CB_Deposit_Next CB_Deposit_Next STR20 String 20 10 CB_Tele_Next CB_Tele_Next STR20 String 20 11 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Print Chequebooks Temp'].CHEKBKID AS 'Print Chequebooks Temp-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB400077 AS ['Print Chequebooks Temp']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Print Chequebooks Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 CB_Cashbook_Balance CB_Cashbook_Balance DLR19_RBS0_UTR$ Currency 19 13 CB_Default_Tax CB_Default_Tax STR20 String 20 14 CB_Multicurrency CB_Multicurrency STR20 String 20 15 CB_Password CB_Password STR20 String 20 16 CB_Posting_Date CB_Posting_Date STR20 String 20