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

XML-Schema Name:VdrDelvModVo 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 VdrDelvModVo 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.
invoice_number varchar2128 0 1 Invoice number for the delivery. DSD INVOICE_ID VARCHAR2 128 No Invoice number for the delivery
invoice_date xs:dateTime 0 1 Invoice date for the delivery. DSD INVOICE_DATE DATE No Invoice date for the delivery.
invoice_cost number12_4 0 1 Invoice cost for the delivery. DSD INVOICE_COST_VALUE NUMBER 12,4 No Invoice cost for the delivery.
carrier_name varchar2128 0 1 Name of the carrier DSD CARRIER_ENTITY VARCHAR2 128 No Name of the carrier
carrier_type dsd_carrier_type 1 1 Carrier type of the delivery. Valid values are CORPORATE, THIRD_PARTY, NO_VALUE, UNKNOWN. DSD CARRIER_TYPE NUMBER 2 No Indicate carrier type, 0 - Corporate, 1 - Third Party
carrier_code varchar24 0 1 Carrier code of carrier responsible for vendor delivery. DSD CARRIER_CODE VARCHAR2 4 No Carrier code of carrier responsible for vendor delivery
license_plate varchar2128 0 1 License plate of the delivery DSD LICENSE_PLATE VARCHAR2 128 No License plate of the delivery
source_address varchar21000 0 1 The address of source sending delivery. DSD SOURCE_ADDRESS VARCHAR2 1000 No The address of source sending delivery.
freight_id varchar2128 0 1 Freight identifier. DSD FREIGHT_ID VARCHAR2 128 No The Freight identifier.
bol_external_id varchar2128 0 1 Bill of Lading external identifier. DSD BOL_EXTERNAL_ID VARCHAR2 128 No Bill of Lading external identifier.
currency_code varchar23 0 1 Currency code of the unit cost for the line item. DSD CURRENCY_CODE VARCHAR2 3 No Currency code
country_code varchar23 0 1 The country code. DSD COUNTRY_CODE VARCHAR2 3 No The Country code
VdrDelvModNote * 0 1000 Notes associated to the vendor delivery.

XML-Schema Name:VdrDelvModNote 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 VdrDelvModNote 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
note varchar22000 1 1 Note associated to the vendor delivery. NOTES TEXT VARCHAR2 3000 No Note associated to the vendor delivery.