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

XML-Schema Name:StkCntHdrColDesc 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 StkCntHdrColDesc 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
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 Fill column length. Yes Fill this description.

XML-Schema Name:StkCntHdrDesc 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 StkCntHdrDesc 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 The store where the stock is being counted. STOCK_COUNT STORE_ID NUMBER 10 Yes an identifier of the store where the stock count will take place.
stock_count_id number12 1 1 The unique identifier for the stock count. STOCK_COUNT ID NUMBER 12 Yes the unique identifier for the stock count. this value is generated by sim.
count_desc varchar2255 1 1 The description for the stock count. STOCK_COUNT DESCRIPTION VARCHAR2 255 Yes the description for the stock count
group_desc varchar2100 1 1 The description of the product group associated to the stock count. STOCK_COUNT PRODUCT_GROUP_DESCRIPTION VARCHAR2 100 No the description from the product group.
schedule_date xs:dateTime 1 1 The date the stock count is scheduled for. STOCK_COUNT SCHEDULE_DATE DATE No the date the stock count is scheduled for.
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 NUMBER 2 Yes "the type of stock count being performed. 1- unit, 2 - unit and amount, 3 - problem line, 4 - Adhoc, 5 - RMS Sync"
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 NUMBER 2 Yes "the status that the stock count is currently in. 0 - New, 1 - Count Scheduled, 2 - Count In progress, 3 - Count Complete, 4 - Recount Scheduled, 5 - Count in progress, 6 - Recount Complete, 7 - Approval Scheduled, 8 - Approval in Progress, 10 - Approval Processing, 12 - Approval Authorized, 14 - Approval Complete, 20 - Canceled"
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. No Derived from status.
left_to_count number12 1 1 The total remaining items from all the stock count child(ren). STOCK_COUNT_CHILD ITEMS_LEFT_TO_COUNT NUMBER 12 Yes a remaining items to be counted.