Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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.2.0 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 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.
ExtOfStkCountSchDesc:ExtOfStkCountSchDesc * 0 1 Provide an extension hook to customize StkCountSchDesc. NA NA NA NA NA NA
LocOfStkCountSchDesc:LocOfStkCountSchDesc * 0 1 Provide an extension hook to localize StkCountSchDesc. NA NA NA NA NA NA

XML-Schema Name:StkCountSchProd Version:13.2.0 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 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.
ExtOfStkCountSchDesc:ExtOfStkCountSchProd * 0 1 Provide an extension hook to customize StkCountSchProd. NA NA NA NA NA NA
LocOfStkCountSchDesc:LocOfStkCountSchProd * 0 1 Provide an extension hook to localize StkCountSchProd. NA NA NA NA NA NA

XML-Schema Name:ExtOfStkCountSchProd Version:13.2.0 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:LocOfStkCountSchProd Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfStkCountSchProd
Table Name Column Name API Type Column Length API Required API Description
InStkCountSchDesc:InStkCountSchProd * 0 unbounded India Localization. NA NA NA NA NA NA
BrStkCountSchDesc:BrStkCountSchProd * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:StkCountSchLoc Version:13.2.0 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 warehouse number on the cycle count.
ExtOfStkCountSchDesc:ExtOfStkCountSchLoc * 0 1 Provide an extension hook to customize StkCountSchLoc. NA NA NA NA NA NA
LocOfStkCountSchDesc:LocOfStkCountSchLoc * 0 1 Provide an extension hook to localize StkCountSchLoc. NA NA NA NA NA NA

XML-Schema Name:ExtOfStkCountSchLoc Version:13.2.0 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:LocOfStkCountSchLoc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfStkCountSchLoc
Table Name Column Name API Type Column Length API Required API Description
InStkCountSchDesc:InStkCountSchLoc * 0 unbounded India Localization. NA NA NA NA NA NA
BrStkCountSchDesc:BrStkCountSchLoc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfStkCountSchDesc Version:13.2.0 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

XML-Schema Name:LocOfStkCountSchDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfStkCountSchDesc
Table Name Column Name API Type Column Length API Required API Description
InStkCountSchDesc:InStkCountSchDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrStkCountSchDesc:BrStkCountSchDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA