Table Data dictionary report - inventory_statistics

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

Table for Inventory Sales Statistics by finanacial period

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_statistics_id_seq'::regclass) Unique identifier
whse character varying(6) No No Warehouse for the item - links to inventory.whse
part_no character varying(34) No No Part number for the item - links to inventory.part_no
year_end date No No Fiscal year end for the sales period on this record
period smallint No No Fiscal period (1-13) for this record
qty numeric(15,3) No No Quantity sold this period for this period
total_sell numeric(15,3) No No Total sales amount this period, for this item
total_cost numeric(15,3) No No Total cost for this period, for this item

Constraints

Name Type Definition Comment
inventory_statistics_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL