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 29 describes the structure of these messages.
Figure 29. UCM Cross Reference Structure
|
Table 114. Account Cross Reference Integration Objects
|
|
|
|
UCMAccountExternalID |
Contact |
LookUpAccountExternalID |
UK1:PartyUIdUK2: Id |
UCMAccountExternalIDRs |
Contact |
LookUpAccountExternalIDResponse |
UK1:PartyUIdUK2: Id |
Table 115. Contact Cross Reference Integration Objects
|
|
|
|
UCMContactExternalID |
Contact |
LookUpContactExternalID |
UK1:PartyUIdUK2: Id |
UCMContactExternalIDRs |
Contact |
LookUpContactExternalIDResponse |
UK1:PartyUIdUK2: Id |
Table 116. Household Cross Reference Integration Objects
|
|
|
|
UCMHouseholdExternalID |
Household |
LookUpHouseholdExternalID |
UK1:IdUK2:IntegrationIdUK3:PartyUId |
UCMHouseholdExternalIDRs |
Household |
LookUpHouseholdExternalIDResponse |
UK1:IdUK2:IntegrationIdUK3:PartyUId |
Table 117. Account Cross Reference Integration Component Fields
|
|
|
|
|
|
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 |
|
|
Partner Flag |
PartnerFlag |
DTYPE_TEXT |
|
|
|
Party UId |
PartyUId |
DTYPE_TEXT |
100 |
|
|
Service Provider Flag |
ServiceProviderFlag |
DTYPE_TEXT |
|
|
|
Status |
Status |
DTYPE_TEXT |
30 |
|
|
Type |
Type |
DTYPE_TEXT |
30 |
|
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
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 |
|
|
System Name |
SystemName |
DTYPE_TEXT |
100 |
|
|
System Number |
SystemNumber |
DTYPE_TEXT |
30 |
|
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
Table 118. Contact Cross Reference Integration Component Fields
|
|
|
|
|
|
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 |
|
|
Party UId |
PartyUId |
DTYPE_TEXT |
100 |
|
|
Person UId |
PersonUId |
DTYPE_TEXT |
100 |
|
|
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 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
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 |
|
|
System Name |
SystemName |
DTYPE_TEXT |
100 |
|
|
System Number |
SystemNumber |
DTYPE_TEXT |
30 |
|
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
Table 119. Household Cross Reference Integration Component Fields
|
|
|
|
|
|
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 |
|
|
Party UId |
PartyUId |
DTYPE_TEXT |
100 |
|
|
Phone Number |
PhoneNumber |
DTYPE_TEXT |
|
|
|
Status |
Status |
DTYPE_TEXT |
30 |
|
|
Type |
Type |
DTYPE_TEXT |
30 |
|
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
CIF Household Reference |
CIF System Id |
CIFSystemId |
DTYPE_ID |
|
4 |
|
Comment |
Comment |
DTYPE_TEXT |
250 |
|
|
Conflict Id |
ConflictId |
DTYPE_ID |
30 |
|
|
Household 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 |
|
|
System Name |
SystemName |
DTYPE_TEXT |
100 |
|
|
System Number |
SystemNumber |
DTYPE_TEXT |
30 |
|
|
Updated |
Updated |
DTYPE_DATETIME |
30 |
|
|
operation |
operation |
DTYPE_TEXT |
30 |
|
|
searchspec |
searchspec |
DTYPE_TEXT |
250 |
|
|
|