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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
RecordSet | String |
Input specifying the resource type. |
Finder | String |
Input specifying the Finder type. |