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