Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AllocDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
alloc_no
stock_allocation
distro_nbr or cust_order_nbr
Yes
*
doc_type
*
*
*
*
physical_wh
transshipment_setup
dc_dest_id
Yes
*
wh
*
*
*
*
item
stock_allocation
item_id
Yes
*
pick_not_before_date
*
*
*
*
pick_not_after_date
*
*
*
*
order_type
*
*
*
*
order_no
*
*
*
*
order_doc_type
*
*
*
*
event
*
*
*
*
event_description
*
*
*
*
priority
*
*
*
*
ticket_type_id
stock_allocation
ticket_type_id
No
*
AllocDtl
*
*
*
*
context_type
*
*
*
*
context_value
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AllocDtl
Tag Name
Table Name
Column Name
API Req
Description
physical_to_loc
*
*
*
*
to_loc
stock_allocation
dest_id
Yes
*
loc_type
*
*
*
*
qty_allocated
stock_allocation
requested_unit_qty
Yes
*
price
stock_allocation
retail_price
No
*
selling_uom
stock_allocation
selling_uom
No
*
priority
stock_allocation
priority
Yes
*
store_ord_mult
stock_allocation
store_ord_mult
Yes
*
AllocDtlTckt
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AllocDtlTckt
Tag Name
Table Name
Column Name
API Req
Description
comp_item
component_ticketing
component_item_id
Yes
*
comp_price
component_ticketing
retail_price
Yes
*
comp_selling_uom
component_ticketing
selling_uom
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AllocRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
alloc_no
stock_allocation
distro_nbr or cust_order_no
Yes
*
doc_type
*
*
*
*
physical_wh
transshipment_setup
dc_dest_id
Yes
*
wh
*
*
*
*
item
stock_allocation
item_id
Yes
*
AllocDtlRef
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AllocDtlRef
Tag Name
Table Name
Column Name
API Req
Description
to_loc
stock_allocation
dest_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AppointDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
from_location
transshipment_setup
dc_dest_id
Yes
*
to_location
*
*
Yes
*
appt_nbr
appt_header_to_upload
appt_nbr
Yes
*
appt_start_ts
appt_header_to_upload
appt_start_ts
Yes
*
appt_action_status
appt_header_to_upload
appt_action_status
Yes
*
AppointDtl
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AppointDtl
Tag Name
Table Name
Column Name
API Req
Description
item_id
appt_detail_to_upload
item_id
Yes
*
unit_qty
appt_detail_to_upload
unit_qty
Yes
*
po_nbr
appt_detail_to_upload
po_nbr
Yes
*
document_type
appt_detail_to_upload
document_type
Yes
*
asn_nbr
appt_detail_to_upload
asn_nbr
No
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AppointRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
appt_nbr
*
*
*
*
from_location
*
*
*
*
AppointDtlRef
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:AppointDtlRef
Tag Name
Table Name
Column Name
API Req
Description
item_id
*
item_id
Yes
*
po_nbr
*
po_nbr
Yes
*
asn_nbr
*
asn_nbr
No
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNInDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
to_location
n/a
n/a
Yes
Not used in RWMS
from_location
n/a
n/a
Yes
Not used in RWMS
asn_nbr
asn
asn_nbr
Yes
*
asn_type
asn
asn_type
Yes
*
container_qty
asn
container_qty
Yes
*
bol_nbr
asn
bol_nbr
No
*
shipment_date
n/a
n/a
Yes
Not used in RWMS.
est_arr_date
n/a
n/a
No
Not used in RWMS.
ship_address1
n/a
n/a
No
Not used in RWMS.
ship_address2
n/a
n/a
No
Not used in RWMS.
ship_address3
n/a
n/a
No
Not used in RWMS.
ship_address4
n/a
n/a
No
Not used in RWMS.
ship_address5
n/a
n/a
No
Not used in RWMS.
ship_city
n/a
n/a
No
Not used in RWMS.
ship_state
n/a
n/a
No
Not used in RWMS.
ship_zip
n/a
n/a
No
Not used in RWMS.
ship_country_id
n/a
n/a
No
Not used in RWMS.
trailer_nbr
n/a
n/a
No
Not used in RWMS.
seal_nbr
n/a
n/a
No
Not used in RWMS.
carrier_code
asn
carrier_code
No
*
vendor_nbr
po
vendor_nbr
Yes
*
ship_pay_method
n/a
n/a
No
Not used in RWMS.
ASNInPO
*
*
*
*
comments
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNInPO
Tag Name
Table Name
Column Name
API Req
Description
po_nbr
po_detail
po_nbr
Yes
*
doc_type
po
doc_type
Yes
*
not_after_date
po
deliv_not_after_date
No
*
comments
*
*
*
*
ASNInCtn
*
*
*
*
ASNInItem
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNInCtn
Tag Name
Table Name
Column Name
API Req
Description
final_location
container
dest_id
Yes
*
container_id
container
container_id
Yes
*
container_weight
container
container_weight
No
*
container_length
container
container_length
No
*
container_width
container
container_width
No
*
container_height
container
container_height
No
*
container_cube
container
container_cube
No
*
expedite_flag
container
expedite_flag
No
*
in_store_date
container
in_store_date
No
*
rma_nbr
container
rma_nbr
No
*
tracking_nbr
n/a
n/a
No
Not used in RWMS
freight_charge
container
freight_charge
No
*
master_container_id
n/a
n/a
No
Not used in RWMS
ASNInItem
*
*
*
*
comments
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNInItem
Tag Name
Table Name
Column Name
API Req
Description
final_location
asn_item
dest_id
Yes
*
item_id
po_detail
item_id
Yes
*
unit_qty
asn_item
unit_qty
Yes
*
priority_level
container_item
priority_level
No
*
vpn
*
*
*
*
order_line_nbr
n/a
n/a
No
Not used in RWMS.
lot_nbr
n/a
n/a
Yes
Not used in RWMS.
ref_item
n/a
n/a
No
Not used in RWMS.
distro_nbr
container_item
distro_nbr
Yes
*
distro_doc_type
n/a
n/a
No
Not used in RWMS.
container_qty
container_item
container_qty
No
*
comments
*
*
*
*
final_location
asn_item
dest_id
Yes
*
item_id
po_detail
item_id
Yes
*
unit_qty
asn_item
unit_qty
Yes
*
priority_level
container_item
priority_level
No
*
vpn
*
*
*
*
order_line_nbr
n/a
n/a
No
Not used in RWMS.
lot_nbr
n/a
n/a
Yes
Not used in RWMS.
ref_item
n/a
n/a
No
Not used in RWMS.
distro_nbr
container_item
distro_nbr
Yes
*
distro_doc_type
n/a
n/a
No
Not used in RWMS.
container_qty
container_item
container_qty
No
*
comments
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNInRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
to_location
manifest
dest_id
Yes
*
from_location
transshipment_setup
dc_dest_id
Yes
*
asn_nbr
calculated
asn_nbr
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNOutDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
to_location
ship_dest
dest_id
Yes
*
from_location
transshipment_setup
dc_dest_id
Yes
*
asn_nbr
computed
*
No
*
asn_type
calculated
*
No
*
container_qty
computed
*
No
*
bol_nbr
bol_to_upload
bol_nbr
Yes
*
shipment_date
manifest
ship_ts
No
*
est_arr_date
ship_dest
lead_time
No
*
ship_address1
ship_dest
address1
No
*
ship_address2
ship_dest
address2
No
*
ship_address3
n/a
n/a
No
Not used in RWMS.
ship_address4
n/a
n/a
No
Not used in RWMS.
ship_address5
n/a
n/a
No
Not used in RWMS.
ship_city
ship_dest
city
No
*
ship_state
ship_dest
state
No
*
ship_zip
ship_dest
zip
No
*
ship_country_id
ship_dest
country_code
No
*
trailer_nbr
manifest
trailer_id
Yes
*
seal_nbr
manifest
seal_nbr
No
*
carrier_code
trailer
carrier_code
Yes
*
transshipment_nbr
manifest
transshipment_nbr
No
*
ASNOutDistro
*
*
*
*
comments
n/a
n/a
No
Not used in RWMS.
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNOutDistro
Tag Name
Table Name
Column Name
API Req
Description
distro_nbr
container_item
distro_nbr
Yes
*
distro_doc_type
stock_order
document_type
Yes
*
customer_order_nbr
stock_order
cust_order_nbr
Yes
*
consumer_direct
stock_order
consumer_direct
No
*
ASNOutCtn
*
*
*
*
comments
n/a
n/a
No
Not used in RWMS.
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNOutCtn
Tag Name
Table Name
Column Name
API Req
Description
final_location
container
dest_id
No
*
container_id
container
container_id
Yes
*
container_weight
container
container_weight
No
*
container_length
container
container_length
No
*
container_width
container
container_width
No
*
container_height
container
container_height
No
*
container_cube
container
container_cube
No
*
expedite_flag
container
expedite_flag
No
*
in_store_date
container
in_store_date
No
*
rma_nbr
container
rma_nbr
No
*
tracking_nbr
*
tracking_nbr
No
*
freight_charge
*
freight_charge
No
*
master_container_id
container
master_container_id
No
*
ASNOutItem
*
*
*
*
comments
n/a
n/a
No
Not used in RWMS.
weight
*
*
*
*
weight_uom
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ASNOutItem
Tag Name
Table Name
Column Name
API Req
Description
item_id
container_item
item_id
Yes
*
unit_qty
container_item
unit_qty
Yes
*
priority_level
container_item
priority_level
No
*
order_line_nbr
*
*
No
*
lot_nbr
container
lot_nbr
No
*
final_location
*
*
No
*
from_disposition
*
*
No
*
to_disposition
*
*
No
*
voucher_number
*
*
No
*
voucher_expiration_date
*
*
No
*
container_qty
computed
*
No
*
comments
n/a
n/a
No
Not used in RWMS.
unit_cost
n/a
n/a
No
*
weight
*
*
*
*
weight_uom
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:CustRetDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
from_location
transshipment_setup
dc_dest_id
Yes
*
rma_nbr
returns_upload
rma_nbr
Yes
*
pro_nbr
returns_upload
pro_nbr
Yes
*
comments
returns_upload
comments
Yes
*
CustRetItem
*
*
*
*
return_date
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:CustRetItem
Tag Name
Table Name
Column Name
API Req
Description
item_id
returns_upload
item_id
Yes
*
CustRetItemQty
*
custretitemqty
Yes
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:CustRetItemQty
Tag Name
Table Name
Column Name
API Req
Description
unit_qty
returns_upload
unit_qty
Yes
*
from_wip
returns_upload
from_wip_code
Yes
*
to_wip
returns_upload
to_wip_code
Yes
*
from_disposition
returns_upload
from_disposition
Yes
*
to_disposition
returns_upload
to_disposition
Yes
*
saleable
returns_upload
saleable
Yes
*
CustRetItemQtyDtl
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:CustRetItemQtyDtl
Tag Name
Table Name
Column Name
API Req
Description
unit_qty
returns_upload
unit_qty
Yes
*
reason_code
returns_upload
reason_code
Yes
*
action_code
returns_upload
action_code
Yes
*
replacement_item
returns_upload
replacement_item
Yes
*
replace_unit_qty
returns_upload
replace_unit_qty
Yes
*
cust_ret_postage_amt
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_id
differentiator
diff_id
Yes
*
diff_type
differentiator
diff_type
Yes
*
diff_desc
differentiator
diff_desc
Yes
*
industry_code
n/a
n/a
No
Not used in RWMS.
industry_subcode
n/a
n/a
No
Not used in RWMS.
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffGrpDtlDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_group_id
diff_group_details
diff_group_id
Yes
*
diff_id
diff_group_details
diff_id
Yes
*
display_seq
*
*
No
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffGrpDtlRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_group_id
diff_group_details
diff_group_id
Yes
*
diff_id
diff_group_details
diff_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffGrpHdrDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_group_id
differentiator_group
diff_group_id
Yes
*
diff_group_type
differentiator_group
diff_group_type
Yes
*
diff_group_desc
differentiator_group
diff_group_desc
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffGrpRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_group_id
differentiator_group
diff_group_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:DiffRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
diff_id
differentiator
diff_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:InvAdjustDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dc_dest_id
transshipment_setup
dc_dest_id
Yes
*
InvAdjustDtl
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:InvAdjustDtl
Tag Name
Table Name
Column Name
API Req
Description
item_id
inv_adjustment_to_upload
item_id
Yes
*
adjustment_reason_code
inv_adjustment_to_upload
adjustment_reason_code
Yes
*
unit_qty
inv_adjustment_to_upload
unit_qty
Yes
*
transshipment_nbr
inv_adjustment_to_upload
transshipment_nbr
Yes
*
from_disposition
inv_adjustment_to_upload
from_disposition
Yes
*
to_disposition
inv_adjustment_to_upload
to_disposition
Yes
*
from_trouble_code
inv_adjustment_to_upload
from_trouble_code
Yes
*
to_trouble_code
inv_adjustment_to_upload
to_trouble_code
Yes
*
from_wip_code
inv_adjustment_to_upload
from_wip_code
Yes
*
to_wip_code
inv_adjustment_to_upload
to_wip_code
Yes
*
transaction_code
inv_adjustment_to_upload
transaction_code
Yes
*
user_id
inv_adjustment_to_upload
user_id
Yes
*
create_date
inv_adjustment_to_upload
create_date
Yes
*
po_nbr
inv_adjustment_to_upload
po_nbr
Yes
*
doc_type
po
doc_type
Yes
*
aux_reason_code
inv_adjustment_to_upload
aux_reason_code
Yes
*
weight
*
*
*
*
weight_uom
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ISCDimRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_supplier_country_dim
item_id
Yes
*
supplier
*
*
Yes
*
origin_country
*
*
*
*
dim_object
item_supplier_country_dim
dim_object
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ISCDimWHDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
dimobjectdesc
item_supp_country_dim
dim_object_desc
*
*
itemid
item_supp_country_dim
item_id
*
*
height
item_supp_country_dim
height
*
*
weight
item_supp_country_dim
weight
*
*
velocity
item_supp_country_dim
velocity
*
*
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
length
item_supp_country_dim
length
*
*
width
item_supp_country_dim
width
*
*
dimobject
item_supp_country_dim
dim_object
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ISCDimWHRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
itemid
item_supp_country_dim
item_id
*
*
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
vendornbr
item_supp_country_dim
vendor_nbr
*
*
origincountryid
item_supp_country_dim
origin_country_id
*
*
dimobject
item_supp_country_dim
dim_object
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemBOMRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
pack_no
bill_of_materials
master_item_id
Yes
*
item
bill_of_materials
component_item_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
ItemHdrDesc
*
*
*
*
ItemSupDesc
*
*
*
*
ItemSupCtyDesc
*
*
*
*
ISCDimDesc
*
*
*
*
ItemUDALOVDesc
*
*
*
*
ItemUDAFFDesc
*
*
*
*
ItemUDADateDesc
*
*
*
*
ItemImageDesc
*
*
*
*
ItemUPCDesc
*
*
*
*
ItemBOMDesc
*
*
*
*
ItemTcktDesc
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemHdrDesc
Tag Name
Table Name
Column Name
API Req
Description
item
item_master
item_id
Yes
*
item_number_type
*
*
*
*
format_id
n/a
n/a
No
Not used in RWMS.
prefix
n/a
n/a
No
Not used in RWMS.
item_parent
n/a
n/a
No
Not used in RWMS.
item_grandparent
n/a
n/a
No
Not used in RWMS.
pack_ind
n/a
n/a
No
Not used in RWMS.
item_level
n/a
n/a
No
Not used in RWMS.
tran_level
n/a
n/a
No
Not used in RWMS.
diff_1
item_differentiator
diff_id
No
*
diff_1_type
item_differentiator
diff_type
No
*
diff_2
item_differentiator
diff_id
No
*
diff_2_type
item_differentiator
diff_type
No
*
diff_3
item_differentiator
diff_id
No
*
diff_3_type
item_differentiator
diff_type
No
*
diff_4
item_differentiator
diff_id
No
*
diff_4_type
item_differentiator
diff_type
No
*
dept
item_master
department
No
*
dept_name
n/a
n/a
No
Not used in RWMS.
class
item_master
class
No
*
class_name
n/a
n/a
No
Not used in RWMS.
subclass
item_master
sub_class
No
*
sub_name
n/a
n/a
No
Not used in RWMS.
status
n/a
n/a
No
Not used in RWMS.
item_desc
item_master
description
No
*
short_desc
n/a
n/a
No
Not used in RWMS.
desc_up
n/a
n/a
No
Not used in RWMS.
primary_ref_item_ind
n/a
n/a
No
Not used in RWMS.
retail_zone_group_id
n/a
n/a
No
Not used in RWMS.
cost_zone_group_id
n/a
n/a
No
Not used in RWMS.
standard_uom
item_master
standard_uom
No
*
uom_conv_factor
item_master
uom_conv_factor
No
*
package_size
*
*
No
*
package_uom
*
*
No
*
merchandise_ind
*
*
No
*
store_ord_mult
*
*
No
*
forecast_ind
*
*
No
*
mfg_rec_retail
n/a
n/a
No
Not used in RWMS.
retail_label_type
n/a
n/a
No
Not used in RWMS.
retail_label_type_desc
n/a
n/a
No
Not used in RWMS.
retail_label_value
n/a
n/a
No
Not used in RWMS.
handling_temp
n/a
n/a
No
Not used in RWMS.
handling_temp_desc
n/a
n/a
No
Not used in RWMS.
handling_sensitivity
n/a
n/a
No
Not used in RWMS.
handling_sensitivity_desc
*
*
*
*
catch_weight_ind
item_master
catch_weight
No
*
waste_type
n/a
n/a
No
Not used in RWMS.
waste_type_desc
n/a
n/a
No
Not used in RWMS.
waste_pct
n/a
n/a
No
Not used in RWMS.
default_waste_pct
n/a
n/a
No
Not used in RWMS.
const_dimen_ind
n/a
n/a
No
Not used in RWMS.
simple_pack_ind
n/a
n/a
No
Not used in RWMS.
contains_inner_ind
n/a
n/a
No
Not used in RWMS.
sellable_ind
n/a
n/a
No
Not used in RWMS.
orderable_ind
n/a
n/a
No
Not used in RWMS.
pack_type
n/a
n/a
No
Not used in RWMS.
order_as_type
n/a
n/a
No
Not used in RWMS.
comments
n/a
n/a
No
Not used in RWMS.
unit_retail
item_master
retail_price
No
*
item_service_level
n/a
n/a
No
Not used in RWMS.
gift_wrap_ind
n/a
n/a
No
Not used in RWMS.
ship_alone_ind
item_master
ship_alone
No
*
vendor_style
item_master
vendor_style
No
*
std_unit_weight
item_master
std_unit_weight
No
*
single_price_flag
item_master
single_price_flag
No
*
preticket_flag
item_master
preticket_flag
No
*
planned_residual
item_master
planned_residual
No
*
autopackable
item_master
autopackable
No
*
sortable
item_master
sortable
No
*
item_master_uda1
item_master
item_master_uda1
No
*
item_master_uda2
item_master
item_master_uda2
No
*
item_master_uda3
item_master
item_master_uda3
No
*
item_master_uda4
item_master
item_master_uda4
No
*
item_master_uda5
item_master
item_master_uda5
No
*
item_master_uda6
item_master
item_master_uda6
No
*
item_master_uda7
item_master
item_master_uda7
No
*
item_master_uda8
item_master
item_master_uda8
No
*
item_master_uda9
item_master
item_master_uda9
No
*
item_master_uda10
item_master
item_master_uda10
No
*
item_master_uda11
item_master
item_master_uda11
No
*
item_master_uda12
item_master
item_master_uda12
No
*
item_master_uda13
item_master
item_master_uda13
No
*
item_master_uda14
item_master
item_master_uda14
No
*
item_master_uda15
item_master
item_master_uda15
No
*
ship_alone
item_master
ship_alone
No
*
slottable
item_master
slottable
No
*
freight_class
item_master
freight_class
No
*
new_item
item_master
new_item
No
*
brand
item_master
brand
No
*
break_case_ups
item_master
break_case_ups
No
*
rigid
item_master
rigid
No
*
fragile
item_master
fragile
No
*
container_type
item_master
container_type
No
*
conveyable_flag
item_master
conveyable_flag
No
*
hazard_matl_code
item_master
hazard_matl_code
No
*
velocity
item_master
velocity
No
*
high_value_ind
item_master
high_value_ind
No
*
ticket_type
item_master
ticket_type
No
*
color
item_master
color
No
*
size1
item_master
size1
No
*
fit
item_master
fit
No
*
shade
item_master
shade
No
*
single_contain_bulk
item_master
single_contain_bulk
No
*
unit_pick_system_code
item_master
unit_pick_system_code
No
*
roundable_flag
item_master
roundable_flag
No
*
perishable_ind
item_master
perishable_ind
No
*
division
item_master
division
No
*
vendor_nbr
item_master
vendor_nbr
No
*
kitting_wip_code
item_master
kitting_wip_code
No
*
unit_ticket_qty
item_master
unit_ticket_qty
No
*
item_length
item_master
item_length
No
*
item_width
item_master
item_width
No
*
item_height
item_master
item_height
No
*
item_weight
item_master
item_weight
No
*
item_cube
item_master
item_cube
No
*
std_unit_factor
item_master
std_unit_factor
No
*
std_unit_qty
item_master
std_unit_qty
No
*
expiration_days
item_master
expiration_days
No
*
putaway_by_volume
item_master
putaway_by_volume
No
*
putaway_plan
item_master
putaway_plan
No
*
item_type
item_master
item_type
No
*
sorter_group
item_master
sorter_group
No
*
sku_optimization
item_master
sku_optimization
No
*
ext_source_system
*
*
*
*
item_xform_ind
*
*
*
*
inventory_ind
*
*
*
*
order_type
*
*
*
*
sale_type
*
*
*
*
deposit_item_type
*
*
*
*
container_item
*
*
*
*
deposit_in_price_per_uom
*
*
*
*
transport_ind
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupDesc
Tag Name
Table Name
Column Name
API Req
Description
item
item_supplier
item_id
*
*
supplier
item_supplier
vendor_nbr
*
*
primary_supp_ind
item_supplier
primary_supp_ind
*
*
vpn
*
*
*
*
supp_label
*
*
*
*
consignment_rate
*
*
*
*
supp_diff_1
*
*
*
*
supp_diff_2
*
*
*
*
supp_diff_3
*
*
*
*
supp_diff_4
*
*
*
*
pallet_name
item_supplier
pallet_name
*
*
case_name
item_supplier
case_name
*
*
inner_name
item_supplier
inner_name
*
*
supp_discontinue_date
*
*
*
*
direct_ship_ind
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupCtyDesc
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
supplier
*
*
*
*
origin_country_id
*
*
*
*
primary_supp_ind
*
*
*
*
primary_country_ind
*
*
*
*
unit_cost
n/a
n/a
No
Not used in RWMS.
lead_time
item_supp_country
lead_time
No
*
pickup_lead_time
n/a
n/a
No
Not used in RWMS.
supp_pack_size
item_supp_country
supp_pack_size
No
*
inner_pack_size
*
*
*
*
round_lvl
n/a
n/a
No
Not used in RWMS.
min_order_qty
n/a
n/a
No
Not used in RWMS.
max_order_qty
n/a
n/a
No
Not used in RWMS.
packing_method
item_supp_country
packing_method
No
*
default_uop
n/a
n/a
No
Not used in RWMS.
ti
*
*
*
*
hi
*
*
*
*
cost_uom
*
*
*
*
tolerance_type
*
*
*
*
max_tolerance
*
*
*
*
min_tolerance
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ISCDimDesc
Tag Name
Table Name
Column Name
API Req
Description
item
item_supp_country_dim
item_id
Yes
*
supplier
item_supp_country_dim
vendor_nbr
Yes
*
origin_country
item_supp_country_dim
origin_country_id
Yes
*
dim_object
item_supp_country_dim
dim_object
Yes
*
object_desc
item_supp_country_dim
dim_object_desc
No
*
presentation_method
n/a
n/a
No
Not used in RWMS.
method_desc
n/a
n/a
No
Not used in RWMS.
length
item_supp_country_dim
length
No
*
width
item_supp_country_dim
width
No
*
height
item_supp_country_dim
height
No
*
lwh_uom
item_supp_country_dim
lwh_uom
No
*
weight
item_supp_country_dim
weight
No
*
net_weight
n/a
n/a
No
Not used in RWMS.
weight_uom
item_supp_country_dim
weight_uom
No
*
liquid_volume
item_supp_country_dim
liquid_volume
No
*
liquid_volume_uom
item_supp_country_dim
liquid_volume_uom
No
*
stat_cube
n/a
n/a
No
Not used in RWMS.
tare_weight
item_supp_country_dim
tare_weight
No
*
tare_type
item_supp_country_dim
tare_type
No
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDALOVDesc
Tag Name
Table Name
Column Name
API Req
Description
item
item_attributes
item_id
Yes
*
uda_id
item_attributes
attribute_type
Yes
*
uda_value
item_attributes
attribute
Yes
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDAFFDesc
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
uda_id
*
*
*
*
uda_text
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDADateDesc
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
uda_id
*
*
*
*
uda_date
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemImageDesc
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
image_name
*
*
*
*
image_addr
*
*
*
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUPCDesc
Tag Name
Table Name
Column Name
API Req
Description
item_id
item_upc
upc
Yes
*
item_parent
item_upc
item_id
No
*
primary_ref_item_ind
item_upc
primary_upc_ind
No
*
format_id
n/a
n/a
No
Not used in RWMS.
prefix
n/a
n/a
No
Not used in RWMS.
item_number_type
n/a
n/a
No
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemBOMDesc
Tag Name
Table Name
Column Name
API Req
Description
pack_no
bill_of_materials
master_item_id
Yes
*
item
bill_of_materials
component_item_id
Yes
*
pack_qty
bill_of_materials
unit_qty
Yes
*
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemTcktDesc
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
ticket_type_id
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemHdrWHDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
itemid
item_master
item_id
*
*
description
item_master
description
*
*
vendornbr
item_master
vendor_nbr
*
*
containertype
item_master
container_type
*
*
conveyableflag
item_master
conveyable_flag
*
*
stdunitqty
item_master
std_unit_qty
*
*
hazardmatlcode
item_master
hazard_matl_code
*
*
highvalueind
item_master
high_value_ind
*
*
department
item_master
department
*
*
class
item_master
class
*
*
singlecontainerbulk
item_master
single_contain_bulk
*
*
subclass
item_master
subclass
*
*
expirationdays
item_master
expiration_days
*
*
perishableind
item_master
perishable_ind
*
*
division
item_master
division
*
*
putawaybyvolume
item_master
putaway_by_volume
*
*
stdunitfactor
item_master
std_unit_factor
*
*
itemmasteruda1
item_master
item_master_uda1
*
*
itemmasteruda2
item_master
item_master_uda2
*
*
itemmasteruda3
item_master
item_master_uda3
*
*
itemmasteruda4
item_master
item_master_uda4
*
*
itemmasteruda5
item_master
item_master_uda5
*
*
itemmasteruda6
item_master
item_master_uda6
*
*
itemmasteruda7
item_master
item_master_uda7
*
*
itemmasteruda8
item_master
item_master_uda8
*
*
itemmasteruda9
item_master
item_master_uda9
*
*
itemmasteruda10
item_master
item_master_uda10
*
*
itemmasteruda11
item_master
item_master_uda11
*
*
itemmasteruda12
item_master
item_master_uda12
*
*
itemmasteruda13
item_master
item_master_uda13
*
*
itemmasteruda14
item_master
item_master_uda14
*
*
itemmasteruda15
item_master
item_master_uda15
*
*
nonsaleable
item_master
non_saleable
*
*
brand
item_master
brand
*
*
fragile
item_master
fragile
*
*
rigid
item_master
rigid
*
*
standarduom
item_master
standard_uom
*
*
uomconvfactor
item_master
uom_conv_factor
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_master
item_id
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupCtyRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_supp_country
item_id
Yes
*
supplier
item_supp_country
vendor_nbr
Yes
*
origin_country_id
item_supp_country
origin_country_id
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_supplier
item_id
Yes
*
supplier
item_supplier
vendor_nbr
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupWHDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
vendornbr
item_supplier
vendor_nbr
*
*
vpn
item_supplier
vpn
*
*
itemid
item_supplier
item_id
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemSupWHRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
vendornbr
item_supplier
vendor_nbr
*
*
itemid
item_supplier
item_id
*
*
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemTcktRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
ticket_type_id
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDADateRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
*
*
*
*
uda_id
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDAFFRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
uda_id
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUDALOVRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_attributes
item_id
Yes
*
uda_id
item_attributes
attribute_type
Yes
*
uda_value
item_attributes
attribute
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemUPCRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
item
item_upc
upc
Yes
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemWHDesc.xsd
Tag Name
Table Name
Column Name
API Req
Description
itemhdrwhdesc
*
*
*
*
itemsupwhdesc
*
*
*
*
itemsupctywhdesc
*
*
*
*
iscdimwhdesc
*
*
*
*
RIB Mappings Report Release: 13.0.0
Retail Integration Bus Mappings Report Release: 13.0.0
Application Name: Retail Warehouse Management System
Version 13.0.0
XML-Schema or Node Name:ItemWHRef.xsd
Tag Name
Table Name
Column Name
API Req
Description
from_location
transshipment_setup
dc_dest_id
*
*
to_location
*
*
*
*
itemid
item_master
item_id
*
*
RIB Mappings Report Release: 13.0.0