folder_file

item_id

string40

Y

N

The ID of the item with which the file is associated.

oper_id

string40

Y

N

The ID of the operation with which the file is associated.

ent_id

int32

Y

N

The physical entity on which the operation is performed.

ver_id

string40

Y

N

The folder version ID.

file_path

string254

Y

N

The path and file name of the file.

file_desc

string40

N

Y

The description of the file.

file_type

string254

N

N

The file type of the file. This value is entered internally, based on the file extension of the file specified in the file_path field.

last_modified

tdatetime

N

Y

The date and time in UTC when the file was last modified.

file_size

int32

N

Y

The size of the file. Changes when the file is modified.

author

string40

N

Y

The user ID of the person to notify if the file changes.

spare1

string80

N

Y

Use defined by language term 5573.

spare2

string80

N

Y

Use defined by language term 5574.

spare3

string80

N

Y

Use defined by language term 5575.

spare4

string80

N

Y

Use defined by language term 5576.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed.

last_edit_by

string40

N

Y

Who last changed this record.

last_edit_at

tdatetime

N

N

When this record was last changed.

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.