This table holds information about product promotions.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| varchar | 40 | No | Natural key of promotion. |
| varchar | 254 | No | Promotion name in the default language. |
| varchar | 254 | Yes | Promotion name in English. |
| varchar | 254 | Yes | Promotion description in the default language. |
| varchar | 254 | Yes | Promotion description in English. |
| varchar | 254 | Yes | Promotion type that appears in the promotion’s item descriptor, such as “Item Discount – Amount Off.” |
| numeric or tinyint | 1 | Yes | Indicates that this promotion is enabled. 0 = No 1 = Yes |
| timestamp | Yes | Date on which the promotion can be used. | |
| timestamp | Yes | Date on which the promotion is no longer usable. | |
| numeric or tinyint | 1 | Yes | Indicates that this promotion is global. 0 = No 1 = Yes |
| timestamp | Yes | Date the record was last updated. | |
| timestamp | Yes | Date when the information in this warehouse record became effective. | |
| timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
| one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
| one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |