Warehouse Virtual

Contains the number which uniquely identifies the warehouse. The additional 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 warehouse ID. Virtual warehouses will have a valid physical warehouse in this column

Name of the warehouse Oracle Retail target column NAME on WAREHOUSE_VIRTUAL.

Org unit ID for the warehouse Oracle Retail target column ORGANIZATION_UNIT_ID on WAREHOUSE_VIRTUAL.

locale country of the warehouse

currency code for the warehouse

Contains the physical warehouse identifier that is assigned to the virtual warehouse.

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.

Secondary name of the warehouse

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

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. A transfer entity is a group of locations that share legal requirements around product management.

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 contain the channel for which the virtual warehouse will be assigned

This is the name of the channel

Y/N value which indicates if this virtual warehouse is an internal finisher.

Holds the email address for the location