OpportunityRevenueItemsRecurringRevenues
The recurring revenues resource is used to view, create, update, and delete a recurring revenue. The revenues that span over a period of time sourced from the same product on an opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| RevnId [KEY] | String | True |
RevnId | |
| ChildRevenueRevnId [KEY] | String | False |
OpportunityRevenueItems.RevnId |
RevnId of ChildRevenue. |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber |
OptyNumber |
| CreatedBy | String | True |
Who column: indicates the user who created the row. | |
| CreationDate | Datetime | True |
Who column: indicates the date and time of the creation of the row. | |
| EffectiveDate | Date | False |
Estimated close date for this revenue - defaulted from opportunity's close date | |
| LastUpdateDate | Datetime | True |
Who column: indicates the date and time of the last update of the row. | |
| LastUpdateLogin | String | True |
Who column: indicates the session login associated to the user who last updated the row. | |
| LastUpdatedBy | String | True |
Who column: indicates the user who last updated the row. | |
| NonRecurringRevenue | Decimal | False |
Non-Recurring Revenue Amount (Net) | |
| Quantity | Double | False |
Product quantity. | |
| RecurParentRevnId | Long | False |
Indicates the parent revenue id for the recurrence | |
| RecurRevenue | Decimal | False |
The recurring revenue amount on the revenue line | |
| RevnAmount | Decimal | False |
Revenue amount. | |
| RevnAmtCurcyCode | String | True |
RevnAmtCurcyCode | |
| RevnNumber | String | False |
User editable revenue number. Defaulted from REVN_ID. Needs to be unique, cannot be NULL. | |
| UsageRevenue | Decimal | False |
The usage revenue amount on the revenue line | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |
| PartyId | String |
Input specifying the Party Id. |
| 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. |
| EffectiveEndDate | String |
Input specifying the Effective EndDate. |
| 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. |
| TeamMember | String |
Input specifying the Team Member. |
| OptyId | String |
Input specifying the Opty Id. |
| ResourcePartyId | String |
Input specifying the ResourcePartyId. |