Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT001
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_Detail_MSTR_Extra_8002a
Physical Name: NCVAT001
Technical Name: NC_Detail_MSTR_Extra_8002aSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TAXDTLID 
Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_Detail_MSTR_Extra_8002a'].TAXDTLID AS 'NC_Detail_MSTR_Extra_8002a-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT001 AS ['NC_Detail_MSTR_Extra_8002a']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_Detail_MSTR_Extra_8002a'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID2 NC_VAT_Treatment NC VAT Treatment NC_VAT_Treatment Integer 0 3 NC_Recoverable_Rate NC Recoverable Rate NC Recoverable Currency 8 4 NC_Destination_Tax_Detai NC Destination Tax Detail ID STR15_Tax_Detail_ID String 15 5 NC_Memo_Account_Index NC Memo Account Index LI_14 Long Integer 14 6 NC_VAT_Calc_Type NC VAT Calc Type NC VAT Calc Type Integer 0 7 NC_VAT_100_Option NC VAT 100 Option GB Integer 0 8 NC_VAT_Allocation NC VAT Allocation NC VAT Calc Type Integer 0 9 NC_VAT_Accrual_Account_I NC VAT Accrual Account Index LI_14 Long Integer 14 10 NC_Expense_Offset_Acc_St NC Expense Offset Acc String STR130 String 130 11 NC_Non_Rec_Acc_String NC Non Rec Acc String STR130 String 130 12 NC_Change_Reason_Require NC Change Reason Required NC Change Reason Required Boolean 0 13 NC_Reverse_Charge_Tax_De NC Reverse Charge Tax Detail ID STR15_Tax_Detail_ID String 15