bom_ver

parent_item_id

string40

Y

N

Identify item being made

ver_id

string40

Y

N

Version of BOM

ver_date

tdatetime

N

N

Date version created/last modified, in UTC.

ver_comments

string80

N

Y

Comments for this version

preferred_ver

logical

N

N

Is this the preferred version to make this parent item? Default = No.

disassembly

logical

N

N

If Yes, this BOM is really telling you what can be gotten out of the main item. Default = No.

Note: This field is currently not used.

start_eff

tsmalldatetime

N

Y

The time at which this BOM version becomes effective, in UTC. Null (default) = no limit.

end_eff

tsmalldatetime

N

Y

The time at which this BOM version is no longer effective, in UTC. Null (default) = no limit.

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.