Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCSYS001
Product: Advanced Bank Reconciliation (2440)
Series: System
Display Name: NC_TableVersion_MSTR
Physical Name: NCSYS001
Technical Name: NC_TableVersion_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PRODID 
Product ID INT4 Integer 4 2 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['NC_TableVersion_MSTR'].CMPANYID AS 'NC_TableVersion_MSTR-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
NCSYS001 AS ['NC_TableVersion_MSTR']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['NC_TableVersion_MSTR'].CMPANYID = ['Company Master'].CMPANYID3 NC_System_Version NC System Version INT4 Integer 4 4 NC_Version_Major NC Version Major INT4 Integer 4 5 NC_Version_Minor NC Version Minor INT4 Integer 4 6 NC_Version_Build NC Version Build INT4 Integer 4 7 NC_SpareStrings_1 NC_SpareStrings[1] STR255 String 255 8 NC_SpareStrings_2 NC_SpareStrings[2] STR255 String 255 9 NC_SpareStrings_3 NC_SpareStrings[3] STR255 String 255 10 NC_SpareStrings_4 NC_SpareStrings[4] STR255 String 255 11 NC_SpareStrings_5 NC_SpareStrings[5] STR255 String 255 12 NC_SpareInts_1 NC_SpareInts[1] INT5 Integer 4 13 NC_SpareInts_2 NC_SpareInts[2] INT5 Integer 4 14 NC_SpareInts_3 NC_SpareInts[3] INT5 Integer 4 15 NC_SpareInts_4 NC_SpareInts[4] INT5 Integer 4 16 NC_SpareInts_5 NC_SpareInts[5] INT5 Integer 4 17 NC_SpareInts_6 NC_SpareInts[6] INT5 Integer 4 18 NC_SpareInts_7 NC_SpareInts[7] INT5 Integer 4 19 NC_SpareInts_8 NC_SpareInts[8] INT5 Integer 4 20 NC_SpareInts_9 NC_SpareInts[9] INT5 Integer 4 21 NC_SpareInts_10 NC_SpareInts[10] INT5 Integer 4