Oracle ATG Web Commerce uses the following table to store claimable information:
dcspp_claimable
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The repository id of the claimable repository item. | |
| INTEGER | NOT NULL |
Used by the repository to detect “out of date” updates. This information is managed internally by the Oracle ATG Web Commerce repositories. | ||
| INTEGER | NOT NULL |
Indicates whether a particular instance of a repository item is a coupon or a gift certificate. | ||
| INTEGER | NULL |
Indicates if a particular item has been claimed or not. | ||
| DATE | NULL |
If there is an expiration date, then an item cannot be claimed after this date. | ||
| DATETIME | NULL |
Indicates when the repository item was last changed. |
dcspp_giftcert
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the gift certificate. References | |
| DOUBLE PRECISION | NOT NULL |
The amount of the gift certificate. | ||
| DOUBLE PRECISION | NOT NULL |
The amount of the gift certificate authorized to be used at the time a purchase is made. | ||
| DOUBLE PRECISION | NOT NULL |
The amount of the gift certificate remaining after it has been used. Before the gift certificate has been claimed, this amount is equal to the amount property. | ||
| VARCHAR(40) | NULL |
The profile id of the person who purchased the gift certificate. | ||
| DATE | NULL |
The date on which the gift certificate is purchased | ||
| DATE | NULL |
The date on which the gift certificate was last used. |
dcs_storecred_clm
This table includes information on store credit.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | References | |
| DOUBLE PRECISION | NOT NULL |
Contains the original amount of the store credit | ||
| DOUBLE PRECISION | NOT NULL |
Contains the amount of the store credit authorized. | ||
| DOUBLE PRECISION | NOT NULL |
The amount of the store credit which has not been consumed yet. | ||
| VARCHAR(40) | NULL |
The profile id of the owner of this store credit. | ||
| DATETIME | NULL |
The date the store credit was issued. | ||
| DATETIME | NULL |
The date the store credit expires. Can be NULL. | ||
| DATETIME | NULL |
The date the store credit was last used. |
dcspp_coupon
This table relates coupons to one or more promotions.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the coupon. References | |
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the promotion. |
dcspp_coupon_info
This table is used for coupon validation.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the coupon. References | |
| VARCHAR(254) | NULL |
The name a user sees when viewing this coupon. | ||
| INT | NULL |
Boolean indicating whether or not the coupon validation process should check for site or site group associations. | ||
| VARCHAR(40) | NULL |
Parent folder for the coupon. References | ||
| INT | NULL |
Number of times the coupon has been claimed. |
dcspp_coupon_batch
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the coupon batch. | |
| VARCHAR(254) | NOT NULL |
| INT | NULL |
| ||
| LONG | NULL |
|
dcspp_batch_claimable
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the batch claimable. | |
| VARCHAR(254) | NULL |
dcspp_cp_folder
This table holds information about coupon folders.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the folder. | |
| VARCHAR(254) | NOT NULL |
The name a user sees when viewing this coupon. | ||
| VARCHAR(40) | NULL |
Parent folder for the coupon, if one is present. References |