XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ClrPrcChgDtl 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 |
clearance_id |
Number15 |
1 |
1 |
Clearance ID |
PRICE_CHANGE_WORKSHEET |
CLEARANCE_ID |
NUMBER |
15,0 |
No |
Clearance price identifier from pricing engine |
item |
varchar225 |
1 |
1 |
Unique identifier of the item in the clearance |
PRICE_CHANGE_WORKSHEET |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item id |
effective_date |
xs:dateTime |
1 |
1 |
The date the clearance becomes active |
PRICE_CHANGE_WORKSHEET |
EFFECTIVE_DATE |
DATE |
DATE |
No |
Date price change is effective |
selling_unit_retail |
number20_4 |
1 |
1 |
Clearance selling unit retail |
PRICE_CHANGE_WORKSHEET |
SELLING_UNIT_CHANGE |
NUMBER |
1,0 |
No |
The selling retail price change indicator |
selling_uom |
varchar24 |
1 |
1 |
Clearance selling UOM |
PRICE_CHANGE_WORKSHEET |
SELLING_RETAIL_UOM |
VARCHAR2 |
4,0 |
No |
The selling retail Unit Of Measure |
selling_currency |
Varchar23 |
1 |
1 |
Clearance selling currency |
PRICE_CHANGE_WORKSHEET |
SELLING_RETAIL_CURRENCY |
VARCHAR2 |
3 |
No |
The selling retail currency code |
reset_clearance_id |
Number15 |
0 |
1 |
Clearance reset ID |
PRICE_CHANGE_WORKSHEET |
RESET_CLEARANCE_ID |
NUMBER |
15,0 |
No |
Reset clearance id |