CE voided report temp table (CBEU1022)

azurecurveProductsCashbook (1058)FinancialCE voided report temp table (CBEU1022)

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_Report

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

Leave a Reply

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