Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rpm Mapping For RegPrcChgDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
price_change_id |
number15 |
1 |
1 |
Contains the ID of the price change that initiated the ticket request. |
rpm_price_change |
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_future_retail |
item |
VARCHAR2 |
25 |
Yes |
Item number |
effective_date |
xs:dateTime |
1 |
1 |
Price Change Effective Date |
rpm_future_retail |
action_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_future_retail_gtt |
pc_selling_retail_ind |
NUMBER |
1 |
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_future_retail |
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_future_retail |
selling_uom |
VARCHAR2 |
2 |
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_future_retail |
selling_retail currency |
VARCHAR2 |
3 |
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_future_retail_gtt |
pc_multi_unit_ind |
NUMBER |
1 |
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_future_retail |
multi_units |
NUMBER |
12, 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_future_retail |
multi_unit_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_future_retail |
multi_unit_retail_currency |
VARCHAR2 |
3 |
No |
Multi Unit Retail Currency |
multi_selling_uom |
varchar24 |
0 |
1 |
Multi Unit Selling UOM |
rpm_future_retail |
multi_selling_uom |
VARCHAR2 |
4 |
No |
Multi Unit Selling UOM |
ExtOfRegPrcChgDesc:ExtOfRegPrcChgDtl
|
*
|
0
|
1
|
Provide an extension hook to customize RegPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfRegPrcChgDesc:LocOfRegPrcChgDtl
|
*
|
0
|
1
|
Provide an extension hook to localize RegPrcChgDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|