PROMOTION_USAGE_ID

bigint

No

Identifier; primary key.

PROMOTION_ID

smallint

No

Identifier of the promotion involved. Foreign key to ARF_PROMOTION.ID.

USAGE_TIMESTAMP

timestamp

Yes

The date and time a promotion transaction occurred.

DAY_ID

varchar

40

No

Day on which the transaction occurred; foreign key to ARF_TIME_DAY.ID.

TIME_ID

integer

No

Time at which the transaction occurred; foreign key to ARF_TIME_TOD.ID.

SKU_ID

integer

No

SKU to which the promotion was applied; foreign key to ARF_SKU.ID.

PRODUCT_ID

integer

No

Product to which the promotion was applied; foreign key to ARF_PRODUCT.ID.

CATEGORY_ID

integer

No

Category of the item to which the promotion was applied; foreign key to ARF_CATEGORY.ID.

CUSTOMER_ID

integer

No

Customer for whom the promotion was used; foreign key to ARF_USER.ID.

SEGCLSTR_ID

integer

No

Segment cluster to which the customer belongs; foreign key to ARF_SEGCLSTR.ID.

BILLING_REGION_ID

smallint

No

Billing region for the transaction; foreign key to ARF_GEO_REGION.ID.

LOCAL_CURRENCY_ID

smallint

No

Local currency in which the transaction occurred; foreign key to ARF_CURRENCY.ID.

DEMOGRAPHIC_ID

smallint

No

Demographic to which the customer belongs; foreign key to ARF_DEMOGRAPHIC.ID.

SITE_VISIT_ID

bigint

No

ID of site visit in which the promotion use occurred.

ORDER_ID

integer

No

ID of the order to which the promotion was applied.

NORDER_ID

varchar

40

No

Natural identifier for the order to which the promotion was applied.

SESSION_ID

varchar

128

Yes

ID of the session in which the promotion was used.

AGENT_ID

varchar

40

Yes

Agent involved in the transaction, if any; foreign key to ARF_IU_USER.ID.

ORIGIN_SALES_CHANNEL_ID

numeric

3

Yes

Identifier for sales channel that originated the order. Foreign key to ARF_SALES_CHANNEL.ID column.

SUBMIT_SALES_CHANNEL_ID

numeric

3

Yes

Identifier for sales channel that completed the order. Foreign key to ARF_SALES_CHANNEL.ID column.

QUANTITY

integer

No

Quantity of items to which the promotion applies.

LOCAL_NET_REVENUE

numeric

19

No

Net revenue for the item to which the promotion was applied, in the local currency. If the promotion is one that applies to an entire order, this value is the same as the LOCAL_ORDER_NET_REVENUE value.

LOCAL_ORDER_NET_REVENUE

numeric

19

No

Net revenue for the entire order after applying the promotion, in the local currency.

LOCAL_DISCOUNT_AMOUNT

numeric

19

No

Effective amount of the discount applied as a result of the promotion, in the local currency.

STANDARD_NET_REVENUE

numeric

19

No

Net revenue for the item to which the promotion was applied, in the standard currency. If the promotion is one that applies to an entire order, this value is the same as the LOCAL_ORDER_NET_REVENUE value.

STANDARD_ORDER_NET_REVENUE

numeric

19

No

Net revenue for the entire order after applying the promotion, in the standard currency.

STANDARD_DISCOUNT_AMOUNT

numeric

19

No

Effective amount of the discount applied as a result of the promotion, in the standard currency.

SITE_ID

smallint

No

The site at which the transaction occurred. Foreign key to ARF_SITE.ID.

COUPON_USAGE_ID

bigint

No

A unique identifier for this use of a coupon. Set to 0 if no coupon is associated with the promotion usage.

COUPON_ID

int

No

The identifier of the coupon record. This is a foreign key to the ARF_COUPON table

COUPON_CODE

varchar

254

Yes

The name assigned to the coupon used