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