Table Name:	qq_line_item
Table Number:	5084
Group:	Sales Mgr
Description:	Line item for a quick quote; reserved obsolete, replaced by contr_itm (142)
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_qq_line_item

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
actual_price	FLOAT	real				CURRENCY	Quoted price of the product
comments	CHAR	varchar		255			Comments about the line item
cost	FLOAT	real				CURRENCY	Standard cost of the product
description	CHAR	varchar		255			Description of the product from the part number
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
extension	FLOAT	real				CURRENCY	The extended price of the item before price factors were applied. It is determined by quantity * actual price
line_no	LONG	smallint				DIRECT	Line number of the line item
list_price	FLOAT	real				CURRENCY	List price of the line item from the price program
objid	LONG	int	3			DIRECT	Internal record number
part_number	CHAR	varchar		30			Part number of the quoted part
quantity	LONG	int				DIRECT	Quantity quoted
revision	CHAR	varchar		10			Revision number (mod_level) of the quoted part
tax_ind	LONG	int				DIRECT	Quantity quoted
taxable	LONG	tinyint				DIRECT	Indicates whether the item is taxable; i.e., 0=no, 1=yes

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
q_item2mod_level	MTO	mod_level	part2qq_line_item	Quoted part revisions
q_item2quick_quote	MTO	quick_quote	q_quote2qq_line_item	Relate quote header

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
q_line_ind	q_item2quick_quote:line_no	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
q_line_ind	q_item2quick_quote, line_no	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

qq_line_item

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user