Future Cost

The item of the future_cost record.

The supplier of the future_cost record.

The origin country of the future_cost record.

The location of the future_cost record.

The location type of the future_cost record. S - store, W - warehouse.

Date that the item/supplier/country/location combinations costs becomes active.

Base cost of the SKU/supplier/country at the given location. This is the same cost that is on the item_supp_country table.

Net cost of the SKU/supplier/country at the given location. This is the base cost minus any deal components designated as applying to net cost on DEAL_DETAIL.

Net net cost of the SKU/supplier/country at the given location. This is the net cost minus any deal components designated as applying to net net cost on DEAL_DETAIL.

Dead net net cost of the SKU/supplier/country at the given location. This is the net net cost minus any deal components designated as applying to dead net net cost on DEAL_DETAIL.

Cost to be used to in pricing reviews. Pricing cost is the cost that will be interfaced with Oracle Price Management for use in pricing decisions.

Date the cost was last calculated.

This value is Y if this record in future_cost is the start date of a cost event or holds N if this record in future_cost is the reset date of a cost event.

Items base cost at the items primary supplier/country and source wh minus any deal pass through values

Amount attributed to expenses, assessments, and up charges.

Indicates if the records is the primary supplier and country for the item/location combination.

Contains a code which uniquely identifies the type of currency.

Contains the number which uniquely identifies the division of the company.

Contains the number which uniquely identifies the group.

Contains the number which uniquely identifies the department.

Contains the number which uniquely identifies the class.

Contains the number which uniquely identifies the subclass.

Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.

Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table.

Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.) Valid values are found on the diff_group and diff_id tables.

Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.) Valid values are found on the diff_group and diff_id tables.

Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.) Valid values are found on the diff_group and diff_id tables.

Diff_group or diff_id that differentiates the current item from its item_parent. For an item that is a parent, this field may be either a group (i.e. Mens pant sizes) or a value (6 oz). For an item that is not a parent, this field may contain a value (34X34, Red, etc.) Valid values are found on the diff_group and diff_id tables.

Contains the number which uniquely identifies the chain.

Contains the number which uniquely identifies the area.

Contains the number which uniquely identifies the region.

Contains the number which uniquely identifies the district

Highest level of supplier hierarchy (e.g. manufacturer). This will be used for assigning rebates that come from a level in the supply chain that is higher than the supplier.

Second highest level of supplier hierarchy. Rebates at this level will include all eligible supplier/item/country/loc records assigned to this supplier hierarchy level.

Third highest level of supplier hierarchy, used for assigning rebates by a level other than supplier. Rebates at this level will include all eligible supplier/item/country/loc records assigned to this supplier hierarchy level.

Identifies the reclassification that affected the costs for the sku/supplier/country/location/active date combination.

Identifies the cost change that affected the costs for the sku/supplier/country/location/active date combination.

Indicates if pack item is a simple pack or not. This field will only be available if the item is a pack item. A simple pack is an item whose components are all the same item (i.e. a six pack of cola, etc). Valid values are: Y = Yes, this item is a simple pack N = No, this item is not a simple pack

This field contains an item number that is a simple pack containing the item in the item column for this record. If populated, the cost of the future cost table will be driven from the simple pack and the deals and cost changes for the simple pack.

This field contain the quantity of the component item for the primary cost pack.

This column will indiate the type of the store. This will have a value only if the location type is a store. Valid values are,F - Franchise, C- Company

This column will give the costing location for the franchise location.The costs for franchise location will be derived from the costing location base cost.

This field will give the franchise cost buildup template to be applied on the item to arrive at the pricing cost.

Percentage of the suppliers off-invoice deals that will be passed from source wh to the customer store.

Holds the supplier negotiated item cost.

Holds the extended base cost of the item. Extended base cost is the cost inclusive of all the taxes that affect the weighted average cost (WAC).

Holds the tax on the weighted average cost.

Indicates the cost used to compute values in cost-related fields for this table. Valid values are, Base Cost (BC) and Negotiated Item Cost (NIC).

Holds the ownership change id associated to this item