Retail Integration Bus Mappings Report Release:13.1 (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.1 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_future_retail location null null 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_future_retail zone_node_type null null 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

XML-Schema Name:ClrPrcChgDtl Version:13.1 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 clearance_id null null Yes Clearance Id
item varchar225 1 1 Not Yet Available rpm_future_retail clear_retail null null Yes Item Number
effective_date xs:dateTime 1 1 Not Yet Available rpm_clearance effective_date null null Yes Effective date of the clearance
selling_unit_retail number20_4 1 1 Not Yet Available rpm_future_retail clear_retail null null Yes Clearance selling retail
selling_uom varchar24 1 1 Not Yet Available rpm_future_retail clear_uom null null Yes Clearance selling UOM
selling_currency Varchar23 1 1 NA rpm_future_retail clear_retail_currency null null Yes Clearance selling currency
reset_clearance_id Number15 0 1 NA rpm_clearance clearance_id null null Yes Clearance reset id
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDtl * 0 1 Provide an extension hook to customize ClrPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfClrPrcChgDtl Version:13.1 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:ExtOfClrPrcChgDesc Version:13.1 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