dbo.GO_CompanyLocations View

GreenshadesOnline Integration Help

dbo.GO_CompanyLocations View

Collapse All

SQL Objects Database > dbo Schema : dbo.GO_CompanyLocations View

Description

This Table is required for Paystub only integration.

Properties

Creation Date	7/17/2015 10:23 AM
Is Schema Bound
Encrypted
Ansi Nulls

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	LocationID	Unique identifier for work location This column relates to Location Column in GO_Employees	varchar	50
	LocationName	Name of work location	varchar	100
	AddressCode	This column is optional	char	15
	LocationContact	Name of the main contact at this location	char	61
	AddressOne	Physical location - address line 1	char	61
	AddressTwo	Physical location - address line 2	char	61
	AddressThree	Physical location - address line 3	char	61
	City	Physical location - city	char	35
	County	Physical location - county	char	61
	State	Physical location - state or province	char	29
	ZipCode	Physical location - five- or nine-digit ZIP code	char	11
	Country	Physical location - country	char	61
	Phone1	Location phone	char	21
	Phone2	Alternate location phone	char	21
	Phone3	Alternate location phone 2	char	21
	FaxNumber	Location Fax Number	char	21
	CompanyLocationID		int	4

See Also

Related Objects

dbo Schema
SQL Objects Database

© 2015 All Rights Reserved.

Send comments on this topic.