Bookshelf v8.0: Cross Reference

Siebel Master Data Applications Reference for Industry Applications > Siebel Master Data Applications Messages > Siebel Master Data Application Messages >

Cross Reference

UCM Cross Reference messages are used in query and response operations for account, contact and household cross references. There is a pair of request and response messages for each object. Figure 27 describes the structure of these messages.

Figure 27. UCM Cross Reference Structure

Table 107 lists the Account Cross Reference Integration Objects.

Table 107. Account Cross Reference Integration Objects
Integration Object	Business Component	XML Tag	User Keys
UCMAccountExternalID	Contact	LookUpAccountExternalID	UK1:PartyUId UK2: Id
UCMAccountExternalIDRs	Contact	LookUpAccountExternalIDResponse	UK1:PartyUId UK2: Id

Table 108 lists the Contact Cross Reference Integration Objects.

Table 108. Contact Cross Reference Integration Objects
Integration Object	Business Component	XML Tag	User Keys
UCMContactExternalID	Contact	LookUpContactExternalID	UK1:PartyUId UK2: Id
UCMContactExternalIDRs	Contact	LookUpContactExternalIDResponse	UK1:PartyUId UK2: Id

Table 109 lists the Household Cross Reference Integration Objects.

Table 109. Household Cross Reference Integration Objects
Integration Object	Business Component	XML Age	User Keys
UCMHouseholdExternalID	Household	LookUpHouseholdExternalID	UK1:Id UK2:IntegrationId UK3:PartyUId
UCMHouseholdExternalIDRs	Household	LookUpHouseholdExternalIDResponse	UK1:Id UK2:IntegrationId UK3:PartyUId

Table 110 lists the Account Cross Reference Integration Component and Integration Component Fields.

Table 110. Account Cross Reference Integration Component and Integration Component Fields
Name	XML Tag	Data Type	Length	Required
IC: Account
Account Status	AccountStatus	DTYPE_TEXT	24
Account Type Code	AccountTypeCode	DTYPE_TEXT	30
Annual Revenue	AnnualRevenue	DTYPE_TEXT
Client Flag	ClientFlag	DTYPE_TEXT
Competitor	Competitor	DTYPE_TEXT
Conflict Id	ConflictId	DTYPE_ID	30
Created	Created	DTYPE_DATETIME	30
Credit Agency Number	CreditAgencyNumber	DTYPE_TEXT	30
Currency Code	CurrencyCode	DTYPE_TEXT	15
Facility Flag	FacilityFlag	DTYPE_TEXT
Federal Tax Number	FederalTaxNumber	DTYPE_TEXT	15
Home Page	HomePage	DTYPE_TEXT	100
Id	Id	DTYPE_ID	30
Integration Id	IntegrationId	DTYPE_TEXT	30
Internal Org Flag	InternalOrgFlag	DTYPE_TEXT
Investor Flag	InvestorFlag	DTYPE_TEXT
Legal Status	LegalStatus	DTYPE_TEXT	30
Location	Location	DTYPE_TEXT	50
Main Fax Number	MainFaxNumber	DTYPE_TEXT
Main Phone Number	MainPhoneNumber	DTYPE_TEXT
Master Account Id	MasterAccountId	DTYPE_ID
Mod Id	ModId	DTYPE_ID	30
Name	Name	DTYPE_TEXT	100
operation	operation	DTYPE_TEXT	30
Partner Flag	PartnerFlag	DTYPE_TEXT
Party UId	PartyUId	DTYPE_TEXT	100
searchspec	searchspec	DTYPE_TEXT	250
Service Provider Flag	ServiceProviderFlag	DTYPE_TEXT
Status	Status	DTYPE_TEXT	30
Type	Type	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30
IC: CIF Account Reference
Account Id	AccountId	DTYPE_ID		4
CIF System Id	CIFSystemId	DTYPE_ID		4
Comment	Comment	DTYPE_TEXT	250
Conflict Id	ConflictId	DTYPE_ID	30
Created	Created	DTYPE_DATETIME	30
External Id1	ExternalId1	DTYPE_TEXT	100
External Id2	ExternalId2	DTYPE_TEXT	100
External Id3	ExternalId3	DTYPE_TEXT	100
Id	Id	DTYPE_ID	30
Mod Id	ModId	DTYPE_ID	30
operation	operation	DTYPE_TEXT	30
searchspec	searchspec	DTYPE_TEXT	250
System Name	SystemName	DTYPE_TEXT	100
System Number	SystemNumber	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30

Table 111 lists the Contact Cross Reference Integration Component and Integration Component Fields.

