XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocPOTsfItmSlsDesc 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 |
eow_date |
xs:dateTime |
1 |
1 |
Description is not available. |
item_loc_hist |
eow_date |
date |
Fill column length. |
Yes |
This field contains the end of the week date of the week for the sales total and other calculations. |
quantity |
number12_4 |
1 |
1 |
Description is not available. |
item_loc_hist |
sales_issues |
number |
(12,4) |
Yes |
This field contains the total number of units sold or transferred for item/location/date/sales_type combination depending on if the location type is store or warehouse, respectively. |
sales_value |
number20_4 |
1 |
1 |
Description is not available. |
item_loc_hist |
value |
number |
(20,4) |
Yes |
This field contains the retail value of the sales for the item/location/week/sales type combination. This field is stored in the local currency. This field will only hold a value for stores. |
sales_type |
varchar21 |
1 |
1 |
Description is not available. |
item_loc_hist |
sales_type |
varchar2 |
1 |
Yes |
This field indicates the type of sale or inventory movement. |