| Table Name: | offering |
| Table Number: | 5759 |
| Group: | Morder |
| Description: | A group of tariff plans, handsets, accessories and options that are marketed as a offer to customers |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| description | CHAR | varchar | 255 | Marketing text used to describe offering presented to the customer. Typically used as help to the agent or presented to the customer. | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| effective_dt | CLK_TIME | datetime | Effective date of offering | Search (3) | ||||
| expiry_dt | CLK_TIME | datetime | Expiry date of offering | Search (4) | ||||
| id | CHAR | varchar | 40 | Populated from the numbering scheme | Search (5) | |||
| is_final | LONG | tinyint | 0 | DIRECT, ALLOW_NULL | Indicates whether the offering is final or can be edited; 1=Yes, 0=No;Default= 0) | Search (1) | ||
| last_update | CLK_TIME | datetime | 46 | Date time of last update | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (10) | ||
| status | CHAR | varchar | 40 | User defined status. Populated through a user defined popup list | Search (4) | |||
| title | CHAR | varchar | 80 | Name of an offering | Search (5) | |||
| type | CHAR | varchar | 40 | User defined type. Populated through a user defined popup list | ||||
| version | LONG | int | DIRECT, ALLOW_NULL | The version of the offering, starting at 1 | Search (4) |
| 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 | ||||||||||
| offering2doc_inst | OTM | doc_inst | doc_inst2offering | Attachments to the offering | ||||||
| offering2elgblty_set | OTOF | elgblty_set | elgblty_set2offering | Eligibility rules controlling who can be offered the offering | eligibility_for | focus_type | focus_lowid | |||
| offering2fr_agr_term | OTM | fr_agr_term | fr_agr_term2offering | Terms for the offering | ||||||
| offering2mod_level | MTO | mod_level | mod_level2offering | Top level part to be installed and act as parent to services ordered for an offering | ||||||
| bus_offering2mod_level | MTO | mod_level | bus_mod_level2offering | For any account level products order from the offering the top level part to be installed | ||||||
| offering2offering_grp | OTM | offering_grp | offering_grp2offering | Products and options included in the offering. Replaced by role table Reserved, obsolete | ||||||
| offering2offr_grp_role | OTM | offr_grp_role | offr_grp_role2offering | Products and options included in the offering | ||||||
| offering2offr_price | MTM | offr_price | offr_price2offering | Indicates whether this shareable offr_price is defined for the offering rather than the framework agreement context. Reserved, obsolete | mtm_offering8_ offr_price4 | |||||
| offering2order_action | OTM | order_action | order_action2offering | Order actions using this offering | ||||||
| offering2proc_inst | MTM | proc_inst | proc_inst2offering | Process/script run for an offering | mtm_offering10_ proc_inst9 | |||||
| offering2process | MTM | process | process2offering | Process/script for an offering | mtm_offering9_ process7 | |||||
| offering2site_part | OTM | site_part | site_part2offering | Installed parts originated from the offering | ||||||
| offering2user | MTO | user | user2offering | Current owner of the offering | Search (4) | |||||
| Index Name | Fields | Flags |
|---|---|---|
| I5759_1 | id:version | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5759_1 | id, version | nonclustered, unique located on PRIMARY |
| o2u5759 | offering2user | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| offering | |||