Company Location Master (SY00600)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Company Location Master
Physical Name: SY00600
Technical Name: HRSY_Location_MSTR

Group Display Name: Company Location Master
Group Technical Name: Company Location Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['Company Location Master'].CMPANYID AS 'Company Location Master-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       SY00600 AS ['Company Location Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Company Location Master'].CMPANYID = ['Company Master'].CMPANYID
2LOCATNID SearchLocation IDSTR15_Location_IDString1615
3LOCATNNM SearchLocation NameSTR30String3230
4ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
5ADRCNTCT SearchAddress ContactSTR60String6260
6ADDRESS1 SearchAddress 1STR60String6260
7ADDRESS2 SearchAddress 2STR60String6260
8ADDRESS3 SearchAddress 3STR60String6260
9CITY SearchCitySTR35String3635
10COUNTY SearchCountySTR60String6260
11STATE SearchStateSTR30_StateString3029
12ZIPCODE SearchZip CodeSTR10String1210
13COUNTRY SearchCountrySTR60String6260
14PHONE1 SearchPhone 1Phone_NumberString2214
15PHONE2 SearchPhone 2Phone_NumberString2214
16PHONE3 SearchPhone 3Phone_Number3String2214
17FAXNUMBR SearchFax NumberSTR14_FAXString2214
18CHANGEBY_I SearchChange BySTR15_User_IDString1615
19CHANGEDATE_I SearchChange DateDTDate48
20NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Company Location Master'].NOTEINDX AS 'Company Location Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SY00600 AS ['Company Location Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Company Location Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
21CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Company Location Master'].CCode AS 'Company Location Master-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SY00600 AS ['Company Location Master']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Company Location Master'].CCode = ['VAT Country Code MSTR'].CCode
22DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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