ATC_OFFER_UPDOWNGRADE_RULES
Stores details of product offer recommendation rules
Details
-
Schema: FUSION
-
Object owner: ATC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ATC_OFFER_UPDOWNGRADE_RULES_PK |
OFFER_UPDOWNGRADE_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OFFER_UPDOWNGRADE_RULE_ID | NUMBER | 18 | Yes | Unique row id | |
| OFFER_UPDOWNGRADE_RULE_NAME | VARCHAR2 | 200 | Yes | Identifier of the upgrade/downgrade rule | |
| UPGRADE_TYPE_CODE | VARCHAR2 | 200 | When Upgrade From is selected Original Promotion is populated with offers from which customers can upgrade (or downgrade) to the current promotion When Upgrade to is selected, Target Promotion is populated with offers to which customers can upgrade (or downgrade) to. | ||
| OFFER | VARCHAR2 | 200 | Valid offers that customer can upgrade from or upgrade to. | ||
| COMMITMENT_START | VARCHAR2 | 200 | For Original Start, Starts on the date of the original promotion. For Now, Starts today. For Original End, Starts on the end date of the original promotion | ||
| DURATION | VARCHAR2 | 200 | For Original Duration, Uses the duration fields that are defined for the original promotion, that is, the promotion from which it is upgraded. For New Duration, Uses the duration fields that are defined for the new promotion, that is, the promotion to which it is upgraded. | ||
| PENALTY | NUMBER | The amount, in currency, to charge if the customer terminates the promotion before the specified end date. | |||
| ACTIVE_FLAG | VARCHAR2 | 1 | A flag indicating if this recommendation Rule is active or not | ||
| ENTITY_ID | NUMBER | 18 | Yes | Indicates the product offer to which the rule is associated to | |
| ENTITY_NAME | VARCHAR2 | 100 | Yes | Indicates the entity name to which the rule is associated to | |
| START_DATE_TIME | TIMESTAMP | Start time from which the rule is valid | |||
| END_DATE_TIME | TIMESTAMP | End Time to which the rule is valid | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| atc_offer_updowngrade_rules_N1 | Non Unique | Default | ENTITY_ID |
| atc_offer_updowngrade_rules_N2 | Non Unique | Default | ENTITY_NAME |
| atc_offer_updowngrade_rules_PK | Unique | Default | OFFER_UPDOWNGRADE_RULE_ID |
| atc_offer_updowngrade_rules_U1 | Unique | Default | OFFER_UPDOWNGRADE_RULE_NAME, ENTITY_ID |