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 TypeSQL DB LengthKeyable Length
1LSTUSRED SearchLast User to EditSTR15String1615
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 DateDTDate48
3MODIFDT SearchModified DateDTDate48
4CMPANYID SearchCompany IDINT5Integer24
5CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
6TAXEXMT1 SearchTax Exempt 1STR25String2625
7TAXEXMT2 SearchTax Exempt 2STR25String2625
8TAXREGTN SearchTax RegistrationSTR25String2625
9COPTXSCH SearchCompany Purchases Tax ScheduleSTR15_LBAUString1615
10COSTXSCH SearchCompany Sales Tax ScheduleSTR15_LBAUString1615
11LOCATNNM SearchLocation NameSTR30String3230
12ADRCNTCT SearchAddress ContactSTR60String6260
13ADDRESS1 SearchAddress 1STR60String6260
14ADDRESS2 SearchAddress 2STR60String6260
15ADDRESS3 SearchAddress 3STR60String6260
16CITY SearchCitySTR35String3635
17COUNTY SearchCountySTR60String6260
18STATE SearchStateSTR30_StateString3029
19ZIPCODE SearchZip CodeSTR10String1210
20PHONE1 SearchPhone 1Phone_NumberString2214
21PHONE2 SearchPhone 2Phone_NumberString2214
22PHONE3 SearchPhone 3Phone_Number3String2214
23FAXNUMBR SearchFax NumberSTR14_FAXString2214
24USESCRTY SearchUse SecurityCB_SecurityBoolean20
25UDCOSTR1 SearchUser Defined Company String 1STR30String3230
26UDCOSTR2 SearchUser Defined Company String 2STR30String3230
27CMPCNTRY SearchCompany CountrySTR60String6260
28NOTEINDX SearchNote IndexDLR14Currency1014
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 NumberSTR25String2625
30PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
31PPSVNDID SearchPPS Vendor IDSTR_15_Vendor_IDString1615
32VATMODE SearchVAT ModeCB_VAT_ModeBoolean20
33LOCATNID SearchLocation IDSTR15_Location_IDString1615
34INTERID SearchIntercompany IDSTR5_IC_IDString65
35ACSEGSEP SearchAccount Segment SeperatorSTR1String21
36SECOPTS SearchSecurity OptionsML_Security_OptionsLong Integer40
37DisplayRegisteredPalette SearchDisplayRegisteredPalettesYNBoolean20
38Company_Options SearchCompany OptionsML_Company_OptionsLong Integer40
39Vets100CompanyNumber SearchVets 100 Company NumberSTR20String2220
40TYPEOFBUSINESS SearchType of BusinessSTR30String3230
41DUNS_Number SearchDUNS NumberSTR20String2220
42SICNUMBER SearchSIC NumberSTR15String1615
43GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
44BRNCHNMBR SearchBranch NumberSTR20String2220
45DFLTTXDTLID SearchDefault Tax Detail IDSTR15_Tax_Detail_IDString1615
46PurchasesTaxDetailID SearchPurchases Tax Detail IDSTR15_Tax_Detail_IDString1615
47CCode SearchCountry CodeSTR6_VATString86
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 SearchIvTrfDocFormatDDLInteger20
49Offline_User SearchOffline UserUser_IDString1615
50WORKFLOWENABLED SearchWorkflow EnabledCB_WorkflowEnabledBoolean20
51CrmCredentialsMethod SearchCrmCredentialsMethodCrmCredentialsMethodInteger20
52CrmOrganizationName SearchCrmOrganizationNameSTR255String256255
53CrmServiceUrl SearchCrmServiceUrlSTR255String256255
54EnableGLReporting SearchEnable GL Reporting for MRCB_EnableGLReportingBoolean20
55EnableAAReporting SearchEnable AA Reporting for MRCB_Enable_AA_ReportingBoolean20
56UseDateEffectiveTax SearchUse Date Effective TaxCBBoolean20
57DateToUse SearchDate To UseDDLInteger20
58DEX_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 *