Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:PrmPrcChgDesc Version:15.0.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) Fill application table name. Fill table column name. number Fill column length. No Not used in SIM
loc_type varchar21 1 1 Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
PrmPrcChgDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgDtl Version:15.0.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 Fill application table name. Fill table column name. number Fill column length. Not Yet Available Not used in SIM
promo_name varchar240 0 1 Promotion Name Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
promo_description varchar2160 0 1 Promotion Description Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
promo_comp_id number10 1 1 Promotion Component Id Fill application table name. Fill table column name. number Fill column length. Not Yet Available Not used in SIM
promo_comp_desc varchar240 0 1 Promotion Component Description Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
promo_comp_detail_id number10 1 1 Promotion Component Detail Id Fill application table name. Fill table column name. number Fill column length. 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 Fill application table name. Fill table column name. number Fill column length. Not Yet Available Not used in SIM
start_date xs:dateTime 1 1 Start date of the promotion component detail Fill application table name. Fill table column name. RIBDate Fill column length. Not Yet Available Not used in SIM
end_date xs:dateTime 0 1 End date of the promotion component detail Fill application table name. Fill table column name. RIBDate Fill column length. 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:15.0.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 Fill application table name. Fill table column name. varhcar2 Fill column length. No Not available.
promo_selling_retail number20 1 1 Simple Promotion selling retail Fill application table name. Fill table column name. number Fill column length. Not Yet Available Not used in SIM
promo_selling_uom xs:string 1 1 Simple promotion selling UOM Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
prm_chg_type varchar21 1 1 Simple Promotion change type Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM
prm_chg_value number20 1 1 Simple Promotion change value Fill application table name. Fill table column name. number Fill column length. Not Yet Available Not used in SIM
prm_chg_uom varchar24 0 1 Simple Promotion change selling UOM Fill application table name. Fill table column name. varchar2 Fill column length. Not Yet Available Not used in SIM

XML-Schema Name:PrmPrcChgThr Version:15.0.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 Fill application table name. Fill table column name. varchar2 25 * Not used in SIM
threshold_id number6 1 1 Threshold Id Fill application table name. Fill table column name. number 6 * Not used in SIM
threshold_name varchar230 0 1 Threshold Name Fill application table name. Fill table column name. varchar2 30 * Not used in SIM
qualification_type number1 1 1 Threshold Qualification Type Fill application table name. null number 1 null Not used in SIM
threshold_type varchar21 1 1 Threshold Type Fill application table name. Fill table column name. varchar2 1 * Not used in SIM
prm_chg_type varchar21 1 1 Threshold Discount Change Type Fill application table name. Fill table column name. varchar2 1 * Not used in SIM
PrmPrcChgThrDtl * 1 unbounded Description is not available.

XML-Schema Name:PrmPrcChgThrDtl Version:15.0.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 Fill application table name. Fill table column name. number 20 * Not used in SIM
prm_chg_value number20 1 1 Threshold Change Value Fill application table name. Fill table column name. number 20 * Not used in SIM
prm_chg_uom varchar24 0 1 Threshold Change Selling UOM Fill application table name. Fill table column name. varchar2 4 * Not used in SIM

XML-Schema Name:PrmPrcChgBuyGet Version:15.0.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 Fill application table name. Fill table column name. varchar2 1 * Not used in SIM
prm_chg_value number20 1 1 Buy Get Discount Change Value Fill application table name. Fill table column name. number 20 * Not used in SIM
prm_chg_uom varchar24 0 1 Buy Get Change Selling UOM Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. * Not used in SIM
buy_qty number20 1 1 Buy quantity Fill application table name. Fill table column name. number 20 * Not used in SIM
all_ind number1 1 1 Buy All Indicator Fill application table name. Fill table column name. 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:15.0.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 Fill application table name. Fill table column name. varchar2 25 * Not used in SIM

XML-Schema Name:PrmPrcChgBuyItem Version:15.0.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 Fill application table name. Fill table column name. varchar2 25 * Not used in SIM