Table Name:	quick_quote
Table Number:	5083
Group:	Sales Mgr
Description:	A quote which contains minimum information; reserved obsolete, replaced by contract (86)
Flags:
Baseline/Custom:	Baseline

select * from table_quick_quote

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bill_addr1	CHAR	varchar		200			Line one of street address for billing
bill_addr2	CHAR	varchar		200			Line two of street address for billing
bill_city	CHAR	varchar		30			City for billing address
bill_country	CHAR	varchar		40			Country of the billing address
bill_state	CHAR	varchar		30			State for billing address
bill_to_attn	CHAR	varchar		50			Name of person to whom billing will be directed
bill_zip	CHAR	varchar		20			Zip or postal code for billing address
comments	CHAR	text	23			ALLOW_NULL	The multi-line field that contains the comments to be written to the quote
create_date	CLK_TIME	datetime					The create date of the quote
description	CHAR	varchar		255			Description of the quote
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
discount_amt	FLOAT	real				CURRENCY	Discount amount on the quote
discount_pct	FLOAT	real					Percentage discount on the quote
expire_date	CLK_TIME	datetime					The expiration date of the quote
fob	CHAR	varchar		30			Identifies the FOB for the quick quote
freight_amt	FLOAT	real				CURRENCY	Discount amount on the quote
id	CHAR	varchar	4	30			Quote ID number	Search (1)
issue_date	CLK_TIME	datetime					The issue date of the quote
objid	LONG	int	3			DIRECT	Internal record number
pay_terms	CHAR	varchar		40			Payment terms; e.g., COD, FOD, installments
po_number	CHAR	varchar		30			The purchase order for the request
request_date	CLK_TIME	datetime					The date the quote was requested
ship_addr1	CHAR	varchar		200			Line one of street address for shiping
ship_addr2	CHAR	varchar		200			Line two of street address for shiping
ship_city	CHAR	varchar		30			City for shiping address
ship_country	CHAR	varchar		40			Country of the shiping address
ship_state	CHAR	varchar		30			State for shiping address
ship_to_attn	CHAR	varchar		50			Name of person to whom shipment will be directed
ship_via	CHAR	varchar		80			Requested means of shipment. This is from a Clarify-defined popup list
ship_zip	CHAR	varchar		20			Zip or postal code for shiping address
status	CHAR	varchar		30			Status of the quote. This is from an user-defined popup list
tax_amt	FLOAT	real				CURRENCY	Total tax amount
tax_pct	FLOAT	real					Tax percentage
total_amt	FLOAT	real				CURRENCY	Total currency amount of the quote

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
q_quote2contact	MTO	contact	contact2quick_quote	Contact for the quote	Search (1)
q_quote2notes_log	OTM	notes_log	qq_notes2quick_quote	Notes for the quote
q_quote2opportunity	MTO	opportunity	opp2quick_quote	Opportunity for which the quote was made
q_quote2price_prog	MTO	price_prog	price_prog2quick_quote	Price schedule used for the quote
q_quote2purchase_ord	OTM	purchase_ord	payment2quick_quote	Payment means for the quick quote. Reserved
q_quote2qq_comment	OTM	qq_comment	comment2quick_quote	Comments appearing on the quote
q_quote2qq_line_item	OTM	qq_line_item	q_item2quick_quote	Line item on the quote
q_quote2site	MTO	site	site2quick_quote	Related site
qq_editor2user	MTO	user	editor2quick_quote	User currently editing the quote

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
q_quote_ind	id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
q_quote_ind	id	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5074	qq_con_site	contact, contact_role, quick_quote, site

My Recent Objects

quick_quote

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog