Retail Integration Mappings Report Release:16.0.030 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StrFtrInvColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StrFtrInvColDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrFtrInvColDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
StrFtrInvDesc:StrFtrInvDesc * 0 unbounded Collection of store item fture inventory information. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StrFtrInvDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrFtrInvDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
item_id varchar225 1 1 Sku number TSF_LINE_ITEM, TSF_ALLOCATION, TSF_DELV_LINE_ITEM, PURCHASE_ORDER_LINE_ITEM, DSD_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Item identifier.
store_id number10 1 1 Store identifier PURCHASE_ORDER, TSF, TSF_DELV, TSF_ALLOCATION STORE_ID NUMBER (10,0), (10,0), (10,0), (10,0) Yes Store Identifier.
src_loc_type inv_location_type 1 1 Location type of the source of the delivery. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. TSF, TSF_DELV, TSF_ALLOCATION SOURCE_TYPE NUMBER 2 Yes Source from which quantity is expected to be delivered
src_loc_id number10 1 1 Identifier of the source of the delivery. TSF, TSF_ALLOCATION, TSF_DELV, PURCHASE_ORDER SOURCE_ID, SOURCE_ID, SOURCE_ID, SUPPLIER_ID NUMBER, NUMBER, NUMBER, VARCHAR2 (10,0), (10,0), (10,0), (128) Yes Source identifier.
delivery_type inv_delivery_type 1 1 Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER, UNKNOWN. No Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER
expected_date xs:dateTime 0 1 The date the inventory is expected to arrive. TSF, TSF_ALLOCATION, TSF_DELV, PURCHASE_ORDER, DSD NOT_AFTER_DATE, QUANTITY_EXPECTED DATE No Expected Date of delivery.
inbound_qty number20_4 1 1 Amount of inventory inbound on delivery. DSD_LINE_ITEM, TSF_DELV_LINE_ITEM QUANTITY_RECEIVED, QUANTITY_DAMAGED NUMBER 20,4 No Quantity that was delivered.
ordered_qty number20_4 1 1 Amount of inventory on order. TSF_LINE_ITEM, TSF_ALLOCATION, PURCHASE_ORDER_LINE_ITEM QUANTITY_APPROVED, QUANTITY_EXPECTED, QUANTITY_EXPECTED NUMBER 20,4 No Quantity ordered