MAV Account Master (MAV00100)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ACTINDX SearchAccount IndexLI_14Long Integer414
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'].ACTINDX
2TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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'].TAXDTLID
3TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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

Leave a Reply

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