Item Parentloc Hist Mth

Unique alphanumeric value that identifies the item.

Number of the location in which the item is to be found. This field may contain a store or a warehouse.

Type of location in the location field. Valid values are: S = Store W = Warehouse

End of the month date for which the sales totals are gathered.

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 Regular sales, promotional sales and clearance sales can occur at stores. Issues occur only at warehouses.

Number of the 454 month for the sales figures.

Number of the 454 year for the sales figures.

Contains the number of units sold for the Item/Store/month/sales_type combination.

Retail value received on 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.

Gross profit calculated for each sale of an item as (sales retail - cost of sales). Sales retail is the actual retail sold for this item. Cost of sales is either av_cost (weighted average cost when system_options.std_av_ind = A), or unit_cost (primary supplier cost when system_options.std_av_ind = S) on item_loc table. This field will only hold a value for stores.

Stock on hand for the item/location combination at the end of the week.

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

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