Retail Integration Bus Mappings Report Release:13.1 (Store Inventory Management)
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 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 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 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 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