Application
|
Retail Warehouse Management System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/WOInRef/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:WOInRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOInRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
wo_id |
number10 |
1 |
1 |
Description is not available. |
* |
* |
number |
10 |
Yes |
* |
order_no |
varchar210 |
1 |
1 |
Description is not available. |
inbound_work_order |
po_nbr |
varchar2 |
10 |
Yes |
* |
WOInDtlRef
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfWOInRef:ExtOfWOInRef
|
*
|
0
|
1
|
Provide an extension hook to customize WOInRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfWOInRef:LocOfWOInRef
|
*
|
0
|
1
|
Provide an extension hook to localize WOInRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:WOInDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For WOInDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
wh |
number10 |
1 |
1 |
Description is not available. |
* |
* |
number |
10 |
Yes |
* |
item |
varchar225 |
1 |
1 |
Description is not available. |
inbound_work_order |
item_id |
varchar2 |
25 |
Yes |
* |
loc_type |
varchar21 |
1 |
1 |
The location type of the final destination location. Valid values are:'S' - Store 'W' - Warehouse |
* |
* |
varchar2 |
1 |
Yes |
* |
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 |
* |
seq_no |
number4 |
1 |
1 |
Description is not available. |
inbound_work_order |
wip_seq_nbr |
number |
4 |
Yes |
* |
wip_code |
varchar29 |
1 |
1 |
Description is not available. |
inbound_work_order |
wip_code |
varchar2 |
6 |
Yes |
* |
ExtOfWOInRef:ExtOfWOInDtlRef
|
*
|
0
|
1
|
Provide an extension hook to customize WOInDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
LocOfWOInRef:LocOfWOInDtlRef
|
*
|
0
|
1
|
Provide an extension hook to localize WOInDtlRef.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOInDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOInDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfWOInDtlRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For LocOfWOInDtlRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InWOInRef:InWOInDtlRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrWOInRef:BrWOInDtlRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOInRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For ExtOfWOInRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:LocOfWOInRef
|
Version:13.2.0
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rwms Mapping For LocOfWOInRef |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
InWOInRef:InWOInRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrWOInRef:BrWOInRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|