Table Name:	lit_ship_req
Table Number:	5311
Group:	Sales Mgr
Description:	Contains shipping information for a particular recipient of a literature request
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_lit_ship_req

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
address	CHAR	varchar		200			Line 1 of address which includes street number, street name, office, building, or suite number, etc
address_2	CHAR	varchar		200			Line 2 of address which typically includes office, building, or suite number, etc
city	CHAR	varchar		30			The city for the specified address
country	CHAR	varchar		40			Country of the address
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
e_mail	CHAR	varchar		80			Recipient's email address
fax	CHAR	varchar		20			Recipient's fax number
first_name	CHAR	varchar		30			First name of the recipient
last_name	CHAR	varchar		30			Last name of the recipient
mail_stop	CHAR	varchar		30			Recipient's internal company mail stop/location/building
objid	LONG	int	3			DIRECT	Internal record number
phone	CHAR	varchar		20			Recipient's phone number
postal_code	CHAR	varchar		20			The zip or other postal code for the specified address
state	CHAR	varchar		40			The state for the specified address

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
lit_ship_req2bus_org	MTO	bus_org	bus_org2lit_ship_req	Related account
lit_ship2contact_role	MTO	contact_role	con_role2lit_ship_req	Contact role for the shipment
lit_ship_req2doc_inst	OTM	doc_inst	doc_inst2lit_ship_req	Soft copies of the documents that were shipped
lit_ship_req2lead	MTO	lead	lead2lit_ship_req	Lead recipient
lit_ship_req2lit_req	MTO	lit_req	lit_req2lit_ship_req	Related template header
lit_ship2opportunity	MTO	opportunity	opp2lit_ship_req	Related opportunity

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
lit_itm_ind	last_name:first_name:phone:lit_ship_req2lit_req:lit_ship_req2lead:lit_ship2contact_role	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_address	address	nonclustered located on PRIMARY
ind_address_2	address_2	nonclustered located on PRIMARY
ind_city	city	nonclustered located on PRIMARY
ind_last_name	last_name, first_name	nonclustered located on PRIMARY
ind_lit_ship_req2lead	lit_ship_req2lead	nonclustered located on PRIMARY
ind_lit_ship_req2lit_req	lit_ship_req2lit_req	nonclustered located on PRIMARY
ind_lit_ship2contact_role	lit_ship2contact_role	nonclustered located on PRIMARY
ind_lit_ship2opportunity	lit_ship2opportunity	nonclustered located on PRIMARY
lit_itm_ind	last_name, first_name, phone, lit_ship_req2lit_req, lit_ship_req2lead, lit_ship2contact_role	nonclustered, unique located on PRIMARY
lsr2bo5311	lit_ship_req2bus_org	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

lit_ship_req

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user