Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:AddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
city_id varchar210 0 1 Indicates the City Id or Code. NA NA NA NA NA NA
state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA
addr number11 1 1 Description is not available. * * number 6 * *
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. * * varchar2 2 * *
primary_addr_type_ind varchar21 1 1 Description is not available. * * varchar2 1 * *
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type * * varchar2 1 * *
add_1 varchar2240 1 1 Description is not available. * * varchar2 240 * *
add_2 varchar2240 0 1 Description is not available. * * varchar2 240 * *
add_3 varchar2240 0 1 Description is not available. * * varchar2 240 * *
city varchar2120 1 1 Description is not available. * * varchar2 120 * *
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. * * varchar2 3 * *
country_id varchar23 1 1 Description is not available. * * varchar2 3 * *
post varchar230 0 1 Description is not available. * * varchar2 30 * *
contact_name varchar2120 0 1 Description is not available. * * varchar2 120 * *
contact_phone varchar220 0 1 Description is not available. * * varchar2 20 * *
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. * * varchar2 20 * *
contact_fax varchar220 0 1 Description is not available. * * varchar2 20 * *
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. * * varchar2 100 * *
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. * * number 15 * *
county varchar220 0 1 Description is not available. * * varchar2 250 * *
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. NA NA NA NA NA NA
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA
LocOfAddrDesc:LocOfAddrDesc * 0 1 Provide an extension hook to localize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ClrPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location number 10 Yes Unique identifier that indicates a Location (Store or Warehouse).
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type varchar2 30 Yes Identifier that indicates whether a location is a Store (S) or a Warehouse (W).
ClrPrcChgDtl * 1 unbounded Description is not available.
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDesc * 0 1 Provide an extension hook to customize ClrPrcChgDesc. NA NA NA NA NA NA
LocOfClrPrcChgDesc:LocOfClrPrcChgDesc * 0 1 Provide an extension hook to localize ClrPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:ClrPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
clearance_id Number15 1 1 Not Yet Available rpm_clearance_payload clearance_id number 15 Yes Clearance Id
item varchar225 1 1 Not Yet Available rpm_clearance_payload item varchar2 25 Yes Item Number
effective_date xs:dateTime 1 1 Not Yet Available rpm_clearance_payload effective_date date Yes Effective date of the clearance
selling_unit_retail number20_4 1 1 Not Yet Available rpm_clearance_payload selling_retail number 20 Yes Clearance selling retail
selling_uom varchar24 1 1 Not Yet Available rpm_clearance_payload selling_retail_uom varchar2 25 Yes Clearance selling UOM
selling_currency Varchar23 1 1 NA rpm_clearance_payload selling_retail_currency varchar2 25 Yes Clearance selling currency
reset_clearance_id Number15 0 1 NA rpm_clearance_payload reset_clearance_id number 15 No Clearance reset id
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDtl * 0 1 Provide an extension hook to customize ClrPrcChgDtl. NA NA NA NA NA NA
LocOfClrPrcChgDesc:LocOfClrPrcChgDtl * 0 1 Provide an extension hook to localize ClrPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfClrPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgDesc:InClrPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgDesc:BrClrPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfClrPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgDesc:InClrPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgDesc:BrClrPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/ClrPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ClrPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_clearance_payload location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse).
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_clearance_payload location_type VARCHAR2 30 * Identifier that indicates whether a location is a Store (S) or a Warehouse (W).
ClrPrcChgDtlRef * 1 unbounded Description is not available.
ExtOfClrPrcChgRef:ExtOfClrPrcChgRef * 0 1 Provide an extension hook to customize ClrPrcChgRef. NA NA NA NA NA NA
LocOfClrPrcChgRef:LocOfClrPrcChgRef * 0 1 Provide an extension hook to localize ClrPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:ClrPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ClrPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
clearance_id number15 1 1 NA rpm_clearance_payload clearance_id NUMBER 15 Yes Clearance Id
item varchar225 1 1 NA rpm_clearance_payload item VARCHAR2 25 * Item Number
ExtOfClrPrcChgRef:ExtOfClrPrcChgDtlRef * 0 1 Provide an extension hook to customize ClrPrcChgDtlRef. NA NA NA NA NA NA
LocOfClrPrcChgRef:LocOfClrPrcChgDtlRef * 0 1 Provide an extension hook to localize ClrPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfClrPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgRef:InClrPrcChgDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgRef:BrClrPrcChgDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfClrPrcChgRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfClrPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgRef:InClrPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgRef:BrClrPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfAddrDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfClrPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfClrPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgDesc:InClrPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgDesc:BrClrPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfClrPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfClrPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfClrPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InClrPrcChgRef:InClrPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrClrPrcChgRef:BrClrPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfPrmPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfPrmPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfPrmPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfPrmPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgRef:InPrmPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgRef:BrPrmPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfPromotionDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfPromotionDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPromotionDesc
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InPromotionDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrPromotionDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfPromotionRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfPromotionRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPromotionRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InPromotionRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrPromotionRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfRegPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfRegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfRegPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfRegPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgRef:InRegPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgRef:BrRegPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/LocOfStoreDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:LocOfStoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description
InStoreDesc:InStoreDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrStoreDesc:BrStoreDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:PrmPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_promo_zone_location location number 10 * Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_promo_zone_location zone_node_type number 2 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtl * 1 unbounded Description is not available.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDesc * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgDesc * 0 1 Provide an extension hook to localize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
promo_id number10 1 1 Promotion Id rpm_promo promo_id number 10 * Promotion Id
promo_name varchar240 0 1 Promotion Name rpm_promo name varchar2 160 * Promotion Name
promo_description varchar2160 0 1 Promotion Description rpm_promo description varchar2 640 * Promotion Description
promo_comp_id number10 1 1 Promotion Component Id rpm_promo_comp promo_comp_id number 10 * Promotion Component Id
promo_comp_desc varchar240 0 1 Promotion Component Description rpm_promo_comp name varchar2 160 * Promotion Component Description
promo_comp_detail_id number10 1 1 Promotion Component Detail Id rpm_promo_dtl promo_dtl_id number 10 * Promotion Component Detail Id
apply_order number1 1 1 The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location rpm_future_retail * null null * The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location
start_date xs:dateTime 1 1 Start date of the promotion component detail rpm_promo_dtl start_date date * Start date of the promotion component detail
end_date xs:dateTime 0 1 End date of the promotion component detail rpm_promo_dtl end_date date * End date of the promotion component detail
PrmPrcChgSmp * 0 unbounded Description is not available.
PrmPrcChgThr * 0 unbounded Description is not available.
PrmPrcChgBuyGet * 0 unbounded Description is not available.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDtl * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgDtl * 0 1 Provide an extension hook to localize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmp Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgSmp
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number
promo_selling_retail number20 1 1 Simple Promotion selling retail rpm_future_retail simple_promo_retail number 20,4 * Simple Promotion selling retail
promo_selling_uom xs:string 1 1 Simple promotion selling UOM rpm_future_retail simple_promo_uom varchar2 4 * Simple promotion selling UOM
prm_chg_type varchar21 1 1 Simple Promotion change type rpm_promo_dtl_disc_ladder change_type number 2 * Simple Promotion change type
prm_chg_value number20 1 1 Simple Promotion change value rpm_promo_dtl_disc_ladder change_amt or change_percent number 20,4 * Simple Promotion change value
prm_chg_uom varchar24 0 1 Simple Promotion change selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 * Simple Promotion change selling UOM
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgSmp * 0 1 Provide an extension hook to customize PrmPrcChgSmp. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgSmp * 0 1 Provide an extension hook to localize PrmPrcChgSmp. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgSmp Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgSmp
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgSmp Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgSmp
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgSmp * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgSmp * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThr Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThr
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Item number rpm_promo_dtl_merch_node item varchar2 25 * Item number
threshold_id number6 1 1 Threshold Id rpm_threshold threshold_id number 6 * Threshold Id
threshold_name varchar230 0 1 Threshold Name rpm_threshold name varchar2 120 * Threshold Name
qualification_type number1 1 1 Threshold Qualification Type rpm_threshold qualification_type number 1 * Threshold Qualification Type
threshold_type varchar21 1 1 Threshold Type rpm_threshold_interval threshold_type number 1 * Threshold Type
prm_chg_type varchar21 1 1 Threshold Discount Change Type rpm_promo_dtl_disc_ladder change_type number 2 * Threshold Discount Change Type
PrmPrcChgThrDtl * 1 unbounded Description is not available.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThr * 0 1 Provide an extension hook to customize PrmPrcChgThr. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgThr * 0 1 Provide an extension hook to localize PrmPrcChgThr. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThrDtl
Table Name Column Name API Type Column Length API Required API Description
threshold_value number20 1 1 Threshold Interval Value rpm_threshold_interval threshold_amount number 20,4 * Threshold Interval Value
prm_chg_value number20 1 1 Threshold Change Value rpm_threshold_interval change_amt or change_percent number 20,4 * Threshold Change Value
prm_chg_uom varchar24 0 1 Threshold Change Selling UOM rpm_threshold_interval change_uom varchar2 4 * Threshold Change Selling UOM
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThrDtl * 0 1 Provide an extension hook to customize PrmPrcChgThrDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgThrDtl * 0 1 Provide an extension hook to localize PrmPrcChgThrDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThrDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgThrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgThrDtl
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgThrDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgThrDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThr Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThr
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgThr Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgThr
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgThr * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgThr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgBuyGet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgBuyGet
Table Name Column Name API Type Column Length API Required API Description
prm_chg_type varchar21 1 1 Buy Get discount change type rpm_promo_dtl_disc_ladder change_type number 2 * Buy Get discount change type
prm_chg_value number20 1 1 Buy Get Discount Change Value rpm_promo_dtl_disc_ladder change_amount or change_percent number 20,4 * Buy Get Discount Change Value
prm_chg_uom varchar24 0 1 Buy Get Change Selling UOM rpm_promo_dtl_disc_ladder change_selling_uom varchar2 4 change_selling_uom Buy Get Change Selling UOM
buy_qty number20 1 1 Buy quantity rpm_promo_dtl_disc_ladder qual_value number 20,4 * Buy quantity
all_ind number1 1 1 Buy All Indicator rpm_promo_dtl_disc_ladder qual_type number 2 * All Indicator
PrmPrcChgGetItem * 1 unbounded Description is not available.
PrmPrcChgBuyItem * 1 unbounded Description is not available.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyGet * 0 1 Provide an extension hook to customize PrmPrcChgBuyGet. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgBuyGet * 0 1 Provide an extension hook to localize PrmPrcChgBuyGet. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgGetItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgGetItem
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Get Item rpm_promo_dtl_merch_node item varchar2 25 * Get Item
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgGetItem * 0 1 Provide an extension hook to customize PrmPrcChgGetItem. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgGetItem * 0 1 Provide an extension hook to localize PrmPrcChgGetItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgGetItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgGetItem
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgGetItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgGetItem
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgGetItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgGetItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgBuyItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgBuyItem
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Buy Item rpm_promo_dtl_merch_node item varchar2 25 * Buy Item
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyItem * 0 1 Provide an extension hook to customize PrmPrcChgBuyItem. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgBuyItem * 0 1 Provide an extension hook to localize PrmPrcChgBuyItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgBuyItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgBuyItem
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgBuyItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgBuyItem
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgBuyItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgBuyItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgBuyGet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgBuyGet
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgBuyGet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgBuyGet
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgBuyGet * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgBuyGet * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrmPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:PrmPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Description is not available. rpm_future_retail location NUMBER 10 * Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_future_retail zone_node_type NUMBER 6 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
PrmPrcChgDtlRef * 1 unbounded Description is not available. NA NA NA NA NA NA
ExtOfPrmPrcChgRef:ExtOfPrmPrcChgRef * 0 1 Provide an extension hook to customize PrmPrcChgRef. NA NA NA NA NA NA
LocOfPrmPrcChgRef:LocOfPrmPrcChgRef * 0 1 Provide an extension hook to localize PrmPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
promo_comp_detail_id number10 1 1 Description is not available. NA NA NA NA NA NA
PrmPrcChgSmpDtlRe * 0 unbounded Description is not available. NA NA NA NA NA NA
PrmPrcChgThrDtlRe * 0 unbounded Description is not available. NA NA NA NA NA NA
ExtOfPrmPrcChgRef:ExtOfPrmPrcChgDtlRef * 0 1 Provide an extension hook to customize PrmPrcChgDtlRef. NA NA NA NA NA NA
LocOfPrmPrcChgRef:LocOfPrmPrcChgDtlRef * 0 1 Provide an extension hook to localize PrmPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmpDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgSmpDtlRe
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 NA NA NA NA NA NA NA
ExtOfPrmPrcChgRef:ExtOfPrmPrcChgSmpDtlRe * 0 1 Provide an extension hook to customize PrmPrcChgSmpDtlRef. NA NA NA NA NA NA
LocOfPrmPrcChgRef:LocOfPrmPrcChgSmpDtlRe * 0 1 Provide an extension hook to localize PrmPrcChgSmpDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgSmpDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgSmpDtlRe
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgSmpDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgSmpDtlRe
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgRef:InPrmPrcChgSmpDtlRe * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgRef:BrPrmPrcChgSmpDtlRe * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThrDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PrmPrcChgThrDtlRe
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 NA NA NA NA NA NA NA
ExtOfPrmPrcChgRef:ExtOfPrmPrcChgThrDtlRe * 0 1 Provide an extension hook to customize PrmPrcChgThrDtlRef. NA NA NA NA NA NA
LocOfPrmPrcChgRef:LocOfPrmPrcChgThrDtlRe * 0 1 Provide an extension hook to localize PrmPrcChgThrDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThrDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgThrDtlRe
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgThrDtlRe Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgThrDtlRe
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgRef:InPrmPrcChgThrDtlRe * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgRef:BrPrmPrcChgThrDtlRe * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgRef:InPrmPrcChgDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgRef:BrPrmPrcChgDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPrmPrcChgRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPrmPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPrmPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgRef:InPrmPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgRef:BrPrmPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:PromotionDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PromotionDesc
Table Name Column Name API Type Column Length API Required API Description
promo_id number10 1 1 Promotion ID * * * * * *
promo_name varchar2160 0 1 Promotion Header Name * * * * * *
promo_description varchar2640 0 1 Promotion Header Description * * * * * *
promo_comp_id number10 1 1 Promotion Component Id * * * * * *
promo_comp_desc varchar2160 0 1 Promotion Component Name * * * * * *
promo_comp_type number2 1 1 Promotion Component Type * * * * * *
promo_dtl_id number10 1 1 Promotion Component Detail Id * * * * * *
apply_order number6 1 1 Application Order of the Promotion * * * * * *
start_date xs:dateTime 1 1 Start Date of Promotion Component Detail * * * * * *
end_date xs:dateTime 0 1 End Date of Promotion Component Detail * * * * * *
exception_parent_id number10 0 1 NA * * * * * *
LocationList * 1 unbounded Description is not available.
ListGroup * 1 unbounded Description is not available.
ItemLocSimpleRet * 0 unbounded Description is not available.
customer_type_id number10 0 1 Customer Type. * * * * * *
CreditDetail * 0 unbounded Description is not available.
ExtOfPromotionDesc:ExtOfPromotionDesc * 0 1 Provide an extension hook to customize PromotionDesc. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfPromotionDesc * 0 1 Provide an extension hook to localize PromotionDesc. NA NA NA NA NA NA

