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
- AdhocInvoiceTemplateID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.AdhocInvoiceTemplateLine | AdhocInvoiceTemplate | AdhocInvoiceTemplateID | AdhocInvoiceTemplateID |
Indexes
- No indexes found.
Triggers
- No triggers found.
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
127.0.0.1