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

XML-Schema Name:StrAdjRsnColDesc 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 StrAdjRsnColDesc 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
StrAdjRsnDesc:StrAdjRsnDesc * 0 unbounded Collection of store inventory adjustment reasons. 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:StrAdjRsnDesc 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 StrAdjRsnDesc 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
reason_id number12 1 1 Unique identifier INV_ADJUST_REASON ID NUMBER 12,0 Yes unique identifier of inventory adjustment reason. The first 100 IDs are reserved for reasons required by the system.
reason_code number4 1 1 External reason code. INV_ADJUST_REASON CODE NUMBER 4,0 Yes contains a code to uniquely identify the reason for an inventory adjustment.
description varchar2256 1 1 Description of the reason INV_ADJUST_REASON DESCRIPTION VARCHAR2 255 No contains a description of the inventory adjustment reason code.
disposition_desc varchar2256 1 1 Description of the inventory disposition associated to the reason. INV_ADJUST_REASON DISPOSITION NUMBER 2,0 Yes the unique identifier of the disposition that is attached to the reason code. this will determine the from and to inventory dispositions as defined on the rk_disposition table.
to_nonsellable_qty_type_id number12 0 1 Identifier of the non-sellable quantity type (or sub-bucket) the non-sellable inventory will move to. INV_ADJUST_REASON TO_NONSELLABLE_TYPE_ID NUMBER 12,0 No To Unavailable Sub-Bucket
from_nonsellable_qty_type_id number12 0 1 Identifier of the non-sellable quantity type (or sub-bucket) the non-sellable inventory will move from. INV_ADJUST_REASON FROM_NONSELLABLE_TYPE_ID NUMBER 12,0 No From Unavailable Sub-Bucket