Table Data dictionary report - inventory_labels

Generated: 2018-10-18 7:59:52 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Schema for temp table created when printing Inventory labels

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
inventory_labels_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL