Company Location Master – HR Alias (SY00600)

azurecurveProductsHuman Resources (414)CompanyCompany Location Master - HR Alias (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 TypeLength
1CMPANYID SearchCompany IDINT5Integer4
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_IDString15
3LOCATNNM SearchLocation NameSTR30String30
4ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
5ADRCNTCT SearchAddress ContactSTR60String60
6ADDRESS1 SearchAddress 1STR60String60
7ADDRESS2 SearchAddress 2STR60String60
8ADDRESS3 SearchAddress 3STR60String60
9CITY SearchCitySTR35String35
10COUNTY SearchCountySTR60String60
11STATE SearchStateSTR30_StateString29
12ZIPCODE SearchZip CodeSTR10String10
13COUNTRY SearchCountrySTR60String60
14PHONE1 SearchPhone 1Phone_NumberString14
15PHONE2 SearchPhone 2Phone_NumberString14
16PHONE3 SearchPhone 3Phone_Number3String14
17FAXNUMBR SearchFax NumberSTR14_FAXString14
18CHANGEBY_I SearchChange BySTR15_User_IDString15
19CHANGEDATE_I SearchChange DateDTDate8
20NOTEINDX SearchNote IndexDLR14Currency14
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_VATString6
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 Searchintint10

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.

azurecurveProductsHuman Resources (414)CompanyCompany Location Master - HR Alias (SY00600)

Leave a Reply

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