Contains information about notes which have been assigned to primary objects. A record is added to this table when a note is added to an object. Notes of an object can be viewed by selecting the Notes of Object-Type node in the Object’s main view.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Object Name. First part of the primary key. Foreign key to one of the following fields: ca_company.company_uuid, ca_contact.contact_uuid, ca_location.location_uuid, ca_owned_resource.own_resource_uuid, ca_model_def.model_uuid, arg_legaldoc.legaldoc_uuid |
| noinstnc | smallint | not null | Note instance. Second part of the primary key. |
| object_type | smallint | with null | Object type |
| nodate | date | with null | Date |
| notime | nvarchar(8) | with null | Time |
| contact_uuid | byte(16) | with null | Primary key. Unique identifier |
| noivid | smallint | with null | Version. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| notype | integer | with null | Note type. Foreign key to the dlkey column of the arg_drpdnlst table. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Creation date. |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table