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/StkCntHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:StkCntHdrColDesc 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 StkCntHdrColDesc 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
StkCntHdrDesc:StkCntHdrDesc * 0 unbounded Collection of stock count objects represented by the StkCntHdrDesc payload attribute. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StkCntHdrDesc 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 StkCntHdrDesc 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 The store where the stock is being counted. STOCK_COUNT STORE_ID RIB or/and RSB or/and RSL NUMBER(10) Yes Fill this description.
stock_count_id number12 1 1 The unique identifier for the stock count. STOCK_COUNT ID RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.
count_desc varchar2255 1 1 The description for the stock count. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
group_desc varchar2100 1 1 The description of the product group associated to the stock count. STOCK_COUNT PRODUCT_GROUP_DESCRIPTION RIB or/and RSB or/and RSL VARCHAR2(1000) Yes Fill this description.
schedule_date xs:dateTime 1 1 The date the stock count is scheduled for. STOCK_COUNT SCHEDULE_DATE RIB or/and RSB or/and RSL DATE Yes Fill this description.
count_type stk_cnt_type 1 1 The type of stock count being performed. Valid values are UNIT, UNIT_AMOUNT, PROBLEM_LINE, ADHOC, RMS_SYNC, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status stk_cnt_status 1 1 The status of the stock count. Valid values are NEW, COUNT_SCHEDULED, COUNT_IN_PROGRESS, COUNT_COMPLETE, RECOUNT_SCHEDULED, RECOUNT_IN_PROGRESS, RECOUNT_COMPLETE, APPROVAL_SCHEDULED, APPROVAL_IN_PROGRESS, APPROVAL_PROCESSING, APPROVAL_AUTHORIZED, APPROVAL_COMPLETE, CANCELED, UNKNOWN. STOCK_COUNT STATUS RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
display_status stk_cnt_display_status 1 1 The display status of the stock count. 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.
left_to_count number12 1 1 The total remaining items from all the stock count child(ren). STOCK_COUNT_CHILD ITEMS_LEFT_TO_COUNT RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.