Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT002
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_Account_MSTR_Extra
Physical Name: NCVAT002
Technical Name: NC_Account_MSTR_ExtraSeq 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
['NC_Account_MSTR_Extra'].ACTINDX AS 'NC_Account_MSTR_Extra-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT002 AS ['NC_Account_MSTR_Extra']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Account_MSTR_Extra'].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
['NC_Account_MSTR_Extra'].TAXDTLID AS 'NC_Account_MSTR_Extra-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT002 AS ['NC_Account_MSTR_Extra']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_Account_MSTR_Extra'].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
['NC_Account_MSTR_Extra'].TAXSCHID AS 'NC_Account_MSTR_Extra-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
NCVAT002 AS ['NC_Account_MSTR_Extra']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['NC_Account_MSTR_Extra'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID4 NC_Exclude_From_Reverse_ NC Exclude From Reverse Charge VAT NC Exclude From Reverse Charge VAT CB Boolean 0