XML-Schema Name:LocationList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocationList
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 NA * * * * * *
loc_type varchar22 1 1 null * * * * * *
ExtOfPromotionDesc:ExtOfLocationList * 0 1 Provide an extension hook to customize LocationList. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfLocationList * 0 1 Provide an extension hook to localize LocationList. NA NA NA NA NA NA

XML-Schema Name:ExtOfLocationList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfLocationList
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfLocationList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfLocationList
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InLocationList * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrLocationList * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ListGroup Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ListGroup
Table Name Column Name API Type Column Length API Required API Description
listgroup_id number10 1 1 NA * * * * * *
ListDtl * 1 unbounded Description is not available.
ExtOfPromotionDesc:ExtOfListGroup * 0 1 Provide an extension hook to customize ListGroup. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfListGroup * 0 1 Provide an extension hook to localize ListGroup. NA NA NA NA NA NA

XML-Schema Name:ListDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ListDtl
Table Name Column Name API Type Column Length API Required API Description
listdtl_id number10 1 1 NA RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id
reward_application number1 0 1 NA RPM_PROMO_DTL_LIST_PAYLOAD REWARD_APPLICATION NUMBER 1 No Reward Application
description varchar2160 0 1 null RPM_PROMO_DTL_LIST_PAYLOAD DESCRIPTION VARCHAR2 120 No Description
DiscountLadder * 0 unbounded Description is not available.
ItemList * 1 unbounded Description is not available.
ExtOfPromotionDesc:ExtOfListDtl * 0 1 Provide an extension hook to customize ListDtl. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfListDtl * 0 1 Provide an extension hook to localize ListDtl. NA NA NA NA NA NA

