|
Application
|
Retail Price Management
|
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/PrcChgDesc/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:PrcChgDesc
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcChgDesc 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 |
|
PrcChg
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrcChg
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcChg 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 |
Location Number |
RPM_PRICE_CHANGE |
LOCATION |
NUMBER |
10 |
Yes |
Location ID |
| loc_type |
varchar21 |
1 |
1 |
Location Type |
RPM_PRICE_CHANGE |
ZONE_NODE_TYPE |
NUMBER |
6 |
Yes |
Location Type |
| item |
varchar225 |
1 |
1 |
Unique Identification of the Item |
RPM_PRICE_CHANGE |
ITEM |
VARCHAR2 |
25 |
Yes |
Item ID |
| change_type |
varchar26 |
1 |
1 |
Price Event Type - Price Change, Clearance or Promotion |
N/A |
N/A |
VARCHAR2 |
N/A |
Yes |
Valid values are PE (Regular), CL (Clearance) and PR (Promotion for Simple Promo only) |
|
PrcChgDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
PrcChgRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrcChgDtl
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcChgDtl 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 |
| unit_retail |
number20_4 |
0 |
1 |
Selling Unit Retail |
RPM_PRICE_CHANGE |
CHANGE_AMOUNT |
NUMBER |
20,4 |
Yes |
Fixed Amount Value - New Selling Unit Retail |
| new_uom |
varchar24 |
0 |
1 |
Unit of Measure |
RPM_PRICE_CHANGE |
CHANGE_SELLING_UOM |
VARCHAR2 |
4 |
Yes |
Change Selling Unit Of Measure |
| effective_date |
xs:dateTime |
0 |
1 |
The date the price event will start |
RPM_PRICE_CHANGE |
EFFECTIVE_DATE |
DATE |
Fill column length. |
Yes |
The date the price event will take effect |
| end_date |
xs:dateTime |
0 |
1 |
The date the promotion will end or the reset date for clearance |
RPM_PROMO_DTL |
END_DATE |
DATE |
Fill column length. |
No |
The date the promotion will end |
|
|
|
XML-Schema Name:PrcChgRef
|
Version:15.0.0
|
Return to Top
|
| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcChgRef 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 |
| change_id |
number15 |
1 |
1 |
Promotion Component Detail ID or Price Change ID or Clearance ID if the price event type is a promotion or price change or clearance, respectively |
RPM_PRICE_CHANGE |
PRICE_CHANGE_ID |
NUMBER |
15 |
Yes |
Price Change ID |
| promo_comp_id |
number10 |
0 |
1 |
Promotion Component ID if the price event type is a promotion |
RPM_PROMO_COMP |
PROMO_COMP_ID |
NUMBER |
10 |
No |
Promotion Component ID |
| promo_id |
number10 |
0 |
1 |
Promotion ID if the price event type is a promotion |
RPM_PROMO |
PROMO_ID |
NUMBER |
10 |
No |
Promotion ID if the price event type is a promotion |
|
|
