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

XML-Schema Name:StkCntDesc 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 StkCntDesc 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
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.
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.
product_group_id number10 0 1 The unique identifier for the product group used for the stock count. STOCK_COUNT PRODUCT_GROUP_ID RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.
schedule_id number10 0 1 The unique identifier for the product group schedule attached to the stock count.. STOCK_COUNT PRODUCT_GROUP_SCHEDULE_ID RIB or/and RSB or/and RSL NUMBER(12) 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. STOCK_COUNT TYPE. RIB or/and RSB or/and RSL NUMBER(2) 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.
counting_method stk_cnt_method 1 1 The counting method of the stock count. Valid values are GUIDED, UNGUIDED, THIRD_PARTY, AUTO, UNKNOWN. STOCK_COUNT COUNTING_METHOD RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
stock_count_time_frame stk_cnt_time_frame 1 1 Time frame indicator for whether snapshot of the stock count took place before or after the store opened. Valid values are BEFORE_STORE_OPEN, AFTER_STORE_CLOSE, NONE. STOCK_COUNT BEFORE_STORE_OPEN RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
group_type stk_cnt_breakdown_type 1 1 Indicates how the stock count items should be broken into stock count children.. Valid values are DEPARTMENT, CLASS, SUBCLASS, LOCATION, NONE. STOCK_COUNT BREAKDOWN_TYPE RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
count_desc varchar2255 1 1 The description of the stock count. STOCK_COUNT DESCRIPTION RIB or/and RSB or/and RSL VARCHAR2(255) Yes Fill this description.
group_desc varchar2128 0 1 The description of the product group. STOCK_COUNT PRODUCT_GROUP_DESCRIPTION RIB or/and RSB or/and RSL VARCHAR2(100) Yes Fill this description.
schedule_date xs:dateTime 0 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_start_time number18 0 1 The time in milliseconds that the count began. STOCK_COUNT START_TIME RIB or/and RSB or/and RSL DATE Yes Fill this description.
last_updated_time xs:dateTime 0 1 The date and time the stock count last had an update. STOCK_COUNT UPDATE_DATE_TIME RIB or/and RSB or/and RSL DATE Yes Fill this description.
export_user varchar240 0 1 The person or operator that exported the stock count. STOCK_COUNT EXPORT_USER RIB or/and RSB or/and RSL VARCHAR2(20) Yes Fill this description.
variance_count number12 0 1 The number of units in standard uom that will determine if an item on the count is to be considered discrepant. STOCK_COUNT VARIANCE_COUNT RIB or/and RSB or/and RSL NUMBER(12,4) Yes Fill this description.
variance_percent number12 0 1 The percentage of units in standard uom that will determine if an item on the count is to be considered discrepant. STOCK_COUNT VARIANCE_PERCENT RIB or/and RSB or/and RSL NUMBER(12,4) Yes Fill this description.
variance_value number12 0 1 The cost value variance from expected that will determine if an item on the count is to be considered discrepant. STOCK_COUNT VARIANCE_VALUE RIB or/and RSB or/and RSL NUMBER(12,4) Yes Fill this description.
recount_active xs:boolean 1 1 True indicates the stock count items should be recounted. STOCK_COUNT RECOUNT RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
auto_authorize xs:boolean 1 1 True indicates the stock count is auto authorized after counting. STOCK_COUNT AUTO_AUTHORIZE RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
pbl_pick_less_suggested xs:boolean 1 1 True indicates that items with action pick amount less than suggested amount are included. STOCK_COUNT PICK_LESS_SUGGESTED RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
pbl_repl_less_suggested xs:boolean 1 1 True indicates that items with replenishment amount less than suggested amount are included. STOCK_COUNT REPL_LESS_SUGGESTED RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
pbl_repl_neg_available xs:boolean 1 1 True indicates items with negative available inventory are included. STOCK_COUNT REPL_NEGATIVE_AVAILABLE RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
pbl_repl_discrepant_uin xs:boolean 1 1 True indicates items with serial number discrepancies are included. STOCK_COUNT UIN_DISCREPANT RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
include_active_items xs:boolean 1 1 True if the stock count includes active items. STOCK_COUNT INACTIVE_ITEMS RIB or/and RSB or/and RSL NUMBER(1) Yes Fill this description.
include_inactive_items xs:boolean 1 1 True if the stock count includes inactive items. STOCK_COUNT INACTIVE_ITEMS RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
include_discontinued_items xs:boolean 1 1 True if the stock count includes discontinued items. STOCK_COUNT DISCONTINUED_ITEMS RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
include_deleted_items xs:boolean 1 1 True if the stock count includes deleted items. STOCK_COUNT DELETED_ITEMS RIB or/and RSB or/and RSL NUMBER(1) Yes Fill this description.
include_soh_zero xs:boolean 1 1 "True if the stock count includes items whose stock on hand is zero. STOCK_COUNT SOH_ZERO RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
include_soh_less_than_zero xs:boolean 1 1 "True if the stock count includes items whose stock on hand is less than zero. STOCK_COUNT SOH_NEGATIVE RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
include_soh_greater_than_zero xs:boolean 1 1 "True if the stock count includes items whose stock on hand is greater than zero. STOCK_COUNT SOH_POSITIVE RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
total_on_count number12 1 1 The total number of items to be counted. STOCK_COUNT TOTAL_ITEM_COUNT RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.
left_to_count number12 1 1 The total remaining items to be counted. STOCK_COUNT_CHILD TOTAL_ITEM_COUNT RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.
all_items xs:boolean 1 1 True indicates the stock count is an all store items count. STOCK_COUNT ALL_ITEMS RIB or/and RSB or/and RSL VARCHAR2(1) Yes Fill this description.
CountChild * 0 1000 A collection of stock count children associated with the stock count.

XML-Schema Name:CountChild 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 CountChild 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
child_id varchar225 1 1 The unique identifier of the stock count child. STOCK_COUNT_CHILD ID RIB or/and RSB or/and RSL NUMBER(12) Yes The unique identifier of the stock count child.
description varchar240 1 1 The description of the stock count child based on department or location. STOCK_COUNT_CHILD DESCRIPTION RIB or/and RSB or/and RSL VARCHAR2(1000) Yes The description of the stock count child based on department or location.
status stk_cnt_status 1 1 Status of the stock count child which may be different from the parent 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_CHILD STATUS RIB or/and RSB or/and RSL NUMBER(2) Yes Fill this description.
display_status stk_cnt_display_status 1 1 Display status of the stock count child which may be different from the parent 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 remaining items to be counted in the stock count child. STOCK_COUNT_CHILD ITEMS_LEFT_TO_COUNT RIB or/and RSB or/and RSL NUMBER(12) Yes Fill this description.