id |
integer |
Yes |
Yes |
nextval('inventory_upc_codes_id_seq'::regclass) |
Unique identifier |
whse |
character varying(6) |
Yes |
No |
|
Warehouse for this record - links to inventory.whse |
part_no |
character varying(34) |
Yes |
No |
|
Part number for this record - links to inventory-part_no |
upc_code |
character varying(40) |
Yes |
No |
|
Universal Product Code for this record |
_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 |
|
UTC Date and time this record was last modified |
_modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
uom |
character varying(10) |
No |
No |
|
Unit of Measure for this record |