| Table Name: | offr_price |
| Table Number: | 5762 |
| Group: | Morder |
| Description: | Offering price for an offer. It links price (price_inst) to a product for an offer |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| is_apply_to_offering_price | LONG | tinyint | 0 | DIRECT | Indicator used to specify that the pricing adjustment should be applied to the offering direct price or base product price. 1=Yes (apply on direct price), 0=No (apply on base product price); Default = 0 | |||
| is_direct | LONG | tinyint | 0 | DIRECT | Does this offer pricing use an eligibility set to decide which products the offer pricing applies to or does it apply directly to the related offer_product. 1=direct, 0=indirect; default=0 | Search (7) | ||
| is_shared | LONG | tinyint | 0 | DIRECT | Indicates that the indirect offr_price can be re-used across offerings. 1=shared, 0=not shared; default=0 | Search (5) | ||
| last_update | CLK_TIME | datetime | 46 | Date time of last update | ||||
| name | CHAR | varchar | 80 | Reference name of offering pricing. Typically used for shared indirect pricing | Search (7) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (9) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| offr_price2elgblty_set | OTOF | elgblty_set | elgblty_set2offr_price | Eligbility to define which product the offer pricing should be applied to an amount | eligibility_for | focus_type | focus_lowid | |||
| offr_price2fr_agrmnt | MTM | fr_agrmnt | fr_agrmnt2offr_price | Framework agreement using this price | mtm_offr_price2_ fr_agrmnt3 | |||||
| offr_price2offering | MTM | offering | offering2offr_price | Indicates whether this shareable offr_price is defined for the offering rather than the framework agreement context. Reserved, obsolete | mtm_offering8_ offr_price4 | Search (1) | ||||
| offr_price2offer_price_role | OTM | offr_price_role | offr_price_role2offr_price | Price for an offering product | ||||||
| offr_price2offr_prod | MTM | offr_prod | offr_prod2offr_price | Various offering prices of a product with in an offer. Replaced by role table. Reserved, obsolete | mtm_offr_prod2_ offr_price0 | Search (3) | ||||
| offr_price2price_inst | OTM | price_inst | price_inst2offr_price | Currency price amount for offer pricing or percentage amount | ||||||
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| offr_price | |||