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/PrcCostColDesc/v1
Version 1.0
Description This object holds a collection of PrcCostDesc rows.
XSD Structure

XML-Schema Name:PrcCostColDesc 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 PrcCostColDesc 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
PrcCostDesc:PrcCostDesc * 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:PrcCostDesc 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 PrcCostDesc 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 Yes 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). Fill this description.
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 No 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 * No Contains the active date for which the pricing cost needs to be retrieved.
pricing_cost number20_4 1 1 Contains the retrieved pricing cost from the future cost table for the passed parameters. future_cost pricing_cost number 20 Yes Contains the RMS Supplier number for retrieving the Pricing Cost.