Siebel Application Services Interface Reference > Predefined Application Service Interfaces > External Opportunity Create/External Opportunity Query/External Opportunity Update >

Opportunity (PRM ANI)


The Opportunity (PRM ANI) ASI encapsulates all the data that is directly related to the Opportunity object. This data includes fields such as Opportunity Name, Status, and so on.

Table 38 lists the primary integration components of Opportunity (PRM ANI).

Table 38. Opportunity (PRM ANI) Integration Components
Integration Component
XML Tag
User Keys

Action

Action

  1. Due, Id, Type
  2. Comment, Description, Due, Type
  3. Comment, Description, Due, Type

Contact

Contact

1 DUNS Number, First Name, ID, Last Name, Middle Name
  1. DUNS Number, First Name, Last Name, Middle Name
  2. First Name, Last Name, Middle Name, Primary Account Name
  3. First Name, Last Name, Middle Name, Primary Account Name
  4. First Name, Last Name

Contact_Account

Contact_Account

1 Account, Account Location

Contact_Account_Business Address

Contact_Account_BusinessAddress

1 City, Country, Postal Code, State, Street Address, Street Address 2
  1. Address Name, City, Postal Code, State, Street Address
  2. City, Postal Code, State
  3. Address Name

Contact_Personal Address

Contact_PersonalAddress

1 City, Country, Postal Code, State, Street Address, Street Address 2
  1. Address Name, City, Postal Code, State, Street Address
  2. City, Integration Id, Postal Code, State
  3. Integration Id

Opportunity

Opportunity

1 Name

Opportunity Note

OpportunityNote

1 Note, Note Type, Oppty Name
  1. Note Type, Oppty Name
  2. Note, Note Type
  3. Note Type
  4. Id

Opportunity_Business Address

OpportunityBusinessAddress

1 Address Name, City, Country, Postal Code, State, Street Address, Street Address 2
  1. City, Postal Code, State, Street Address
  2. City, Integration Id, Postal Code, State
  3. Integration Id

Revenue

Revenue

1 Revenue Item Number

Table 39 lists the fields and their attributes.

Table 39. Opportunity (PRM ANI) ASI Fields
Name
XML Tag
Data Type
Length
Req.

Action

Comment

Comment

DTYPE_TEXT

1,500

No

Description

Description

DTYPE_TEXT

100

No

Done

Done

DTYPE_TEXT

50

No

Due

Due

DTYPE_TEXT

50

No

Id

Id

DTYPE_ID

30

No

Planned

Planned

DTYPE_TEXT

50

No

Planned Completion

PlannedCompletion

DTYPE_TEXT

50

No

Priority

Priority

DTYPE_TEXT

30

No

Started

Started

DTYPE_TEXT

50

No

Status

Status

DTYPE_TEXT

30

No

Type

Type

DTYPE_TEXT

30

No

Contact

Account Id

AccountId

DTYPE_ID

15

No

Account Integration Id

AccountIntegrationId

DTYPE_TEXT

30

No

Cellular Phone #

CellularPhone

DTYPE_TEXT

40

No

Comment

Comment

DTYPE_TEXT

255

No

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

Email Address

EmailAddress

DTYPE_TEXT

50

No

Fax Phone #

FaxPhone

DTYPE_TEXT

40

No

First Name

FirstName

DTYPE_TEXT

50

No

Home Phone #

HomePhone

DTYPE_TEXT

40

No

Id

Id

DTYPE_ID

30

No

Job Title

JobTitle

DTYPE_TEXT

75

No

Last Name

LastName

DTYPE_TEXT

50

No

M/M

MM

DTYPE_TEXT

15

No

Middle Name

MiddleName

DTYPE_TEXT

50

No

Primary Account Name

PrimaryAccountName

DTYPE_TEXT

100

No

Work Phone #

WorkPhone

DTYPE_TEXT

40

No

Contact_Account

Account

Name

DTYPE_TEXT

100

No

Account Location

Location

DTYPE_TEXT

50

No

Currency Code

CurrencyCode

DTYPE_TEXT

15

No

Customer Account Group

CustomerAccountGroup

DTYPE_TEXT

30

No

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

Group Type Code

GroupTypeCode

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Party Type Code

PartyTypeCode

DTYPE_TEXT

30

No

Contact_Account_Business Address

Address Name

AddressName

DTYPE_TEXT

