Future Cost Workspace

The unique identifier of the cost event.

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.

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

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.

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.

Amount attributed to expenses, assessments, and up charges.

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.