XML-Schema Name:DiscountLadder Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For DiscountLadder
Table Name Column Name API Type Column Length API Required API Description
chg_type number2 0 1 Change Type RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_TYPE NUMBER 2 No Change Type
chg_amt number20_4 0 1 Change Amount RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_AMOUNT NUMBER 20 No Change Amount
chg_currency varchar23 0 1 NA RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_CURRENCY VARCHAR2 3 No Change Currency
chg_percent number20_4 0 1 Change Percent RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_PERCENT NUMBER 20 No Change Percent
chg_selling_uom varchar24 0 1 Change Selling UOM RPM_PROMO_DISC_LDR_PAYLOAD CHANGE_SELLING_UOM VARCHAR2 4 No Selling UOM
qual_type number2 0 1 NA RPM_PROMO_DISC_LDR_PAYLOAD QUAL_TYPE NUMBER 2 No Qualification Type
qual_value number20_4 0 1 NA RPM_PROMO_DISC_LDR_PAYLOAD QUAL_VALUE NUMBER 20 No Qualification Value
chg_duration number20_4 0 1 Change duration RPM_PROMO_DISC_LDR_PAYLOAD DURATION NUMBER 10 No Change Duration
ExtOfPromotionDesc:ExtOfDiscountLadder * 0 1 Provide an extension hook to customize DiscountLadder. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfDiscountLadder * 0 1 Provide an extension hook to localize DiscountLadder. NA NA NA NA NA NA

