Wh

Contains the number which uniquely identifies the warehouse. The wh table stores all warehouses in the system. Both virtual and physical warehouses will be stored on this table. The addition of the new column, physical_wh, helps determine which warehouses are physical and which are virtual. All physical warehouses will have a physical_wh column value equal to their wh number. Virtual warehouses will have a valid physical warehouse in this column.

Contains the name of the warehouse which, along with the warehouse number, identifies the warehouse.

Secondary name of the warehouse.

Holds the email address for the location

warehouse is located. Oracle Retail target column VAT_REGION on WH.

Contains the organization type that will be used in reporting purposes for the warehouse. The type comes from the organizational hierarchy. Valid values are: 1 = Company 10 = Chain 20 = Area 30 = Region 40 = District 50 = Store

Contains the code associated with the specific organizational hierarchy type. Valid values include the company number, chain number, area number, etc.

This field contains the currency code under which the warehouse operates.

This column will contain the number of the physical warehouse that is assigned to the virtual warehouse.

This field holds the virtual warehouse that will used as the basis for all transactions for which only a physical warehouse and not a virtual warehouse has not been specified.

This column will contain the channel for which the virtual warehouse will be assigned.

This column will indicate if the warehouse is a stock holding location. In a non-multichannel environment, this will always be Y. In a multichannel environment it will be N for a physical warehouse and Y for a virtual warehouse.

Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are : Y or N.

Indicates that the warehouse is a Re-Distribution warehouse. Used as a location on Purchase Orders in place of actual locations that are unknown at the time of Purchase Order creation and approval. This value allows the Redistribution Report to identify orders requiring redistribution. A Warehouse with this indicator will not be limited in any RMS transactions. Valid values are Y or N.

Contains the delivery policy of the warehouse. Next Day indicates that the if a location is closed, the warehouse will deliver on the next day. Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day before delivering. Valid values come from the DLVY code on code_head/code_detail.

Indicator used to restrict virtual warehouses from receiving stock during an inbound type transaction (ex. positive SOH inventory adjustment, PO over-receipt) when stock needs to be prorated across virtual warehouses within a physical warehouse because a virtual warehouse in the physical warehouse has not been identified for the transaction. The indicator will restrict the virtual warehouse from receiving stock unless all the valid virtual warehouses determined by the system are restricted, then the stock will be distributed across those restricted virtual warehouses. This indicator will only be used in a multi-channel environment. It is always set to No in a single channel environment.

Indicator used to determine if the virtual warehouse is affected last in transactions where inventory is removed or affected first in short-shipment type transactions where inventory is being added. The indicator will be used in any outbound or inventory removal type transactions (ex. RTVs, negative SOH inventory adjustments, etc.) when the system has to distribute the transaction quantity across virtual warehouses within a physical warehouse either because a virtual warehouse has not been specified or couldnt be derived or if a virtual warehouse doesnt have enough stock to cover the transaction quantity and stock needs to be pulled from other virtual warehouse within the physical warehouse. The indicator will also be used for inbound type transactions where there is some sort of short- shipment ex. a short-shipment for a PO). The indicator will determine which virtual warehouses will have their order quantity fulfilled first with the receipt quantity. Note that this indicator does not guarantee that stock will not be pulled from the virtual warehouse, it is only used to ensure that the virtual warehouse is affected last. This indicator will only be used in a multi-channel environment. It is always set to No in a single channel environment.

This indicator determines if a warehouse is forecastable. The intent of this indicator is to restrict the information being sent to RDF against which to generate forecasts.

This column determines which virtual warehouses within a physical warehouse should be rounded together as well as determining which virtual warehouse receives the additional stock or decreased stock due to rounding. This value will be a virtual warehouse number. All warehouses will the same rounding seq number will be rounded together with the warehouse that equals the rounding seq receiving any extra stock.

This indicator determines if a warehouse is replenishable.

This field holds the replenishable warehouse that is linked to this virtual warehouse. This link implies that the virtual warehouse is included in the net inventory calculations for the replenishable warehouse.

This field contains the order from which the inventory is sourced from the linked warehouses.

This field indicates if the warehouse is an investment buy warehouse.

This field contains the investment buy warehouse that is linked to the virtual warehouse. This link implies that the virtual warehouse is included in the net inventory calculations for the investment buy warehouse.

This indicator determines if the investment buys inventory should be automatically transferred to the turn (replenishable) warehouse when an order is received by the turn warehouse.

This field holds the Dun and Bradstreet number to identify the warehouse

This field holds the Dun and Bradstreet number to identify the location

ID of the transfer entity with which this warehouse is associated. Valid values are found on the TSF_ENTITY table. A transfer entity is a group of locations that share legal requirements around product management.

Yes/No value which indicates if this virtual warehouse is an internal finisher.

Warehouse inbound handling days are defined as the number of days that the warehouse requires to receive any item and get it to the shelf so that it is ready to pick.

this column will hold the oracle oraganizational unit id value.

This attribute will be included in the location downloads to AIP.

This is the new column that will specify if the warehouse is a legal entity (Importer, Exporter) or a regular warehouse. Valid values are: R - regular warehouse (including finisher); M - importer; X - exporter. Default value is R.

This Column determines if the location is customer order location or not, i.e. if the indicator is checked then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used. It is enabled only for virtual warehouses. For a physical warehouse, this column would be NULL. For virtual warehouses, the valid values are 'Y' or 'N'.

This column holds the User id of the user who created the record.

This column holds the record creation date.

This field contains the default warehouse linked to the virtual warehouse.

The location from which pricing records will be copied.

This column will indicate if the location will support shipping to a customer for customer orders.

This column will indicate if the location will support gift wrapping.

Contains the unique tax identification number of the physical warehouse.

Holds the user-id of the user who most recently updated this record.

Holds the date time stamp of the most recent update by the last_update_id.

This column will hold the ID of legal entity associated with the Warehouse. The legal entity if specified will directly be used in the integration with Accounts Payable.