Table tax_rates

Table tax_rates holds regulative tax rates for sales and purchase transactions. They are used in association with table tax_authorities to determine the tax rate applied to sales/purchases. This table determines the tax to apply to the transaction and tax_authorities determines how the tax is distributed to the authorities.

Table Type: InnoDB

Field Type Default Description
tax_rate_id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
description_short varchar(15) NULL Short name used in reports and where description space is limited.
description_long varchar(64) NULL Longer mre detailed description of the tax rate, may include what taxz authorities are involved.
rate_accounts varchar(64) NULL encoded string containing the GL accounts and rate values.
freight_taxable 0, 1 0 Determines whether freight is taxable or not