Cost Susp Sup Detail Loc

Contains the number which uniquely identifies the cost change.

Contains the number which identifies the supplier associated with the cost change.

The country where the item was manufactured or significantly altered.

Unique alphanumeric value that identifies the item.

Contains the type of the location. Valid values are Store and Warehouse.

Number of the location the cost change will occur at. This can represent a store or a warehouse Cost changes will be managed and stored at the physical warehouse level since the unit cost must remain consistant across all virtual warehouses within the same physical warehouse. The sccext batch program will handle blowing the cost change down to all virtual warehouses that reside on the physical warehouse stored on this table.

The values are the various levels in the vendors price list whereby costing of the items will be affected as the levels are achieved on Purchase Orders.

The unit of measure defining each value in a bracket. All values within a bracket have the same UOM.

This column will contain the value of the secondary bracket.

Contains the new unit cost for the specified item/location.

Describes the type of cost change

Holds the value of cost change

This field indicates whether or not approved order costs should be re-calculated when a supplier cost has changed. Valid values are: Y - Yes, recalculate order, N - No, do no recalculate order

This field contains the value which will control which cost is the base cost for processing throughout the system. Each bracket group (either by supplier, supplier/department, supplier/department/location, supplier/location) must have one bracket defined as the default bracket.

Contains the number which uniquely identifies the department. This field is only populated from the supplier bracket costing dialogue when bracket inserts or default bracket changes involved the department level.

This field will contain the supplier department sequence number.

DELIVERY_COUNTRY_ID Oracle Retail target column DELIVERY_COUNTRY_ID on COST_SUSP_SUP_DETAIL_LOC.

This contains a code to indicate whether the item is normal merchandise (i.e. owned by the retailer), consignment stock or a concession item. Valid values are 0 - Owned, 1 - Consignment, 2 - Concession.

This indicates if the cost for the consignment/concession item will be managed either based on cost per unit or as a percentage of retail. Valid values are C - Cost per Unit, P - Purchase Rate.

This column contains the percentage of the retail price which will determine the cost paid to the supplier for a consignment or concession item.