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 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).
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 |
| 2 | TAXDTLID | Tax Detail ID | STR15_Tax_Detail_ID | String | 15 |
| Key to the Sales/Purchases Tax Master (TX00201).
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 |
| 3 | TAXSCHID | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 |
| Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
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 |
| 4 | NC_Exclude_From_Reverse_ | NC Exclude From Reverse Charge VAT | NC Exclude From Reverse Charge VAT CB | Boolean | 0 |
