XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOInDtl 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 |
wh |
number10 |
1 |
1 |
The warehouse where the work order will be done. |
wo_detail |
wh |
null |
null |
Yes |
The warehouse where the work order will be done. |
item |
varchar225 |
1 |
1 |
The item on which the work order will be done. |
wo_detail |
item |
null |
null |
Yes |
The item on which the work order will be done. |
loc_type |
varchar21 |
1 |
1 |
The location type of the final destination location. Valid values are:'S' - Store or 'W' - Warehouse |
wo_detail |
loc_type |
null |
|
Yes |
The location type of the final destination location. Valid values are S (store) or W (warehouse). |
location |
number10 |
1 |
1 |
The final destination of the merchandise. If the item is predistributed this location will be the store/warehouse on the allocation. If not, it will be the same warehouse as in the wh column. |
wo_detail |
location |
null |
null |
Yes |
The final destination of the merchandise. If the item is predistributed, this location will be the store/warehouse on the allocation. If not, it will be the same warehouse as in the warehouse column. |
seq_no |
number4 |
1 |
1 |
The sequence number (needed to ensure each record is unique, since the same wip code can be listed more than once on the same work order). |
wo_detail |
seq_no |
null |
null |
Yes |
The sequence number (needed to ensure each record is unique, because the same wip code can be listed more than once on the same work order). |
wip_code |
varchar29 |
1 |
1 |
The wip code for the work to be done on the item. |
wo_detail |
wip_code |
null |
null |
Yes |
The wip code for the work to be done on the item. |
instructions |
varchar2300 |
0 |
1 |
Not used by RMS. |
* |
* |
null |
null |
No |
Not used by RMS. |