Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim 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. |
RK_PRICE_CHANGE |
PRICE_CHANGE_ID |
NUMBER |
128 |
Yes |
Contains the ID of the price change that initiated the ticket request. |
item |
varchar225 |
1 |
1 |
Alphanumeric value that identifies the item for which tickets have been requested. |
RK_PRICE_CHANGE |
ID_ITM |
VARCHAR2 |
25 |
No |
Alphanumeric value that identifies the item for which tickets have been requested. |
effective_date |
xs:dateTime |
1 |
1 |
Price Change Effective Date |
RK_PRICE_CHANGE |
EFFECTIVE_DATE |
DATE |
|
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. |
RK_PRICE_CHANGE |
SELLING_UNIT_CHANGE_IND |
number |
1 |
No |
Indicates whether the selling retail price has been changed. Valid values are '0' - no change or '1' - retail is changed. |
selling_unit_retail |
number20_4 |
1 |
1 |
This field contains the unit retail for the item at the indicated location. |
RK_PRICE_CHANGE |
UNIT_RETAIL |
VARCHAR2 |
75 |
No |
This field contains the unit retail for the item at the indicated location. |
selling_uom |
varchar24 |
1 |
1 |
Holds the selling unit of measure for an item's single-unit retail. |
RK_PRICE_CHANGE |
SELLING_UOM |
VARCHAR2 |
40 |
No |
Holds the selling unit of measure for an item's single-unit retail. |
selling_currency |
varchar23 |
1 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
RK_PRICE_CHANGE |
SELLING_RETAIL_CURRENCY |
varchar2 |
3 |
No |
Contains the currency code that should match the store's or warehouse's 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. |
RK_PRICE_CHANGE |
MULTI_UNIT_CHANGED_IND |
number |
1 |
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 |
RK_PRICE_CHANGE |
MULTI_UNITS |
number |
12 |
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. |
RK_PRICE_CHANGE |
MULTI_UNIT_RETAIL |
VARCHAR2 |
75 |
No |
This field contains the multi-unit retail for the item at the indicated location. |
multi_unit_retail_currency |
varchar23 |
0 |
1 |
Contains the currency code that should match the store's or warehouse's currency code. |
|
null |
varchar2 |
3 |
null |
null |
multi_selling_uom |
varchar24 |
0 |
1 |
Multi Unit Selling UOM |
RK_PRICE_CHANGE |
MULTI_SELLING_UOM |
varchar2 |
40 |
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
|