Retail Integration Mappings Report Release:14.1.0 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/WOOutRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:WOOutRef Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutRef in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
wo_id number15 1 1 NA * * number 10 No Exists in code but not used
dc_dest_id varchar210 1 1 NA transshipment_setup dc_dest_id varchar2 10 Yes *
distro_nbr varchar212 1 1 NA outbound_work_order distro_nbr varchar2 12 Yes A number which uniquely identifies a distribution order.
WOOutDtlRef * 0 unbounded NA
distro_parent_nbr varchar212 0 1 The higher level transfer that this transfer belongs to. n/a n/a * * No Not used in RWMS

XML-Schema Name:WOOutDtlRef Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOOutDtlRef in RWMS application.
RWMS's Table Name RWMS's Column Name Integration API(RIB or/and RSB or/and RSL) RWMS's Column Length Is Column Required in RWMS's API? RWMS's API Description
dest_id varchar210 1 1 NA outbound_work_order dest_id varchar2 10 Yes A number which uniquely identifies a destination to which the DC delivers goods
item_id varchar225 1 1 NA outbound_work_order item_id varchar2 25 Yes Uniquely identifies the item. May consist of some combination of SKU, style, color, size, etc.
wip_seq_nbr number7 0 1 NA outbound_work_order wip_seq_nbr number 7 Yes Order in which WIP Codes are processed
order_line_nbr number20 0 1 NA outbound_work_order order_line_nbr number 4 Yes Order detail information