Contains information about attachments assigned to a primary object. UAPM supports attaching electronic files to an object. The supporting documents of a specific object can be made easily accessable to the user as and when required. For example, a scanned copy of a contract with the legal document record that represents the contract. A record is added to this table when a supporting document is attached to it. This table information can be viewed by selecting the respective node under Attachments for Object-Type node of an object's main view.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Attachment object. 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 |
| amid | integer | not null | Attachment ID. Second part of the primary key. |
| object_type | smallint | with null | Object type |
| amfile | nvarchar(250) | with null | File Path. Stores the file path of the attachment. This is the place where the attachment is saved on the server. |
| amdesc | nvarchar(255) | with null | Description |
| 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