Table of Contents



pears.IQacVATRate

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

VAT rates

Columns

Column Type Null Default Comment
VATCode char(3) NOT NULL
Name char(50) NOT NULL
VATRate double NOT NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.IQacParams IQacVATRate DefaultVATCode VATCode
pears.IQacParams IQacVATRate1 UnallocatedCashVATCode VATCode

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacVATRate"
-- Table comment: VAT rates
-- Statement count: 2
 
CREATE TABLE "pears"."IQacVATRate" (
    "VATCode"                        CHAR(3) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"VATRate"                        DOUBLE NOT NULL
   ,PRIMARY KEY ("VATCode" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQacVATRate" IS 
	'VAT rates'
GO