====== pears.InvoiceManagementGroup ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
Groups that control the processing of invoices.
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **ID** | char(1) | NOT NULL | | |
| Name | char(250) | NULL | | |
| ProcessMethod | char(1) | NULL | 0 | 0/null - Standard, 1 No Checking |
===== Primary Key =====
* ID
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
* No incoming foreign keys found.
===== Indexes =====
* No indexes found.
===== Triggers =====
* No triggers found.
===== Original SQL =====
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."InvoiceManagementGroup"
-- Table comment: Groups that control the processing of invoices.
-- Statement count: 3
CREATE TABLE "pears"."InvoiceManagementGroup" (
"ID" char(1) NOT NULL
,"Name" char(250) NULL
,"ProcessMethod" char(1) NULL DEFAULT 0
,PRIMARY KEY ("ID" ASC)
)
go
COMMENT ON COLUMN "pears"."InvoiceManagementGroup"."ProcessMethod" IS
'0/null - Standard, 1 No Checking'
go
COMMENT ON TABLE "pears"."InvoiceManagementGroup" IS
'Groups that control the processing of invoices.'
go