Table of Contents



pears.BanknameSortcode

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

Columns

Column Type Null Default Comment
SortCode char(8) NOT NULL
BankName char(30) NULL
ValidatedAgainst tinyint NULL 0 = Original list, 1=bacs, 2=bankscan.dll, 3=user

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BanknameSortcode"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."BanknameSortcode" (
    "SortCode"                       CHAR(8) NOT NULL
   ,"BankName"                       CHAR(30) NULL
   ,"ValidatedAgainst"               tinyint NULL
   ,PRIMARY KEY ("SortCode" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."BanknameSortcode"."ValidatedAgainst" IS 
	' 0 = Original list, 1=bacs, 2=bankscan.dll, 3=user'
GO