Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MAV00100
Product: MIS-AMS Extensions (3459)
Series: Financial
Display Name: MAV Account Master
Physical Name: MAV00100
Technical Name: MAV_GL_Account_MSTRSeq 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
['MAV Account Master'].ACTINDX AS 'MAV Account Master-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
MAV00100 AS ['MAV Account Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['MAV Account Master'].ACTINDX = ['Account Index Master'].ACTINDX2 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['MAV Account Master'].TAXDTLID AS 'MAV Account Master-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
MAV00100 AS ['MAV Account Master']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['MAV Account Master'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID3 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['MAV Account Master'].TAXSCHID AS 'MAV Account Master-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
MAV00100 AS ['MAV Account Master']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['MAV Account Master'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID