NC_Account_MSTR_Extra_9003s (NCVAT002)

azurecurveProductsAdvanced VAT (2474)FinancialNC_Account_MSTR_Extra_9003s (NCVAT002)

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_Extra

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ACTINDX SearchAccount IndexLI_14Long Integer14
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'].ACTINDX
2TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
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'].TAXDTLID
3TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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'].TAXSCHID
4NC_Exclude_From_Reverse_ SearchNC Exclude From Reverse Charge VATNC Exclude From Reverse Charge VAT CBBoolean0
azurecurveProductsAdvanced VAT (2474)FinancialNC_Account_MSTR_Extra_9003s (NCVAT002)

Leave a Reply

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