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