NUM_LINE_ITEMS

numeric

Yes

The number of line items in customer purchases that correspond to the day, site, sales channel, segment cluster, internal agent, and product. This value counts rows in the ARF_LINE_ITEM table.

SUBMIT_DAY_ID

varchar

40

No

A reference to a value in the ARF_TIME_DAY.ID column.

DAY_TIMESTAMP

timestamp

No

A reference to a value in the ARF_TIME_DAY.DAY_TIMESTAMP column.

SUBMIT_SITE_ID

smallint

No

A reference to a value in the ARF_SITE.ID column.

SUBMIT_SALES_CHANNEL_ID

tinyint

Yes

A reference to a value in the ARF_SALES_CHANNEL.ID column.

SEGMENTCLUSTER_ID

integer

No

A reference to a value in the ARF_SEGCLSTR.ID column.

AGENT_ID

varchar

40

Yes

A reference to a value in the ARF_IU_USER.ID column.

PRODUCT_ID

integer

No

A reference to a value in the ARF_PRODUCT.ID column.

TOTAL_QUANTITY

numeric

Yes

The number of product items for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.QUANTITY column values that correspond to the grouping column values.

TOTAL_STD_UNIT_PRICE

numeric

Yes

The total price of the product items for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_UNIT_PRICE column values that correspond to the grouping column values.

TOTAL_STD_NET_REVENUE

numeric

Yes

The total revenue after adjustments due to discounts, taxes, and shipping for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_NET_REVENUE column values that correspond to the grouping column values.

TOTAL_STD_GROSS_REVENUE

numeric

Yes

The total revenue before adjustments due to discounts, taxes, and shipping for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_GROSS_REVENUE column values that correspond to the grouping column values.

TOTAL_STD_DISCOUNT

numeric

Yes

The total discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_DISCOUNT_AMOUNT column values that correspond to the grouping column values.

TOTAL_STD_MARKDOWN_DISCOUNT

numeric

Yes

The total markdown discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_MARKDOWN_AMOUNT column values that correspond to the grouping column values.

TOTAL_STD_ORDER_SHIP_ALLOC

numeric

Yes

The total order shipping costs for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_ORDER_SHIPPING_ALLOC column values that correspond to the grouping column values.

TOTAL_STD_ORDER_TAX_ALLOC

numeric

Yes

The total of order tax amounts for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_ORDER_TAX_ALLOC column values that correspond to the grouping column values.

TOTAL_STD_ORDER_DSCNT_ALLOC

numeric

Yes

The total of order-level discounts applied for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_ORDER_DISCOUNT_ALLOC column values that correspond to the grouping column values.

TOTAL_STD_APPSMT_CRED_ALLOC

numeric

Yes

The total of appeasement credits applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_APPSMT_CDT_ALLOC_AMT column values that correspond to the grouping column values.

TOTAL_STD_APPSMT_DEBIT_ALLOC

numeric

Yes

The total of appeasement debits applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_APPSMT_DBT_ALLOC_AMT column values that correspond to the grouping column values.

TOTAL_STD_PRICE_OVERRIDE

numeric

Yes

The total value of price overrides applied by internal agents for the day, site, sales channel, segment cluster, internal agent, and product. This value sums ARF_LINE_ITEM.STANDARD_PRICE_OVERRIDE_AMT column values that correspond to the grouping column values.