CE Transaction Work (CBEU1102)

azurecurveProductsCashbook (1058)FinancialCE Transaction Work (CBEU1102)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEU1102

Product: Cashbook (1058)
Series: Financial

Display Name: CE Transaction Work
Physical Name: CBEU1102
Technical Name: CB_Euro_Transaction_Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Times_Printed SearchCB_Times_PrintedINT3Integer23
2CB_Cash_Document_Number SearchCB_Cash_Document_NumberSTR30String3230
3CB_Sequence_Number SearchCB_Sequence_NumberINT5Integer24
4MCTRXSTT SearchMC Transaction StateINT1Integer21
5CB_Import_Invoice_No SearchCB_Import_Invoice_NoSTR255String256255
6TRXSORCE SearchTRX SourceSTR13String1413
7DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
8VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
9DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
10ERMSGTXT SearchError Message TextSTR255String256255
11ERMSGTX2 SearchError Message Text 2STR255String256255
12CB_Tax_Only SearchCB_Tax_OnlybooleanBoolean20
13DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
14CB_Denom_Exchange_Rate SearchCB_Denom_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
15CB_Orig_Currency_Index SearchCB_Orig_Currency_IndexINT5Integer24
16CB_Checkbook_Currency_In SearchCB_Checkbook_Currency_IndexINT5Integer24
17EXCHDATE SearchExchange DateDT_DateDate46
18EXPNDATE SearchExpiration DateDT_DateDate46
19TIME1 SearchTimeTM6Time46
20RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['CE Transaction Work'].RATETPID AS 'CE Transaction Work-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['CE Transaction Work'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
21EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['CE Transaction Work'].EXGTBLID AS 'CE Transaction Work-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['CE Transaction Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
22CB_Unmatched_Amount SearchCB_Unmatched_AmountCB_DLR19Currency1019
23ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
24ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
25ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
26ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
27ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
28ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
29ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
30ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
31ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
32ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
33CB_Pay_Rec SearchCB_Pay_RecSTR5String65
34CB_Transaction_Status SearchCB_Transaction_StatusINT3Integer23
35CB_Statement_No SearchCB_Statement_NoSTR20String2220
36CB_Trx_Type_String SearchCB_Trx_Type_StringSTR30String3230
37CB_Doc_No SearchCB_Doc_NoDocument_NumberString2220
38CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CE Transaction Work'].CHEKBKID AS 'CE Transaction Work-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CE Transaction Work'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
39CB_Ledger_Type SearchCB_Ledger_TypeINT3Integer23
40CB_Transaction_Date SearchCB_Transaction_DateDATEDate46
41CB_Transaction_Person SearchCB_Transaction_PersonSTR50String5250
42ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['CE Transaction Work'].ACTINDX AS 'CE Transaction Work-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['CE Transaction Work'].ACTINDX = ['Account Index Master'].ACTINDX
43CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['CE Transaction Work'].CURNCYID AS 'CE Transaction Work-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['CE Transaction Work'].CURNCYID = ['Currency Setup'].CURNCYID
44TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['CE Transaction Work'].TAXSCHID AS 'CE Transaction Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CBEU1102 AS ['CE Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['CE Transaction Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
45DSCRIPTN SearchDescriptionSTR30String3230
46XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
47RATECALC SearchRate Calc MethodINTInteger20
48CB_Exchange_Rate SearchCB_Exchange_RateDLR14_Exchange_RateCurrency (Variable)1014
49CB_Rate_Calc_Method SearchCB_Rate_Calc_MethodINTInteger20
50CB_Exc_Amount SearchCB_Exc_AmountCB_DLR19Currency1019
51Vat_Amount SearchVat_AmountDLR19_RBS0_UTR$Currency1019
52CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
53CB_Inc_Tax_Amount SearchCB_Inc_Tax_AmountCB_DLR19Currency1019
54CB_Exc_Tax_Amount SearchCB_Exc_Tax_AmountCB_DLR19Currency1019
55CB_Entered_Amount SearchCB_Entered_AmountDLR19_RBS0_UTR$Currency1019
56CB_Check_Exc_Amount SearchCB_Check_Exc_AmountCB_DLR19Currency1019
57CB_Check_Vat_Amount SearchCB_Check_Vat_AmountCB_DLR19Currency1019
58CB_Check_Trans_Amount SearchCB_Check_Trans_AmountCB_DLR19Currency1019
59CB_Check_Inc_Tax_Amount SearchCB_Check_Inc_Tax_AmountCB_DLR19Currency1019
60CB_Check_Exc_Tax_Amount SearchCB_Check_Exc_Tax_AmountCB_DLR19Currency1019
61CB_Check_Entered_Amount SearchCB_Check_Entered_AmountCB_DLR19Currency1019
62CB_Orig_Exc_Amount SearchCB_Orig_Exc_AmountCB_DLR19Currency1019
63CB_Orig_Vat_Amount SearchCB_Orig_Vat_AmountCB_DLR19Currency1019
64CB_Orig_Trans_Amount SearchCB_Orig_Trans_AmountCB_DLR19Currency1019
65CB_Orig_Inc_Tax_Amount SearchCB_Orig_Inc_Tax_AmountCB_DLR19Currency1019
66CB_Orig_Exc_Tax_Amount SearchCB_Orig_Exc_Tax_AmountCB_DLR19Currency1019
67CB_Orig_Entered_Amount SearchCB_Orig_Entered_AmountCB_DLR19Currency1019
azurecurveProductsCashbook (1058)FinancialCE Transaction Work (CBEU1102)

Leave a Reply

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