SITE Table

The SITE table stores telephone and fax numbers, and responsible individual information for sites. Sites are locations for products. Product site information is entered using the Infor CRM Windows Client (Tools > Manage > Centers).

Table Relationships

The SITE table has a (Many) to (Zero or One) relationship with the ADDRESS table.

Mailing addresses for a site are stored in the ADDRESS table and are referenced by AddressID.
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

Legend

Field	Datatype (Length)	Allow Nulls	Indexes
SITEID (PK)	STANDARDID(12)	NOT NULL	SITE_SITEID_PK (CA)
ADDRESSID (FK)	STANDARDID(12)	NULLS
MAINPHONE	varchar(32)	NULLS
ALTERNATEPHONE	varchar(32)	NULLS
FAX	varchar(32)	NULLS
ATTENTION	varchar(64)	NULLS
COMMENTS	TEXTBLOB(16)	NULLS
SITECODE(FK)	varchar(10)	NULLS
DATAOWNER	varchar(64)	NULLS
CREATEUSER (FK)	STANDARDID(12)	NULLS
CREATEDATE	datetime(8)	NULLS
MODIFYUSER (FK)	STANDARDID(12)	NULLS
MODIFYDATE	datetime(8)	NULLS