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 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-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_0 1 1 Unique ID of the store. STORE STORE NUMBER 10 Yes Unique ID of the store.
store_type varchar26 0 1 This will indicate whether a particular store is a franchise or company store. STORE STORE_TYPE VARCHAR2 6 Yes This will indicate whether a particular store is a franchise or company store.
store_name varchar2150 0 1 Contains the name of the store which, along with the store number, identifies the store. STORE STORE_NAME VARCHAR2 150 Yes Contains the name of the store which, along with the store number, identifies the store.
store_name_10 varchar210 0 1 Contains a ten character abbreviation of the store name. STORE STORE_NAME10 VARCHAR2 10 Yes Contains a ten character abbreviation of the store name.
store_name_abbr varchar23 0 1 Contains a three character abbreviation of the store name. STORE STORE_NAME_ABBR VARCHAR2 3 Yes Contains a three character abbreviation of the store name.
store_name_sec varchar2150 0 1 Secondary name of the store. STORE STORE_NAME_SECONDARY VARCHAR2 1 No Secondary name of the store.
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. STORE STORE_CLASS VARCHAR2 1 Yes Contains the code letter indicating the class of which the store is a member. Valid values are A through E.
store_class_desc varchar2250 0 1 Contains the name of the store class. CODE_DETAIL CODE_DESC VARCHAR2 250 Yes Contains the name of the store class. Code Type CSTR.
manager varchar2120 0 1 Contains the name of the store manager. STORE STORE_MGR_NAME VARCHAR2 120 Yes Contains the name of the store manager.
open_date xs:dateTime 0 1 Contains the date on which the store opened. STORE STORE_OPEN_DATE DATE Yes Contains the date on which the store opened.
close_date xs:dateTime 0 1 Contains the date on which the store closed. STORE STORE_CLOSE_DATE DATE No Contains the date on which the store closed.
acquire_date xs:dateTime 0 1 Contains the date on which the store was acquired. STORE ACQUIRED_DATE DATE No Contains the date on which the store was acquired.
remodel_date xs:dateTime 0 1 Contains the date on which the store was last remodeled. STORE REMODEL_DATE DATE No Contains the date on which the store was last remodeled.
fax_number varchar220 0 1 Contains the fax number for the store. STORE FAX_NUMBER VARCHAR2 20 No Contains the fax number for the store.
phone_number varchar220 0 1 Contains the phone number for the store. STORE PHONE_NUMBER VARCHAR2 20 No Contains the phone number for the store.
email varchar2100 0 1 Holds the email address for the location. STORE EMAIL VARCHAR2 100 No Holds the email address for the location.
total_sq_feet number8_0 0 1 Contains the total square footage of the store. STORE TOTAL_SQUARE_FEET NUMBER 8 No Contains the total square footage of the store.
selling_sq_feet number8_0 0 1 Contains the total square footage of the stores selling area. STORE SELLING_SQUARE_FT NUMBER 8 No Contains the total square footage of the stores selling area.
linear_distance number8_0 0 1 Holds the total merchandisable space of the location. STORE LINEAR_DISTANCE NUMBER 8 No Holds the total merchandisable space of the location.
vat_region number4_0 0 1 Contains the number of the Value Added Tax region in which this store is contained. STORE VAT_REGION NUMBER 4 No Contains the number of the Value Added Tax region in which this store is contained.
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. STORE VAT_INCLUDE_IND VARCHAR2 1 No Indicates whether or not Value Added Tax will be included in the retail prices for the store. Valid values are Y or N.
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. STORE STOCKHOLDING_IND VARCHAR2 1 Yes This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Y.
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. STORE CHANNEL_ID NUMBER 4, 0 No In a multichannel environment this will contain the channel with which the store is associated. Valid values can be found on the channels table.
channel_name varchar2120 0 1 Contains the name of the channel. Fill application table name. Fill table column name. BDI Fill column length. Yes 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. STORE STORE_FORMAT NUMBER 4 No Contains the number indicating the format of the store. Valid values are found on the store format table.
store_format_name varchar260 0 1 Contains the name of the store format. STORE_FORMAT FORMAT_NAME VARCHAR2 60 Yes Contains the number indicating the format of the store. Valid values are found on the store format table.
mall_name varchar2120 0 1 Contains the name of the mall in which the store is located. STORE MALL_NAME VARCHAR2 120 No Contains the name of the mall in which the store is located.
district number10_0 0 1 Contains the number of the district in which the store is a member. STORE DISTRICT NUMBER 10, 0 Yes Contains the number of the district in which the store is a member.
transfer_zone number4_0 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. STORE TRANSFER_ZONE NUMBER 4 No Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table.
transfer_zone_desc varchar2120 0 1 Contains the name of the Transfer Zone. TSFZONE DESCRIPTION VARCHAR2 120 No Contains the name of the Transfer Zone.
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. STORE DEFAULT_WH NUMBER 10, 0 No 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.
stop_order_days number3_0 0 1 Contains the number of days before a store closing that the store will stop accepting orders. STORE STOP_ORDER_DAYS NUMBER 3 No Contains the number of days before a store closing that the store will stop accepting orders.
start_order_days number3_0 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. STORE START_ORDER_DAYS NUMBER 3 Yes Contains the number of days before the store_open_date that the store will begin accepting orders.
currency_code varchar23 0 1 This field contains the currency code under which the store operates. STORE CURRENCY_CODE VARCHAR2 3 Yes This field contains the currency code under which the store operates.
store_lang_iso_code varchar26 0 1 This column identifies the language to be used for the given store. LANG ISO_CODE VARCHAR2 6 Yes This column identifies the language to be used for the given store.
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). STORE TRAN_NO_GENERATED VARCHAR2 6 Yes 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).
duns_number varchar29 0 1 This field holds the Dun and Bradstreet number to identify the store. STORE DUNS_NUMBER VARCHAR2 9 No This field holds the Dun and Bradstreet number to identify the store.
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. STORE SISTER_STORE NUMBER 10 No This field will hold a store number which will be used to relate the current store to the historical data of an existing store.
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. STORE TSF_ENTITY_ID NUMBER 10 No 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.
org_unit_id number15_0 0 1 Column will contain the organizational unit ID value. STORE ORG_UNIT_ID NUMBER 15 No Column will contain the organizational unit ID value.
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. STORE AUTO_RCV VARCHAR2 1 Yes 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.
remerch_ind varchar21 0 1 Identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS. STORE REMERCH_IND VARCHAR2 1 Yes Identifies stores that are undergoing a significant remerchandising effort. Used only when AIP is integrated with RMS.
wf_customer number10_0 0 1 Numeric Id of the customer. STORE WF_CUSTOMER_ID NUMBER 10 Yes Numeric Id of the customer.
timezone varchar264 0 1 Indicates the time zone of the store. For example, America/New_York. STORE TIMEZONE_NAME VARCHAR2 64 Yes Indicates the time zone of the store. For example, America/New_York.
customer_order_loc_ind varchar21 0 1 This Column determines whether the location is customer order location or not. STORE CUSTOMER_ORDER_LOC_IND VARCHAR2 1 No This Column determines whether the location is customer order location or not.