Table Data dictionary report - inventory_receipts

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

Table for Inventory Receipts through Purchase Orders, Inventory Adjustments/Transfers, Production Orders, Sales Order returns, each record includes FIFO/LIFO information

Columns

Name Data type Not Null? Primary key? Default Comment
id bigint Yes Yes nextval('inventory_receipts_id_seq'::regclass) Unique identifier and receipt number
receive_date date No No Date of inventory receipt
vendor_no character varying(20) No No Vendor code item received from- links to vendors.vendor_no
whse_location character varying(20) No No Warehouse physical location at time of receipt
qty numeric(15,5) No No Quantity received
cost numeric(19,5) No No Cost of part number received
selling numeric(15,5) No No Sell price at time of receipt
link_no character varying(10) No No The document number that posted receipt; Adjustment number Production Order number Purchase Order number Sales Order number (customer return) Transfer number
remaining_qty numeric(15,5) No No Remaining quantity available at this cost when using FIFO or LIFO cost
ref_no character varying(20) No No Reference number from the Purchase Order or Inventory Adjustment
uom_inventory character varying(10) No No Inventory or stock 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 purchase unit of measure
_dbversion integer No No Program version that last modified this record
_created timestamp without time zone No No UTC Date and time record was created
_created_by character varying(3) No No User initials that created this record
_modified timestamp without time zone No No UTC Date and time this record was last modified
_modified_by character varying(3) No No User initials that last modified this record
link_table character varying(4) No No The module that received the item; BHIS = Production Order PORD = Purchase Order or Adjustment SORD = Sales Order (customer return)
inventory_id integer Yes No Inventory item for this receipt - links to inventory.id
link_guid character varying(32) No No Link to source record; inventory_count_items.guid production_history_items.guid production_order_items.guid purchase_history_items.guid purchase_order_items.guid sales_history_items.guid sales_order_items.guid
new_average_cost numeric(19,5) No No New value written to inventory.average_cost at the time of this receipt
new_onhand_qty numeric(15,5) No No New value written to inventory.onhand_qty at the time of this receipt

Constraints

Name Type Definition Comment
inventory_receipts_pkey Primary key (id)
inventory_receipts_inventory_id_fkey Foreign key (inventory_id) REFERENCES public.inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin3 LTS by BigSQL