Table Data dictionary report - sales_taxes

Generated: 9/23/2016 3:06:39 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('sales_taxes_id_seq'::regclass)
tax_no smallint No No Tax code
name character varying(60) No No Tax name
rate numeric(7,4) No No Percentage of tax
gl_account character varying(24) No No GL account to post tax
short_name character varying(20) No No Short name of tax
use_partial_rate boolean No No Does tax use partial tax rate TRUE = Yes FALSE = No
partial_rate numeric(7,4) No No Partial tax rate
_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
udf_data hstore No No ''::hstore hstore field containing user defined data
freight boolean No No false Apply this tax to freight TRUE = Yes FALSE = No
surcharge boolean No No true
include_landed boolean No No true Add this tax to purchase order landed cost. (usually yes except in the case of recoverable tax like HST) TRUE = Yes FALSE = No
gl_credit_account character varying(24) No No What GL account to post tax that is recoverable (like HST)

Constraints

Name Type Definition Comment
sales_tax_pkey Primary key (id)

Report generated by pgAdmin III