XML-Schema Name:ExtOfDiscountLadder Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfDiscountLadder
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfDiscountLadder Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfDiscountLadder
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InDiscountLadder * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrDiscountLadder * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ItemList
Table Name Column Name API Type Column Length API Required API Description
item_num varchar225 1 1 NA RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 Yes Item Number
ExtOfPromotionDesc:ExtOfItemList * 0 1 Provide an extension hook to customize ItemList. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfItemList * 0 1 Provide an extension hook to localize ItemList. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfItemList
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemList Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfItemList
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InItemList * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrItemList * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfListDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfListDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfListDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfListDtl
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InListDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrListDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfListGroup Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfListGroup
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfListGroup Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfListGroup
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InListGroup * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrListGroup * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ItemLocSimpleRet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ItemLocSimpleRet
Table Name Column Name API Type Column Length API Required API Description
item_num varchar225 1 1 Transaction Item Identifier RPM_PROMO_ITEM_LOC_SR_PAYLOAD ITEM VARCHAR2 25 No Item Number
location number10 1 1 Store ID RPM_PROMO_ITEM_LOC_SR_PAYLOAD LOCATION NUMBER 10 No Location
selling_retail number20_4 0 1 Selling retail of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_retail NUMBER 20 No Selling Retail
selling_uom varchar24 0 1 Selling UOM of the item RPM_PROMO_ITEM_LOC_SR_PAYLOAD selling_uom VARCHAR2 4 No Selling UOM
ExtOfPromotionDesc:ExtOfItemLocSimpleRet * 0 1 Provide an extension hook to customize ItemList. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfItemLocSimpleRet * 0 1 Provide an extension hook to localize ItemList. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemLocSimpleRet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfItemLocSimpleRet
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemLocSimpleRet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfItemLocSimpleRet
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InItemLocSimpleRet * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrItemLocSimpleRet * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:CreditDetail Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For CreditDetail
Table Name Column Name API Type Column Length API Required API Description
creditDetail_id number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD FINANCE_DTL_ID NUMBER 10 No Credit Detail Id
creditType varchar240 1 1 RPM_PROMO_FIN_DTL_PAYLOAD CARD_TYPE VARCHAR2 25 No Card Type
binNumberFrom number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD BIN_FROM_VALUE NUMBER 16 No Bin From Value
binNumberTo number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD BIN_TO_VALUE NUMBER 16 No Bin To Value
commisionRate number10 1 1 RPM_PROMO_FIN_DTL_PAYLOAD COMMISSION_RATE NUMBER 20 No Commission Rate
comments varchar2160 1 1 RPM_PROMO_FIN_DTL_PAYLOAD COMMENTS VARCHAR2 1000 No Comments
ExtOfPromotionDesc:ExtOfCreditDetail * 0 1 Provide an extension hook to customize ItemList. NA NA NA NA NA NA
LocOfPromotionDesc:LocOfCreditDetail * 0 1 Provide an extension hook to localize ItemList. NA NA NA NA NA NA

