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

XML-Schema Name:StrVnsHdrColDesc 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 StrVnsHdrColDesc 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
StrVnsHdrDesc:StrVnsHdrDesc * 0 unbounded Collection of vendor shipment 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:StrVnsHdrDesc 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 StrVnsHdrDesc 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
shipment_id number15 1 1 Unique identifier RTV_SHIP ID NUMBER 15,0 Yes The unique identifier for the RTV shipment
store_id number10 1 1 Store identifier RTV_SHIP STORE_ID NUMBER 10,0 Yes The store id the RTV Shipment is created from
supplier_id number10 1 1 Supplier identifier. RTV_SHIP SUPPLIER_ID NUMBER 10,0 Yes The supplier to which the RTV Shipment is created
authorization_code varchar212 0 1 Authorization code RTV_SHIP AUTHORIZATION_CODE VARCHAR2 12 No The vendor authorization number
not_after_date xs:dateTime 0 1 Date after which the vendor shipment in no longer valid RTV_SHIP NOT_AFTER_DATE DATE Fill column length. No The not after date for the RTV Shipment
status rtv_ship_status 1 1 Current status Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. RTV_SHIP STATUS NUMBER 2,0 Yes The status of the RTV Shipment. Valid values: 1- New, 2- In progress, 3- Submitted, 4- Shipped, 5- Canceled
number_of_line_items number10 1 1 Number of line items on the vendor shipment. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.