ActivityNotes
Note data objects that capture comments, information or instructions for an Oracle Fusion Applications business object.
Columns
| Name | Type | ReadOnly | References | Description |
| NoteId [KEY] | Long | False |
Unique Note Identifier. This is the primary key of the notes table. | |
| ActivityNumber [KEY] | String | False |
Activities.ActivityNumber | |
| 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 |
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. | |
| 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 | |
| DeleteFlag | Bool | False |
This flag controls if the user has access to delete the record | |
| EmailAddress | String | False |
Email Address of the user who created the Note | |
| FormattedAddress | String | False |
Address of the user who created the Note | |
| FormattedPhoneNumber | String | False |
Phone Number of the user who created the Note | |
| LastUpdateDate | Datetime | False |
Who column: indicates the date and time of the last update of the row. | |
| LastUpdateLogin | String | False |
System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system. | |
| LastUpdatedBy | String | False |
System attribute to capture the Id of the user who last updated the Note. This is defaulted by the system. | |
| 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. | |
| ParentNoteId | Long | False |
null | |
| 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. | |
| UpdateFlag | Bool | False |
This flag controls if the user has access to update the record | |
| VisibilityCode | String | False |
This is the attribute to specify the visibility level of the note. |