OpportunityRevenueItemsChildSplitRevenue
The child split revenue resource is used to view, create, update, and delete a split revenue. The revenue or nonrevenue credit is allocated to the resource which has contributed to the selling effort for an opportunity revenue line.
Columns
| Name | Type | ReadOnly | References | Description |
| RevnId [KEY] | String | False |
RevnId | |
| ChildRevenueRevnId [KEY] | String | False |
OpportunityRevenueItems.RevnId |
RevnId of ChildRevenue |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber |
OptyNumber |
| CreatedBy | String | False |
Who column: indicates the user who created the row. | |
| CreationDate | Datetime | False |
Who column: indicates the date and time of the creation of the row. | |
| ExtnPartyName | String | False |
ExtnPartyName | |
| ExtnPartyNameLOVSwitcher | String | False |
ExtnPartyNameLOVSwitcher | |
| ForecastTerritoryName | String | False |
ForecastTerritoryName | |
| LastUpdateDate | Datetime | False |
Who column: indicates the date and time of the last update of the row. | |
| LastUpdateLogin | String | False |
Who column: indicates the session login associated to the user who last updated the row. | |
| LastUpdatedBy | String | False |
Who column: indicates the user who last updated the row. | |
| Name | String | False |
Name of the resource organization of the credit recipient. | |
| OwnerLockAsgnFlag | Bool | False |
Indicates if the credit recipients of the revenue line should be locked from re-assignment by the system. | |
| OwnerPartyNumber | String | False |
OwnerPartyNumber | |
| PrTerritoryUpdatedByPartyName | String | False |
Name of the user who last updated the forecast territory. | |
| PrTerritoryVersionId | Long | False |
Forecast territory version identifier. | |
| PrTerritoryVersionIdForManual | String | False |
Indicates the version ID of a territory that is to be manually assigned to the revenue record. | |
| ResourcePartyId | Long | False |
Resource identifier of the credit recipient. | |
| RevnAmount | Decimal | False |
Revenue amount. | |
| RevnAmountCurcyCode | String | False |
The currency the amount on this revenue line is based on. | |
| RevnNumber | String | False |
Unique number for the revenue line. Initially defaulted from the revenue identifier. | |
| SalesCreditTypeCode | String | False |
Indicates the type of sales credit - revenue or nonrevenue. | |
| SplitPercent | Double | False |
Split percent. | |
| TerrOwnerPartyName | String | False |
TerrOwnerPartyName | |
| 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. |