ATG Commerce uses the following tables to store information about promotions:
dcs_promotion
This table contains information about promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE |
(primary key) | The unique identifier associated with the promotion. | |
| INT | NOT NULL |
The version of the promotion. ATG Commerce uses this value to allow several people to edit the same promotion at the same time. | ||
| DATE | NULL |
The date the promotion was created. | ||
| DATE | NULL |
The date on which the promotion will become available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database. | ||
| DATE | NULL |
The last date on which the promotion will be available. This is an optional field that can be used by the SQL Repository as part of an RQL filter to prevent items from being loaded from the database. | ||
| VARCHAR(254) | NULL |
The name of the promotion that is displayed in the ACC. | ||
| VARCHAR(254) | NULL |
A text description of the promotion. | ||
| INT | NULL |
Indicates the type of promotion. | ||
| NUMERIC(1) | NULL CHECK |
Determines whether or not the promotion is valid. | ||
| DATE | NULL |
The date ATG Commerce will begin using this promotion. | ||
| DATE | NULL |
The date ATG Commerce will stop using this promotion. | ||
| INT | NULL |
The order in which the promotion should be applied. Low priority takes precedence. | ||
| NUMERIC(1) | NULL CHECK |
Determines whether this promotion is global. | ||
| NUMERIC(1) | NULL CHECK |
Determines whether the promotion should be given to users with anonymous profiles. | ||
| NUMERIC(1) | NULL CHECK |
Determines whether a user can receive more than one copy of the promotion. | ||
| INT | NULL |
Determines how many times the promotion can be used by a single customer. | ||
| NUMERIC(1) | NULL CHECK |
| integer | NULL |
The time left until the promotion expires. |
dcs_promo_media
This table contains information about media used in promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier of the promotion to which this belongs. References | |
| VARCHAR(42) | NOT NULL |
(primary key) | The identifier for the promotion instruction. | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with this media item. References |
dcs_discount_promo
This table contains information about promotion discounts. ATG Commerce uses this information to deduct the correct amount from a user’s order, based on the rules of the promotion.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE | |
(primary key) | The unique identifier associated with the promotion. References | ||
| VARCHAR(254) | NOT NULL | |
The ATG Commerce calculator that interprets the promotion and applies the discount. | |||
| DOUBLE PRECISION | NOT NULL | |
The number by which the promotion discounts. For example, the percent off the purchase. | |||
| LONG VARCHAR | NOT NULL | |
The promotion rule that specifies under what conditions the promotion applies. | |||
| NUMERIC (1, 0) | DEFAULT NULL | |
Determines whether a promotion can be used more than once for a given user. |
dcs_promo_upsell
This table contains information about upsell promotions. ATG Commerce uses this information to determine if the upsell feature is enabled in a promotion.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the promotion. References | |
| NUMERIC (1,0) | DEFAULT NULL |
Determines whether upselling is enabled for a promotion. |
dcs_upsell_action
This table contains information about dynamic products used in Upsell Actions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the Upsell Action. | |
| integer | NOT NULL |
Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the ATG framework, you should also increment the version number. | ||
| VARCHAR(40) | NOT NULL |
The name of the Upsell Action. | ||
| LONG VARCHAR | DEFAULT NULL |
The content group associated with an Upsell Action. |
dcs_close_qualif
This table contains information about Closeness Qualifiers.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | |
(primary key) | The ID of the Closeness Qualifier. | ||
| integer | NOT NULL | |
Manages the optimistic locking feature of the SQL Repository. This value is automatically incremented by the SQL Repository when any value of the item is modified. If you change rows directly outside of the ATG framework, you should also increment the version number. | |||
| VARCHAR(40) | NOT NULL | |
The name of the Closeness Qualifier. | |||
| integer | DEFAULT NULL | |
The priority given to a Closeness Qualifier in the context of a promotion. Closeness Qualifiers are evaluated in the order specified by their priority. | |||
| LONG VARCHAR | DEFAULT NULL | |
The PMDL rule that describes under which circumstances the Closeness Qualifier applies. | |||
| VARCHAR(40) | DEFAULT NULL | |
The media item associated with the Closeness Qualifier. | |||
| VARCHAR(40) | DEFAULT NULL | |
The Upsell Action assigned to the Closeness Qualifier. |
dcs_prm_cls_qlf
This table associates Closeness Qualifiers with promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the promotion. References | |
| NUMERIC (1,0) | NOT NULL |
The unique identifier associated with the Closeness Qualifier. References |
dcs_upsell_prods
This table associates fixed products with Upsell Actions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the Upsell Action. References | |
| VARCHAR(40) | NOT NULL |
The ID of a product associated with the Upsell Action. | ||
| integer | NOT NULL |
Used to order rows in this table. |
dcs_prom_used_evt
This table contains information about Uses Promotion events.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE | |
(primary key) | The ID of the event. | ||
| TIMESTAMP | NULL | |
The date and time that the event was sent. | |||
| VARCHAR(40) | NULL | |
The ID of the order for which the promotion was used. | |||
| VARCHAR(40) | NULL | |
The ID of the promotion that was used. | |||
| NUMERIC(26,7) | NULL | |
The amount of the order for which the promotion was used. | |||
| NUMERIC(26,7) | NULL | |
The amount discounted as a result of the promotion that was used. | |||
| VARCHAR(40) | NULL | |
The profile ID of the user associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The current session ID associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application. |
dcs_promo_rvkd
This table contains information about Promotion Revoked events.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE | |
(primary key) | The ID of the event. | ||
| TIMESTAMP | NULL | |
The date and time that the event was sent. | |||
| VARCHAR(254) | NOT NULL | |
The ID of the promotion that was revoked. | |||
| VARCHAR(254) | NOT NULL | |
The profile ID of the user associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The current session ID associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application. |
dcs_promo_grntd
This table contains information about Promotion Offered events.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL UNIQUE | |
(primary key) | The ID of the event. | ||
| TIMESTAMP | NULL | |
The date and time that the event was sent. | |||
| VARCHAR(254) | NOT NULL | |
The ID of the promotion that was offered. | |||
| VARCHAR(254) | NOT NULL | |
The profile ID of the user associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The current session ID associated with the request when this message is sent in the context of an HTTP request. | |||
| VARCHAR(100) | NULL | |
The parent session ID. This ID may be different from the request’s current session ID on application servers that use a separate session ID for each Web application. |