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

XML-Schema Name:StkCntChdDesc 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 StkCntChdDesc 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 an identifier of a stock count.
stock_count_child_id number12 1 1 The unique identifier for the stock count child. STOCK_COUNT_CHILD ID RIB or/and RSB or/and RSL NUMBER(12) Yes the unique identifier for each record on the table. this value is system generated.
count_desc varchar2255 0 1 The description for the stock count child, based on department or location. STOCK_COUNT_CHILD Fill table column name. RIB or/and RSB or/and RSL VARCHAR2(1000) Yes the description of stock count location.
status stk_cnt_status 1 1 The status of the stock count child. 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 The status of the stock count child. 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.
display_status stk_cnt_display_status 1 1 The display status of the stock count child. 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.
area store_sequence_area_type 1 1 The area within the store the stock count child is for. Valid values are NO_LOCATION, SHOPFLOOR, BACKROOM, NO_VALUE. STOCK_COUNT_CHILD LOCATION_AREA RIB or/and RSB or/and RSL NUMBER(9) Yes area number within a location.
left_to_count number12 1 1 The total remaining items to be counted. STOCK_COUNT_CHILD ITEMS_LEFT_TO_COUNT RIB or/and RSB or/and RSL NUMBER(12) Yes The total remaining items to be counted.
StkCntChdLineItm * 1 5000 Collection of stock count line item description(s).

XML-Schema Name:StkCntChdLineItm 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 StkCntChdLineItm 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
line_item_id number12 1 1 The unique identifier of the line item. STOCK_COUNT_LINE_ITEM ID RIB or/and RSB or/and RSL NUMBER(12) Yes The unique identifier of the line item.
item_id varchar225 1 1 The sku number of the item being counted. STOCK_COUNT_LINE_ITEM ITEM_ID RIB or/and RSB or/and RSL VARCHAR2(25) Yes The sku number of the item being counted.
count_snapshot number12 0 1 The stock on hand quantity count snapshot. STOCK_COUNT_LINE_ITEM COUNT_SNAPSHOT RIB or/and RSB or/and RSL NUMBER(12,4) Yes The stock on hand quantity count snapshot.
recount_snapshot number12 0 1 The stock on hand quantity recount snapshot. STOCK_COUNT_LINE_ITEM RECOUNT_SNAPSHOT RIB or/and RSB or/and RSL NUMBER(12,4) Yes The stock on hand quantity recount snapshot.
stock_counted number12 0 1 The number of stock counted. STOCK_COUNT_LINE_ITEM COUNTED_QUANTITY RIB or/and RSB or/and RSL NUMBER(12,4) Yes The number of stock counted.
stock_recounted number12 0 1 The number of stock recounted. STOCK_COUNT_LINE_ITEM RECOUNTED_QUANTITY RIB or/and RSB or/and RSL NUMBER(12,4) Yes The number of stock recounted.
stock_counted_total number12 0 1 The number of stock counted across all stock count children for the item. STOCK_COUNT_LINE_ITEM COUNTED_TOTAL RIB or/and RSB or/and RSL NUMBER(12,4) Yes The number of stock counted across all stock count children for the item.
stock_recounted_total number12 0 1 The number of stock recounted across all stock count children for the item. STOCK_COUNT_LINE_ITEM RECOUNTED_TOTAL RIB or/and RSB or/and RSL NUMBER(12,4) Yes The number of stock recounted across all stock count children for the item.
stock_approved number12 0 1 The number of stock approved across all stock count children for the item. STOCK_COUNT_LINE_ITEM APPROVED_QUANTITY RIB or/and RSB or/and RSL NUMBER(12,4) Yes The number of stock approved across all stock count children for the item.
count_timestamp xs:dateTime 0 1 The date of the first count for the item. STOCK_COUNT_LINE_ITEM COUNT_DATE_TIME RIB or/and RSB or/and RSL DATE Yes The date of the first count for the item.
recount_timestamp xs:dateTime 0 1 The date of the first re-count for the item. STOCK_COUNT_LINE_ITEM RECOUNT_DATE_TIME RIB or/and RSB or/and RSL DATE Yes The date of the first re-count for the item.
approved_timestamp xs:dateTime 0 1 The date of a last manual entry of an approval quantity. STOCK_COUNT_LINE_ITEM APPROVED_DATE_TIME RIB or/and RSB or/and RSL DATE Yes The date of a last manual entry of an approval quantity.
StkCntUinNum * 0 1000 Collection of serial numbers associated with this line item
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated with the line item. NA NA NA NA NA NA
primary_location xs:boolean 1 1 True indicates this is the primary instance of the item on the stock count. STOCK_COUNT_LINE_ITEM PRIMARY_LOCATION RIB or/and RSB or/and RSL VARCHAR2(1) Yes True indicates this is the primary instance of the item on the stock count.
breakable_component xs:boolean 1 1 True indicates the item is a component of a breakable pack which requires adding pack counts to the line item before processing. STOCK_COUNT_LINE_ITEM BREAKABLE_COMPONENT RIB or/and RSB or/and RSL VARCHAR2(1) Yes True indicates the item is a component of a breakable pack which requires adding pack counts to the line item before processing.
multi_located xs:boolean 1 1 True indicates the item exists multiple times within a stock. The item must have a primary location. STOCK_COUNT_LINE_ITEM MULTI_LOCATED RIB or/and RSB or/and RSL VARCHAR2(1) Yes True indicates the item exists multiple times within a stock. The item must have a primary location.
discrepant xs:boolean 1 1 True indicates the stock counted for this item has met discrepant requirements and is considered a discrepant count. STOCK_COUNT_LINE_ITEM DISCREPANT RIB or/and RSB or/and RSL VARCHAR2(1) Yes True indicates the stock counted for this item has met discrepant requirements and is considered a discrepant count.

XML-Schema Name:StkCntUinNum 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 StkCntUinNum 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
uin_detail_id number12 1 1 Unique identifier of the uin detail. STOCK_COUNT_LINE_ITEM_UIN ITEM_UIN_ID RIB or/and RSB or/and RSL NUMBER(12) Yes Unique identifier of the uin detail.
serial_number varchar2128 1 1 The unique identification number. STOCK_COUNT_LINE_ITEM_UIN UIN RIB or/and RSB or/and RSL VARCHAR2(128) Yes The unique identification number.

XML-Schema Name:StrInvExtAttDesc 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 StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.