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
- VATCode
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.IQacParams | IQacVATRate | DefaultVATCode | VATCode |
| pears.IQacParams | IQacVATRate1 | UnallocatedCashVATCode | VATCode |
Indexes
- No indexes found.
Triggers
- No triggers found.
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