OpportunityNotes
The note resource is used to capture comments, information, or instructions for an opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| NoteId [KEY] | Long | False |
This is the primary key of the notes table. | |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber | |
| ContactRelationshipId | Long | False |
The identifier of the relationship populated when the note is associated with a contact. | |
| CorpCurrencyCode | String | False |
The corporate currency code of the note associated with the contact. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. | |
| CreatedBy | String | False |
The user who created the note record. | |
| CreationDate | Datetime | False |
The date and time when the note record was created. | |
| CreatorPartyId | Long | False |
The unique party identifier for the note creator. | |
| CurcyConvRateType | String | False |
The currency conversion rate type associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. | |
| CurrencyCode | String | False |
The currency code associated with the note. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. | |
| LastUpdateDate | Datetime | False |
The date when the note data was last updated. | |
| NoteTxt | String | False |
The actual note text. | |
| NoteTypeCode | String | False |
This code for categorization of the note type. | |
| PartyId | Long | False |
The unique Identifier of the party to which the note is associated. | |
| PartyName | String | False |
The name of party associated with the opportunity. | |
| SourceObjectCode | String | False |
The code of the source object Opportunities, as defined in OBJECTS Metadata. | |
| SourceObjectId | String | False |
The primary key identifier of the source object Opportunities, as defined in OBJECTS Metadata. | |
| VisibilityCode | String | False |
The visibility level of the note. | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| PartyId | Long | False |
The unique Identifier of the party to which the note is associated. | |
| SourceObjectId | String | False |
The unique identifier of the source object as defined in OBJECTS Metadata, such as activities, opportunities, and so on. |
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. |
| 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. |
| ResourcePartyId | String |
Input specifying the Resource Party Id. |
| TeamMember | String |
Input specifying the Team Member. |
| Name | String |
Input specifying the Name. |
| OptyId | String |
Input specifying the Opty Id. |