Application | Retail Price 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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | location | number10 | 1 | 1 | Unique identifier that indicates a Location (Store or Warehouse) | rpm_promo_location_payload | location | number | 10 | Yes | Unique identifier that indicates a Location (Store or Warehouse) | loc_type | varchar21 | 1 | 1 | Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') | rpm_promo_location_payload | location_type | number | 30 | * | Identifier that indicates whether a location is a Store ('S') or a Warehouse ('W') | 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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | promo_id | number10 | 1 | 1 | Promotion Id | rpm_promo_dtl_payload | promo_id | number | 10 | Yes | Promotion Id | promo_name | varchar240 | 0 | 1 | Promotion Name | rpm_promo_dtl_payload | name | varchar2 | 160 | * | Promotion Name | promo_description | varchar2160 | 0 | 1 | Promotion Description | rpm_promo_dtl_payload | description | varchar2 | 640 | * | Promotion Description | promo_comp_id | number10 | 1 | 1 | Promotion Component Id | rpm_promo_dtl_payload | promo_comp_id | number | 10 | Yes | Promotion Component Id | promo_comp_desc | varchar240 | 0 | 1 | Promotion Component Description | rpm_promo_dtl_payload | name | varchar2 | 160 | * | Promotion Component Description | promo_comp_detail_id | number10 | 1 | 1 | Promotion Component Detail Id | rpm_promo_dtl_payload | promo_dtl_id | number | 10 | Yes | Promotion Component Detail Id | 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 | rpm_promo_dtl_payload | apply_order | number | 6 | * | 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 | start_date | xs:dateTime | 1 | 1 | Start date of the promotion component detail | rpm_promo_dtl_payload | start_date | date | Fill column length. | Yes | Start date of the promotion component detail | end_date | xs:dateTime | 0 | 1 | End date of the promotion component detail | rpm_promo_dtl_payload | end_date | date | Fill column length. | No | End date of the promotion component detail | 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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | item | varchar225 | 1 | 1 | Item number | rpm_promo_dtl_merch_node | item | varchar2 | 25 | * | Item number | promo_selling_retail | number20 | 1 | 1 | Simple Promotion selling retail | rpm_future_retail | simple_promo_retail | number | 20,4 | * | Simple Promotion selling retail | promo_selling_uom | xs:string | 1 | 1 | Simple promotion selling UOM | rpm_future_retail | simple_promo_uom | varchar2 | 4 | * | Simple promotion selling UOM | prm_chg_type | varchar21 | 1 | 1 | Simple Promotion change type | rpm_promo_dtl_disc_ladder | change_type | number | 2 | * | Simple Promotion change type | prm_chg_value | number20 | 1 | 1 | Simple Promotion change value | rpm_promo_dtl_disc_ladder | change_amt or change_percent | number | 20,4 | * | Simple Promotion change value | prm_chg_uom | varchar24 | 0 | 1 | Simple Promotion change selling UOM | rpm_promo_dtl_disc_ladder | change_selling_uom | varchar2 | 4 | * | Simple Promotion change selling UOM | | |
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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | item | varchar225 | 1 | 1 | Item number | rpm_promo_dtl_merch_node | item | varchar2 | 25 | * | Item number | threshold_id | number6 | 1 | 1 | Threshold Id | rpm_threshold | threshold_id | number | 6 | * | Threshold Id | threshold_name | varchar230 | 0 | 1 | Threshold Name | rpm_threshold | name | varchar2 | 120 | * | Threshold Name | qualification_type | number1 | 1 | 1 | Threshold Qualification Type | rpm_threshold | qualification_type | number | 1 | * | Threshold Qualification Type | threshold_type | varchar21 | 1 | 1 | Threshold Type | rpm_threshold_interval | threshold_type | number | 1 | * | Threshold Type | prm_chg_type | varchar21 | 1 | 1 | Threshold Discount Change Type | rpm_promo_dtl_disc_ladder | change_type | number | 2 | * | Threshold Discount Change Type | 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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | threshold_value | number20 | 1 | 1 | Threshold Interval Value | rpm_threshold_interval | threshold_amount | number | 20,4 | * | Threshold Interval Value | prm_chg_value | number20 | 1 | 1 | Threshold Change Value | rpm_threshold_interval | change_amt or change_percent | number | 20,4 | * | Threshold Change Value | prm_chg_uom | varchar24 | 0 | 1 | Threshold Change Selling UOM | rpm_threshold_interval | change_uom | varchar2 | 4 | * | Threshold Change Selling UOM | | |
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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | prm_chg_type | varchar21 | 1 | 1 | Buy Get discount change type | rpm_promo_dtl_disc_ladder | change_type | number | 2 | * | Buy Get discount change type | prm_chg_value | number20 | 1 | 1 | Buy Get Discount Change Value | rpm_promo_dtl_disc_ladder | change_amount or change_percent | number | 20,4 | * | Buy Get Discount Change Value | prm_chg_uom | varchar24 | 0 | 1 | Buy Get Change Selling UOM | rpm_promo_dtl_disc_ladder | change_selling_uom | varchar2 | 4 | change_selling_uom | Buy Get Change Selling UOM | buy_qty | number20 | 1 | 1 | Buy quantity | rpm_promo_dtl_disc_ladder | qual_value | number | 20,4 | * | Buy quantity | all_ind | number1 | 1 | 1 | Buy All Indicator | rpm_promo_dtl_disc_ladder | qual_type | number | 2 | * | All Indicator | 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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | item | varchar225 | 1 | 1 | Get Item | rpm_promo_dtl_merch_node | item | varchar2 | 25 | * | Get Item | | |
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 RPM application. | RPM's Table Name | RPM's Column Name | Integration API(RIB or/and RSB or/and RSL) | RPM's Column Length | Is Column Required in RPM's API? | RPM's API Description | item | varchar225 | 1 | 1 | Buy Item | rpm_promo_dtl_merch_node | item | varchar2 | 25 | * | Buy Item | | |