Retail Integration Mappings Report Release:14.1.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocPOTsfDealsColDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:LocPOTsfDealsColDesc Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocPOTsfDealsColDesc 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
collection_size number4 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
LocPOTsfDealsDesc:LocPOTsfDealsDesc * 0 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:LocPOTsfDealsDesc Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocPOTsfDealsDesc 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
deal_id number10 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
deal_type varchar210 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
active_date xs:dateTime 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
close_date xs:dateTime 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
deal_class varchar26 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
limit_type varchar26 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
value_type varchar26 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
lower_limit number20 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
upper_limit number20 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
value number20 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.