Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
Target Name Space http://www.oracle.com/retail/integration/base/bo/XStoreDesc/v1
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:XStoreDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
store number10 1 1 The unique identifier of the store. RMS.store store varchar2 10 Yes The unique identifier of the store.
store_name varchar2150 1 1 The name of the store. RMS.store store_name varchar2 150 Yes The name of the store.
store_type varchar21 0 1 The one character abbreviation of the store type. RMS.store store_type varchar2 6 No The one character abbreviation of the store type
store_name10 varchar210 0 1 The ten character abbreviation of the store name. RMS.store store_name10 varchar2 10 No The ten character abbreviation of the store name.
store_name3 varchar23 0 1 The three character abbreviation of the store name. RMS.store store_name3 varchar2 3 No The three character abbreviation of the store name.
store_class varchar21 1 1 The code of the class of which the store is a member. RMS.store store_class varchar2 1 Yes The code of the class of which the store is a member.
store_mgr_name varchar2120 1 1 The name of the store manager. RMS.store store_mgr_name varchar2 120 Yes The name of the store manager.
store_open_date xs:dateTime 1 1 The date on which the store opened. RMS.store store_open_date date null Yes The date on which the store opened.
store_close_date xs:dateTime 0 1 The date on which the store closed. RMS.store store_close_date date null No The date on which the store closed.
acquired_date xs:dateTime 0 1 The date on which the store was acquired. RMS.store acquired_date date null No The date on which the store was acquired.
remodel_date xs:dateTime 0 1 The date on which the store was remodeled. RMS.store remodel_date date null No The date on which the store was remodeled.
fax_number varchar220 0 1 This type can hold a number of digits count mber. RMS.store fax_number varchar2 20 No The fax number of the store.
phone_number varchar220 0 1 This type can hold a number of digits count number. RMS.store phone_number varchar2 20 No The store's phone number.
email varchar2100 0 1 The email address of the store. RMS.store email varchar2 100 No The email address of the store.
total_square_ft number8 0 1 The total square footage of the store. RMS.store total_square_ft number 8 No The total square footage of the store.
selling_square_ft number8 0 1 The total square footage of the store's selling area. RMS.store selling_square_ft number 8 No The total square footage of the store's selling area.
linear_distance number8 0 1 The total merchandise space of the store. RMS.store linear_distance number 8 No The total merchandise space of the store.
stockholding_ind varchar21 1 1 Indicates if the store can hold stock. This field cannot be modified. RMS.store stockholding_ind varchar2 1 Yes Indicates if the store can hold stock. This field cannot be modified.
channel_id number4 0 1 The identifier of the channel. This value must be predefined on the CHANNELS table. In a multichannel environment this field is required. RMS.store channel_id number 4 No The identifier of the channel. This value must be predefined in the CHANNELS table. In a multichannel environment this field is required.
store_format number4 0 1 The code of the store format of the store. This value must be predefined on the STORE_FORMAT table. RMS.store store_format number 4 No Indicates the store's format. This value must be predefined in the STORE_FORMAT table.
mall_name varchar2120 0 1 The name of the mall in which the store is located. RMS.store mall_name varchar2 120 No The name of the mall in which the store is located.
district number10 1 1 The number of the district of which the store is a member. This value must be predefined on the DISTRICT table. RMS.store district number 10 Yes The number of the district towhich the store belongs. This value must be predefined in the DISTRICT table.
promo_zone number4 0 1 Field not used. RMS.* * null null No Not used by RMS.
transfer_zone number4 0 1 The transfer zone in which the store is located. This value must be predefined on the TSFZONE table. RMS.store transfer_zone number 4 No The transfer zone in which the store is located. This value must be predefined in the TSFZONE table.
default_wh number10 0 1 The default warehouse for the store. This value must be predefined on the WH table. RMS.store default_wh number 10 No The default warehouse for the store. This value must be predefined in the WH table.
stop_order_days number3 0 1 The number of days before the store close date that the store will stop accepting orders. RMS.store stop_order_days number 3 No The number of days before the store close date that the store will stop accepting orders.
start_order_days number3 1 1 The number of days before the store open date that the store will begin accepting orders. RMS.store start_order_days number 3 Yes The number of days before the store open date that the store will begin accepting orders.
currency_code varchar23 1 1 The code of the currency under which the store operates. This value must be predefined on the CURRENCIES table. It cannot be modified. RMS.store currency_code varchar2 3 Yes The code of the currency under which the store operates. This value must be predefined on the CURRENCIES table. It cannot be modified.
lang number6 0 1 The code of the language used at the store. This value must be predefined on the LANG table. RMS.store lang number 6 No The code of the language used at the store. This value must be predefined in the LANG table.
iso_code varchar26 0 1 The character code corresponding to the Language used at the store Fill application table name. Fill table column name. null null No The character code corresponding to the language used at the store.
integrated_pos_ind varchar21 1 1 Indicates whether the store's POS is integrated. RMS.store integrated_pos_ind varchar2 1 Yes Indicates whether the store's POS is integrated.
duns_number varchar29 0 1 This type can hold a number of digits count umber. RMS.store duns_number varchar2 9 No The Dun and Bradstreet number to identify the store.
duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. RMS.store duns_loc varchar2 4 No The Dun and Bradstreet number to identify the location.
copy_dlvry_ind varchar21 0 1 Indicates if the like store's delivery schedule information should be copied to the new store. This value cannot be modified. It will only be populated on a store create message. RMS.store_add copy_dlvry_ind varchar2 1 No Indicates whether the like store's delivery schedule information should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
copy_activity_ind varchar21 0 1 Indicates if the like store's closing date schedule should be copied to the new store. This value cannot be modified. It will only be populated on a store create message. RMS.store_add copy_activity_ind varchar2 1 No Indicates whether the like store's closing date schedule should be copied to the new store. This value cannot be modified. It will only be populated on a store create message.
price_store number10 0 1 The store from which pricing information will be copied to the new store. The pricing store does not need the same currency as the new store. This value is not required on a create message and should not be populated on a modify message. RMS.store_add price_store number 10 No The store from which pricing information is copied to the new store. The pricing store does not need the same currency as the new store. This value is not required in a create message and should not be populated in a modify message.
cost_location number10 0 1 The location from which to copy cost information to the new store. This field should only be populated on store create messages. This value must be predefined on the WH or STORE table. This value cannot be modified. RMS.store_add cost_location number 10 No The location from which to copy cost information to the new store. This field should only be populated in store create messages. This value must be predefined in the WH or STORE table. This value cannot be modified.
vat_include_ind varchar21 0 1 Indicates whether retail prices for the store will contain VAT. RMS.store vat_include_ind varchar2 1 No Indicates whether retail prices for the store will contain VAT.
vat_region number4 0 1 The vat region of which the store is a part. This value must be predefined on the VAT_REGION table. It is required if VAT is on in the system. RMS.store vat_region number 4 No The VAT region of which the store is a part. This value must be predefined on the VAT_REGION table. It is required if VAT is on in the system.
like_store number10 0 1 The store from which the new store will have item\locations copied. This value must be predefined on the STORE table. It cannot be modified and will only be populated on a create message. RMS.store_add like_store number 10 No The store from which the new store copies item\locations. This value must be predefined in the STORE table. It cannot be modified and will only be populated in a create message.
copy_repl_ind varchar21 0 1 Indicates whether replenishment information should be copied from the like store to the new store. This field cannot be modified. It will only be populated on a store create message. RMS.store copy_repl_ind varchar2 1 No Indicates whether replenishment information should be copied from the like store to the new store. This field cannot be modified. It will only be populated in a store create message.
transfer_entity number10 1 1 The transfer entity of which the store is a part. This value must be predefined on the TSF_ENTITY table. If the system allows intercompany transfers this field is required. RMS.store tsf_entity_id number 10 Yes The transfer entity of which the store is a part. This value must be predefined on the TSF_ENTITY table. If the system allows intercompany transfers this field is required.
sister_store number10 0 1 The store which will be used to relate historical data to the new store. This value must be predefined on the STORE table. RMS.store sister_store number 10 No The store used for relating historical data to the new store. This value must be predefined in the STORE table.
tran_no_generated varchar26 1 1 The level at which unique POS transaction numbers are generated. RMS.store tran_no_generated varchar2 6 Yes The level at which unique POS transaction numbers are generated.
county varchar2250 0 1 The county in which the store is located. RMS.addr county varchar2 250 No The county in which the store is located.
XStoreLocTrt:XStoreLocTrt * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
XStoreWT:XStoreWT * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
timezone_name varchar264 0 1 TimeZone name. RMS.store timezone_name varchar2 64 Yes Indicates the time zone of the store. For example, 'America/New_York'.
wf_customer_id number10 0 1 Customer ID associated with the WF Store. RMS.store wf_customer_id number 10 No Customer ID associated with the WF store
org_unit_id number15 0 1 Column will contain the organizational unit ID value. RMS.store org_unit_id number 15 No Column will contain the organizational unit ID value.
store_name_secondary varchar2150 0 1 Secondary name of the store. This field can only be populated when system_options.secondary_desc_ind = Y. RMS.store store_name_secondary varchar2 150 No Secondary name of the store. This field can only be populated when system_options.secondary_desc_ind = Y.
customer_order_loc_ind varchar21 0 1 Customer order location indicator. This field can have Y or N. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:XStoreLocTrt Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreLocTrt in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
loc_trait number4 1 1 The identifier of the location trait. Though the node is optional, this field is required if the node is included. The node can not be populated on the store create message. RMS.loc_traits loc_trait number 4 Yes The identifier of the location trait. Though the node is optional, this field is required if the node is included. The node can not be populated on the store create message.

XML-Schema Name:XStoreWT Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreWT in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
walk_through_store number10 1 1 A walk through store of the store being modified. Though the node is optional, if it is included this field is required. This node can not be populated on a store create message. RMS.walk_through_store walk_through_store number 10 Yes A walk through store of the store being modified. Though the node is optional, if it is included this field is required. This node can not be populated on a store create message.

XML-Schema Name:AddrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
city_id varchar210 0 1 Indicates the City Id or Code. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state_name varchar2120 0 1 Indicates the State name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
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. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_addr_type_ind varchar21 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_1 varchar2240 1 1 Contains the first line of the address Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_2 varchar2240 0 1 Contains the second line of the address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_3 varchar2240 0 1 Contains the thirdline of the address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
city varchar2120 1 1 Contains the name of the city that is associated with the address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_id varchar23 1 1 Contains the country where the address exists. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
post varchar230 0 1 Contains the zip code for the address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
county varchar2250 0 1 Contains the county name for the location. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.