Retail Integration Mappings Report Release:16.0.030 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:StoreDesc 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 StoreDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
store number10 1 1 Contains the number to uniquely identify the store. store store number 10,0 Yes Contains the number to uniquely identify the store.
store_type varchar21 1 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 1 1 Contains the name of the store. store store_name varchar2 150 Yes Contains the name of the store.
store_name10 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_name3 varchar23 0 1 Contains a three character abbreviation of the store name. store store_name3 varchar2 3 Yes Contains a three character abbreviation of the store name.
store_add1 varchar2240 0 1 Not used by RMS. * * null null No Not used by RMS.
store_add2 varchar2240 0 1 Not used by RMS. * * null null No Not used by RMS.
store_city varchar2120 0 1 Not used by RMS. * * null null No Not used by RMS.
county varchar2250 0 1 Not used by RMS. * * null null No Not used by RMS.
state varchar23 0 1 Not used by RMS. * * null null No Not used by RMS.
country_id varchar23 0 1 Not used by RMS. * * null null No Not used by RMS.
store_pcode varchar230 0 1 Not used by RMS. * * null null No Not used by RMS.
store_class 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 to which the store belongs. Valid values are A, B, C, D, and E.
store_mgr_name varchar2120 0 1 Contains the name of the store manager. store store_mgr_name varchar2 120 Yes Contains the name of the store manager.
store_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.
store_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.
acquired_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 Contains the email address for the location. store email varchar2 100 No Contains the email address for the location.
total_square_ft number8 0 1 Contains the total square footage of the store. store total_square_ft number 8,0 No Contains the total square footage of the store.
selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. store selling_square_ft number 8,0 No Contains the total square footage of the store's selling area.
linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. store linear_distance number 8,0 No Contains the total space of the location that can be used for merchandise.
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be store stockholding_ind varchar2 1 Yes This column indicates whether the store can hold stock.
channel_id number4 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 field contains the channel with which the store is associated. Valid values are in the channels table.
store_format number4 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,0 No Contains the number indicating the format of the store. Valid values are in 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 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.
district_name varchar2120 0 1 Contains the name of the district. district district_name varchar2 120 Yes Contains the name of the district.
promo_zone number4 0 1 Not used by RMS. * * null null No Not used by RMS.
promo_desc varchar220 0 1 Not used by RMS. * * null null No Not used by RMS.
transfer_zone number4 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,0 No Contains the transfer zone in which the store is located. Valid values are located in the tsfzone table.
description varchar21000 0 1 Contains the name of the transfer zone. tsfzone description varchar2 120 Yes Contains the name of the transfer zone.
default_wh varchar210 0 1 Contains the number of the warehouse that may be used as the default for creating cross-dock 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 varchar2 10,0 No Contains the number of the warehouse that may be used as the default for creating cross-dock masks. This determines the stores associated with (or sourced from) a warehouse. Will contain only virtual warehouses in a multi-channel environment.
stop_order_days number3 0 1 Contains the number of days before a store closing that the store will stop accepting orders. This column will be used when the store_close_date is defined. store stop_order_days number 3,0 No Contains the number of days before a store closing that the store will stop accepting orders. This column is used when the store_close_date is defined.
start_order_days number3 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,0 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.
lang number6 0 1 This column identifies the language to be used for the store. store lang number 6,0 Yes This column identifies the language to be used for the store.
integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. store integrated_pos_ind varchar2 1 Yes Indicates whether the POS system at the store is integrated.
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency store orig_currency_code varchar2 3 Yes The original currency of a store after it has adopted the Euro as its main operating currency.
duns_number varchar29 0 1 This type can hold a number of digits count umber. store duns_number varchar2 9 No This field contains the Dun and Bradstreet number to identify the store.
duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. store duns_loc varchar2 4 No This field contains the Dun and Bradstreet number to identify the location.
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
pricing_loc number10 0 1 If this field is null, the new store will not be added to RPM_ZONE_LOCATION table. wh_add pricing_location number 10,0 No The store from which pricing infomation was copied for this store.
pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. wh_add pricing_loc_curr varchar2 3 No This is the currency code of the pricing_loc store.
org_unit_id number15 0 1 Column will contain the organizational unit ID value. store org_unit_id number 15,0 No Column will contain the organizational unit ID value.
timezone_name 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'.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
store_name_secondary varchar2150 0 1 Contains the secondary name of the store. store store_name_secondary varchar2 150 No Secondary name of the store.
store_class_description varchar2150 0 1 Contains the description of the class of which the store is a member. * * * * Derived
vat_region number4 0 1 Contains the number of the Value Added Tax region in which this store is contained. store vat_region number 4,0 No Contains the number of the Value Added Tax region in which this store is contained.
vat_include_ind varchar21 0 1 Indicates whether or not Value Added Tax will be included in the retail prices in the POS files coming from 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.
channel_name varchar2120 0 1 Indicates the channel description with which the store is associated. channels channel_name varchar2 120 Yes Contains the name of the channel.
store_format_name varchar2120 0 1 Contains the name or description of the store format.
sister_store number10 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,0 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 1 This field will hold id of the transfer entity with which a store is associated. store tsf_entity_id number 10,0 No Foregin key to the TSF_ENTITY table
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). 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 This field 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_id number10 0 1 This field identifies numeric id of the customer. store wf_customer_id number 10,0 No Numeric Id of the customer.
customer_order_loc_ind varchar21 0 1 This Column determines whether the location is customer order location or not.If the indicator is Y then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used.It is enabled only for the company stores. store customer_order_loc_ind varchar2 1 No This Column determines whether the location is customer order location or not.If the indicator is Y then the location can be used by OMS for sourcing/ fulfillment or both else it cannot be used.It is enabled only for the company stores .
gift_wrapping_ind varchar21 0 1 This field indicates weathere a gift wrapping needs to be done or not. store gift_wrapping_ind varchar2 1 Yes This column will indicate if the location will support gift wrapping.
customer_order_ship_ind varchar21 0 1 This field indicates wheather the customer order has been been shipped from Warehouse or not. store customer_order_ship_ind varchar2 1 Yes This column will indicate if the location will support shipping to a customer for customer orders.
StoreHoursDesc:StoreHoursDesc * 0 unbounded References a collection of store hours details. NA NA NA NA NA NA

