Retail Integration Mappings Report Release:16.0.030 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/StkCntHdrCriVo/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StkCntHdrCriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StkCntHdrCriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
store_id number10 1 1 Retrieves only stock counts for this store. STOCK_COUNT STORE_ID NUMBER 10 Yes the unique identifier of the store where the stock count is taking place.
schedule_date xs:dateTime 0 1 Retrieves only stock counts for the date the count is scheduled to commence. STOCK_COUNT SCHEDULE_DATE DATE Yes the date the stock count is scheduled for.
count_phase stk_cnt_phase 1 1 Retrieves only stock counts at this phase. Valid values are FUTURE, COUNT, RECOUNT, AUTHORIZE, UNKNOWN. STOCK_COUNT PHASE NUMBER 2 Yes "the phase that the stock count is in. 0 - Future, 1 - Count, 2 - Recount, 3 - Authorize"
display_status stk_cnt_display_status 1 1 Retrieves only stock counts with this display status. Valid values are NONE, NEW, ACTIVE, IN_PROGRESS, PENDING, PROCESSING, AUTHORIZED, COMPLETED, CANCELED, VIEW_ONLY. STOCK_COUNT STATUS NUMBER 2 Yes Derived from status of the stock count.
department_id number12 0 1 Retrieves only stock counts associated to this department. STOCK_COUNT_LINE_ITEM DEPARTMENT_ID NUMBER 12 Yes an identifier of the department of an item that is being counted as part of this stock count.
class_id number12 0 1 Retrieves only stock counts associated to this class. Cannot enter class without first entering department. STOCK_COUNT_LINE_ITEM CLASS_ID NUMBER 12 Yes an identifier of the class of an item that is being counted as part of this stock count.
subclass_id number12 0 1 Retrieves only stock counts associated to this subclass. Cannot enter subclass without first entering department and class. STOCK_COUNT_LINE_ITEM SUBCLASS_ID NUMBER 12 Yes n identifier of the subclass of an item that is being counted as part of this stock count.