Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVIM201
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_VATImport_LINE_SAVE
Physical Name: NCVIM201
Technical Name: NC_VATImport_LINE_SAVESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NC_Reference_ID 
NC Reference ID STR50 String 50 2 NC_Reference_Line NC Reference Line DLR19_$S2 Currency 19 3 JRNENTRY Journal Entry LI8_U0 Long Integer 8 4 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 5 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 6 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 7 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 8 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 9 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 10 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 11 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 12 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 13 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 14 ACTNUMST Account Number String STR128_LBU String 128 15 DSCRIPTN Description STR30 String 30 16 DEBITAMT Debit Amount DLR19_$S2 Currency 19 17 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 18 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_VATImport_LINE_SAVE'].TAXDTLID AS 'NC_VATImport_LINE_SAVE-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVIM201 AS ['NC_VATImport_LINE_SAVE']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_VATImport_LINE_SAVE'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID19 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 20 NC_Default_Taxes NC Default Taxes Boolean Boolean 0