Table 111. Contact Cross Reference Integration Component and Integration Component Fields
Name	XML Tag	Data Type	Length	Required
IC: Contact
Cellular Phone #	CellularPhone	DTYPE_TEXT
Conflict Id	ConflictId	DTYPE_ID	30
Created	Created	DTYPE_DATETIME	30
Date of Birth	DateofBirth	DTYPE_DATETIME
Email Address	EmailAddress	DTYPE_TEXT	50
Fax Phone #	FaxPhone	DTYPE_TEXT
First Name	FirstName	DTYPE_TEXT	50
Home Phone #	HomePhone	DTYPE_TEXT
Id	Id	DTYPE_ID	30
Integration Id	IntegrationId	DTYPE_TEXT	30
Job Title	JobTitle	DTYPE_TEXT	75
Last Name	LastName	DTYPE_TEXT	50
M/F	MF	DTYPE_TEXT	30
M/M	MM	DTYPE_TEXT	15
Marital Status	MaritalStatus	DTYPE_TEXT	30
Middle Name	MiddleName	DTYPE_TEXT	50
Mod Id	ModId	DTYPE_ID	30
Mother Maiden Name	MotherMaidenName	DTYPE_TEXT	50
operation	operation	DTYPE_TEXT	30
Party UId	PartyUId	DTYPE_TEXT	100
Person UId	PersonUId	DTYPE_TEXT	100
searchspec	searchspec	DTYPE_TEXT	250
Social Security Number	SocialSecurityNumber	DTYPE_TEXT
Status	Status	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30
Work Phone #	WorkPhone	DTYPE_TEXT
Work Phone Extension	WorkPhoneExtension	DTYPE_TEXT	10
IC: CIF Contact Reference
CIF System Id	CIFSystemId	DTYPE_ID		4
Comment	Comment	DTYPE_TEXT	250
Conflict Id	ConflictId	DTYPE_ID	30
Contact Id	ContactId	DTYPE_ID		4
Created	Created	DTYPE_DATETIME	30
External Id1	ExternalId1	DTYPE_TEXT	100
External Id2	ExternalId2	DTYPE_TEXT	100
External Id3	ExternalId3	DTYPE_TEXT	100
Id	Id	DTYPE_ID	30
Mod Id	ModId	DTYPE_ID	30
operation	operation	DTYPE_TEXT	30
searchspec	searchspec	DTYPE_TEXT	250
System Name	SystemName	DTYPE_TEXT	100
System Number	SystemNumber	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30

Table 112 lists the Household Cross Reference Integration Component and Integration Component Fields.

Table 112. Household Cross Reference Integration Component and Integration Component Fields
Name	XML Tag	Data Type	Length	Required
IC: Household
Category	Category	DTYPE_TEXT	30
Conflict Id	ConflictId	DTYPE_ID	30
Created	Created	DTYPE_DATETIME	30
Currency Code	CurrencyCode	DTYPE_TEXT	20
Fax Number	FaxNumber	DTYPE_TEXT
Household Name	HouseholdName	DTYPE_TEXT	50
Household Number	HouseholdNumber	DTYPE_TEXT	100
Id	Id	DTYPE_ID	30
Integration Id	IntegrationId	DTYPE_TEXT	30
Mod Id	ModId	DTYPE_ID	30
operation	operation	DTYPE_TEXT	30
Party UId	PartyUId	DTYPE_TEXT	100
Phone Number	PhoneNumber	DTYPE_TEXT
searchspec	searchspec	DTYPE_TEXT	250
Status	Status	DTYPE_TEXT	30
Type	Type	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30
IC: CIF Household Reference
CIF System Id	CIFSystemId	DTYPE_ID		4
Comment	Comment	DTYPE_TEXT	250
Conflict Id	ConflictId	DTYPE_ID	30
Created	Created	DTYPE_DATETIME	30
External Id1	ExternalId1	DTYPE_TEXT	100
External Id2	ExternalId2	DTYPE_TEXT	100
External Id3	ExternalId3	DTYPE_TEXT	100
Household Id	ContactId	DTYPE_ID		4
Id	Id	DTYPE_ID	30
Mod Id	ModId	DTYPE_ID	30
operation	operation	DTYPE_TEXT	30
searchspec	searchspec	DTYPE_TEXT	250
System Name	SystemName	DTYPE_TEXT	100
System Number	SystemNumber	DTYPE_TEXT	30
Updated	Updated	DTYPE_DATETIME	30

Siebel Master Data Applications Reference for Industry Applications		Copyright © 2007, Oracle. All rights reserved.