Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVIM003
Product: Advanced VAT (2474)
Series: System
Display Name: NC_VATImport_Errors
Physical Name: NCVIM003
Technical Name: NC_VATImport_ErrorsSeq 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 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['NC_VATImport_Errors'].INTERID AS 'NC_VATImport_Errors-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
NCVIM003 AS ['NC_VATImport_Errors']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['NC_VATImport_Errors'].INTERID = ['Company Master'].INTERID
4 JRNENTRY Journal Entry LI8_U0 Long Integer 8 5 NC_Status NC Status INT1 Integer 1 6 NC_Error_List_String NC Error List String NC Error List String Text 0