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 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 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_0 1 1 Unique ID of the store. DCS_LOCATION location_id BDI 40 Yes location_id will be prepended with "ST_" store id is also mapped to DCS_LOCATION ext_loc_id
store_type varchar26 0 1 This will indicate whether a particular store is a franchise or company store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_name varchar2150 0 1 Contains the name of the store which, along with the store number, identifies the store. DCS_LOCATION name BDI 254 Yes store name
store_name_10 varchar210 0 1 Contains a ten character abbreviation of the store name. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_name_abbr varchar23 0 1 Contains a three character abbreviation of the store name. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_name_sec varchar2150 0 1 Secondary name of the store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_class_id varchar21 0 1 Contains the code letter indicating the class of which the store is a member. Valid values are A through E. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_class_desc varchar2250 0 1 Contains the name of the store class. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
manager varchar2120 0 1 Contains the name of the store manager. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
open_date xs:dateTime 0 1 Contains the date on which the store opened. DCS_LOCATION start_date BDI date Yes Date on which the store openeed
close_date xs:dateTime 0 1 Contains the date on which the store closed. DCS_LOCATION end_date BDI date Yes Contains the date on which the store closed
acquire_date xs:dateTime 0 1 Contains the date on which the store was acquired. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
fax_number varchar220 0 1 Contains the fax number for the store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
phone_number varchar220 0 1 Contains the phone number for the store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
email varchar2100 0 1 Holds the email address for the location. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
total_sq_feet number8_0 0 1 Contains the total square footage of the store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
selling_sq_feet number8_0 0 1 Contains the total square footage of the stores selling area. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
linear_distance number8_0 0 1 Holds the total merchandisable space of the location. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
vat_region number4_0 0 1 Contains the number of the Value Added Tax region in which this store is contained. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
vat_incl_ind varchar21 0 1 Indicates whether or not Value Added Tax will be included in the retail prices for the store. Valid values are Y or N. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
stock_holding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Y. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
channel_id number4_0 0 1 In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
channel_name varchar2120 0 1 Contains the name of the channel. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_format_id number4_0 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_format_name varchar260 0 1 Contains the name of the store format. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
district number10_0 0 1 Contains the number of the district in which the store is a member. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
transfer_zone number4_0 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
transfer_zone_desc varchar2120 0 1 Contains the name of the Transfer Zone. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
default_wh number10_0 0 1 Contains the number of the warehouse that may be used as the default for creating crossdock masks. This determines which stores are associated with or sourced from a warehouse. Will hold only virtual warehouses in a multi-channel environment. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
stop_order_days number3_0 0 1 Contains the number of days before a store closing that the store will stop accepting orders. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
start_order_days number3_0 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
currency_code varchar23 0 1 This field contains the currency code under which the store operates. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
store_lang_iso_code varchar26 0 1 This column identifies the language to be used for the given store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
tran_no_generate varchar26 0 1 Contains the level at which unique POS transaction numbers are generated. If the store has one sequence number that is used for all registers, then the value in this columnwill be S (Store) otherwise it will be R (Register). Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
duns_number varchar29 0 1 This field holds the Dun and Bradstreet number to identify the store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
sister_store number10_0 0 1 This field will hold a store number which will be used to relate the current store to the historical data of an existing store. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
tsf_entity_id number10_0 0 1 This is the Id of the transfer entity this store belongs to. A transfer entity is a group of locations that are a part of single legal entity and share same accounting set of books. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
org_unit_id number15_0 0 1 Column will contain the organizational unit ID value. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
auto_rcv varchar21 0 1 This column will indicate whether the client is allowing automatic receipt for the store. Valid Values are Y (Yes), N (No), D (System Default). Default value should be D. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
remerch_ind varchar21 0 1 Identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
wf_customer number10_0 0 1 Numeric Id of the customer. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
timezone varchar264 0 1 Indicates the time zone of the store. For example, America/New_York. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.
customer_order_loc_ind varchar21 0 1 This Column determines whether the location is customer order location or not. Fill application table name. Fill table column name. BDI Fill column length. No Fill this description.