pears.IQacCurrency

Currencies used in sales ledger.

• CurrencyCode

• No outgoing foreign keys found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacCurrency"
-- Table comment: Currencies used in sales ledger.
-- Statement count: 5
 
CREATE TABLE "pears"."IQacCurrency" (
    "CurrencyCode"                   CHAR(3) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"RatePerHome"                    DOUBLE NULL
   ,PRIMARY KEY ("CurrencyCode" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQacCurrency" IS 
	'Currencies used in sales ledger.'
GO
 
 
CREATE UNIQUE INDEX "IQacCurr_Name" ON "pears"."IQacCurrency"
    ( "Name" )
GO
 
 
CREATE TRIGGER "WPK_iqaccurrency_CURRENCY" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."iqaccurrency"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('P','CURRENCY')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."IQacCurrency"."WPK_iqaccurrency_CURRENCY" IS 
{CREATE TRIGGER WPK_iqaccurrency_CURRENCY 
 after INSERT,DELETE,UPDATE ORDER 1 ON
iqaccurrency
FOR each statement
BEGIN
  CALL WPKTrackChange('P','CURRENCY')
END
}
GO