Retail Integration Mappings Report Release:15.0.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.
XSD Structure

XML-Schema Name:WOStatusDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOStatusDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
wo_id varchar215 1 1 NA Fill application table name. null null null null Not used in SIM
distro_nbr varchar212 1 1 NA Fill application table name. null null null null Not used in SIM
distro_doc_type varchar21 1 1 NA Fill application table name. null null null null Not used in SIM
distro_parent_nbr varchar212 0 1 The higher level transfer that this transfer is part of. Fill application table name. 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. Fill application table name. null null null null Not used in SIM
wh number10 1 1 NA Fill application table name. null null null null Not used in SIM
loc_type varchar21 1 1 NA Fill application table name. null null null null Not used in SIM
location number10 1 1 NA Fill application table name. null null null null Not used in SIM
seq_no number4 1 1 NA Fill application table name. null null null null Not used in SIM
wip_code varchar29 1 1 NA Fill application table name. null null null null Not used in SIM
instructions varchar2300 1 1 NA Fill application table name. null null null null Not used in SIM
complete_date xs:dateTime 1 1 NA Fill application table name. null null null null Not used in SIM
completed_qty number12 0 1 The quantity of the item on which work has been completed. Fill application table name. null null null null Not used in SIM
completed_ind varchar21 1 1 NA Fill application table name. null null null null Not used in SIM
WOStatusInvAdj * 0 unbounded NA

XML-Schema Name:WOStatusInvAdj Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for WOStatusInvAdj in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
from_disposition varchar24 1 1 NA Fill application table name. null null null null Not used in SIM
to_disposition varchar24 1 1 NA Fill application table name. null null null null Not used in SIM
unit_qty number12 1 1 NA Fill application table name. null null null null Not used in SIM