XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItemLocPhysRef 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 |
physical_loc |
number10 |
1 |
1 |
Identifier of the physical location where the item is located. |
|
|
number |
10 |
|
Identifier of the physical location where the item is located. |
loc_type |
varchar21 |
0 |
1 |
Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. |
item_loc |
loc_type |
varchar2 |
1 |
Yes |
Type of location in the location field. Valid values are S (store), W (warehouse), and E (external finisher). |
store_type |
varchar21 |
0 |
1 |
Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'.
Valid values are: 'C' = company store, 'F' = franchise store. |
store |
store_type |
varchar2 |
6 |
Yes |
This will indicate whether a particular store is a franchise or company store. |
stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'.
Valid values are: 'Y' = yes, 'N' = no. |
store, wh |
stockholding_ind |
varchar2 |
1 |
Yes |
This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Y.
This column will indicate if the warehouse is a stock holding location. In a non-multichannel environment, this will always be Y. In a multichannel environment it will be N for a physical warehouse and Y for a virtual warehouse. |
ItemLocVirtRef
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|