XML-Schema Name:ExtOfCreditDetail Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfCreditDetail
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfCreditDetail Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfCreditDetail
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InCreditDetail * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrCreditDetail * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPromotionDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPromotionDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPromotionDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPromotionDesc
Table Name Column Name API Type Column Length API Required API Description
InPromotionDesc:InPromotionDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionDesc:BrPromotionDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PromotionRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:PromotionRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For PromotionRef
Table Name Column Name API Type Column Length API Required API Description
promo_id number10 1 1 Promotion ID RPM_PROMO_DTL_PAYLOAD PROMO_ID NUMBER 10 Yes Promotion Id
promo_comp_id number10 1 1 Promotion Component ID RPM_PROMO_DTL_PAYLOAD PROMO_COMP_ID NUMBER 10 Yes Promotion Component Id
promo_dtl_id number10 1 1 Description is not available. RPM_PROMO_DTL_PAYLOAD PROMO_DTL_ID NUMBER 10 Yes Promotion Detail Id
LocationListRef * 1 unbounded Description is not available.
ListGroupRef * 1 unbounded Description is not available.
ExtOfPromotionRef:ExtOfPromotionRef * 0 1 Provide an extension hook to customize PromotionRef. NA NA NA NA NA NA
LocOfPromotionRef:LocOfPromotionRef * 0 1 Provide an extension hook to localize PromotionRef. NA NA NA NA NA NA

