Table of Contents



pears.BankModulusValidSortcodes

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

Description

List of sort codes to be excluded from modulus checking.

Columns

Column Type Null Default Comment
sortcode integer NOT NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BankModulusValidSortcodes"
-- Table comment: List of sort codes to be excluded from modulus checking.
-- Statement count: 2
 
CREATE TABLE "pears"."BankModulusValidSortcodes" (
    "sortcode"                       INTEGER NOT NULL
   ,PRIMARY KEY ("sortcode" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BankModulusValidSortcodes" IS 
	'List of sort codes to be excluded from modulus checking.'
GO