This table stores information about the coupons configured in Oracle ATG Web Commerce.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| int | No | The identifier of the coupon | |
| varchar | 40 | No | The natural identifier of the coupon |
| varchar | 254 | No | The name assigned to the coupon |
| varchar | 254 | Yes | The name assigned to the coupon in English |
| timestamp | Yes | The time and date at which the coupon became usable | |
| timestamp | Yes | The time and date at which the coupon was no longer usable | |
| one-digit | No | A boolean value that indicates whether the coupon is serialized 0 = false 1 = true | |
| int | No | If the coupon is serialized, the number of instances that are in the batch | |
| timestamp | Yes | The time and date at which this data warehouse record was last updated | |
| timestamp | Yes | The time and date at which this data warehouse record was created | |
| timestamp | Yes | The time and date at which this data warehouse record was marked for deletion | |
| one-digit | No | A boolean value that indicates whether this record holds the most recent information about the coupon. 0 = false 1 = true | |
| one-digit | No | A boolean value that indicates whether the coupon has been deleted 0 = false 1 = true |