100

No

City

City

DTYPE_TEXT

50

No

Country

Country

DTYPE_TEXT

50

No

Email Address

EmailAddress

DTYPE_TEXT

50

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Phone Number

PhoneNumber

DTYPE_TEXT

40

No

Postal Code

PostalCode

DTYPE_TEXT

30

No

State

State

DTYPE_TEXT

10

No

Street Address

StreetAddress

DTYPE_TEXT

200

No

Street Address 2

StreetAddress2

DTYPE_TEXT

100

No

Contact_Personal Address

Address Name

AddressName

DTYPE_TEXT

100

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Personal City

PersonalCity

DTYPE_TEXT

50

No

Personal Country

PersonalCountry

DTYPE_TEXT

50

No

Personal Postal Code

PersonalPostalCode

DTYPE_TEXT

30

No

Personal State

PersonalState

DTYPE_TEXT

10

No

Personal Street Address

PersonalStreetAddress

DTYPE_TEXT

200

No

Personal Street Address 2

PersonalStreetAddress2

DTYPE_TEXT

100

No

Opportunity

Account

AccountName

DTYPE_TEXT

100

No

Account Integration Id

AccountIntegrationId

DTYPE_TEXT

30

No

Account Location

AccountLocation

DTYPE_TEXT

50

No

Currency Code

CurrencyCode

DTYPE_TEXT

15

No

DUNS Number

DUNSNumber

DTYPE_TEXT

15

No

Description

Description

DTYPE_TEXT

255

No

Id

Id

DTYPE_ID

30

No

Name

Name

DTYPE_TEXT

100

No

Parent Opportunity Name

ParentOpportunityName

DTYPE_TEXT

100

No

Primary Revenue Amount

PrimaryRevenueAmount

DTYPE_TEXT

22

No

Primary Revenue Class

PrimaryRevenueClass

DTYPE_TEXT

30

No

Primary Revenue Close Date

PrimaryRevenueCloseDate

DTYPE_DATETIME

50

No

Primary Revenue Type

PrimaryRevenueType

DTYPE_TEXT

30

No

Primary Revenue Win Probability

PrimaryRevenueWinProbability

DTYPE_NUMBER

22

No

Sales Method

SalesMethod

DTYPE_TEXT

30

No

Sales Stage

SalesStage

DTYPE_TEXT

30

No

Opportunity Note

Id

Id

DTYPE_ID

30

No

Note

Note

DTYPE_NOTE

1,000

No

Note Type

NoteType

DTYPE_TEXT

30

No

Opportunity Name

OpportunityName

DTYPE_TEXT

100

No

Opportunity_Business Address

Address Name

AddressName

DTYPE_TEXT

50

No

City

City

DTYPE_TEXT

50

No

Country

Country

DTYPE_TEXT

50

No

Integration Id

IntegrationId

DTYPE_TEXT

30

No

IsPrimaryMVG

IsPrimaryMVG

DTYPE_TEXT

1

No

Postal Code

PostalCode

DTYPE_TEXT

30

No

State

State

DTYPE_TEXT

10

No

Stree Address Line 2

StreeAddressLine2

DTYPE_TEXT

100

No

Street Address

StreetAddress

DTYPE_TEXT

200

No

Revenue

Account

Account

DTYPE_TEXT

100

No

Account Location

AccountLocation

DTYPE_TEXT

50

No

Committed

Committed

DTYPE_TEXT

1

No

Currency Code

CurrencyCode

DTYPE_TEXT

20

No

Date

Date

DTYPE_DATETIME

50

No

Description

Description

DTYPE_TEXT

100

No

Id

Id

DTYPE_ID

30

No

Part Number

PartNumber

DTYPE_TEXT

50

No

Price

Price

DTYPE_TEXT

22

No

Product

Product

DTYPE_TEXT

50

No

Quantity

Quantity

DTYPE_NUMBER

22

No

Revenue

Revenue

DTYPE_TEXT

22

No

Revenue Class

RevenueClass

DTYPE_TEXT

30

No

Revenue Item Number

RevenueItemNumber

DTYPE_TEXT

30

No

Revenue Type

RevenueType

DTYPE_TEXT

30

No

Summary

Summary

DTYPE_TEXT

1

No

Win Probability

WinProbability

DTYPE_NUMBER

22

No

Siebel Application Services Interface Reference Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.