pears.IQacLedger

Ledger type cash/sales

• LedgerID

• No outgoing foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacLedger"
-- Table comment: Ledger type cash/sales
-- Statement count: 4
 
CREATE TABLE "pears"."IQacLedger" (
    "LedgerID"                       CHAR(12) NOT NULL
   ,"LedgerType"                     CHAR(30) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,PRIMARY KEY ("LedgerID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQacLedger"."LedgerType" IS 
	'Sales, Purchase, Cash, Employee, Asset, Other'
GO
 
 
COMMENT ON TABLE "pears"."IQacLedger" IS 
	'Ledger type cash/sales'
GO
 
 
CREATE UNIQUE INDEX "IQacLedger_Name" ON "pears"."IQacLedger"
    ( "Name" )
GO