Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/RegPrcChgRef/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:RegPrcChgRef
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RegPrcChgRef in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
location |
number10 |
1 |
1 |
Unique identifier of the location |
PRICE_CHANGE_WORKSHEET |
STORE_ID |
NUMBER |
10,0 |
No |
store id |
loc_type |
varchar21 |
1 |
1 |
Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') |
* |
* |
varchar2 |
1 |
* |
* |
RegPrcChgDtlRef
|
*
|
1
|
unbounded
|
NA
|
|
|
|
|
|
|
|
|
XML-Schema Name:RegPrcChgDtlRef
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RegPrcChgDtlRef in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
price_change_id |
number15 |
1 |
1 |
Unique identifier of the price change |
PRICE_CHANGE_WORKSHEET |
REGULAR_PRICE_CHANGE_ID |
NUMBER |
15,0 |
No |
regular price change identifer from pricing engine |
item |
varchar225 |
1 |
1 |
Unique identifier of the item |
PRICE_CHANGE_WORKSHEET |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item id |
|
|