Table Data dictionary report - inventory_receipts

Generated: 9/23/2016 2:49:07 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_receipts_id_seq'::regclass)
receipt_no bigint No No Receipt number
whse character varying(6) No No Warehouse of item received
part_no character varying(34) No No Part number of item received
receive_date date No No Date of receipt
vendor_no character varying(20) No No Vendor code item received from. Comes from vendor.vendor_no
whse_location character varying(20) No No Warehouse location at thime of receipt
qty numeric(15,5) No No Quantity received
cost numeric(19,5) No No Cost of part numnber received
selling numeric(15,5) No No Sell price at time of receipt
receive_user character varying(3) No No Initials of user that posted receipt
link_no character varying(10) No No The document number that posted receipt. PO number Adjustment number Transfer number
remaining_qty numeric(15,5) No No Remaining unsold quantity when using FIFO or LIFO pricing.
open_close_flag character varying(1) No No Set to closed when all of the quantity is consumed when using FIFO or LIFO pricing.
ref_no character varying(20) No No Reference number from the PO or adjustment
uom_inventory character varying(10) No No Inventory or stocking unit of measure
uom_receive character varying(10) No No Receipt unit of measure
qty_receive_uom numeric(15,5) No No Quantity received of the unit of measure
_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
link_table character varying(4) No No The module that received the item PORD = Purchase Order or Adjustment BHIS = Production Order

Constraints

Name Type Definition Comment
receipts_pkey Primary key (id)

Report generated by pgAdmin III