Table of Contents



pears.IQacPaymentMethod

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

Description

Cash, BACS etc

Columns

Column Type Null Default Comment
PaymentMethodCode char(3) NOT NULL
Name char(50) NOT NULL
Card smallint NULL 0
DocumentTemplateID char(12) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
IQacDocumentTemplate DocumentTemplateID pears.IQacDocumentTemplate (DocumentTemplateID)

Referenced By

Table Constraint Columns Referenced columns
pears.IQacParams IQacPaymentMethod DefaultPaymentMethod PaymentMethodCode

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQacPaymentMethod"
-- Table comment: Cash, BACS etc
-- Statement count: 3
 
CREATE TABLE "pears"."IQacPaymentMethod" (
    "PaymentMethodCode"              CHAR(3) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"Card"                           SMALLINT NULL DEFAULT 0
   ,"DocumentTemplateID"             CHAR(12) NULL
   ,PRIMARY KEY ("PaymentMethodCode" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQacPaymentMethod" IS 
	'Cash, BACS etc'
GO
 
 
ALTER TABLE "pears"."IQacPaymentMethod"
    ADD FOREIGN KEY "IQacDocumentTemplate" ("DocumentTemplateID" ASC)
    REFERENCES "pears"."IQacDocumentTemplate" ("DocumentTemplateID")
GO