Ordloc Discount

Order that deal components apply to.

Sequence number that uniquely identifies each ordsku_discount line associated with an order.

Item to which the deal/location applies.

Location to which the deal/item applies. This location can either be a store or physical warehouse.

Deal that applies to the order item.

Deal component that applies to the order item.

This field will be populated in the case of a buyer pack, when deal components should be applied to the component SKUs within the pack. The component SKU will be placed in the SKU field.

Discount value that applies to the order item. This is the currency amt., percentage, quantity or fixed currency amt. that will be discounted or rebated.

Identifies the type of the discount value. Valid values are Q for qty., A for currency amount, P for percentage or F for fixed amount. These values will be held on the codes table under a code type of DLL2.

This column will hold the value, per unit of the discount. For discounts of type Amount, this value will be the same as the discount value. For discounts of type Percent, this value will be the discount value percent off the cost of the item. If the discount type is fixed amount, this value will be the fixed discount amount prorated over the units purchased.

Order in which the deal components are applied to the order item.

Indicates if a discount/rebate has been paid. This value will always be Y for off-invoice discounts taken at the time of order. It will be set to Y at the time of receipt for off-invoice discounts taken at the time of receipt. It can also be used to indicate payment by the supplier for bill-back discounts and rebates. Valid values are Y for yes or N for no.

Date the order item discounts/rebates were last calculated in the nightly batch process.