Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure AddrDesc

XML-Schema Name:AddrDesc 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 AddrDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM'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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/AddrRef/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure AddrRef

XML-Schema Name:AddrRef 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 AddrRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffDesc

XML-Schema Name:DiffDesc 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 DiffDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_id varchar210 1 1 This field will hold a unique number (identifier) of the differentiator. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_type varchar26 1 1 This field holds a value of all possible differential types. Valid values are stored in the code_detail table with the code_type of 'DIFF'. Valid values are also found in the diff_type table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_desc varchar2120 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. industry_code varchar210 0 1 A unique number that represents all possible combinations of sizes according to the National Retail Federation. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. industry_subcode varchar210 0 1 A unique number that represents all different color range groups. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpDtlDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpDtlDesc

XML-Schema Name:DiffGrpDtlDesc 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 DiffGrpDtlDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_group_id varchar210 1 1 Contains the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_id varchar210 1 1 Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. display_seq number4 0 1 This field contains the display sequence for the differential. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpDtlRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpDtlRef

XML-Schema Name:DiffGrpDtlRef 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 DiffGrpDtlRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_group_id varchar210 1 1 Contains the value of the differential group that the differential belongs to. This field must be a valid value on the diff_group_head table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_id varchar210 1 1 Contains the value of the differential that is included in the differential group. This field must be a valid value from the diff_ids table. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpHdrDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpHdrDesc

XML-Schema Name:DiffGrpHdrDesc 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 DiffGrpHdrDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_group_id varchar210 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_group_type varchar26 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. diff_group_desc varchar2120 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffGrpRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffGrpRef

XML-Schema Name:DiffGrpRef 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 DiffGrpRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_group_id varchar210 1 1 This field holds a unique number (identifier) of the differential group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DiffRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DiffRef

XML-Schema Name:DiffRef 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 DiffRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description diff_id varchar210 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/DistanceDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure DistanceDesc

XML-Schema Name:DistanceDesc 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 DistanceDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description distance number10 1 1 The numerical value of distance. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit unit_type 1 1 The unit of distance. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/GeoAddrDesc/v1 Version 1.0 Description This is a generic address object XSD Structure GeoAddrDesc

XML-Schema Name:GeoAddrDesc 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 GeoAddrDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description addr_id number22 0 1 Unique identifier for this address entry. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. addr_type addr_type 0 1 The address type can be any of the enumerated values 'Home','Office','Billing','Shipping' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_alias varchar2250 0 1 Alias for this address, example 'My Event Venue' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_1 varchar2240 1 1 Contains Address Line 1. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_2 varchar2240 0 1 Contains Address Line 2. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_3 varchar2240 0 1 Contains Address Line 3. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_4 varchar2240 0 1 Contains Address Line 4. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address_5 varchar2240 0 1 Contains Address Line 5. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. city varchar2120 0 1 Contains the city where the address is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 County where this address is located Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_code varchar23 0 1 Contains the postal abbreviation for the state, province or territory in which the address is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state_name varchar2120 0 1 Indicates the state, province or territory name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_code varchar23 0 1 Contains the postal abbreviation of the country in which the address is located Fill application table name. Fill table column name. RIB or/and RSB 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 Fill column length. Yes Fill this description. postal_code varchar230 0 1 Contains the postal code for the address Fill application table name. Fill table column name. RIB or/and RSB 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 Fill column length. Yes Fill this description. contact_preference_code varchar2120 0 1 Indicates the type of communications being sent to this address. Sample values are order information only, promotion info only, marketing material, no contact Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. validated_addr_flag xs:boolean 0 1 If the retailer integrates with an external system that does address validation at the time of adding this record, this flag is set to true. Absence of this element should indicate "false". Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAvailColDesc/v1 Version 1.0 Description XSD Structure InvAvailColDesc InvAvailDesc

