AccountNotes
The note resource is used to capture comments, information, or instructions for an account.
Columns
| Name | Type | ReadOnly | References | Description |
| NoteId [KEY] | Long | False |
This is the primary key of the notes table. | |
| PartyNumber [KEY] | String | False |
Accounts.PartyNumber |
The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number. |
| ContactRelationshipId | Long | False |
The relationship ID populated when the note is associated with a contact. | |
| CorpCurrencyCode | String | False |
Holds Corporate Currency Code from profile. | |
| CreatedBy | String | False |
Indicates the user who created the row. | |
| CreationDate | Datetime | False |
Indicates the date and time of the creation of the row. | |
| CreatorPartyId | Long | False |
This is Party Id for the Note Creator. | |
| CurcyConvRateType | String | False |
Holds Currency Conversion Rate Type from profile. | |
| CurrencyCode | String | False |
Holds currency code of a record. | |
| LastUpdateDate | Datetime | False |
Indicates the date and time of the last update of the row. | |
| AccountLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| NoteTxt | String | False |
This is the column which will store the actual note text. | |
| NoteTypeCode | String | False |
This is the note type code for categorization of note. | |
| PartyId | Long | False |
Party identifier. | |
| PartyName | String | False |
Name of this party. | |
| SourceObjectCode | String | False |
This is the source_object_code for the source object as defined in OBJECTS Metadata. | |
| SourceObjectId | String | False |
This is the source_object_Uid for the source object (such as Activities, Opportunities etc) as defined in OBJECTS Metadata. | |
| VisibilityCode | String | False |
This is the attribute to specify the visibility level of the note. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| FocusPartyId | String |
The unique identifier of the child account to be returned at the top by the Direct Accounts finder. |
| ParentPartyId | String |
The unique identifier of the account used to search the direct child accounts. |
| BindUserPartyId | String |
The unique identifier of the party. Used in MyAccounts finder. |
| SourceSystem | String |
Name of external source system. |
| SourceSystemReferenceValue | String |
Identifier for this record from external source system. |
| OrganizationProfileId | String |
The unique identifier of the organization. |