Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
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