Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MAV00201
Product: MIS-AMS Extensions (3459)
Series: Company
Display Name: MAV VAT Master File
Physical Name: MAV00201
Technical Name: MAV_Detail_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MAVTAXID 
MAV Tax Detail ID STR15_Tax_Detail_ID String 15 2 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['MAV VAT Master File'].TAXDTLID AS 'MAV VAT Master File-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
MAV00201 AS ['MAV VAT Master File']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['MAV VAT Master File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID