Retail Integration Mappings Report Release:16.0.21 (Retail Order Broker)
Application Retail Order Broker
Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAvToPromColCriVo/v1
Version 1.0
Description This object holds a collection of InvAvToPromCriVo business objects.
XSD Structure

XML-Schema Name:InvAvToPromColCriVo Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvAvToPromColCriVo in ROB application.
ROB's Table Name ROB's Column Name Integration API(RIB or/and RSB or/and RSL) ROB's Column Length Is Column Required in ROB's API? ROB's API Description
InvAvToPromCriVo:InvAvToPromCriVo * 0 999 Inventory available-to-promise query criteria. NA NA NA NA NA NA
collection_size number3 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:InvAvToPromCriVo Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for InvAvToPromCriVo in ROB application.
ROB's Table Name ROB's Column Name Integration API(RIB or/and RSB or/and RSL) ROB's Column Length Is Column Required in ROB's API? ROB's API Description
item varchar225 1 1 Contains the item identifier for which to check inventory. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
min_qty number12_4 1 1 Contains the minimum item quantity needed. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
unit_of_measure varchar24 0 1 Contains the unit of measure for quantity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
InvAvLocation * 0 999 Contains the locations at which to check inventory.
sa:SearchAreaDesc * 0 1 Used for proximity calculation. This defines the criteria to identify the inventory locations. Not used when request specifies inventory locations. NA NA NA NA NA NA