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

XML-Schema Name:StrVnsCtnHdrCol 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 StrVnsCtnHdrCol 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
StrVnsCtnHdrDesc:StrVnsCtnHdrDesc * 0 unbounded Collection of vendor shipment container 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:StrVnsCtnHdrDesc 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 StrVnsCtnHdrDesc 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 Shipment unique identifier RTV_SHIP_CARTON RTV_SHIP_ID NUMBER 15,0 No The unique ID of the RTV shipment the carton is associated to
container_id number15 1 1 Container unique identifier. RTV_SHIP_CARTON ID NUMBER 15,0 Yes The unique identifier for the RTV shipment carton/container
store_id number10 1 1 Store unique identifier RTV_SHIP_CARTON STORE_ID NUMBER 10,0 Yes The store id from which the RTV Shipment is created
container_label varchar2128 0 1 The identifier used to print a barcode or label for the container. RTV_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No The external identifier
status rtv_ship_carton_status 1 1 Current status of the container Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. RTV_SHIP_CARTON STATUS NUMBER 2,0 Yes The status of the RTV Shipment carton.Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled
number_of_line_items number10 1 1 Number of line items on the vendor shipment container. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.