folder

item_id

string40

Y

N

Part "number"

oper_id

string40

Y

N

Operation "number"

ent_id

int32

Y

N

Physical entity on which operation done

ver_id

string40

Y

N

Folder revision

oper_desc

string80

N

Y

Operation description

notes

nvarchar(max)

N

Y

User-entered text notes

udf1

string40

N

Y

User-defined field 1

udf2

string40

N

Y

User-defined field 2

preferred_ver

logical

N

N

Is this the preferred version? Default = No.

design_hold

logical

N

N

When Yes folder is unusable. Default = No.

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