|
Application
|
Store Inventory 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.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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) |
RK_PRICE_CHANGE |
id_str_rt |
NUMBER |
128 |
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') |
TBD |
TBD |
VARCHAR2 |
* |
Not Yet Available |
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
|
|
LocOfClrPrcChgDesc:LocOfClrPrcChgDesc
|
*
|
0
|
1
|
Provide an extension hook to localize ClrPrcChgDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ClrPrcChgDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ClrPrcChgDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
| clearance_id |
Number15 |
1 |
1 |
Not Yet Available |
RK_PRICE_CHANGE |
Change_ref_ id |
NUMBER |
15 |
No |
Price change id |
| item |
varchar225 |
1 |
1 |
Not Yet Available |
RK_PRICE_CHANGE |
id_item |
VARCHAR2 |
128 |
Yes |
Item id |
| effective_date |
xs:dateTime |
1 |
1 |
Not Yet Available |
RK_PRICE_CHANGE |
effective_date |
RIBDate |
* |
Yes |
Date price change is effective |
| selling_unit_retail |
number20_4 |
1 |
1 |
Not Yet Available |
RK_PRICE_CHANGE |
new_price |
NUMBER |
75 |
No |
New price |
| selling_uom |
varchar24 |
1 |
1 |
Not Yet Available |
RK_PRICE_CHANGE |
new_selling_uom |
VARCHAR2 |
40 |
No |
New selling uom |
| selling_currency |
Varchar23 |
1 |
1 |
NA |
RK_PRICE_CHANGE |
null |
varchar2 |
25 |
No |
Selling retail currency |
| reset_clearance_id |
Number15 |
0 |
1 |
NA |
RK_PRICE_CHANGE |
reset_clearance_id |
Number15 |
15,0 |
No |
Reset clearance id |
|
ExtOfClrPrcChgDesc:ExtOfClrPrcChgDtl
|
*
|
0
|
1
|
Provide an extension hook to customize ClrPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
LocOfClrPrcChgDesc:LocOfClrPrcChgDtl
|
*
|
0
|
1
|
Provide an extension hook to localize ClrPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfClrPrcChgDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfClrPrcChgDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfClrPrcChgDtl
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfClrPrcChgDtl |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InClrPrcChgDesc:InClrPrcChgDtl
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrClrPrcChgDesc:BrClrPrcChgDtl
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
|
XML-Schema Name:ExtOfClrPrcChgDesc
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfClrPrcChgDesc |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
|
XML-Schema Name:LocOfClrPrcChgDesc
|
Version:13.2.0
|
Return to Top
|
| Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For LocOfClrPrcChgDesc |
| Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
InClrPrcChgDesc:InClrPrcChgDesc
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
BrClrPrcChgDesc:BrClrPrcChgDesc
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
