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.
|
XSD Structure
|
|
|
XML-Schema Name:ClrPrcChgDesc
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ClrPrcChgDesc in RPM application. |
RPM's Table Name |
RPM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RPM's Column Length |
Is Column Required in RPM's API? |
RPM's 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.
|
|
|
|
|
|
|
|
|
XML-Schema Name:ClrPrcChgDtl
|
Version:16.0.21
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ClrPrcChgDtl in RPM application. |
RPM's Table Name |
RPM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RPM's Column Length |
Is Column Required in RPM's API? |
RPM's API Description |
clearance_id |
Number15 |
1 |
1 |
Clearance ID |
rpm_clearance_payload |
clearance_id |
number |
15 |
Yes |
Clearance Id |
item |
varchar225 |
1 |
1 |
Unique identifier of the item in the clearance |
rpm_clearance_payload |
item |
varchar2 |
25 |
Yes |
Item Number |
effective_date |
xs:dateTime |
1 |
1 |
The date the clearance becomes active |
rpm_clearance_payload |
effective_date |
date |
Fill column length. |
Yes |
Effective date of the clearance |
selling_unit_retail |
number20_4 |
1 |
1 |
Clearance selling unit retail |
rpm_clearance_payload |
selling_retail |
number |
20 |
Yes |
Clearance selling retail |
selling_uom |
varchar24 |
1 |
1 |
Clearance selling UOM |
rpm_clearance_payload |
selling_retail_uom |
varchar2 |
25 |
Yes |
Clearance selling UOM |
selling_currency |
Varchar23 |
1 |
1 |
Clearance selling currency |
rpm_clearance_payload |
selling_retail_currency |
varchar2 |
25 |
Yes |
Clearance selling currency |
reset_clearance_id |
Number15 |
0 |
1 |
Clearance reset ID |
rpm_clearance_payload |
reset_clearance_id |
number |
15 |
No |
Clearance reset id |
|
|