This table contains one row for every line item in every order placed by customers. Note the following:
Discount refers to any amount subtracted from the price of the item or the order, such as coupons.
Tax and shipping costs are applied to an order. The pipeline processors that populate the data warehouse allocate these costs across line items. See the ATG Commerce Programming Guide for information on these processors.
Local currency refers to the currency in which the customer pays; standard currency is the currency used for reporting.
Column Name
Type
Length
Null Allowed
Description
SUBMIT_DAY_ID
varchar
40
No
Day order was submitted. Foreign key to ARF_TIME_DAY.ID column.
SUBMIT_TIME_ID
int
No
Time the order was submitted. Foreign key to ARF_TIME_TOD.ID column.
SKU_ID
int
No
Identifier of SKU ordered. Foreign key to ARF_SKU.ID column.
PRODUCT_ID
int
No
Identifier for item’s product. Foreign key to ARF_PRODUCT.ID column.
CATEGORY_ID
int
No
Identifier for item’s category. Foreign key to ARF_CATEGORY.ID column.
CUSTOMER_ID
int
No
Customer’s user ID. Foreign key to ARF_USER.ID column.
STIM_GRP_ID
smallint
No
Reference to the group of stimuli that may have stimulated the order. Foreign key to ARF_STIMGRP.ID column.
SEGCLSTR_ID
int
No
Identifier of segment cluster of which the customer is a member. Foreign key to ARF_SEGCLSTR.ID column.
PROMOGRP_ID
int
No
Identifier of promotion group that applies to the line item. Foreign key to ARF_PROMOGRP.ID column.
BILLING_REGION_ID
smallint
No
Identifier for the region of the customer’s billing address. Foreign key to ARF_GEO_REGION.ID column.
SHIPPING_REGION_ID
smallint
No
Identifier for the region of the customer’s shipping address. Foreign key to ARF_GEO_REGION.ID column.
LOCAL_CURRENCY_ID
smallint
No
Currency in which the line item was purchased. Foreign key to ARF_CURRENCY.ID column.
DEMOGRAPHIC_ID
smallint
No
Foreign key to ARF_DEMOGRAPHIC_ID column, which provides references to age, marital status, etc..
SITE_VISIT_ID
bigint
No
ID of site visit.
ORDER_ID
int
No
ID of order. Surrogate key.
LINE_ITEM_ID
bigint
No
Identifier; primary key. Surrogate key.
NORDER_ID
varchar
40
No
Natural key of order from the Order repository..
NLINE_ITEM_ID
varchar
40
No
Natural key of line item from the Order repository.
QUANTITY
int
No
Quantity of this line item ordered.
LOCAL_UNIT_PRICE
double
No
Unit price in the local currency. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_GROSS_REVENUE
double
No
Revenue before adjustments due to discounts, taxes, and shipping, in the local currency. Equal to unit price * quantity.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_DISCOUNT_AMOUNT
double
No
Any discount applied to this specific line item, in the local currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_ORDER_TAX_ALLOC
double
No
Amount of tax on the order that is allocated to this line item, in the local currency. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_ORDER_SHIPPING_ALLOC
double
No
Amount of shipping on the order that is allocated to this line item. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_ORDER_DISCOUNT_ALLOC
double
No
Amount of any order-level discounts that is allocated to this line item, in the local currency. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_NET_REVENUE
double
No
Revenue after adjustments due to discounts, taxes, and shipping, in the local currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
LOCAL_ORDER_NET_REVENUE
double
No
Revenue for the entire order of which this line item is a part, after adjustments due to discounts, taxes, and shipping, in the local currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_UNIT_PRICE
double
No
Unit price in the reporting currency. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_GROSS_REVENUE
double
No
Revenue before adjustments due to discounts, taxes, and shipping, in the reporting currency. Equal to unit price * quantity.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_DISCOUNT_AMOUNT
double
No
Any discount applied to this specific line item, in the reporting currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_ORDER_TAX_ALLOC
double
No
Amount of tax on the order that is allocated to this line item, in the reporting currency. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_ORDER_SHIPPING_ALLOC
double
No
Amount of shipping on the order that is allocated to this line item, in the reporting currency. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_ORDER_DISCOUNT_ALLOC
double
No
Amount of any order-level discounts that is allocated to this line item, in the reporting currency. The allocation is determined by the processing pipeline.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_NET_REVENUE
double
No
Revenue after adjustments due to discounts, taxes, and shipping, in the reporting currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
STANDARD_ORDER_NET_REVENUE
double
No
Revenue for the entire order of which this line item is a part, after adjustments due to discounts, taxes, and shipping, in the reporting currency.
The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.
