Retail Integration Mappings Report Release:16.0.21

(Retail Fiscal management)

Application Retail Fiscal management 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

XML-Schema Name:POScheduleDesc Version:16.0.21 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for POScheduleDesc in RFM application. RFM's Table Name RFM's Column Name Integration API(RIB or/and RSB or/and RSL) RFM's Column Length Is Column Required in RFM's API? RFM's API Description schedule_nbr number8 0 1 Contains the Inbound Schedule number created in RFM. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Contains the Inbound Schedule number created in RFM. physical_wh varchar210 0 1 Contains the Physical Warehouse number. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Contains the Physical Warehouse number POSchedule * 1 unbounded Contains the array of POSchedule records.

XML-Schema Name:POSchedule Version:16.0.21 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for POSchedule in RFM application. RFM's Table Name RFM's Column Name Integration API(RIB or/and RSB or/and RSL) RFM's Column Length Is Column Required in RFM's API? RFM's API Description requisition_nbr varchar212 0 1 Contains the PO number. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Contains the PO number. requisition_type varchar21 0 1 The requistion type will always be Purchase Order. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes The requistion type will always be Purchase Order. POScheduleDtl * 0 unbounded Contains the array of POSchedule Detail records.

XML-Schema Name:POScheduleDtl Version:16.0.21 Return to Top XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for POScheduleDtl in RFM application. RFM's Table Name RFM's Column Name Integration API(RIB or/and RSB or/and RSL) RFM's Column Length Is Column Required in RFM's API? RFM's API Description item_id varchar225 0 1 Contains the Item Number. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Contains the Item Number. consolidate_qty number12_4 0 1 Contains the consolidated quantities of the item in PO. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Contains the consolidated quantities of the item in PO.