XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItPrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
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 unique identifer from an external system. |
ITEM_PRICE |
PROMOTION_COMP_ID, REGULAR_PRICE_CHANGE_ID, CLEARANCE_ID |
NUMBER |
15 |
No |
the unique identifier of the promotion component./
regular price change identifer from pricing engine/
Clearance price identifier from pricing engine |
store_id |
number10 |
1 |
1 |
SIM store internal identifier. |
ITEM_PRICE |
STORE_ID |
NUMBER |
10 |
Yes |
the unique identifier of the store where the price change is occurring. |
item_id |
varchar225 |
1 |
1 |
Sku number |
ITEM_PRICE |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that is having the price changed. |
effective_date |
xs:dateTime |
1 |
1 |
Date that the price becomes effective. |
ITEM_PRICE |
EFFECTIVE_DATE |
DATE |
7 |
Yes |
the date the new price should take effect. |
end_date |
xs:dateTime |
0 |
1 |
Date that the price is no longer valid. |
ITEM_PRICE |
END_DATE |
DATE |
7 |
No |
the date the price should end. this will be null for permanent price changes. |
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 |
selling_unit_price_cur |
varchar23 |
0 |
1 |
The currency code of the current selling unit price. |
ITEM_PRICE |
PRICE_CURRENCY |
VARCHAR2 |
3 |
No |
The Price currency. |
selling_unit_price_value |
number12_4 |
0 |
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). |
status |
it_pr_status |
1 |
1 |
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 |
promotion_id |
number10 |
0 |
1 |
Promotion unique identifier. |
ITEM_PRICE |
PROMOTION_ID |
NUMBER |
(10,0) |
No |
the unique identifier of the related promotion. |
promotion_component_id |
number10 |
0 |
1 |
Promotion component unique identifier. |
ITEM_PRICE |
PROMOTION_COMP_ID |
NUMBER |
(10,0) |
No |
the unique identifier of the promotion component. |
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. |
multi_units |
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_price_currency_code |
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 |
multi unit retail value |
multi_unit_uom |
varchar24 |
0 |
1 |
Unit of measure of 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_change |
xs:boolean |
0 |
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 |
Yes |
indicates if the multi-unit pricing has changed. valid values 0 - no 1 - yes |
selling_unit_change |
xs:boolean |
0 |
1 |
True if a change was made to this item price. |
ITEM_PRICE |
SELLING_UNIT_CHANGE |
NUMBER |
1 |
Yes |
did selling unit retail change with this price event (0 = no change, 1 = changed) |
promotion_name |
varchar2160 |
0 |
1 |
The name of the associated promotion. |
ITEM_PRICE |
PROMOTION_NAME |
VARCHAR2 |
160 |
No |
promotion header name |
promotion_description |
varchar2640 |
0 |
1 |
The long description of the associated promotion. |
ITEM_PRICE |
PROMOTION_DESCRIPTION |
VARCHAR2 |
640 |
No |
promotion header description |
promotion_comp_name |
varchar2160 |
0 |
1 |
The name of the promotion component. |
ITEM_PRICE |
PROMOTION_COMP_NAME |
VARCHAR2 |
160 |
No |
promotion component name |
reset_clearance_id |
number15 |
0 |
1 |
Clearance reset identifier. |
ITEM_PRICE |
RESET_CLEARANCE_ID |
NUMBER |
(15,0) |
No |
id of clearance reset |
new_price_cur |
varchar23 |
0 |
1 |
The currency code of the new selling 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. |
suggest_retail_cur |
varchar23 |
0 |
1 |
The currency code of the manufacturer's suggested retail price. |
ITEM_PRICE |
MANU_SUGGESTED_RETAIL_PRICE |
NUMBER |
(12,4) |
No |
Manufacturer suggested retail price |
suggest_retail_value |
number12_4 |
0 |
1 |
The amount of the manufacturer's suggested retail price. |
ITEM |
MANU_SUGGESTED_RETAIL_PRICE |
NUMBER |
(12,4). |
No |
Manufacturer suggested retail price |