Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCVAT35
Product: VAT Daybook (3096)
Series:
Display Name: vatDaybookReverseChargeTaxDetailSetup
Physical Name: EDCVAT35
Technical Name: vatDaybookReverseChargeTaxDetailSetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TAXDTLID 
Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['vatDaybookReverseChargeTaxDetailSetup'].TAXDTLID AS 'vatDaybookReverseChargeTaxDetailSetup-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
EDCVAT35 AS ['vatDaybookReverseChargeTaxDetailSetup']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['vatDaybookReverseChargeTaxDetailSetup'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID2 TXDTLDSC Tax Detail Description String STR30 30 3 TXDTLPDC Tax Detail Print on Documents Boolean CB_Print_on_Documents 0 4 TXDTLTYP Tax Detail Type Integer DDL_Tax_Detail_Type 0 5 RCTAXDTLID RC Tax Detail ID String STR15_Tax_Detail_ID 15 6 RCTXDTLDSC RC Tax Detail Description String STR30 30 7 RCTXDTLPDC RC Tax Detail Print on Documents Boolean CB_Print_on_Documents 0