Table of Contents



pears.AdhocInvoiceTemplate

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

Description

Save As Template button on AdHoc Invoice

Columns

Column Type Null Default Comment
AdhocInvoiceTemplateID char(20) NOT NULL
Name char(250) NULL
TheirRef char(50) NULL
AttnOf char(100) NULL
Description long varchar NULL
InvOrCredit char(1) NULL
CompOrPlace char(1) NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.AdhocInvoiceTemplateLine AdhocInvoiceTemplate AdhocInvoiceTemplateID AdhocInvoiceTemplateID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AdhocInvoiceTemplate"
-- Table comment: Save As Template button on AdHoc Invoice
-- Statement count: 2
 
CREATE TABLE "pears"."AdhocInvoiceTemplate" (
    "AdhocInvoiceTemplateID"         CHAR(20) NOT NULL
   ,"Name"                           CHAR(250) NULL
   ,"TheirRef"                       CHAR(50) NULL
   ,"AttnOf"                         CHAR(100) NULL
   ,"Description"                    long VARCHAR NULL
   ,"InvOrCredit"                    CHAR(1) NULL
   ,"CompOrPlace"                    CHAR(1) NULL
   ,PRIMARY KEY ("AdhocInvoiceTemplateID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."AdhocInvoiceTemplate" IS 
	'Save As Template button on AdHoc Invoice'
GO