Supplier Bracket Cost

Primary key, system generated by a sequence that will uniquely identify the parent supplier inventory management record at the supplier, supplier/department, supplier/department/location or supplier/location level.

Primary key. This field contains the value of the primary bracket type. A specific value, -999, will be used to hold the FOB/pickup bracket value. The values in this field are stored in the bracket UOM 1 field at the parent supplier inventory management level.

This field contains the unique identifying number for a supplier within the system

This field contains the number which uniquely identifies the department.

This field contains the number which identifies the location. Only warehouse locations have bracket costing. In a multi-channel environment, only physical warehouses will have brackets attached. This table is being stored at the physical warehouse level because it is easier to maintain at that level since attributes will not vary from virtual warehouse to virtual warehouse within the same physical warehouse. Also, suppliers will have no knowledge (at this point in time) of virtual warehouses within physical warehouses, so this table must be stored at the physical warehouse level.