wo_file

wo_id

string40

Y

N

Work order ID number

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 that the file was last modified

file_size

int32

N

Y

Size of file

author

string40

N

Y

User_ID to notify if file changes

spare1

string80

N

Y

Use defined by language term 5577

spare2

string80

N

Y

Use defined by language term 5578

spare3

string80

N

Y

Use defined by language term 5579

spare4

string80

N

Y

Use defined by language term 5580

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.