id |
integer |
Yes |
Yes |
nextval('inventory_labels_id_seq'::regclass) |
Unique identifier |
whse |
character varying(6) |
No |
No |
|
Warehouse - links to inventory.whse |
part_no |
character varying(34) |
No |
No |
|
Part number - links to inventory.part_no |
stock_uom |
character varying(10) |
No |
No |
|
Inventory stock Unit of Measure |
sell_uom |
character varying(10) |
No |
No |
|
Sell Unit of Measure |
receipt |
bigint |
No |
No |
|
Receipt number links to inventory_receipts.id |
serial |
character varying(40) |
No |
No |
|
Serial or Lot number - links to inventory_serial_numbers.number |