B Attribute Mapping Information
This appendix describes the mapped attributes of customer, product, quote, and order records that are synchronized between Oracle CRM On Demand and Oracle E-Business Suite (Oracle EBS).
This chapter includes the following sections:
B.1 Customer Data Mappings
Table B-1 lists the mapped attributes of customer records that are synchronized between Oracle EBS and Oracle CRM On Demand.
Note:
The full name of each of the Enterprise Business Objects (EBOs) listed in the EBO column of the following table includes the prefix CreateCustomerPartyEBM/DataArea/CreateCustomerPary. This is not listed in the table.
Table B-1 Mapped attributes of Customer Records
| EBO | CRM On Demand | CRM On Demand | Oracle EBS | |
|---|---|---|---|---|
|
/ |
Account |
Contact |
Organization |
Org-Contact |
|
PartyLocation/LocationReference/Address/LineOne |
Address |
/ |
Address 1 |
/ |
|
PartyLocation/LocationReference/Address/LineTwo |
StreetAddress2 |
/ |
Address 2 |
/ |
|
PartyLocation/LocationReference/Address/LineThree |
StreetAddress3 |
/ |
Address 3 |
|
|
PartyLocation/LocationReference/Address/CityName |
City |
/ |
City |
|
|
PartyLocation/LocationReference/Address/StateName |
StateProvince |
/ |
State |
/ |
|
PartyLocation/LocationReference/Address/ProvinceName |
Province |
/ |
Province |
/ |
|
PartyLocation/LocationReference/Address/CountryCode |
Country |
/ |
Country |
/ |
|
PartyLocation/LocationReference/Address/PostalCode |
ZipCode |
/ |
Postal Code |
/ |
|
PartyLocation/LocationReference/Address/CountyName |
County |
/ |
County |
/ |
|
PartyContact/Contact/ContactPhoneCommunication/PhoneCommunication/CompleteNumber |
MainPhone |
/ |
Telephone |
/ |
|
PartyContact/Contact/ContactFaxCommunication/FaxCommunication/CompleteNumber |
MainFax |
/ |
Fax |
/ |
|
PartyContact/Contact/ContactWebsiteCommunication/WebsiteCommunication/WebsiteURI |
WebSite |
/ |
URL |
/ |
|
PartyContact/Contact/ContactPhoneCommunication/PhoneCommunication/CompleteNumber |
HomePhone |
Telephone (Purpose: Personal) |
||
|
PartyContact/Contact/ContactPhoneCommunication/PhoneCommunication/CompleteNumber |
WorkPhone |
Telephone (Purpose: Business) |
||
|
PartyContact/Contact/ContactPhoneCommunication/PhoneCommunication/CompleteNumber |
CellularPhone |
Mobile |
||
|
PartyContact/Contact/ContactFaxCommunication/FaxCommunication/CompleteNumber |
WorkFax |
Fax |
||
|
PartyContact/Contact/ContactEmailCommunication/EmailCommunication/URI |
ContactEmail |
|
||
|
PartyContact/Contact/JobTitle |
JobTitle |
JobTitle |
||
|
PartyContact/Contact/PersonName/FirstName |
ContactFirstName |
First Name |
||
|
PartyContact/Contact/PersonName/MiddleName |
Middle Name |
MiddleName |
||
|
PartyContact/Contact/PersonName/FamilyName |
ContactLastName |
Last Name |
||
|
PartyContact/Contact/PersonName/Salutation |
MrMrs |
Prefix |
||
|
Organization/Name |
AccountName |
Organization |
||
|
Organization/TotalEmployeeCount |
NumberOf Employees |
Organization Total |
||
|
Organization/PreferredFunctionalCurrencyCode |
CurrencyCode |
Currency Preference |
||
|
Organization/OrganizationFinancialStatement/OrganizationFinancialNumber/Amount |
AnnualRevenues |
Annual Revenue |
||
|
CustomerPartyAccount/Status/Code |
Status |
Account Status |
||
|
CustomerPartyAccount/CustomerPartyAccountSite/CustomerPartyAccountSiteUsage/Usage/UsageCode |
Address Description |
Purpose Account Site Level |
||
Figure B-1 illustrates the account mapping between Oracle E-Business Suite and CRM On Demand:
B.2 Product Data Mappings
Table B-2 lists the mapped attributes of product records that are synchronized between Oracle EBS and Oracle CRM On Demand.
Table B-2 Mapped Attributes of Product Records
| EBO | CRM On Demand | Oracle EBS |
|---|---|---|
|
ItemEBO/Name |
Name |
ProductDefinition/ProductName |
|
ItemEBO/Description |
Description |
ProductDefinition/Description |
|
ItemEBO/TypeCode |
Type |
ItemType |
|
ItemEBO/Status/Code |
Status |
InventoryItemStatusCode |
|
ItemEBO/ItemOrderManagementCharacteristics/ SaleableIndicator |
Orderable |
CustomerOrderFlag |
|
ItemEBO/ItemOrderManagementCharacteristics/ OrderableIndicator |
Orderable |
CustomerOrderEnabledFlag |
B.3 Quote Data Mappings
Table B-3 describes the mapped attributes of quote records that are synchronized between EBS and Oracle CRM On Demand.
Table B-3 Mapped Attributes of Quote Records
| EBO | CRM On Demand | Oracle EBS (OM Quote) | Oracle EBS (CRM Quote) |
|---|---|---|---|
|
SalesQuoteEBO/Identification/ BusinessComponentID |
QuoteId |
||
|
SalesQuoteEBO/Identification/ ApplicationObjectKey/ID |
QuoteId |
P_HEADER_REC/ ORIG_SYS_DOCUMENT_REF P_LINE_TBL/P_LINE_TBL_ITEM/ ORIG_SYS_DOCUMENT_REF |
P_QTE_HEADER_REC/ ORIGINAL_SYSTEM_ REFERENCE |
|
SalesQuoteEBO/Identification/ID |
QuoteId |
||
|
SalesQuoteEBO/Identification/ Revision/Number |
|||
|
SalesQuoteEBO/ BusinessUnitReference/ BusinessUnitIdentification/ BusinessComponentID |
P_HEADER_REC/ORG_ID |
P_QTE_HEADER_REC/ ORG_ID |
|
|
SalesQuoteEBO/Name |
Opportunity Name |
P_HEADER_REC/ SALES_DOCUMENT_NAME |
P_QTE_HEADER_REC/ QUOTE_NAME |
|
SalesQuoteEBO/CurrencyCode |
CurrencyCode |
P_HEADER_REC/ TRANSACTIONAL_CURR_CODE |
P_QTE_HEADER_REC/ CURRENCY_CODE |
|
SalesQuoteEBO/ SalesOpportunityReference/ SalesOpportunityIdentification/ ApplicationObjectKey/ID |
OpportunityId |
P_HEADER_REC/ ORIG_SYS_DOCUMENT_REF |
P_QTE_HEADER_REC/ ORIGINAL_SYSTEM_ REFERENCE |
|
SalesQuoteEBO/ CustomerPartyReference/ PartyIdentification/ BusinessComponentID |
AccountId |
P_QTE_HEADER_REC/ PARTY_ID P_QTE_HEADER_REC/ CUST_PARTY_ID |
|
|
SalesQuoteEBO/ CustomerPartyReference/ CustomerPartyAccountIdentification/BusinessComponentID |
AccountId |
P_HEADER_REC/ SOLD_TO_ORG_ID |
P_QTE_HEADER_REC/ CUST_ACCOUNT_ID |
|
SalesQuoteEBO/ CustomerPartyReference/ Contact/Identification/ BusinessComponentID |
ContactId |
||
|
SalesQuoteEBO/ CustomerPartyReference/Contact/ Identification/AlternateObjectKey/ ID[@schemeID='CUSTOMERPARTY_PARTYCONTACTID_GUID'] |
ContactId |
P_HEADER_REC/ SOLD_TO_ORG_CONTACT_ID |
P_QTE_HEADER_REC/ ORG_CONTACT_ID |
|
SalesQuoteEBO/ BillToPartyReference/ PartyIdentification/ BusinessComponentID |
AccountId |
P_HEADER_REC/ INVOICE_TO_PARTY_ID |
P_QTE_HEADER_REC/ INVOICE_TO_PARTY _ID |
|
SalesQuoteEBO/ BillToPartyReference/ CustomerPartyAccountIdentification/BusinessComponentID |
AccountId |
P_HEADER_REC/ INVOICE_TO_CUSTOMER_ID |
P_QTE_HEADER_REC/ INVOICE_TO_CUST_ ACCOUNT_ID |
|
SalesQuoteEBO/ BillToPartyReference/ LocationReference/ LocationIdentification/ BusinessComponentID |
PrimaryBillTo AddressId |
||
|
SalesQuoteEBO/ BillToPartyReference/ LocationReference/ LocationIdentification/ AlternateObjectKey/ ID[@schemeID= 'CUSTOMERPARTY_ PARTYLOCATIONID_GUID'] |
PrimaryBillTo AddressId |
P_HEADER_REC/ INVOICE_TO_PARTY_SITE_ID |
P_QTE_HEADER_REC/ INVOICE_TO_PARTY_ SITE_ID |
|
SalesQuoteEBO/ShipToPartyReference/PartyIdentification/BusinessComponentID |
AccountId |
P_HEADER_REC/ SHIP_TO_PARTY_ID |
P_HD_SHIPMENT_ REC/SHIP_TO_PARTY _ID |
|
SalesQuoteEBO/ShipToPartyReference/CustomerPartyAccountIdentification/BusinessComponentID |
AccountId |
P_HEADER_REC/ SHIP_TO_CUSTOMER_ID |
P_HD_SHIPMENT_ REC/SHIP_TO_CUST_ ACCOUNT_ID |
|
SalesQuoteEBO/ShipToPartyReference/LocationReference/LocationIdentification/BusinessComponentID |
PrimaryShipTo AddressId |
||
|
SalesQuoteEBO/ ShipToPartyReference/ LocationReference/ LocationIdentification/ AlternateObjectKey/ ID[@schemeID= 'CUSTOMERPARTY_ PARTYLOCATIONID_GUID'] |
PrimaryShipTo AddressId |
P_HEADER_REC/ SHIP_TO_PARTY_SITE_ID |
P_HD_SHIPMENT_ REC/SHIP_TO_PARTY_SITE_ID |
|
SalesQuoteEBO/ SalesPersonPartyReference/ Contact/ ContactEmailCommunication/ EmailCommunication |
EMailAddr |
P_QTE_HEADER_REC/ RESOURCE_ID |
|
|
SalesQuoteEBO/SalesQuoteLine |
Product |
P_LINE_TBL/P_LINE_TBL _ITEM |
P_QTE_LINE_TBL/ P_QTE_LINE_REC |
|
SalesQuoteEBO/SalesQuoteLine/ Identification/BusinessComponentID |
ProductRevenueId |
||
|
SalesQuoteEBO/SalesQuoteLine/ Identification/ApplicationObjectKey/ ID |
ProductRevenueId |
P_LINE_TBL/P_LINE_TBL _ITEM/ORIG_SYS_LINE_REF |
|
|
SalesQuoteEBO/SalesQuoteLine/ Identificaton/ID |
ProductPart Number |
||
|
SalesQuoteEBO/SalesQuoteLine/ Quantity |
Quantity |
P_LINE_TBL/P_LINE_TBL_ ITEM/ORDERED_QUANTITY |
P_QTE_LINE_TBL/ P_QTE_LINE_REC/ QUANTITY |
|
SalesQuoteEBO/SalesQuoteLine/ Quantity/@unitCode |
P_LINE_TBL/P_LINE_TBL_ ITEM/ORDER_QUANTITY_ UOM |
P_QTE_LINE_TBL/ P_QTE_LINE_REC/ UOM_CODE |
|
|
SalesQuoteEBO/SalesQuoteLine/ |
ProductId |
P_LINE_TBL/P_LINE_TBL_ ITEM/INVENTORY_ITEM_ID |
P_QTE_LINE_TBL/ P_QTE_LINE_REC/ |
|
ItemReference/ItemIdentification/ BusinessComponentID |
INVENTORY_ITEM_ID |
B.4 Order Data Mappings
Table B-4 lists the mapped attributes of order records that are synchronized between EBS and Oracle CRM On Demand.
Table B-4 Mapped Attributes of Order Records
| EBO | CRM On Demand | Oracle EBS |
|---|---|---|
|
SalesOrderEBO/Identification/ID |
Id |
|
|
SalesOrderEBO/Identification/ ApplicationObjectKey/ID |
Id |
|
|
SalesOrderEBO/Identification/ BusinessComponentID |
Id |
P_HEADER_REC/ ORIG_SYS_DOCUMENT_REF P_LINE_TBL/P_LINE_TBL_ITEM/ ORIG_SYS_DOCUMENT_REF |
|
SalesOrderEBO/CurrencyCode |
CurrencyCode |
P_HEADER_REC/ TRANSACTIONAL_CURR_CODE |
|
SalesOrderEBO/OrderDateTime |
OrderCreationDate |
P_HEADER_REC/ORDERED _DATE |
|
SalesOrderEBO/TypeCode |
SALESORDER |
P_HEADER_VAL_REC/ORDER _TYPE P_HEADER_REC/ORDER_ SOURCE_ID P_HEADER_REC/ TRANSACTION_PHASE_CODE |
|
SalesOrderEBO/BillToPartyReference/ PartyIdentification/BusinessComponentID |
AccountId |
|
|
SalesOrderEBO/BillToPartyReference/ PartyIdentification/ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/BillToPartyReference/ CustomerPartyAccountIdentification/ BusinessComponentID |
AccountId |
|
|
SalesOrderEBO/BillToPartyReference/ CustomerPartyAccountIdentification/ ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/BillToPartyReference/ LocationReference/LocationIdentification/ BusinessComponentID |
PrimaryBillToAddressId |
|
|
SalesOrderEBO/BillToPartyReference/ LocationReference/LocationIdentification/ ApplicationObjectKey/ID |
PrimaryBillToAddressId |
|
|
SalesOrderEBO/BillToPartyReference/ LocationReference/Address/Identification/BusinessComponentID |
PrimaryBillToAddressId |
|
|
SalesOrderEBO/BillToPartyReference/ LocationReference/LocationIdentification/ AlternateObjectKey/ID |
PrimaryBillToAddressId |
|
|
SalesOrderEBO/CustomerPartyReference/ PartyIdentification/BusinessComponentID |
AccountId |
|
|
SalesOrderEBO/CustomerPartyReference/ PartyIdentification/ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/CustomerPartyReference/ CustomerPartyAccountIdentification/ BusinessComponentID |
AccountId |
P_HEADER_REC/SOLD_TO_ ORG_ID |
|
SalesOrderEBO/CustomerPartyReference/ CustomerPartyAccountIdentification/ ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/CustomerPartyReference/ Contact/Identification/BusinessComponentID |
KeyContactId |
|
|
SalesOrderEBO/CustomerPartyReference/ Contact/Identification/ApplicationObjectKey/ ID |
KeyContactId |
|
|
SalesOrderEBO/ShipToPartyReference/ PartyIdentification/BusinessComponentID |
AccountId |
|
|
SalesOrderEBO/ShipToPartyReference/ PartyIdentification/ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/ShipToPartyReference/ CustomerPartyAccountIdentification/ BusinessComponentID |
AccountId |
|
|
SalesOrderEBO/ShipToPartyReference/ CustomerPartyAccountIdentification/ ApplicationObjectKey/ID |
AccountId |
|
|
SalesOrderEBO/ShipToPartyReference/ LocationReference/LocationIdentification/ BusinessComponentID |
PrimaryShipToAddressId |
|
|
SalesOrderEBO/ShipToPartyReference/ LocationReference/LocationIdentification/ ApplicationObjectKey/ID |
PrimaryShipToAddressId |
|
|
SalesOrderEBO/ShipToPartyReference/ LocationReference/Address/Identification/ BusinessComponentID |
PrimaryShipToAddressId |
|
|
SalesOrderEBO/ShipToPartyReference/ LocationReference/Address/Identification/ ApplicationObjectKey/ID |
PrimaryShipToAddressId |
|
|
SalesOrderEBO/SourceDocumentReference/ DocumentIdentification/ContextId |
OpportunityId |
|
|
SalesOrderEBO/SalesOrderLine |
For each Opportunity revenue line |
P_LINE_TBL/P_LINE_TBL_ITEM P_LINE_VAL_TBL/P_LINE_ VAL_TBL_ITEM |
|
SalesOrderEBO/SalesOrderLine/Identification/ApplicationObjectKey/ID |
ProductRevenueId |
|
|
SalesOrderEBO/SalesOrderLine/Identification/BusinessComponentID |
ProductRevenueId |
P_LINE_TBL/P_LINE_TBL_ITEM/ ORIG_SYS_LINE_REF |
|
SalesOrderEBO/SalesOrderLine/ OrderQuantity |
Quantity |
P_LINE_TBL/P_LINE_TBL_ITEM/ ORDERED_QUANTITY |
|
SalesOrderEBO/SalesOrderLine/ ItemReference/ItemIdentification/ BusinessComponentID |
ProductId |
P_LINE_TBL/P_LINE_TBL_ITEM/ INVENTORY_ITEM_ID |
|
SalesOrderEBO/SalesOrderLine/ ItemReference/ItemIdentification/ ApplicationObjectKey/ID |
ProductId |
|
|
SalesOrderEBO/SalesOrderLine/ ItemReference/Name |
ProductName |
|
|
SalesOrderEBO/SalesOrderLine/Status/ Code |
OrderStatus |