ID

smallint

No

Identifier; primary key.

NPROMO_ID

varchar

40

No

Natural key of promotion.

PROMO_NAME

varchar

254

No

Promotion name in the default language.

PROMO_NAME_EN

varchar

254

Yes

Promotion name in English.

PROMO_DESC

varchar

254

Yes

Promotion description in the default language.

PROMO_DESC_EN

varchar

254

Yes

Promotion description in English.

PROMO_TYPE

varchar

254

Yes

Promotion type that appears in the promotion’s item descriptor, such as “Item Discount – Amount Off.”

PROMO_ENABLED

numeric or tinyint

1

Yes

Indicates that this promotion is enabled.

0 = No

1 = Yes

PROMO_BEGIN_USABLE

timestamp

Yes

Date on which the promotion can be used.

PROMO_END_USABLE

timestamp

Yes

Date on which the promotion is no longer usable.

PROMO_GLOBAL

numeric or tinyint

1

Yes

Indicates that this promotion is global.

0 = No

1 = Yes

RECORD_LAST_UPDATE

timestamp

Yes

Date the record was last updated.

RECORD_START_DATE

timestamp

Yes

Date when the information in this warehouse record became effective.

RECORD_END_DATE

timestamp

Yes

Date when the information in this warehouse record is no longer effective.

MOST_RECENT

one-digit

No

Indicates that this record is the most recent.

0 = No

1 = Yes

DELETED

one-digit

No

Indicates that this record has been deleted.

0= No

1 = Yes