Table Data dictionary report - inventory_count_details

Generated: 2018-10-18 6:22:23 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Inventory Count item records, one record for each count entered, for every part number counted

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_count_details_id_seq'::regclass) Unique identifier
sequence integer Yes No Sequencial record number
count_id integer Yes No Link to the counter header table - links to inventory_counts.id
inventory_id integer Yes No The inventory.id of this item - links to inventory.id
serial_id integer No No The serial number record for this item - links to inventory_serial_numbers.id
parent_id integer No No The id of the parent record for all of the counts belonging to a single part number
guid character varying(32) No No A unigue record identifier for linking to other tables like inventory_serial_transactions, inventory_receipts
count_time timestamp without time zone No No Date and time that this count record was recorded
uom character varying(10) No No Unit of measure recorded with this count record, may be different then inventory.uom_inventory
whse_location character varying(20) No No Physical location in the warehouse where part number was counted
expected_qty numeric(15,5) No No The onhand quantity that was expected to exist, inventory.onhand_qty when the Invoice Count was created (Frozen)
committed_qty numeric(15,5) No No The committed quantity that was in inventory.committed_qty when the Inventory Count was created (Frozen)
counted_qty numeric(15,5) No No The count quanitity for this record
inventory_qty numeric(15,5) No No The count quantity for this record in the inventory unit of measure
cost numeric(15,5) No No The average cost of this item
unit_variance numeric(15,5) No No The variance quantity for this item
gain_loss numeric(15,5) No No The amount of loss (negative) or gain for this item
notes text No No User added notes for this record
count_user character varying(3) No No The initials of the user that recorded the count for this record
_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

Constraints

Name Type Definition Comment
inventory_count_details_pkey Primary key (id)
inventory_count_details_count_id_fkey Foreign key (count_id) REFERENCES public.inventory_counts (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
inventory_count_details_inventory_id_fkey Foreign key (inventory_id) REFERENCES public.inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
inventory_count_details_serial_id_fkey Foreign key (serial_id) REFERENCES public.inventory_serial_numbers (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin3 LTS by BigSQL