Table Name:	csc_address
Table Number:	5115
Group:	Exchange Mgr
Description:	This object contains a specific address for an individual, or an organization
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_csc_address

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
address_type	LONG	smallint			0	DIRECT	Identifies the address type: i.e., 0=primay, 1=shipping, 2=billing, 3=service, 255=unknown. Default=0
city	CHAR	varchar		30			The city for the specified address
country	CHAR	varchar		40			Name of the specific country
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
geoaddress1	CHAR	varchar		200			First line of address
geoaddress2	CHAR	varchar		200			Second line of address
geoaddress3	CHAR	varchar		200			Third line of address
geoaddress4	CHAR	varchar		200			Fourth line of address
objid	LONG	int	3			DIRECT	Internal record number
postal_code	CHAR	varchar		20			The zip or other postal code for the specified address
region	CHAR	varchar		40			The region that the address belongs to
server_id	LONG	int				DIRECT	Exchange protocol server ID number
time_zone	CHAR	varchar		20			Time zone name

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
address2csc_country	MTO	csc_country	country2csc_address	Related CSC country
address2csc_location	OTM	csc_location	location2csc_address	Additional information
csc_address2csc_org	OTOF	csc_org	csc_org2csc_address	Related CSC organization
csc_address2csc_person	OTOF	csc_person	csc_person2csc_address	Related CSC person
address2csc_state_prov	MTO	csc_state_prov	state_prov2csc_address	Related CSC organization
address2csc_tzone	MTO	csc_tzone	time2csc_address	Time zone where CSC address is located

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_csc_address_city	city, region	nonclustered located on PRIMARY
ind_csc_address_region	region	nonclustered located on PRIMARY
ind_csc_address2csc_country	address2csc_country	nonclustered located on PRIMARY
ind_csc_address2csc_state_prov	address2csc_state_prov	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

csc_address

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user