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. |