res

res_desc

string80

N

N

Description of a resource

res_class

string80

N

N

Class of a resource – used to organize display

qty_avail

tfloat

N

N

Available quantity of this resource

allow_neg_bal

logical

N

N

Yes if it is allowable to have qty_avail – total qty reqd < 0, else No (default).

num_decimals

int32

N

N

Number of decimal places to display for quantities of this resource; if 0 resources cannot be fractional

spare1

string80

N

Y

Use defined by language term 2289

spare2

string80

N

Y

Use defined by language term 2290

spare3

string80

N

Y

Use defined by language term 2291

spare4

string80

N

Y

Use defined by language term 2292

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.

res_id

ID 1

Y

N

Identify a resource