Retail Integration Bus Mappings Report Release:13.1.1 (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.

XML-Schema Name:StkCountSchDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For StkCountSchDesc
Table Name Column Name API Type Column Length API Required 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 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. stake_head cycle_count_desc varchar2 250 Yes 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. stake_head loc_type 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. stake_head stocktake_date RIBDate * Yes 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'. stake_head stocktake_type varchar2 1 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.
ExtOfStkCountSchDesc:ExtOfStkCountSchDesc * 0 1 Provide an extension hook to customize StkCountSchDesc. NA NA NA NA NA NA

XML-Schema Name:StkCountSchProd Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For StkCountSchProd
Table Name Column Name API Type Column Length API Required 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 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. stake_product class null null 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. stake_product subclass null null No Contains the subclass number where the cycle count will occur.
ExtOfStkCountSchDesc:ExtOfStkCountSchProd * 0 1 Provide an extension hook to customize StkCountSchProd. NA NA NA NA NA NA

XML-Schema Name:ExtOfStkCountSchProd Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfStkCountSchProd
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:StkCountSchLoc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For StkCountSchLoc
Table Name Column Name API Type Column Length API Required 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 wh number on the cycle count.
ExtOfStkCountSchDesc:ExtOfStkCountSchLoc * 0 1 Provide an extension hook to customize StkCountSchLoc. NA NA NA NA NA NA

XML-Schema Name:ExtOfStkCountSchLoc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfStkCountSchLoc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfStkCountSchDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfStkCountSchDesc
Table Name Column Name API Type Column Length API Required API Description