XML-Schema Name:InvAvailColDesc 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 InvAvailColDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description InvAvailDesc:InvAvailDesc * 0 unbounded A collection of InvAvailDesc objects. NA NA NA NA NA NA collection_size number6 1 1 Number of items in the collection. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:InvAvailDesc 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 InvAvailDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description item varchar225 1 1 The item identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. location number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type loc_type 1 1 Type of location. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is warehouse, this is optional based on the input criteria. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. available_qty number12_4 1 1 Contains the available quantity for the item/location in standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_of_measure varchar24 1 1 Contains the unit of measure for available quantity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. available_date xs:dateTime 0 1 The date at which this quantity of inventory is available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_calculate_ind pack_calculate_ind 0 1 Valid for pack item only. Indicate if the pack item available quantity is actual held value ('N') or calculated using pack component ('Y'). Calculated pack quantity should be treated as an estimate value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. Dist:DistanceDesc * 0 1 Gives the distance of the location from the center of Search Area. NA NA NA NA NA NA

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAvailCriVo/v1 Version 1.0 Description XSD Structure InvAvailCriVo InvLocation

XML-Schema Name:InvAvailCriVo 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 InvAvailCriVo in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description items varchar225 1 999 Contains the transaction level item numbers for which to check inventory. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. InvLocation * 1 999 Contains the locations at which to check inventory. sa:SearchAreaDesc * 0 1 Used for proximity calculation. This defines the criteria to identify the inventory locations. SearchAreaDesc will override InvLocation when present. NA NA NA NA NA NA store_pickup_ind store_pickup_ind 1 1 Indicates if the inventory availability lookup is for general purpose or specific for store pickup. Valid values are 'Y' (store pickup) and 'N' (others). This field will be used for routing the input request. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:InvLocation 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 InvLocation in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description location number10 1 1 The location at which to check item inventory. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type loc_type 1 1 Type of item inventory location. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 Only used when a physical WH is passed. If a channel is passed the results will be limited by the passed in channel. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/InvAvailDesc/v1 Version 1.0 Description XSD Structure InvAvailDesc

XML-Schema Name:InvAvailDesc 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 InvAvailDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description item varchar225 1 1 The item identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. location number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type loc_type 1 1 Type of location. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is warehouse, this is optional based on the input criteria. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. available_qty number12_4 1 1 Contains the available quantity for the item/location in standard unit of measure. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_of_measure varchar24 1 1 Contains the unit of measure for available quantity. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. available_date xs:dateTime 0 1 The date at which this quantity of inventory is available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pack_calculate_ind pack_calculate_ind 0 1 Valid for pack item only. Indicate if the pack item available quantity is actual held value ('N') or calculated using pack component ('Y'). Calculated pack quantity should be treated as an estimate value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. Dist:DistanceDesc * 0 1 Gives the distance of the location from the center of Search Area. NA NA NA NA NA NA

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemLocDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemLocDesc ItemLocPhys ItemLocVirt ItemLocVirtRepl

XML-Schema Name:ItemLocDesc 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 ItemLocDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description item varchar225 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocPhys * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhys 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 ItemLocPhys in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description physical_loc number10 1 1 Identifier of the physical location where the item is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 1 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = Finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. returnable_ind varchar21 0 1 This field will contain a value of Yes when the item can be returned to the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocVirt * 0 unbounded Description is not available. ItemLocVirtRepl * 0 unbounded Description is not available.

