NUM_LINE_ITEMS

numeric

Yes

The number of line items in customer purchases that correspond to the day and site. This value counts rows in the ARF_LINE_ITEM_MV_SUPPL_ORDERS table.

NUM_ORDERS

numeric

Yes

The number of line items in customer purchases that correspond to the day and site. This value counts unique, or distinct, ORDER_ID column values in the ARF_LINE_ITEM_MV_SUPPL_ORDERS 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.

TOTAL_QUANTITY

numeric

Yes

The number of product items for the day and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. 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 and site. This value sums ARF_LINE_ITEM.STANDARD_PRICE_OVERRIDE_AMT column values that correspond to the grouping column values.