pears.IQacParams

Default invoice settings

• DBID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacParams"
-- Table comment: Default invoice settings
-- Statement count: 8
 
CREATE TABLE "pears"."IQacParams" (
    "DBID"                           CHAR(2) NOT NULL
   ,"LastDocumentNumber"             INTEGER NULL
   ,"Name"                           CHAR(50) NULL
   ,"Version"                        SMALLINT NULL
   ,"CountryCode"                    CHAR(3) NOT NULL
   ,"CurrencyCode"                   CHAR(3) NOT NULL
   ,"VATNumber"                      CHAR(20) NULL
   ,"ReserveNominalCode"             CHAR(12) NULL
   ,"LockDate"                       DATE NULL
   ,"LastPrintBatch"                 INTEGER NULL
   ,"LastTransferBatch"              INTEGER NULL
   ,"CashAccounting"                 SMALLINT NULL
   ,"DefaultVATCode"                 CHAR(3) NULL
   ,"UnallocatedCashVATCode"         CHAR(3) NULL
   ,"DefaultPaymentMethod"           CHAR(3) NULL
   ,PRIMARY KEY ("DBID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQacParams" IS 
	'Default invoice settings'
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD NOT NULL FOREIGN KEY "IQacCountry" ("CountryCode" ASC)
    REFERENCES "pears"."IQacCountry" ("CountryCode")
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD NOT NULL FOREIGN KEY "IQacCurrency" ("CurrencyCode" ASC)
    REFERENCES "pears"."IQacCurrency" ("CurrencyCode")
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD FOREIGN KEY "IQacNominal" ("ReserveNominalCode" ASC)
    REFERENCES "pears"."IQacNominal" ("NominalCode")
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD FOREIGN KEY "IQacPaymentMethod" ("DefaultPaymentMethod" ASC)
    REFERENCES "pears"."IQacPaymentMethod" ("PaymentMethodCode")
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD FOREIGN KEY "IQacVATRate" ("DefaultVATCode" ASC)
    REFERENCES "pears"."IQacVATRate" ("VATCode")
GO
 
 
ALTER TABLE "pears"."IQacParams"
    ADD FOREIGN KEY "IQacVATRate1" ("UnallocatedCashVATCode" ASC)
    REFERENCES "pears"."IQacVATRate" ("VATCode")
GO