NC_TableVersion_MSTR (NCSYS001)

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_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PRODID SearchProduct IDINT4Integer24
2CMPANYID SearchCompany IDINT5Integer24
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
3NC_System_Version SearchNC System VersionINT4Integer24
4NC_Version_Major SearchNC Version MajorINT4Integer24
5NC_Version_Minor SearchNC Version MinorINT4Integer24
6NC_Version_Build SearchNC Version BuildINT4Integer24
7NC_SpareStrings_1 SearchNC_SpareStrings[1]STR255String256255
8NC_SpareStrings_2 SearchNC_SpareStrings[2]STR255String256255
9NC_SpareStrings_3 SearchNC_SpareStrings[3]STR255String256255
10NC_SpareStrings_4 SearchNC_SpareStrings[4]STR255String256255
11NC_SpareStrings_5 SearchNC_SpareStrings[5]STR255String256255
12NC_SpareInts_1 SearchNC_SpareInts[1]INT5Integer24
13NC_SpareInts_2 SearchNC_SpareInts[2]INT5Integer24
14NC_SpareInts_3 SearchNC_SpareInts[3]INT5Integer24
15NC_SpareInts_4 SearchNC_SpareInts[4]INT5Integer24
16NC_SpareInts_5 SearchNC_SpareInts[5]INT5Integer24
17NC_SpareInts_6 SearchNC_SpareInts[6]INT5Integer24
18NC_SpareInts_7 SearchNC_SpareInts[7]INT5Integer24
19NC_SpareInts_8 SearchNC_SpareInts[8]INT5Integer24
20NC_SpareInts_9 SearchNC_SpareInts[9]INT5Integer24
21NC_SpareInts_10 SearchNC_SpareInts[10]INT5Integer24

Leave a Reply

Your email address will not be published. Required fields are marked *