Table of Contents



pears.IQacNominal

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

Description

Nominal Code definitions and behaviour settings

Columns

Column Type Null Default Comment
NominalCode char(12) NOT NULL
NominalType char(1) NOT NULL 'P' <P>&L or <B>S
Name char(50) NOT NULL
NominalGroup char(12) NOT NULL Used for P&L/BS report
LedgerRelationship char(30) NOT NULL LedgerControl, AccountControl, AccountOptional, AccountRequired, NoAccount
LedgerID char(12) NULL
AccountCode char(12) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
NomLedger LedgerID pears.IQacLedger (LedgerID)
NomAccount LedgerID, AccountCode pears.IQacAccount (LedgerID, AccountCode)

Referenced By

Table Constraint Columns Referenced columns
pears.IQacDocumentTemplate IQacNominal VATNominalCode NominalCode
pears.IQacJournal IQacNominal NominalCode NominalCode
pears.IQacParams IQacNominal ReserveNominalCode NominalCode

Indexes

Name Type Columns Detail
IQacNom_Name Unique index Name

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacNominal"
-- Table comment: Nominal Code definitions and behaviour settings
-- Statement count: 8
 
CREATE TABLE "pears"."IQacNominal" (
    "NominalCode"                    CHAR(12) NOT NULL
   ,"NominalType"                    CHAR(1) NOT NULL DEFAULT 'P'
   ,"Name"                           CHAR(50) NOT NULL
   ,"NominalGroup"                   CHAR(12) NOT NULL
   ,"LedgerRelationship"             CHAR(30) NOT NULL
   ,"LedgerID"                       CHAR(12) NULL
   ,"AccountCode"                    CHAR(12) NULL
   ,PRIMARY KEY ("NominalCode" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQacNominal"."NominalType" IS 
	'<P>&L or <B>S'
GO
 
 
COMMENT ON COLUMN "pears"."IQacNominal"."NominalGroup" IS 
	'Used for P&L/BS report'
GO
 
 
COMMENT ON COLUMN "pears"."IQacNominal"."LedgerRelationship" IS 
	'LedgerControl, AccountControl, AccountOptional, AccountRequired, NoAccount'
GO
 
 
COMMENT ON TABLE "pears"."IQacNominal" IS 
	'Nominal Code definitions and behaviour settings'
GO
 
 
ALTER TABLE "pears"."IQacNominal"
    ADD FOREIGN KEY "NomLedger" ("LedgerID" ASC)
    REFERENCES "pears"."IQacLedger" ("LedgerID")
GO
 
 
ALTER TABLE "pears"."IQacNominal"
    ADD FOREIGN KEY "NomAccount" ("LedgerID" ASC,"AccountCode" ASC)
    REFERENCES "pears"."IQacAccount" ("LedgerID","AccountCode")
GO
 
 
CREATE UNIQUE INDEX "IQacNom_Name" ON "pears"."IQacNominal"
    ( "Name" )
GO