XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for RegPrcChgDtl in RPM application. |
RPM's Table Name |
RPM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RPM's Column Length |
Is Column Required in RPM's API? |
RPM's API Description |
price_change_id |
number15 |
1 |
1 |
Contains the ID of the price change that initiated the ticket request. |
rpm_price_chg_payload |
price_change_id |
NUMBER |
15 |
Yes |
Price Change Id |
item |
varchar225 |
1 |
1 |
Alphanumeric value that identifies the item for which tickets have been requested. |
rpm_price_chg_payload |
item |
VARCHAR2 |
25 |
Yes |
Item number |
effective_date |
xs:dateTime |
1 |
1 |
Price Change Effective Date |
rpm_price_chg_payload |
effective_date |
DATE |
null |
Yes |
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. |
rpm_price_chg_payload |
selling_unit_change_ind |
NUMBER |
6 |
Yes |
Indicate whether the regular selling retail is change by the Price Change |
selling_unit_retail |
number20_4 |
1 |
1 |
This field contains the unit retail for the item at the indicated location. |
rpm_price_chg_payload |
selling_retail |
NUMBER |
20,4 |
Yes |
Regular selling retail |
selling_uom |
varchar24 |
1 |
1 |
Holds the selling unit of measure for an item's single-unit retail. |
rpm_price_chg_payload |
selling_retail_uom |
VARCHAR2 |
25 |
Yes |
Regular Selling UOM |
selling_currency |
varchar23 |
1 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
rpm_price_chg_payload |
selling_retail currency |
VARCHAR2 |
25 |
Yes |
Regular Selling Retail Currency |
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. |
rpm_price_chg_payload |
multi_unit_changed_ind |
NUMBER |
6 |
Yes |
Indicate whether the Multi Unit Selling Retail is changed by the Price Change |
multi_units |
number12_4 |
0 |
1 |
The number that indicate how many item is priced in the multi unit selling retail |
rpm_price_chg_payload |
multi_units |
NUMBER |
18, 4 |
No |
The number that indicate how many item is priced in the multi unit selling retail |
multi_unit_retail |
number20_4 |
0 |
1 |
This field contains the multi-unit retail for the item at the indicated location. |
rpm_price_chg_payload |
multi_units_retail |
NUMBER |
20,4 |
No |
Multi Unit Selling Retail |
multi_unit_retail_currency |
varchar23 |
0 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
rpm_price_chg_payload |
multi_units_currency |
VARCHAR2 |
25 |
No |
Multi Unit Retail Currency |
multi_selling_uom |
varchar24 |
0 |
1 |
Multi Unit Selling UOM |
rpm_price_chg_payload |
multi_units_uom |
VARCHAR2 |
25 |
No |
Multi Unit Selling UOM |