Siebel Forecast
The Siebel Forecast ASI consists of internal and external integration objects and a business service. This ASI facilitates the outbound data synchronization between the Siebel application and an external back-office system. This ASI is used by the Export Forecast business process, which queries the Siebel application for data on a given forecast and returns the data to a back-office system.
The following image shows the Siebel Forecast ASI structure, which contains the following components: Forecast Header and Forecast Items.
The following table lists the integration components and user keys of the Siebel Forecast ASI.
| Integration Component | XML Tag | User Keys |
|---|---|---|
Forecast |
Forecast |
|
Forecast Item Detail Flat |
ForecastItemDetailFlat |
|
Forecast Fields in Siebel Forecast ASI
The following table lists the Forecast fields and their attributes in Siebel Forecast ASI. Fields without a length specified do not have a maximum length associated with them.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Archive Timestamp |
ArchiveTimestamp |
DTYPE_TEXT |
N/A |
No |
Created By Login |
CreatedByLogin |
DTYPE_TEXT |
50 |
No |
Forecast Base Period Type |
ForecastBasePeriodType |
DTYPE_TEXT |
30 |
No |
Forecast Date |
ForecastDate |
DTYPE_TEXT |
N/A |
No |
Forecast End Date |
ForecastEndDate |
DTYPE_TEXT |
N/A |
No |
Forecast Id |
ForecastId |
DTYPE_ID |
15 |
No |
Forecast Name |
ForecastSeriesName |
DTYPE_TEXT |
20 |
No |
Forecast Number |
ForecastNumber |
DTYPE_TEXT |
30 |
No |
Forecast Start Date |
ForecastStartDate |
DTYPE_TEXT |
N/A |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Owner Organization Id |
OwnerOrganizationId |
DTYPE_ID |
15 |
No |
Owner Position Id |
OwnerPositionId |
DTYPE_ID |
15 |
No |
Forecast Item Detail Flat Fields in Siebel Forecast ASI
The following table lists the Forecast Item Detail Flat fields and their attributes in Siebel Forecast ASI. Fields without a length specified do not have a maximum length associated with them.
| Name | XML Tag | Data Type | Length | Req. |
|---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
Amount Revenue |
Revenue |
DTYPE_TEXT |
N/A |
No |
Best Case |
BestCase |
DTYPE_TEXT |
N/A |
No |
Commit Flag |
CommitFlag |
DTYPE_TEXT |
1 |
No |
Cost |
Cost |
DTYPE_TEXT |
N/A |
No |
Currency |
CurrencyCode |
DTYPE_TEXT |
N/A |
No |
Detail Date |
DetailDate |
DTYPE_TEXT |
N/A |
No |
DUNS Number |
DUNSNumber |
DTYPE_TEXT |
15 |
No |
Forecast Id |
ForecastId |
DTYPE_ID |
15 |
No |
Forecast Item Id |
ForecastItemId |
DTYPE_ID |
15 |
No |
Id |
Id |
DTYPE_ID |
15 |
No |
Link Type |
LinkType |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
15 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
15 |
No |
Owner Forecast Id |
OwnerForecastId |
DTYPE_ID |
15 |
No |
Primary Product Line Id |
ProductLineId |
DTYPE_ID |
15 |
No |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Product Price |
ProductPrice |
DTYPE_TEXT |
N/A |
No |
Product Quantity |
ProductQuantity |
DTYPE_TEXT |
N/A |
No |
Sales Rep Id |
SalesRepPositionId |
DTYPE_ID |
15 |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
15 |
No |
Unit of Measure |
UnitOfMeasure |
DTYPE_TEXT |
30 |
No |
Worst Case |
WorstCase |
DTYPE_TEXT |
N/A |
No |