Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOInDtl |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
wh |
number10 |
1 |
1 |
The warehouse where the work order will be done. |
n/a |
n/a |
number |
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 |
varchar2 |
1 |
Yes |
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 |
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 |
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 |
6 |
Yes |
Populates wip_code in inbound_work_order table. |
instructions |
varchar2300 |
0 |
1 |
Not used by RMS. |
inbound_work_order |
instructions |
varchar2 |
300 |
No |
* |
ExtOfWOInDesc:ExtOfWOInDtl
|
*
|
0
|
1
|
Provide an extension hook to customize WOInDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfWOInDesc:LocOfWOInDtl
|
*
|
0
|
1
|
Provide an extension hook to localize WOInDtl.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|