Table of Contents



pears.IQacCurrency

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

Description

Currencies used in sales ledger.

Columns

Column Type Null Default Comment
CurrencyCode char(3) NOT NULL
Name char(50) NOT NULL
RatePerHome double NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.IQacCountry IQacCurrency DefaultCurrencyCode CurrencyCode
pears.IQacDocument IQacCurrency CurrencyCode CurrencyCode
pears.IQacParams IQacCurrency CurrencyCode CurrencyCode

Indexes

Name Type Columns Detail
IQacCurr_Name Unique index Name

Triggers

Name Timing Event
WPK_iqaccurrency_CURRENCY after insert,delete,update order 1

Original SQL

-- 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