XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RegPrcChgDtl 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 |
price_change_id |
number15 |
1 |
1 |
Contains the ID of the price change that initiated the ticket request. |
PRICE_CHANGE_WORKSHEET |
REGULAR_PRICE_CHANGE_ID |
NUMBER |
15,0 |
No |
regular price change identifer from pricing engine |
item |
varchar225 |
1 |
1 |
Alphanumeric value that identifies the item for which tickets have been requested. |
PRICE_CHANGE_WORKSHEET |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item id |
effective_date |
xs:dateTime |
1 |
1 |
Price Change Effective Date |
PRICE_CHANGE_WORKSHEET |
EFFECTIVE_DATE |
DATE |
Fill column length. |
No |
Price Change Effective Date |
selling_retail_changed_ind |
number1 |
1 |
1 |
Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed. |
PRICE_CHANGE_WORKSHEET |
SELLING_UNIT_CHANGE |
NUMBER |
1,0 |
No |
The selling retail price change indicator |
selling_unit_retail |
number20_4 |
1 |
1 |
This field contains the unit retail for the item at the indicated location. |
PRICE_CHANGE_WORKSHEET |
SELLING_RETAIL |
VARCHAR2 |
12,4 |
No |
The selling retail price |
selling_uom |
varchar24 |
1 |
1 |
Holds the selling unit of measure for an item's single-unit retail. |
PRICE_CHANGE_WORKSHEET |
SELLING_RETAIL_UOM |
VARCHAR2 |
4,0 |
No |
The selling retail Unit Of Measure |
selling_currency |
varchar23 |
1 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
PRICE_CHANGE_WORKSHEET |
SELLING_RETAIL_CURRENCY |
VARCHAR2 |
3 |
No |
The selling retail currency code |
multi_unit_changed_ind |
number1 |
1 |
1 |
Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. |
PRICE_CHANGE_WORKSHEET |
MULTI_UNIT_CHANGE |
NUMBER |
1,0 |
No |
Indicates whether the retail for multi units has been changed. Valid values are '0' - no change or '1' - retail is changed. Default value is 0 |
multi_units |
number12_4 |
0 |
1 |
The number that indicate how many item is priced in the multi unit selling retail |
PRICE_CHANGE_WORKSHEET |
MULTI_UNITS |
NUMBER |
12,4 |
No |
The price of multiple units |
multi_unit_retail |
number20_4 |
0 |
1 |
This field contains the multi-unit retail for the item at the indicated location. |
PRICE_CHANGE_WORKSHEET |
MULTI_UNIT_RETAIL |
NUMBER |
12,4 |
No |
The multi-units retail price |
multi_unit_retail_currency |
varchar23 |
0 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
PRICE_CHANGE_WORKSHEET |
MULTI_UNIT_RETAIL_CURRENCY |
VARCHAR2 |
3,0 |
No |
The multi-units retail currency |
multi_selling_uom |
varchar24 |
0 |
1 |
Multi Unit Selling UOM |
PRICE_CHANGE_WORKSHEET |
MULTI_UNIT_RETAIL_UOM |
VARCHAR2 |
4,0 |
No |
The multi-units retail Unit Of Measure |