Retail Integration Bus Mappings Report Release:13.2.0 (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.2.0 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 Not used in SIM
distro_nbr varchar210 1 1 NA null null null null Not used in SIM
distro_doc_type varchar21 1 1 NA null null null null Not used in SIM
distro_parent_nbr varchar210 0 1 The higher level transfer that this transfer is part of. null null null null Not used in SIM
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 Not used in SIM
wh number10 1 1 NA null null null null Not used in SIM
loc_type varchar21 1 1 NA null null null null Not used in SIM
location number10 1 1 NA null null null null Not used in SIM
seq_no number4 1 1 NA null null null null Not used in SIM
wip_code varchar29 1 1 NA null null null null Not used in SIM
instructions varchar2300 1 1 NA null null null null Not used in SIM
complete_date xs:dateTime 1 1 NA null null null null Not used in SIM
completed_qty number12 0 1 The quantity of the item on which work has been completed. null null null null Not used in SIM
completed_ind varchar21 1 1 NA null null null null Not used in SIM
WOStatusInvAdj * 0 unbounded NA
ExtOfWOStatusDesc:ExtOfWOStatusDesc * 0 1 Provide an extension hook to customize WOStatusDesc. NA NA NA NA NA NA
LocOfWOStatusDesc:LocOfWOStatusDesc * 0 1 Provide an extension hook to localize WOStatusDesc. NA NA NA NA NA NA

XML-Schema Name:WOStatusInvAdj Version:13.2.0 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 Not used in SIM
to_disposition varchar24 1 1 NA null null null null Not used in SIM
unit_qty number12 1 1 NA null null null null Not used in SIM
ExtOfWOStatusDesc:ExtOfWOStatusInvAdj * 0 1 Provide an extension hook to customize WOStatusInvAdj. NA NA NA NA NA NA
LocOfWOStatusDesc:LocOfWOStatusInvAdj * 0 1 Provide an extension hook to localize WOStatusInvAdj. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOStatusInvAdj Version:13.2.0 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:LocOfWOStatusInvAdj Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfWOStatusInvAdj
Table Name Column Name API Type Column Length API Required API Description
InWOStatusDesc:InWOStatusInvAdj * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOStatusDesc:BrWOStatusInvAdj * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfWOStatusDesc Version:13.2.0 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

XML-Schema Name:LocOfWOStatusDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For LocOfWOStatusDesc
Table Name Column Name API Type Column Length API Required API Description
InWOStatusDesc:InWOStatusDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrWOStatusDesc:BrWOStatusDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA