pears.InvoiceManagementGroup

Groups that control the processing of invoices.

• ID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- 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