Forecast Item

The forecast item of the forecast territory.

QName: {http://xmlns.oracle.com/apps/sales/salesForecasting/forecasts/forecastService/}ForecastItemDetail

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handled by

Sales Forecast

Attributes

The following table describes attributes in the service data object.

Name Type Description

AdjustPeriodId

long

The adjust period ID if there is a adjustment tied to the item.

AdjustedForecast

decimal

The adjusted forecast.

AdjustedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The adjusted quantity value.

BUOrgId

long

The organization ID of the business unit.

BestCaseAdjustedForecast

decimal

The best case adjusted forecast.

Category

string

Forecast item category denotes whether the forecast item is of type renewal or new.

CloseDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The close date.

CorporateCurrencyCode

string

A corporate currency code set in profile.

CorporateCurrencyRate

decimal

The currency rate in corporate currency.

CorporateUnadjustedDownsideAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The worst case amount in corporate currency.

CorporateUnadjustedRevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The revenue amount in corporate currency.

CorporateUnadjustedUpsideAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Best Case amount in corporate currency.

CurrentStageId

long

The current sales stage ID.

CustomerPartyId

long

The customer associated with the revenue.

DownsideAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The worst case amount.

EffectiveDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The effective date of the revenue.

ForecastHeaderId

long

The ID that represents a forecast header record key.

ForecastItemId

long

The primary key for a ForecastItem record.
  • Primary Key

ForecastOverrideCode

string

The forecast override code for criteria.

InventoryItemId

long

The item Id of the product.

InventoryOrgId

long

The inventory organization ID from product schema.

OpportunityId

long

The ID of opportunity that the underlying revenue belongs to.

OpportunityName

string

The name of an opportunity.

OpportunityNumber

string

The opportunity number associated to the opportunity.

OpportunityStatusCode

string

The status of opportunity.

OwnerName

string

The owner name.

OwnerResourceId

long

The ID associated with the revenue owner.

OwnerResourceOrgId

long

The organization ID of revenue owner.

PartEngagementTypeCode

string

A partner engagement type code.

PartnerPartOrgPartyId

long

The party ID of the partner's organization.

PartnerSourceNumber

string

The source number of partner.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PrimaryTerritoryId

long

Primary territory ID of the revenue.

PrimaryTerritoryVersionId

long

Primary territory Version ID of the revenue.

ProductGroupId

long

The group that the product belongs to.

ProductName

string

The product name.

Quantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Quantity of product making up the revenue.

RecommendedRevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The recommended revenue amount.

RecommendedWinProbability

decimal

The likelihood to bug product.

RecurTypeCode

string

A recurring type code.

RevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The revenue amount from the revenue Item.

RevenueAmountCurrencyCode

string

Entered currency code for revenue.

RevenueExpectAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The expected revenue amount.

RevenueId

long

The ID of the revenue that the item belongs to.

RevenueNumber

string

The revenue number of the revenue.

RevenueStatusCode

string

The status of revenue.

RevenueTerritoryId

long

The Territory ID of the revenue.

RevenueTypeCode

string

A type of revenue.

SalesChannelCode

string

A code for sales channel, DIRECT or INDIRECT.

SalesCreditTypeCode

string

The code associated with the sales credit type.

SplitTypeCode

string

The split type code.

StatusCodeSetId

long

The StatusCodeSetId of revenue.

TypeCodeSetId

long

The TypeCodeSetId of the revenue.

UOMCode

string

Unit of measure code.

UnadjustedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The unadjusted quantity value.

UnitPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

A unit price of revenue.

UpdateFlag

boolean

The flag that controls if the user has access to update the record.

UpsideAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The best case amount.

WinProbability

decimal

The win probability for the revenue.

WorstCaseAdjustedForecast

decimal

The worst case adjusted forecast.