Retail Integration Bus Mappings Report Release:13.2.0 (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.2.0 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) 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.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDesc * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgDesc * 0 1 Provide an extension hook to localize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgDtl Version:13.2.0 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 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.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgDtl * 0 1 Provide an extension hook to customize PrmPrcChgDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgDtl * 0 1 Provide an extension hook to localize PrmPrcChgDtl. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgSmp Version:13.2.0 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 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
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgSmp * 0 1 Provide an extension hook to customize PrmPrcChgSmp. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgSmp * 0 1 Provide an extension hook to localize PrmPrcChgSmp. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgSmp Version:13.2.0 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:LocOfPrmPrcChgSmp Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgSmp
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgSmp * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgSmp * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThr Version:13.2.0 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 * 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.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThr * 0 1 Provide an extension hook to customize PrmPrcChgThr. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgThr * 0 1 Provide an extension hook to localize PrmPrcChgThr. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgThrDtl Version:13.2.0 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 * 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
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgThrDtl * 0 1 Provide an extension hook to customize PrmPrcChgThrDtl. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgThrDtl * 0 1 Provide an extension hook to localize PrmPrcChgThrDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThrDtl Version:13.2.0 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:LocOfPrmPrcChgThrDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgThrDtl
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgThrDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgThrDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgThr Version:13.2.0 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:LocOfPrmPrcChgThr Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgThr
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgThr * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgThr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgBuyGet Version:13.2.0 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 * 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.
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyGet * 0 1 Provide an extension hook to customize PrmPrcChgBuyGet. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgBuyGet * 0 1 Provide an extension hook to localize PrmPrcChgBuyGet. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgGetItem Version:13.2.0 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 * Not used in SIM
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgGetItem * 0 1 Provide an extension hook to customize PrmPrcChgGetItem. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgGetItem * 0 1 Provide an extension hook to localize PrmPrcChgGetItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgGetItem Version:13.2.0 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:LocOfPrmPrcChgGetItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgGetItem
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgGetItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgGetItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:PrmPrcChgBuyItem Version:13.2.0 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 * Not used in SIM
ExtOfPrmPrcChgDesc:ExtOfPrmPrcChgBuyItem * 0 1 Provide an extension hook to customize PrmPrcChgBuyItem. NA NA NA NA NA NA
LocOfPrmPrcChgDesc:LocOfPrmPrcChgBuyItem * 0 1 Provide an extension hook to localize PrmPrcChgBuyItem. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgBuyItem Version:13.2.0 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:LocOfPrmPrcChgBuyItem Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgBuyItem
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgBuyItem * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgBuyItem * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgBuyGet Version:13.2.0 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:LocOfPrmPrcChgBuyGet Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgBuyGet
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgBuyGet * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgBuyGet * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgDtl Version:13.2.0 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:LocOfPrmPrcChgDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgDtl
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPrmPrcChgDesc Version:13.2.0 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

XML-Schema Name:LocOfPrmPrcChgDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfPrmPrcChgDesc
Table Name Column Name API Type Column Length API Required API Description
InPrmPrcChgDesc:InPrmPrcChgDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPrmPrcChgDesc:BrPrmPrcChgDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA