CE Import table (CBEU1028)

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_Import

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
2CB_Pay_Rec_Int SearchCB_Pay_Rec_IntINT1Integer21
3CB_Line_Number SearchCB_Line_NumberCB_LongLong Integer410
4CB_Error SearchCB_ErrorbooleanBoolean20
5CB_Import_Trx_Type SearchCB_Import_Trx_TypeSTR50String5250
6CB_Ledger_Type SearchCB_Ledger_TypeINT3Integer23
7CB_Error_Message_Text255 SearchCB_Error_Message_Text_255STR255String256255
8CB_Import_Invoice_No SearchCB_Import_Invoice_NoSTR255String256255
9CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
10CB_Trx_Type_String SearchCB_Trx_Type_StringSTR30String3230
11CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
12CB_Bank_Account_Number SearchCB_Bank_Account_NumberSTR35String3635
13CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
14CB_Orig_Trans_Amount SearchCB_Orig_Trans_AmountCB_DLR19Currency1019
15CB_Transaction_Date SearchCB_Transaction_DateDATEDate46
16CB_Transaction_Person SearchCB_Transaction_PersonSTR50String5250
17DSCRIPTN SearchDescriptionSTR30String3230

Leave a Reply

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