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

XML-Schema Name:VdrDelvHdrColDesc 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 VdrDelvHdrColDesc 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
VdrDelvHdrDesc:VdrDelvHdrDesc * 0 unbounded Collection of vendor delivery headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. DSD n/a RIB or/and RSB Fill column length. Yes number of vendor deliveries

XML-Schema Name:VdrDelvHdrDesc 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 VdrDelvHdrDesc 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 ID NUMBER 12 Yes Delivery identifier.
store_id number10 1 1 Store identifier. DSD STORE_ID NUMBER 10 Yes Store identifier.
supplier_id number10 1 1 Supplier identifier. DSD SUPPLIER_ID NUMBER 10 Yes Supplier identifier.
supplier_name varchar2240 0 1 Supplier name. SUPPLIER NAME VARCHAR2 240 Yes Supplier name.
asn varchar2128 0 1 External identifier of the ASN for the delivery. DSD ASN_ID VARCHAR2 128 No External identifier of the ASN for the delivery.
origin_type origin_type 1 1 Originating type of delivery. Valid values are ASN, DEXNEX, MANUAL, PO, NO_VALUE, UNKNOWN. DSD ORIGIN_TYPE NUMBER 2 Yes Originating type of delivery.0 -ASN 1 - PO, 2 - DEX-NEX, 3 - on the fly
status dsd_status 1 1 Status of the delivery. Valid values are NEW, IN_PROGRESS, RECEIVED, CANCELED, REJECTED, NO_VALUE, UNKNOWN. DSD STATUS NUMBER 4 Yes status of the delivery
expected_arrival_date xs:dateTime 0 1 The date the delivery is expected to arrive. DSD EXPECTED_DATE DATE No The date the delivery is expected to arrive.
total_cartons number9 1 1 Total number of cartons on the delivery. No Derived from number of carton on DSD_CARTON associated to the delivery identifier.
line_item_received_total number9 1 1 Total number of line items received on the delivery. Yes Count on line item received on delivery.
missing_cartons xs:boolean 1 1 Indicate if delivery has missing cartons. Yes Calculated on number of carton associated to delivery which are currently in missing status.
customer_order_related xs:boolean 1 1 Indicate if delivery related to customer order. No Boolean value calculated on base of customer order id on dsd_line_item and dsd table for the delivery.