ATC_OFFER_RECOMMEND_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_RECOMMEND_RULES_PK |
OFFER_RECOMMEND_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OFFER_RECOMMEND_RULE_ID | NUMBER | 18 | Yes | Unique row id | |
| AT_TYPE | VARCHAR2 | 200 | Represent the actual class type of an entity | ||
| VALUE_TYPE_CODE | VARCHAR2 | 200 | Indicates the type of the subjectProduct used in the rule like SPEC,OFFER etc. | ||
| AT_BASE_TYPE | VARCHAR2 | 200 | Represent the base class of a given resource that has been extended | ||
| EARLY_TERM_PENALTY | NUMBER | The amount, in currency, to charge if the customer terminates the promotion before the specified end date. | |||
| AT_SCHEMA_LOCATION | VARCHAR2 | 1000 | Indicates a url which points to a schema which allow specifying user-defined properties of an Entity or to specify the expected characteristics of an entity | ||
| COMMITMENT_START_CODE | 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_CODE | 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. | ||
| OFFER_RECOMMEND_RULE_NAME | VARCHAR2 | 200 | Yes | Identifier of the recommendation rule | |
| SUBJECT_PRODUCT | VARCHAR2 | 200 | Subject offer component of the recommendation rule | ||
| OBJECT_PRODUCT | VARCHAR2 | 200 | Object offer component of the recommendation rule | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | A flag indicating if this recommendation Rule is active or not | ||
| REASON | VARCHAR2 | 1000 | The message is used by customer service representatives to tell customers the reason that they should purchase the upsell or cross-sell product. | ||
| START_DATE_TIME | TIMESTAMP | Start time from which the rule is valid | |||
| END_DATE_TIME | TIMESTAMP | End Time to which the rule is valid | |||
| RULE_SCORE | NUMBER | Indicates rule score | |||
| MESSAGE_TYPE_CODE | VARCHAR2 | 200 | Indicates message type | ||
| ENTITY_ID | NUMBER | 18 | Yes | Indicates the entity to which the rule is associated to | |
| ENTITY_NAME | VARCHAR2 | 100 | Yes | Indicates the entity name to which the rule is associated to | |
| 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_recommend_rules_N1 | Non Unique | Default | ENTITY_ID |
| atc_offer_recommend_rules_N2 | Non Unique | Default | ENTITY_NAME |
| atc_offer_recommend_rules_PK | Unique | Default | OFFER_RECOMMEND_RULE_ID |
| atc_offer_recommend_rules_U1 | Unique | Default | OFFER_RECOMMEND_RULE_NAME, ENTITY_ID |