Company Master – HR Alias (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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	LSTUSRED	Last User to Edit	STR15	String	16	15
	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
2	CREATDDT	Created Date	DT	Date	4	8
3	MODIFDT	Modified Date	DT	Date	4	8
4	CMPANYID	Company ID	INT5	Integer	2	4
5	CMPNYNAM	Company Name	STR64_Company_Name	String	66	64
6	TAXEXMT1	Tax Exempt 1	STR25	String	26	25
7	TAXEXMT2	Tax Exempt 2	STR25	String	26	25
8	TAXREGTN	Tax Registration	STR25	String	26	25
9	COPTXSCH	Company Purchases Tax Schedule	STR15_LBAU	String	16	15
10	COSTXSCH	Company Sales Tax Schedule	STR15_LBAU	String	16	15
11	LOCATNNM	Location Name	STR30	String	32	30
12	ADRCNTCT	Address Contact	STR60	String	62	60
13	ADDRESS1	Address 1	STR60	String	62	60
14	ADDRESS2	Address 2	STR60	String	62	60
15	ADDRESS3	Address 3	STR60	String	62	60
16	CITY	City	STR35	String	36	35
17	COUNTY	County	STR60	String	62	60
18	STATE	State	STR30_State	String	30	29
19	ZIPCODE	Zip Code	STR10	String	12	10
20	PHONE1	Phone 1	Phone_Number	String	22	14
21	PHONE2	Phone 2	Phone_Number	String	22	14
22	PHONE3	Phone 3	Phone_Number3	String	22	14
23	FAXNUMBR	Fax Number	STR14_FAX	String	22	14
24	USESCRTY	Use Security	CB_Security	Boolean	2	0
25	UDCOSTR1	User Defined Company String 1	STR30	String	32	30
26	UDCOSTR2	User Defined Company String 2	STR30	String	32	30
27	CMPCNTRY	Company Country	STR60	String	62	60
28	NOTEINDX	Note Index	DLR14	Currency	10	14
	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
29	PPSFRNUM	PPS File/Reconciliation Number	STR25	String	26	25
30	PPSTAXRT	PPS Tax Rate	INT5_%2	Integer	2	5
31	PPSVNDID	PPS Vendor ID	STR_15_Vendor_ID	String	16	15
32	VATMODE	VAT Mode	CB_VAT_Mode	Boolean	2	0
33	LOCATNID	Location ID	STR15_Location_ID	String	16	15
34	INTERID	Intercompany ID	STR5_IC_ID	String	6	5
35	ACSEGSEP	Account Segment Seperator	STR1	String	2	1
36	SECOPTS	Security Options	ML_Security_Options	Long Integer	4	0
37	DisplayRegisteredPalette	DisplayRegisteredPalettes	YN	Boolean	2	0
38	Company_Options	Company Options	ML_Company_Options	Long Integer	4	0
39	Vets100CompanyNumber	Vets 100 Company Number	STR20	String	22	20
40	TYPEOFBUSINESS	Type of Business	STR30	String	32	30
41	DUNS_Number	DUNS Number	STR20	String	22	20
42	SICNUMBER	SIC Number	STR15	String	16	15
43	GOVCRPID	Governmental Corporate ID	STR30_Gov_Corp_ID	String	32	30
44	BRNCHNMBR	Branch Number	STR20	String	22	20
45	DFLTTXDTLID	Default Tax Detail ID	STR15_Tax_Detail_ID	String	16	15
46	PurchasesTaxDetailID	Purchases Tax Detail ID	STR15_Tax_Detail_ID	String	16	15
47	CCode	Country Code	STR6_VAT	String	8	6
	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
48	IVTRFDOCFMT	IvTrfDocFormat	DDL	Integer	2	0
49	Offline_User	Offline User	User_ID	String	16	15
50	WORKFLOWENABLED	Workflow Enabled	CB_WorkflowEnabled	Boolean	2	0
51	CrmCredentialsMethod	CrmCredentialsMethod	CrmCredentialsMethod	Integer	2	0
52	CrmOrganizationName	CrmOrganizationName	STR255	String	256	255
53	CrmServiceUrl	CrmServiceUrl	STR255	String	256	255
54	EnableGLReporting	Enable GL Reporting for MR	CB_EnableGLReporting	Boolean	2	0
55	EnableAAReporting	Enable AA Reporting for MR	CB_Enable_AA_Reporting	Boolean	2	0
56	UseDateEffectiveTax	Use Date Effective Tax	CB	Boolean	2	0
57	DateToUse	Date To Use	DDL	Integer	2	0
58	DEX_ROW_ID		int	int	10	10
	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.

azurecurve Products Human Resources (414)SystemCompany Master - HR Alias (SY01500)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply