3E:Timcard

USE [TE_3E_BAT27B]
GO

/****** Object:  Table [dbo].[Timecard]    Script Date: 12/06/2013 10:09:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Timecard](
    [TimecardID] [uniqueidentifier] NOT NULL,
    [TimeIndex] [int] IDENTITY(1,1) NOT NULL,
    [OrigTimeIndex] [int] NULL,
    [IsActive] [tinyint] NOT NULL,
    [Office] [nvarchar](16) NOT NULL,
    [WorkDate] [datetime] NOT NULL,
    [PostDate] [datetime] NOT NULL,
    [Currency] [nvarchar](8) NOT NULL,
    [CurrDate] [datetime] NOT NULL,
    [Matter] [int] NOT NULL,
    [BillMatter] [int] NOT NULL,
    [Timekeeper] [int] NOT NULL,
    [WorkMattEffDate] [uniqueidentifier] NOT NULL,
    [BillMattEffDate] [uniqueidentifier] NOT NULL,
    [TkprEffDate] [uniqueidentifier] NOT NULL,
    [IsNB] [tinyint] NOT NULL,
    [ResPct] [decimal](16, 2) NULL,
    [IsNoCharge] [tinyint] NOT NULL,
    [StartTime] [datetime] NULL,
    [TimeInterval] [nvarchar](8) NULL,
    [EntryUnitType] [nvarchar](16) NULL,
    [EntryUnit] [int] NULL,
    [WorkHrs] [decimal](16, 5) NOT NULL,
    [WorkRate] [decimal](16, 4) NOT NULL,
    [WorkAmt] [decimal](16, 2) NOT NULL,
    [ChrgCard] [int] NULL,
    [OrigHrs] [decimal](16, 5) NULL,
    [OrigRate] [decimal](16, 4) NULL,
    [OrigAmt] [decimal](16, 2) NULL,
    [StdCurrency] [nvarchar](8) NULL,
    [StdRate] [decimal](16, 4) NULL,
    [StdAmt] [decimal](16, 2) NULL,
    [Language] [int] NOT NULL,
    [Narrative] [nvarchar](max) NULL,
    [Narrative_UnformattedText] [nvarchar](max) NULL,
    [InternalComments] [nvarchar](255) NULL,
    [TimeType] [nvarchar](16) NOT NULL,
    [TransactionType] [nvarchar](16) NOT NULL,
    [TaxJurisdiction] [nvarchar](16) NULL,
    [Phase] [uniqueidentifier] NULL,
    [Task] [uniqueidentifier] NULL,
    [Activity] [uniqueidentifier] NULL,
    [TaxCode] [nvarchar](16) NULL,
    [EditTranType] [nvarchar](16) NULL,
    [ReasonType] [nvarchar](16) NULL,
    [Disposition] [nvarchar](16) NULL,
    [ProfMaster] [int] NULL,
    [InvMaster] [int] NULL,
    [Voucher] [int] NULL,
    [OrigCurrency] [nvarchar](8) NULL,
    [WorkType] [nvarchar](16) NOT NULL,
    [InputTaxCode] [nvarchar](16) NULL,
    [PurgeType] [nvarchar](16) NULL,
    [WIPRemoveDate] [datetime] NULL,
    [RefCurrency] [nvarchar](8) NULL,
    [RefRate] [decimal](16, 4) NULL,
    [RefAmt] [decimal](16, 2) NULL,
    [UnitCurrRate] [decimal](16, 10) NULL,
    [FirmCurrRate] [decimal](16, 10) NULL,
    [UnitCurrRateStd] [decimal](16, 10) NULL,
    [FirmCurrRateStd] [decimal](16, 10) NULL,
    [WIPHrs] [decimal](16, 5) NULL,
    [WIPRate] [decimal](16, 4) NULL,
    [WIPAmt] [decimal](16, 2) NULL,
    [IsDisplay] [tinyint] NOT NULL,
    [LoadNumber] [nvarchar](64) NULL,
    [LoadSource] [nvarchar](64) NULL,
    [LoadGroup] [nvarchar](64) NULL,
    [RateCalcList] [nvarchar](8) NULL,
    [GLDate] [datetime] NOT NULL,
    [AuthTimekeeper] [int] NULL,
    [SpvTimekeeper] [int] NULL,
    [IsFlatFeeComplete] [tinyint] NOT NULL,
    [IsTaxAdvice] [tinyint] NOT NULL,
    [ParTimeIndex] [int] NULL,
    [UpdateList] [int] NULL,
    [TimePracticeArea] [nvarchar](16) NULL,
    [MatrixTaxCode] [nvarchar](16) NULL,
    [Rpt1CurrRate] [decimal](16, 10) NULL,
    [Rpt2CurrRate] [decimal](16, 10) NULL,
    [Rpt3CurrRate] [decimal](16, 10) NULL,
    [Rpt1CurrRateStd] [decimal](16, 10) NULL,
    [Rpt2CurrRateStd] [decimal](16, 10) NULL,
    [Rpt3CurrRateStd] [decimal](16, 10) NULL,
    [PrevProfMaster] [int] NULL,
    [ArchetypeCode] [nvarchar](50) NOT NULL,
    [CurrProcItemID] [uniqueidentifier] NULL,
    [LastProcItemID] [uniqueidentifier] NULL,
    [OrigProcItemID] [uniqueidentifier] NULL,
    [HasAttachments] [tinyint] NULL,
    [TimeStamp] [datetime] NULL,
    [Notes] [nvarchar](4000) NULL,
    [IsTimer] [tinyint] NOT NULL,
    [ConversionRefNum] [nvarchar](64) NULL,
PRIMARY KEY NONCLUSTERED
(
    [TimecardID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [TBL_APP_LARGE]

GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Activity_@_Activity_@_ActivityID] FOREIGN KEY([Activity])
REFERENCES [dbo].[Activity] ([ActivityID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Activity_@_Activity_@_ActivityID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ChrgCard_@_ChrgCard_@_ChrgCardIndex] FOREIGN KEY([ChrgCard])
REFERENCES [dbo].[ChrgCard] ([ChrgCardIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ChrgCard_@_ChrgCard_@_ChrgCardIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_DispositionList_@_Disposition_@_Code] FOREIGN KEY([Disposition])
REFERENCES [dbo].[DispositionList] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_DispositionList_@_Disposition_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_InvMaster_@_InvMaster_@_InvIndex] FOREIGN KEY([InvMaster])
REFERENCES [dbo].[InvMaster] ([InvIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_InvMaster_@_InvMaster_@_InvIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Language_@_Language_@_Locale] FOREIGN KEY([Language])
REFERENCES [dbo].[Language] ([Locale])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Language_@_Language_@_Locale]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_MattDate_@_BillMattEffDate_@_MattDateID] FOREIGN KEY([BillMattEffDate])
REFERENCES [dbo].[MattDate] ([MattDateID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_MattDate_@_BillMattEffDate_@_MattDateID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_MattDate_@_WorkMattEffDate_@_MattDateID] FOREIGN KEY([WorkMattEffDate])
REFERENCES [dbo].[MattDate] ([MattDateID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_MattDate_@_WorkMattEffDate_@_MattDateID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Matter_@_BillMatter_@_MattIndex] FOREIGN KEY([BillMatter])
REFERENCES [dbo].[Matter] ([MattIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Matter_@_BillMatter_@_MattIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Matter_@_Matter_@_MattIndex] FOREIGN KEY([Matter])
REFERENCES [dbo].[Matter] ([MattIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Matter_@_Matter_@_MattIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_Currency_@_CurrCode] FOREIGN KEY([Currency])
REFERENCES [dbo].[NxCurrencyCode] ([CurrCode])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_Currency_@_CurrCode]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_OrigCurrency_@_CurrCode] FOREIGN KEY([OrigCurrency])
REFERENCES [dbo].[NxCurrencyCode] ([CurrCode])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_OrigCurrency_@_CurrCode]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_RefCurrency_@_CurrCode] FOREIGN KEY([RefCurrency])
REFERENCES [dbo].[NxCurrencyCode] ([CurrCode])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_RefCurrency_@_CurrCode]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_StdCurrency_@_CurrCode] FOREIGN KEY([StdCurrency])
REFERENCES [dbo].[NxCurrencyCode] ([CurrCode])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_NxCurrencyCode_@_StdCurrency_@_CurrCode]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Office_@_Office_@_Code] FOREIGN KEY([Office])
REFERENCES [dbo].[Office] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Office_@_Office_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Phase_@_Phase_@_PhaseID] FOREIGN KEY([Phase])
REFERENCES [dbo].[Phase] ([PhaseID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Phase_@_Phase_@_PhaseID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ProfMaster_@_PrevProfMaster_@_ProfIndex] FOREIGN KEY([PrevProfMaster])
REFERENCES [dbo].[ProfMaster] ([ProfIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ProfMaster_@_PrevProfMaster_@_ProfIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ProfMaster_@_ProfMaster_@_ProfIndex] FOREIGN KEY([ProfMaster])
REFERENCES [dbo].[ProfMaster] ([ProfIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ProfMaster_@_ProfMaster_@_ProfIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_PurgeType_@_PurgeType_@_Code] FOREIGN KEY([PurgeType])
REFERENCES [dbo].[PurgeType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_PurgeType_@_PurgeType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_RateCalcList_@_RateCalcList_@_Code] FOREIGN KEY([RateCalcList])
REFERENCES [dbo].[RateCalcList] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_RateCalcList_@_RateCalcList_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ReasonType_@_ReasonType_@_Code] FOREIGN KEY([ReasonType])
REFERENCES [dbo].[ReasonType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_ReasonType_@_ReasonType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Task_@_Task_@_TaskID] FOREIGN KEY([Task])
REFERENCES [dbo].[Task] ([TaskID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Task_@_Task_@_TaskID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_InputTaxCode_@_Code] FOREIGN KEY([InputTaxCode])
REFERENCES [dbo].[TaxCode] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_InputTaxCode_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_MatrixTaxCode_@_Code] FOREIGN KEY([MatrixTaxCode])
REFERENCES [dbo].[TaxCode] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_MatrixTaxCode_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_TaxCode_@_Code] FOREIGN KEY([TaxCode])
REFERENCES [dbo].[TaxCode] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxCode_@_TaxCode_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxJurisdiction_@_TaxJurisdiction_@_Code] FOREIGN KEY([TaxJurisdiction])
REFERENCES [dbo].[TaxJurisdiction] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TaxJurisdiction_@_TaxJurisdiction_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timecard_@_OrigTimeIndex_@_TimeIndex] FOREIGN KEY([OrigTimeIndex])
REFERENCES [dbo].[Timecard] ([TimeIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timecard_@_OrigTimeIndex_@_TimeIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timecard_@_ParTimeIndex_@_TimeIndex] FOREIGN KEY([ParTimeIndex])
REFERENCES [dbo].[Timecard] ([TimeIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timecard_@_ParTimeIndex_@_TimeIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeCardUpdateList_@_UpdateList_@_TimeCardUpdateListIndex] FOREIGN KEY([UpdateList])
REFERENCES [dbo].[TimeCardUpdateList] ([TimeCardUpdateListIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeCardUpdateList_@_UpdateList_@_TimeCardUpdateListIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeEntryUnit_@_EntryUnitType_@_Code] FOREIGN KEY([EntryUnitType])
REFERENCES [dbo].[TimeEntryUnit] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeEntryUnit_@_EntryUnitType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_AuthTimekeeper_@_TkprIndex] FOREIGN KEY([AuthTimekeeper])
REFERENCES [dbo].[Timekeeper] ([TkprIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_AuthTimekeeper_@_TkprIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_SpvTimekeeper_@_TkprIndex] FOREIGN KEY([SpvTimekeeper])
REFERENCES [dbo].[Timekeeper] ([TkprIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_SpvTimekeeper_@_TkprIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_Timekeeper_@_TkprIndex] FOREIGN KEY([Timekeeper])
REFERENCES [dbo].[Timekeeper] ([TkprIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Timekeeper_@_Timekeeper_@_TkprIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimePracticeArea_@_TimePracticeArea_@_Code] FOREIGN KEY([TimePracticeArea])
REFERENCES [dbo].[TimePracticeArea] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimePracticeArea_@_TimePracticeArea_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeType_@_TimeType_@_Code] FOREIGN KEY([TimeType])
REFERENCES [dbo].[TimeType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TimeType_@_TimeType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TkprDate_@_TkprEffDate_@_TkprDateID] FOREIGN KEY([TkprEffDate])
REFERENCES [dbo].[TkprDate] ([TkprDateID])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TkprDate_@_TkprEffDate_@_TkprDateID]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TransactionType_@_EditTranType_@_Code] FOREIGN KEY([EditTranType])
REFERENCES [dbo].[TransactionType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TransactionType_@_EditTranType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TransactionType_@_TransactionType_@_Code] FOREIGN KEY([TransactionType])
REFERENCES [dbo].[TransactionType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_TransactionType_@_TransactionType_@_Code]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Voucher_@_Voucher_@_VchrIndex] FOREIGN KEY([Voucher])
REFERENCES [dbo].[Voucher] ([VchrIndex])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_Voucher_@_Voucher_@_VchrIndex]
GO

ALTER TABLE [dbo].[Timecard]  WITH CHECK ADD  CONSTRAINT [FK_CONSTRAINT_NX_Timecard_WorkType_@_WorkType_@_Code] FOREIGN KEY([WorkType])
REFERENCES [dbo].[WorkType] ([Code])
GO

ALTER TABLE [dbo].[Timecard] CHECK CONSTRAINT [FK_CONSTRAINT_NX_Timecard_WorkType_@_WorkType_@_Code]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((1)) FOR [IsActive]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [IsNB]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [IsNoCharge]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((1)) FOR [IsDisplay]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [IsFlatFeeComplete]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [IsTaxAdvice]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [HasAttachments]
GO

ALTER TABLE [dbo].[Timecard] ADD  DEFAULT ((0)) FOR [IsTimer]
GO