Table Data dictionary report - inventory_serial_numbers

Generated: 9/23/2016 2:50:38 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_lot_numbers_id_seq'::regclass)
whse character varying(6) Yes No Warehouse of the part number that this serial/lot number is in.
part_no character varying(34) Yes No Part number for this serial/lot number
number character varying(40) Yes No Serial/lot number
closed boolean Yes No Serial/lot number has been consumed by sales or production, or it has been returned.
unit_cost numeric(15,5) Yes No Cost of the serial/lot number
last_received_date date No No Received date of serial number or the last date a lot number was received.
expiry_date date No No Expiry of lot number
available_qty numeric(15,5) Yes No Available quantity of serial or lot number. For serial numbers this is either 0 or 1
committed_qty numeric(15,5) Yes No Quantiry of serial or lot number that is committed. For serial numbers this is either 0 or 1.
temp_qty numeric(15,5) Yes No Quantiry of serial or lot number that is temporarily committed. For serial numbers this is either 0 or 1. This number is always back to zero when sales.production order is saved.
selling numeric(15,5) No No Sell price for this serial or lot number.
hold boolean Yes No Serial or lot number is held and cannot be sold.
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No

Constraints

Name Type Definition Comment
bve_lot_number_pkey Primary key (id)

Report generated by pgAdmin III