Table Name:	order_line_price
Table Number:	5771
Group:	Morder
Description:	Pricing for the Order line
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_order_line_price

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
amount	DECIMAL	decimal (19,4)				CURRENCY	Calculated amount from offering
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
last_update	CLK_TIME	datetime	46				Date time of last update
objid	LONG	int	3			DIRECT	Internal record number
rate_description	CHAR	varchar		255			Rate description copied from price_inst
tax_amount	DECIMAL	decimal (19,4)				CURRENCY	Tax amount

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
order_line_price2order_line	MTO	order_line	order_line2order_line_price	Order_line that price applied to
order_line_price2price_type	MTO	price_type	price_type2order_line_price	Type of pricing - recurring, immediate etc.

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
olp2ol5771	order_line_price2order_line	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

order_line_price

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user