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

XML-Schema Name:VdrDelvHdrColDesc 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 VdrDelvHdrColDesc 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
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.21 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 RSL) 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, 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, 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 7 No The date the delivery is expected to arrive.
total_cartons number9 1 1 Total number of cartons on the delivery. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
line_item_received_total number9 1 1 Total number of line items received on the delivery. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
missing_cartons xs:boolean 1 1 Indicate if delivery has missing cartons. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
customer_order_related xs:boolean 1 1 Indicate if delivery related to customer order. DSD n/a RIB or/and RSB Fill column length. Yes Fill this description.