Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
cycle_count number8 1 1 Contains the number which uniquely identifies the stock or cycle count. stake_head cycle_count number 8 Yes Contains the number to uniquely identify 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. stake_head cycle_count_desc varchar2 250 Yes Contains a description of the cycle or stock count that 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. stake_head loc_type null null Yes Indicates whether the cycle count is 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. stake_head stocktake_date RIBDate * Yes Contains the date on which the stock or cycle count event 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'. stake_head stocktake_type varchar2 1 Yes Indicates the type of stock take. Valid values are B (Both Unit and Dollar) and U (Unit Only). However, the RIB interface allows only 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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS'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. stake_product dept null null Yes Contains the department number for which the cycle count will occur. If the value = -1, the stock count will apply to all departments.
class number4 0 1 Contains the class number where the cycle count will occur. stake_product class null null No Contains the class number for which the cycle count will occur.
subclass number4 0 1 Contains the subclass number where the cycle count will occur. stake_product subclass null null No Contains the subclass number for which 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 RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
location number10 1 1 Contains the store or wh number on the cycle count. stake_location location null null Yes Contains the store or warehouse number on the cycle count.