SIM Expl

Unique identifying number for the supplier within the system.

This column will link the supplier/dept/loc to a master supplier.

Contains the investment buy order control associated with the supplier, supplier/dept, supplier/loc or supplier/dept/loc. When the investment buy opportunity calculation processes an item/supplier/origin_country/location, this value is retrieved at lowest applicable level. A value of Manual dictates that investment buy ROQs will only be written to the Investment Buy Results table and will not be processed by any online or batch processes. A value of Buyer Worksheet dictates that investment buy ROQs will be processed solely via the buyer worksheet online dialog. A value of Semi- Automatic dictates that investment buy ROQs will be added to Worksheet orders by the replenishment automatic order building process. A value of Automatic dictates that investment buy ROQs will be added to Approved orders by the replenishment automatic order building process.

Indicates the alphanumeric representation of Term Name which acts as the Term code in Oracle Financials.

Contains the number of days until payment is due

This column will contain the warehouse associated with the Investment Buy setup data.

Contains the physical wh associated with the wh.

This column contains the replenishable warehouse that is attached to the virtual warehouse.

This column will contain the department associated with the Investment Buy setup data

Contains the buyer associated with the dept.

The type of the whs stroage cost.

Contains the default cost of warehouse storage, expressed as the weekly cost per the unit of measure specified in COST_WH_STORAGE_UOM. This value is held in the primary system currency and currently used by the investment buy functionality only.

Contains the unit of measure to which the default cost of warehouse storage is applicable. The unit of measure may only be pallet or from the volume class. This value is currently used by the investment buy functionality only.

The type of the whs stroage cost.

Contains the default cost of outside storage, expressed as the weekly cost per the unit of measure specified in COST_OUT_STORAGE_UOM. This value is held in the primary system currency and currently used by the investment buy functionality only.

Contains the unit of measure to which the default cost of outside storage is applicable. The unit of measure may only be pallet or from the volume class. This value is currently used by the investment buy functionality only.

Indicates which type of storage cost should be used as the default storage cost when calculating investment buy opportunities. Valid values are Warehouse and Outside. This value is currently used by the investment buy functionality only.

Indicates currency used for storages costs.

Indicates suppliers currency. Oracle Retail target column SUPPLIER_CURRENCY on SIM_EXPL.

Contains the default maximum weeks of supply to use in the investment buy opportunity calculation. The investment buy opportunity calculation will not recommend an order quantity that would stock the associated location (currently warehouses only) beyond this number of weeks. This value is currently used by the investment buy functionality only.

Contains the default return on investment that must be met or exceeded for the investment buy opportunity to recommend an order quantity. This value is currently used by the investment buy functionality only

Contains the cost of money, defined as the annualized percentage cost to borrow capital for investing. This value is currently used by the investment buy functionality only.

Contains ALL_LVL if the sup_inv_mgmt parameters were sourced at the sup/dept/loc level. Contains LOC_LVL if the sup_inv_mgmt parameters were sourced at the sup/loc level. Contains DEPT_LVL if the sup_inv_mgmt parameters were sourced at the sup/dept level. Contains SUPP_LVL if the sup_inv_mgmt parameters were sourced at the sup level.