| id |
integer |
Yes |
Yes |
nextval('bom_items_id_seq'::regclass) |
Unique identifier |
| sequence |
integer |
No |
No |
|
Sequential line number |
| whse |
character varying(6) |
No |
No |
|
Component warehouse - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Component Part number - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Component description from inventory.description |
| qty |
numeric(15,5) |
No |
No |
|
Component quantity for this item |
| uom_usage |
character varying(10) |
No |
No |
|
Unit of measure used for the component |
| cost |
numeric(15,5) |
No |
No |
|
Not used |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
UTC User initials that last modified this record |
| parent_id |
integer |
Yes |
No |
|
The inventory.id of the parent item for this group of components - links to inventory.id |
| inventory_id |
integer |
No |
No |
|
The inventory.id of this item - links to inventory.id |
| price |
numeric(15,5) |
No |
No |
|
Not used |