Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/SupplierColDesc/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:SupplierColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SupplierColDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
collection_size number4 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
SupplierDesc:SupplierDesc * 1 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
ExtOfSupplierColDesc:ExtOfSupplierColDesc * 0 1 Provide an extension hook to customize SupplierCollectionDesc. NA NA NA NA NA NA
LocOfSupplierColDesc:LocOfSupplierColDesc * 0 1 Provide an extension hook to localize SupplierCollectionDesc. NA NA NA NA NA NA

XML-Schema Name:SupplierDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for SupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
sup_xref_key varchar232 1 1 This column holds the ID for the supplier used in the external financial system. It is populated by the integration that brings suppliers from external financial systems into RMS. This ID and the supplier site ID can be used to join to information about the supplier in the external system. * sup_xref_key varchar2 32 Yes Fill this description.
supplier_id number10 0 1 Unique identifying number for a supplier within the system. The user determines this number when a new supplier is first added to the system. * supplier_id number 10 No Fill this description.
SupAttr * 1 1 Description is not available.
SupSite * 0 unbounded Description is not available.
ExtOfSupplierDesc:ExtOfSupplierDesc * 0 1 Provide an extension hook to customize SupplierDesc. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupplierDesc * 0 unbounded Provide an extension hook to localize SupplierDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupplierDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ExtOfSupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupplierDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfSupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupplierDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupplierDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupplierColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ExtOfSupplierColDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupplierColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfSupplierColDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierColDesc:InSupplierColDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierColDesc:BrSupplierColDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA