Retail Integration Mappings Report Release:19.0.000 (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:19.0.000 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 BDI) 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_CHILD STOCK_COUNT_ID 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 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 DESCRIPTION VARCHAR2 (1000) No 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, NO_VALUE, UNKNOWN. STOCK_COUNT STATUS 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. No Derived from status and phase of stock count child
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, UNKNOWN, NO_VALUE. STOCK_COUNT_CHILD LOCATION_AREA NUMBER (9) No 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 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:19.0.000 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 BDI) 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 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 VARCHAR2 (25) Yes The sku number of the item being counted.
count_snapshot number12_4 0 1 The stock on hand quantity count snapshot. STOCK_COUNT_LINE_ITEM COUNT_SNAPSHOT NUMBER (12,4) No The stock on hand quantity count snapshot.
recount_snapshot number12_4 0 1 The stock on hand quantity recount snapshot. STOCK_COUNT_LINE_ITEM RECOUNT_SNAPSHOT NUMBER (12,4) No The stock on hand quantity recount snapshot.
stock_counted number12_4 0 1 The number of stock counted. STOCK_COUNT_LINE_ITEM COUNTED_QUANTITY NUMBER (12,4) No The number of stock counted.
stock_recounted number12_4 0 1 The number of stock recounted. STOCK_COUNT_LINE_ITEM RECOUNTED_QUANTITY NUMBER (12,4) No The number of stock recounted.
stock_counted_total number12_4 0 1 The number of stock counted across all stock count children for the item. STOCK_COUNT_LINE_ITEM COUNTED_TOTAL NUMBER (12,4) No The number of stock counted across all stock count children for the item.
stock_recounted_total number12_4 0 1 The number of stock recounted across all stock count children for the item. STOCK_COUNT_LINE_ITEM RECOUNTED_TOTAL NUMBER (12,4) No The number of stock recounted across all stock count children for the item.
stock_approved number12_4 0 1 The number of stock approved across all stock count children for the item. STOCK_COUNT_LINE_ITEM APPROVED_QUANTITY NUMBER (12,4) No 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 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 DATE No 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 DATE No 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 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 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 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 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:19.0.000 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 BDI) 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 NUMBER (12) Yes Unique identifier of the uin detail.
serial_number varchar2128 1 1 The unique identification number. STOCK_COUNT_LINE_ITEM_UIN UIN VARCHAR2 (128) Yes The unique identification number.

XML-Schema Name:StrInvExtAttDesc Version:19.0.000 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 BDI) 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. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT QUANTITY NUMBER 12 Yes Extended attribute quantity.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.