XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItPrVo 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 |
new_price_cur |
varchar23 |
0 |
1 |
The currency code of the unit price on the effective date. |
ITEM_PRICE |
MULTI_UNIT_RETAIL_CURRENCY |
VARCHAR2 |
(3 BYTE) |
No |
this field holds the multi-unit retail in the multi-selling unit of measure for the price change. |
new_price_value |
number12_4 |
1 |
1 |
The unit price on the effective date. |
ITEM_PRICE |
MULTI_UNIT_RETAIL |
NUMBER |
(12,4) |
No |
this field holds the multi-unit retail value |
selling_uom |
varchar24 |
0 |
1 |
The unit of measure that applies to unit price on effective date. |
ITEM_PRICE |
MULTI_UNIT_UOM |
VARCHAR2 |
(4 BYTE) |
No |
this field holds the selling unit of measure for an items multi-unit retail. |