pears.TempAccordNIReChargeLine

Used in Invoice (switch dependent) to groups accord requests per document

• TempTimeSheetLineID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempAccordNIReChargeLine"
-- Table comment: Used in Invoice (switch dependent) to groups accord requests per document
-- Statement count: 3
 
CREATE TABLE "pears"."TempAccordNIReChargeLine" (
    "TempTimeSheetLineID"            CHAR(20) NOT NULL
   ,"TempTimeSheetID"                CHAR(20) NOT NULL
   ,"NIRecharge"                     DOUBLE NULL
   ,PRIMARY KEY ("TempTimeSheetLineID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TempAccordNIReChargeLine" IS 
	'Used in Invoice (switch dependent) to groups accord requests per document'
GO
 
 
ALTER TABLE "pears"."TempAccordNIReChargeLine"
    ADD NOT NULL FOREIGN KEY "TempTimeSheet" ("TempTimeSheetID" ASC)
    REFERENCES "pears"."TempTimeSheet" ("TempTimeSheetID")
GO