XML-Schema Name:ItemLocVirt 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 ItemLocVirt in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description loc number10 1 1 Location where the item is to be found. This field may contain a store or a warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 1 1 Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. local_item_desc varchar2250 1 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. local_short_desc varchar2120 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. status varchar21 1 1 Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_supp number10 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_cntry varchar23 0 1 Contains the origin country which will be considered the primary country for the item/location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. receive_as_type varchar21 0 1 Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. taxable_ind varchar21 1 1 Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. source_method varchar21 0 1 Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. source_wh number10 0 1 If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_retail number20_4 0 1 Unit retail of the item in the selling Unit of Measure. Only published for create not modify. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. selling_unit_retail number20_4 0 1 Selling unit retail in selling unit of measure. Only published for create, not update Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. selling_uom varchar24 0 1 Selling Unit of measure. Only published for Create not update. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_price_ind varchar21 0 1 Indicates if the location can modify the item's price. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Purchase Type Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uin_type varchar26 0 1 This attribute will contain the type of the unique identification number (UIN) used to identify instances of the item at the location. Valid values for this attribute should be user-definable on the RMS code tables. This attribute should be nullable. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. uin_label varchar26 0 1 This attribute will contain the label for the UIN when displayed in SIM. Valid values should be user-definable on the RMS code tables. This attribute should be nullable but a value is required when a UIN Type is specified. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. capture_time varchar26 0 1 This attribute will indicate when the UIN should be captured for an item during transaction processing. There are 2 valid values for this field which should be stored on the RMS code tables: Sale and Store Receiving. This attribute should be nullable. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ext_uin_ind varchar21 0 1 This Yes/No indicator indicates if UIN is being generated in the external system (e.g. SIM). This value will always be N (no) when the Capture Time attribute is set to Sale. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ranged_ind varchar21 1 1 An indicator to differentiate between user ranged locations and RMS program ranged locations. Values are 'Y' or 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:ItemLocVirtRepl 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 ItemLocVirtRepl in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description loc number10 1 1 Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 1 1 Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. primary_repl_supplier number10 0 1 Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. repl_method varchar26 0 1 Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. reject_store_order_ind varchar21 0 1 Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid." Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. next_delivery_date xs:dateTime 0 1 Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. multiple_runs_per_day_ind varchar21 0 1 Indicates if the item-location is replenished multiple times per day. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/ItemLocRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure ItemLocRef ItemLocPhysRef ItemLocVirtRef

XML-Schema Name:ItemLocRef 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 ItemLocRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description item varchar225 1 1 Unique identifier for the item. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocPhysRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocPhysRef 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 ItemLocPhysRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description physical_loc number10 1 1 Identifier of the physical location where the item is located. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. loc_type varchar21 0 1 Type of location in the physical_loc field. Valid values are: S = Store, W = Warehouse, E = external finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the physical_loc store. Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the physical_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. ItemLocVirtRef * 1 unbounded Description is not available.

XML-Schema Name:ItemLocVirtRef 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 ItemLocVirtRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description loc number10 1 1 Numeric identifier of the location in which the item is to be found. This field may contain a store, warehouse, or external finisher. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/LocationDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure LocationDesc

