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/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:15.0.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. number 4 No Fill this description.
LocPOTsfDealsDesc:LocPOTsfDealsDesc * 0 unbounded Description is not available. NA NA NA NA NA NA

XML-Schema Name:LocPOTsfDealsDesc 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 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 deal_head Fill table column name. number 10 Yes Unique Deal number
deal_type varchar210 1 1 Not Yet Available deal_head type varchar2 10 Yes Type of the deal. Valid values are A for annual deal, P for promotional deal, O for PO-specific deal or M for vendor-funded markdown.
active_date xs:dateTime 1 1 Not Yet Available deal_head active_date date Fill column length. Yes This is the date the deal will become active
close_date xs:dateTime 0 1 Not Yet Available deal_head close_date date Fill column length. No Date the deal will/did end. This date determines when deal components are no longer factored into item costs.
deal_class varchar26 0 1 Not Yet Available deal_detail deal_class varchar2 6 No Identifies the calculation class of the deal component. Valid values are CU for cumulative (discounts are added together and taken off as one lump sum), CS for cascade (discounts are taken one at a time with subsequent discounts taken off the result of the previous discount) and EX for exclusive (overrides all other discounts). EX type deal components are only valid for promotional deals.
limit_type varchar26 0 1 Not Yet Available deal_head threshold_limit_type varchar2 6 No Identifies whether thresholds will be set up as qty values, currency amount values or percentages (growth rebates only). Valid values are Q for qty, A for currency amount or P for percentage.
value_type varchar26 0 1 Not Yet Available deal_detail THRESHOLD_VALUE_TYPE varchar2 6 No Identifies whether the discount values associated with the thresholds will be set up as qty values, currency amount values, percentages or fixed amounts. Valid values are Q for qty, A for currency amount, P for percentage or F for fixed amount. Qty threshold deals are only allowed on off-invoice discounts.
lower_limit number20 1 1 Not Yet Available deal_threshold lower_limit number 20 Yes Lower limit of the deal component. This is the minimum value that must be met in order to get the specified discount. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component.
upper_limit number20 1 1 Not Yet Available deal_threshold upper_limit number 20 Yes Upper limit of the deal component. This is the maximum value for which the specified discount will apply. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component.
value number20 1 1 Not Yet Available deal_threshold value number 20 Yes Value of the discount that will be given for meeting the specified thresholds for this deal component. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_value_type field of this deal component.