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

XML-Schema Name:StrAdjHdrColDesc 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 StrAdjHdrColDesc 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
StrAdjHdrDesc:StrAdjHdrDesc * 0 unbounded Collection of store inventory adjustment headers. 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:StrAdjHdrDesc 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 StrAdjHdrDesc 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
adjustment_id number12 1 1 Unique identifier INV_ADJUST ID NUMER 12,0 Yes Adjustment identifier.
status str_adj_status 1 1 Current status Valid values are IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. INV_ADJUST STATUS NUMBER 2,0 Yes Indicates the current status of the adjustment. Possible values 1- In Progress, 2- Completed, 3- Canceled
create_date xs:dateTime 1 1 Date the adjustment was created INV_ADJUST CREATE_DATE DATE Fill column length. Yes The date the adjustment was created.
create_user_name varchar2128 1 1 User that created the adjustment INV_ADJUST CREATE_USER VARCHAR2 128 Yes The user that created the adjustment.
template_id number12 0 1 Identifier of a template used to create the adjustment INV_ADJUST INV_ADJUST_TEMPLATE_ID NUMBER 12,0 No Template used to create the adjustment.
item_count number10 1 1 Number of line items on the adjustment Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Number of line items on the adjustment