wh |
wh |
wh |
Yes |
The number which
uniquely identifies the warehouse. The wh table stores all warehouses in
the system, both virtual and physical. |
wh_name |
wh |
wh_name |
Yes |
The name of the
warehouse. |
wh_add1 |
* |
* |
No |
Field not
used. |
wh_add2 |
* |
* |
No |
Field not
used. |
wh_city |
* |
* |
No |
Field not
used. |
county |
* |
* |
No |
Field not
used. |
state |
* |
* |
No |
Field not
used. |
country_id |
* |
* |
No |
Field not
used. |
wh_pcode |
* |
* |
No |
Field not
used. |
email |
wh |
email |
No |
The email
address for the warehouse. |
stockholding_ind |
wh |
stockholding_ind |
Yes |
Indicates 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. |
channel_id |
wh |
channel_id |
No |
The channel for
which the virtual warehouse will be assigned. |
currency_code |
wh |
currency_code |
Yes |
The code for the
currency which the warehouse uses. |
duns_number |
wh |
duns_number |
No |
The Dun and
Bradstreet number tp identify the warehouse. |
duns_loc |
wh |
duns_loc |
No |
The Dun and
Bradstreet number to identify the location. |
physical_wh |
wh |
physical_wh |
Yes |
The number of
the physical warehouse corresponding to this warehouse. |
break_pack_ind |
wh |
break_pack_ind |
Yes |
Indicates
whether or not the warehouse is capable of distributing less than the
supplier case quantity. Valid values are 'Y' or 'N' |
redist_wh_ind |
wh |
redist_wh_ind |
Yes |
Indicates
whether 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. Used by Redistribution
report. |
delivery_policy |
wh |
delivery_policy |
Yes |
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. |
contact_person |
* |
* |
No |
Field not
used. |
dest_fax |
* |
* |
No |
Field not
used. |
phone_nbr |
* |
* |
No |
Field not
used. |
default_route |
* |
* |
No |
Field not
used. |
default_carrier_code |
* |
* |
No |
Field not
used. |
default_service_code |
* |
* |
No |
Field not
used. |
expedite_route |
* |
* |
No |
Field not
used. |
expedite_carrier_code |
* |
* |
No |
Field not
used. |
expedite_service_code |
* |
* |
No |
Field not
used. |
bol_upload_type |
* |
* |
No |
Field not
used. |
bol_print_type |
* |
* |
No |
Field not
used. |
lead_time |
* |
* |
No |
Always set to
zero. |
distance_to_dest |
* |
* |
No |
Always set to
zero. |
drop_trailers_accepted_flag |
* |
* |
No |
Field not
used. |
rcv_dock_available_flag |
* |
* |
No |
Field not
used. |
container_type |
* |
* |
No |
Field not
used. |
mld_default_route |
* |
* |
No |
Field not
used. |
unit_pick_container_type |
* |
* |
No |
Field not
used. |
dest_seq_nbr |
* |
* |
No |
Always set to
zero. |
owning_dc |
* |
* |
No |
Field not
used. |
AddrDesc |
* |
* |
* |
This is a child
node; see layout below. |
pricing_loc |
wh_add |
pricing_location |
No |
The location for
which pricing info was copied for this warehouse. |
pricing_loc_curr |
wh_add |
pricing_loc_curr |
No |
This is the
currency code of the pricing location. |