Oracle Customer Hub (UCM) Master Data Management Reference > ASIs and Messages for Oracle Master Data Management Applications > Messages for Oracle Master Data Management Applications >
Account Relationship
Account relationship messages are used in insert, query, update, and delete operations to maintain Account Relationships. LookUpAccountRelationship and LookUpAccountRelationshipByName are used for query operations. UpdateAccountRelationship, InsertAccountRelationship, and DeleteAccountRelationship are message pairs for request and response operations. Figure 22 describes the structure of this message.
Figure 22. Structure of the Account Relationship Message
|
Table 379 lists the Account Relationship Query Integration objects.
Table 379. Account Relationship Query Integration Objects
|
|
|
|
CIFAccountRelationship |
Account |
LookUpAccountRelationship |
UK1:PartyUIdUK2: Id |
CIFAccountRelationshipRs |
Account |
LookUpAccountRelationshipResponse |
UK1:PartyUIdUK2: Id |
Table 380 lists the Account Relationship Query by Name Integration objects.
Table 380. Account Relationship Query by Name Integration Objects
|
|
|
|
CIFAccountRelationshipByName |
Account |
LookUpAccountRelationshipByName |
UK1:PartyUIdUK2: Id |
CIFAccountRelationshipByNameRs |
Account |
LookUpAccountRelationshipByNameResponse |
UK1:PartyUIdUK2: Id |
Table 381 lists the Account Relationship Update Integration objects.
Table 381. Account Relationship Update Integration Objects
|
|
|
|
CIFAccountRelationshipUpdate |
Account |
UpdateAccountRelationship |
UK1:PartyUIdUK2: Id |
CIFAccountRelationshipUpdateRs |
Account |
UpdateAccountRelationshipResponse |
UK1:PartyUIdUK2: Id |
Table 382 lists the Account Relationship Insert Integration objects.
Table 382. Account Relationship Insert Integration Objects
|
|
|
|
CIFAccountRelationshipInsert |
Account |
InsertAccountRelationship |
UK1:PartyUIdUK2: Id |
CIFAccountRelationshipInsertRs |
Account |
InsertAccountRelationshipResponse |
UK1:PartyUIdUK2: Id |
Table 383 lists the Account Relationship Delete Integration objects.
Table 383. Account Relationship Delete Integration Objects
|
|
|
|
CIFAccountRelationshipDelete |
Account |
DeleteAccountRelationship |
UK1:PartyUIdUK2: Id |
CIFAccountRelationshipDeleteRs |
Account |
DeleteAccountRelationshipResponse |
UK1:PartyUIdUK2: Id |
Table 384 lists the Account Relationship Integration Component and Integration Component Fields.
Table 384. Account Relationship Integration Component and Integration Component Fields
|
|
|
|
|
|
IC: Account |
Account Region |
AccountRegion |
Text |
30 |
No |
Use for picking a related entity |
Account Status |
AccountStatus |
Text |
24 |
No |
Bound by ACCOUNT_STATUS |
Account Type Code |
AccountTypeCode |
Text |
30 |
Yes |
Bound by CUT_ACCOUNT_TYPE |
Account Value |
AccountValue |
Text |
30 |
No |
Bound by FIN_CON_VALUE_TYPE |
Alias |
Alias |
Text |
50 |
No |
None |
Annual Revenue |
AnnualRevenue |
Text |
22 |
No |
None |
Client Flag |
ClientFlag |
Boolean |
1 |
No |
None |
Competitor |
Competitor |
Boolean |
1 |
No |
None |
Credit Agency Number |
CreditAgencyNumber |
Text |
30 |
No |
None |
Cumulative Sales |
CumulativeSales |
Number |
22 |
No |
None |
Currency Code |
CurrencyCode |
Text |
15 |
Yes |
None |
Current Volume |
CurrentVolume |
Currency |
22 |
No |
None |
Dont Call |
DontCall |
Boolean |
1 |
No |
None |
Drug Spent Currency Code |
DrugSpentCurrencyCode |
Text |
30 |
Yes |
Use for picking a related entity |
Employees |
Employees |
Number |
22 |
No |
None |
Facility Flag |
FacilityFlag |
Boolean |
1 |
No |
None |
Federal Tax Number |
FederalTaxNumber |
Text |
15 |
No |
None |
Financing Method |
FinancingMethod |
Text |
30 |
No |
Bound by FINCORP_CLIENT_FINANCING |
Gross Potential Value |
GrossPotentialValue |
Currency |
22 |
No |
None |
Group Type Code |
GroupTypeCode |
Text |
30 |
Yes |
Bound by GROUP_TYPE_CD |
Home Page |
HomePage |
Text |
100 |
No |
None |
Id |
Id |
Id |
15 |
No |
For cross-referencing |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
Internal Org Flag |
InternalOrgFlag |
Boolean |
1 |
Yes |
None |
Investor Flag |
InvestorFlag |
Boolean |
1 |
No |
None |
Last Year Sales |
LastYearSales |
Currency |
22 |
No |
None |
Legal Status |
LegalStatus |
Text |
30 |
No |
Bound by UT_LEGAL_STATUS |
Location |
Location |
Text |
50 |
No |
None |
Main Fax Number |
MainFaxNumber |
Phone |
40 |
No |
None |
Main Phone Number |
MainPhoneNumber |
Phone |
40 |
No |
None |
Master Account Id |
MasterAccountId |
Id |
15 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
None |
operation |
operation |
Text |
30 |
No |
None |
Partner Flag |
PartnerFlag |
Boolean |
1 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
Yes |
None |
Privacy Code |
PrivacyCode |
Text |
30 |
Yes |
Bound by PRIVACY_CODE |
Reference Flag |
ReferenceFlag |
Boolean |
1 |
No |
None |
Referenciable |
Referenciable |
Boolean |
1 |
No |
None |
Revenue Growth |
RevenueGrowth |
Number |
22 |
No |
None |
Service Provider Flag |
ServiceProviderFlag |
Text |
1 |
No |
None |
Status |
Status |
Text |
30 |
No |
Bound by FINS_COMPETITOR_STATUS_MLOV |
Total # Meters |
TotalMeters |
Number |
22 |
No |
None |
Total Potential Volume |
TotalPotentialVolume |
Currency |
22 |
No |
None |
Type |
Type |
Text |
30 |
No |
Bound by ACCOUNT_TYPE |
Unionized |
Unionized |
Boolean |
1 |
No |
None |
YTD Net Contribution |
YTDNetContribution |
Currency |
22 |
No |
None |
IC: Contact |
Account Id |
AccountId |
Id |
30 |
No |
None |
Account Integration Id |
AccountIntegrationId |
Text |
30 |
No |
None |
Assistant |
Assistant |
Text |
50 |
No |
None |
Assistant Phone # |
AssistantPhone |
Phone |
40 |
No |
None |
Cellular Phone # |
CellularPhone |
Phone |
40 |
No |
None |
Fax Phone # |
FaxPhone |
Phone |
40 |
No |
None |
First Name |
FirstName |
Text |
50 |
Yes |
None |
Home Phone # |
HomePhone |
Text |
40 |
No |
None |
Job Title |
JobTitle |
Text |
75 |
No |
None |
Last Name |
LastName |
Text |
50 |
Yes |
None |
M/M |
MM |
Text |
15 |
No |
None |
Middle Name |
MiddleName |
Text |
50 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Party UId |
PartyUId |
Text |
100 |
Yes |
None |
Person UId |
PersonUId |
Id |
30 |
No |
None |
Preferred Communication Method |
PreferredCommunicationMethod |
Text |
20 |
No |
Bound by COMM_METHOD |
Privacy Code |
PrivacyCode |
Text |
30 |
Yes |
Bound by PRIVACY_CODE |
Row Id |
RowId |
Id |
100 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Work Phone # |
WorkPhone |
Phone |
45 |
No |
None |
IC: Contact_Personal Address |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Personal Address Id |
PersonalAddressId |
Id |
100 |
Yes |
None |
Personal Address Integration Id |
PersonalAddressIntegrationId |
Text |
30 |
No |
None |
Personal City |
PersonalCity |
Text |
50 |
Yes |
None |
Personal Country |
PersonalCountry |
Text |
50 |
No |
Bound by COUNTRY |
Personal Postal Code |
PersonalPostalCode |
Text |
30 |
No |
None |
Personal State |
PersonalState |
Text |
10 |
No |
Bound by STATE_ABBREV |
Personal Street Address |
PersonalStreetAddress |
Text |
200 |
Yes |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
IC: Related Industry |
Industry |
Industry |
Text |
50 |
Yes |
None |
Industry Id |
IndustryId |
Id |
30 |
Yes |
None |
Industry Integration Id |
IndustryIntegrationId |
Text |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
SIC Code |
SICCode |
Text |
30 |
Yes |
None |
IC: Related Organization |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Organization |
Organization |
Text |
100 |
Yes |
None |
Organization Id |
OrganizationId |
Id |
100 |
Yes |
None |
Organization Integration Id |
OrganizationIntegrationId |
Text |
30 |
No |
None |
IC: Related Sales Reps |
Division |
Division |
Text |
255 |
Yes |
Use to select a related entity |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
Login |
Login |
Id |
15 |
No |
None |
Position |
Position |
Text |
50 |
No |
None |
Position Id |
PositionId |
Id |
30 |
No |
None |
Position Integration Id |
PositionIntegrationId |
Text |
30 |
No |
None |
IC: Sub Account |
Account Status |
AccountStatus2 |
Text |
30 |
No |
Bound by ACCOUNT_STATUS |
Id |
Id |
Id |
100 |
Yes |
None |
Location |
Location |
Text |
50 |
No |
None |
Main Phone Number |
MainPhoneNumber |
Phone |
40 |
No |
None |
Name |
Name |
Text |
100 |
Yes |
None |
operation |
operation |
Text |
30 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Party UId |
PartyUId |
Text |
30 |
Yes |
None |
Party UId |
PartyUId |
Text |
30 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Type |
Type |
Text |
255 |
Yes |
Bound by ACCOUNT_TYPE |
Type |
Type |
Text |
255 |
No |
None |
IC: Sub Account_Business Address |
Address Id |
AddressId |
Id |
30 |
Yes |
None |
Address Name |
AddressName |
Text |
100 |
No |
None |
Integration Id |
IntegrationId |
Text |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
Street Address |
StreetAddress |
Text |
200 |
Yes |
None |
IC: Sub Account_Position |
Division |
Division |
Text |
255 |
Yes |
Use it to select a related entity |
Division Integration Id |
DivisionIntegrationId |
Text |
30 |
No |
None |
IsPrimaryMVG |
IsPrimaryMVG |
Text |
1 |
No |
None |
operation |
operation |
Text |
30 |
No |
None |
Position |
Position |
Text |
50 |
No |
Bound by POSITION_TYPE |
Position Id |
PositionId |
Id |
30 |
No |
None |
searchspec |
searchspec |
Text |
250 |
No |
None |
|