Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1109
Product: Cashbook (1058)
Series: Financial
Display Name: EBM Posting Table Temp
Physical Name: CBEU1109
Technical Name: CB_Euro_Posting_TempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Pay_Rec 
CB_Pay_Rec STR5 String 5 2 CB_Matched CB_Matched boolean Boolean 0 3 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 4 CB_Batch_Total CB_Batch_Total boolean Boolean 0 5 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['EBM Posting Table Temp'].CHEKBKID AS 'EBM Posting Table Temp-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBEU1109 AS ['EBM Posting Table Temp']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['EBM Posting Table Temp'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID6 CB_Ledger_Type CB_Ledger_Type INT3 Integer 3 7 CB_Doc_No CB_Doc_No Document_Number String 20 8 BCHSOURC Batch Source STR15 String 15 9 BACHNUMB Batch Number STR15_LBAU String 15 10 JRNENTRY Journal Entry LI8_U0 Long Integer 8 11 DOCNUMBR Document Number STR20_Document_Number String 20 12 PMNTNMBR Payment Number STR20_LBAU String 20