Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/PrmPrcChgDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:PrmPrcChgDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgDesc |
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 |
TBD |
number |
* |
No |
Not Yet Available |
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 |
Not Yet Available |
PrmPrcChgDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDesc
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:PrmPrcChgDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
promo_id |
number10 |
1 |
1 |
Promotion Id |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
promo_name |
varchar240 |
0 |
1 |
Promotion Name |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
promo_description |
varchar2160 |
0 |
1 |
Promotion Description |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
promo_comp_id |
number10 |
1 |
1 |
Promotion Component Id |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
promo_comp_desc |
varchar240 |
0 |
1 |
Promotion Component Description |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
promo_comp_detail_id |
number10 |
1 |
1 |
Promotion Component Detail Id |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
apply_order |
number1 |
1 |
1 |
The order that this promotion component detail to be applied in case there is more than one promotion component details in one day for an item/location |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
start_date |
xs:dateTime |
1 |
1 |
Start date of the promotion component detail |
TBD |
TBD |
RIBDate |
* |
Not Yet Available |
Not Yet Available |
end_date |
xs:dateTime |
0 |
1 |
End date of the promotion component detail |
TBD |
TBD |
RIBDate |
* |
Not Yet Available |
Not Yet Available |
PrmPrcChgSmp
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgThr
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgBuyGet
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDtl
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:PrmPrcChgSmp
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgSmp |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Item number |
RK_PRICE_CHANGE |
TBD |
varhcar2 |
* |
No |
Not Yet Available |
promo_selling_retail |
number20 |
1 |
1 |
Simple Promotion selling retail |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
promo_selling_uom |
xs:string |
1 |
1 |
Simple promotion selling UOM |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
prm_chg_type |
varchar21 |
1 |
1 |
Simple Promotion change type |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
prm_chg_value |
number20 |
1 |
1 |
Simple Promotion change value |
TBD |
TBD |
number |
* |
Not Yet Available |
Not Yet Available |
prm_chg_uom |
varchar24 |
0 |
1 |
Simple Promotion change selling UOM |
TBD |
TBD |
varchar2 |
* |
Not Yet Available |
Not Yet Available |
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgSmp
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgSmp.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfPrmPrcChgSmp
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgSmp |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:PrmPrcChgThr
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgThr |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Item number |
* |
* |
varchar2 |
25 |
* |
* |
threshold_id |
number6 |
1 |
1 |
Threshold Id |
* |
* |
number |
6 |
* |
* |
threshold_name |
varchar230 |
0 |
1 |
Threshold Name |
* |
* |
varchar2 |
30 |
* |
* |
qualification_type |
number1 |
1 |
1 |
Threshold Qualification Type |
|
null |
number |
1 |
null |
null |
threshold_type |
varchar21 |
1 |
1 |
Threshold Type |
* |
* |
varchar2 |
1 |
* |
* |
prm_chg_type |
varchar21 |
1 |
1 |
Threshold Discount Change Type |
* |
* |
varchar2 |
1 |
* |
* |
PrmPrcChgThrDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThr
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgThr.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:PrmPrcChgThrDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgThrDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
threshold_value |
number20 |
1 |
1 |
Threshold Interval Value |
* |
* |
number |
20 |
* |
* |
prm_chg_value |
number20 |
1 |
1 |
Threshold Change Value |
* |
* |
number |
20 |
* |
* |
prm_chg_uom |
varchar24 |
0 |
1 |
Threshold Change Selling UOM |
* |
* |
varchar2 |
4 |
* |
* |
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThrDtl
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgThrDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfPrmPrcChgThrDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgThrDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfPrmPrcChgThr
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgThr |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:PrmPrcChgBuyGet
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgBuyGet |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
prm_chg_type |
varchar21 |
1 |
1 |
Buy Get discount change type |
* |
* |
varchar2 |
1 |
* |
* |
prm_chg_value |
number20 |
1 |
1 |
Buy Get Discount Change Value |
* |
* |
number |
20 |
* |
* |
prm_chg_uom |
varchar24 |
0 |
1 |
Buy Get Change Selling UOM |
* |
* |
varchar2 |
4 |
* |
* |
buy_qty |
number20 |
1 |
1 |
Buy quantity |
* |
* |
number |
20 |
* |
* |
all_ind |
number1 |
1 |
1 |
Buy All Indicator |
* |
* |
number |
1 |
* |
* |
PrmPrcChgGetItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgBuyItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyGet
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgBuyGet.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:PrmPrcChgGetItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgGetItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Get Item |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgGetItem
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgGetItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfPrmPrcChgGetItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgGetItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:PrmPrcChgBuyItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For PrmPrcChgBuyItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
Buy Item |
* |
* |
varchar2 |
25 |
* |
* |
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyItem
|
*
|
0
|
1
|
Provide an extension hook to customize PrmPrcChgBuyItem.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfPrmPrcChgBuyItem
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgBuyItem |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfPrmPrcChgBuyGet
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgBuyGet |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfPrmPrcChgDtl
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfPrmPrcChgDesc
|
Version:13.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfPrmPrcChgDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|