Table Data dictionary report - inventory_serial_transactions

Generated: 9/23/2016 2:51:05 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_transactions_id_seq'::regclass)
whse character varying(6) Yes No Warehouse for serialized item
part_no character varying(34) Yes No Part number for serialized item
number character varying(40) Yes No Serial number
link_type character varying(4) Yes No Where transactrion came from PORD = Purchasae order, Production order or adjustment SHIS = Posted Invoice
link_no character varying(10) Yes No The document number that created transaction Adjustment Purchase Order Invoice Production order
link_guid character varying(32) No No GUID linking to the line of a sales, purcahse or production order that created this transaction
receipt_no bigint No No Receipt number from when serial/lot was received
receipt_date date No No Receipt date for serial or lot number
unit_cost numeric(15,5) Yes No Cost of serial or lot number
recvd_qty numeric(15,5) Yes No Quantity of serial or lot number received. Always 1 or -1 for serial number
sales_qty numeric(15,5) Yes No Quantity sold of the serial or lot number. Always 0 or 1 for a serial number.
_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_trans_pkey Primary key (id)

Report generated by pgAdmin III