Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StkCountSchDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:StkCountSchDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkCountSchDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
cycle_count number8 1 1 Contains the number which uniquely identifies the stock or cycle count. PRODUCT_GROUP_SCHEDULE ID Number 8 Yes Contains the number which uniquely identifies the stock or cycle count.
cycle_count_desc varchar2250 1 1 Contains a description of the cycle or stock count which, along with the cycle count number, identifies the cycle or stock count. PRODUCT_GROUP_SCHEDULE DESCRIPTION varchar2 250 No Contains a description of the cycle or stock count which, along with the cycle count number, identifies the cycle or stock count.
location_type varchar21 1 1 Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse. n/a n/a null null Yes Contains an indicator which identifies whether the cycle count will be for Stores or Warehouses. Valid values are 'S' - Store and 'W' - Warehouse.
stocktake_date xs:dateTime 1 1 Contains the date on which the stock or cycle count even will take place. PRODUCT_GROUP_SCHEDULE START_DATE RIBDate Date No Contains the date on which the stock or cycle count even will take place.
stocktake_type varchar21 1 1 Contains a value which indicates the type of stock take. Valid values are 'B' -Both Unit and Dollar and 'U' - Unit only. However the RIB interface only allows 'B'. n/a n/a null null Yes Contains a value which indicates the type of stock take. Valid values are 'B' -Both Unit and Dollar and 'U' - Unit only. However the RIB interface only allows 'B'.
StkCountSchProd * 0 unbounded Description is not available.
StkCountSchLoc * 0 unbounded Description is not available.

XML-Schema Name:StkCountSchProd Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkCountSchProd in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
dept number4 1 1 Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments. PRODUCT_GROUP_HIERARCHY DEPARTMENT_ID Number 12 No Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments.
class number4 0 1 Contains the class number where the cycle count will occur. PRODUCT_GROUP_HIERARCHY CLASS_ID Number 12 No Contains the class number where the cycle count will occur.
subclass number4 0 1 Contains the subclass number where the cycle count will occur. PRODUCT_GROUP_HIERARCHY SUBCLASS_ID Number 12 No Contains the subclass number where the cycle count will occur.

XML-Schema Name:StkCountSchLoc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkCountSchLoc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
location number10 1 1 Contains the store or wh number on the cycle count. PRODUCT_GROUP_SCHED_STORE STORE_ID Number 10,0 Yes Contains the store or wh number on the cycle count.