ATG 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 ATG 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. |
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. | ||
| TIMESTAMP | NULL |
The date the store credit was issued. | ||
| TIMESTAMP | NULL |
The date the store credit expires. Can be NULL. | ||
| TIMESTAMP | NULL |
The date the store credit was last used. |
dcspp_coupon
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(40) | NOT NULL |
(primary key) | The unique identifier associated with the coupon. References | |
| VARCHAR(40) | NOT NULL |
The unique identifier associated with the promotion. |