Company Master (SY01500)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Company Master
Physical Name: SY01500
Technical Name: HRSY_Company_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1LSTUSRED SearchLast User to EditSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Company Master'].LSTUSRED AS 'Company Master-Last User to Edit'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY01500 AS ['Company Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Company Master'].LSTUSRED = ['Users Master'].USERID
2CREATDDT SearchCreated DateDTDate8
3MODIFDT SearchModified DateDTDate8
4CMPANYID SearchCompany IDINT5Integer4
5CMPNYNAM SearchCompany NameSTR64_Company_NameString64
6TAXEXMT1 SearchTax Exempt 1STR25String25
7TAXEXMT2 SearchTax Exempt 2STR25String25
8TAXREGTN SearchTax RegistrationSTR25String25
9COPTXSCH SearchCompany Purchases Tax ScheduleSTR15_LBAUString15
10COSTXSCH SearchCompany Sales Tax ScheduleSTR15_LBAUString15
11LOCATNNM SearchLocation NameSTR30String30
12ADRCNTCT SearchAddress ContactSTR60String60
13ADDRESS1 SearchAddress 1STR60String60
14ADDRESS2 SearchAddress 2STR60String60
15ADDRESS3 SearchAddress 3STR60String60
16CITY SearchCitySTR35String35
17COUNTY SearchCountySTR60String60
18STATE SearchStateSTR30_StateString29
19ZIPCODE SearchZip CodeSTR10String10
20PHONE1 SearchPhone 1Phone_NumberString14
21PHONE2 SearchPhone 2Phone_NumberString14
22PHONE3 SearchPhone 3Phone_Number3String14
23FAXNUMBR SearchFax NumberSTR14_FAXString14
24USESCRTY SearchUse SecurityCB_SecurityBoolean0
25UDCOSTR1 SearchUser Defined Company String 1STR30String30
26UDCOSTR2 SearchUser Defined Company String 2STR30String30
27CMPCNTRY SearchCompany CountrySTR60String60
28NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Company Master'].NOTEINDX AS 'Company Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SY01500 AS ['Company Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Company Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29PPSFRNUM SearchPPS File/Reconciliation NumberSTR25String25
30PPSTAXRT SearchPPS Tax RateINT5_%2Integer5
31PPSVNDID SearchPPS Vendor IDSTR_15_Vendor_IDString15
32VATMODE SearchVAT ModeCB_VAT_ModeBoolean0
33LOCATNID SearchLocation IDSTR15_Location_IDString15
34INTERID SearchIntercompany IDSTR5_IC_IDString5
35ACSEGSEP SearchAccount Segment SeperatorSTR1String1
36SECOPTS SearchSecurity OptionsML_Security_OptionsLong Integer0
37DisplayRegisteredPalette SearchDisplayRegisteredPalettesYNBoolean0
38Company_Options SearchCompany OptionsML_Company_OptionsLong Integer0
39Vets100CompanyNumber SearchVets 100 Company NumberSTR20String20
40TYPEOFBUSINESS SearchType of BusinessSTR30String30
41DUNS_Number SearchDUNS NumberSTR20String20
42SICNUMBER SearchSIC NumberSTR15String15
43GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
44BRNCHNMBR SearchBranch NumberSTR20String20
45DFLTTXDTLID SearchDefault Tax Detail IDSTR15_Tax_Detail_IDString15
46PurchasesTaxDetailID SearchPurchases Tax Detail IDSTR15_Tax_Detail_IDString15
47CCode SearchCountry CodeSTR6_VATString6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Company Master'].CCode AS 'Company Master-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SY01500 AS ['Company Master']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Company Master'].CCode = ['VAT Country Code MSTR'].CCode
48IVTRFDOCFMT SearchIvTrfDocFormatDDLInteger0
49Offline_User SearchOffline UserUser_IDString15
50WORKFLOWENABLED SearchWorkflow EnabledCB_WorkflowEnabledBoolean0
51CrmCredentialsMethod SearchCrmCredentialsMethodCrmCredentialsMethodInteger0
52CrmOrganizationName SearchCrmOrganizationNameSTR255String255
53CrmServiceUrl SearchCrmServiceUrlSTR255String255
54EnableGLReporting SearchEnable GL Reporting for MRCB_EnableGLReportingBoolean0
55EnableAAReporting SearchEnable AA Reporting for MRCB_Enable_AA_ReportingBoolean0
56UseDateEffectiveTax SearchUse Date Effective TaxCBBoolean0
57DateToUse SearchDate To UseDDLInteger0
58DEX_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.

Leave a Reply

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