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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1LSTUSRED SearchLast User to EditStringSTR1515
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 DateDateDT8
3MODIFDT SearchModified DateDateDT8
4CMPANYID SearchCompany IDIntegerINT54
5CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
6TAXEXMT1 SearchTax Exempt 1StringSTR2525
7TAXEXMT2 SearchTax Exempt 2StringSTR2525
8TAXREGTN SearchTax RegistrationStringSTR2525
9COPTXSCH SearchCompany Purchases Tax ScheduleStringSTR15_LBAU15
10COSTXSCH SearchCompany Sales Tax ScheduleStringSTR15_LBAU15
11LOCATNNM SearchLocation NameStringSTR3030
12ADRCNTCT SearchAddress ContactStringSTR6060
13ADDRESS1 SearchAddress 1StringSTR6060
14ADDRESS2 SearchAddress 2StringSTR6060
15ADDRESS3 SearchAddress 3StringSTR6060
16CITY SearchCityStringSTR3535
17COUNTY SearchCountyStringSTR6060
18STATE SearchStateStringSTR30_State29
19ZIPCODE SearchZip CodeStringSTR1010
20PHONE1 SearchPhone 1StringPhone_Number14
21PHONE2 SearchPhone 2StringPhone_Number14
22PHONE3 SearchPhone 3StringPhone_Number314
23FAXNUMBR SearchFax NumberStringSTR14_FAX14
24USESCRTY SearchUse SecurityBooleanCB_Security0
25UDCOSTR1 SearchUser Defined Company String 1StringSTR3030
26UDCOSTR2 SearchUser Defined Company String 2StringSTR3030
27CMPCNTRY SearchCompany CountryStringSTR6060
28NOTEINDX SearchNote IndexCurrencyDLR1414
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 NumberStringSTR2525
30PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
31PPSVNDID SearchPPS Vendor IDStringSTR_15_Vendor_ID15
32VATMODE SearchVAT ModeBooleanCB_VAT_Mode0
33LOCATNID SearchLocation IDStringSTR15_Location_ID15
34INTERID SearchIntercompany IDStringSTR5_IC_ID5
35ACSEGSEP SearchAccount Segment SeperatorStringSTR11
36SECOPTS SearchSecurity OptionsLong IntegerML_Security_Options0
37DisplayRegisteredPalette SearchDisplayRegisteredPalettesBooleanYN0
38Company_Options SearchCompany OptionsLong IntegerML_Company_Options0
39Vets100CompanyNumber SearchVets 100 Company NumberStringSTR2020
40TYPEOFBUSINESS SearchType of BusinessStringSTR3030
41DUNS_Number SearchDUNS NumberStringSTR2020
42SICNUMBER SearchSIC NumberStringSTR1515
43GOVCRPID SearchGovernmental Corporate IDStringSTR30_Gov_Corp_ID30
44BRNCHNMBR SearchBranch NumberStringSTR2020
45DFLTTXDTLID SearchDefault Tax Detail IDStringSTR15_Tax_Detail_ID15
46PurchasesTaxDetailID SearchPurchases Tax Detail IDStringSTR15_Tax_Detail_ID15
47CCode SearchCountry CodeStringSTR6_VAT6
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 SearchIvTrfDocFormatIntegerDDL0
49Offline_User SearchOffline UserStringUser_ID15
50WORKFLOWENABLED SearchWorkflow EnabledBooleanCB_WorkflowEnabled0
51CrmCredentialsMethod SearchCrmCredentialsMethodIntegerCrmCredentialsMethod0
52CrmOrganizationName SearchCrmOrganizationNameStringSTR255255
53CrmServiceUrl SearchCrmServiceUrlStringSTR255255
54EnableGLReporting SearchEnable GL Reporting for MRBooleanCB_EnableGLReporting0
55EnableAAReporting SearchEnable AA Reporting for MRBooleanCB_Enable_AA_Reporting0
56UseDateEffectiveTax SearchUse Date Effective TaxBooleanCB0
57DateToUse SearchDate To UseIntegerDDL0
58GroupVAT SearchGroup VATBooleanCB_Group VAT0

Leave a Reply

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