XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcInqDtl 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 |
status_code |
varchar210 |
1 |
1 |
Status Code of the Price Inquiry (Success or Business Error) |
N/A |
N/A |
N/A |
N/A |
Yes |
Status Code of the Price Inquiry - success or error |
item |
varchar225 |
1 |
1 |
Unique Identification of the Item |
RPM_FUTURE_RETAIL |
ITEM |
VARCHAR2 |
25 |
Yes |
Item Number |
location |
number10 |
1 |
1 |
Location |
RPM_FUTURE_RETAIL |
LOCATION |
NUMBER |
10 |
Yes |
Location Number |
location_type |
varchar21 |
1 |
1 |
Location Type ('S'tore or 'W'arehouse) |
RPM_FUTURE_RETAIL |
ZONE_NODE_TYPE |
NUMBER |
6 |
Yes |
Location Type |
pricing_date |
xs:dateTime |
1 |
1 |
The date the price is effective |
RPM_FUTURE_RETAIL |
ACTION_DATE |
DATE |
Fill column length. |
Yes |
The date the selling unit retail is effective |
selling_unit_retail |
number20_4 |
1 |
1 |
Selling Unit Retail |
RPM_FUTURE_RETAIL |
SELLING_RETAIL |
NUMBER |
20,4 |
Yes |
Selling Unit Retail |
selling_uom |
varchar24 |
1 |
1 |
Selling Unit of Measure |
RPM_FUTURE_RETAIL |
SELLING_UOM |
VARCHAR2 |
4 |
Yes |
Selling Unit of Measure |
multi_units |
number12_4 |
0 |
1 |
Multi Units |
RPM_FUTURE_RETAIL |
MULTI_UNITS |
NUMBER |
12,4 |
No |
Multi Units |
multi_unit_retail |
number20_4 |
0 |
1 |
Multi Unit Retail |
RPM_FUTURE_RETAIL |
MULTI_UNIT_RETAIL |
NUMBER |
20,4 |
No |
Multi Unit Retail |
multi_selling_uom |
varchar24 |
0 |
1 |
Multi Selling UOM |
RPM_FUTURE_RETAIL |
MULTI_SELLING_UOM |
VARCHAR2 |
4 |
No |
Multi Selling Unit of Measure |
currency_code |
varchar23 |
1 |
1 |
Currency Code |
RPM_FUTURE_RETAIL |
SELLING_RETAIL_CURRENCY |
VARCHAR2 |
3 |
Yes |
Selling Retail Currency Code |
price_type |
VARCHAR26 |
1 |
1 |
Selling Unit Retail Type (Regular, Clearance or Promotion depending if the item is on clearance, promotion or not) |
N/A |
N/A |
N/A |
N/A |
Yes |
Selling Unit Retail Type (Regular, Clearance or Promotion) |