XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for PODtlRef 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 |
Unique alphanumeric value to identify the item. |
item_master |
item |
varchar2 |
25 |
Yes |
Unique alphanumeric value to identify the item. |
physical_location_type |
varchar21 |
1 |
1 |
Type of location in the physical_location field. Valid values are: S = Store, W = Warehouse. |
ordloc |
loc_type |
varchar2 |
1 |
Yes |
Type of location in the physical_location field. Valid values are S = Store, W = Warehouse. |
physical_location |
number10 |
1 |
1 |
Identifier of the physical location. |
ordloc |
location |
number |
10 |
Yes |
Identifier of the physical location. |
physical_store_type |
varchar21 |
0 |
1 |
Indicates the store type of the physical_location store. Only populated if physical_location_type is 'S'.
Valid values are: 'C' = company store, 'F' = franchise store. |
store |
store_type |
varchar2 |
1 |
No |
Indicates the store type of the physical_location store. Only populated if physical_location_type is 'S'.
Valid values are 'C' = company store, 'F' = franchise store. |
physical_stockholding_ind |
varchar21 |
0 |
1 |
Indicates if the physical_location store is stockholding or not. Only populated if physical_location_type is 'S'.
Valid values are: 'Y' = yes, 'N' = no. |
store |
stockholding_ind |
varchar2 |
1 |
Yes |
Indicates if the physical_location store is stockholding or not. Only populated if physical_location_type is 'S'.
Valid values are 'Y' = yes, 'N' = no. |