Retail Integration Bus Mappings Report Release:13.1.1 (Store Inventory Management)
Application Store Inventory Management
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.

XML-Schema Name:StoreDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For StoreDesc
Table Name Column Name API Type Column Length API Required API Description
store number10 1 1 Description is not available. PA_STR_RTL ID_STR_RT NUMBER 128 No Not Yet Available
store_type varchar21 1 1 Description is not available. * * varchar2 1 Yes *
store_name varchar2150 1 1 Description is not available. PA_ORGN NM_ORGN VARCHAR2 40 No Not Yet Available
store_name10 varchar210 0 1 Description is not available. null null null null null
store_name3 varchar23 0 1 Description is not available. null null null null null
store_add1 varchar2240 0 1 Description is not available. null null null null null
store_add2 varchar2240 0 1 Description is not available. null null null null null
store_city varchar2120 0 1 Description is not available. PA_ORGN ID_GRP_MSG VARCHAR2 128 No Not Yet Available
county varchar2250 0 1 Description is not available. null null null null null
state varchar23 0 1 Description is not available. PA_ORGN ID_GRP_MSG VARCHAR2 128 No Not Yet Available
country_id varchar23 0 1 Description is not available. PA_ORGN ID_GRP_MSG VARCHAR2 128 No Not Yet Available
store_pcode varchar230 0 1 Description is not available. null null null null null
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. null null null null null
store_mgr_name varchar2120 0 1 Description is not available. null null null null null
store_open_date xs:dateTime 0 1 Description is not available. PA_STR_RTL DC_OPN_RT_STR RIBDate * No Not Yet Available
store_close_date xs:dateTime 0 1 Description is not available. PA_STR_RTL DC_CL_RT_STR RIBDate * No Not Yet Available
acquired_date xs:dateTime 0 1 Description is not available. null RIBDate * null null
remodel_date xs:dateTime 0 1 Description is not available. null RIBDate * null null
fax_number varchar220 0 1 This type can hold a number of digits count mber. null varchar2 20 null null
phone_number varchar220 0 1 This type can hold a number of digits count number. null varchar2 20 null null
email varchar2100 0 1 Description is not available. null varchar2 100 null null
total_square_ft number8 0 1 Description is not available. PA_STR_RTL QU_SZ_STR NUMBER 9,2 No Not Yet Available
selling_square_ft number8 0 1 Description is not available. PA_STR_RTL QU_SZ_AR_SL NUMBER 9,2 No Not Yet Available
linear_distance number8 0 1 Description is not available. null number 8 null null
stockholding_ind varchar21 0 1 This column indicates whether the store can hold stock. In a non-multichannel environment this will always be null null null null null
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. null number 4 null null
store_format number4 0 1 Contains the number indicating the format of the store. Valid values are found on the store format table. null number 4 null null
mall_name varchar2120 0 1 Description is not available. null varchar2 120 null null
district number10 0 1 Description is not available. null null null null null
district_name varchar2120 0 1 Description is not available. null null null null null
promo_zone number4 0 1 Description is not available. null null null null null
promo_desc varchar220 0 1 Description is not available. null null null null null
transfer_zone number4 0 1 Contains the transfer zone in which the store is located. Valid values are located on the tsfzone table. PA_STR_RTL ID_TSF_ZONE NUMBER 128 No Not Yet Available
description varchar21000 0 1 Description is not available. null varchar2 1000 null null
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. null varchar2 10 null null
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. null number 3 null null
start_order_days number3 0 1 Contains the number of days before the store_open_date that the store will begin accepting orders. null null null null null
currency_code varchar23 0 1 Description is not available. PA_STR_RTL TY_CNY VARCHAR2 40 No Not Yet Available
lang number6 0 1 Description is not available. null null null null null
integrated_pos_ind varchar21 0 1 Description is not available. null null null null null
orig_currency_code varchar23 0 1 holds the original currency of a store after it's adopted the Euro as its main operating currency null null null null null
duns_number varchar29 0 1 This type can hold a number of digits count umber. null varchar2 9 null null
duns_loc varchar24 0 1 Description is not available. null varchar2 4 null null
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. null null null null null
pricing_loc_curr varchar23 0 1 Description is not available. null null null null null
org_unit_id number15 0 1 Description is not available. NA NA NA NA NA NA
timezone_name varchar264 0 1 Description is not available. NA NA NA NA NA NA
ExtOfStoreDesc:ExtOfStoreDesc * 0 1 Provide an extension hook to customize StoreDesc. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
addr number6 1 1 Description is not available. LO_ADS_NSTD TBD NUMBER * No Not Yet Available
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. null null null null null
primary_addr_type_ind varchar21 1 1 Description is not available. null null null null null
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type null null null null null
add_1 varchar2240 1 1 Description is not available. LO_ADS_NSTD A1_ADS VARCHAR2 40 No Not Yet Available
add_2 varchar2240 0 1 Description is not available. LO_ADS_NSTD A2_ADS VARCHAR2 40 No Not Yet Available
add_3 varchar2240 0 1 Description is not available. null varchar2 240 null null
city varchar2120 1 1 Description is not available. LO_ADS_NSTD CITY VARCHAR2 40 No Not Yet Available
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. LO_ADS_NSTD TE_NM VARCHAR2 40 No Not Yet Available
country_id varchar23 1 1 Description is not available. LO_ADS_NSTD CO_NM VARCHAR2 40 No Not Yet Available
post varchar230 0 1 Description is not available. LO_ADS_NSTD PC_NM VARCHAR2 15 No Not Yet Available
contact_name varchar2120 0 1 Description is not available. null null null null null
contact_phone varchar220 0 1 Description is not available. LO_PH TA_PH VARCHAR2 10-15-10 No Not Yet Available
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. LO_PH TA_PH VARCHAR2 10 No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_fax varchar220 0 1 Description is not available. LO_PH TA_PH VARCHAR2 10 No Mapped to TL_PH, PH_EXTN as well. Not Yet Available
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. LO_EML_ADS EM_ADS VARCHAR2 64 Yes Not Yet Available
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. null null null null null
county varchar220 0 1 Description is not available. null null null null null
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddrDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfStoreDesc Version:13.1.1 Return to Top
Tag Name Type Min Occurs Max Occurs Description sim Mapping For ExtOfStoreDesc
Table Name Column Name API Type Column Length API Required API Description