XML-Schema Name:LocationListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocationListRef
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Store ID RPM_PROMO_LOCATION_PAYLOAD LOCATION NUMBER 10 Yes Location Id
ExtOfPromotionRef:ExtOfLocationListRef * 0 1 Provide an extension hook to customize LocationListRef. NA NA NA NA NA NA
LocOfPromotionRef:LocOfLocationListRef * 0 1 Provide an extension hook to localize LocationListRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfLocationListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfLocationListRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfLocationListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfLocationListRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InLocationListRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrLocationListRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ListGroupRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ListGroupRef
Table Name Column Name API Type Column Length API Required API Description
listgroup_id number10 1 1 Description is not available. RPM_PROMO_DTL_LIST_GRP_PAYLOAD PROMO_DTL_LIST_GRP_ID NUMBER 10 Yes Promotion Detail List Group Id
ListDtlRef * 1 unbounded Description is not available.
ExtOfPromotionRef:ExtOfListGroupRef * 0 1 Provide an extension hook to customize ListGroupRef. NA NA NA NA NA NA
LocOfPromotionRef:LocOfListGroupRef * 0 1 Provide an extension hook to localize ListGroupRef. NA NA NA NA NA NA

XML-Schema Name:ListDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ListDtlRef
Table Name Column Name API Type Column Length API Required API Description
listdtl_id number10 1 1 Description is not available. RPM_PROMO_DTL_LIST_PAYLOAD PROMO_DTL_LIST_ID NUMBER 10 Yes Promotion Detail List Id
ItemListRef * 1 unbounded Description is not available. NA NA NA NA NA NA
ExtOfPromotionRef:ExtOfListDtlRef * 0 1 Provide an extension hook to customize ListDtlRef. NA NA NA NA NA NA
LocOfPromotionRef:LocOfListDtlRef * 0 1 Provide an extension hook to localize ListDtlRef. NA NA NA NA NA NA

