XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItPrHdrCriVo 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 |
store_id |
number10 |
1 |
1 |
SIM store internal identifier |
ITEM_PRICE |
STORE_ID |
NUMBER |
10,0 |
Yes |
the unique identifier of the store where the price change is occurring. |
from_effective_date |
xs:dateTime |
0 |
1 |
Include prices with an effective date equal to or after this date. |
ITEM_PRICE |
EFFECTIVE_DATE |
DATE |
Fill column length. |
Yes |
the date the new price should take effect. |
to_effective_date |
xs:dateTime |
0 |
1 |
Include prices with an effective date equal to or before this date. |
ITEM_PRICE |
EFFECTIVE_DATE |
DATE |
Fill column length. |
Yes |
the date the new price should take effect. |
from_end_date |
xs:dateTime |
0 |
1 |
Include prices with an end date equal to or after this end date. |
ITEM_PRICE |
END_DATE |
DATE |
|
No |
the date the price should end. this will be null for permanent price changes. |
to_end_date |
xs:dateTime |
0 |
1 |
Include prices with an end date equal to or before this end date. |
ITEM_PRICE |
END_DATE |
DATE |
Fill column length. |
No |
the date the price should end. this will be null for permanent price changes. |
department_id |
number12 |
0 |
1 |
Include prices with items with this merchandise hierarchy department identifier. |
ITEM |
DEPARTMENT_ID |
NUMBER |
12,0 |
No |
hierarchy department id |
class_id |
number12 |
0 |
1 |
Include prices with items with this merchandise hierarchy class identifier. |
ITEM |
CLASS_ID |
number |
12,0 |
No |
hierarchy class id |
subclass_id |
number12 |
0 |
1 |
Include prices with items with this merchandise hierarchy subclass identifier. |
ITEM |
SUBCLASS_ID |
NUMBER |
12,0 |
No |
hierarchy subclass id |
item_id |
varchar225 |
0 |
1 |
Include only prices for this particular sku. |
ITEM_PRICE |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that is having the price changed. |
status |
it_pr_status |
1 |
1 |
Include only prices in this 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 |
Include only prices of this 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 |
Include only prices associated with this promotion. |
ITEM_PRICE |
PROMOTION_ID |
NUMBER |
10,0 |
No |
the unique identifier of the related promotion. |
search_limit |
number3 |
1 |
1 |
Maximum number of items to return from the query. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
maximum number of items to return from query |