Table of Contents



pears.ExportOptions

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

Description

Stores filesname and paths for payroll and invoice exports

Columns

Column Type Null Default Comment
pk integer NOT NULL
Pay char(20) NULL
PayExportFolder char(255) NULL
PayExportScript char(255) NULL
Perm char(20) NULL
PermExportFolder char(255) NULL
PermExportScript char(255) NULL
ISLSalesInvoice char(20) NULL
ISLExportFolder char(255) NULL
ISLExportScript char(255) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ExportOptions"
-- Table comment: Stores filesname and paths for payroll and invoice exports
-- Statement count: 2
 
CREATE TABLE "pears"."ExportOptions" (
    "pk"                             INTEGER NOT NULL
   ,"Pay"                            CHAR(20) NULL
   ,"PayExportFolder"                CHAR(255) NULL
   ,"PayExportScript"                CHAR(255) NULL
   ,"Perm"                           CHAR(20) NULL
   ,"PermExportFolder"               CHAR(255) NULL
   ,"PermExportScript"               CHAR(255) NULL
   ,"ISLSalesInvoice"                CHAR(20) NULL
   ,"ISLExportFolder"                CHAR(255) NULL
   ,"ISLExportScript"                CHAR(255) NULL
   ,PRIMARY KEY ("pk" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."ExportOptions" IS 
	'Stores filesname and paths for payroll and invoice exports'
GO