Table Name:	offr_prod
Table Number:	5761
Group:	Morder
Description:	The tariff plans, handsets, accessories and options included in an offering
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_offr_prod

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
description	CHAR	varchar		255				Search (7)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
is_mandatory	LONG	tinyint			0	DIRECT	Whether product is mandatory in the group; 1=Yes, 0=No;default=0	Search (4)
last_update	CLK_TIME	datetime	46				Date time of last update
max_number	LONG	int			1	DIRECT	Maximum number of product/option that must be taken up in the offering. Default=1	Search (5)
min_number	LONG	int			1	DIRECT	Minimum number of product/option that must be taken up in the offering. Default=1	Search (5)
objid	LONG	int	3			DIRECT	Internal record number	Search (15)
reference	LONG	int			0	DIRECT	An internal line reference to be used by external systems to identify the specific offr_prd row. Required as a product may appear many times in an offering

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
offr_prod2offering_grp	MTO	offering_grp	offering_grp2offr_prod	An offering group of an offered product			Search (6)
offr_prod2offr_price	MTM	offr_price	offr_price2offr_prod	Offering prices for this product in an offering. Replaced by role table. Reserved, obsolete		mtm_offr_prod2_ offr_price0
offr_prod2offr_price_role	OTM	offr_price_role	offr_price_role2offr_prod	The pricings for the offering product
option2offr_prod	MTO	offr_prod	product2offr_prod	Offering product that is the parent for the option			Search (6)
product2offr_prod	OTM	offr_prod	option2offr_prod	Offering product s that are options for this offering product
offr_prod2order_line	OTM	order_line	order_line2offr_prod	Order lines of the offering product
offr_prod2price_qty	MTO	price_qty	price_qty2offr_prod	Pricing for an offered product			Search (11)
offr_prod2site_part	OTM	site_part	site_part2offr_prod	Installed parts from this offering product

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
op2og5761	offr_prod2offering_grp	nonclustered located on PRIMARY
op2pq5761	offr_prod2price_qty	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5790	offr_price_v	fr_agrmnt, offr_price, offr_prod, price_inst, price_prog, price_type
5791	offr_prod_v	mod_level, offering, offering_grp, offr_prod, part_num, price_qty
5792	offr_prod_price_v	currency, mod_level, offr_prod, part_num, price_inst, price_prog, price_qty, price_type
5807	order_line_v	contract, mod_level, offr_prod, order_action, order_line, price_qty
5811	offr_price_name_v	offering, offr_price, offr_prod
5834	agr_price_name_v	fr_agrmnt, offr_price, offr_prod
5856	order_line_parts_v	contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
5993	offr_prod_view	mod_level, offering, offering_grp, offr_grp_role, offr_prod, part_num, price_qty
5996	offr_price_name_view	offr_price, offr_price_role, offr_prod
6010	cmn_grp_ofr_prd_view	mod_level, offering_grp, offr_grp_grp_role, offr_prod, part_num, price_qty
6011	cmn_ofr_prd_view	mod_level, offering_grp, offr_prod, part_num, price_qty
6032	order_line_view	contract, mod_level, offr_prod, order_action, order_line, part_num, price_qty
6034	agr_price_name_view	fr_agrmnt, offr_price, offr_price_role, offr_prod
6035	agr_offr_price_view	fr_agrmnt, offr_price, offr_price_role, offr_prod, price_inst, price_prog, price_type
6041	offr_price_view	offr_price, offr_price_role, offr_prod, price_inst, price_prog, price_type

My Recent Objects

offr_prod

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user