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/InvAvailColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:InvAvailColDesc 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 InvAvailColDesc 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
InvAvailDesc:InvAvailDesc * 0 unbounded A collection of InvAvailDesc objects. NA NA NA NA NA NA
collection_size number6 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:InvAvailDesc 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 InvAvailDesc 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 The item identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
location number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
loc_type loc_type 1 1 Type of location. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
channel_id number4 0 1 Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is warehouse, this is optional based on the input criteria. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
available_qty number12_4 1 1 Contains the available quantity for the item/location in standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
unit_of_measure varchar24 1 1 Contains the unit of measure for available quantity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
available_date xs:dateTime 0 1 The date at which this quantity of inventory is available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
pack_calculate_ind pack_calculate_ind 0 1 Valid for pack item only. Indicate if the pack item available quantity is actual held value ('N') or calculated using pack component ('Y'). Calculated pack quantity should be treated as an estimate value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
Dist:DistanceDesc * 0 1 Gives the distance of the location from the center of Search Area. NA NA NA NA NA NA