MAV VAT Master File (MAV00201)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MAVTAXID SearchMAV Tax Detail IDSTR15_Tax_Detail_IDString1615
2TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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

Leave a Reply

Your email address will not be published. Required fields are marked *