Retail Integration Mappings Report Release:15.0.0

Application	Retail Merchandising 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	WOOutRef WOOutDtlRef

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for WOOutRef in RMS application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	RMS's Table Name	RMS's Column Name	Integration API(RIB or/and RSB or/and RSL)	RMS's Column Length	Is Column Required in RMS's API?	RMS's API Description
wo_id	number15	1	1	NA	tsf_wo_head	tsf_wo_id	null	null	Yes	The work order number.
dc_dest_id	varchar210	1	1	NA	tsfhead	from_loc	null	null	Yes	The From location of the transfer.
distro_nbr	varchar212	1	1	NA	tsfhead	tsf_no	null	null	Yes	The transfer of which this work order is a part.
WOOutDtlRef	*	0	unbounded	NA
distro_parent_nbr	varchar212	0	1	The higher level transfer that this transfer belongs to.	tsfhead	tsf_parent_no	null	null	No	The higher level transfer to which this transfer belongs.

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for WOOutDtlRef in RMS application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	RMS's Table Name	RMS's Column Name	Integration API(RIB or/and RSB or/and RSL)	RMS's Column Length	Is Column Required in RMS's API?	RMS's API Description
dest_id	varchar210	1	1	NA	tsfhead	to_loc	null	null	Yes	The To location of the transfer.
item_id	varchar225	1	1	NA	tsf_wo_detail	item	null	null	Yes	The item for this portion of the work order.
wip_seq_nbr	number7	0	1	NA	*	*	null	null	No	Not used by RMS.
order_line_nbr	number20	0	1	NA	*	*	null	null	No	Not used by RMS.