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: SY_Location_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
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 IDStringSTR15_Location_ID15
3LOCATNNM SearchLocation NameStringSTR3030
4ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
5ADRCNTCT SearchAddress ContactStringSTR6060
6ADDRESS1 SearchAddress 1StringSTR6060
7ADDRESS2 SearchAddress 2StringSTR6060
8ADDRESS3 SearchAddress 3StringSTR6060
9CITY SearchCityStringSTR3535
10COUNTY SearchCountyStringSTR6060
11STATE SearchStateStringSTR30_State29
12ZIPCODE SearchZip CodeStringSTR1010
13COUNTRY SearchCountryStringSTR6060
14PHONE1 SearchPhone 1StringPhone_Number14
15PHONE2 SearchPhone 2StringPhone_Number14
16PHONE3 SearchPhone 3StringPhone_Number314
17FAXNUMBR SearchFax NumberStringSTR14_FAX14
18CHANGEBY_I SearchChange ByStringSTR15_User_ID15
19CHANGEDATE_I SearchChange DateDateDT8
20NOTEINDX SearchNote IndexCurrencyDLR1414
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 CodeStringSTR6_VAT6
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

Leave a Reply

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