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