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.
|
XSD Structure
|
|
|
XML-Schema Name:PrmPrcChgDesc
|
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 PrmPrcChgDesc 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 that indicates a Location (Store or Warehouse) |
|
|
number |
|
No |
Not used in SIM |
loc_type |
varchar21 |
1 |
1 |
Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
PrmPrcChgDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrmPrcChgDtl
|
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 PrmPrcChgDtl 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 |
promo_id |
number10 |
1 |
1 |
Promotion Id |
|
|
number |
|
Not Yet Available |
Not used in SIM |
promo_name |
varchar240 |
0 |
1 |
Promotion Name |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
promo_description |
varchar2160 |
0 |
1 |
Promotion Description |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
promo_comp_id |
number10 |
1 |
1 |
Promotion Component Id |
|
|
number |
|
Not Yet Available |
Not used in SIM |
promo_comp_desc |
varchar240 |
0 |
1 |
Promotion Component Description |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
promo_comp_detail_id |
number10 |
1 |
1 |
Promotion Component Detail Id |
|
|
number |
|
Not Yet Available |
Not used in SIM |
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 |
|
|
number |
|
Not Yet Available |
Not used in SIM |
start_date |
xs:dateTime |
1 |
1 |
Start date of the promotion component detail |
|
|
RIBDate |
|
Not Yet Available |
Not used in SIM |
end_date |
xs:dateTime |
0 |
1 |
End date of the promotion component detail |
|
|
RIBDate |
|
Not Yet Available |
Not used in SIM |
PrmPrcChgSmp
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgThr
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgBuyGet
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrmPrcChgSmp
|
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 PrmPrcChgSmp 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 |
item |
varchar225 |
1 |
1 |
Item number |
|
|
varhcar2 |
|
No |
Not available. |
promo_selling_retail |
number20 |
1 |
1 |
Simple Promotion selling retail |
|
|
number |
|
Not Yet Available |
Not used in SIM |
promo_selling_uom |
xs:string |
1 |
1 |
Simple promotion selling UOM |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
prm_chg_type |
varchar21 |
1 |
1 |
Simple Promotion change type |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
prm_chg_value |
number20 |
1 |
1 |
Simple Promotion change value |
|
|
number |
|
Not Yet Available |
Not used in SIM |
prm_chg_uom |
varchar24 |
0 |
1 |
Simple Promotion change selling UOM |
|
|
varchar2 |
|
Not Yet Available |
Not used in SIM |
|
|
XML-Schema Name:PrmPrcChgThr
|
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 PrmPrcChgThr 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 |
item |
varchar225 |
1 |
1 |
Item number |
|
|
varchar2 |
25 |
* |
Not used in SIM |
threshold_id |
number6 |
1 |
1 |
Threshold Id |
|
|
number |
6 |
* |
Not used in SIM |
threshold_name |
varchar230 |
0 |
1 |
Threshold Name |
|
|
varchar2 |
30 |
* |
Not used in SIM |
qualification_type |
number1 |
1 |
1 |
Threshold Qualification Type |
|
null |
number |
1 |
null |
Not used in SIM |
threshold_type |
varchar21 |
1 |
1 |
Threshold Type |
|
|
varchar2 |
1 |
* |
Not used in SIM |
prm_chg_type |
varchar21 |
1 |
1 |
Threshold Discount Change Type |
|
|
varchar2 |
1 |
* |
Not used in SIM |
PrmPrcChgThrDtl
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrmPrcChgThrDtl
|
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 PrmPrcChgThrDtl 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 |
threshold_value |
number20 |
1 |
1 |
Threshold Interval Value |
|
|
number |
20 |
* |
Not used in SIM |
prm_chg_value |
number20 |
1 |
1 |
Threshold Change Value |
|
|
number |
20 |
* |
Not used in SIM |
prm_chg_uom |
varchar24 |
0 |
1 |
Threshold Change Selling UOM |
|
|
varchar2 |
4 |
* |
Not used in SIM |
|
|
XML-Schema Name:PrmPrcChgBuyGet
|
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 PrmPrcChgBuyGet 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 |
prm_chg_type |
varchar21 |
1 |
1 |
Buy Get discount change type |
|
|
varchar2 |
1 |
* |
Not used in SIM |
prm_chg_value |
number20 |
1 |
1 |
Buy Get Discount Change Value |
|
|
number |
20 |
* |
Not used in SIM |
prm_chg_uom |
varchar24 |
0 |
1 |
Buy Get Change Selling UOM |
|
|
|
|
* |
Not used in SIM |
buy_qty |
number20 |
1 |
1 |
Buy quantity |
|
|
number |
20 |
* |
Not used in SIM |
all_ind |
number1 |
1 |
1 |
Buy All Indicator |
|
|
number |
1 |
* |
Not used in SIM |
PrmPrcChgGetItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
PrmPrcChgBuyItem
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
|
|
XML-Schema Name:PrmPrcChgGetItem
|
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 PrmPrcChgGetItem 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 |
item |
varchar225 |
1 |
1 |
Get Item |
|
|
varchar2 |
25 |
* |
Not used in SIM |
|
|
XML-Schema Name:PrmPrcChgBuyItem
|
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 PrmPrcChgBuyItem 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 |
item |
varchar225 |
1 |
1 |
Buy Item |
|
|
varchar2 |
25 |
* |
Not used in SIM |
|
|