Retail Integration Mappings Report Release:16.0.030 (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.030 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 BDI) 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.030 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 BDI) 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, NO_VALUE, UNKNOWN. DSD_CARTON STATUS NUMBER 4 Yes "carton status. valid values- 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. No Derived from number of line items associated to carton.
number_of_documents number10 1 1 total number of documents. No Derived from number of purchase order associated to the line item on the container.
customer_order_related order_related_type 1 1 Indicates how delivery related to customer order. Valid values are YES, MIX, NO, NO_VALUE, UNKNOWN. 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. No Derived from DSD_LINE_ITEM if the expected doesn't match received + damaged for the line item associated to the container.
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.