NC_TableVersion_MSTR (NCSYS001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCSYS001

Display Name: NC_TableVersion_MSTR
Physical Name: NCSYS001
Technical Name: NC_TableVersion_MSTR

Seq 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'].CMPANYID
3	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