Application
|
Retail Merchandising System
|
Target Name Space
|
http://www.oracle.com/retail/integration/base/bo/SupplierRef/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:SupplierRef
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SupplierRef 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 |
|
supplier_id |
number10 |
1 |
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 |
Yes |
|
SupplierSite
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfSupplierRef:ExtOfSupplierRef
|
*
|
0
|
1
|
Provide an extension hook to customize SupplierRef.
|
|
|
|
|
|
|
LocOfSupplierRef:LocOfSupplierRef
|
*
|
0
|
unbounded
|
Provide an extension hook to localize SupplierRef.
|
|
|
|
|
|
|
|
|
XML-Schema Name:SupplierSite
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SupplierSite 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 |
supsite_xref_key |
varchar232 |
1 |
1 |
Description is not available. |
* |
supsite_xref_key |
varchar2 |
32 |
Yes |
|
supplier_site_id |
number10 |
1 |
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_site_id |
number |
10 |
Yes |
|
SupplierSiteAddr
|
*
|
1
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfSupplierRef:ExtOfSupplierSite
|
*
|
0
|
1
|
Provide an extension hook to customize SupplierSite.
|
|
|
|
|
|
|
LocOfSupplierRef:LocOfSupplierSite
|
*
|
0
|
1
|
Provide an extension hook to localize SupplierSite.
|
|
|
|
|
|
|
|
|
XML-Schema Name:SupplierSiteAddr
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for SupplierSiteAddr 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 |
addr_xref_key |
varchar232 |
1 |
1 |
This column contains a unique number used to distinguish between different addresses. |
* |
addr_xref_key |
varchar2 |
32 |
Yes |
|
addr_key |
number11 |
1 |
1 |
This column contains a unique number used to distinguish between different addresses. |
addr |
addr_key |
number |
10 |
No |
This column contains a unique number used to distinguish between different addresses. |
ExtOfSupplierRef:ExtOfSupplierSiteAddr
|
*
|
0
|
1
|
Provide an extension hook to customize SupplierSiteAddress.
|
|
|
|
|
|
|
LocOfSupplierRef:LocOfSupplierSiteAddr
|
*
|
0
|
1
|
Provide an extension hook to localize SupplierSiteAddress.
|
|
|
|
|
|
|
|
|
XML-Schema Name:ExtOfSupplierSiteAddr
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ExtOfSupplierSiteAddr 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:LocOfSupplierSiteAddr
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocOfSupplierSiteAddr 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 |
InSupplierRef:InSupplierSiteAddr
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrSupplierRef:BrSupplierSiteAddr
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfSupplierSite
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ExtOfSupplierSite 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:LocOfSupplierSite
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocOfSupplierSite 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 |
InSupplierRef:InSupplierSite
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrSupplierRef:BrSupplierSite
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|
XML-Schema Name:ExtOfSupplierRef
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ExtOfSupplierRef 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:LocOfSupplierRef
|
Version:14.1.0
|
Return to Top
|
XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocOfSupplierRef 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 |
InSupplierRef:InSupplierRef
|
*
|
0
|
unbounded
|
India Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
BrSupplierRef:BrSupplierRef
|
*
|
0
|
unbounded
|
Brazil Localization.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
|