XML-Schema Name:ItemListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ItemListRef
Table Name Column Name API Type Column Length API Required API Description
item_num varchar225 1 1 Item ID RPM_PROMO_ITEM_PAYLOAD ITEM VARCHAR2 25 * Item Number
ExtOfPromotionRef:ExtOfItemListRef * 0 1 Provide an extension hook to customize ItemListRef. NA NA NA NA NA NA
LocOfPromotionRef:LocOfItemListRef * 0 1 Provide an extension hook to localize ItemListRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfItemListRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfItemListRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfItemListRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InItemListRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrItemListRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfListDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfListDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfListDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfListDtlRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InListDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrListDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfListGroupRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfListGroupRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfListGroupRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfListGroupRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InListGroupRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrListGroupRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPromotionRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfPromotionRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPromotionRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfPromotionRef
Table Name Column Name API Type Column Length API Required API Description
InPromotionRef:InPromotionRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrPromotionRef:BrPromotionRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Unique identifier that indicates a Location (Store or Warehouse) rpm_future_retail location NUMBER 10 Yes Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Indicates the type of location which has requested tickets. Valid values for this field are: 'W' (for warehouse) and 'S' (for store). rpm_future_retail zone_node_type NUMBER 6 Yes Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtl * 1 unbounded Description is not available.
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDesc * 0 1 Provide an extension hook to customize RegPrcChgDesc. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDesc * 0 1 Provide an extension hook to localize RegPrcChgDesc. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
price_change_id number15 1 1 Contains the ID of the price change that initiated the ticket request. rpm_price_change price_change_id NUMBER 15 Yes Price Change Id
item varchar225 1 1 Alphanumeric value that identifies the item for which tickets have been requested. rpm_future_retail item VARCHAR2 25 Yes Item number
effective_date xs:dateTime 1 1 Price Change Effective Date rpm_future_retail action_date DATE null Yes Price Change Effective Date
selling_retail_changed_ind number1 1 1 Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_future_retail_gtt pc_selling_retail_ind NUMBER 1 Yes Indicate whether the regular selling retail is change by the Price Change
selling_unit_retail number20_4 1 1 This field contains the unit retail for the item at the indicated location. rpm_future_retail selling_retail NUMBER 20,4 Yes Regular selling retail
selling_uom varchar24 1 1 Holds the selling unit of measure for an item's single-unit retail. rpm_future_retail selling_uom VARCHAR2 2 Yes Regular Selling UOM
selling_currency varchar23 1 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_future_retail selling_retail currency VARCHAR2 3 Yes Regular Selling Retail Currency
multi_unit_changed_ind number1 1 1 Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. rpm_future_retail_gtt pc_multi_unit_ind NUMBER 1 Yes Indicate whether the Multi Unit Selling Retail is changed by the Price Change
multi_units number12_4 0 1 The number that indicate how many item is priced in the multi unit selling retail rpm_future_retail multi_units NUMBER 12, 4 No The number that indicate how many item is priced in the multi unit selling retail
multi_unit_retail number20_4 0 1 This field contains the multi-unit retail for the item at the indicated location. rpm_future_retail multi_unit_retail NUMBER 20,4 No Multi Unit Selling Retail
multi_unit_retail_currency varchar23 0 1 Contains the currency code that should match the store's or warehouse's currency code. rpm_future_retail multi_unit_retail_currency VARCHAR2 3 No Multi Unit Retail Currency
multi_selling_uom varchar24 0 1 Multi Unit Selling UOM rpm_future_retail multi_selling_uom VARCHAR2 4 No Multi Unit Selling UOM
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl * 0 1 Provide an extension hook to customize RegPrcChgDtl. NA NA NA NA NA NA
LocOfRegPrcChgDesc:LocOfRegPrcChgDtl * 0 1 Provide an extension hook to localize RegPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRegPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRegPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgDesc:InRegPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgDesc:BrRegPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/RegPrcChgRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:RegPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
location number10 1 1 Description is not available. rpm_future_retail location NUMBER 10 * Unique identifier that indicates a Location (Store or Warehouse)
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') rpm_future_retail zone_node_type NUMBER 6 * Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W')
RegPrcChgDtlRef * 1 unbounded NA
ExtOfRegPrcChgRef:ExtOfRegPrcChgRef * 0 1 Provide an extension hook to customize RegPrcChgRef. NA NA NA NA NA NA
LocOfRegPrcChgRef:LocOfRegPrcChgRef * 0 1 Provide an extension hook to localize RegPrcChgRef. NA NA NA NA NA NA

XML-Schema Name:RegPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For RegPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
price_change_id number15 1 1 Description is not available. rpm_price_change price_change_id NUMBER 15 * Price Change ID
item varchar225 1 1 Description is not available. rpm_future_retail item VARCHAR2 25 * Item number
ExtOfRegPrcChgRef:ExtOfRegPrcChgDtlRef * 0 1 Provide an extension hook to customize RegPrcChgDtlRef. NA NA NA NA NA NA
LocOfRegPrcChgRef:LocOfRegPrcChgDtlRef * 0 1 Provide an extension hook to localize RegPrcChgDtlRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRegPrcChgDtlRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgDtlRef
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgRef:InRegPrcChgDtlRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgRef:BrRegPrcChgDtlRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfRegPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfRegPrcChgRef
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfRegPrcChgRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfRegPrcChgRef
Table Name Column Name API Type Column Length API Required API Description
InRegPrcChgRef:InRegPrcChgRef * 0 unbounded India Localization. NA NA NA NA NA NA
BrRegPrcChgRef:BrRegPrcChgRef * 0 unbounded Brazil Localization. NA NA NA NA NA NA

RIB Mappings Report Release:13.2.0
Retail Integration Bus Mappings Report Release:13.2.0 (Retail Price Management)
Application Retail Price Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:StoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For StoreDesc
Table Name Column Name API Type Column Length API Required API Description
store number10 1 1 Description is not available. rpm_zone_location location null null Yes *
store_type varchar21 1 1 Description is not available. NA NA NA NA NA NA
store_name varchar2150 1 1 Description is not available. * * varchar2 150 * *
store_name10 varchar210 0 1 Description is not available. * * varchar2 10 * *
store_name3 varchar23 0 1 Description is not available. * * varchar2 3 * *
store_add1 varchar2240 0 1 Description is not available. * * varchar2 240 * *
store_add2 varchar2240 0 1 Description is not available. * * varchar2 240 * *
store_city varchar2120 0 1 Description is not available. * * varchar2 120 * *
county varchar2250 0 1 Description is not available. * * varchar2 250 * *
state varchar23 0 1 Description is not available. * * varchar2 3 * *
country_id varchar23 0 1 Description is not available. * * varchar2 3 * *
store_pcode varchar230 0 1 Description is not available. * * varchar2 30 * *
store_class varchar21 0 1 Contains the code letter indicating the class of which the store is a member. Valid values are A through E. * * varchar2 1 * *
store_mgr_name varchar2120 0 1 Description is not available. * * varchar2 120 * *
store_open_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
store_close_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
acquired_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
remodel_date xs:dateTime 0 1 Description is not available. * * RIBDate * * *
fax_number varchar220 0 1 This type can hold a number of digits count mber. * * varchar2 20 * *
phone_number varchar220 0 1 This type can hold a number of digits count number. * * varchar2 20 * *
email varchar2100 0 1 Description is not available. * * varchar2 100 * *
total_square_ft number8 0 1 Description is not available. * * number 8 * *
selling_square_ft number8 0 1 Description is not available. * * number 8 * *
linear_distance number8 0 1 Description is not available. * * number 8 * *
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be * * varchar2 1 * *
channel_id number4 0 1 In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table. * * number 4 * *
store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. * * number 4 * *
mall_name varchar2120 0 1 Description is not available. * * varchar2 120 * *
district number10 0 1 Description is not available. * * number 10 * *
district_name varchar2120 0 1 Description is not available. * * varchar2 120 * *
promo_zone number4 0 1 Description is not available. * * number 4 * *
promo_desc varchar220 0 1 Description is not available. * * varchar2 20 * *
transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. * * number 4 * *
description varchar21000 0 1 Description is not available. * * varchar2 1000 * *
default_wh varchar210 0 1 Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment. * * varchar2 10 * *
stop_order_days number3 0 1 Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined. * * number 3 * *
start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. * * number 3 * *
currency_code varchar23 0 1 Description is not available. * * varchar2 3 * *
lang number6 0 1 Description is not available. * * number 6 * *
integrated_pos_ind varchar21 0 1 Description is not available. * * varchar2 1 * *
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency * * varchar2 3 * *
duns_number varchar29 0 1 This type can hold a number of digits count umber. * * varchar2 9 * *
duns_loc varchar24 0 1 Description is not available. * * varchar2 4 * *
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
pricing_loc number10 0 1 If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. * * null null Yes If this field is null, the new store will not be added to RPM_ZONE_LOCATION table.
pricing_loc_curr varchar23 0 1 Description is not available. * * varchar2 3 * *
org_unit_id number15 0 1 Description is not available. NA NA NA NA NA NA
timezone_name varchar264 0 1 Description is not available. NA NA NA NA NA NA
ExtOfStoreDesc:ExtOfStoreDesc * 0 1 Provide an extension hook to customize StoreDesc. NA NA NA NA NA NA
LocOfStoreDesc:LocOfStoreDesc * 0 1 Provide an extension hook to localize StoreDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
city_id varchar210 0 1 Indicates the City Id or Code. NA NA NA NA NA NA
state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA
addr number11 1 1 Description is not available. * * number 6 * *
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. * * varchar2 2 * *
primary_addr_type_ind varchar21 1 1 Description is not available. * * varchar2 1 * *
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type * * varchar2 1 * *
add_1 varchar2240 1 1 Description is not available. * * varchar2 240 * *
add_2 varchar2240 0 1 Description is not available. * * varchar2 240 * *
add_3 varchar2240 0 1 Description is not available. * * varchar2 240 * *
city varchar2120 1 1 Description is not available. * * varchar2 120 * *
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. * * varchar2 3 * *
country_id varchar23 1 1 Description is not available. * * varchar2 3 * *
post varchar230 0 1 Description is not available. * * varchar2 30 * *
contact_name varchar2120 0 1 Description is not available. * * varchar2 120 * *
contact_phone varchar220 0 1 Description is not available. * * varchar2 20 * *
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. * * varchar2 20 * *
contact_fax varchar220 0 1 Description is not available. * * varchar2 20 * *
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. * * varchar2 100 * *
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. * * number 15 * *
county varchar220 0 1 Description is not available. * * varchar2 250 * *
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. NA NA NA NA NA NA
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA
LocOfAddrDesc:LocOfAddrDesc * 0 1 Provide an extension hook to localize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfStoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For ExtOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfStoreDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rpm Mapping For LocOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description
InStoreDesc:InStoreDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrStoreDesc:BrStoreDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA