| View Name: | offr_prod_price_v |
| View Number: | 5792 |
| Group: | Morder |
| Description: | Lists the prices of products belonging to a certain offer (Screen ID 122023) May later become a FAKE view joining the products base prices with the prices given to them as part of the offer. Used in offering_pricing.jsp page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| child_mod_level_objid | child_mod_level(mod_level) | objid | Child mod_level internal record number | |
| currency_objid | currency | objid | Currency internal record number | |
| effective_date | price_inst | effective_date | Date the price instance becomes effective | |
| expire_date | price_inst | expire_date | Last date the price instance is effective | |
| is_reference | price_inst | is_reference | Indicates that this price is referenced from another system an cannot be edited. 1=referenced, 0=not referenced | |
| max_number | offr_prod | max_number | Maximum number of product / option that must be taken up in the offering. Default=1 | |
| min_number | offr_prod | min_number | Minimum number of product / option that must be taken up in the offering. Default=1 | |
| objid | price_inst | objid | Price instance internal record number | 3 (UNIQUE) |
| offr_prod_objid | offr_prod | objid | Offering product internal record number | |
| par_mod_level_objid | parent_mod_level(mod_level) | objid | Parent mod_level internal record number | |
| part_num_objid | part_num | objid | Part internal record number | |
| part_number | part_num | part_number | Part number/name | |
| price | price_inst | price | Price for a given product | |
| price_prog_name | price_prog | name | Name for the pricing program | |
| price_qty_objid | price_qty | objid | Price_qty internal record number | |
| price_type_name | price_type | description | Marketing text to be used to present the pricing to the user or customer e.g. 'Connection Fee', 'Monthly Line Rental', 'Deposit' | |
| rate_description | price_inst | rate_description | String value of price amount |
Join From | Join To |
|---|---|
| (offr_prod).offr_prod2price_qty | (price_qty).price_qty2offr_prod |
| (price_qty).priced_part2mod_level | child_mod_level(mod_level).priced_part2price_qty |
| (price_qty).context_part2mod_level | parent_mod_level(mod_level).context_part2price_qty |
| child_mod_level(mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (price_inst).price_inst2price_qty | (price_qty).price_qty2price_inst |
| (price_inst).price_inst2price_prog | (price_prog).price_prog2price_inst |
| (price_inst).price_inst2price_type | (price_type).price_type2price_inst |
| (price_prog).price_prog2currency | (currency).currency2price_prog |
| offr_prod_price_v | |||