Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEUH122
Product: Cashbook (1058)
Series: Financial
Display Name: CE Transaction Work Hist
Physical Name: CBEUH122
Technical Name: CB_Euro_Transaction_Work_HistSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Times_Printed 
CB_Times_Printed INT3 Integer 3 2 CB_Cash_Document_Number CB_Cash_Document_Number STR30 String 30 3 CB_Sequence_Number CB_Sequence_Number INT5 Integer 4 4 MCTRXSTT MC Transaction State INT1 Integer 1 5 CB_Import_Invoice_No CB_Import_Invoice_No STR255 String 255 6 TRXSORCE TRX Source STR13 String 13 7 DOCTYPE Document Type DDL_Document_Type Integer 0 8 VCHRNMBR Voucher Number STR20_LBAU String 20 9 DOCNUMBR Document Number STR20_Document_Number String 20 10 ERMSGTXT Error Message Text STR255 String 255 11 ERMSGTX2 Error Message Text 2 STR255 String 255 12 CB_Tax_Only CB_Tax_Only boolean Boolean 0 13 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 14 CB_Denom_Exchange_Rate CB_Denom_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 15 CB_Orig_Currency_Index CB_Orig_Currency_Index INT5 Integer 4 16 CB_Checkbook_Currency_In CB_Checkbook_Currency_Index INT5 Integer 4 17 EXCHDATE Exchange Date DT_Date Date 6 18 EXPNDATE Expiration Date DT_Date Date 6 19 TIME1 Time TM6 Time 6 20 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['CE Transaction Work Hist'].RATETPID AS 'CE Transaction Work Hist-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['CE Transaction Work Hist'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID21 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['CE Transaction Work Hist'].EXGTBLID AS 'CE Transaction Work Hist-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['CE Transaction Work Hist'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID22 CB_Unmatched_Amount CB_Unmatched_Amount CB_DLR19 Currency 19 23 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 24 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 25 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 26 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 27 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 28 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 29 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 30 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 31 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 32 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 33 CB_Pay_Rec CB_Pay_Rec STR5 String 5 34 CB_Transaction_Status CB_Transaction_Status INT3 Integer 3 35 CB_Statement_No CB_Statement_No STR20 String 20 36 CB_Trx_Type_String CB_Trx_Type_String STR30 String 30 37 CB_Doc_No CB_Doc_No Document_Number String 20 38 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CE Transaction Work Hist'].CHEKBKID AS 'CE Transaction Work Hist-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CE Transaction Work Hist'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID39 CB_Ledger_Type CB_Ledger_Type INT3 Integer 3 40 CB_Transaction_Date CB_Transaction_Date DATE Date 6 41 CB_Transaction_Person CB_Transaction_Person STR50 String 50 42 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CE Transaction Work Hist'].ACTINDX AS 'CE Transaction Work Hist-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CE Transaction Work Hist'].ACTINDX = ['Account Index Master'].ACTINDX43 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CE Transaction Work Hist'].CURNCYID AS 'CE Transaction Work Hist-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CE Transaction Work Hist'].CURNCYID = ['Currency Setup'].CURNCYID44 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['CE Transaction Work Hist'].TAXSCHID AS 'CE Transaction Work Hist-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CBEUH122 AS ['CE Transaction Work Hist']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['CE Transaction Work Hist'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID45 DSCRIPTN Description STR30 String 30 46 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 47 RATECALC Rate Calc Method INT Integer 0 48 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 49 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 50 CB_Exc_Amount CB_Exc_Amount CB_DLR19 Currency 19 51 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 52 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 53 CB_Inc_Tax_Amount CB_Inc_Tax_Amount CB_DLR19 Currency 19 54 CB_Exc_Tax_Amount CB_Exc_Tax_Amount CB_DLR19 Currency 19 55 CB_Entered_Amount CB_Entered_Amount DLR19_RBS0_UTR$ Currency 19 56 CB_Check_Exc_Amount CB_Check_Exc_Amount CB_DLR19 Currency 19 57 CB_Check_Vat_Amount CB_Check_Vat_Amount CB_DLR19 Currency 19 58 CB_Check_Trans_Amount CB_Check_Trans_Amount CB_DLR19 Currency 19 59 CB_Check_Inc_Tax_Amount CB_Check_Inc_Tax_Amount CB_DLR19 Currency 19 60 CB_Check_Exc_Tax_Amount CB_Check_Exc_Tax_Amount CB_DLR19 Currency 19 61 CB_Check_Entered_Amount CB_Check_Entered_Amount CB_DLR19 Currency 19 62 CB_Orig_Exc_Amount CB_Orig_Exc_Amount CB_DLR19 Currency 19 63 CB_Orig_Vat_Amount CB_Orig_Vat_Amount CB_DLR19 Currency 19 64 CB_Orig_Trans_Amount CB_Orig_Trans_Amount CB_DLR19 Currency 19 65 CB_Orig_Inc_Tax_Amount CB_Orig_Inc_Tax_Amount CB_DLR19 Currency 19 66 CB_Orig_Exc_Tax_Amount CB_Orig_Exc_Tax_Amount CB_DLR19 Currency 19 67 CB_Orig_Entered_Amount CB_Orig_Entered_Amount CB_DLR19 Currency 19