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

XML-Schema Name:XStoreRef Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and BDI) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
store number10 1 1 The store number being deleted, or for which a location trait or walk through store is being disassociated. RMS.store store null null Yes The store number being deleted, or for which a location trait or walk through store is being disassociated.
XStoreLocTrt:XStoreLocTrt * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
XStoreWT:XStoreWT * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
AddrRef:AddrRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
StoreHoursRef:StoreHoursRef * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
XStoreUpChrgRef * 0 unbounded Child node.

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

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

XML-Schema Name:AddrRef Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and BDI) IGS's Column Length Is Column Required in IGS's API? IGS'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.

XML-Schema Name:StoreHoursRef Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StoreHoursRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and BDI) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
store_id number10 1 1 Unique ID of the store.
day_no number1 1 1 This field indicates the day of the week for which store timing is being stored.

XML-Schema Name:XStoreUpChrgRef Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreUpChrgRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and BDI) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
hier_level varchar26 1 1 The hierarchy level for Department Up Charges. Valid values are: DI - Division, GR - Group, DE - Department, AD - All Department.
hier number4 0 1 The value of the hierarchy.
from_loc varchar210 0 1 Contains the source location from which goods will be transferred. This column can contain Country/Area/Region IDs when From Location Type is 'C', 'A', or 'R'. It will be a store, virtual warehouse or physical warehouse when From Location Type is 'S', 'W' or 'PW'. Otherwise, it should be left blank when From Location Type is either 'AS' or 'AW'.
to_loc varchar210 0 1 Contains the destination location to which goods will be transferred. This column can contain Country/Area/Region IDs when To Location Type is 'C', 'A', or 'R'. It will be a store, virtual warehouse or physical warehouse when To Location Type is 'S', 'W' or 'PW'. Otherwise, it should be left blank when To Location Type is either 'AS' or 'AW'.
from_loc_type varchar26 1 1 Contains the type of source location from which goods will be transferred. Valid values are C - Country, A - Area, R - Region, S - store, W - Virtual Warehouse, PW - Physical Warehouse, AS - All Stores, AW - All Warehouses.
to_loc_type varchar26 1 1 Contains the type of destination location to which goods will be transferred. Valid values are C - Country, A - Area, R - Region, S - store, W - Virtual Warehouse, PW - Physical Warehouse, AS - All Stores, AW - All Warehouses.
XStoreUpChrgDtlRef * 0 unbounded Child node.

XML-Schema Name:XStoreUpChrgDtlRef Version:19.0.000 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for XStoreUpChrgDtlRef in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and BDI) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
comp_id varchar210 0 1 This field contains the unique identifier of the Up Charge component. NA NA NA NA NA NA