Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBEUH107
Product: Cashbook (1058)
Series: Financial
Display Name: CE Tax Table History
Physical Name: CBEUH107
Technical Name: CB_Euro_Vat_Table_HistSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTINDX 
Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CE Tax Table History'].ACTINDX AS 'CE Tax Table History-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CBEUH107 AS ['CE Tax Table History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CE Tax Table History'].ACTINDX = ['Account Index Master'].ACTINDX2 CB_Vat_Not_Rounded CB_Vat_Not_Rounded DLR19_RBS0_UTR$ Currency 19 3 CB_Exc_Inc CB_Exc_Inc DDL Integer 0 4 TXDTLPCT Tax Detail Percent DLR7_%5S Currency 7 5 CB_Trans_Type CB_Trans_Type STR1 String 1 6 CB_Ref_No CB_Ref_No CB_STR15NoNegative String 15 7 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['CE Tax Table History'].TAXDTLID AS 'CE Tax Table History-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
CBEUH107 AS ['CE Tax Table History']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['CE Tax Table History'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID8 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 9 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 10 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 11 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 12 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 13 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 14 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 15 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 16 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 17 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 18 BACHNUMB Batch Number STR15_LBAU String 15 19 DOCNUMBR Document Number STR20_Document_Number String 20 20 CB_Type_Description CB_Type_Description STR30 String 30 21 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 22 TXDTLBSE Tax Detail Base DDL_Tax_Detail_Base Integer 0 23 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 24 CB_Check_Vat_Amount CB_Check_Vat_Amount CB_DLR19 Currency 19 25 CB_Orig_Vat_Amount CB_Orig_Vat_Amount CB_DLR19 Currency 19