Retail Integration Mappings Report Release:15.0.0

Application	Retail Warehouse Management System
Target Name Space	http://www.oracle.com/retail/integration/base/bo/POScheduleDesc/v1
Version	1.0
Description	This is root element of this document which contains name space definitions for the document elements.
XSD Structure	POScheduleDesc POSchedule POScheduleDtl

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for POScheduleDesc in RWMS application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
schedule_nbr	number8	0	1	Contains the Inbound Schedule number created in RFM.	schedule	schd_nbr	number	8	Yes	Contains the Inbound Schedule number created in RFM.
physical_wh	varchar210	0	1	Contains the Physical Warehouse number.	transshipment_setup	dc _dest_id	varchar2	10	Yes	Contains the Physical Warehouse number
POSchedule	*	1	unbounded	Contains the array of POSchedule records.

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for POSchedule in RWMS application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
requisition_nbr	varchar212	0	1	Contains the PO number.	schedule_detail	po_nbr	varchar2	12	Yes	Contains the PO number for the schedule
requisition_type	varchar21	0	1	The requistion type will always be Purchase Order.	po	doc_type	varchar2	1	No	The requisition type will always be Purchase Order.'P'
POScheduleDtl	*	0	unbounded	Contains the array of POSchedule Detail records.

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for POScheduleDtl in RWMS application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	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
item_id	varchar225	0	1	Contains the Item Number.	schedule_detail	item_id	varchar2	25	Yes	Contains the Item Number in the PO
consolidate_qty	number12_4	0	1	Contains the consolidated quantities of the item in PO.	schedule_detail	unit_qty	number	12	Yes	Contains the consolidated quantities of the item in PO.