Table Data dictionary report - inventory_product_codes

Generated: 9/23/2016 2:47:57 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_product_codes_id_seq'::regclass)
product_code character varying(10) No No Product code
description character varying(80) No No Product code description
default_margin numeric(9,2) No No Lowest margin to sell for before getting warning
sub_category boolean No No
top_category_code character varying(10) No No
code_sequence_no numeric(7) No No
code_page_size numeric(3) No No
code_display_type character varying(17) No No
sales_acct smallint No No Sales dept normally used for this prodcut code
_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
surcharge_pct numeric(7,2) No No Surcharge percentage to charge for this product code
discount_code character varying(1)[] Yes No '{" "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "}'::character varying[]
discount_mode smallint[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::smallint[]
discount_pct numeric(7,4)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[]
discount_amt numeric(15,2)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[]
udf_data hstore No No ''::hstore hstore field that contains user defined data

Constraints

Name Type Definition Comment
product_code_pkey Primary key (id)

Report generated by pgAdmin III