OpportunityRevenueTerritories
The opportunity revenue territories resource is used to view, create, and update the revenue territories of an opportunity. The territories assigned to an opportunity revenue line. The territories provide the rules for automatically assigning salespeople and other resources to customers, partners, leads, and opportunity line items.
Columns
| Name | Type | ReadOnly | References | Description |
| RevnTerrId [KEY] | Long | False |
This is the primary key of the revenue territories table. | |
| RevnId [KEY] | Long | False | ||
| OptyNumber [KEY] | String | False | ||
| AssignmentType | String | False |
The type of assignment used to assign the territory to the opportunity. | |
| CreatedBy | String | False |
The user who created the revenue territory record. | |
| CreationDate | Datetime | False |
The date when the record was created. | |
| EffectiveEndDate | Date | False |
The date when the resource organization assignment to the territory ends. | |
| EffectiveStartDate | Date | False |
The date when the resource organization for the territory was assigned to the revenue line. | |
| ForecastParticipationCode | String | False |
The code to identify the forecast type that the territory participates in. For example, Revenue, Nonrevenue, Revenue and Nonrevenue, or Nonforecasting. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The login of the user who last updated the record. | |
| Name | String | False |
The name of the territory that the opportunity belongs to. | |
| Name1 | String | False |
The name of the organization that the territory resource belongs to. | |
| PartyId | Long | False |
The unique identifier of the resource who owns the territory. | |
| PartyName | String | False |
The name of the territory owner for the opportunity. | |
| RoleId | Long | False |
The unique identifier of the resource's role. | |
| RoleName | String | False |
The name of the resource's role. | |
| TerritoryId | Long | False |
Territory identifier. | |
| TerritoryVersionId | Long | False |
Territory version identifier. | |
| TypeCode | String | False |
The type of territory assigned to the opportunity. | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| PartyId | Long | False |
The unique identifier of the resource who owns the territory. | |
| EffectiveEndDate | Datetime | False |
The date when the resource organization assignment to the territory ends. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |
| PartyIdAttribute | String |
Input specifying the Party Id Attribute. |
| AttributeName | String |
Input specifying the Attribute Name. |
| RollUpId | String |
Input specifying the RollUp Id. |
| SourceObject | String |
Input specifying the Source Object. |
| SourceObjectId | String |
Input specifying the Source Object Id. |
| ClosePeriod | String |
Input specifying the Close Period. |
| ContactPartyId | String |
Input specifying the Contact Party Id. |
| EffectiveBeginDate | String |
Input specifying the Effective BeginDate. |
| LeadNumber | String |
Input specifying the Lead Number. |
| LookupCategory | String |
Input specifying the Lookup Category. |
| OpportunityContactName | String |
Input specifying the Opportunity Contact Name. |
| OptyStatusCode | String |
Input specifying the Opty StatusCode. |
| Partner | String |
Input specifying the Partner. |
| PartnerPartyId | String |
Input specifying the Partner Party Id. |
| Product | String |
Input specifying the Product. |
| ProductGroup | String |
Input specifying the Product Group. |
| ReferenceName | String |
Input specifying the Reference Name. |
| ResourcePartyId | String |
Input specifying the Resource Party Id. |
| TeamMember | String |
Input specifying the Team Member. |
| OptyId | String |
Input specifying the Opty Id. |