Column Name

Data Type/Size

Description

ACTIVITY_SEQN

long integer

Used to store a reference to an associated activity record

FILE_NAME

varchar (255)

Attachment's file extension

FILE_TIMESTAMP

Datetime

Date the attachment was last modified

ATTACH_IMAGE

image

File's binary data

INTENT_TO_EDIT

varchar (40)

Indicates whether a user has started an edit operation (Date/Time + "#" + <User ID>)

READ_ONLY

Boolean

Indicates whether the attachment is available for editing by non-administrator users