Oracle Customer Hub (UCM) Master Data Management Reference > ASIs and Messages for Oracle Master Data Management Applications > Messages for Oracle Master Data Management Applications >
Cross-Reference
Cross-reference messages are used in query and response operations for account, contact and household cross-references. Each object has a pair of request and response messages. Figure 24 describes the structure of these messages.
Figure 24. Cross Reference Structure
|
Table 419 lists the Account Cross-Reference Integration Objects.
Table 419. Account Cross-Reference Integration Objects
|
|
|
|
UCMAccountExternalID |
Contact |
LookUpAccountExternalID |
UK1:PartyUId UK2: Id |
UCMAccountExternalIDRs |
Contact |
LookUpAccountExternalIDResponse |
UK1:PartyUId UK2: Id |
Table 420 lists the Contact Cross-Reference Integration Objects.
Table 420. Contact Cross-Reference Integration Objects
|
|
|
|
UCMContactExternalID |
Contact |
LookUpContactExternalID |
UK1:PartyUId UK2: Id |
UCMContactExternalIDRs |
Contact |
LookUpContactExternalIDResponse |
UK1:PartyUId UK2: Id |
Table 421 lists the Household Cross-Reference Integration Objects.
Table 421. Household Cross-Reference Integration Objects
|
|
|
|
UCMHouseholdExternalID |
Household |
LookUpHouseholdExternalID |
UK1:Id UK2:IntegrationId UK3:PartyUId |
UCMHouseholdExternalIDRs |
Household |
LookUpHouseholdExternalIDResponse |
UK1:Id UK2:IntegrationId UK3:PartyUId |
Table 422 lists the Account Cross-Reference Integration Component and Integration Component Fields.
Table 422. Account Cross-Reference Integration Component and Integration Component Fields
|
|
|
|
|
IC: Account |
Account Status |
AccountStatus |
Text |
24 |
No |
Account Type Code |
AccountTypeCode |
Text |
30 |
No |
Annual Revenue |
AnnualRevenue |
Text |
Not applicable |
No |
Client Flag |
ClientFlag |
Text |
Not applicable |
No |
Competitor |
Competitor |
Text |
Not applicable |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
Credit Agency Number |
CreditAgencyNumber |
Text |
30 |
No |
Currency Code |
CurrencyCode |
Text |
15 |
No |
Facility Flag |
FacilityFlag |
Text |
Not applicable |
No |
Federal Tax Number |
FederalTaxNumber |
Text |
15 |
No |
Home Page |
HomePage |
Text |
100 |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Internal Org Flag |
InternalOrgFlag |
Text |
Not applicable |
No |
Investor Flag |
InvestorFlag |
Text |
Not applicable |
No |
Legal Status |
LegalStatus |
Text |
30 |
No |
Location |
Location |
Text |
50 |
No |
Main Fax Number |
MainFaxNumber |
Text |
Not applicable |
No |
Main Phone Number |
MainPhoneNumber |
Text |
Not applicable |
No |
Master Account Id |
MasterAccountId |
Id |
Not applicable |
No |
Mod Id |
ModId |
Id |
30 |
No |
Name |
Name |
Text |
100 |
No |
operation |
operation |
Text |
30 |
No |
Partner Flag |
PartnerFlag |
Text |
Not applicable |
No |
Party UId |
PartyUId |
Text |
100 |
No |
searchspec |
searchspec |
Text |
250 |
No |
Service Provider Flag |
ServiceProviderFlag |
Text |
Not applicable |
No |
Status |
Status |
Text |
30 |
No |
Type |
Type |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
IC: CIF Account Reference |
Account Id |
AccountId |
Id |
Not applicable |
Yes |
CIF System Id |
CIFSystemId |
Id |
Not applicable |
Yes |
Comment |
Comment |
Text |
250 |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
External Id1 |
ExternalId1 |
Text |
100 |
No |
External Id2 |
ExternalId2 |
Text |
100 |
No |
External Id3 |
ExternalId3 |
Text |
100 |
No |
Id |
Id |
Id |
30 |
No |
Mod Id |
ModId |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
System Name |
SystemName |
Text |
100 |
No |
System Number |
SystemNumber |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Table 423 lists the Contact Cross-Reference Integration Component and Integration Component Fields.
Table 423. Contact Cross-Reference Integration Component and Integration Component Fields
|
|
|
|
|
IC: Contact |
Cellular Phone # |
CellularPhone |
Text |
Not applicable |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
Date of Birth |
DateofBirth |
Date and time |
Not applicable |
No |
Email Address |
EmailAddress |
Text |
50 |
No |
Fax Phone # |
FaxPhone |
Text |
Not applicable |
No |
First Name |
FirstName |
Text |
50 |
No |
Home Phone # |
HomePhone |
Text |
Not applicable |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Job Title |
JobTitle |
Text |
75 |
No |
Last Name |
LastName |
Text |
50 |
No |
M/F |
MF |
Text |
30 |
No |
M/M |
MM |
Text |
15 |
No |
Marital Status |
MaritalStatus |
Text |
30 |
No |
Middle Name |
MiddleName |
Text |
50 |
No |
Mod Id |
ModId |
Id |
30 |
No |
Mother Maiden Name |
MotherMaidenName |
Text |
50 |
No |
operation |
operation |
Text |
30 |
No |
Party UId |
PartyUId |
Text |
100 |
No |
Person UId |
PersonUId |
Text |
100 |
No |
searchspec |
searchspec |
Text |
250 |
No |
Social Security Number |
SocialSecurityNumber |
Text |
Not applicable |
No |
Status |
Status |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Work Phone # |
WorkPhone |
Text |
Not applicable |
No |
Work Phone Extension |
WorkPhoneExtension |
Text |
10 |
No |
IC: CIF Contact Reference |
CIF System Id |
CIFSystemId |
Id |
Not applicable |
Yes |
Comment |
Comment |
Text |
250 |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Contact Id |
ContactId |
Id |
Not applicable |
Yes |
Created |
Created |
Date and time |
30 |
No |
External Id1 |
ExternalId1 |
Text |
100 |
No |
External Id2 |
ExternalId2 |
Text |
100 |
No |
External Id3 |
ExternalId3 |
Text |
100 |
No |
Id |
Id |
Id |
30 |
No |
Mod Id |
ModId |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
System Name |
SystemName |
Text |
100 |
No |
System Number |
SystemNumber |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
Table 424 lists the Household Cross-Reference Integration Component and Integration Component Fields.
Table 424. Household Cross-Reference Integration Component and Integration Component Fields
|
|
|
|
|
IC: Household |
Category |
Category |
Text |
30 |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
Currency Code |
CurrencyCode |
Text |
20 |
No |
Fax Number |
FaxNumber |
Text |
Not applicable |
No |
Household Name |
HouseholdName |
Text |
50 |
No |
Household Number |
HouseholdNumber |
Text |
100 |
No |
Id |
Id |
Id |
30 |
No |
Integration Id |
IntegrationId |
Text |
30 |
No |
Mod Id |
ModId |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
Party UId |
PartyUId |
Text |
100 |
No |
Phone Number |
PhoneNumber |
Text |
Not applicable |
No |
searchspec |
searchspec |
Text |
250 |
No |
Status |
Status |
Text |
30 |
No |
Type |
Type |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
IC: CIF Household Reference |
CIF System Id |
CIFSystemId |
Id |
Not applicable |
Yes |
Comment |
Comment |
Text |
250 |
No |
Conflict Id |
ConflictId |
Id |
30 |
No |
Created |
Created |
Date and time |
30 |
No |
External Id1 |
ExternalId1 |
Text |
100 |
No |
External Id2 |
ExternalId2 |
Text |
100 |
No |
External Id3 |
ExternalId3 |
Text |
100 |
No |
Household Id |
ContactId |
Id |
Not applicable |
Yes |
Id |
Id |
Id |
30 |
No |
Mod Id |
ModId |
Id |
30 |
No |
operation |
operation |
Text |
30 |
No |
searchspec |
searchspec |
Text |
250 |
No |
System Name |
SystemName |
Text |
100 |
No |
System Number |
SystemNumber |
Text |
30 |
No |
Updated |
Updated |
Date and time |
30 |
No |
|