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/ItemLocRef/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:ItemLocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemLocRef
Table Name Column Name API Type Column Length API Required API Description
item varchar225 1 1 Unique identifier for the item. AS_ITM_RTL_STR ID_ITM VARCHAR2 25 Yes Unique identifier for the item.
ItemLocPhysRef * 1 unbounded Description is not available.
ExtOfItemLocRef:ExtOfItemLocRef * 0 1 Provide an extension hook to customize ItemLocRef. NA NA NA NA NA NA
LocOfItemLocRef:LocOfItemLocRef * 0 1 Provide an extension hook to localize ItemLocRef. NA NA NA NA NA NA

XML-Schema Name:ItemLocPhysRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemLocPhysRef
Table Name Column Name API Type Column Length API Required API Description
physical_loc number10 1 1 Description is not available. AS_ITM_RTL_STR ID_STR_RT number 10,0 No warehouse or store id
ItemLocVirtRef * 1 unbounded Description is not available.
ExtOfItemLocRef:ExtOfItemLocPhysRef * 0 1 Provide an extension hook to customize ItemLocPhysRef. NA NA NA NA NA NA
LocOfItemLocRef:LocOfItemLocPhysRef * 0 1 Provide an extension hook to localize ItemLocPhysRef. NA NA NA NA NA NA

XML-Schema Name:ItemLocVirtRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ItemLocVirtRef
Table Name Column Name API Type Column Length API Required API Description
loc number10 1 1 Description is not available. AS_ITM_RTL_STR ID_STR_RT number 10,0 Yes store id
ExtOfItemLocRef:ExtOfItemLocVirtRef * 0 1 Provide an extension hook to customize ItemLocVirtRef. NA NA NA NA NA NA
LocOfItemLocRef:LocOfItemLocVirtRef * 0 1 Provide an extension hook to localize ItemLocVirtRef. NA NA NA NA NA NA

XML-Schema Name:ExtOfItemLocVirtRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfItemLocVirtRef
Table Name Column Name API Type Column Length API Required API Description

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

XML-Schema Name:ExtOfItemLocPhysRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfItemLocPhysRef
Table Name Column Name API Type Column Length API Required API Description

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

XML-Schema Name:ExtOfItemLocRef Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfItemLocRef
Table Name Column Name API Type Column Length API Required API Description

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