Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1022
Product: Cashbook (1058)
Series: Financial
Display Name: CE voided report temp table
Physical Name: CBEU1022
Technical Name: CB_Euro_Voided_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Pay_Rec_Int 
CB_Pay_Rec_Int INT1 Integer 1 2 CB_Line_Number CB_Line_Number CB_Long Long Integer 10 3 CB_Error CB_Error boolean Boolean 0 4 CB_Import_Trx_Type CB_Import_Trx_Type STR50 String 50 5 CB_Ledger_Type CB_Ledger_Type INT3 Integer 3 6 CB_Error_Message_Text255 CB_Error_Message_Text_255 STR255 String 255 7 CB_Import_Invoice_No CB_Import_Invoice_No STR255 String 255 8 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CE voided report temp table'].CHEKBKID AS 'CE voided report temp table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBEU1022 AS ['CE voided report temp table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CE voided report temp table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID9 CB_Trx_Type_String CB_Trx_Type_String STR30 String 30 10 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CE voided report temp table'].CURNCYID AS 'CE voided report temp table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CBEU1022 AS ['CE voided report temp table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CE voided report temp table'].CURNCYID = ['Currency Setup'].CURNCYID11 CB_Bank_Account_Number CB_Bank_Account_Number STR35 String 35 12 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 13 CB_Orig_Trans_Amount CB_Orig_Trans_Amount CB_DLR19 Currency 19 14 CB_Transaction_Date CB_Transaction_Date DATE Date 6 15 CB_Transaction_Person CB_Transaction_Person STR50 String 50 16 DSCRIPTN Description STR30 String 30 17 CB_Imported_Linetext CB_Imported_Line_Text CB_Imported_Line Text 32765