Ordloc

Contains the number that uniquely identifies an order within the system.

Unique alphanumeric value that identifies the item.

This field contains the location that item will be ordered to. This field may contain a store or a warehouse.

This field contains the type of location in the location field. Valid values are: S - Store W - Warehouse

Contains the current retail price for the SKU at this location. This field is stored in the local currency. This field is only stored on this table for the purpose of calculating Open-To-Buy.

Contains the total number of items ordered for the SKU to this location.

Contains the order quantity (system generated or manually generated) for the item/location before order scaling processing was performed.

Contains the number of items for this SKU already received to this location.

Contains the number of items that were received in the most recent shipment.

This column will hold the most recent system rounded order quantity value for the line item.

This column will hold the last system rounded order quantity for the rounding group the location is apart of.

This field contains the quantity that was left to be ordered when the line item was cancelled.

This field contains the reason that the line item was cancelled. This field is required if a line item is cancelled.

This field contains the date the line item was cancelled.

This field contains the user ID of the user who cancelled the line item. This field will be automatically populated if a line item is cancelled.

Original order quantity from replenishment.

This field contains the unit cost for the Item/Location on the order, including discounts (deal/bracket/allowance), but not landed cost components. This field is stored in order currency.

Initial supplier unit cost of the item/location on the order, before deals were applied. When discounts must be recalculated on an approved order, this cost will be used as the starting point. This value is captured as the current item/location/supplier/origin country cost at the time of order approval.

Indicates the basis for the cost of the Item/Location on the order and whether deals or brackets have been applied. Valid values include: NORM - Normal Supplier Cost DEAL - Cost Based on a Deal BRKT - Cost Based on a Bracket MANL - User Specified or Manual Override Cost CONT - Costs retrieved from the Contract ALLW - Cost Based on an Allowance

Indicator to determine if the item/locations order quantity should not be scaled during the order scaling process. Valid values include: Y - Yes. Fix the order quantity to ensure that the item/location order quantity is not adjusted during the order scaling process. N - No. Do not fix the order quantity to ensure that the item/location order quantity will be adjusted during the order scaling process.

A reference number to link the item on the transfer to any purchase orders that have been created to allow the from location (i.e. warehouse) on the transfer to fulfill the transfer quantity to the to location (i.e store) on the transfer.

Date that the item on the PO is expected to be available to ship from the PO location to another location. It is calculated as the Order Creation or Approval Date + Supplier Lead Time + Transit Days between the Supplier and the PO/location + Item/Warehouse Inbound Handling Days (if PO location is a warehouse).

The date a record was last updated.

The username identifier of the user who last updated a record.

The date a record was created.

The username identifier of the user who created the record.

This column holds a backup of ORDLOC.UNIT_COST at the start of orddscnt. It is the order unit cost, including off-invoice deal discounts, calculated after the previous run of orddscnt. It is a helper column for the purpose of deal discount re-application.