Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrcCostColCriVo/v1
Version 1.0
Description This object holds a collection of PrcCostCol rows.
XSD Structure

XML-Schema Name:PrcCostColCriVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcCostColCriVo in RMS application.
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
PrcCostCriVo:PrcCostCriVo * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
collection_size number4 1 1 Number of items in the collection. n/a n/a number n/a Yes Number of items in the collection

XML-Schema Name:PrcCostCriVo Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrcCostCriVo in RMS application.
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
item varchar225 1 1 Contains the RMS item number that uniquely identifies the item. This is required input for the Pricing Cost Service future_cost item varchar2 25 Yes Contains the RMS item number that uniquely identifies the item.
source_location number10 0 1 Contains the RMS Supplier number for retrieving the Pricing Cost future_cost supplier number 10 No Contains the RMS Supplier number for retrieving the Pricing Cost.
source_location_country varchar23 0 1 Contains the country, supplier belongs to for which the Pricing Cost needs to be retrieved. future_cost origin_country_id varchar2 3 No Contains the country, supplier belongs to for which the Pricing Cost needs to be retrieved.
fulfill_location number10 1 1 Contains the location number . This is required input for the Pricing Cost Service. future_cost location number 10 Yes Contains the location number.
loc_type loc_type 1 1 Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). *. * varchar2 1 Yes Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse).
channel_id number4 0 1 Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. channels channel_id number 4 Yes Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel.
active_date xs:dateTime 0 1 Contains the active date for which the pricing cost needs to be retrieved. future_cost active_date date n/a No Contains the active date for which the pricing cost needs to be retrieved.