Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
adjustment	LONG	tinyint				DIRECT	Type of value in the price field; i.e., 0=currency amount, 1=percent of parent from price_qty, 2=percent of child, 3 =Fixed amount, 4=Precentage, 5=Final amount
adjustment_string	CHAR	varchar		25			Translates price_type
currency_objid	LONG	int				DIRECT	Internal record number
currency_symbol	CHAR	varchar		5			Symbol for the currency; e.g., $ for US dollar
effective_date	CLK_TIME	datetime					Date the price instance becomes effective
expire_date	CLK_TIME	datetime					Last date the price instance is effective
is_reference	LONG	int				DIRECT	Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced
offr_price_is_shared	LONG	tinyint				DIRECT	Indicates that the indirect offr_price can be re-used across offerings. 1=shared, 0=not shared; default=0
offr_price_objid	LONG	int				DIRECT	Internal record number
price	DECIMAL	decimal (19,4)					Price for a given product
price_inst_objid	LONG	int	3			DIRECT	Internal record number
price_prog_name	CHAR	varchar		40			Name for the pricing program
price_prog_objid	LONG	int				DIRECT	Internal record number
price_type	LONG	int				DIRECT	Pricing type used to decide how to handle the charge. 1=One time charge on the Bill, 2=Immediate Charge, 3= Recurring Charge
price_type_description	CHAR	varchar		255			Marketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit'
price_type_objid	LONG	int				DIRECT	Internal record number
rate_description	CHAR	varchar		255			String value of price amount

SQL:

((
select table_price_inst.objid as price_inst_objid,
table_price_inst.price as price,
table_price_inst.effective_date as effective_date,
table_price_inst.expire_date as expire_date,
table_price_inst.rate_description as rate_description,
table_price_inst.is_reference as is_reference,
table_price_prog.objid as price_prog_objid,
table_price_prog.name as price_prog_name,
table_price_type.objid as price_type_objid,
table_price_type.type as price_type,
table_price_type.description as price_type_description,
table_price_inst.price_type as adjustment,
table_price_inst.type_string as adjustment_string,
table_offr_price.objid as offr_price_objid,
table_offr_price.is_shared as offr_price_is_shared,
table_currency.objid as currency_objid,
'' as currency_symbol
from table_price_inst , table_price_prog, table_price_type , table_offr_price, table_currency
where table_price_inst.price_type='4' AND
table_price_prog.objid=table_price_inst.price_inst2price_prog AND
table_price_type.objid=table_price_inst.price_inst2price_type AND
table_offr_price.objid=table_price_inst.price_inst2offr_price AND
table_currency.objid=table_price_prog.price_prog2currency
)union
(
select table_price_inst.objid as price_inst_objid,
table_price_inst.price as price,
table_price_inst.effective_date as effective_date,
table_price_inst.expire_date as expire_date,
table_price_inst.rate_description as rate_description,
table_price_inst.is_reference as is_reference,
table_price_prog.objid as price_prog_objid,
table_price_prog.name as price_prog_name,
table_price_type.objid as price_type_objid,
table_price_type.type as price_type,
table_price_type.description as price_type_description,
table_price_inst.price_type as adjustment,
table_price_inst.type_string as adjustment_string,
table_offr_price.objid as offr_price_objid,
table_offr_price.is_shared as offr_price_is_shared,
table_currency.objid as currency_objid,
table_currency.symbol as currency_symbol
from table_price_inst , table_price_prog, table_price_type , table_offr_price, table_currency
where table_price_inst.price_type !='4' AND
table_price_prog.objid=table_price_inst.price_inst2price_prog AND
table_price_type.objid=table_price_inst.price_inst2price_type AND
table_offr_price.objid=table_price_inst.price_inst2offr_price AND
table_currency.objid=table_price_prog.price_prog2currency
))