XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WHDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
wh |
number10 |
1 |
1 |
The number which uniquely
identifies the warehouse. The wh table stores all
warehouses in the system, both virtual and
physical. |
WAREHOUSE |
ID |
NUMBER |
10,0 |
Yes |
Warehouse id |
wh_name |
varchar2150 |
1 |
1 |
Not Yet Available |
WAREHOUSE |
NAME |
VARCHAR2 |
150 |
Yes |
WAREHOUSE NAME |
wh_add1 |
varchar2240 |
0 |
1 |
Not Yet Available |
ADDRESS |
ADDRESS_LINE_1 |
VARCHAR2 |
240 |
No |
FIRST ADDRESS |
wh_add2 |
varchar2240 |
0 |
1 |
Not Yet Available |
ADDRESS |
ADDRESS_LINE_2 |
VARCHAR2 |
240 |
No |
second address |
wh_city |
varchar2120 |
0 |
1 |
Not Yet Available |
ADDRESS |
CITY |
VARCHAR2 |
120 |
No |
warehouse city id for address type |
county |
varchar2250 |
0 |
1 |
Not Yet Available |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Not Yet Available |
NOT USED IN SIM |
state |
varchar23 |
0 |
1 |
Not Yet Available |
ADDRESS |
STATE |
VARCHAR2 |
3 |
No |
warehouse state for address type |
country_id |
varchar23 |
0 |
1 |
Not Yet Available |
ADDRESS |
COUNTRY_ID |
VARCHAR2 |
3 |
No |
supplier country id depending on address type |
wh_pcode |
varchar230 |
0 |
1 |
NA |
ADDRESS |
POSTAL_CODE |
VARCHAR2 |
30 |
No |
warehouse post info depending on address type |
email |
varchar2100 |
0 |
1 |
Not Yet Available |
ADDRESS |
CONTACT_EMAIL |
VARCHAR2 |
100 |
No |
supplier email for address type |
stockholding_ind |
varchar21 |
0 |
1 |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
not used in sim |
channel_id |
number4 |
0 |
1 |
The channel for which the
virtual warehouse will be assigned. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
currency_code |
varchar23 |
1 |
1 |
The code for the currency
which the warehouse uses. |
WAREHOUSE |
CURRENCY_CODE |
VARCHAR2 |
40 |
Yes |
Currency Code |
duns_number |
varchar29 |
0 |
1 |
This type can hold a number
of digits count umber. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
duns_loc |
varchar24 |
0 |
1 |
The Dun and Bradstreet number
to identify the location. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
physical_wh |
number10 |
0 |
1 |
The number of the physical
warehouse corresponding to this warehouse. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
break_pack_ind |
varchar21 |
0 |
1 |
Indicates whether or not the
warehouse is capable of distributing less than the
supplier case quantity. Valid values are 'Y' or 'N' |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
redist_wh_ind |
varchar21 |
0 |
1 |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
delivery_policy |
varchar26 |
0 |
1 |
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. |
Fill application table name. |
null |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
contact_person |
varchar2120 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
dest_fax |
varchar220 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
phone_nbr |
varchar220 |
0 |
1 |
NA |
ADDRESS |
CONTACT_PHONE |
VARCHAR2 |
20 |
No |
warehouse phone for address type |
default_route |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
default_carrier_code |
varchar24 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
default_service_code |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
expedite_route |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
expedite_carrier_code |
varchar24 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
expedite_service_code |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
bol_upload_type |
varchar24 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
bol_print_type |
varchar24 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
lead_time |
number4 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
distance_to_dest |
number4 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
drop_trailers_accepted_flag |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
rcv_dock_available_flag |
varchar21 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
container_type |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
mld_default_route |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
unit_pick_container_type |
varchar26 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
dest_seq_nbr |
number4 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
owning_dc |
varchar210 |
0 |
1 |
NA |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
AddrDesc:AddrDesc
|
*
|
0
|
unbounded
|
It's a referenced element.
For detailed description, please refer referenced
element doc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
pricing_loc |
number10 |
0 |
1 |
The location for which
pricing info was copied for this warehouse. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
pricing_loc_curr |
varchar23 |
0 |
1 |
This is the currency code of
the pricing location. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
null |
NOT USED IN SIM |
org_unit_id |
number15 |
0 |
1 |
This field holds the Org Unit id of the Warehouse. |
WAREHOUSE |
ORGANIZATION_UNIT_ID |
VARCHAR2 |
15 |
No |
Fill this description. |