Retail Integration Mappings Report Release:16.0.21 (BDI Retail Extended Module)
Application BDI Retail Extended Module
Target Name Space http://www.oracle.com/retail/integration/bdi/bdi-interface-module
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:Store_Addr 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 Store_Addr in BDI-RXM application.
BDI-RXM's Table Name BDI-RXM's Column Name Integration API(RIB or/and RSB or/and RSL) BDI-RXM's Column Length Is Column Required in BDI-RXM's API? BDI-RXM's API Description
store_id number10 1 1 Contains the unique ID of the store. Data will always be present in this field. DCS_LOCATION_ADDR location_id BDI 40 Yes Unique id for the store, prepended with "ST_"
addr number11 1 1 This column contains a unique number used to distinguish between different addresses. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
addr_type varchar22 1 1 Contains the code used to identify the address type. Common examples include 01 (Business), 02 (Postal), 03 (Returns), 04 (Order), 05 (Invoice) and 06 (Remittance). Data will always be present in this field. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
addr_type_desc varchar220 1 1 Contains the code used to identify the address type. Common Common examples include Business, Postal, Returns, Order, Invoice and Remittance. Description data is only sent in the primary integration language of the system. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether the address is the primary address for the address type. Valid values are Y and N. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
add_1 varchar2240 1 1 Contains the first line of the address. This information is required. DCS_LOCATION_ADDR address_1 BDI 50 Yes Address first line
add_2 varchar2240 0 1 This column contains the second line of the address. DCS_LOCATION_ADDR address_2 BDI 50 Yes Address line 2
add_3 varchar2240 0 1 This column contains the third line of the address. DCS_LOCATION_ADDR address_3 BDI 50 Yes Address line 3
city varchar2120 1 1 Contains the name of the city that is associated with the address. This information is required. DCS_LOCATION_ADDR city BDI 40 Yes name of city associated with the address
county varchar2250 0 1 This column holds the county name for the location. DCS_LOCATION_ADDR county BDI 40 Yes county for this location
state varchar23 0 1 This column contains the state abbreviation for the address. DCS_LOCATION_ADDR state_addr BDI 40 Yes state for this location
country varchar23 1 1 Contains the ISO 3166-1 country code associated with the address. This information is required. DCS_LOCATION_ADDR country BDI 40 Yes country for this store
post_code varchar230 0 1 This column contains the zip code for the address. DCS_LOCATION_ADDR postal_code BDI 10 Yes postal code
jurisdiction_code varchar210 0 1 This column contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
contact_name varchar2120 0 1 This column contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
contact_phone varchar220 0 1 This column contains the phone number of the contact person at this address. Fill application table name. Fill table column name. BDI Fill column length. Yes Fill this description.
contact_fax varchar220 0 1 This column contains the fax number of the contact person at this address. DCS_LOCATION_ADDR fax_number BDI 40 Yes fax number
contact_email varchar2100 0 1 This column contains the email address of the partner or suppliers representative contact. DCS_LOCATION_ADDR email BDI 255 Yes contact email