XML-Schema Name:LocationDesc 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 LocationDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description dest_id varchar210 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_type varchar220 0 1 The dest_type field indicates if the location is a store, warehouse, or finisher. Values from RMS will be as follows: 'E', 'S', 'W'. When this value is consumed by RWMS it will be translated as follows: ('W' = 'WAREHOUSE') , ('E' = 'FINISHER'), (if 'S' and store_type = 'C' and stock_holding_ind = 'N' then 'VIRTUAL' else 'S' = 'STORE' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the location (dest_id). Only populated if loc_type is 'S'. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the to_loc store is stockholding or not. Only populated if loc_type is 'S'. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. description varchar21000 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address1 varchar2240 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. address2 varchar2240 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. city varchar2120 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_code varchar23 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. zip varchar230 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_person varchar2120 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_fax varchar220 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. phone_nbr varchar220 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. currency_code varchar23 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_route varchar210 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_carrier_code varchar24 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_service_code varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_route varchar210 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_carrier_code varchar24 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_service_code varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_upload_type varchar24 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_print_type varchar24 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lead_time number3 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. distance_to_dest number4 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. drop_trailers_accepted_flag varchar21 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rcv_dock_available_flag varchar21 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_type varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mld_default_route varchar210 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_pick_container_type varchar26 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_seq_nbr number4 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. owning_dc varchar210 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email_to varchar2500 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email_cc varchar2500 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email_bcc varchar2500 0 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_unit_id number15 0 1 This field holds the Org Unit id of the Location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/LocationRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure LocationRef AddrRef

XML-Schema Name:LocationRef 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 LocationRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description dest_id varchar210 1 1 Description is not available. rxm_site ext_site_id RIB or/and RSB 10 Yes Web sites are identified by merchandise management as locations. The location id is save as the site's externalSiteId. AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef 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 AddrRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrClsDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrClsDesc

XML-Schema Name:MrchHrClsDesc 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 MrchHrClsDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description class number4 1 1 Contains the number which uniquely identifies the class within the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class_name varchar2120 1 1 Contains the name of the class which, along with the class number, identifies the class. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class_vat_ind varchar21 0 1 This field determines if retail is displayed and held with or with out vat. This field is only editable when vat is turned on in the system and defined at the class level, when that is the case the field can vary between 'Y' and 'N' by class. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the number of the department of which the class is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrClsRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrClsRef

XML-Schema Name:MrchHrClsRef 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 MrchHrClsRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description class number4 1 1 Contains the number which uniquely identifies the class within the system. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the number of the department of which the class is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDeptDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDeptDesc

XML-Schema Name:MrchHrDeptDesc 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 MrchHrDeptDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description dept number4 1 1 Contains the number which uniquely identifies the department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept_name varchar2120 0 1 Not used by SIM Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. buyer number4 0 1 Contains the number which uniquely identifies the buyer for that department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. purchase_type varchar26 0 1 Contains a code which indicates whether items in this department are normal merchandise or consignment stock. Valid values are:0 = Normal Merchandise1 = Consignment Stock. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. total_market_amt number24_4 0 1 Contains the total market amount that is expected for the department. The field can be used for analytics or reporting. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number which uniquely describes the merchandiser for that department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. group_no number4 0 1 Contains the number of the group in which the department exists. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bud_mkup number12_4 0 1 Contains the Budgeted Markup percentage. This term is synonymous with the term Markup Percent of Cost. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. profit_calc_type number1 0 1 Contains a number which indicates whether profit will be calculated by Direct Cost or by Retail Inventory. Valid values are:1 = Direct Cost, 2 = Retail Inventory Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. markup_calc_type varchar22 0 1 Contains the code letter which determines how markup is calculated in this department. Valid values are:C = Cost, R = Retail Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. otb_calc_type varchar21 0 1 Contains the code letter which determines how OTB is calculated in this department. Valid values are:C = Cost, R = Retail Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. max_avg_counter number5 0 1 A maximum average counter will hold the maximum count of days with acceptable data to include in an avarage for items within the department. Although not required on the table, if the RPM_ind column is 'Y' (yes) on the system_options table, then this field will be required when maintaining departments online. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. avg_tolerance_pct number12_4 0 1 A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70. Although not required on the table, if the RPM_ind column Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bud_int number12_4 0 1 Contains the Budgeted Intake percentage. Budgeted Intake is the percent of total take that is income and is synonymous with the term Markup Percent of Retail. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept_vat_incl_ind varchar21 0 1 This indicator will be be used only to default to the class level indicator when classes are initially set up for the department and will only be available when the system level class vat option is on. When vat is turned on in the system and not defined at the class level, this field defaults to 'Y'. When vat is turned off in the system, this field defaults to 'N'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDeptRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDeptRef

XML-Schema Name:MrchHrDeptRef 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 MrchHrDeptRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description dept number4 1 1 Contains the number which uniquely identifies the department. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDivDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDivDesc

XML-Schema Name:MrchHrDivDesc 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 MrchHrDivDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description division number4 1 1 Contains the number which uniquely identifies the division of the company. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. div_name varchar2120 1 1 Contains the name which, along with the division number, identifies the division of the company. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. buyer number4 0 1 Contains the number of the buyer associated with the division. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number of the merchandiser associated with the division. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. total_market_amt number24_4 0 1 Contains the total market amount that is expected for the division. The field can be used for analytics or reporting. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrDivRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrDivRef

XML-Schema Name:MrchHrDivRef 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 MrchHrDivRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description division number4 1 1 Contains the number which uniquely identifies the division of the company. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrGrpDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrGrpDesc

XML-Schema Name:MrchHrGrpDesc 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 MrchHrGrpDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description group_no number4 1 1 Contains the number which uniquely identifies the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. group_name varchar2120 1 1 Contains the description which, along with the group number, identifies the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. buyer number4 0 1 Contains the number of the buyer associated with the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. merch number4 0 1 Contains the number of the merchandiser associated with the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. division number4 1 1 Contains the number of the division of which the group is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrGrpRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrGrpRef

XML-Schema Name:MrchHrGrpRef 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 MrchHrGrpRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description group_no number4 1 1 Contains the number which uniquely identifies the group. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrSclsDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrSclsDesc

XML-Schema Name:MrchHrSclsDesc 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 MrchHrSclsDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description subclass number4 1 1 Contains the number which uniquely identifies the subclass. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. subclass_name varchar2120 1 1 Contains the name of the subclass which, along with the subclass number, uniquely identifies the subclass. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class number4 1 1 Contains the class number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the department number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/MrchHrSclsRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure MrchHrSclsRef

XML-Schema Name:MrchHrSclsRef 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 MrchHrSclsRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description subclass number4 1 1 Contains the number which uniquely identifies the subclass. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. class number4 1 1 Contains the class number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dept number4 1 1 Contains the department number of which the subclass is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/SearchAreaDesc/v1 Version 1.0 Description XSD Structure SearchAreaDesc Center

XML-Schema Name:SearchAreaDesc 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 SearchAreaDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description Center * 1 1 Requesting customer specified address or a store ID. Used for calculating nearby stores located within the specified distance. Dist:DistanceDesc * 1 1 Used for proximity calculation. Holds the distance with unit. NA NA NA NA NA NA

XML-Schema Name:Center 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 Center in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description AddrDesc:GeoAddrDesc * 0 1 Customer specified address. Not used when a store id is specified. NA NA NA NA NA NA store_id number10 0 1 ID of the store, for which other stores which are in its proximity, need to be found.Not used when an address is specified. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module 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 StoreDesc AddrDesc

XML-Schema Name:StoreDesc 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 StoreDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description store number10 1 1 Contains the number to uniquely identify the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 1 1 This will indicate whether a particular store is a franchise or company store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_name varchar2150 1 1 Contains the name of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_name10 varchar210 0 1 Contains a ten character abbreviation of the store name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_name3 varchar23 0 1 Contains a three character abbreviation of the store name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_add1 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_add2 varchar2240 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_city varchar2120 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_id varchar23 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_pcode varchar230 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_mgr_name varchar2120 0 1 Contains the name of the store manager. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_open_date xs:dateTime 0 1 Contains the date on which the store opened. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_close_date xs:dateTime 0 1 Contains the date on which the store closed. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. acquired_date xs:dateTime 0 1 Contains the date on which the store was acquired. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes 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. RIB or/and RSB Fill column length. Yes Fill this description. fax_number varchar220 0 1 Contains the fax number for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. phone_number varchar220 0 1 Contains the phone number for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email varchar2100 0 1 Contains the email address for the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. total_square_ft number8 0 1 Contains the total square footage of the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. selling_square_ft number8 0 1 Contains the total square footage of the store's selling area. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. linear_distance number8 0 1 Contains the total space of the location that can be used for merchandise. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_format number4 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. RIB or/and RSB Fill column length. Yes 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. RIB or/and RSB Fill column length. Yes Fill this description. district number10 0 1 Contains the number of the district in which the store is a member. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. district_name varchar2120 0 1 Contains the name of the district. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. promo_zone number4 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. promo_desc varchar220 0 1 Not used by RMS. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. transfer_zone number4 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. RIB or/and RSB Fill column length. Yes Fill this description. description varchar21000 0 1 Contains the name of the transfer zone. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. start_order_days number3 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. RIB or/and RSB Fill column length. Yes 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. RIB or/and RSB Fill column length. Yes Fill this description. lang number6 0 1 This column identifies the language to be used for the store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. integrated_pos_ind varchar21 0 1 Indicates whether the POS system at the store is integrated. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_number varchar29 0 1 This type can hold a number of digits count umber. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_loc varchar24 0 1 This field contains the Dun and Bradstreet number to identify the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pricing_loc_curr varchar23 0 1 This is the currency code of the pricing_loc store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_unit_id number15 0 1 Column will contain the organizational unit ID value. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. timezone_name varchar264 0 1 Indicates the time zone of the store. For example, 'America/New_York'. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:AddrDesc 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 AddrDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM'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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/StoreRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure StoreRef AddrRef

XML-Schema Name:StoreRef 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 StoreRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description store number10 1 1 The store number for the store or address being deleted. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. store_type varchar21 0 1 Indicates the store type of the store. Valid values are: 'C' = company store, 'F' = franchise store. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the store is stockholding or not. Valid values are: 'Y' = yes, 'N' = no. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef 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 AddrRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/WHDesc/v1 Version 1.1 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure WHDesc AddrDesc

XML-Schema Name:WHDesc 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 WHDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description wh number10 1 1 The number which uniquely identifies the warehouse. The wh table stores all warehouses in the system, both virtual and physical. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_name varchar2150 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_add1 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_add2 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_city varchar2120 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. county varchar2250 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. state varchar23 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. country_id varchar23 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. wh_pcode varchar230 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. email varchar2100 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. stockholding_ind varchar21 0 1 Indicates if the warehouse is a stock holding location. In a non-multichannel environment, this will always be 'Y'. In a multichannel environment it will be 'N' for a physical warehouse and 'Y' for a virtual warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. channel_id number4 0 1 The channel for which the virtual warehouse will be assigned. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. currency_code varchar23 1 1 The code for the currency which the warehouse uses. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_number varchar29 0 1 This type can hold a number of digits count umber. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. duns_loc varchar24 0 1 The Dun and Bradstreet number to identify the location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. physical_wh number10 0 1 The number of the physical warehouse corresponding to this warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. break_pack_ind varchar21 0 1 Indicates whether or not the warehouse is capable of distributing less than the supplier case quantity. Valid values are 'Y' or 'N' Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. redist_wh_ind varchar21 0 1 Indicates whether the warehouse is a 'Re-Distribution' warehouse. Used as a location on Purchase Orders in place of actual locations that are unknown at the time of purchase order creation. Used by Redistribution report. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. delivery_policy varchar26 0 1 The delivery policy of the warehouse. Next day indicates that the if a location is closed, the warehouse will deliver on the next day. Next Valid Delivery Day indicates that the warehouse will wait until the next scheduled delivery day. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. contact_person varchar2120 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_fax varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. phone_nbr varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. default_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_carrier_code varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. expedite_service_code varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_upload_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. bol_print_type varchar24 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. lead_time number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. distance_to_dest number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. drop_trailers_accepted_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. rcv_dock_available_flag varchar21 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. mld_default_route varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. unit_pick_container_type varchar26 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. dest_seq_nbr number4 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. owning_dc varchar210 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. 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 The location for which pricing info was copied for this warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. pricing_loc_curr varchar23 0 1 This is the currency code of the pricing location. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. org_unit_id number15 0 1 This field holds the Org Unit id of the Warehouse. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:AddrDesc 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 AddrDesc in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM'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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Fill column length. Yes Fill this description.

Retail Integration Mappings Report Release:16.0.21

(Retail Extended Module)

Application Retail Extended Module Target Name Space http://www.oracle.com/retail/integration/base/bo/WHRef/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. XSD Structure WHRef AddrRef

XML-Schema Name:WHRef 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 WHRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description wh number10 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description. AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA

XML-Schema Name:AddrRef 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 AddrRef in RXM application. RXM's Table Name RXM's Column Name Integration API(RIB or/and RSB or/and RSL) RXM's Column Length Is Column Required in RXM's API? RXM's API Description addr varchar232 1 1 The unique identifier of the address being deleted. For address delete messages that are interfaced into RMS, it will hold the external store system's address ID. For address delete messages published out of RMS, it will hold RMS's address ID. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.