Table tax_authorities

Table tax_authorities holds regulative authorities and the tax rate applied to transactions. They are used in association with table tax_rates to determine the tax rate applied to sales/purchases. This table applies the tax to the appropriate accounts and tax_rates determines which authority receives the tax.

Table Type: InnoDB

Field Type Default Description
tax_auth_id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
description_short char(15) NULL Short description used for reports and where display space is limited
description_long varchar(64) NULL More detailed description used where all the details of the tax authority is required.
account_id varchar(15) NULL General Ledger account associated with this tax authority. This field determines where the tax value calculated in a transaction is placed.
vendor_id int(11) 0 Account (Contact) associated with this tax_authority.
tax_rate float 0 Tax rate value