Retail Integration Mappings Report Release:16.0.21 (BDI Retail Merchandising System)
Application BDI Retail Merchandising System
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-RMS application.
BDI-RMS's Table Name BDI-RMS's Column Name Integration API(RIB or/and RSB or/and RSL) BDI-RMS's Column Length Is Column Required in BDI-RMS's API? BDI-RMS's API Description
store_id number10 1 1 Contains the unique ID of the store. Data will always be present in this field. STORE KEY_VALUE_1 VARCHAR2 20 Yes Contains the unique ID of the store. Data will always be present in this field.
addr number11 1 1 This column contains a unique number used to distinguish between different addresses. ADDR ADDR_KEY NUMBER 11 Yes This column contains a unique number used to distinguish between different addresses.
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. ADDR ADDR_TYPE VARCHAR2 2 Yes 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.
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. ADD_TYPE_TL TYPE_DESC VARCHAR2 40 Yes 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.
primary_addr_ind varchar21 1 1 Indicates whether the address is the primary address for the address type. Valid values are Y and N. ADDR PRIMARY_ADDR_IND VARCHAR2 1 Yes Indicates whether the address is the primary address for the address type. Valid values are Y and N.
add_1 varchar2240 1 1 Contains the first line of the address. This information is required. ADDR ADD_1 VARCHAR2 240 Yes Contains the first line of the address. This information is required.
add_2 varchar2240 0 1 This column contains the second line of the address. ADDR ADD_2 VARCHAR2 240 No This column contains the second line of the address.
add_3 varchar2240 0 1 This column contains the third line of the address. ADDR ADD_3 VARCHAR2 240 Yes This column contains the third line of the address.
city varchar2120 1 1 Contains the name of the city that is associated with the address. This information is required. ADDR CITY VARCHAR2 120 Yes Contains the name of the city that is associated with the address. This information is required.
county varchar2250 0 1 This column holds the county name for the location. ADDR COUNTY VARCHAR2 250 No This column holds the county name for the location.
state varchar23 0 1 This column contains the state abbreviation for the address. ADDR STATE VARCHAR2 3 No This column contains the state abbreviation for the address.
country varchar23 1 1 Contains the ISO 3166-1 country code associated with the address. This information is required. ADDR COUNTRY_ID VARCHAR2 3 Yes Contains the ISO 3166-1 country code associated with the address. This information is required.
post_code varchar230 0 1 This column contains the zip code for the address. ADDR POST VARCHAR2 30 No This column contains the zip code for the address.
jurisdiction_code varchar210 0 1 This column contains the name of the contact for the supplier at this address. ADDR JURISDICTION_CODE VARCHAR2 10 No Identifies the jurisdiction code for the country-state relationship.
contact_name varchar2120 0 1 This column contains the name of the contact for the supplier at this address. ADDR CONTACT_NAME VARCHAR2 120 No This column contains the name of the contact for the store at this address.
contact_phone varchar220 0 1 This column contains the phone number of the contact person at this address. ADDR CONTACT_PHONE VARCHAR2 20 No This column contains the phone number of the contact person at this address.
contact_fax varchar220 0 1 This column contains the fax number of the contact person at this address. ADDR CONTACT_FAX VARCHAR2 20 No This column contains the fax number of the contact person at this address.
contact_email varchar2100 0 1 This column contains the email address of the partner or suppliers representative contact. ADDR CONTACT_EMAIL VARCHAR2 100 No This column contains the email address of the partner or suppliers representative contact.