Item Loc Hist

This field contains a unique alphanumeric value that identifies the item.

This field contains the unique identifier for the location in which the transactions occurred. This may contain a store or a warehouse.

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

This field contains the end of the week date of the week for the sales total and other calculations.

This field contain the identifer of the week in which the transactions occurred based on the 454 calendar.

This field contain the identifer of the month in which the transactions occurred based on the 454 calendar.

This field contain the identifer of the year in which the transactions occurred based on the 454 calendar.

This field indicates the type of sale or inventory movement. Valid Values are: R = Regular Sales, P = Promotional Sales, C = Clearance Sales, I = Issues from Warehouses to Stores.

This fields contains the number of units sold or transferred for item/location/week/sales type combination. If the location type is a store, then this value represents sales. If the location type is a warehouse, then this value represents outbound transfer/allocation transactions to stores.

This field contains the retail value of the sales for the item/location/week/sales type combination. This field is stored in the local currency. This field will only hold a value for stores.

This field contains the total gross profit calculated for the item/location/week/sales type. This is updated for each sale that occurs during the week and is calculated as (sales retail - cost of sales). This field will only hold a value for stores.

This field contains the stock on hand for the item/location combination at the end of the week.

This field contains the unit retail price of the item at the location at the end of the week. This field is stored in the local currency.

This field contains the average cost of the item at the location at the end of the week. This field is stored in the local currency.

This field contains the date and time when the record was created. This date/time will be used in export processing. This value is populated on insert and never be updated.

This field holds the date time stamp of the most recent update by the last_update_id.

This field holds the Oracle user ID of the user who most recently updated this record.

This field contains the department of the item.

This field contains the class of the item.

This field contains the subclass of the item.

Holds the business date (vdate) the record is inserted or last updated. It should always have a value.