SY01500 - Company Master | Prospr - Dynamics GP Table Reference

SY01500 - Company Master

Query Builder

Select * from SY01500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
LSTUSRED	Last User to Edit	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
CMPANYID	Company ID	Integer	2	View
CMPNYNAM	Company Name	String	66	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TAXREGTN	Tax Registration	String	26	View
COPTXSCH	Company Purchases Tax Schedule	String	16	View
COSTXSCH	Company Sales Tax Schedule	String	16	View
LOCATNNM	Location Name	String	32	View
ADRCNTCT	Address Contact	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
COUNTY	County	String	62	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
USESCRTY	Use Security	Boolean	2	View
UDCOSTR1	User Defined Company String 1	String	32	View
UDCOSTR2	User Defined Company String 2	String	32	View
CMPCNTRY	Company Country	String	62	View
NOTEINDX	Note Index	Currency	10	View
PPSFRNUM	PPS File/Reconciliation Number	String	26	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
PPSVNDID	PPS Vendor ID	String	16	View
VATMODE	VAT Mode	Boolean	2	View
LOCATNID	Location ID	String	16	View
INTERID	Intercompany ID	String	6	View
ACSEGSEP	Account Segment Seperator	String	2	View
SECOPTS	Security Options	Long Integer	4	View
DisplayRegisteredPalette	DisplayRegisteredPalettes	Boolean	2	View
Company_Options	Company Options	Long Integer	4	View
Vets100CompanyNumber	Vets 100 Company Number	String	22	View
TYPEOFBUSINESS	Type of Business	String	32	View
DUNS_Number	DUNS Number	String	22	View
SICNUMBER	SIC Number	String	16	View
GOVCRPID	Governmental Corporate ID	String	32	View
BRNCHNMBR	Branch Number	String	22	View
DFLTTXDTLID	Default Tax Detail ID	String	16	View
PurchasesTaxDetailID	Purchases Tax Detail ID	String	16	View
CCode	Country Code	String	8	View
IVTRFDOCFMT	IvTrfDocFormat	Integer	2	View
WORKFLOWENABLED	Workflow Enabled	Boolean	2	View
CrmCredentialsMethod	CrmCredentialsMethod	Integer	2	View
CrmOrganizationName	CrmOrganizationName	String	256	View
CrmServiceUrl	CrmServiceUrl	String	256	View

SY01500 - Company Master

Query Builder

Customer Service

Information

My Account

Contact Us