XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PrcCostDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
item |
varchar225 |
1 |
1 |
Contains the RMS item number that uniquely identifies
the item. This is required input for the Pricing Cost Service
|
future_cost |
item |
varchar2 |
25 |
Yes |
Contains the RMS item number that uniquely identifies the item. |
source_location |
number10 |
0 |
1 |
Contains the RMS Supplier number for retrieving the Pricing Cost
|
future_cost |
supplier |
number |
10 |
No |
Contains the RMS Supplier number for retrieving the Pricing Cost. |
source_location_country |
varchar23 |
0 |
1 |
Contains the country, supplier belongs to for which the Pricing
Cost needs to be retrieved.
|
future_cost |
origin_country_id |
varchar2 |
3 |
Yes |
Contains the country, supplier belongs to for which the Pricing Cost needs to be retrieved. |
fulfill_location |
number10 |
1 |
1 |
Contains the location number . This is required input for the
Pricing Cost Service.
|
future_cost |
location |
number |
10 |
Yes |
Contains the location number . |
loc_type |
loc_type |
1 |
1 |
Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). |
* |
* |
varchar2 |
1 |
Yes |
Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). Fill this description. |
channel_id |
number4 |
0 |
1 |
Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. |
channels |
channel_id |
number |
4 |
No |
Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. |
active_date |
xs:dateTime |
0 |
1 |
Contains the active date for which the pricing cost needs to be retrieved.
|
future_cost |
active_date |
date |
* |
No |
Contains the active date for which the pricing cost needs to be retrieved. |
pricing_cost |
number20_4 |
1 |
1 |
Contains the retrieved pricing cost from the future cost table
for the passed parameters.
|
future_cost |
pricing_cost |
number |
20 |
Yes |
Contains the RMS Supplier number for retrieving the Pricing Cost. |