pears.TimesheetCancelReason

Lookup of user defined reasons why Timesheet cancelled

• TimesheetCancelReasonID

• No outgoing foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TimesheetCancelReason"
-- Table comment: Lookup of user defined reasons why Timesheet cancelled
-- Statement count: 2
 
CREATE TABLE "pears"."TimesheetCancelReason" (
    "TimesheetCancelReasonID"        CHAR(20) NOT NULL
   ,"Name"                           CHAR(100) NOT NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"Defunct"                        tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("TimesheetCancelReasonID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TimesheetCancelReason" IS 
	'Lookup of user defined reasons why Timesheet cancelled'
GO