Application
|
Store Inventory Management
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/WOStatusDesc/v1
|
Version
|
1.0
|
Description
|
This is root element of this document which contains name space definitions for the document elements.
|
|
|
|
XML-Schema Name:WOStatusDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For WOStatusDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
wo_id |
varchar215 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
distro_nbr |
varchar210 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
distro_doc_type |
varchar21 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
distro_parent_nbr |
varchar210 |
0 |
1 |
The higher level transfer that this transfer is part of. |
|
null |
null |
null |
null |
null |
distro_parent_type |
varchar21 |
0 |
1 |
NA |
|
null |
null |
null |
null |
null |
item |
varchar225 |
0 |
1 |
The item on which the work order has been completed. If an item transformation occurred, this should be the resultant item. |
|
null |
null |
null |
null |
null |
wh |
number10 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
loc_type |
varchar21 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
location |
number10 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
seq_no |
number4 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
wip_code |
varchar29 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
instructions |
varchar2300 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
complete_date |
xs:dateTime |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
completed_qty |
number12 |
0 |
1 |
The quantity of the item on which work has been completed. |
|
null |
null |
null |
null |
null |
completed_ind |
varchar21 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
WOStatusInvAdj
|
*
|
0
|
unbounded
|
NA
|
|
|
|
|
|
|
ExtOfWOStatusDesc:ExtOfWOStatusDesc
|
*
|
0
|
1
|
Provide an extension hook to customize WOStatusDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:WOStatusInvAdj
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For WOStatusInvAdj |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
from_disposition |
varchar24 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
to_disposition |
varchar24 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
unit_qty |
number12 |
1 |
1 |
NA |
|
null |
null |
null |
null |
null |
ExtOfWOStatusDesc:ExtOfWOStatusInvAdj
|
*
|
0
|
1
|
Provide an extension hook to customize WOStatusInvAdj.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfWOStatusInvAdj
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfWOStatusInvAdj |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|
XML-Schema Name:ExtOfWOStatusDesc
|
Version:13.1.1
|
Return to Top
|
Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
sim Mapping For ExtOfWOStatusDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
|
|