Oracle Portal
 Retail Integration Bus Mappings Report     Release: 13.0.1

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:StkCountSchDesc.xsd
Tag Name Table Name Column Name API Req Description
cycle_count RK_STK_CT STK_CT_ID Yes Contains the number which uniquely identifies the stock count
cycle_count_desc RK_STK_CT DESCRIPTION No Contains a description of the stock count
location_type n/a n/a 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 RK_STK_CT START_DATE Yes Contains the date on which the stock or cycle count even will take place
stocktake_type n/a n/a 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 * * * *
StkCountSchLoc * * * *

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:StkCountSchProd
Tag Name Table Name Column Name API Req Description
dept RK_STK_CT_GRP_MH MH_ID Yes Contains the department number where the cycle count will occur. If the value = -1, the stock count will applies to all departments.
class RK_STK_CT_GRP_MH MH_ID No Contains the class number where the cycle count will occur.
subclass RK_STK_CT_GRP_MH MH_ID No Contains the subclass number where the cycle count will occur.

Application Name: Store Inventory Management
Version 13.0.1
XML-Schema or Node Name:StkCountSchLoc
Tag Name Table Name Column Name API Req Description
location RK_STK_CT_STORE ID_STR_RT No Contains the store or wh number on the stock count.