Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:PartnerDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PartnerDesc
Table Name Column Name API Type Column Length API Required API Description
partner_type varchar26 1 1 Specifies the type of the partner. partner partner_type null null Yes Specifies the type of the partner.
partner_id varchar210 1 1 Unique identifying number for a partner within the system. partner partner_id null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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 null null 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
ExtOfPartnerDesc:ExtOfPartnerDesc * 0 1 Provide an extension hook to customize PartnerDesc. NA NA NA NA NA NA
LocOfPartnerDesc:LocOfPartnerDesc * 0 1 Provide an extension hook to localize PartnerDesc. NA NA NA NA NA NA

XML-Schema Name:PartnerOUDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PartnerOUDesc
Table Name Column Name API Type Column Length API Required API Description
org_unit_id number15 0 1 This field holds the Org Unit id of the Partner. NA NA NA NA NA NA
ExtOfPartnerOUDesc:ExtOfPartnerOUDesc * 0 1 Provide an extension hook to customize PartnerOUDesc. NA NA NA NA NA NA
LocOfPartnerOUDesc:LocOfPartnerOUDesc * 0 1 Provide an extension hook to localize PartnerOUDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfPartnerOUDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPartnerOUDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPartnerOUDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPartnerOUDesc
Table Name Column Name API Type Column Length API Required API Description
InPartnerOUDesc:InPartnerOUDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPartnerOUDesc:BrPartnerOUDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:AddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For AddrDesc
Table Name Column Name API Type Column Length API Required API Description
city_id varchar210 0 1 Indicates the City Id or Code. NA NA NA NA NA NA
state_name varchar2120 0 1 Indicates the State name. NA NA NA NA NA NA
country_name varchar2120 0 1 Indicates the Country Name. For e.g Brazil,United States NA NA NA NA NA NA
addr number11 1 1 Description is not available. addr addr_key null null Yes Address unique identifier.
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 Indicates the type for the address. Valid values are: 01-business, 02-postal, 03-returns, 04-order, 05-invoice, 06-external finisher
primary_addr_type_ind varchar21 1 1 Description is not available. addr primary_addr_type_ind varchar2 1 Yes The primary address of a particular address type
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 Indicates whether the address is the primary address for the address type
add_1 varchar2240 1 1 Description is not available. addr add_1 varchar2 240 Yes Contains the first line of the address
add_2 varchar2240 0 1 Description is not available. addr add_2 varchar2 240 No Contains the second line of the address
add_3 varchar2240 0 1 Description is not available. addr add_3 varchar2 240 No Contains the third line of the address
city varchar2120 1 1 Description is not available. addr city varchar2 120 Yes Contains the city address
state varchar23 0 1 Contains the postal abbreviation for the state in which the warehouse is located. addr state null null Yes Contains the postal abbreviation for the state of the address.
country_id varchar23 1 1 Description is not available. addr country_id null null Yes Contains the country code of the country for the address.
post varchar230 0 1 Description is not available. addr post varchar2 30 Yes Contains the zip code for the address
contact_name varchar2120 0 1 Description is not available. addr contact_name null null No Contains the name of the contact for the partner at this address
contact_phone varchar220 0 1 Description is not available. addr contact_phone null null No Contains the phone number of the contact for the partner at this address.
contact_telex varchar220 0 1 Contains the telex number of the partner or suppliers representative contact. addr contact_telex null null No Contains the telex number of the partner or suppliers representative contact.
contact_fax varchar220 0 1 Description is not available. addr contact_fax null null No Contains the fax number of the contact for the partner at this address.
contact_email varchar2100 0 1 Contains the email address of the partner or suppliers representative contact. addr contact_email null null No 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 No The unique identifier of the address on the oracle side
county varchar220 0 1 Description is not available. addr county null null No Holds the county of the location
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. NA NA NA NA NA NA
ExtOfAddrDesc:ExtOfAddrDesc * 0 1 Provide an extension hook to customize AddrDesc. NA NA NA NA NA NA
LocOfAddrDesc:LocOfAddrDesc * 0 1 Provide an extension hook to localize AddrDesc. NA NA NA NA NA NA

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

XML-Schema Name:LocOfAddrDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfAddrDesc
Table Name Column Name API Type Column Length API Required API Description
InAddrDesc:InAddrDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrAddrDesc:BrAddrDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPartnerDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPartnerDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPartnerDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPartnerDesc
Table Name Column Name API Type Column Length API Required API Description
InPartnerDesc:InPartnerDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPartnerDesc:BrPartnerDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA