Retail Integration Bus Mappings Report Release:13.1 (Retail Merchandizing System)
Application Retail Merchandizing System
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 rms Mapping For WOStatusDesc
Table Name Column Name API Type Column Length API Required API Description
wo_id varchar215 1 1 NA * * null null No Not used.
distro_nbr varchar210 1 1 NA tsfhead tsf_no null null Yes The transfer that this work order is part of.
distro_doc_type varchar21 1 1 NA * * null null Yes The should be 'T' for transfer.
distro_parent_nbr varchar210 0 1 The higher level transfer that this transfer is part of. tsfhead tsf_parent_no null null No The higher level transfer that this transfer is part of.
distro_parent_type varchar21 0 1 NA * * null null No Not used.
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. tsfdetail item null null Yes The item on which the work order has been completed. If an item transformation occurred, this should be the resultant item.
wh number10 1 1 NA * * null null No Not used.
loc_type varchar21 1 1 NA * * null null No Not used.
location number10 1 1 NA wh wh null null Yes The warehouse that is the finisher location.
seq_no number4 1 1 NA * * null null No Not used.
wip_code varchar29 1 1 NA * * null null No Not used.
instructions varchar2300 1 1 NA * * null null No Not used.
complete_date xs:dateTime 1 1 NA * * null null No The date the work on the item was completed.
completed_qty number12 0 1 The quantity of the item on which work has been completed. * * null null No The quantity of the item on which work has been completed.
completed_ind varchar21 1 1 NA * * null null No Not used.
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 rms Mapping For WOStatusInvAdj
Table Name Column Name API Type Column Length API Required API Description
from_disposition varchar24 1 1 NA * * null null No This entire node is not used.
to_disposition varchar24 1 1 NA * * null null No *
unit_qty number12 1 1 NA * * null null No *
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 rms 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 rms Mapping For ExtOfWOStatusDesc
Table Name Column Name API Type Column Length API Required API Description