Retail Integration Mappings Report Release:16.0.21 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/VdrDelvCtnHdrCol/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:VdrDelvCtnHdrCol Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDelvCtnHdrCol 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
VdrDelvCtnHdrDesc:VdrDelvCtnHdrDesc * 0 unbounded Collection of vendor delivery headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. DSD_CARTON n/a RIB or/and RSB Fill column length. Yes number of delviery cartons

XML-Schema Name:VdrDelvCtnHdrDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VdrDelvCtnHdrDesc 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
delivery_id number12 1 1 Delivery identifier. DSD_CARTON DSD_ID NUMBER 12 Yes Delivery identifier.
store_id number10 1 1 Store identifier. DSD_CARTON STORE_ID NUMBER 10 Yes Store identifier
carton_id number12 1 1 Carton identifier. DSD_CARTON ID NUMBER 12 No Carton identifier.
carton_external_id varchar2128 0 1 Carton external identifier. DSD_CARTON EXTERNAL_ID VARCHAR2 128 No Carton external identifier.
status dsd_carton_status 1 1 Status of the carton. Valid values are NEW, IN_PROGRESS, SUBMITTED, RECEIVED, DAMAGED, MISSING, CANCELED, UNKNOWN. DSD_CARTON STATUS NUMBER 4 Yes carton status. 1 - New, 2 - In Progress, 3 - Submitted, 4 - Received, 5 - Damaged, 6 - Missing, 7 - Canceled
number_of_line_items number10 1 1 Total number of line items. n/a n/a RIB or/and RSB Fill column length. Yes Fill this description.
number_of_documents number10 1 1 total number of documents. DSD_CARTON n/a RIB or/and RSB Fill column length. Yes Fill this description.
customer_order_related order_related_type 1 1 Indicates how delivery related to customer order. Valid values are YES, MIX, NO. DSD_CARTON CUSTOMER_ORDER_RELATED NUMBER 4 Yes Indicate if carton contains customer order items. 1 - yes, 2 - mix; 3 - no
discrepant xs:boolean 1 1 Indicates if carton quantities are discrepant. DSD_CARTON n/a RIB or/and RSB Fill column length. Yes Fill this description.
uin_required xs:boolean 1 1 True if UINs are required for the item. DSD_CARTON UIN_REQUIRED VARCHAR2 1 Yes Indicates if UINs are required for the item.