XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for WOInDtl in RWMS application. |
RWMS's Table Name |
RWMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RWMS's Column Length |
Is Column Required in RWMS's API? |
RWMS's API Description |
wh |
number10 |
1 |
1 |
The warehouse where the work order will be done. |
n/a |
n/a |
varchar2 |
10 |
Yes |
Not used by RWMS. |
item |
varchar225 |
1 |
1 |
The item on which the work order will be done. |
inbound_work_order |
item_id |
varchar2 |
25 |
Yes |
Populates item_id in inbound_work_order table |
loc_type |
varchar21 |
1 |
1 |
The location type of the final destination location. Valid values are:'S' - Store or 'W' - Warehouse |
n/a |
n/a |
* |
* |
No |
Not used by RWMS. |
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. |
inbound_work_order |
dest_id |
number |
10 |
Yes |
A number which uniquely identifies a destination to which the DC delivers goods. Populates dest_id in inbound_work_order table. |
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). |
inbound_work_order |
wip_seq_no |
number |
4 |
Yes |
Order in which WIP Codes are processed. Populates wip_seq_no in inbound_work_order table |
wip_code |
varchar29 |
1 |
1 |
The wip code for the work to be done on the item. |
inbound_work_order |
wip_code |
varchar2 |
9 |
Yes |
Work in process code setup in wip_code table. Populates wip_code in inbound_work_order table. |
instructions |
varchar2300 |
0 |
1 |
Not used by RMS. |
inbound_work_order |
instructions |
varchar2 |
300 |
No |
A field to indicate specific instructions needed to be processed for the inbound work order. |