claimable_id
(primary key)

varchar(40)

not null

The repository id of the claimable repository item.

version

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.

type

integer

not null

Indicates whether a particular instance of a repository item is a coupon or a gift certificate.

status

integer

null

Indicates if a particular item has been claimed or not.

expiration_date

date

null

If there is an expiration date, then an item cannot be claimed after this date.

last_modified

datetime

null

Indicates when the repository item was last changed.

giftcertificate_id
(primary key)

varchar (40)

not null

The unique identifier associated with the gift certificate. References dcspp_claimable
(claimable_id).

amount

double precision

not null

The amount of the gift certificate.

amount_authorized

double precision

not null

The amount of the gift certificate authorized to be used at the time a purchase is made.

amount_remaining

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.

purchaser_id

varchar (40)

null

The profile ID of the person who purchased the gift certificate.

purchase_date

date

null

The date on which the gift certificate is purchased.

last_used

date

null

The date on which the gift certificate was last used.

store_credit_id
(primary key)

varchar (40)

not null

References dcspp_claimable
(claimable_id).

amount

double precision

not null

Contains the original amount of the store credit.

amount_authorized

double precision

not null

Contains the amount of the store credit authorized.

amount_remaining

double precision

not null

The amount of the store credit which has not been consumed yet.

owner_id

varchar (40)

null

The profile id of the owner of this store credit.

issue_date

datetime

null

The date the store credit was issued.

expiration_date

datetime

null

The date the store credit expires. Can be NULL.

last_used

datetime

null

The date the store credit was last used.

coupon_id
(primary key)

varchar (40)

not null

The unique identifier associated with the coupon. References dcspp_claimable(claimable_id).

promotion_id
(primary key)

varchar (40)

not null

The unique identifier associated with the promotion.

coupon_id
(primary key)

varchar (40)

not null

The unique identifier associated with the coupon. References dcspp_claimable
(claimable_id).

display_name

varchar (254)

null

The name a user sees when viewing this coupon.

use_promo_site

integer

null

Boolean indicating whether or not the coupon validation process should check for site or site group associations.

parent_folder

varchar (40)

null

Parent folder for the coupon. References dcspp_cp_folder(folder_id).

uses

integer

null

Number of times the coupon has been claimed.

id
(primary key)

varchar (40)

not null

The unique identifier associated with the coupon batch.

code_prefix

varchar (254)

not null

number_of_coupons

integer

null

seed_value

long varchar

null

coupon_id
(primary key)

varchar (40)

not null

The unique identifier associated with the batch claimable.

coupon_batch

varchar (254)

null

folder_id
(primary key)

varchar (40)

not null

The unique identifier associated with the folder.

name

varchar (254)

not null

The name a user sees when viewing this coupon.

parent_folder

varchar (40)

null

Parent folder for the coupon, if one is present. References dcspp_cp_folder(folder_id).