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/ItPrHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ItPrHdrColDesc 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 ItPrHdrColDesc 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
ItPrHdrDesc:ItPrHdrDesc * 0 unbounded A collection of item price header information NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:ItPrHdrDesc 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 ItPrHdrDesc 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_price_id number12 1 1 Item price identifier. ITEM_PRICE ID number 12,0 Yes the unique identifier of the item price.
external_id number15 0 1 Item price external identifier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes 202, permanent 201, promotion 200,clearance
effective_date xs:dateTime 1 1 The effective date of this item price. ITEM_PRICE EFFECTIVE_DATE date Fill column length. Yes the date the new price should take effect
end_date xs:dateTime 0 1 The end date of this item price. ITEM_PRICE END_DATE date Fill column length. No the date the price should end. this will be null for permanent price changes.
item_id varchar225 1 1 Item identifier ITEM_PRICE ITEM_ID varchar2 25 Yes the unique identifier of the item that is having the price changed.
current_price_cur varchar23 0 1 The currency code of the current unit price. ITEM_PRICE PRICE_CURRENCY varchar2 3 No The Price currency
current_price_value number12_4 1 1 The current selling unit price. ITEM_PRICE PRICE_VALUE number 12,4 Yes The selling retail price value with price type of 1 (permanent) or the promotion retail price value with price type of 2(promotion) or the clearance retail price with price type of 3 (clearance).
current_selling_uom varchar24 0 1 Selling unit of measure of the current price. ITEM_PRICE PRICE_UNIT_OF_MEASURE varchar2 4 No The price unit of measure.
new_price_cur varchar23 0 1 The currency code of the new unit price. ITEM_PRICE PRICE_CURRENCY varchar2 3 No The Price currency.
new_price_value number12_4 1 1 The new selling unit price. ITEM_PRICE PRICE_VALUE number 12,4 Yes The selling retail price value with price type of 1 (permanent) ; or the promotion retail price value with price type of 2(promotion); or the clearance retail price with price type of 3 (clearance).
new_selling_uom varchar24 0 1 Selling unit of measure of the new unit price. ITEM_PRICE PRICE_UNIT_OF_MEASURE varchar2 4 No The price unit of measure.
multi_unit_price_cur varchar23 0 1 The currency code of the multi unit price. ITEM_PRICE MULTI_UNIT_RETAIL_CURRENCY varchar2 3 No this field holds the multi-unit retail in the multi-selling unit of measure for the price change.
multi_unit_price_value number12_4 0 1 The new multi unit price. ITEM_PRICE MULTI_UNIT_RETAIL number 12,4 No Fill this description.
multi_unit_quantity number12_4 0 1 Number of units involved in the multi unit pricing of the item. ITEM_PRICE MULTI_UNITS number 12,4 No this field contains the multi-units for the price change.
multi_unit_selling_uom varchar24 0 1 The unit of measure that applies to the multi unit price. ITEM_PRICE MULTI_UNIT_UOM varchar2 4 No this field holds the selling unit of measure for an items multi-unit retail.
multi_unit_price_change xs:boolean 1 1 True if a change was made to the multi-unit pricing for this item price, false if it only involves regular pricing. ITEM_PRICE MULTI_UNIT_CHANGE number 1,0 No indicates if the multi-unit pricing has changed. valid values 0 - no 1 - yes
suggest_retail_cur varchar23 0 1 The currency code of the manufacturer's suggested retail price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
suggest_retail_value number12_4 0 1 The amount of the manufacturer's suggested retail price. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status it_pr_status 1 1 Current status Valid values are APPROVED, PENDING, ACTIVE, COMPLETED, REJECTED, TICKET_LIST, NEW, DEFAULT, DELETED, NO_VALUE, UNKNOWN. ITEM_PRICE STATUS number 2,0 Yes the current status of the price changes. The possible values are 0 - new, 1 - pending 2 - approved, 3 - completed, 4 - rejected, 5 - ticket list, 7 - extract failed, 9 - deleted, 99 - default
price_type it_pr_price_type 1 1 Price type Valid values are CLEARANCE, PROMOTIONAL, PERMANENT, NO_VALUE, UNKNOWN. ITEM_PRICE PRICE_TYPE number 3,0 Yes The item price type. Valid values 200- Clearance, 201- Promotional, 202-Permanent
promotion_id number10 0 1 Promotion identifier ITEM_PRICE PROMOTION_ID number 10,0 No the unique identifier of the related promotion.