Retail Integration Bus Mappings Report Release:13.1 (Retail Warehouse Management System)
Application Retail Warehouse Management System
Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemWHDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ItemWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ItemWHDesc
Table Name Column Name API Type Column Length API Required API Description
ItemHdrWHDesc:ItemHdrWHDesc * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupWHDesc:ItemSupWHDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ItemSupCtyWHDesc:ItemSupCtyWHDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ISCDimWHDesc:ISCDimWHDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ExtOfItemWHDesc:ExtOfItemWHDesc * 0 1 Provide an extension hook to customize ItemWHDesc. NA NA NA NA NA NA

XML-Schema Name:ItemHdrWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ItemHdrWHDesc
Table Name Column Name API Type Column Length API Required API Description
from_location varchar210 0 1 Description is not available. NA NA NA NA NA NA
to_location varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemid varchar225 0 1 Description is not available. NA NA NA NA NA NA
description varchar21000 0 1 Description is not available. NA NA NA NA NA NA
vendornbr varchar210 0 1 Description is not available. NA NA NA NA NA NA
containertype varchar26 0 1 Description is not available. NA NA NA NA NA NA
conveyableflag varchar21 0 1 Description is not available. NA NA NA NA NA NA
stdunitqty number12_4 0 1 Description is not available. NA NA NA NA NA NA
hazardmatlcode varchar26 0 1 Description is not available. NA NA NA NA NA NA
highvalueind varchar21 0 1 Description is not available. NA NA NA NA NA NA
department number4 0 1 Description is not available. NA NA NA NA NA NA
class varchar27 0 1 Description is not available. NA NA NA NA NA NA
singlecontainerbulk varchar21 0 1 Description is not available. NA NA NA NA NA NA
subclass varchar24 0 1 Description is not available. NA NA NA NA NA NA
expirationdays number4 0 1 Description is not available. NA NA NA NA NA NA
perishableind varchar21 0 1 Description is not available. NA NA NA NA NA NA
division number4 0 1 Description is not available. NA NA NA NA NA NA
putawaybyvolume varchar21 0 1 Description is not available. NA NA NA NA NA NA
stdunitfactor number6_2 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda1 varchar210 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda2 varchar210 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda3 varchar210 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda4 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda5 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda6 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda7 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda8 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda9 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda10 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda11 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda12 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda13 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda14 varchar220 0 1 Description is not available. NA NA NA NA NA NA
itemmasteruda15 varchar220 0 1 Description is not available. NA NA NA NA NA NA
nonsaleable varchar21 0 1 Description is not available. NA NA NA NA NA NA
brand varchar210 0 1 Description is not available. NA NA NA NA NA NA
fragile varchar21 0 1 Description is not available. NA NA NA NA NA NA
rigid varchar21 0 1 Description is not available. NA NA NA NA NA NA
standarduom varchar24 0 1 Description is not available. NA NA NA NA NA NA
uomconvfactor number20_10 0 1 Description is not available. NA NA NA NA NA NA
ExtOfItemHdrWHDesc:ExtOfItemHdrWHDesc * 0 1 Provide an extension hook to customize ItemHdrWHDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemHdrWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfItemHdrWHDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ItemSupWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ItemSupWHDesc
Table Name Column Name API Type Column Length API Required API Description
itemid varchar225 0 1 Description is not available. NA NA NA NA NA NA
from_location varchar210 0 1 Description is not available. NA NA NA NA NA NA
to_location varchar220 0 1 Description is not available. NA NA NA NA NA NA
vendornbr varchar210 0 1 Description is not available. NA NA NA NA NA NA
vpn varchar230 0 1 Description is not available. NA NA NA NA NA NA
ExtOfItemSupWHDesc:ExtOfItemSupWHDesc * 0 1 Provide an extension hook to customize ItemSupWHDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemSupWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfItemSupWHDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ItemSupCtyWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ItemSupCtyWHDesc
Table Name Column Name API Type Column Length API Required API Description
itemid varchar225 1 1 Description is not available. NA NA NA NA NA NA
origincountryid varchar23 1 1 Description is not available. NA NA NA NA NA NA
from_location varchar210 1 1 Description is not available. NA NA NA NA NA NA
to_location varchar220 1 1 Description is not available. NA NA NA NA NA NA
dcti number12_4 1 1 Description is not available. NA NA NA NA NA NA
dchi number12_4 1 1 Description is not available. NA NA NA NA NA NA
supppacksize number12_4 1 1 Description is not available. NA NA NA NA NA NA
innerpacksize number12_4 1 1 Description is not available. NA NA NA NA NA NA
stackability number4 1 1 Description is not available. NA NA NA NA NA NA
ExtOfItemSupCtyWHDesc:ExtOfItemSupCtyWHDesc * 0 1 Provide an extension hook to customize ItemSupCtyWHDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemSupCtyWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfItemSupCtyWHDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ISCDimWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ISCDimWHDesc
Table Name Column Name API Type Column Length API Required API Description
itemid varchar225 0 1 Description is not available. NA NA NA NA NA NA
from_location varchar210 0 1 Description is not available. NA NA NA NA NA NA
to_location varchar220 0 1 Description is not available. NA NA NA NA NA NA
dimobject varchar26 0 1 Description is not available. NA NA NA NA NA NA
length number12_4 0 1 Description is not available. NA NA NA NA NA NA
width number12_4 0 1 Description is not available. NA NA NA NA NA NA
height number6_2 0 1 Description is not available. NA NA NA NA NA NA
weight number12_4 0 1 Description is not available. NA NA NA NA NA NA
dimobjectdesc varchar240 0 1 Description is not available. NA NA NA NA NA NA
velocity number12_4 0 1 Description is not available. NA NA NA NA NA NA
ExtOfISCDimWHDesc:ExtOfISCDimWHDesc * 0 1 Provide an extension hook to customize ISCDimWHDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfISCDimWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfISCDimWHDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfItemWHDesc Version:13.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfItemWHDesc
Table Name Column Name API Type Column Length API Required API Description