Retail Integration Mappings Report Release:16.0.030 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/PartnerDesc/v1
Version 1.1
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:PartnerDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PartnerDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
partner_type varchar26 1 1 Specifies the type of the partner. partner partner_type varchar2 6 Yes Specifies the type of the partner.
partner_id varchar210 1 1 Unique identifying number for a partner within the system. partner partner_id varchar2 10 Yes Unique identifying number for a partner in the system.
partner_desc varchar2240 1 1 Contain the partner's description or name. partner partner_desc number 20,4 Yes Contain the partner's description or name.
currency_code varchar23 1 1 Contains a code identifying the currency the partner uses for business transactions. partner currency_code varchar2 3 Yes Contains a code identifying the currency the partner uses for business transactions.
lang number6 0 1 The partner's preferred language. This field is provided for custom purchase orders in a specified language partner lang number 6,0 No The partner's preferred language. This field is provided for custom purchase orders in a specified language.
status varchar21 1 1 Determines if the partner is currently active. Valid values are 'A' = Active or 'I' = Inactive. partner status varchar2 1 Yes Determines whether the partner is active. Valid values are A (active) and I (inactive).
contact_name varchar2120 0 1 Contains the name of the partner's representative contract. partner contact_name varchar2 120 Yes Contains the name of the partner's representative contact.
contact_phone varchar220 0 1 Contains the phone number of the partner's representative contact. partner contact_phone varchar2 20 Yes Contains the phone number of the partner's representative contact.
contact_fax varchar220 0 1 Contains the fax number of the partner's representative contact. partner contact_fax varchar2 20 No Contains the fax number of the partner's representative contact.
contact_telex varchar220 0 1 Contains the telex number of the partner's representative contact. partner contact_telex varchar2 20 No Contains the telex number of the partner's representative contact.
contact_email varchar2100 0 1 Contains the e-mail address of the partner's representative contact. partner contact_email varchar2 100 No Contains the e-mail address of the partner's representative contact.
mfg_id varchar218 0 1 Contains the manufacturer's tax identification number. This field is NULL when the Partner Type is Bank ('BK'). partner mfg_id varchar2 18 No Contains the manufacturer's tax identification number. This field is NULL whenPartner Type is BK (bank).
principal_country_id varchar23 0 1 Contains the country id to which the partner is assigned. This field is NULL when the Partner Type is Bank ('BK'). partner principal_country_id varchar2 3 No Contains the country ID to which the partner is assigned. This field is NULL when Partner Type is BK (bank).
line_of_credit number20_4 0 1 Contains the line of credit the company has at the Bank in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK'). partner line_of_credit number 20,4 No Contains the line of credit the company has at the bank in the partner's currency. This field is not NULL when Partner Type is BK (bank).
outstanding_credit number20_4 0 1 Contains the total amount of credit that the company has used or has charged against in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK'). partner outstanding_credit number 20,4 No Contains the total amount of credit that the company has used or has charged against in the partner's currency. This field is not NULL when the Partner Type is BK (bank).
open_credit number20_4 0 1 Contains the total amount that the company can still charge against in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK'). partner open_credit number 20,4 No Contains the total amount that the company can still charge against in the partner's currency. This field is not NULL when Partner Type is BK (bank).
ytd_credit number20_4 0 1 Contains the total amount of credit the company has used this year to date in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK'). partner ytd_credit number 20,4 No Contains the total amount of credit the company has used this year to date in the partner's currency. This field is not NULL when Partner Type is BK (bank).
ytd_drawdowns number20_4 0 1 Contains the year to date payments the bank has made on behalf of the company in the Partner's currency. This field is not NULL when the Partner Type is Bank ('BK'). partner ytd_drawdowns number 20,4 No Contains the year to date payments the bank has made on behalf of the company in the partner's currency. This field is not NULL when the Partner Type is BK (bank).
tax_id varchar218 0 1 Contains the unique tax identification number of the partner. This will be used for reporting during the Customs Entry process. partner tax_id varchar2 18 No Contains the partner's unique tax identification number. This field is used for reporting during the Customs Entry process.
terms varchar215 1 1 Payment terms for the partner. These terms specify when payment is due and if any discounts exist for early payment. If populated, they will default on any invoice entered for this partner. partner terms varchar2 15,0 Yes Payment terms for the partner. These terms specify when payment is due and if any discounts exist for early payment. If populated, this value defaults on invoices entered for this partner.
service_perf_req_ind varchar21 1 1 Indicates if the partner's services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that partner. Valid values are 'Y' and 'N'. partner service_perf_req_ind varchar2 1 Yes Indicates if the partner's services (such as shelf stocking) must be confirmed as "performed" before paying an invoice from that partner. Valid values are Y and N.
invc_pay_loc varchar26 0 1 Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are 'S' (paid at the store) and 'C' (paid centrally). partner invc_pay_loc varchar2 6 No Indicates where invoices from this supplier are paid, at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally).
invc_receive_loc varchar26 0 1 Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are 'S' (received at the store) and 'C' (received centrally). partner invc_receive_loc varchar2 6 No Indicates where invoices from this supplier are received, at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally).
import_country_id varchar23 0 1 Import country of the Import Authority. This field is not populated for other partner types. partner import_country_id varchar2 3 No Import country of the Import Authority. This field is not populated for other partner types.
primary_ia_ind varchar21 1 1 Indicates if an Import Authority is the primary Import Authority for an import country. This field will always be 'N' for other partner types. There must be one and only one primary Import Authority for each country associated with an Import Authority on the partner table. partner primary_ia_ind varchar2 1 Yes Indicates if the import authority is the primary import authority for an import country. This field always is N for other partner types. There must be one and only one primary import authority for each country associated with an import authority in the partner table.
PartnerOUDesc:PartnerOUDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
AddrDesc:AddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA
comment_desc varchar22000 0 1 Contains any comments associated with the Partner. partner comment_desc varchar2 2000 No Contains any comments associated with the Partner.
tsf_entity_id number10 0 1 This field contains the id of the transfer entity with which an external finisher (partner_type = E) is associated. partner tsf_entity_id number 10,0 No ID of the transfer entity with which an external finisher (partner_type = E) is associated. Valid values are found on the TSF_ENTITY table. A transfer entity is a group of locations that share legal requirements around product management. If SYSTEM_OPTIONS.INTERCOMPANY_TRANSFER_IND = Y, then each external finisher will be required to have an associated TSF_ENTITY_ID. If SYSTEM_OPTIONS.INTERCOMPANY_TRANSFER_IND = N, then transfer entity functionality is not used and PARTNER.TSF_ENTITY_ID will not be required.
vat_region number4 0 1 This field contains the id of the transfer entity with which an external finisher (partner_type = E) is associated. partner vat_region number 4,0 No VAT (value added tax) region with which a partner is associated. Valid values will be found on the VAT_REGION table. If SYSTEM_OPTIONS.DEFAULT_TAX_TYPE is SVAT, then each partner will be required to have an associated VAT_REGION. For other default_tax_type, then VAT functionality is not used and PARTNER.VAT_REGION will not be required.
org_unit_id number15 0 1 This field contains the org unit id with which partner is associated. partner org_unit_id number 15,0 No Org Unit Id
partner_name_secondary varchar2240 0 1 This field holds the secondary name of the partner. partner partner_name_secondary varchar2 240 No This will hold the secondary name of the partner.
auto_rcv_stock_ind varchar21 0 1 This field indicates whether the system will update the stock for the external finisher when the 1st leg of the transfer is shipped. Valid values are Yes or No. partner auto_rcv_stock_ind varchar2 1 Yes This will indicate whether the system will update the stock for the external finisher when the 1st leg of the transfer is shipped. Valid values are Yes or No

XML-Schema Name:PartnerOUDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PartnerOUDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
org_unit_id number15 0 1 This field holds the Org Unit id of the Partner. Fill application table name. n/a RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:AddrDesc Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for AddrDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
city_id varchar210 0 1 Indicates the City Id or Code. N/A N/A varchar2 10 No Indicates the City Id or Code.
state_name varchar2120 0 1 Indicates the State name. state description varchar2 120 Yes Contains the full name of the state.
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States country country_desc varchar2 120 Yes Contains the name of the country.
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. addr addr_key number 11,0 Yes This column contains a unique number used to distinguish between different addresses.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.
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. addr addr_type varchar2 2 Yes This column indicates the type for the address.
primary_addr_type_ind varchar21 0 1 Description is not available. * * varchar2 1 No Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether this address is the primary address for this address type addr primary_addr_ind varchar2 1 Yes This column indicates whether the address is the primary address for the address type.
add_1 varchar2240 1 1 Contains the first line of the address addr add_1 varchar2 240 Yes This column contains the first line of the address.
add_2 varchar2240 0 1 Contains the second line of the address. addr add_2 varchar2 240 No This column contains the second line of the address.
add_3 varchar2240 0 1 Contains the thirdline of the address. addr add_3 varchar2 240 No This column contains the third line of the address.
city varchar2120 1 1 Contains the name of the city that is associated with the address. addr city varchar2 120 Yes This column contains the name of the city that is associated with the address.
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state varchar2 3 No This column contains the state abbreviation for the address.
country_id varchar23 1 1 Contains the country where the address exists. addr country_id varchar2 3 Yes This column contains the country where the address exists.
post varchar230 0 1 Contains the zip code for the address. addr post varchar2 30 No This column contains the zip code for the address.
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. addr contact_name varchar2 120 No This column contains the name of the contact for the supplier at this address.
contact_phone varchar220 0 1 Contains the phone number of the contact person at this address. addr contact_phone varchar2 20 No This column contains the phone number of the contact person at this address.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex varchar2 20 No This column contains the telex number of the partner or suppliers representative contact.contact.
contact_fax varchar220 0 1 Contains the fax number of the contact person at this address. addr contact_fax varchar2 20 No This column contains the fax number of the contact person at this address.
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. addr contact_email varchar2 100 No This column contains the email address of the partner or suppliers representative contact.
oracle_vendor_site_id number15 0 1 The unique identifier of this address in the Oracle Financials systems, if used. addr oracle_vendor_site_id number 15,0 No This column will only be used for the Oracle Financial Interfaces. It holds the value of the Oracle vendor site ID for a supplier address. This Oracle vendor site ID is the unique identifier of the address on the Oracle side, it must be stored on the RMS addr table to allow updates from Oracle. This site ID can be found on the Oracle po_vendor_sites table.
county varchar2250 0 1 Contains the county name for the location. addr county varchar2 250 No This column holds the county name for the location.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. addr jurisdiction_code varchar2 10 No Identifies the jurisdiction code for the country-state relationship.
CustFlexAttriVo:CustFlexAttriVo * 0 unbounded References a collection of customer flexible attributes. NA NA NA NA NA NA

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:CustFlexAttriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CustFlexAttriVo in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and BDI) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
name varchar230 1 1 Holds the attribute name. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value varchar2250 0 1 Holds the numeric or string value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
value_date xs:dateTime 0 1 Holds the date value of the attribute. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.