ContactNotes
The note resource is used to capture comments, information, or instructions for a contact.
Columns
| Name | Type | ReadOnly | References | Description |
| NoteId [KEY] | Long | False |
This is the primary key of the notes table. | |
| PartyNumber [KEY] | String | False |
Contacts.PartyNumber | |
| 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 contact to which the note is associated. One of PartyId, PartyNumber or PartySourceSystem and PartySourceSystemReferenceValue keys is required to uniquely identify the contact record with which the address is associated. | |
| PartyName | String | False |
The name of a contact party. | |
| SourceObjectCode | String | False |
The code of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata. | |
| SourceObjectId | String | False |
The primary key identifier of the source object such as Activities, Opportunities, as defined in OBJECTS Metadata. | |
| VisibilityCode | String | False |
The visibility level of the note. | |
| ContactLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| BindUserPartyId | String |
The unique identifier of the contact. |
| PersonProfileId | String |
The unique identifier of the contact. |
| SourceSystem | String |
The name of external source system where the contact party is imported from. |
| SourceSystemReferenceValue | String |
The unique identifier for the contact party from the external source system. |