Table Data dictionary report - sales_taxes

Generated: 2018-10-18 8:05:33 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Sales Taxes

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('sales_taxes_id_seq'::regclass) Unique identifier
tax_no smallint No No Tax code created by user
name character varying(60) No No Tax name or description
rate numeric(7,4) No No Tax rate to apply
gl_account character varying(24) No No General Ledger tax liability accouunt
short_name character varying(20) No No Tax short name to use on forms
use_partial_rate boolean No No Partial tax rate allowed flag; TRUE = Yes FALSE = No
partial_rate numeric(7,4) No No Partial tax rate
_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
udf_data hstore No No ''::hstore User defined data for this record
freight boolean No No false Tax applicable to freight flag; FALSE = No TRUE = Yes
surcharge boolean No No true Tax applicable to surcharges flag; FALSE = No TRUE = Yes
include_landed boolean No No true Include tax to Purchase Order landed cost flag; FALSE = No (tax is recoverable) TRUE = Yes (tax is added to purchase cost)
gl_credit_account character varying(24) No No General Ledger account for recoverable tax - Input Tax Credit account

Constraints

Name Type Definition Comment
sales_tax_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL