Retail Integration Mappings Report Release:15.0.0 (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:15.0.0 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 RSL) 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 RIB or/and RSB or/and RSL NUMBER(10) Yes Fill this description.
schedule_date xs:dateTime 0 1 Retrieves only stock counts for the date the count is scheduled to commence. STOCK_COUNT SCHEDULE_DATE RIB or/and RSB or/and RSL DATE Yes Fill this description.
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 RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
department_id number12 0 1 Retrieves only stock counts associated to this department. STOCK_COUNT BREAKDOWN_TYPE RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
class_id number12 0 1 Retrieves only stock counts associated to this class. Cannot enter class without first entering department. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
subclass_id number12 0 1 Retrieves only stock counts associated to this subclass. Cannot enter subclass without first entering department and class. STOCK_COUNT BREAKDOWN_TYPE RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.