XML-Schema Name:AddrDesc 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 AddrDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
city_id varchar210 0 1 Indicates the City Id or Code. N/A N/A varchar2 10 No Indicates the City Id or Code.
state_name varchar2120 0 1 Indicates the State name. state description varchar2 120 Yes Contains the full name of the state.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States country country_desc varchar2 120 Yes Contains the name of the country.
addr varchar232 1 1 This field holds the unique address ID from the source system. For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID. addr addr_key number 11,0 Yes This column contains a unique number used to distinguish between different addresses.For addresses that are interfaced into RMS, it will hold the external system's address ID. For addresses published out of RMS, it will hold RMS's address ID.
addr_type varchar22 1 1 Indicates the type for the address. Valid values (e.g. 01-business, 02-postal) are in the add_type table. addr addr_type varchar2 2 Yes This column indicates the type for the address.
primary_addr_type_ind varchar21 0 1 Description is not available. * * varchar2 1 No Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type addr primary_addr_ind varchar2 1 Yes This column indicates whether the address is the primary address for the address type.
add_1 varchar2240 1 1 Contains the first line of the address addr add_1 varchar2 240 Yes This column contains the first line of the address.
add_2 varchar2240 0 1 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 Contains the thirdline of the address. addr add_3 varchar2 240 No 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. addr city varchar2 120 Yes This column contains the name of the city that is associated with the address.
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state varchar2 3 No This column contains the state abbreviation for the address.
country_id varchar23 1 1 Contains the country where the address exists. addr country_id varchar2 3 Yes This column contains the country where the address exists.
post varchar230 0 1 Contains the zip code for the address. addr post varchar2 30 No This column contains the zip code for the address.
contact_name varchar2120 0 1 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 supplier at this address.
contact_phone varchar220 0 1 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_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex varchar2 20 No This column contains the telex number of the partner or suppliers representative contact.contact.
contact_fax varchar220 0 1 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 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.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. addr oracle_vendor_site_id number 15,0 No This column will only be used for the Oracle Financial Interfaces. It holds the value of the Oracle vendor site ID for a supplier address. This Oracle vendor site ID is the unique identifier of the address on the Oracle side, it must be stored on the RMS addr table to allow updates from Oracle. This site ID can be found on the Oracle po_vendor_sites table.
county varchar2250 0 1 Contains the county name for the location. addr county varchar2 250 No This column holds the county name for the location.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. addr jurisdiction_code varchar2 10 No Identifies the jurisdiction code for the country-state relationship.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo 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 CustFlexAttriVo in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo 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 CustFlexAttriVo in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:StoreHoursDesc 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 StoreHoursDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
store_id number10 1 1 Unique ID of the store. store_hours store number 10,0 Yes This coulmn contains the number which uniquely identifies the store.
day_no number1 1 1 This field indicates the day of the week for which store timing is being stored. store_hours day_no number 1,0 Yes This column contains the numeric value which indicates the day of the week on which the store will be open/closed. Valid values are 1-Sunday,2-Monday,3-Tuesday,4-Wednesday,5-Thursday,6-Friday,7-Saturday.
store_open_time varchar28 0 1 Contains the open time for the store. store_hours open_time varchar2 8 No This column contains the open time for the store for each day of the week.
store_close_time varchar28 0 1 Contains the close time for the store. store_hours close_time varchar2 8 No This column contains the open time for the store for each day of the week.