Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT009
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_Account_MSTR_Extra_2
Physical Name: NCVAT009
Technical Name: NC_Account_MSTR_Extra_2Seq 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_2'].ACTINDX AS 'NC_Account_MSTR_Extra_2-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT009 AS ['NC_Account_MSTR_Extra_2']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Account_MSTR_Extra_2'].ACTINDX = ['Account Index Master'].ACTINDX2 NC_Vat_Control_Account NC_Vat_Control_Account boolean Boolean 0