Attachments View

Applies to QAComplete 12.71 SaaS, last modified on January 19, 2021

Description

Contains detailed information on the attachments.

Dependencies

Columns

AttachmentId  :  int, allows null: no, default: auto-generated

The unique numeric identifier of the item.

AttachmentTypeCode  :  varchar (max 100 chars), allows null: no

The column is reserved for system use only.

Comments  :  varchar (max 8000 chars), allows null: yes

The attachment comments, as displayed on the Files tab.

This column corresponds to a field that can be available for Rich Text Feature.

DateCreated  :  datetime, allows null: yes, default: Current date and time

The date the attachment was first uploaded.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: yes, default: Current date and time

The date the attachment was reuploaded.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EntityCode  :  varchar (max 100 chars), allows null: no

The type of the item with which the attachment is associated.

You can find correspondences between entity code values and related modules or features in Table of Entity Code Values.

FileFormatCode  :  varchar (max 100 chars), allows null: no, default: N/A

The type of the file, such as Image, Other, and so on.

FileName  :  varchar (max 255 chars), allows null: no

The attachment’s file name.

FileNameZipped  :  varchar (max 255 chars), allows null: no

The attachment’s zipped file name.

FKId  :  int, allows null: no

The ID of the item the attachment is associated with.

IsInternalUseOnly  :  varchar (max 1 char), allows null: yes

The column is reserved for system use only.

ProjId  :  int, allows null: no

The ID of the project related to the associated item.

Seq  :  int, allows null: no, default: 0

The sequence of the attachment, as it appears on the Files tab of the associated item.

Title  :  varchar (max 255 chars), allows null: no

The attachment title, as displayed on the Files tab.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the attachment info.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the attachment, in the Last name, First name format.

See Also

Attachments Table
CustomFields View
Crossmodules

Highlight search results