use keyhouse CREATE TABLE [dbo].[ALLBANKS] ( [NSC] [float] NULL , [BANK] [varchar] (255) NULL , [BRANCH] [varchar] (255) NULL , [Address 1] [varchar] (255) NULL , [Address 2] [varchar] (255) NULL , [Address 3] [varchar] (255) NULL , [Address 4] [varchar] (255) NULL , [KEYWORDS] [varchar] (255) NULL , [TELEPHONE] [varchar] (255) NULL , [FAX] [varchar] (255) NULL , [ATM] [varchar] (255) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Accruals] ( [NOMINALFROM] [char] (10) NULL , [NOMINALTO] [char] (10) NULL , [DESCRIPTION] [char] (40) NULL , [VALUE] [decimal](13, 2) NULL , [VALUEYTD] [decimal](13, 2) NULL , [PERIOD] [smallint] NULL , [INSTRUCTIONS] [text] NULL , [RecordId] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[ActionWorkTypes] ( [WORKTYPE] [char] (4) NOT NULL , [ACTIONCODE] [char] (15) NOT NULL , [SEQ] [decimal](13, 0) NULL , [ForCopy] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Allocations] ( [BATCHNO] [int] NULL , [PREF] [int] NULL , [DATE] [datetime] NULL , [ABATCHNO] [int] NULL , [OPREF] [int] NULL , [OREF] [char] (10) NULL , [VALUE] [decimal](17, 2) NULL , [FEES] [decimal](17, 2) NULL , [OUTLAY] [decimal](17, 2) NULL , [VAT] [decimal](17, 2) NULL , [USERCODE] [char] (8) NULL , [AllNo] [int] NULL , [VATCODE] [char] (1) NULL , [KEYID] [decimal](7, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[AssociateCategory] ( [Category] [char] (50) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[AssociateTypes] ( [CODE] [char] (12) NOT NULL , [DESCRIPTION] [char] (50) NULL , [ASSOCIATETYPE] [char] (1) NULL , [Category] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankRecClearDown] ( [BANKACC] [char] (10) NULL , [DATE] [datetime] NULL , [PREF] [int] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankRecCompleteTrans] ( [BANKAC] [char] (10) NOT NULL , [TYPE] [char] (1) NOT NULL , [DATE] [datetime] NULL , [REF] [char] (8) NOT NULL , [BATCH] [int] NOT NULL , [PREF] [int] NOT NULL , [NARR] [char] (60) NULL , [VALUE] [decimal](17, 2) NULL , [OSRECNO] [decimal](5, 0) NULL , [RECNO] [decimal](5, 0) NOT NULL , [TICKED] [char] (1) NULL , [RECORDID] [int] IDENTITY (1, 1) NOT NULL , [NomTransId] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankRecHistory] ( [RECNO] [decimal](5, 0) NOT NULL , [BANKAC] [char] (10) NOT NULL , [RECDATE] [datetime] NULL , [DATECOMPLETE] [datetime] NULL , [LASTREC] [int] NULL , [CURRENCY] [char] (1) NULL , [OPENINGBALANCE] [decimal](17, 2) NULL , [LODGEMENTS] [decimal](17, 2) NULL , [CHEQUES] [decimal](17, 2) NULL , [OSLODGEMENTS] [decimal](17, 2) NULL , [OSCHEQUES] [decimal](17, 2) NULL , [BANKBAL] [decimal](17, 2) NULL , [CLOSINGBAL] [decimal](17, 2) NULL , [DIFF] [decimal](17, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankRecOutstandingTrans] ( [BANKAC] [char] (10) NOT NULL , [TYPE] [char] (1) NULL , [DATE] [datetime] NULL , [REF] [char] (8) NULL , [BATCH] [int] NOT NULL , [PREF] [int] NOT NULL , [NARR] [char] (60) NULL , [VALUE] [decimal](17, 2) NULL , [RECNO] [decimal](5, 0) NOT NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankRecTransactions] ( [BANKAC] [char] (10) NOT NULL , [TYPE] [char] (1) NULL , [DATE] [datetime] NULL , [REF] [char] (8) NULL , [BATCH] [int] NULL , [PREF] [int] NULL , [NARR] [char] (60) NULL , [VALUE] [decimal](17, 2) NULL , [OSRECNO] [decimal](5, 0) NULL , [RECNO] [decimal](5, 0) NULL , [TICKED] [char] (1) NULL , [RECORDID] [int] IDENTITY (1, 1) NOT NULL , [NomTransId] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BankTally] ( [BANK] [char] (10) NULL , [AMOUNT] [decimal](11, 2) NULL , [FROMDATE] [datetime] NULL , [TODATE] [datetime] NULL , [RATE] [decimal](7, 2) NULL , [DIRT] [decimal](11, 2) NULL , [RESULT] [decimal](11, 2) NULL , [TOTAL] [decimal](11, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BatchDetails] ( [BATCHNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [CODE] [char] (10) NULL , [PREF] [int] NULL , [REF] [char] (10) NULL , [DATE] [datetime] NULL , [FEE] [char] (3) NULL , [BRANCH] [char] (1) NULL , [NARR] [char] (100) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [VALUE] [decimal](17, 2) NULL , [VATCODE] [char] (1) NULL , [VATVAL] [decimal](17, 2) NULL , [CLIENTYN] [char] (1) NULL , [OUTLAY] [char] (1) NULL , [PENDING] [char] (1) NULL , [YEAR] [smallint] NULL , [PERNO] [smallint] NULL , [ENTRYCURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CURRENCYVAT] [decimal](17, 2) NULL , [OUTLAYCODE] [char] (4) NULL , [THIRDPARTY] [char] (1) NULL , [PAYEE] [char] (60) NULL , [HEADPREF] [int] NULL , [HEADBATCH] [int] NULL , [ALLOCBATCH] [int] NULL , [ALLOCPREF] [int] NULL , [ALLOCREF] [char] (10) NULL , [ALLOCVALUE] [decimal](17, 2) NULL , [ALLOCWRITEOFF] [char] (1) NULL , [PSUPP] [char] (10) NULL , [UNDETAKING] [smallint] NULL , [KEYID] [decimal](9, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BatchH] ( [BATCHNO] [int] NOT NULL , [POSTFWD] [char] (1) NULL , [TYPE] [char] (1) NULL , [CODE] [char] (10) NULL , [BRANCH] [char] (1) NULL , [PREF] [int] NULL , [REF] [char] (10) NULL , [DATE] [datetime] NULL , [FEE] [char] (3) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [NARR] [char] (150) NULL , [VALUE] [decimal](17, 2) NULL , [SUBTOT] [decimal](17, 2) NULL , [POSTED] [char] (1) NULL , [CLIENTAC] [char] (1) NULL , [PERNO] [smallint] NULL , [YEAR] [smallint] NULL , [PAYEE] [char] (60) NULL , [OUTLAYTOT] [decimal](17, 2) NULL , [VATTOT] [decimal](17, 2) NULL , [FEETOT] [decimal](17, 2) NULL , [INVCR] [char] (1) NULL , [THIRDPARTY] [char] (1) NULL , [USERCODE] [char] (8) NULL , [ENTRYDATE] [datetime] NULL , [CLIENTBANK] [char] (10) NULL , [CURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CUROUTLAYTOT] [decimal](17, 2) NULL , [CURVATTOT] [decimal](17, 2) NULL , [CURFEETOT] [decimal](17, 2) NULL , [RECNO] [int] NULL , [SINGLELINE] [char] (1) NULL , [TEMPLATE] [char] (10) NULL , [CHEQUEREQNO] [int] NULL , [WRITEDOWN] [datetime] NULL , [WRITEBACKHOURS] [decimal](7, 2) NULL , [WRITEBACKVALUE] [decimal](13, 2) NULL , [CORRECTCOPY] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BillDescriptions] ( [NUMBER] [int] IDENTITY (1, 1) NOT NULL , [BILLDESCRIPTIONS] [text] NULL , [SEARCHFIELD] [char] (20) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[BillDetails] ( [MATTER] [char] (11) NULL , [DRAFTNO] [int] NULL , [BILLNO] [int] NULL , [TYPE] [char] (1) NULL , [FEEEARNER] [char] (3) NULL , [NOMINAL] [char] (10) NULL , [NARRATIVE] [varchar] (6999) NULL , [NET] [decimal](13, 2) NULL , [VATCODE] [char] (1) NULL , [VATRATE] [decimal](5, 2) NULL , [VATVALUE] [decimal](13, 2) NULL , [LINENO] [smallint] NULL , [KEYID] [decimal](10, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BillFeeBreakDown] ( [MATTER] [char] (11) NOT NULL , [DRAFTNO] [int] NOT NULL , [BILLNO] [int] NOT NULL , [FECODE] [char] (3) NULL , [TYPE] [char] (1) NULL , [PERCENT] [decimal](5, 2) NULL , [CALCULATION] [decimal](9, 5) NULL , [VALUE] [decimal](11, 2) NULL , [VATCODE] [char] (1) NULL , [VATAMT] [decimal](11, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BillHeader] ( [MATTER] [char] (11) NOT NULL , [DRAFTNO] [int] NOT NULL , [DATE] [datetime] NULL , [USER] [char] (8) NULL , [ADDRESSEE] [char] (400) NULL , [INVCR] [char] (1) NULL , [BILLNO] [int] NULL , [OURREF] [char] (15) NULL , [YOURREF] [char] (20) NULL , [TOTAL] [decimal](17, 2) NULL , [FEES] [decimal](17, 2) NULL , [OUTLAY] [decimal](17, 2) NULL , [TOTALVAT] [decimal](17, 2) NULL , [FEEVATCODE] [char] (1) NULL , [NET0] [decimal](17, 2) NULL , [RATE1] [decimal](17, 2) NULL , [NETRATE1] [decimal](17, 2) NULL , [VATRATE1] [decimal](17, 2) NULL , [RATE2] [decimal](17, 2) NULL , [NETRATE2] [decimal](17, 2) NULL , [VATRATE2] [decimal](17, 2) NULL , [RATE3] [decimal](17, 2) NULL , [NETRATE3] [decimal](17, 2) NULL , [VATRATE3] [decimal](17, 2) NULL , [RELEASED] [char] (1) NULL , [RETURNREASON] [char] (100) NULL , [MATTERDESCRIPTION] [char] (120) NULL , [TRANSFER] [char] (1) NULL , [WRITEDOWN] [datetime] NULL , [WRITEBACKHOURS] [decimal](7, 2) NULL , [WRITEBACKVALUE] [decimal](13, 2) NULL , [ACTIONID] [decimal](15, 2) NULL , [OPENINVOICE] [char] (1) NULL , [BATCHNO] [int] NULL , [FEMISCTOTAL] [decimal](13, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Branch] ( [BRANCHCODE] [char] (1) NOT NULL , [DESCRIPTION] [char] (40) NULL , [DEBTORSCTRL] [char] (10) NULL , [CREDITORSCTRL] [char] (10) NULL , [OUTLAYCTRL] [char] (10) NULL , [VATCTRL] [char] (10) NULL , [PANDL] [char] (10) NULL , [CLIENTLEDCTRL] [char] (10) NULL , [FEESWO] [char] (10) NULL , [OUTLAYWO] [char] (10) NULL , [PURCHBILLSWO] [char] (10) NULL , [DEFOFFICE] [char] (10) NULL , [DEFCLIENT] [char] (10) NULL , [DEFCLDEPOSIT] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BranchLocation] ( [BRANCHNO] [int] NOT NULL , [ServerName] [char] (100) NULL , [DatabaseName] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BranchNominals] ( [CODE] [char] (10) NOT NULL , [BRANCH] [char] (1) NOT NULL , [DESC] [char] (30) NULL , [CONSOLIDATETO] [char] (10) NULL , [TYPE] [char] (6) NOT NULL , [PB] [char] (1) NOT NULL , [BALANCE] [decimal](17, 2) NULL , [CURRENCYBAL] [decimal](17, 2) NULL , [BALANCEFWD] [decimal](17, 2) NULL , [CURRENCYBALFWD] [decimal](17, 2) NULL , [CURRENCY] [char] (1) NULL , [SEQ] [char] (4) NOT NULL , [MONTH1] [decimal](17, 2) NULL , [MONTH2] [decimal](17, 2) NULL , [MONTH3] [decimal](17, 2) NULL , [MONTH4] [decimal](17, 2) NULL , [MONTH5] [decimal](17, 2) NULL , [MONTH6] [decimal](17, 2) NULL , [MONTH7] [decimal](17, 2) NULL , [MONTH8] [decimal](17, 2) NULL , [MONTH9] [decimal](17, 2) NULL , [MONTH10] [decimal](17, 2) NULL , [MONTH11] [decimal](17, 2) NULL , [MONTH12] [decimal](17, 2) NULL , [BUDGET1] [decimal](17, 2) NULL , [BUDGET2] [decimal](17, 2) NULL , [BUDGET3] [decimal](17, 2) NULL , [BUDGET4] [decimal](17, 2) NULL , [BUDGET5] [decimal](17, 2) NULL , [BUDGET6] [decimal](17, 2) NULL , [BUDGET7] [decimal](17, 2) NULL , [BUDGET8] [decimal](17, 2) NULL , [BUDGET9] [decimal](17, 2) NULL , [BUDGET10] [decimal](17, 2) NULL , [BUDGET11] [decimal](17, 2) NULL , [BUDGET12] [decimal](17, 2) NULL , [LASTYEAR1] [decimal](17, 2) NULL , [LASTYEAR2] [decimal](17, 2) NULL , [LASTYEAR3] [decimal](17, 2) NULL , [LASTYEAR4] [decimal](17, 2) NULL , [LASTYEAR5] [decimal](17, 2) NULL , [LASTYEAR6] [decimal](17, 2) NULL , [LASTYEAR7] [decimal](17, 2) NULL , [LASTYEAR8] [decimal](17, 2) NULL , [LASTYEAR9] [decimal](17, 2) NULL , [LASTYEAR10] [decimal](17, 2) NULL , [LASTYEAR11] [decimal](17, 2) NULL , [LASTYEAR12] [decimal](17, 2) NULL , [LASTNO] [decimal](9, 0) NULL , [CLIENTAC] [char] (1) NULL , [CHEQUEPRINTER] [char] (40) NULL , [DEPOSITYN] [char] (1) NULL , [DEPOSITTYPE] [char] (4) NULL , [ACCRUAL] [decimal](13, 2) NULL , [SORTCODE] [char] (10) NULL , [BANK] [char] (40) NULL , [BANKBRANCH] [char] (40) NULL , [ACCOUNTNO] [char] (10) NULL , [ACCOUNTNAME] [char] (50) NULL , [BANKADDRESS] [char] (120) NULL , [BANKPHONE] [char] (20) NULL , [WITHDRAWNAMES] [char] (255) NULL , [ACOPENED] [datetime] NULL , [ACCLOSED] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Calendar] ( [CALDATE] [datetime] NOT NULL , [CALREASON] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseAssociatesContacts] ( [NAMECODE] [char] (6) NULL , [KEYID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [NAME] [char] (100) NULL , [SALUTATION] [char] (100) NULL , [JOBTITLE] [char] (100) NULL , [ADDRESS] [char] (200) NULL , [PHONE] [char] (30) NULL , [FAX] [char] (30) NULL , [MOBILE] [char] (30) NULL , [EMAIL] [char] (100) NULL , [RELATIONSHIP] [char] (20) NULL , [NOTES] [char] (200) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseAssociatesNames] ( [CODE] [char] (6) NOT NULL , [TYPE] [char] (12) NULL , [NAME] [char] (80) NULL , [SALUTATION] [char] (30) NULL , [TITLE] [char] (50) NULL , [COMPANY] [char] (80) NULL , [ADDRESS] [char] (200) NULL , [FORENAME] [char] (30) NULL , [SURNAME] [char] (40) NULL , [PHONENO] [char] (20) NULL , [FAXNO] [char] (20) NULL , [HOME] [char] (20) NULL , [MOBILENO] [char] (20) NULL , [EMAIL] [char] (100) NULL , [WEBADDRESS] [char] (150) NULL , [SSNUMBER] [char] (20) NULL , [LEGALNAME] [char] (150) NULL , [LEGALADDRESS] [char] (200) NULL , [COURTNO] [smallint] NULL , [COURTAREA] [char] (50) NULL , [TAX] [char] (1) NULL , [DXREF] [char] (30) NULL , [DOB] [datetime] NULL , [MARTIALSTATUS] [char] (20) NULL , [MARRIAGEDATE] [datetime] NULL , [DECEASED] [char] (1) NULL , [SEPARATED] [char] (3) NULL , [HOWSEPARATED] [char] (10) NULL , [DATESEPARATED] [datetime] NULL , [DECEASEDDATE] [datetime] NULL , [OCCUPATION] [char] (100) NULL , [SEARCH] [char] (10) NULL , [CONTACTNO] [decimal](9, 0) NULL , [NOTES] [char] (6000) NULL , [Area] [char] (15) NULL , [Town] [char] (20) NULL , [Gender] [char] (20) NULL , [AddressType] [char] (1) NULL , [ServiceType] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseAssoicatesTypes] ( [NAMECODE] [char] (6) NOT NULL , [TYPECODE] [char] (12) NOT NULL , [SEARCHCODE] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseContacts] ( [CASECODE] [char] (11) NOT NULL , [CONTYPE] [char] (12) NOT NULL , [CONNUM] [smallint] NOT NULL , [NAMECODE] [char] (6) NULL , [SOLCODE] [char] (6) NULL , [SOLREF] [char] (50) NULL , [INSCODE] [char] (6) NULL , [INSREF] [char] (20) NULL , [COURTRECORDNO] [char] (20) NULL , [HEARINGDATE] [datetime] NULL , [TIME] [char] (10) NULL , [Relationship] [char] (40) NULL , [Nominated] [bit] NULL , [AssignedContact] [decimal](18, 0) NULL , [ForCopy] [char] (1) NULL , [CivilSumSDate] [datetime] NULL , [CivilBillSDate] [datetime] NULL , [SSumSDate] [datetime] NULL , [InstOrdSDate] [datetime] NULL , [ComOrdSDate] [datetime] NULL , [WarrantIssDate] [datetime] NULL , [SumAttSerDate] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseMaster] ( [CSCODE] [char] (11) NOT NULL , [CSCLIENTCDE] [char] (6) NULL , [CSFNR] [char] (6) NULL , [CSDESC] [char] (50) NULL , [CSINSTYN] [char] (1) NULL , [CSDATEENTERED_DATE] [datetime] NULL , [CSPLAINTNO] [char] (12) NULL , [CSWARRANT] [char] (12) NULL , [CSCLEXEYN] [char] (1) NULL , [CSCLBENYN] [char] (1) NULL , [CSLEDGREF] [char] (12) NULL , [CSPFILEREF] [char] (20) NULL , [CSWKTCODE] [char] (4) NULL , [CSCRTCODE] [char] (3) NULL , [CSAGYCODE] [char] (3) NULL , [CSGENAGYCODE] [char] (3) NULL , [CSBSCCODE] [char] (3) NULL , [CSBNKCODE] [char] (3) NULL , [CSLRGCODE] [char] (3) NULL , [CSDRGCODE] [char] (3) NULL , [CSHCTCODE] [char] (3) NULL , [CSSHFCODE] [char] (3) NULL , [CSLAUTHCODE] [char] (3) NULL , [CSIRTCODE] [char] (3) NULL , [CSSTACODE] [char] (3) NULL , [CSISSFEECODE] [char] (3) NULL , [CSJUDFEECODE] [char] (3) NULL , [CSINTADD] [decimal](7, 2) NULL , [CSCOMPTIME] [smallint] NULL , [CSCOMPUNIT] [char] (1) NULL , [CSCONTRATE] [decimal](7, 2) NULL , [CSDAILYRATE] [decimal](7, 2) NULL , [CSNODTR] [smallint] NULL , [CSNOGTR] [smallint] NULL , [CSNOPTF] [smallint] NULL , [CSNOPLC] [smallint] NULL , [CSNODOC] [smallint] NULL , [CSNOSPL] [smallint] NULL , [CSNOBEN] [smallint] NULL , [CSPREMISES] [char] (80) NULL , [CSSOLTRDNAME] [char] (50) NULL , [CSSOLTRDADDR] [char] (80) NULL , [CSSOLTEL] [char] (20) NULL , [CSSOLFAX] [char] (20) NULL , [CSSOLSALUTE] [char] (15) NULL , [CSSOLDXNO] [char] (20) NULL , [CSSOLEMAIL] [char] (50) NULL , [CSDATESERVICE_DATE] [datetime] NULL , [CSDATEINSTSTART_DATE] [datetime] NULL , [CSINSTTOTAL] [decimal](7, 2) NULL , [CSINSTAMT] [decimal](7, 2) NULL , [CSINSTFREQ] [smallint] NULL , [CSINSTUNIT] [char] (1) NULL , [CSLASTACN] [char] (3) NULL , [CSDATELASTACN_DATE] [datetime] NULL , [CSNEXTACN] [char] (3) NULL , [CSDATENEXTACN_DATE] [datetime] NULL , [CSDATEISSUE_DATE] [datetime] NULL , [CSDATERETURN_DATE] [datetime] NULL , [CSDATEMOTION_DATE] [datetime] NULL , [CSDATEHEARING_DATE] [datetime] NULL , [CSDATEJDGT_DATE] [datetime] NULL , [CSDATEEXCHG_DATE] [datetime] NULL , [CSDATECLOSE_DATE] [datetime] NULL , [CSDATECOMPLETION_DATE] [datetime] NULL , [CSDATEREGIST_DATE] [datetime] NULL , [CSDATEACCEPT_DATE] [datetime] NULL , [CSDATESOL_DATE] [datetime] NULL , [CSDATEFIRSTINV_DATE] [datetime] NULL , [CSDATELASTINV_DATE] [datetime] NULL , [CSDATELASTPAY_DATE] [datetime] NULL , [CSFIRSTINVAMT] [decimal](7, 2) NULL , [CSORGDEBT] [decimal](7, 2) NULL , [CSBALDEBT] [decimal](7, 2) NULL , [CSBALCLIENT] [decimal](7, 2) NULL , [CSCOSTISSUE] [decimal](7, 2) NULL , [CSCOSTJDGT] [decimal](7, 2) NULL , [CSCOSTENF] [decimal](7, 2) NULL , [CSFEEISSUE] [decimal](7, 2) NULL , [CSFEEJDGT] [decimal](7, 2) NULL , [CSFEEENF] [decimal](7, 2) NULL , [CSINTISSUE] [decimal](7, 2) NULL , [CSINTJDGT] [decimal](7, 2) NULL , [CSINTENF] [datetime] NULL , [CSCLAUSE1] [char] (6) NULL , [CSCLAUSE2] [char] (6) NULL , [CSCLAUSE3] [char] (6) NULL , [CSCLAUSE4] [char] (6) NULL , [CSCLAUSE5] [char] (6) NULL , [CSCLAUSE6] [char] (3) NULL , [CSCLAUSE7] [char] (3) NULL , [CSCLAUSE8] [char] (3) NULL , [CSCLAUSE9] [char] (3) NULL , [CSCLAUSE10] [char] (3) NULL , [CSSOLREF] [char] (15) NULL , [CSFILENUM] [char] (4) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseMasterClosed] ( [CSCODE] [char] (11) NOT NULL , [FILENUM] [int] NOT NULL , [CSCLIENTCDE] [char] (6) NULL , [CSFNR] [char] (6) NULL , [CSDESC] [char] (50) NULL , [CSINSTYN] [char] (1) NULL , [CSDATEENTERED] [datetime] NULL , [CSPLAINTNO] [char] (12) NULL , [CSWARRANT] [char] (12) NULL , [CSCLEXEYN] [char] (1) NULL , [CSCLBENYN] [char] (1) NULL , [CSLEDGREF] [char] (12) NULL , [CSPFILEREF] [char] (20) NULL , [CSWKTCODE] [char] (4) NULL , [CSCRTCODE] [char] (3) NULL , [CSAGYCODE] [char] (3) NULL , [CSGENAGYCODE] [char] (3) NULL , [CSBSCCODE] [char] (3) NULL , [CSBNKCODE] [char] (3) NULL , [CSLRGCODE] [char] (3) NULL , [CSDRGCODE] [char] (3) NULL , [CSHCTCODE] [char] (3) NULL , [CSSHFCODE] [char] (3) NULL , [CSLAUTHCODE] [char] (3) NULL , [CSIRTCODE] [char] (3) NULL , [CSSTACODE] [char] (3) NULL , [CSISSFEECODE] [char] (3) NULL , [CSJUDFEECODE] [char] (3) NULL , [CSINTADD] [decimal](9, 2) NULL , [CSCOMPTIME] [smallint] NULL , [CSCOMPUNIT] [char] (1) NULL , [CSCONTRATE] [decimal](9, 2) NULL , [CSDAILYRATE] [decimal](9, 2) NULL , [CSNODTR] [smallint] NULL , [CSNOGTR] [smallint] NULL , [CSNOPTF] [smallint] NULL , [CSNOPLC] [smallint] NULL , [CSNODOC] [smallint] NULL , [CSNOSPL] [smallint] NULL , [CSNOBEN] [smallint] NULL , [CSPREMISES] [char] (80) NULL , [CSSOLTRDNAME] [char] (50) NULL , [CSSOLTRDADDR] [char] (80) NULL , [CSSOLTEL] [char] (20) NULL , [CSSOLFAX] [char] (20) NULL , [CSSOLSALUTE] [char] (15) NULL , [CSSOLDXNO] [char] (20) NULL , [CSSOLEMAIL] [char] (50) NULL , [CSDATESERVICE] [datetime] NULL , [CSDATEINSTSTART] [datetime] NULL , [CSINSTTOTAL] [decimal](9, 2) NULL , [CSINSTAMT] [decimal](9, 2) NULL , [CSINSTFREQ] [smallint] NULL , [CSINSTUNIT] [char] (1) NULL , [CSLASTACN] [char] (3) NULL , [CSDATELASTACN] [datetime] NULL , [CSNEXTACN] [char] (3) NULL , [CSDATENEXTACN] [datetime] NULL , [CSDATEISSUE] [datetime] NULL , [CSDATERETURN] [datetime] NULL , [CSDATEMOTION] [datetime] NULL , [CSDATEHEARING] [datetime] NULL , [CSDATEJDGT] [datetime] NULL , [CSDATEEXCHG] [datetime] NULL , [CSDATECLOSE] [datetime] NULL , [CSDATECOMPLETION] [datetime] NULL , [CSDATEREGIST] [datetime] NULL , [CSDATEACCEPT] [datetime] NULL , [CSDATESOL] [datetime] NULL , [CSDATEFIRSTINV] [datetime] NULL , [CSDATELASTINV] [datetime] NULL , [CSDATELASTPAY] [datetime] NULL , [CSFIRSTINVAMT] [decimal](9, 2) NULL , [CSORGDEBT] [decimal](9, 2) NULL , [CSBALDEBT] [decimal](9, 2) NULL , [CSBALCLIENT] [decimal](9, 2) NULL , [CSCOSTISSUE] [decimal](9, 2) NULL , [CSCOSTJDGT] [decimal](9, 2) NULL , [CSCOSTENF] [decimal](9, 2) NULL , [CSFEEISSUE] [decimal](9, 2) NULL , [CSFEEJDGT] [decimal](9, 2) NULL , [CSFEEENF] [decimal](9, 2) NULL , [CSINTISSUE] [decimal](9, 2) NULL , [CSINTJDGT] [decimal](9, 2) NULL , [CSINTENF] [decimal](9, 2) NULL , [CSCLAUSE1] [char] (6) NULL , [CSCLAUSE2] [char] (6) NULL , [CSCLAUSE3] [char] (6) NULL , [CSCLAUSE4] [char] (6) NULL , [CSCLAUSE5] [char] (6) NULL , [CSCLAUSE6] [char] (3) NULL , [CSCLAUSE7] [char] (3) NULL , [CSCLAUSE8] [char] (3) NULL , [CSCLAUSE9] [char] (3) NULL , [CSCLAUSE10] [char] (3) NULL , [CSSOLREF] [char] (15) NULL , [CSFILENUM] [char] (4) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CasePlanCodes] ( [CPCODE] [char] (10) NOT NULL , [CPDESC] [char] (80) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseTeams] ( [TEAMCODE] [char] (3) NOT NULL , [TEAMDESC] [char] (50) NULL , [TEAMLEADER] [char] (80) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CaseUDFAnswers] ( [CASECODE] [char] (11) NOT NULL , [UDFFILE] [char] (5) NOT NULL , [UDFNAME] [char] (20) NOT NULL , [SEQNO] [smallint] NULL , [DateValue] [datetime] NULL , [NumberValue] [decimal](18, 0) NULL , [ForCopy] [char] (1) NULL , [TEXT1] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Category] ( [CatType] [char] (6) NOT NULL , [Code] [char] (10) NOT NULL , [Desc$] [char] (30) NOT NULL , [Prompt1] [char] (20) NULL , [Prompt2] [char] (20) NULL , [Prompt3] [char] (20) NULL , [Prompt4] [char] (20) NULL , [Prompt5] [char] (20) NULL , [Prompt6] [char] (20) NULL , [Prompt7] [char] (20) NULL , [Prompt8] [char] (20) NULL , [Prompt9] [char] (20) NULL , [Prompt10] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CategoryType] ( [CategoryType] [char] (6) NOT NULL , [Description] [char] (30) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChargeArrangements] ( [CODE] [char] (3) NULL , [DESCRIPTION] [char] (200) NULL , [TIMECHARGE] [char] (1) NULL , [ACTION] [char] (15) NULL , [BAND1LIMIT] [decimal](13, 2) NULL , [BAND1RATE] [decimal](13, 2) NULL , [BAND2LIMIT] [decimal](13, 2) NULL , [BAND2RATE] [decimal](13, 2) NULL , [BAND3LIMIT] [decimal](13, 2) NULL , [BAND3RATE] [decimal](13, 2) NULL , [BAND4LIMIT] [decimal](13, 2) NULL , [BAND4RATE] [decimal](13, 2) NULL , [BAND5LIMIT] [decimal](13, 2) NULL , [BAND5RATE] [decimal](13, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChargeType] ( [TAXHEAD] [char] (2) NOT NULL , [CHARGETYPE] [char] (2) NOT NULL , [DESCRIPTION] [varchar] (35) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChargingMatrix] ( [ARRANGEMENTCODE] [char] (3) NOT NULL , [CHARGECODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (100) NULL , [BAND1LIMIT] [decimal](13, 2) NULL , [BAND1RATE] [decimal](13, 2) NULL , [BAND2LIMIT] [decimal](13, 2) NULL , [BAND2RATE] [decimal](13, 2) NULL , [BAND3LIMIT] [decimal](13, 2) NULL , [BAND3RATE] [decimal](13, 2) NULL , [BAND4LIMIT] [decimal](13, 2) NULL , [BAND4RATE] [decimal](13, 2) NULL , [BAND5LIMIT] [decimal](13, 2) NULL , [BAND5RATE] [decimal](13, 2) NULL , [BAND6LIMIT] [decimal](13, 2) NULL , [BAND6RATE] [decimal](13, 2) NULL , [BAND7LIMIT] [decimal](13, 2) NULL , [BAND7RATE] [decimal](13, 2) NULL , [BAND8LIMIT] [decimal](13, 2) NULL , [BAND8RATE] [decimal](13, 2) NULL , [StageCode] [char] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChequeNumbers] ( [BANKCODE] [char] (10) NOT NULL , [LASTCHEQUENO] [decimal](13, 0) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChequeRequisitionDetail] ( [REQNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [MATTER] [char] (11) NOT NULL , [VALUE] [decimal](17, 2) NULL , [NOMINAL] [char] (10) NOT NULL , [NARRATIVE] [char] (100) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChequeRequisitionHeader] ( [REQNO] [int] NOT NULL , [DATE] [datetime] NULL , [WHO] [char] (8) NOT NULL , [BANK] [char] (10) NOT NULL , [VALUE] [decimal](17, 2) NULL , [NARRATIVE] [char] (100) NULL , [PAYEE] [char] (60) NULL , [STATUS] [char] (1) NOT NULL , [RETURNREASON] [char] (100) NULL , [FEEEARNER] [char] (3) NULL , [THIRDPARTY] [char] (1) NULL , [SPLIT] [char] (1) NULL , [SUPPLY] [char] (6) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ChequesForPrinting] ( [CHEQUENO] [char] (8) NOT NULL , [BATCHNO] [int] NULL , [BANK] [char] (1) NOT NULL , [DATE] [datetime] NOT NULL , [PAYEE] [char] (40) NULL , [MATTER] [char] (11) NULL , [CURRENCY] [char] (1) NULL , [VALUE] [decimal](9, 2) NULL , [STATUS] [char] (1) NULL , [TENMILS] [char] (5) NULL , [ONEMILS] [char] (5) NULL , [HUNDTHOU] [char] (5) NULL , [TENTHOU] [char] (5) NULL , [THOU] [char] (5) NULL , [HUND] [char] (5) NULL , [TENS] [char] (5) NULL , [ONES] [char] (5) NULL , [ADD] [char] (120) NULL , [YOURREF] [char] (20) NULL , [NARR] [char] (120) NULL , [INVDATE] [datetime] NULL , [INVNO] [char] (20) NULL , [INVAMOUNT] [decimal](13, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ClientContacts] ( [CLCODE] [char] (6) NOT NULL , [CLNUMCONTACT] [smallint] NOT NULL , [CLTITLE] [char] (10) NULL , [CLINITS] [char] (5) NULL , [CLNAMECON] [char] (35) NULL , [CLSALUTE] [char] (30) NULL , [CLSSNUMBER] [char] (15) NULL , [FIRSTNAME] [char] (20) NULL , [SURNAME] [char] (20) NULL , [Address] [char] (200) NULL , [HomePhone] [char] (30) NULL , [WorkPhone] [char] (30) NULL , [Mobile] [char] (30) NULL , [EmailAddress] [char] (100) NULL , [PPSNo] [char] (20) NULL , [Dob] [datetime] NULL , [MarrigeDate] [datetime] NULL , [Occupation] [char] (100) NULL , [DateofDeath] [datetime] NULL , [MartialStatus] [char] (3) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CloseCaseContacts] ( [CASECODE] [char] (11) NOT NULL , [FILENUM] [int] NOT NULL , [CONTYPE] [char] (12) NOT NULL , [CONNUM] [smallint] NOT NULL , [NAMECODE] [char] (6) NULL , [SOLCODE] [char] (6) NULL , [SOLREF] [char] (50) NULL , [INSCODE] [char] (6) NULL , [INSREF] [char] (20) NULL , [COURTRECORDNO] [char] (20) NULL , [HEARINGDATE] [datetime] NULL , [TIME] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CloseDiary] ( [FILENUM] [int] NULL , [CASECODE] [char] (11) NOT NULL , [DATE] [datetime] NULL , [STATUS] [smallint] NOT NULL , [ACTIONCODE] [char] (15) NOT NULL , [ACTIONSTATUS] [char] (3) NULL , [ACTIONTYPE] [char] (1) NULL , [PROCESSTYPE] [char] (1) NULL , [FNCODE] [char] (3) NOT NULL , [TEAMCODE] [char] (3) NOT NULL , [TEXT1] [text] NULL , [TEXT2] [text] NULL , [DELEGATEDFNR] [char] (3) NULL , [DELEGATEDDATE] [datetime] NULL , [DELEGATEDBACKDATE] [datetime] NULL , [DEFERRED] [char] (3) NULL , [DUEDATE] [datetime] NULL , [IMAGENO] [int] NULL , [PUBLISH] [char] (1) NULL , [DYSTARTTIME] [char] (10) NULL , [DYENDTIME] [char] (10) NULL , [DURATION] [smallint] NULL , [ACTIONID] [decimal](15, 0) NOT NULL , [PRIORITY] [char] (1) NULL , [HIGHLIGHTED] [char] (1) NULL , [MILESTEONETYPE] [char] (12) NULL , [ATTACHMENTS] [char] (1) NULL , [PROCESSSTATUS] [smallint] NULL , [WORKPROCESS] [smallint] NULL , [BILLABLE] [int] NULL , [BILLDESCRIPTION] [char] (150) NULL , [EMAILADDRESS] [char] (150) NULL , [EMAIL] [char] (1) NULL , [SUBJECT] [text] NULL , [ADDRESSTO] [text] NULL , [ORIGINALACTIONID] [decimal](15, 0) NULL , [DELEGATIONSTATUS] [decimal](5, 2) NULL , [DRAFTBILLNO] [int] NULL , [CHEQUEREQNO] [int] NULL , [Location] [char] (50) NULL , [HearingType] [char] (50) NULL , [TxmDate] [datetime] NULL , [TxmSeqNo] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[CloseDiaryAttachments] ( [DIARYID] [decimal](15, 0) NOT NULL , [TRACKREFERENCE] [decimal](7, 0) NOT NULL , [CASECODE] [char] (11) NOT NULL , [NAME] [char] (10) NOT NULL , [DOCUMENT] [char] (100) NULL , [FILEPATH] [char] (255) NULL , [ARCHPATH] [char] (255) NULL , [TYPE] [char] (3) NOT NULL , [DOCCLASS] [char] (3) NOT NULL , [DATEENTERED] [datetime] NULL , [ENTEREDBY] [char] (8) NULL , [LASTACCESSDATE] [datetime] NULL , [LASTACCESSBY] [char] (8) NULL , [SYSTEM] [char] (1) NULL , [DICTATIONFILE] [char] (255) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Closed] ( [CODE] [char] (11) NOT NULL , [CLIENTCODE] [char] (6) NULL , [MATTER] [char] (4) NULL , [DESCRIPTION] [char] (200) NULL , [FECODE] [char] (3) NULL , [DEPT] [char] (3) NULL , [STARTED] [datetime] NULL , [WTYPE] [char] (4) NULL , [ESTFEE] [decimal](17, 2) NULL , [OUTLAYBUD] [decimal](17, 2) NULL , [EXPBILLD] [datetime] NULL , [EXPPAYD] [datetime] NULL , [S13] [char] (1) NULL , [COMMENT] [char] (200) NULL , [DEBTBAL] [decimal](17, 2) NULL , [OUTLAYBAL] [decimal](17, 2) NULL , [CLIENTBAL] [decimal](17, 2) NULL , [CLIENTCURBAL] [decimal](17, 2) NULL , [CLIENTDEPBAL] [decimal](17, 2) NULL , [DEBTBALFWD] [decimal](17, 2) NULL , [OUTLAYBALFWD] [decimal](17, 2) NULL , [CLIENTBALFWD] [decimal](17, 2) NULL , [CLIENTCURBALFWD] [decimal](17, 2) NULL , [CLIENTDEPBALFWD] [decimal](17, 2) NULL , [PENDINGBAL] [decimal](17, 2) NULL , [CLIENTMIN] [decimal](17, 2) NULL , [FILENUM] [int] NULL , [THIRDPART] [char] (6) NULL , [THPARTSOL] [char] (6) NULL , [VALUE] [decimal](17, 2) NULL , [UNDERTAKING] [char] (1) NULL , [LASTACT] [datetime] NULL , [LASTACTTYPE] [char] (10) NULL , [LASTACTWHO] [char] (10) NULL , [STATUTELIMITS] [datetime] NULL , [STATUS] [char] (6) NULL , [SECTION68] [char] (1) NULL , [FNL_DATE] [datetime] NULL , [FNL_NAME] [char] (40) NULL , [FNL_ADDRESS] [char] (120) NULL , [FNL_FEES] [decimal](15, 2) NULL , [FNL_OUTLAY] [decimal](15, 2) NULL , [FNL_VAT] [decimal](15, 2) NULL , [FNL_TOTAL] [decimal](15, 2) NULL , [OLDREF] [char] (12) NULL , [PCODE] [char] (11) NULL , [PFECODE] [char] (3) NULL , [USER1] [char] (20) NULL , [USER2] [char] (20) NULL , [USER3] [char] (20) NULL , [DEPOSITNAME] [char] (40) NULL , [DEPOSITTYPE] [char] (4) NULL , [TIMEBAL] [decimal](13, 2) NULL , [CHARGEBAL] [decimal](13, 2) NULL , [CURDEBTBAL] [decimal](17, 2) NULL , [CUROUTLAYBAL] [decimal](17, 2) NULL , [CURCLIENTBAL] [decimal](17, 2) NULL , [CURCLIENTCBAL] [decimal](17, 2) NULL , [CURCLIENTDBAL] [decimal](17, 2) NULL , [CURDEBTBALFWD] [decimal](17, 2) NULL , [CUROUTLAYBALFWD] [decimal](17, 2) NULL , [CURCLIENTBALFWD] [decimal](17, 2) NULL , [CURCLIENTCBALFWD] [decimal](17, 2) NULL , [CURCLIENTDBALFWD] [decimal](17, 2) NULL , [CURPENDINGBAL] [decimal](17, 2) NULL , [UNALLOCATED] [decimal](13, 2) NULL , [STATEMENTS] [char] (1) NULL , [CHARGELEVEL] [int] NULL , [FILECOLOUR] [char] (3) NULL , [OPENINVOICENO] [int] NULL , [DATECLOSED] [datetime] NULL , [OTHERREF] [char] (10) NULL , [LOCATION] [char] (20) NULL , [DESTROYDATE] [datetime] NULL , [YOURREF] [char] (15) NULL , [BRANCH] [char] (1) NULL , [PASSWORD] [char] (20) NULL , [COMPBILLONOFF] [char] (1) NULL , [COMPFREQUENCY] [char] (1) NULL , [COMPOUTLAYLIMIT] [decimal](13, 2) NULL , [COMPFEESLIMIT] [decimal](13, 2) NULL , [COMPTOTALLIMIT] [decimal](13, 2) NULL , [CompBillingMatter] [char] (11) NULL , [CompBilling] [char] (1) NULL , [ClientName] [char] (60) NULL , [ClientAddress] [char] (120) NULL , [ClientSalutation] [char] (40) NULL , [ChargeArrangement] [char] (3) NULL , [Importance] [smallint] NULL , [OriginalDebt] [decimal](18, 2) NULL , [DebtCollected] [decimal](18, 2) NULL , [RecoverableCosts] [decimal](18, 2) NULL , [DebtInterest] [decimal](18, 2) NULL , [BillingMethod] [char] (1) NULL , [CollectingBalance] [decimal](18, 2) NULL , [Publish] [char] (1) NULL , [Permissions] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ClosedCaseUDFAnswers] ( [TEXT1] [text] NULL , [FILENUM] [int] NULL , [CASECODE] [char] (11) NOT NULL , [UDFFILE] [char] (5) NOT NULL , [UDFNAME] [char] (20) NOT NULL , [SEQNO] [smallint] NULL , [NumberValue] [decimal](18, 0) NULL , [DateValue] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[ClosedMatterLedger] ( [MATTER] [char] (11) NOT NULL , [FILENUM] [int] NULL , [BATCHNO] [int] NULL , [PREF] [int] NULL , [DATE] [datetime] NULL , [REF] [char] (10) NULL , [NARR] [char] (80) NULL , [VALUED] [decimal](17, 2) NULL , [VALUEO] [decimal](17, 2) NULL , [VALUEC] [decimal](17, 2) NULL , [VALUECC] [decimal](17, 2) NULL , [VALUECD] [decimal](17, 2) NULL , [FEE] [char] (3) NULL , [PER] [smallint] NULL , [YEAR] [smallint] NULL , [CLIENT] [char] (6) NULL , [ENTRYDATE] [datetime] NULL , [CURVALUED] [decimal](17, 2) NULL , [CURVALUEO] [decimal](17, 2) NULL , [CURVALUEC] [decimal](17, 2) NULL , [CURVALUECC] [decimal](17, 2) NULL , [CURVALUECD] [decimal](17, 2) NULL , [DEPOSITTYPE] [char] (4) NULL , [LREF] [int] NULL , [BILLED] [char] (1) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CompositeBillBreakDown] ( [COMPBILLNO] [decimal](7, 0) NOT NULL , [MATTER] [char] (11) NOT NULL , [POSTINGREF] [decimal](7, 0) NOT NULL , [BATCHNO] [decimal](7, 0) NOT NULL , [INCLUDEITEM] [char] (1) NULL , [DATE] [datetime] NOT NULL , [NARRATIVE] [char] (150) NULL , [VALUE] [decimal](15, 2) NULL , [INCLUDEVALUE] [decimal](13, 2) NULL , [LEDGERREF] [decimal](7, 0) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CompositeBillDetail] ( [COMPBILLNO] [decimal](9, 0) NULL , [MATTER] [char] (11) NULL , [FEEEARNER] [char] (3) NULL , [TOTALOUTLAY] [decimal](13, 2) NULL , [TOTALFEES] [decimal](13, 2) NULL , [TOTALTIME] [decimal](7, 0) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CompositeBillFees] ( [COMPBILLNO] [decimal](7, 0) NULL , [MATTER] [char] (11) NULL , [FE] [char] (3) NULL , [INCLUDEITEM] [char] (1) NULL , [DATE] [datetime] NULL , [VALUE] [decimal](9, 2) NULL , [INCLUDEVALUE] [decimal](13, 2) NULL , [TIME] [decimal](7, 0) NULL , [FROMTIMSER] [char] (1) NULL , [NARRATIVE] [char] (255) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CompositeBillHeader] ( [COMPBILLNO] [decimal](9, 0) NOT NULL , [COMPMATTER] [char] (11) NULL , [COMPDATE] [datetime] NULL , [ACTUALREF] [char] (10) NULL , [REQCLIENT] [char] (6) NULL , [COMPDESCRIPTION] [char] (200) NULL , [CHECKOUTLAYLIMIT] [tinyint] NULL , [CHECKFEESLIMIT] [tinyint] NULL , [CHECKBILLLIMIT] [tinyint] NULL , [REQOUTLAYLIMIT] [decimal](13, 2) NULL , [REQFEESLIMIT] [decimal](13, 2) NULL , [REQTOTALLIMIT] [decimal](13, 2) NULL , [REQBILLTODATE] [datetime] NULL , [TOTALOUTLAY] [decimal](13, 2) NULL , [TOTALFEES] [decimal](13, 2) NULL , [TOTALBILL] [decimal](13, 2) NULL , [UPDATED] [char] (1) NULL , [USER] [char] (10) NULL , [BATCHNO] [decimal](9, 0) NULL , [PREF] [decimal](9, 0) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CompositeFEBreakdown] ( [COMPBILLNO] [decimal](7, 0) NOT NULL , [MATTER] [char] (11) NOT NULL , [FE] [char] (3) NOT NULL , [INCLUDEITEM] [char] (1) NULL , [TOTALVALUE] [decimal](9, 2) NULL , [TOTALTIME] [decimal](7, 0) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ContactCategories] ( [CONTACT] [char] (6) NOT NULL , [CATEGORYTYPE] [char] (6) NOT NULL , [CATEGORY] [char] (10) NOT NULL , [DATE] [datetime] NULL , [FIELDVALUE1] [char] (60) NULL , [FIELDVALUE2] [char] (60) NULL , [FIELDVALUE3] [char] (60) NULL , [FIELDVALUE4] [char] (60) NULL , [FIELDVALUE5] [char] (60) NULL , [FIELDVALUE6] [char] (60) NULL , [FIELDVALUE7] [char] (60) NULL , [FIELDVALUE8] [char] (60) NULL , [FIELDVALUE9] [char] (60) NULL , [FIELDVALUE10] [char] (60) NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ContactLinks] ( [CONTACTA] [char] (10) NOT NULL , [CONTACTB] [char] (10) NOT NULL , [RELATE] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ContactPhoneNos] ( [CONTACT] [char] (6) NOT NULL , [PHONE] [char] (25) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ContactRequisition] ( [TEMPCONTACTREF] [char] (6) NOT NULL , [NEWCONTACTREF] [char] (6) NULL , [DATEINCEPTION] [datetime] NULL , [WHOINCEPT] [char] (8) NULL , [DATEAPPROVAL] [datetime] NULL , [WHOAPPROVAL] [char] (8) NULL , [STATUS] [char] (1) NULL , [NAME] [char] (40) NULL , [ADDRESS] [char] (120) NULL , [SALUT] [char] (20) NULL , [OTHERREF] [char] (10) NULL , [TEL] [char] (20) NULL , [FAX] [char] (20) NULL , [MOBILE] [char] (20) NULL , [EMAIL] [char] (40) NULL , [PRINCIPAL] [char] (30) NULL , [NATIONALITY] [char] (3) NULL , [CORPORATE] [char] (1) NULL , [FE] [char] (3) NULL , [GROUP] [char] (40) NULL , [RETURNREASON] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Contacts] ( [Code] [char] (6) NOT NULL , [Name] [char] (60) NULL , [Address] [char] (120) NULL , [Salut] [char] (20) NULL , [Tel] [char] (20) NULL , [Fax] [char] (20) NULL , [email] [char] (40) NULL , [Principal] [char] (30) NULL , [FE] [char] (3) NULL , [Client] [char] (1) NULL , [Nation] [char] (3) NULL , [LastMatter] [int] NULL , [OpenMatters] [smallint] NULL , [StartDate] [datetime] NULL , [BillBal] [decimal](17, 2) NULL , [OutlayBal] [decimal](17, 2) NULL , [ClientCur] [decimal](17, 2) NULL , [ClientDep] [decimal](17, 2) NULL , [RSINo] [char] (20) NULL , [Spouse] [char] (30) NULL , [DOB] [datetime] NULL , [SpouseDOB] [datetime] NULL , [Introducer] [char] (30) NULL , [IntroFE] [char] (3) NULL , [Comments] [char] (2000) NULL , [Corporate] [char] (1) NULL , [Inactive] [char] (1) NULL , [DateInactive] [datetime] NULL , [LastAR] [datetime] NULL , [OtherAddress] [char] (120) NULL , [DateOfMarriage] [datetime] NULL , [SpouseDead] [char] (1) NULL , [Separated] [char] (1) NULL , [HowSeparated] [char] (20) NULL , [Partner] [char] (30) NULL , [PartnerSince] [datetime] NULL , [Occupation] [char] (20) NULL , [OtherRef] [char] (10) NULL , [OpsisRef] [char] (20) NULL , [ContactNo] [int] NULL , [CurBillBal] [decimal](17, 2) NULL , [CurOutlayBal] [decimal](17, 2) NULL , [CurClientCBal] [decimal](17, 2) NULL , [CurClientDBal] [decimal](17, 2) NULL , [Statements] [char] (1) NULL , [RemoteAccess] [char] (1) NULL , [Password] [char] (20) NULL , [CompBillOnOff] [tinyint] NULL , [CompMatter] [char] (11) NULL , [CompFrequency] [char] (1) NULL , [CompOutlayLimit] [decimal](17, 2) NULL , [CompFeesLimit] [decimal](17, 2) NULL , [CompTotalLimit] [decimal](17, 2) NULL , [ChargeArrangement] [char] (3) NULL , [BillingMethod] [char] (1) NULL , [Approved] [smallint] NULL , [SpousePPS] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CostFees] ( [CFTYPE] [char] (3) NOT NULL , [CFCODE] [char] (3) NOT NULL , [CFBANDNO] [smallint] NOT NULL , [CFDESC] [char] (40) NULL , [CFBANDLIMIT] [decimal](7, 2) NULL , [CFBANDAMT] [decimal](7, 2) NULL , [CFBANDPCENT] [decimal](7, 2) NULL , [CFVATCODE] [char] (3) NOT NULL , [CFTRANSTYPE] [char] (3) NULL , [CFROUNDIND] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CostTransGathering] ( [REF] [char] (10) NULL , [DATE] [datetime] NULL , [MATTER] [char] (11) NULL , [VALUE] [decimal](17, 2) NULL , [ENTRYCURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CURRENCYVAT] [decimal](17, 2) NULL , [HEADPREF] [int] NULL , [HEADBATCH] [int] NULL , [ALLOCBATCH] [int] NULL , [ALLOCPREF] [int] NULL , [ALLOCREF] [char] (10) NULL , [ALLOCVALUE] [decimal](17, 2) NULL , [ALLOCWRITEOFF] [char] (1) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CourtFees] ( [CODE] [char] (3) NULL , [DESCRIPTION] [char] (100) NULL , [CHARGECLIENT] [tinyint] NULL , [VALUE] [decimal](9, 2) NULL , [CLIENTVALUE] [decimal](13, 2) NULL , [GROUP] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CreditorsList] ( [SUPPLYCODE] [char] (6) NOT NULL , [BATCHNO] [int] NOT NULL , [PREF] [int] NULL , [REF] [char] (10) NULL , [DATE] [datetime] NULL , [ORIGVALUE] [decimal](11, 2) NULL , [OSVALUE] [decimal](11, 2) NULL , [PAYVALUE] [decimal](11, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DBODSSW21] ( [OPE_LOGIN] [char] (129) NOT NULL , [OPE_FIRSTNAME] [char] (20) NULL , [OPE_SURNAME] [char] (20) NULL , [OPE_PASSWORD] [char] (129) NULL , [OPE_NUMBER] [smallint] NULL , [OPE_USERGROUP] [smallint] NULL , [OPE_LASTPASSWORDCHANGEDATE] [int] NULL , [OPE_HOOK1] [int] NULL , [OPE_HOOK2] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DBODSSW22] ( [ACC_APPLICATION] [smallint] NOT NULL , [ACC_OPERATOR] [smallint] NOT NULL , [ACC_HASHNUMBER] [smallint] NOT NULL , [ACC_ACCESS] [int] NULL , [ACC_MOREACCESS] [int] NULL , [ACC_EVENMOREACCESS] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DBODSSW23] ( [NAM_APPNUMBER] [smallint] NOT NULL , [NAM_NAME] [char] (129) NOT NULL , [NAM_HASHNUMBER] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DBODSSW24] ( [LOG_OPERATORCODE] [char] (8) NULL , [LOG_APPLICATION] [smallint] NULL , [LOG_WINDOWNUMBER] [smallint] NULL , [LOG_ACTION] [smallint] NULL , [LOG_DATE] [int] NOT NULL , [LOG_TIME] [int] NOT NULL , [LOG_MACHINENAME] [char] (8) NULL , [LOG_DESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DBODSSW25] ( [LIC_LICENCEDTO] [char] (40) NULL , [LIC_PRODUCT] [char] (40) NOT NULL , [LIC_COPIES] [int] NULL , [LIC_LEVEL] [tinyint] NULL , [LIC_EXPIRYDATE] [int] NULL , [LIC_LASTRUNDATE] [int] NULL , [LIC_APPNUMBER] [smallint] NULL , [LIC_SERIALNUMBER] [char] (20) NULL , [LIC_MODULES] [int] NULL , [LIC_OTHER1] [char] (20) NULL , [LIC_OTHER2] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DataFiles] ( [NOTES] [text] NULL , [FILENAME] [char] (40) NOT NULL , [REALNAME] [char] (40) NULL , [DESCRIPTION] [char] (100) NULL , [VERSION] [decimal](9, 0) NULL , [LASTREPAIRDATE] [int] NULL , [LASTREPAIREDBY] [char] (20) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[DebtAccounts] ( [ACCASECODE] [char] (18) NOT NULL , [ACCTYPE] [char] (1) NOT NULL , [ACTRNDATE] [datetime] NOT NULL , [ACSEQ] [smallint] NOT NULL , [ACTRNCODE] [char] (3) NOT NULL , [ACTRNREF] [char] (12) NULL , [ACTRNDESC] [char] (50) NULL , [ACTRNAMT] [decimal](9, 2) NOT NULL , [ACTRNVAT] [decimal](9, 2) NULL , [ACTRNCATEGORY] [char] (3) NULL , [ACTRNSTATUS] [char] (3) NULL , [ACDIARYDATE] [datetime] NULL , [ACDIARYSEQ] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DebtAllocations] ( [BreakdownId] [decimal](10, 0) NOT NULL , [PaymentId] [decimal](10, 0) NULL , [TaxAmount] [decimal](18, 2) NULL , [InterestAmount] [decimal](18, 2) NULL , [AllocDate] [datetime] NULL , [RecordId] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [ProcessDate] [datetime] NULL , [Sent] [int] NULL , [Sequence] [int] NULL , [SendDate] [datetime] NULL , [Type] [char] (20) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DebtBreakDown] ( [MatterCode] [char] (11) NOT NULL , [StartPeriod] [datetime] NULL , [EndPeriod] [datetime] NULL , [TaxHead] [char] (2) NULL , [TaxHeadRegistration] [char] (7) NULL , [CheckCharacter] [char] (1) NULL , [TaxAmount] [decimal](18, 2) NULL , [Interest] [decimal](18, 2) NULL , [ChargeType] [char] (2) NULL , [Sequence] [decimal](3, 0) NOT NULL , [AmednmentReason] [char] (1) NULL , [OSTaxAmount] [decimal](18, 2) NULL , [OSInterestAmt] [decimal](18, 2) NULL , [RecordID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [OriginalTax] [decimal](18, 2) NULL , [OriginalInterest] [decimal](18, 2) NULL , [OUTFileNo] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DebtCostingLedger] ( [MATTERCODE] [char] (17) NOT NULL , [DATE] [datetime] NULL , [REFERENCE] [char] (20) NULL , [DESCRIPTION] [char] (200) NULL , [TYPE] [char] (20) NULL , [Value] [decimal](13, 2) NULL , [INTEREST] [decimal](13, 2) NULL , [COSTS] [decimal](13, 2) NULL , [REMITTANCENO] [int] NULL , [DATEREMITTED] [datetime] NULL , [HELDDATE] [datetime] NULL , [ENTRYDATE] [datetime] NULL , [ENTEREDBY] [char] (12) NULL , [POSTINGREF] [int] NOT NULL , [BOUNCED] [decimal](13, 2) NULL , [PREMIUMPAID] [decimal](13, 2) NULL , [PREMIUMSTATUS] [char] (1) NULL , [INTERESTPAID] [decimal](13, 2) NULL , [INTERESTSTATUS] [char] (1) NULL , [COSTSPAID] [decimal](13, 2) NULL , [COSTSTATUS] [char] (1) NULL , [PAYMENTMETHOD] [char] (40) NULL , [Outcome] [int] NULL , [XnId] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DebtorsLedger] ( [MATTER] [char] (11) NOT NULL , [TYPE] [char] (1) NULL , [CLIENT] [char] (6) NOT NULL , [DATE] [datetime] NOT NULL , [REF] [char] (10) NULL , [BATCHNO] [int] NOT NULL , [PREF] [int] NOT NULL , [NARR] [char] (80) NULL , [ORIGINAL] [decimal](17, 2) NULL , [OSVALUE] [decimal](17, 2) NULL , [ORFEES] [decimal](17, 2) NULL , [OROUTLAY] [decimal](17, 2) NULL , [ORVAT] [decimal](17, 2) NULL , [OSFEES] [decimal](17, 2) NULL , [OSOUTLAY] [decimal](17, 2) NULL , [OSVAT] [decimal](17, 2) NULL , [VATCODE] [char] (1) NULL , [PER] [smallint] NULL , [YEAR] [smallint] NULL , [FEECODE] [char] (3) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Departments] ( [CODE] [char] (3) NOT NULL , [DESC] [char] (50) NULL , [RETIRED] [char] (1) NULL , [Description] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DepositType] ( [CODE] [char] (4) NOT NULL , [DESCRIPTION] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DesktopControl] ( [DEFAULTTASK] [char] (10) NULL , [REQUESTER] [char] (1) NULL , [SPLITCHEQUES] [char] (1) NULL , [INDICATOR3] [char] (1) NULL , [INDICATOR4] [char] (1) NULL , [INDICATOR5] [char] (1) NULL , [INDICATOR6] [char] (1) NULL , [INDICATOR7] [char] (1) NULL , [INDICATOR8] [char] (1) NULL , [INDICATOR9] [char] (1) NULL , [INDICATOR10] [char] (1) NULL , [ENQUIRY] [char] (1) NULL , [TIMECOSTING] [char] (1) NULL , [BILLING] [char] (1) NULL , [CHEQUEREQ] [char] (1) NULL , [CLIENTREQ] [char] (1) NULL , [CASEMAN] [char] (1) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DesktopMessages] ( [MESSAGE] [char] (255) NOT NULL , [HEADING] [char] (255) NOT NULL , [DATE] [int] NOT NULL , [TIME] [int] NOT NULL , [BUTTON] [int] NULL , [DURATION] [int] NULL , [NAME] [char] (100) NOT NULL , [FLAG] [int] NULL , [EXTRAS] [char] (100) NULL , [EXTRAL] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DesktopNarr] ( [CODE] [char] (6) NOT NULL , [NARRATIVE] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DiaryAttachments] ( [DIARYID] [bigint] NOT NULL , [TRACKREFERENCE] [int] NOT NULL , [CASECODE] [char] (11) NOT NULL , [NAME] [char] (10) NOT NULL , [DOCUMENT] [char] (100) NULL , [FILEPATH] [char] (255) NULL , [TYPE] [char] (3) NOT NULL , [DOCCLASS] [char] (3) NOT NULL , [DATEENTERED] [datetime] NULL , [ENTEREDBY] [char] (8) NULL , [LASTACCESSDATE] [datetime] NULL , [LASTACCESSBY] [char] (8) NULL , [SYSTEM] [char] (1) NULL , [DICTATIONFILE] [char] (255) NULL , [Source] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DiaryDelegations] ( [ACTIONID] [decimal](15, 0) NOT NULL , [HANDLER] [char] (3) NOT NULL , [TEAM] [char] (3) NULL , [DATE] [datetime] NULL , [TIME] [char] (10) NULL , [DATER] [datetime] NULL , [TIMER] [char] (10) NULL , [DUEDATE] [datetime] NULL , [DUETIME] [char] (10) NULL , [REVIEW] [char] (1) NULL , [STATUS] [smallint] NULL , [OWNER] [char] (1) NULL , [DELEGATE] [char] (3) NULL , [DELEGATESTATUS] [smallint] NULL , [ActionType] [char] (1) NULL , [AssignNo] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [FromHandler] [char] (3) NULL , [ReturnedBy] [char] (3) NULL , [DelType] [char] (15) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DiaryLinks] ( [RecordID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL , [ActionID] [decimal](18, 0) NOT NULL , [ChildId] [decimal](18, 0) NOT NULL , [LinkDate] [datetime] NULL , [LinkedBy] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DocumentClasses] ( [CLASSCODE] [char] (3) NOT NULL , [CLASSDESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DocumentPopCat] ( [CATEGORY] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DocumentPopups] ( [TEXTVALUE] [text] NULL , [KEYFIELD] [int] NOT NULL , [CATEGORY] [char] (20) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[EMailAttachments] ( [EACASECODE] [char] (18) NOT NULL , [EAACNDATE] [datetime] NOT NULL , [EAACNCODE] [char] (3) NOT NULL , [EASEQ] [smallint] NOT NULL , [EADOCNAME] [char] (100) NULL , [EAFILETYPE] [char] (3) NULL , [EAATTNUM] [smallint] NOT NULL , [EAEMREF] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ElectronicBankRec] ( [BankRecNumber] [int] NULL , [SortCode] [char] (10) NULL , [AccountNumber] [char] (10) NULL , [AccountCode] [char] (10) NULL , [Currency] [char] (3) NULL , [Date] [datetime] NULL , [Narrative] [char] (50) NULL , [Ref] [char] (10) NULL , [Amount] [decimal](18, 2) NULL , [Balance] [decimal](18, 2) NULL , [Type] [char] (1) NULL , [Checked] [char] (1) NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL , [RecTransId] [int] NULL , [ImportNumber] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ElectronicImportLog] ( [ImportDate] [datetime] NULL , [BankRecNo] [int] NULL , [ImportNumber] [int] NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FeeEarnerCodes] ( [CODE] [char] (3) NOT NULL , [BRANCH] [char] (1) NULL , [NAME] [char] (40) NULL , [NOMINAL] [char] (10) NULL , [RETIRED] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FeeExtract] ( [FEERECNO] [int] NOT NULL , [FEEPOSTDATE] [datetime] NULL , [FEEEFFECDATE] [datetime] NULL , [FEECLIENTCODE] [varchar] (6) NULL , [FEEDEFRECNO] [int] NULL , [FEECODE] [varchar] (6) NULL , [FEEDESC] [varchar] (60) NULL , [FEEAMT] [money] NULL , [FEEOFFICIAL] [varchar] (8) NULL , [FEESOL] [varchar] (50) NULL , [FEEINVNO] [int] NULL , [EXTRACTED] [varchar] (1) NULL , [DEFOURREF] [varchar] (50) NULL , [DEFCORRREF] [varchar] (50) NULL , [DEFORGCODE] [int] NULL , [FEEFINALBILL] [varchar] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FieldTransfer] ( [OLDFIELD] [char] (40) NOT NULL , [NEWFIELDPREFIX] [char] (5) NULL , [NEWFIELDNAME] [char] (100) NULL , [CATEGORY] [char] (12) NULL , [TYPE] [char] (11) NULL , [NUMBER] [smallint] NULL , [OLDDESCRIPTION] [char] (100) NULL , [DOC1] [char] (20) NULL , [DOC2] [char] (20) NULL , [DOC3] [char] (20) NULL , [DOC4] [char] (20) NULL , [DOC5] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FileColours] ( [COLOURCODE] [char] (3) NULL , [COLOURDESC] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[FileManagerItems] ( [LOCATION] [char] (10) NOT NULL , [ITEMCODE] [char] (10) NULL , [CLIENTCODE] [char] (6) NOT NULL , [MATTERCODE] [char] (11) NOT NULL , [ITEMTYPE] [char] (3) NOT NULL , [DESCRIPTION] [char] (100) NULL , [STATUS] [char] (1) NULL , [DESTROYDATE] [datetime] NULL , [SEARCHCODE] [char] (20) NULL , [BOXNO] [char] (10) NULL , [OPENCLOSED] [char] (1) NULL , [CLOSEDFILENO] [char] (10) NULL , [CLOSEDDATE] [datetime] NULL , [ENTRYDATE] [datetime] NULL , [FEEARNER] [char] (3) NULL , [DEEDADDRESS] [char] (300) NULL , [WILLDATE] [datetime] NULL , [TESTATOR] [char] (100) NULL , [EXECUTORNAME1] [char] (100) NULL , [EXECUTORADDRESS1] [char] (250) NULL , [EXECUTORNAME2] [char] (100) NULL , [EXECUTORADDRESS2] [char] (250) NULL , [ESTIMATEESTATE] [decimal](13, 2) NULL , [ACCOUNTABLERECEIPT] [char] (1) NULL , [ARDATE] [datetime] NULL , [ARNARRATIVE] [char] (300) NULL , [LASTACTION] [datetime] NULL , [LASTACTIONWHO] [char] (10) NULL , [NUMBER] [int] NOT NULL , [WitnessName1] [char] (100) NULL , [WitnessAddress1] [char] (250) NULL , [WitnessName2] [char] (100) NULL , [WitnessAddress2] [char] (250) NULL , [Probate] [char] (20) NULL , [ReleaseDate] [datetime] NULL , [ReleaseTo] [char] (20) NULL , [PrevWillDate1] [datetime] NULL , [PrevWillDate2] [datetime] NULL , [DateReviewed] [datetime] NULL , [ReceivedFrom] [char] (35) NULL , [NatureOfTitle] [char] (35) NULL , [JointOwner] [char] (35) NULL , [TenantInCommon] [char] (35) NULL , [ScheduleOfDeeds] [char] (35) NULL , [DateRemoved] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Forms] ( [APPNO] [decimal](11, 0) NOT NULL , [NAME] [char] (100) NULL , [ADDRESS] [char] (150) NULL , [PHONENO] [char] (20) NULL , [FAXNO] [char] (20) NULL , [EMAIL] [char] (150) NULL , [SUBJECT] [char] (1000) NULL , [AMOUNT] [decimal](9, 2) NULL , [DATE] [datetime] NULL , [REQUESTER] [char] (50) NULL , [ENTRYDATE] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[HandlerBudgets] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [Handler] [char] (3) NOT NULL , [Year] [int] NOT NULL , [Month] [int] NOT NULL , [FeesBudget] [decimal](18, 2) NOT NULL , [ChargableTimeBudget] [decimal](18, 2) NOT NULL , [NonChargableTimeBudget] [decimal](18, 2) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Handlers] ( [CODE] [char] (3) NOT NULL , [TEAM] [char] (3) NULL , [TEAMCODE] [char] (3) NULL , [Dept] [char] (3) NULL , [Type] [char] (1) NULL , [NAME] [char] (30) NULL , [RATE] [float] NULL , [BUDGET1] [decimal](13, 2) NULL , [BUDGET2] [decimal](13, 2) NULL , [BUDGET3] [decimal](13, 2) NULL , [BUDGET4] [decimal](13, 2) NULL , [BUDGET5] [decimal](13, 2) NULL , [BUDGET6] [decimal](13, 2) NULL , [BUDGET7] [decimal](13, 2) NULL , [BUDGET8] [decimal](13, 2) NULL , [BUDGET9] [decimal](13, 2) NULL , [BUDGET10] [decimal](13, 2) NULL , [BUDGET11] [decimal](13, 2) NULL , [BUDGET12] [decimal](13, 2) NULL , [ACTUAL1] [decimal](13, 2) NULL , [ACTUAL2] [decimal](13, 2) NULL , [ACTUAL3] [decimal](13, 2) NULL , [ACTUAL4] [decimal](13, 2) NULL , [ACTUAL5] [decimal](13, 2) NULL , [ACTUAL6] [decimal](13, 2) NULL , [ACTUAL7] [decimal](13, 2) NULL , [ACTUAL8] [decimal](13, 2) NULL , [ACTUAL9] [decimal](13, 2) NULL , [ACTUAL10] [decimal](13, 2) NULL , [ACTUAL11] [decimal](13, 2) NULL , [ACTUAL12] [decimal](13, 2) NULL , [TEMPCALC] [decimal](13, 2) NULL , [LOGON] [char] (10) NULL , [MAILADDRESS] [char] (20) NULL , [TIMECOSTER] [char] (1) NULL , [TEAMLEADER] [char] (1) NULL , [NORECENTMATTERS] [decimal](3, 0) NULL , [DEFAULTTASK] [char] (6) NULL , [EXCHANGEALIAS] [char] (256) NULL , [RATE1] [decimal](7, 2) NULL , [RATE2] [decimal](7, 2) NULL , [RATE3] [decimal](7, 2) NULL , [RATE4] [decimal](7, 2) NULL , [RATE5] [decimal](7, 2) NULL , [EMAIL] [char] (100) NULL , [RETIRED] [char] (1) NULL , [DELEGATE] [char] (3) NULL , [OutlookView] [char] (1) NULL , [AutoLaunchTimer] [char] (1) NULL , [SIGNATURE] [text] NULL , [PhoneNo] [varchar] (30) NULL , [AutoLaunchKPI] [char] (1) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[HandlersDepartments] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [Handler] [char] (3) NOT NULL , [Department] [char] (3) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ImportLog] ( [SeqNo] [int] NULL , [ImportDate] [datetime] NULL , [SplitKey] [char] (1) NULL , [TaxAmount] [decimal](18, 2) NULL , [InterestAmount] [decimal](18, 2) NULL , [TotalAmount] [decimal](18, 2) NULL , [NoofRecords] [decimal](18, 0) NULL , [SplitDescription] [char] (50) NULL , [ActualNoRecs] [decimal](18, 0) NULL , [ImportorExport] [char] (1) NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[InterestCalcHistory] ( [MATTERREF] [char] (11) NULL , [DATE] [datetime] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[InterestLedger] ( [RECORDID] [int] IDENTITY (1, 1) NOT NULL , [MATTER] [char] (11) NULL , [VDATE] [int] NULL , [DATE] [int] NULL , [VALUE] [decimal](15, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[InterestRates] ( [RECORDID] [int] IDENTITY (1, 1) NOT NULL , [DATEFROM] [int] NOT NULL , [DATETO] [int] NULL , [RATE] [decimal](7, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[InterestTransactions] ( [RECORDID] [int] IDENTITY (1, 1) NOT NULL , [MATCODE] [char] (11) NULL , [DATEFROM] [int] NULL , [DATETO] [int] NULL , [DAYS] [smallint] NULL , [RATE] [decimal](7, 2) NULL , [RECEIVED] [decimal](15, 2) NULL , [PAID] [decimal](15, 2) NULL , [AMOUNT] [decimal](15, 2) NULL , [OPENINGBAL] [decimal](15, 2) NULL , [INTEREST] [decimal](7, 2) NULL , [INTERESTNEG] [decimal](15, 2) NULL , [INTERESTPOS] [decimal](15, 2) NULL , [CLOSINGBAL] [decimal](15, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ItemDiary] ( [ITEMCODE] [char] (10) NOT NULL , [DATE] [datetime] NOT NULL , [DETAILS] [char] (300) NULL , [COMPLETE] [int] NULL , [NUMBER] [int] NOT NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ItemHistory] ( [ITEMCODE] [char] (10) NOT NULL , [WHO] [char] (10) NULL , [OUTDATE] [datetime] NOT NULL , [OUTTIME] [int] NOT NULL , [INDATE] [datetime] NULL , [INTIME] [int] NULL , [NUMBER] [int] NOT NULL , [HANDLER] [char] (3) NULL , [COMMENT] [char] (300) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ItemLocations] ( [CODE] [char] (10) NOT NULL , [DESCRIPTION] [char] (10) NULL , [FULLYN] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ItemTypes] ( [TYPECODE] [char] (3) NOT NULL , [TYPEDESCRIPTION] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[JGroups] ( [JGRP_GroupID] [int] NOT NULL , [JGRP_G1] [char] (50) NULL , [JGRP_G2] [char] (50) NULL , [JGRP_G3] [char] (50) NULL , [JGRP_G4] [char] (50) NULL , [JGRP_G5] [char] (50) NULL , [JGRP_G6] [char] (50) NULL , [JGRP_G7] [char] (50) NULL , [JGRP_G8] [char] (50) NULL , [JGRP_G9] [char] (50) NULL , [JGRP_G10] [char] (50) NULL , [JGRP_G11] [char] (50) NULL , [JGRP_G12] [char] (50) NULL , [JGRP_G13] [char] (50) NULL , [JGRP_G14] [char] (50) NULL , [JGRP_G15] [char] (50) NULL , [JGRP_G16] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[JPermissions] ( [JPER_PermissionID] [int] NOT NULL , [JPER_UserNumber] [int] NULL , [JPER_Permissions] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[KPIParameters] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [StartOfYear] [datetime] NULL , [FromDate] [datetime] NULL , [ToDate] [datetime] NULL , [Period] [int] NULL , [Year] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Log] ( [DATE] [datetime] NOT NULL , [USER] [char] (8) NULL , [EVENT] [char] (100) NULL , [RecordId] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MatterLedger] ( [MATTER] [char] (11) NULL , [BATCHNO] [int] NULL , [PREF] [int] NULL , [DATE] [datetime] NULL , [REF] [char] (10) NULL , [NARR] [char] (80) NULL , [VALUED] [decimal](17, 2) NULL , [VALUEO] [decimal](17, 2) NULL , [VALUEC] [decimal](17, 2) NULL , [FEE] [char] (3) NULL , [PER] [smallint] NULL , [YEAR] [smallint] NULL , [ENTRYDATE] [datetime] NULL , [CLIENT] [char] (6) NULL , [VALUECC] [decimal](17, 2) NULL , [VALUECD] [decimal](17, 2) NULL , [DEPOSITTYPE] [char] (4) NULL , [CURVALUED] [decimal](17, 2) NULL , [CURVALUEO] [decimal](17, 2) NULL , [CURVALUEC] [decimal](17, 2) NULL , [CURVALUECC] [decimal](17, 2) NULL , [CURVALUECD] [decimal](17, 2) NULL , [LREF] [int] IDENTITY (1, 1) NOT NULL , [BILLED] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MatterLedgerClearDown] ( [MATTER] [char] (11) NOT NULL , [BATCHNO] [int] NOT NULL , [PREF] [int] NOT NULL , [DATE] [datetime] NOT NULL , [REF] [char] (10) NULL , [NARR] [char] (80) NULL , [VALUED] [decimal](17, 2) NULL , [VALUEO] [decimal](17, 2) NULL , [VALUEC] [decimal](17, 2) NULL , [FEE] [char] (3) NULL , [PER] [smallint] NULL , [YEAR] [smallint] NULL , [ENTRYDATE] [datetime] NULL , [CLIENT] [char] (6) NOT NULL , [VALUECC] [decimal](17, 2) NULL , [VALUECD] [decimal](17, 2) NULL , [DEPOSITTYPE] [char] (4) NULL , [CURVALUED] [decimal](17, 2) NULL , [CURVALUEO] [decimal](17, 2) NULL , [CURVALUEC] [decimal](17, 2) NULL , [CURVALUECC] [decimal](17, 2) NULL , [CURVALUECD] [decimal](17, 2) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MatterTally] ( [MATTER] [char] (11) NULL , [HIGHLOW] [char] (1) NULL , [AMOUNT] [decimal](11, 2) NULL , [FROMDATE] [datetime] NULL , [TODATE] [datetime] NULL , [RATE] [decimal](7, 2) NULL , [DIRT] [decimal](11, 2) NULL , [RESULT] [decimal](11, 2) NULL , [TOTAL] [decimal](11, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MemorisedBatchD] ( [MCODE] [char] (10) NOT NULL , [DESCRIPTION] [char] (30) NULL , [TYPE] [char] (1) NULL , [DATE] [datetime] NULL , [CODE] [char] (10) NULL , [REF] [char] (10) NULL , [FEE] [char] (3) NULL , [NARR] [char] (100) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [VALUE] [decimal](17, 2) NULL , [VATCODE] [char] (1) NULL , [VATVAL] [decimal](17, 2) NULL , [CLIENTYN] [char] (1) NULL , [OUTLAY] [char] (1) NULL , [THIRDPARTY] [char] (1) NULL , [PAYEE] [char] (40) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MemorsiedBatchH] ( [MCODE] [char] (10) NOT NULL , [DESCRIPTION] [char] (30) NULL , [TYPE] [char] (1) NULL , [DATE] [datetime] NULL , [CODE] [char] (10) NULL , [REF] [char] (10) NULL , [FEE] [char] (3) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [NARR] [char] (150) NULL , [VALUE] [decimal](17, 2) NULL , [CLIENTAC] [char] (1) NULL , [PAYEE] [char] (30) NULL , [INVCR] [char] (1) NULL , [THIRDPARTY] [char] (1) NULL , [CLIENTBANK] [char] (10) NULL , [CURRENCY] [char] (1) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MilestoneTypes] ( [CODE] [char] (12) NOT NULL , [DESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MiscCodes] ( [CDETYPE] [char] (3) NOT NULL , [CDECODE] [char] (40) NOT NULL , [CDEDESC] [char] (100) NULL , [CDETEAM] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MultiBatchD] ( [BATCHNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [CODE] [char] (10) NOT NULL , [PREF] [int] NOT NULL , [REF] [char] (10) NULL , [DATE] [datetime] NULL , [FEE] [char] (3) NULL , [NARR] [char] (100) NULL , [MATTER] [char] (11) NOT NULL , [SUPP] [char] (10) NOT NULL , [VALUE] [decimal](17, 2) NULL , [VATCODE] [char] (1) NULL , [VATVAL] [decimal](17, 2) NULL , [CLIENTYN] [char] (1) NULL , [OUTLAY] [char] (1) NULL , [PENDING] [char] (1) NULL , [YEAR] [smallint] NULL , [PERNO] [smallint] NULL , [ENTRYCURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CURRENCYVAT] [decimal](17, 2) NULL , [OUTLAYCODE] [char] (4) NULL , [THIRDPARTY] [char] (1) NULL , [PAYEE] [char] (30) NULL , [HEADPREF] [int] NULL , [HEADBATCH] [int] NULL , [ALLOCBATCH] [int] NULL , [ALLOCPREF] [int] NULL , [ALLOCREF] [char] (10) NULL , [ALLOCVALUE] [decimal](17, 2) NULL , [ALLOCWRITEOFF] [char] (1) NULL , [PSUPP] [char] (10) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MultiField] ( [OLDFIELDNAME] [char] (40) NOT NULL , [CASEPLAN] [char] (3) NOT NULL , [CATEGORY] [char] (12) NOT NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Narratives] ( [CODE] [char] (6) NOT NULL , [NARRATIVE] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NationCodes] ( [NATION] [char] (3) NOT NULL , [DESC] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NewNominal] ( [CODE] [char] (10) NOT NULL , [TYPE] [char] (4) NULL , [DESC] [char] (30) NULL , [CLIENTYN] [char] (1) NULL , [BALANCE] [decimal](15, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Nominal] ( [CODE] [char] (10) NOT NULL , [DESC] [char] (30) NULL , [TYPE] [char] (6) NULL , [PB] [char] (1) NULL , [BALANCE] [decimal](17, 2) NULL , [CURRENCYBAL] [decimal](17, 2) NULL , [BALANCEFWD] [decimal](17, 2) NULL , [CURRENCYBALFWD] [decimal](17, 2) NULL , [CURRENCY] [char] (1) NULL , [SEQ] [char] (4) NULL , [MONTH1] [decimal](17, 2) NULL , [MONTH2] [decimal](17, 2) NULL , [MONTH3] [decimal](17, 2) NULL , [MONTH4] [decimal](17, 2) NULL , [MONTH5] [decimal](17, 2) NULL , [MONTH6] [decimal](17, 2) NULL , [MONTH7] [decimal](17, 2) NULL , [MONTH8] [decimal](17, 2) NULL , [MONTH9] [decimal](17, 2) NULL , [MONTH10] [decimal](17, 2) NULL , [MONTH11] [decimal](17, 2) NULL , [MONTH12] [decimal](17, 2) NULL , [BUDGET1] [decimal](17, 2) NULL , [BUDGET2] [decimal](17, 2) NULL , [BUDGET3] [decimal](17, 2) NULL , [BUDGET4] [decimal](17, 2) NULL , [BUDGET5] [decimal](17, 2) NULL , [BUDGET6] [decimal](17, 2) NULL , [BUDGET7] [decimal](17, 2) NULL , [BUDGET8] [decimal](17, 2) NULL , [BUDGET9] [decimal](17, 2) NULL , [BUDGET10] [decimal](17, 2) NULL , [BUDGET11] [decimal](17, 2) NULL , [BUDGET12] [decimal](17, 2) NULL , [LASTYEAR1] [decimal](17, 2) NULL , [LASTYEAR2] [decimal](17, 2) NULL , [LASTYEAR3] [decimal](17, 2) NULL , [LASTYEAR4] [decimal](17, 2) NULL , [LASTYEAR5] [decimal](17, 2) NULL , [LASTYEAR6] [decimal](17, 2) NULL , [LASTYEAR7] [decimal](17, 2) NULL , [LASTYEAR8] [decimal](17, 2) NULL , [LASTYEAR9] [decimal](17, 2) NULL , [LASTYEAR10] [decimal](17, 2) NULL , [LASTYEAR11] [decimal](17, 2) NULL , [LASTYEAR12] [decimal](17, 2) NULL , [LASTNO] [decimal](9, 0) NULL , [CLIENTAC] [char] (1) NULL , [CHEQUEPRINTER] [char] (40) NULL , [DEPOSITYN] [char] (1) NULL , [DEPOSITTYPE] [char] (4) NULL , [ACCRUAL] [decimal](13, 2) NULL , [SORTCODE] [char] (10) NULL , [BANK] [char] (40) NULL , [BANKBRANCH] [char] (40) NULL , [ACCOUNTNO] [char] (10) NULL , [ACCOUNTNAME] [char] (50) NULL , [BANKADDRESS] [char] (120) NULL , [BANKPHONE] [char] (20) NULL , [WITHDRAWNAMES] [char] (255) NULL , [ACOPENED] [datetime] NULL , [ACCLOSED] [datetime] NULL , [ChequeReq] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NominalLedger] ( [CODE] [char] (10) NULL , [BRANCH] [char] (1) NULL , [BATCHNO] [int] NULL , [PREF] [int] NULL , [DATE] [datetime] NULL , [REF] [char] (10) NULL , [NARR] [char] (100) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [FEE] [char] (3) NULL , [VALUE] [decimal](17, 2) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [PER] [smallint] NULL , [YEAR] [smallint] NULL , [ENTRYDATE] [datetime] NULL , [RECNO] [int] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NominalReportSeq] ( [CODE] [char] (4) NOT NULL , [DESC] [char] (40) NULL , [PB] [char] (1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NominalTypes] ( [NTYCODE] [char] (6) NOT NULL , [NTYDESC] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Officers] ( [CONTACTCODE] [char] (6) NOT NULL , [CONTACTOFFICER] [char] (6) NULL , [NAME] [char] (30) NULL , [COSECRETARY] [char] (1) NULL , [DATEAPPOINTED] [datetime] NULL , [DATERESIGNED] [datetime] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OutlayCode] ( [CODE] [char] (4) NOT NULL , [DESCRIPTION] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OutlayTransfer] ( [MATTER] [char] (11) NOT NULL , [DEBTBAL] [decimal](17, 2) NULL , [OUTLAYBAL] [decimal](17, 2) NULL , [CLIENTBAL] [decimal](17, 2) NULL , [TRANSFERVALUE] [decimal](13, 2) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OutlookIds] ( [ACTIONID] [decimal](15, 0) NOT NULL , [OUTLOOKID] [char] (256) NOT NULL , [EXCHANGEALIAS] [char] (256) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PFKCtrl] ( [KEYFIELD] [int] NULL , [TEMPBATCHNO] [int] NULL , [TEMPPREFNO] [int] NULL , [WORKTYPE] [char] (4) NULL , [DEPT] [char] (3) NULL , [FECODE] [char] (3) NULL , [CODE] [char] (10) NULL , [LASTACTION] [char] (1) NULL , [INVOICECODE] [char] (2) NULL , [LASTINVOICENO] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PFKOutlay] ( [CODE] [char] (8) NULL , [DESC] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PendingOutlay] ( [MATTER] [char] (11) NOT NULL , [DATE] [datetime] NOT NULL , [SUPPLIER] [char] (6) NOT NULL , [REF] [char] (8) NULL , [NARRATIVE] [char] (100) NULL , [VALUE] [decimal](11, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[RBatchD] ( [BATCHNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [CODE] [char] (10) NULL , [PREF] [int] NOT NULL , [REF] [char] (10) NULL , [DATE] [datetime] NOT NULL , [FEE] [char] (3) NULL , [NARR] [char] (100) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [VALUE] [decimal](17, 2) NULL , [VATCODE] [char] (1) NULL , [VATVAL] [decimal](17, 2) NULL , [CLIENTYN] [char] (1) NULL , [OUTLAY] [char] (1) NULL , [PENDING] [char] (1) NULL , [YEAR] [smallint] NULL , [PERNO] [smallint] NULL , [ENTRYCURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CURRENCYVAT] [decimal](17, 2) NULL , [OUTLAYCODE] [char] (4) NULL , [THIRDPARTY] [char] (1) NULL , [PAYEE] [char] (60) NULL , [HEADPREF] [int] NULL , [HEADBATCH] [int] NULL , [ALLOCBATCH] [int] NULL , [ALLOCPREF] [int] NULL , [ALLOCREF] [char] (10) NULL , [ALLOCVALUE] [decimal](17, 2) NULL , [ALLOCWRITEOFF] [char] (1) NULL , [PSUPP] [char] (10) NULL , [UNDETAKING] [smallint] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[RBatchH] ( [BATCHNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [CODE] [char] (10) NULL , [PREF] [int] NULL , [REF] [char] (10) NULL , [DATE] [datetime] NOT NULL , [FEE] [char] (3) NULL , [MATTER] [char] (11) NULL , [SUPP] [char] (10) NULL , [NARR] [char] (150) NULL , [VALUE] [decimal](17, 2) NULL , [SUBTOT] [decimal](17, 2) NULL , [POSTED] [char] (1) NULL , [CLIENTAC] [char] (1) NULL , [PERNO] [smallint] NULL , [YEAR] [smallint] NULL , [PAYEE] [char] (60) NULL , [OUTLAYTOT] [decimal](17, 2) NULL , [VATTOT] [decimal](17, 2) NULL , [FEETOT] [decimal](17, 2) NULL , [INVCR] [char] (1) NULL , [THIRDPARTY] [char] (1) NULL , [USERCODE] [char] (8) NULL , [ENTRYDATE] [datetime] NULL , [CLIENTBANK] [char] (10) NULL , [CURRENCY] [char] (1) NULL , [CURRENCYVALUE] [decimal](17, 2) NULL , [CUROUTLAYTOT] [decimal](17, 2) NULL , [CURVATTOT] [decimal](17, 2) NULL , [CURFEETOT] [decimal](17, 2) NULL , [RECNO] [int] NULL , [SINGLELINE] [char] (1) NULL , [TEMPLATE] [char] (10) NULL , [CHEQUEREQNO] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[RecentMatterList] ( [FEE] [char] (3) NOT NULL , [MATTER] [char] (11) NOT NULL , [DateField] [datetime] NULL , [TIME] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ReferralControl] ( [INSEQUENCE] [decimal](7, 2) NULL , [OUTSEQUENCE] [decimal](7, 2) NULL , [INFOLDER] [char] (400) NULL , [OUTFOLDER] [char] (400) NULL , [RECORDID] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SAM3Fields] ( [FORMAT] [char] (20) NULL , [F_NAME] [char] (30) NOT NULL , [F_DESC] [char] (50) NULL , [FILE] [char] (5) NOT NULL , [CATEGORY] [char] (1) NULL , [CLOSEFORMAT] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SAMMessages] ( [MESSAGE] [char] (255) NOT NULL , [HEADING] [char] (255) NOT NULL , [DATE] [datetime] NOT NULL , [TIME] [int] NOT NULL , [BUTTON] [int] NULL , [DURATION] [int] NULL , [NAME] [char] (100) NOT NULL , [FLAG] [int] NULL , [EXTRAS] [char] (100) NULL , [EXTRAL] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SQLResult] ( [FIELDRESULT] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SQLResultD] ( [RESULTFIELD] [decimal](19, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SalutationCodes] ( [Code] [char] (6) NOT NULL , [Description] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sec_Roles] ( [RoleID] [varchar] (30) NOT NULL , [Description] [varchar] (120) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sec_Users] ( [UID] [varchar] (100) NOT NULL , [PWD] [char] (10) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sec_UsersRoles] ( [UserID] [varchar] (100) NOT NULL , [RoleID] [varchar] (30) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ServiceCodes] ( [CODE] [char] (6) NOT NULL , [DESCRIPTION] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[StatusCodes] ( [CODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (50) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[StatusId] ( [StatusId] [smallint] NOT NULL , [Description] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SupplierLedger] ( [SUPP] [char] (10) NOT NULL , [TYPE] [char] (1) NULL , [DATE] [datetime] NOT NULL , [REF] [char] (10) NULL , [BATCHNO] [int] NOT NULL , [PREF] [int] NOT NULL , [NARR] [char] (80) NULL , [ORIGINAL] [decimal](17, 2) NULL , [OSVALUE] [decimal](17, 2) NULL , [YEAR] [smallint] NULL , [PER] [smallint] NULL , [ENTRYDATE] [datetime] NULL , [THIRDPARTY] [char] (1) NULL , [THIRDPARTYVALUE] [decimal](13, 2) NULL , [MATTER] [char] (11) NULL , [PENDINGOUTLAY] [decimal](17, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Suppliers] ( [CODE] [char] (6) NOT NULL , [NAME] [char] (40) NULL , [ADDRESS] [char] (120) NULL , [NOMINAL] [char] (10) NOT NULL , [BALANCE] [decimal](15, 2) NULL , [BALANCEFWD] [decimal](15, 2) NULL , [TAXNO] [char] (15) NULL , [SERVICEDESC] [char] (6) NULL , [TPBAL] [decimal](15, 2) NULL , [DEFTPSTATUS] [char] (1) NULL , [COUNSEL] [char] (1) NULL , [UNALLOCATED] [decimal](13, 2) NULL , [PAYRUNTOTAL] [decimal](13, 2) NULL , [VATNo] [varchar] (20) NULL , [Phone] [varchar] (20) NULL , [Retired] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SystemConfig] ( [SCACCOUNTLINK] [char] (50) NULL , [SCCOPYFOLDER] [char] (80) NULL , [EMAILON] [char] (1) NULL , [STORAGEMETHOD] [char] (1) NULL , [SCFILENUMBER] [char] (1) NULL , [SCFILESTARTNO] [smallint] NULL , [SCIMAGEVIEWER] [char] (80) NULL , [SCLICENCE] [char] (1) NULL , [SCPRECEDENTFOLDER] [char] (80) NULL , [SCPRECEDENTFORMAT] [char] (20) NULL , [SCREPORTFOLDER] [char] (80) NULL , [SCREPORTLINES] [smallint] NULL , [SCREPORTVIEWER] [char] (80) NULL , [SCSTARTFORM] [char] (50) NULL , [SCSYSTEMNAME] [char] (50) NULL , [SCUSERID] [char] (20) NOT NULL , [SCUSERNUMBERS] [smallint] NULL , [SCWPFOLDER] [char] (80) NULL , [SCWPPRODUCT] [char] (50) NULL , [WPDELIMITER] [char] (1) NULL , [WPDELIMITEREND] [char] (1) NULL , [SCWPFORMAT] [char] (8) NULL , [SCACCOUNTFOLDER] [char] (100) NULL , [SCIMAGESORT] [char] (2) NULL , [SCTRACKREFNUM] [smallint] NULL , [SCIND1] [char] (1) NULL , [SCIND2] [char] (1) NULL , [SCIND3] [char] (1) NULL , [SCIND4] [char] (1) NULL , [SCIND5] [char] (1) NULL , [SCIND6] [char] (1) NULL , [SCIND7] [char] (1) NULL , [SCIND8] [char] (1) NULL , [SCIND9] [char] (1) NULL , [SCIND10] [char] (1) NULL , [SCIND11] [char] (1) NULL , [SCIND12] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SystemFiles] ( [NAME] [char] (30) NOT NULL , [PREFIX] [char] (5) NULL , [ACTUAL_PREFIX] [char] (5) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SystemUserDefinedFields] ( [FILEPREFIX] [char] (5) NOT NULL , [FIELDNAME] [char] (30) NOT NULL , [TYPE] [char] (11) NULL , [PROMPT] [char] (80) NULL , [LENGTH] [decimal](5, 0) NULL , [DECMIAL] [decimal](3, 0) NULL , [FORMAT] [char] (10) NULL , [INITIALVALUE] [char] (255) NULL , [CALCINITIALVALUE] [char] (1) NULL , [OVERRIDEINITIALVALUE] [char] (1) NULL , [REQUIRED] [char] (1) NULL , [VALIDATION] [char] (1) NULL , [LOW] [decimal](9, 2) NULL , [HIGH] [decimal](9, 2) NULL , [SYSTEMFIELD] [char] (1) NULL , [TOP] [decimal](5, 0) NULL , [LEFT] [decimal](5, 2) NULL , [HEIGHT] [decimal](5, 0) NULL , [WIDTH] [decimal](5, 2) NULL , [FONT] [char] (20) NULL , [VISIBLE] [char] (1) NULL , [ENABLED] [char] (1) NULL , [READONLY] [char] (1) NULL , [MULTILINE] [char] (1) NULL , [ACTUALNAME] [char] (200) NULL , [COMMON] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TableName] ( [FileName] [char] (200) NOT NULL , [SQLName] [char] (200) NULL , [Type] [char] (12) NULL , [TagId] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TaggedSupLed] ( [Supp] [char] (10) NULL , [Type] [char] (1) NULL , [Date] [datetime] NULL , [Ref] [char] (10) NULL , [BatchNo] [int] NULL , [PRef] [int] NULL , [Narr] [char] (80) NULL , [Original] [decimal](18, 2) NULL , [OSValue] [decimal](18, 2) NULL , [Year] [int] NULL , [Per] [int] NULL , [EntryDate] [datetime] NULL , [ThirdParty] [char] (1) NULL , [ThirdPartyValue] [decimal](18, 2) NULL , [Matter] [char] (11) NULL , [PendingOutlay] [decimal](18, 2) NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TaskTypes] ( [CODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TasksCodes] ( [CODE] [char] (6) NOT NULL , [DESC] [char] (30) NULL , [DEFAULT] [float] NULL , [UDFLEN1] [int] NULL , [UDFLEN2] [int] NULL , [UDFLEN3] [int] NULL , [UDFLEN4] [int] NULL , [UDFLEN5] [int] NULL , [UDFLEN6] [int] NULL , [UDFPROMPT1] [char] (20) NULL , [UDFPROMPT2] [char] (20) NULL , [UDFPROMPT3] [char] (20) NULL , [UDFPROMPT4] [char] (20) NULL , [UDFPROMPT5] [char] (20) NULL , [UDFPROMPT6] [char] (20) NULL , [CHARGEAMT] [decimal](11, 2) NULL , [REC_IRR] [char] (1) NULL , [CHARGELEVEL] [char] (1) NULL , [StageCode] [char] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TaxHead] ( [TAXHEAD] [char] (2) NOT NULL , [DESCRIPTION] [varchar] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Team] ( [CODE] [char] (3) NOT NULL , [NAME] [char] (30) NULL , [DEPT] [char] (3) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TeamMembers] ( [TEAMCODE] [char] (3) NOT NULL , [HANDLER] [char] (3) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TempBatchD] ( [BatchNo] [int] NOT NULL , [Type] [char] (1) NULL , [Code] [char] (10) NULL , [PRef] [int] NOT NULL , [Ref] [char] (10) NULL , [Date] [datetime] NULL , [Fee] [char] (3) NULL , [Branch] [char] (1) NULL , [Narr] [char] (100) NULL , [Matter] [char] (11) NULL , [KellyRef] [char] (20) NULL , [Supp] [char] (10) NULL , [Value] [decimal](17, 2) NULL , [VatCode] [char] (1) NULL , [VATVal] [decimal](17, 2) NULL , [ClientYN] [char] (1) NULL , [Outlay] [char] (1) NULL , [Pending] [char] (1) NULL , [Year] [smallint] NULL , [PerNo] [smallint] NULL , [EntryCurrency] [char] (1) NULL , [CurrencyValue] [decimal](17, 2) NULL , [CurrencyVAT] [decimal](17, 2) NULL , [OutlayCode] [char] (4) NULL , [ThirdParty] [char] (1) NULL , [Payee] [char] (30) NULL , [HeadPRef] [int] NULL , [HeadBatch] [int] NULL , [AllocBatch] [int] NULL , [AllocPRef] [int] NULL , [AllocRef] [char] (10) NULL , [AllocValue] [decimal](17, 2) NULL , [AllocWriteOff] [char] (1) NULL , [PSupp] [char] (10) NULL , [Undetaking] [int] NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TempBatchH] ( [OutlayCode] [char] (6) NULL , [PettyInvoice] [char] (1) NULL , [BatchNo] [int] NOT NULL , [PostFwd] [char] (1) NULL , [Type] [char] (1) NULL , [Code] [char] (10) NULL , [Branch] [char] (1) NULL , [PRef] [int] NULL , [Ref] [char] (10) NULL , [Date] [datetime] NULL , [Fee] [char] (3) NULL , [Matter] [char] (11) NULL , [KellyRef] [char] (20) NULL , [Supp] [char] (10) NULL , [Narr] [char] (150) NULL , [Value] [decimal](17, 2) NULL , [SubTot] [decimal](17, 2) NULL , [Posted] [char] (1) NULL , [ClientAc] [char] (1) NULL , [PerNo] [smallint] NULL , [Year] [smallint] NULL , [Payee] [char] (60) NULL , [OutlayTot] [decimal](17, 2) NULL , [VATTot] [decimal](17, 2) NULL , [FeeTot] [decimal](17, 2) NULL , [InvCr] [char] (1) NULL , [ThirdParty] [char] (1) NULL , [UserCode] [char] (8) NULL , [EntryDate] [datetime] NULL , [ClientBank] [char] (10) NULL , [Currency] [char] (1) NULL , [CurrencyValue] [decimal](17, 2) NULL , [CurOutlayTot] [decimal](17, 2) NULL , [CurVATTot] [decimal](17, 2) NULL , [CurFeeTot] [decimal](17, 2) NULL , [RecNo] [int] NULL , [SingleLine] [char] (1) NULL , [Template] [char] (10) NULL , [ChequeReqno] [int] NULL , [WriteDown] [datetime] NULL , [WriteBackHours] [decimal](7, 2) NULL , [WriteBackValue] [decimal](17, 2) NULL , [CorrectCopy] [char] (1) NULL , [KellyRecordId] [int] NULL , [Rejected] [char] (1) NULL , [RejectedDate] [datetime] NULL , [RejectedReason] [char] (250) NULL , [AddedToSAM] [char] (1) NULL , [KellyInvoiceNumber] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateActionCommands] ( [ACTIONCODE] [char] (15) NOT NULL , [ORDER] [decimal](3, 0) NOT NULL , [COMMAND] [char] (255) NULL , [PARAMETERS] [char] (255) NULL , [DESCRIPTION] [char] (400) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateActionDcouments] ( [ACTION] [char] (15) NOT NULL , [DOCUMENT] [char] (10) NOT NULL , [OPTIONAL] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateActionTypes] ( [CODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (80) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateActionUDF] ( [ACTIONCODE] [char] (15) NOT NULL , [FILEPREFIX] [char] (5) NOT NULL , [FIELDNAME] [char] (30) NOT NULL , [VALUE] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateActions] ( [ACTIONCODE] [char] (15) NOT NULL , [DESC] [char] (100) NULL , [WKTCODE] [char] (4) NULL , [ACTTYPE] [char] (1) NULL , [ACTIONCATEGORY] [char] (1) NULL , [STATUS] [char] (3) NULL , [PROCESSTYPE] [char] (1) NULL , [PUBLISHER] [char] (1) NULL , [UPDATEFIELD] [char] (30) NULL , [UPDATEVALUE] [char] (255) NULL , [HIGHLIGHTED] [char] (1) NULL , [MILESTONETYPE] [char] (12) NULL , [PRIORITY] [char] (6) NULL , [NEXTACTIONOPTIONAL] [char] (1) NULL , [BILLABLE] [char] (1) NULL , [EMAIL] [char] (1) NULL , [BILLDESCRIPTION] [char] (150) NULL , [AssignActionTo] [char] (1) NULL , [ASSIGNHANDLER] [char] (3) NULL , [AssignTeamActionTo] [char] (1) NULL , [ASSIGNTEAM] [char] (3) NULL , [ChargeValue] [decimal](18, 0) NULL , [Arrangement] [char] (3) NULL , [ChargeInterest] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateCopyAssociates] ( [PlanCode] [char] (3) NOT NULL , [AssociateType] [char] (12) NOT NULL , [AskUser] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateDocumentUDF] ( [DUVDOCCODE] [char] (40) NOT NULL , [DUVUVCODE] [char] (40) NOT NULL , [DUVQRYNO] [smallint] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateDocumentUDFs] ( [UDFCODE] [char] (30) NOT NULL , [DOCUMENT] [char] (10) NOT NULL , [OPTIONAL] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateDocuments] ( [CODE] [char] (10) NOT NULL , [FILEPATH] [char] (255) NULL , [NAME] [char] (100) NULL , [TYPE] [char] (3) NULL , [DOCCLASS] [char] (3) NULL , [STORE] [char] (4) NULL , [DICTATION] [char] (1) NULL , [OPENDURINGDICTATION] [char] (1) NULL , [StartToken] [char] (2) NULL , [EndToken] [char] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateEmails] ( [RecordId] [int] IDENTITY (1, 1) NOT NULL , [ActionID] [char] (15) NOT NULL , [EmailTo] [varchar] (1000) NULL , [EmailCc] [varchar] (1000) NULL , [EmailBcc] [varchar] (1000) NULL , [Subject] [varchar] (1000) NULL , [Body] [text] NULL , [IncludeAttachments] [char] (1) NULL , [RequestReadRecipt] [char] (1) NULL , [Priority] [char] (1) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[TemplateNextActions] ( [ACTION] [char] (15) NOT NULL , [NEXTACTION] [char] (15) NOT NULL , [DECISION] [char] (6) NULL , [OPTIONAL] [char] (1) NULL , [WHENTYPE] [char] (7) NULL , [WHEN] [decimal](7, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Templates] ( [WKTYPE] [char] (3) NULL , [WKCODE] [char] (4) NOT NULL , [WKDESC] [char] (40) NULL , [WKACTION] [char] (15) NULL , [WKACCSRN] [char] (1) NULL , [WKSRNLIT] [char] (1) NULL , [WKSRNCON] [char] (1) NULL , [WKSRNPRB] [char] (1) NULL , [WKSRNDRC] [char] (1) NULL , [WKSRNGEN] [char] (1) NULL , [WKPATH] [char] (200) NULL , [Dept] [char] (3) NULL , [SourceMatter] [char] (11) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TestTable] ( [MatterCode] [char] (11) NOT NULL , [TestField1] [char] (10) NULL , [TestDate1] [datetime] NULL , [TestValue] [decimal](18, 2) NULL , [Newfield] [char] (100) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TimeAdminCodes] ( [NCCODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (30) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TimeDayBook] ( [MATTER] [char] (11) NOT NULL , [FEEEARN] [char] (3) NOT NULL , [DATE] [datetime] NOT NULL , [TIME] [decimal](5, 0) NULL , [RATE] [decimal](10, 2) NULL , [CHARGE] [decimal](10, 2) NULL , [TASK] [char] (6) NOT NULL , [TIMEORCHARGE] [char] (1) NULL , [STARTTIME] [int] NULL , [COMMENT] [char] (255) NULL , [NCCCODE] [char] (3) NULL , [TEAM] [char] (3) NULL , [TRACKREF] [decimal](9, 0) NULL , [DOCKET] [char] (8) NULL , [REC_IRR] [char] (1) NULL , [PERIOD] [int] NULL , [YEAR] [int] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL , [ActionId] [int] NULL , [Leave] [char] (1) NULL , [StageCode] [char] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TimeEntry] ( [MATTER] [char] (11) NOT NULL , [FEEEARN] [char] (3) NULL , [DATE] [datetime] NULL , [TIME] [decimal](7, 0) NULL , [RATE] [decimal](10, 2) NULL , [CHARGE] [decimal](10, 2) NULL , [TASK] [char] (6) NULL , [TIMEORCHARGE] [char] (1) NULL , [COMMENT] [char] (255) NULL , [BILLED] [decimal](13, 2) NULL , [NCCODE] [char] (3) NULL , [DOCKET] [decimal](9, 0) NULL , [TEAM] [char] (3) NULL , [TRACKREF] [decimal](9, 0) NULL , [REC_IRR] [char] (1) NULL , [SHOULDHAVE] [decimal](13, 2) NULL , [INVOICENO] [int] NULL , [PERIOD] [int] NULL , [YEAR] [int] NULL , [BILLINGPERIOD] [int] NULL , [BILLINGYEAR] [int] NULL , [OPENINV] [char] (1) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL , [ActionId] [int] NULL , [Leave] [char] (1) NULL , [StageCode] [char] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TransferList] ( [MATTER] [char] (11) NOT NULL , [BATCHNO] [int] NOT NULL , [PREF] [int] NULL , [BILLNO] [char] (8) NULL , [DATE] [datetime] NULL , [ORIGVALUE] [decimal](11, 2) NULL , [ORIGFEES] [decimal](11, 2) NULL , [ORIGVAT] [decimal](11, 2) NULL , [ORIGOUTLAY] [decimal](11, 2) NULL , [OSVALUE] [decimal](11, 2) NULL , [OSFEES] [decimal](11, 2) NULL , [OSVAT] [decimal](11, 2) NULL , [OSOUTLAY] [decimal](11, 2) NULL , [TRANSFERVALUE] [decimal](13, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[UDFDefinition] ( [UVTYPE] [char] (3) NOT NULL , [UVCODE] [char] (40) NOT NULL , [UVSHORTCODE] [char] (30) NOT NULL , [UVDESC] [char] (80) NULL , [UDVINTEL] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[UDFLookups] ( [FIELDNAME] [char] (30) NOT NULL , [CODE] [char] (3) NOT NULL , [DESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[UDFTemplatesWorkTypes] ( [UDUVCODE] [char] (30) NOT NULL , [UDFILE] [char] (5) NOT NULL , [UDWKCODE] [char] (4) NOT NULL , [UDSEQ] [smallint] NOT NULL , [IncludeInMatterCopy] [char] (1) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Undertakings] ( [MATTER] [char] (11) NOT NULL , [SEQ] [smallint] NOT NULL , [DATE] [datetime] NOT NULL , [DISCHARGEDATE] [int] NULL , [TYPE] [char] (1) NULL , [DESCRIPTION] [char] (100) NULL , [WHO] [char] (40) NULL , [VALUE] [decimal](13, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[VATCodes] ( [CODE] [char] (1) NOT NULL , [RATE] [decimal](5, 2) NULL , [INVOICESNET] [decimal](15, 2) NULL , [INVOICESVAT] [decimal](15, 2) NULL , [BILLSNET] [decimal](15, 2) NULL , [BILLSVAT] [decimal](15, 2) NULL , [RECEIPTSNET] [decimal](15, 2) NULL , [RECEIPTSVAT] [decimal](15, 2) NULL , [PAYMENTSNET] [decimal](15, 2) NULL , [PAYMENTSVAT] [decimal](15, 2) NULL , [JOURNALSNET] [decimal](15, 2) NULL , [JOURNALSVAT] [decimal](15, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[VATReportExtract] ( [BATCHNO] [int] NOT NULL , [TYPE] [char] (1) NULL , [PREF] [int] NOT NULL , [REF] [char] (10) NULL , [DATE] [datetime] NULL , [VALUE] [decimal](15, 2) NULL , [VATCODE] [char] (1) NULL , [VATVAL] [decimal](15, 2) NULL , [UNALLOC] [decimal](15, 2) NULL , [YEAR] [smallint] NULL , [PERNO] [smallint] NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebActions] ( [ActionID] [int] IDENTITY (1, 1) NOT NULL , [Description] [varchar] (120) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebAssociates] ( [WebAssociateID] [int] IDENTITY (1, 1) NOT NULL , [FormId] [int] NOT NULL , [CaseAssociateType] [char] (12) NOT NULL , [AssociateLabel] [varchar] (50) NOT NULL , [AssociateOrder] [int] NULL , [PopupSelection] [char] (1) NOT NULL , [AllowMultiples] [char] (1) NOT NULL , [DefaultMultiples] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebAssociatesFields] ( [WebAssociateFieldID] [int] IDENTITY (1, 1) NOT NULL , [WebAssociateId] [int] NOT NULL , [FieldPrefix] [char] (5) NOT NULL , [FieldName] [char] (30) NOT NULL , [FieldOrder] [int] NOT NULL , [FieldLabel] [char] (30) NULL , [FieldTip] [varchar] (100) NULL , [Required] [char] (1) NOT NULL , [ControlTypeID] [int] NULL , [Lines] [tinyint] NULL , [WidthChars] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebControlTypes] ( [ControlTypeID] [int] IDENTITY (1, 1) NOT NULL , [Description] [varchar] (50) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebFields] ( [RecordId] [int] IDENTITY (1, 1) NOT NULL , [FormId] [int] NOT NULL , [FilePreFix] [char] (5) NOT NULL , [FieldName] [char] (30) NOT NULL , [FieldOrder] [int] NOT NULL , [FieldLabel] [char] (50) NULL , [Required] [char] (1) NULL , [FieldTip] [varchar] (100) NULL , [ControlTypeID] [int] NOT NULL , [Lines] [tinyint] NULL , [WidthChars] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebForms] ( [FormId] [int] IDENTITY (1, 1) NOT NULL , [FormName] [varchar] (50) NOT NULL , [Title] [varchar] (200) NULL , [CasePlanCode] [char] (4) NOT NULL , [Handler] [char] (3) NULL , [Team] [char] (3) NULL , [InitialActionCode] [char] (15) NOT NULL , [RequestAction] [char] (15) NULL , [Department] [char] (3) NULL , [WorkType] [char] (4) NULL , [FeCode] [char] (3) NULL , [TemplateCode] [char] (4) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WebForms_Actions] ( [FormID] [int] NOT NULL , [ActionID] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Wills] ( [CONTACT] [char] (6) NOT NULL , [TESTATOR] [char] (30) NULL , [EXECUTOR] [char] (30) NULL , [EXECUTORADDR] [char] (100) NULL , [EXECKEY] [char] (10) NOT NULL , [WILLDATE] [datetime] NULL , [FE] [char] (3) NULL , [COMMENT] [text] NULL , [LOCATION] [char] (10) NULL , [ESTIMATEESTATE] [decimal](13, 2) NULL , [LASTACCESS] [datetime] NULL , [LASTACCESSWHO] [char] (8) NULL , [RECORDID] [decimal](17, 0) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[WorkInProgressReport] ( [MATTER] [char] (11) NOT NULL , [FECODE] [char] (3) NOT NULL , [WIPHRS] [decimal](9, 2) NULL , [WIPVALUE] [decimal](11, 2) NULL , [BILLDATE] [datetime] NULL , [BILLTOTAL] [decimal](13, 2) NULL , [BILLFEES] [decimal](13, 2) NULL , [BILLTIMEVAL] [decimal](13, 2) NULL , [RECORDID] [decimal](17, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[WorkTypes] ( [CODE] [char] (4) NOT NULL , [DESC] [char] (50) NULL , [RETIRED] [char] (1) NULL , [Description] [char] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[children] ( [CONTACT] [char] (6) NOT NULL , [NAME] [char] (15) NULL , [COMMENT] [char] (40) NULL , [DOB] [datetime] NULL , [KeyID] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[client] ( [CLCODE] [char] (6) NOT NULL , [CLNAME] [char] (50) NOT NULL , [CLFNR] [char] (3) NOT NULL , [CLGRP] [char] (3) NULL , [CLADDR] [char] (80) NULL , [CLLEGALNAME] [char] (150) NULL , [CLLEGALADDR] [char] (80) NULL , [CLTEL] [char] (20) NULL , [CLFAX] [char] (20) NULL , [CLMOBNO] [char] (20) NULL , [CLEMAIL] [char] (50) NULL , [CLTYPE] [char] (1) NULL , [CLNEXTCSENO] [smallint] NULL , [CLCSECOUNT] [smallint] NULL , [ClMartialCde] [char] (3) NULL , [ClDateBirth_DATE] [datetime] NULL , [CLNUMCHILD] [smallint] NULL , [CLOCCUPCDE] [char] (3) NULL , [CLEMPLOYER] [char] (40) NULL , [CLCONTACTCDE] [char] (3) NULL , [CLHOUSEYN] [char] (1) NULL , [CLFAMILYYN] [char] (1) NULL , [CLCLIENTYN] [char] (1) NULL , [CLBUSYN] [char] (1) NULL , [CLOTHERYN] [char] (1) NULL , [DCOUMENTFOLDER] [char] (200) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[contacthistory] ( [CONTACT] [char] (6) NOT NULL , [DATE] [int] NOT NULL , [DETAIL] [char] (60) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[control] ( [NAME] [char] (40) NOT NULL , [DEBTORS] [char] (10) NULL , [CREDITOR] [char] (10) NULL , [VATNO] [char] (20) NULL , [OUTLAY] [char] (10) NULL , [OUTLAYPENDING] [char] (10) NULL , [VAT] [char] (10) NULL , [CLIENT] [char] (10) NULL , [PL] [char] (10) NULL , [FEESWRITEOFF] [char] (10) NULL , [OUTLAYWRITEOFF] [char] (10) NULL , [BILLSWRITEOFF] [char] (10) NULL , [YEAR] [smallint] NULL , [CURPER] [smallint] NULL , [LASTBATCH] [int] NULL , [LASTBILL] [int] NULL , [LASTPREF] [int] NULL , [LASTALLOC] [int] NULL , [LASTCLIENT] [int] NULL , [DEFAULTCATEGORY] [char] (6) NULL , [SOLICITORTYPE] [char] (6) NULL , [SOLICITOR] [char] (6) NULL , [SUPPLIERCATEGORY] [char] (6) NULL , [OTHPARTY] [char] (6) NULL , [NEXTFILE] [int] NULL , [VATEXCLUDE] [char] (1) NULL , [FEEEXCLUDE] [char] (4) NULL , [BASECURRENCY] [char] (1) NULL , [EICONVERT] [decimal](9, 6) NULL , [IECONVERT] [decimal](9, 6) NULL , [LASTRECON] [int] NULL , [ENABLEFNL] [char] (1) NULL , [ENABLECDB] [char] (1) NULL , [ENABLEDW] [char] (1) NULL , [ENABLEFM] [char] (1) NULL , [ENABLECP] [char] (1) NULL , [RECINSTALLED] [char] (1) NULL , [NOBAR] [char] (1) NULL , [WORDPERFECT] [char] (1) NULL , [AUTONUMBER] [char] (1) NULL , [OPSISLINK] [char] (1) NULL , [CHEQUEPRINTING] [char] (2) NULL , [TIMECOSTING] [char] (1) NULL , [FORCEFE] [char] (1) NULL , [UK] [char] (1) NULL , [USEOUTLAYTYPE] [char] (1) NULL , [PENDINGOUTLAY] [char] (1) NULL , [AUTOALPHACLIENTNUMBERING] [char] (1) NULL , [INDICATOR18] [char] (1) NULL , [INDICATOR19] [char] (1) NULL , [INDICATOR20] [char] (1) NULL , [YEARENDCOMPLETED] [char] (1) NULL , [INDICATOR22] [char] (1) NULL , [INDICATOR23] [char] (1) NULL , [INDICATOR24] [char] (1) NULL , [INDICATOR25] [char] (1) NULL , [INDICATOR26] [char] (1) NULL , [INDICATOR27] [char] (1) NULL , [INDICATOR28] [char] (1) NULL , [INDICATOR29] [char] (1) NULL , [INDICATOR30] [char] (1) NULL , [THIRDPARTYLIMIT] [decimal](7, 2) NULL , [DATEFUTVALIDATION] [smallint] NULL , [DATEPASTVALIDATION] [smallint] NULL , [DEMOEXPIRE] [int] NULL , [WP_DIR] [char] (50) NULL , [NEXT_DOC_NO] [int] NOT NULL , [LABELPRINTER] [char] (1) NULL , [USERPROMPT1] [char] (20) NULL , [USERPROMPT2] [char] (20) NULL , [USERPROMPT3] [char] (20) NULL , [MAXNUMBEROFMATTERS] [decimal](5, 0) NULL , [OUTLAYBUDGET] [decimal](7, 2) NULL , [PERIODEND] [int] NULL , [LASTRECDATE] [int] NULL , [LASTRECCLDIFF] [decimal](13, 2) NULL , [LASTRECOLDIFF] [decimal](13, 2) NULL , [LASTRECDRDIFF] [decimal](13, 2) NULL , [LASTRECSUDIFF] [decimal](13, 2) NULL , [LASTRECCLBKDIFF] [decimal](13, 2) NULL , [P1BATCH] [int] NULL , [P2BATCH] [int] NULL , [P3BATCH] [int] NULL , [P4BATCH] [int] NULL , [P5BATCH] [int] NULL , [P6BATCH] [int] NULL , [P7BATCH] [int] NULL , [P8BATCH] [int] NULL , [P9BATCH] [int] NULL , [P10BATCH] [int] NULL , [P11BATCH] [int] NULL , [P12BATCH] [int] NULL , [DEFAULTOFFICEAC] [char] (10) NULL , [DEFAULTOUTLAYBK] [char] (10) NULL , [DEFAULTCLIENTAC] [char] (10) NULL , [DEFAULTCLIENTDEP] [char] (10) NULL , [DEFAULTVAT] [char] (1) NULL , [DATELASTRECBAL] [int] NULL , [BATCHLASTBALREC] [int] NULL , [MISCOUTLAY] [char] (10) NULL , [PETTYCASH] [char] (10) NULL , [WITHTAX] [char] (10) NULL , [BUILDNO] [int] NULL , [CLOSEDFILENO] [int] NULL , [FEESREPSEQ] [char] (20) NULL , [MISCFE] [char] (4) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[csaccounts] ( [ACCASECODE] [char] (18) NOT NULL , [ACCTYPE] [char] (1) NOT NULL , [ACTRNDATE] [datetime] NOT NULL , [ACSEQ] [smallint] NOT NULL , [ACTRNCODE] [char] (3) NOT NULL , [ACTRNREF] [char] (12) NULL , [ACTRNDESC] [char] (50) NULL , [ACTRNAMT] [decimal](9, 2) NOT NULL , [ACTRNVAT] [decimal](9, 2) NULL , [ACTRNCATEGORY] [char] (3) NULL , [ACTRNSTATUS] [char] (3) NULL , [ACDIARYDATE] [datetime] NULL , [ACDIARYSEQ] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[deeds] ( [CONTACT] [char] (6) NOT NULL , [ADDRESS] [char] (100) NULL , [LOCATION] [char] (10) NULL , [ACCOUNTRECEIPT] [char] (1) NULL , [ARWHO] [char] (130) NULL , [ARWHEN] [datetime] NULL , [COMMENT] [char] (2000) NULL , [LASTACCESS] [int] NULL , [LASTACCESSWHO] [char] (8) NULL , [RecordID] [int] IDENTITY (1, 1) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[diary] ( [CASECODE] [char] (11) NOT NULL , [DATE] [datetime] NULL , [STATUS] [smallint] NULL , [ACTIONCODE] [char] (15) NULL , [ACTIONSTATUS] [char] (3) NULL , [ACTIONTYPE] [char] (1) NULL , [PROCESSTYPE] [char] (1) NULL , [FNCODE] [char] (3) NULL , [TEAMCODE] [char] (3) NULL , [TEXT1] [text] NULL , [TEXT2] [text] NULL , [DELEGATEDFNR] [char] (3) NULL , [DELEGATEDDATE] [datetime] NULL , [DELEGATEDBACKDATE] [datetime] NULL , [DEFERRED] [char] (3) NULL , [DUEDATE] [datetime] NULL , [IMAGENO] [int] NULL , [PUBLISH] [char] (1) NULL , [DYSTARTTIME] [char] (10) NULL , [DYENDTIME] [char] (10) NULL , [DURATION] [smallint] NULL , [ACTIONID] [decimal](15, 0) NOT NULL , [ORGINALACTIONID] [decimal](15, 0) NULL , [PRIORITY] [char] (1) NULL , [HIGHLIGHTED] [char] (1) NULL , [MILESTEONETYPE] [char] (12) NULL , [ATTACHMENTS] [char] (1) NULL , [PROCESSSTATUS] [smallint] NULL , [WORKPROCESS] [smallint] NULL , [BILLABLE] [int] NULL , [BILLDESCRIPTION] [varchar] (150) NULL , [EMAILADDRESS] [varchar] (150) NULL , [ADDRESSTO] [text] NULL , [CCTo] [text] NULL , [BCCTo] [text] NULL , [EMAIL] [char] (1) NULL , [SUBJECT] [text] NULL , [DELEGATIONSTATUS] [decimal](5, 2) NULL , [DRAFTBILLNO] [int] NULL , [CHEQUEREQNO] [int] NULL , [TxmSent] [bit] NULL , [Location] [varchar] (50) NULL , [HearingType] [varchar] (50) NULL , [ForCopy] [char] (1) NULL , [TxmDate] [datetime] NULL , [TxmSeqNo] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[diarytemp] ( [CASECODE] [char] (11) NOT NULL , [DATE] [datetime] NULL , [STATUS] [smallint] NULL , [ACTIONCODE] [char] (15) NULL , [ACTIONSTATUS] [char] (3) NULL , [ACTIONTYPE] [char] (1) NULL , [PROCESSTYPE] [char] (1) NULL , [FNCODE] [char] (3) NULL , [TEAMCODE] [char] (3) NULL , [TEXT1] [text] NULL , [TEXT2] [text] NULL , [DELEGATEDFNR] [char] (3) NULL , [DELEGATEDDATE] [datetime] NULL , [DELEGATEDBACKDATE] [datetime] NULL , [DEFERRED] [char] (3) NULL , [DUEDATE] [datetime] NULL , [IMAGENO] [int] NULL , [PUBLISH] [char] (1) NULL , [DYSTARTTIME] [char] (10) NULL , [DYENDTIME] [char] (10) NULL , [DURATION] [smallint] NULL , [ACTIONID] [decimal](15, 0) NOT NULL , [ORGINALACTIONID] [decimal](15, 0) NULL , [PRIORITY] [char] (1) NULL , [HIGHLIGHTED] [char] (1) NULL , [MILESTEONETYPE] [char] (12) NULL , [ATTACHMENTS] [char] (1) NULL , [PROCESSSTATUS] [smallint] NULL , [WORKPROCESS] [smallint] NULL , [BILLABLE] [int] NULL , [BILLDESCRIPTION] [varchar] (150) NULL , [EMAILADDRESS] [varchar] (150) NULL , [ADDRESSTO] [text] NULL , [CCTo] [text] NULL , [BCCTo] [text] NULL , [EMAIL] [char] (1) NULL , [SUBJECT] [text] NULL , [DELEGATIONSTATUS] [decimal](5, 2) NULL , [DRAFTBILLNO] [int] NULL , [CHEQUEREQNO] [int] NULL , [TxmSent] [bit] NULL , [Location] [varchar] (50) NULL , [HearingType] [varchar] (50) NULL , [ForCopy] [char] (1) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[dssw21] ( [OPE_LOGIN] [char] (129) NOT NULL , [OPE_FIRSTNAME] [char] (20) NULL , [OPE_SURNAME] [char] (20) NULL , [OPE_PASSWORD] [char] (129) NULL , [OPE_NUMBER] [smallint] NULL , [OPE_USERGROUP] [smallint] NULL , [OPE_LASTPASSWORDCHANGEDATE] [int] NULL , [OPE_HOOK1] [int] NULL , [OPE_HOOK2] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dssw22] ( [ACC_APPLICATION] [smallint] NOT NULL , [ACC_OPERATOR] [smallint] NOT NULL , [ACC_HASHNUMBER] [smallint] NOT NULL , [ACC_ACCESS] [int] NULL , [ACC_MOREACCESS] [int] NULL , [ACC_EVENMOREACCESS] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dssw23] ( [NAM_APPNUMBER] [smallint] NOT NULL , [NAM_NAME] [char] (129) NOT NULL , [NAM_HASHNUMBER] [smallint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dssw24] ( [LOG_OPERATORCODE] [char] (8) NULL , [LOG_APPLICATION] [smallint] NULL , [LOG_WINDOWNUMBER] [smallint] NULL , [LOG_ACTION] [smallint] NULL , [LOG_DATE] [int] NOT NULL , [LOG_TIME] [int] NOT NULL , [LOG_MACHINENAME] [char] (8) NULL , [LOG_DESCRIPTION] [char] (40) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dssw25] ( [LIC_LICENCEDTO] [char] (40) NULL , [LIC_PRODUCT] [char] (40) NOT NULL , [LIC_COPIES] [int] NULL , [LIC_LEVEL] [tinyint] NULL , [LIC_EXPIRYDATE] [int] NULL , [LIC_LASTRUNDATE] [int] NULL , [LIC_APPNUMBER] [smallint] NULL , [LIC_SERIALNUMBER] [char] (20) NULL , [LIC_MODULES] [int] NULL , [LIC_OTHER1] [char] (20) NULL , [LIC_OTHER2] [char] (20) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[matters] ( [Code] [char] (11) NOT NULL , [ClientCode] [char] (6) NOT NULL , [Matter] [char] (4) NOT NULL , [Description] [char] (200) NULL , [FECode] [char] (3) NOT NULL , [Partner] [char] (3) NULL , [Secretary] [char] (3) NULL , [Dept] [char] (3) NOT NULL , [Started] [datetime] NULL , [WType] [char] (4) NOT NULL , [Branch] [char] (1) NULL , [EstFee] [decimal](17, 2) NULL , [OutlayBud] [decimal](17, 2) NULL , [ExpBillD] [datetime] NULL , [ExpPayD] [datetime] NULL , [S13] [char] (1) NULL , [Comment] [char] (3000) NULL , [DebtBal] [decimal](17, 2) NULL , [OutlayBal] [decimal](17, 2) NULL , [ClientBal] [decimal](17, 2) NULL , [ClientCurBal] [decimal](17, 2) NULL , [ClientDepBal] [decimal](17, 2) NULL , [DebtBalFwd] [decimal](17, 2) NULL , [OutlayBalFwd] [decimal](17, 2) NULL , [ClientBalFwd] [decimal](17, 2) NULL , [ClientCurBalFwd] [decimal](17, 2) NULL , [ClientDepBalFwd] [decimal](17, 2) NULL , [PendingBal] [decimal](17, 2) NULL , [ClientMin] [decimal](17, 2) NULL , [FileNum] [int] NULL , [ThirdPart] [char] (6) NULL , [ThPartSol] [char] (6) NULL , [Value] [decimal](17, 2) NULL , [Undertaking] [char] (1) NULL , [LastAct] [datetime] NULL , [LastActType] [char] (10) NULL , [LastActWho] [char] (10) NULL , [StatuteLimits] [datetime] NULL , [Status] [char] (6) NULL , [Section68] [char] (1) NULL , [FNL_Date] [datetime] NULL , [FNL_Name] [char] (40) NULL , [FNL_Address] [char] (120) NULL , [FNL_Fees] [decimal](15, 2) NULL , [FNL_Outlay] [decimal](15, 2) NULL , [FNL_VAT] [decimal](15, 2) NULL , [FNL_Total] [decimal](15, 2) NULL , [OldRef] [char] (12) NULL , [PCODE] [char] (11) NULL , [PFECODE] [char] (3) NULL , [User1] [char] (20) NULL , [User2] [char] (20) NULL , [User3] [char] (20) NULL , [DepositName] [char] (40) NULL , [DepositType] [char] (4) NULL , [TimeBal] [decimal](13, 2) NULL , [ChargeBal] [decimal](13, 2) NULL , [YourRef] [char] (15) NULL , [CurDebtBal] [decimal](17, 2) NULL , [CurOutlayBal] [decimal](17, 2) NULL , [CurClientBal] [decimal](17, 2) NULL , [CurClientCBal] [decimal](17, 2) NULL , [CurClientDBal] [decimal](17, 2) NULL , [CurDebtBalFwd] [decimal](17, 2) NULL , [CurOutlayBalFwd] [decimal](17, 2) NULL , [CurClientBalFwd] [decimal](17, 2) NULL , [CurClientCBalFwd] [decimal](17, 2) NULL , [CurClientDBalFwd] [decimal](17, 2) NULL , [CurPendingBal] [decimal](17, 2) NULL , [Unallocated] [decimal](13, 2) NULL , [Statements] [char] (1) NULL , [ChargeLevel] [int] NULL , [FileColour] [char] (3) NULL , [OpenInvoiceNo] [int] NULL , [Password] [char] (20) NULL , [CompBillOnOff] [char] (1) NULL , [CompFrequency] [char] (1) NULL , [CompOutlayLimit] [decimal](13, 2) NULL , [CompFeesLimit] [decimal](13, 2) NULL , [CompTotalLimit] [decimal](13, 2) NULL , [CompBillingMatter] [char] (11) NULL , [CompBilling] [char] (1) NULL , [ClientName] [char] (60) NULL , [ClientAddress] [char] (120) NULL , [ClientSalutation] [char] (40) NULL , [ChargeArrangement] [char] (3) NULL , [Importance] [smallint] NULL , [OriginalDebt] [decimal](18, 2) NULL , [DebtCollected] [decimal](18, 2) NULL , [RecoverableCosts] [decimal](18, 2) NULL , [DebtInterest] [decimal](18, 2) NULL , [BillingMethod] [char] (1) NULL , [CollectingBalance] [decimal](18, 2) NULL , [Publish] [char] (1) NULL , [Permissions] [int] NULL , [OUTFileNo] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[outlayextract] ( [OUTLAYRECNO] [int] NOT NULL , [OUTLAYPOSTDATE] [datetime] NULL , [OUTLAYEFFECDATE] [datetime] NULL , [OUTLAYCLIENTCODE] [varchar] (6) NULL , [OUTLAYDEFRECNO] [int] NULL , [OUTLAYCODE] [varchar] (6) NULL , [OUTLAYDESC] [varchar] (60) NULL , [OUTLAYAMT] [money] NULL , [OUTLAYOFFICIAL] [varchar] (8) NULL , [OUTLAYSOL] [varchar] (10) NULL , [OUTLAYINVNO] [int] NULL , [EXTRACTED] [varchar] (1) NULL , [DEFCORRREF] [varchar] (50) NULL , [DEFOURREF] [varchar] (50) NULL , [DEFORGCODE] [int] NULL , [OUTLAYFINALBILL] [varchar] (2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[outlayextractpetty] ( [OUTLAYRECNO] [int] NOT NULL , [OUTLAYPOSTDATE] [datetime] NULL , [OUTLAYEFFECDATE] [datetime] NULL , [OUTLAYCLIENTCODE] [varchar] (6) NULL , [OUTLAYDEFRECNO] [int] NULL , [OUTLAYCODE] [varchar] (6) NULL , [OUTLAYDESC] [varchar] (60) NULL , [OUTLAYAMT] [money] NULL , [OUTLAYOFFICIAL] [varchar] (8) NULL , [OUTLAYSOL] [varchar] (20) NULL , [OUTLAYINVNO] [int] NULL , [EXTRACTED] [varchar] (1) NULL , [DEFCORRREF] [varchar] (50) NULL , [DEFOURREF] [varchar] (50) NULL , [DEFORGCODE] [int] NULL , [OUTLAYFINALBILL] [varchar] (2) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Accruals] WITH NOCHECK ADD CONSTRAINT [PK_Accruals] PRIMARY KEY CLUSTERED ( [RecordId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ActionWorkTypes] WITH NOCHECK ADD CONSTRAINT [PK__ActionWorkTypes__6C190EBB] PRIMARY KEY CLUSTERED ( [WORKTYPE], [ACTIONCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Allocations] WITH NOCHECK ADD CONSTRAINT [PK__Allocations__6991A7CB] PRIMARY KEY CLUSTERED ( [KEYID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[AssociateCategory] WITH NOCHECK ADD CONSTRAINT [PK_AssociateCategory] PRIMARY KEY CLUSTERED ( [Category] ) ON [PRIMARY] GO ALTER TABLE [dbo].[AssociateTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecClearDown] WITH NOCHECK ADD CONSTRAINT [PK__BankRecClearDown__2BC97F7C] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecCompleteTrans] WITH NOCHECK ADD CONSTRAINT [PK__BankRecCompleteT__6DCC4D03] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecHistory] WITH NOCHECK ADD CONSTRAINT [PK__BankRecHistory__662B2B3B] PRIMARY KEY CLUSTERED ( [BANKAC], [RECNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecOutstandingTrans] WITH NOCHECK ADD CONSTRAINT [PK__BankRecOutstandi__69FBBC1F] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecTransactions] WITH NOCHECK ADD CONSTRAINT [PK_BankRecTransactions] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BankTally] WITH NOCHECK ADD CONSTRAINT [PK__BankTally__6C190EBB] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BatchDetails] WITH NOCHECK ADD CONSTRAINT [PK__BatchDetails__6F4A8121] PRIMARY KEY CLUSTERED ( [KEYID] ) WITH FILLFACTOR = 70 ON [PRIMARY] GO ALTER TABLE [dbo].[BatchH] WITH NOCHECK ADD CONSTRAINT [PK_BatchH] PRIMARY KEY CLUSTERED ( [BATCHNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BillDescriptions] WITH NOCHECK ADD CONSTRAINT [PK__BillDescriptions__731B1205] PRIMARY KEY CLUSTERED ( [NUMBER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BillDetails] WITH NOCHECK ADD CONSTRAINT [PK__BillDetails__76EBA2E9] PRIMARY KEY CLUSTERED ( [KEYID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BillFeeBreakDown] WITH NOCHECK ADD CONSTRAINT [PK__BillFeeBreakDown__66603565] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BillHeader] WITH NOCHECK ADD CONSTRAINT [PK__BillHeader__7ABC33CD] PRIMARY KEY CLUSTERED ( [DRAFTNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Branch] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [BRANCHCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BranchNominals] WITH NOCHECK ADD CONSTRAINT [PK__BranchNominals__43D61337] PRIMARY KEY CLUSTERED ( [CODE], [BRANCH] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseAssociatesContacts] WITH NOCHECK ADD CONSTRAINT [PK__CaseAssociatesCo__5FB337D6] PRIMARY KEY CLUSTERED ( [KEYID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseAssociatesNames] WITH NOCHECK ADD CONSTRAINT [PK__CaseAssociatesNa__084B3915] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseAssoicatesTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NAMECODE], [TYPECODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseContacts] WITH NOCHECK ADD CONSTRAINT [PK__CaseContacts__2BC97F7C] PRIMARY KEY CLUSTERED ( [CASECODE], [CONTYPE], [CONNUM] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseMaster] WITH NOCHECK ADD CONSTRAINT [PK__CaseMaster__39237A9A] PRIMARY KEY CLUSTERED ( [CSCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseMasterClosed] WITH NOCHECK ADD CONSTRAINT [PK__CaseMasterClosed__7E02B4CC] PRIMARY KEY CLUSTERED ( [CSCODE], [FILENUM] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CasePlanCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CPCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseTeams] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [TEAMCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseUDFAnswers] WITH NOCHECK ADD CONSTRAINT [PK__CaseUDFAnswers__0E8E2250] PRIMARY KEY CLUSTERED ( [CASECODE], [UDFFILE], [UDFNAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Category] WITH NOCHECK ADD CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED ( [CatType], [Code] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChargeType] WITH NOCHECK ADD CONSTRAINT [PK__ChargeType__2A363CC5] PRIMARY KEY CLUSTERED ( [TAXHEAD], [CHARGETYPE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChargingMatrix] WITH NOCHECK ADD CONSTRAINT [PK__ChargingMatrix__38996AB5] PRIMARY KEY CLUSTERED ( [ARRANGEMENTCODE], [CHARGECODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequeNumbers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [BANKCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequeRequisitionDetail] WITH NOCHECK ADD CONSTRAINT [PK__ChequeRequisitio__7755B73D] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequeRequisitionHeader] WITH NOCHECK ADD CONSTRAINT [PK__ChequeRequisitio__7B264821] PRIMARY KEY CLUSTERED ( [REQNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequesForPrinting] WITH NOCHECK ADD CONSTRAINT [PK__ChequesForPrinti__0BE6BFCF] PRIMARY KEY CLUSTERED ( [CHEQUENO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ClientContacts] WITH NOCHECK ADD CONSTRAINT [PK__ClientContacts__76969D2E] PRIMARY KEY CLUSTERED ( [CLCODE], [CLNUMCONTACT] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CloseCaseContacts] WITH NOCHECK ADD CONSTRAINT [PK__CloseCaseContact__32767D0B] PRIMARY KEY CLUSTERED ( [CASECODE], [CONTYPE], [CONNUM] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CloseDiary] WITH NOCHECK ADD CONSTRAINT [PK__CloseDiary__68D28DBC] PRIMARY KEY CLUSTERED ( [ACTIONID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CloseDiaryAttachments] WITH NOCHECK ADD CONSTRAINT [PK__CloseDiaryAttach__603D47BB] PRIMARY KEY CLUSTERED ( [TRACKREFERENCE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Closed] WITH NOCHECK ADD CONSTRAINT [PK__Closed__7D0E9093] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ClosedCaseUDFAnswers] WITH NOCHECK ADD CONSTRAINT [PK_ClosedCaseUDFAnswers] PRIMARY KEY CLUSTERED ( [CASECODE], [UDFFILE], [UDFNAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ClosedMatterLedger] WITH NOCHECK ADD CONSTRAINT [PK_ClosedMatterLedger] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillBreakDown] WITH NOCHECK ADD CONSTRAINT [PK__CompositeBillBre__4C364F0E] PRIMARY KEY CLUSTERED ( [COMPBILLNO], [BATCHNO], [POSTINGREF] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillDetail] WITH NOCHECK ADD CONSTRAINT [PK__CompositeBillDet__42ACE4D4] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillFees] WITH NOCHECK ADD CONSTRAINT [PK__CompositeBillFee__51EF2864] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillHeader] WITH NOCHECK ADD CONSTRAINT [PK__CompositeBillHea__4865BE2A] PRIMARY KEY CLUSTERED ( [COMPBILLNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeFEBreakdown] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [COMPBILLNO], [MATTER], [FE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ContactCategories] WITH NOCHECK ADD CONSTRAINT [PK_ContactCategories] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ContactPhoneNos] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CONTACT], [PHONE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ContactRequisition] WITH NOCHECK ADD CONSTRAINT [PK__ContactRequisiti__3B0BC30C] PRIMARY KEY CLUSTERED ( [TEMPCONTACTREF] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD CONSTRAINT [PK_Contacts] PRIMARY KEY CLUSTERED ( [Code] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CostFees] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CFTYPE], [CFCODE], [CFBANDNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CostTransGathering] WITH NOCHECK ADD CONSTRAINT [PK__CostTransGatheri__73BA3083] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CreditorsList] WITH NOCHECK ADD CONSTRAINT [PK__CreditorsList__2F9A1060] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DBODSSW21] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [OPE_LOGIN] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DBODSSW22] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ACC_APPLICATION], [ACC_OPERATOR], [ACC_HASHNUMBER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DBODSSW23] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NAM_APPNUMBER], [NAM_NAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DBODSSW25] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [LIC_PRODUCT] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DataFiles] WITH NOCHECK ADD CONSTRAINT [PK__DataFiles__55BFB948] PRIMARY KEY CLUSTERED ( [FILENAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtAccounts] WITH NOCHECK ADD CONSTRAINT [PK__DebtAccounts__6ABAD62E] PRIMARY KEY CLUSTERED ( [ACCASECODE], [ACCTYPE], [ACTRNDATE], [ACSEQ] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtAllocations] WITH NOCHECK ADD CONSTRAINT [PK_DebtAllocations] PRIMARY KEY CLUSTERED ( [RecordId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtBreakDown] WITH NOCHECK ADD CONSTRAINT [PK_DebtBreakdown] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtCostingLedger] WITH NOCHECK ADD CONSTRAINT [PK__DebtCostingLedge__43E1002F] PRIMARY KEY CLUSTERED ( [POSTINGREF] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtorsLedger] WITH NOCHECK ADD CONSTRAINT [PK__DebtorsLedger__184C96B4] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Departments] WITH NOCHECK ADD CONSTRAINT [PK__Departments__1A9EF37A] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DepositType] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DesktopControl] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DesktopMessages] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [DATE], [TIME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DesktopNarr] WITH NOCHECK ADD CONSTRAINT [PK_DesktopNarr] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryAttachments] WITH NOCHECK ADD CONSTRAINT [PK__DiaryAttachments__5A846E65] PRIMARY KEY CLUSTERED ( [TRACKREFERENCE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryDelegations] WITH NOCHECK ADD CONSTRAINT [PK_DiaryDelegations] PRIMARY KEY CLUSTERED ( [AssignNo] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryLinks] WITH NOCHECK ADD CONSTRAINT [PK_DiaryLinks] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DocumentClasses] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CLASSCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DocumentPopups] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [KEYFIELD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[EMailAttachments] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [EACASECODE], [EAACNDATE], [EAACNCODE], [EASEQ], [EAATTNUM] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ElectronicBankRec] WITH NOCHECK ADD CONSTRAINT [PK_ElectronicBankRec] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ElectronicImportLog] WITH NOCHECK ADD CONSTRAINT [PK_ElectronicImportLog] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[FeeEarnerCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[FieldTransfer] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [OLDFIELD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[FileManagerItems] WITH NOCHECK ADD CONSTRAINT [PK__FileManagerItems__4E739D3B] PRIMARY KEY CLUSTERED ( [NUMBER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Forms] WITH NOCHECK ADD CONSTRAINT [PK__Forms__373B3228] PRIMARY KEY CLUSTERED ( [APPNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[HandlerBudgets] WITH NOCHECK ADD CONSTRAINT [PK_HandlerBudgets] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Handlers] WITH NOCHECK ADD CONSTRAINT [PK_Handlers] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[HandlersDepartments] WITH NOCHECK ADD CONSTRAINT [PK_HandlersDepartments] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ImportLog] WITH NOCHECK ADD CONSTRAINT [PK_ImportLog] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[InterestCalcHistory] WITH NOCHECK ADD CONSTRAINT [PK__InterestCalcHist__7D439ABD] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[InterestLedger] WITH NOCHECK ADD CONSTRAINT [PK__InterestLedger__3F865F66] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[InterestRates] WITH NOCHECK ADD CONSTRAINT [PK__InterestRates__3CA9F2BB] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[InterestTransactions] WITH NOCHECK ADD CONSTRAINT [PK__InterestTransact__416EA7D8] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ItemDiary] WITH NOCHECK ADD CONSTRAINT [PK__ItemDiary__01142BA1] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ItemHistory] WITH NOCHECK ADD CONSTRAINT [PK__ItemHistory__04E4BC85] PRIMARY KEY CLUSTERED ( [NUMBER], [ITEMCODE], [OUTDATE], [OUTTIME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ItemLocations] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ItemTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [TYPECODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[JGroups] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [JGRP_GroupID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[JPermissions] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [JPER_PermissionID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[KPIParameters] WITH NOCHECK ADD CONSTRAINT [PK_KPIParameters] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Log] WITH NOCHECK ADD CONSTRAINT [PK_Log] PRIMARY KEY CLUSTERED ( [RecordId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterLedger] WITH NOCHECK ADD CONSTRAINT [PK_MatterLedger] PRIMARY KEY CLUSTERED ( [LREF] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterLedgerClearDown] WITH NOCHECK ADD CONSTRAINT [PK__MatterLedgerClea__5AD97420] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterTally] WITH NOCHECK ADD CONSTRAINT [PK__MatterTally__3E1D39E1] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MemorisedBatchD] WITH NOCHECK ADD CONSTRAINT [PK__MemorisedBatchD__5EAA0504] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MemorsiedBatchH] WITH NOCHECK ADD CONSTRAINT [PK__MemorsiedBatchH__60924D76] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MilestoneTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MultiBatchD] WITH NOCHECK ADD CONSTRAINT [PK__MultiBatchD__40058253] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MultiField] WITH NOCHECK ADD CONSTRAINT [PK__MultiField__27F8EE98] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Narratives] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NationCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NATION] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NewNominal] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Nominal] WITH NOCHECK ADD CONSTRAINT [PK__Nominal__1C1D2798] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NominalLedger] WITH NOCHECK ADD CONSTRAINT [PK__NominalLedger__6D9742D9] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NominalReportSeq] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [PB], [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NominalTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NTYCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Officers] WITH NOCHECK ADD CONSTRAINT [PK__Officers__51300E55] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[OutlayCode] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[OutlookIds] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ACTIONID], [OUTLOOKID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PendingOutlay] WITH NOCHECK ADD CONSTRAINT [PK__PendingOutlay__5AB9788F] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[RBatchD] WITH NOCHECK ADD CONSTRAINT [PK__RBatchD__5E8A0973] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[RBatchH] WITH NOCHECK ADD CONSTRAINT [PK__RBatchH__625A9A57] PRIMARY KEY CLUSTERED ( [DATE], [BATCHNO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[RecentMatterList] WITH NOCHECK ADD CONSTRAINT [PK__RecentMatterList__2C88998B] PRIMARY KEY CLUSTERED ( [FEE], [MATTER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ReferralControl] WITH NOCHECK ADD CONSTRAINT [PK__ReferralControl__31D75E8D] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SAM3Fields] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [FILE], [F_NAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SAMMessages] WITH NOCHECK ADD CONSTRAINT [PK__SAMMessages__4301EA8F] PRIMARY KEY CLUSTERED ( [DATE], [TIME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SalutationCodes] WITH NOCHECK ADD CONSTRAINT [PK_SalutationCodes] PRIMARY KEY CLUSTERED ( [Code] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ServiceCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[StatusCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SupplierLedger] WITH NOCHECK ADD CONSTRAINT [PK__SupplierLedger__7EF6D905] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Suppliers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SystemConfig] WITH NOCHECK ADD CONSTRAINT [PK__SystemConfig__1446FBA6] PRIMARY KEY CLUSTERED ( [SCUSERID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SystemFiles] WITH NOCHECK ADD CONSTRAINT [PK_SystemFiles] PRIMARY KEY CLUSTERED ( [NAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SystemUserDefinedFields] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [FILEPREFIX], [FIELDNAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TableName] WITH NOCHECK ADD CONSTRAINT [PK_TableName] PRIMARY KEY CLUSTERED ( [FileName] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TaggedSupLed] WITH NOCHECK ADD CONSTRAINT [PK_TaggedSupLed] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TaskTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TasksCodes] WITH NOCHECK ADD CONSTRAINT [PK__TasksCodes__00DF2177] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TaxHead] WITH NOCHECK ADD CONSTRAINT [PK__TaxHead__2C1E8537] PRIMARY KEY CLUSTERED ( [TAXHEAD] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Team] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TeamMembers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [TEAMCODE], [HANDLER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TempBatchD] WITH NOCHECK ADD CONSTRAINT [PK_TempBatchD] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TempBatchH] WITH NOCHECK ADD CONSTRAINT [PK_TempBatchH] PRIMARY KEY CLUSTERED ( [BatchNo] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActionCommands] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ACTIONCODE], [ORDER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActionTypes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActionUDF] WITH NOCHECK ADD CONSTRAINT [PK__TemplateActionUD__52E34C9D] PRIMARY KEY CLUSTERED ( [ACTIONCODE], [FILEPREFIX], [FIELDNAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActions] WITH NOCHECK ADD CONSTRAINT [PK_TemplateActions] PRIMARY KEY CLUSTERED ( [ACTIONCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateCopyAssociates] WITH NOCHECK ADD CONSTRAINT [PK_TemplateCopyAssociates] PRIMARY KEY CLUSTERED ( [PlanCode], [AssociateType] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateDocumentUDFs] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [UDFCODE], [DOCUMENT] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateDocuments] WITH NOCHECK ADD CONSTRAINT [PK__TemplateDocument__123EB7A3] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateEmails] WITH NOCHECK ADD CONSTRAINT [PK_TemplateEmails] PRIMARY KEY CLUSTERED ( [RecordId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateNextActions] WITH NOCHECK ADD CONSTRAINT [PK__TemplateNextActi__55BFB948] PRIMARY KEY CLUSTERED ( [ACTION], [NEXTACTION] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Templates] WITH NOCHECK ADD CONSTRAINT [PK__Templates__39E294A9] PRIMARY KEY CLUSTERED ( [WKCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TestTable] WITH NOCHECK ADD CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED ( [MatterCode] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TimeAdminCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NCCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TimeDayBook] WITH NOCHECK ADD CONSTRAINT [PK__TimeDayBook__0B5CAFEA] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TimeEntry] WITH NOCHECK ADD CONSTRAINT [PK__TimeEntry__0F2D40CE] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TransferList] WITH NOCHECK ADD CONSTRAINT [PK__TransferList__22401542] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[UDFDefinition] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [UVTYPE], [UVCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[UDFLookups] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [FIELDNAME], [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[UDFTemplatesWorkTypes] WITH NOCHECK ADD CONSTRAINT [PK__UDFTemplatesWork__17036CC0] PRIMARY KEY CLUSTERED ( [UDFILE], [UDUVCODE], [UDWKCODE], [UDSEQ] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Undertakings] WITH NOCHECK ADD CONSTRAINT [PK__Undertakings__12FDD1B2] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[VATCodes] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[VATReportExtract] WITH NOCHECK ADD CONSTRAINT [PK__VATReportExtract__1A9EF37A] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebActions] WITH NOCHECK ADD CONSTRAINT [PK_WebActions] PRIMARY KEY CLUSTERED ( [ActionID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebAssociates] WITH NOCHECK ADD CONSTRAINT [PK_WebAssociates] PRIMARY KEY CLUSTERED ( [WebAssociateID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebAssociatesFields] WITH NOCHECK ADD CONSTRAINT [PK_WebAssociatesFields] PRIMARY KEY CLUSTERED ( [WebAssociateFieldID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebControlTypes] WITH NOCHECK ADD CONSTRAINT [PK_WebControlTypes] PRIMARY KEY CLUSTERED ( [ControlTypeID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebFields] WITH NOCHECK ADD CONSTRAINT [PK_WebFields] PRIMARY KEY CLUSTERED ( [RecordId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebForms] WITH NOCHECK ADD CONSTRAINT [PK_WebForms] PRIMARY KEY CLUSTERED ( [FormId] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WebForms_Actions] WITH NOCHECK ADD CONSTRAINT [PK_WebForms_Actions] PRIMARY KEY CLUSTERED ( [FormID], [ActionID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Wills] WITH NOCHECK ADD CONSTRAINT [PK__Wills__5F492382] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WorkInProgressReport] WITH NOCHECK ADD CONSTRAINT [PK__WorkInProgressRe__1E6F845E] PRIMARY KEY CLUSTERED ( [RECORDID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[WorkTypes] WITH NOCHECK ADD CONSTRAINT [PK__WorkTypes__6319B466] PRIMARY KEY CLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[children] WITH NOCHECK ADD CONSTRAINT [PK_children] PRIMARY KEY CLUSTERED ( [KeyID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[client] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [CLCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[control] WITH NOCHECK ADD CONSTRAINT [PK_control] PRIMARY KEY CLUSTERED ( [NEXT_DOC_NO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[deeds] WITH NOCHECK ADD CONSTRAINT [PK_deeds] PRIMARY KEY CLUSTERED ( [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[diary] WITH NOCHECK ADD CONSTRAINT [PK__diary__51BA1E3A] PRIMARY KEY CLUSTERED ( [ACTIONID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[diarytemp] WITH NOCHECK ADD CONSTRAINT [PK_diarytemp] PRIMARY KEY CLUSTERED ( [ACTIONID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[dssw21] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [OPE_LOGIN] ) ON [PRIMARY] GO ALTER TABLE [dbo].[dssw22] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [ACC_APPLICATION], [ACC_OPERATOR], [ACC_HASHNUMBER] ) ON [PRIMARY] GO ALTER TABLE [dbo].[dssw23] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [NAM_APPNUMBER], [NAM_NAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[dssw25] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [LIC_PRODUCT] ) ON [PRIMARY] GO ALTER TABLE [dbo].[matters] WITH NOCHECK ADD CONSTRAINT [PK_matters] PRIMARY KEY CLUSTERED ( [Code] ) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [ALL_KEYNSC] ON [dbo].[ALLBANKS]([NSC]) ON [PRIMARY] GO ALTER TABLE [dbo].[Accruals] ADD CONSTRAINT [DF_Accruals_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_Accruals_VALUEYTD] DEFAULT (0) FOR [VALUEYTD] GO CREATE INDEX [KeyNomFrom] ON [dbo].[Accruals]([NOMINALFROM], [RecordId]) ON [PRIMARY] GO ALTER TABLE [dbo].[ActionWorkTypes] ADD CONSTRAINT [UQ__ActionWorkTypes__1BC821DD] UNIQUE NONCLUSTERED ( [WORKTYPE], [SEQ] ) ON [PRIMARY] , CONSTRAINT [UQ__ActionWorkTypes__1CBC4616] UNIQUE NONCLUSTERED ( [ACTIONCODE], [WORKTYPE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Allocations] ADD CONSTRAINT [DF_Allocations_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_Allocations_FEES] DEFAULT (0) FOR [FEES], CONSTRAINT [DF_Allocations_OUTLAY] DEFAULT (0) FOR [OUTLAY], CONSTRAINT [DF_Allocations_VAT] DEFAULT (0) FOR [VAT] GO CREATE INDEX [AllocFro] ON [dbo].[Allocations]([BATCHNO], [PREF], [KEYID]) ON [PRIMARY] GO CREATE INDEX [AllocNo] ON [dbo].[Allocations]([AllNo], [KEYID]) ON [PRIMARY] GO ALTER TABLE [dbo].[AssociateTypes] ADD CONSTRAINT [CategoryKey] UNIQUE NONCLUSTERED ( [Category], [CODE] ) ON [PRIMARY] GO CREATE INDEX [KeyBankAcc] ON [dbo].[BankRecClearDown]([BANKACC], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBankPost] ON [dbo].[BankRecClearDown]([BANKACC], [PREF], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecCompleteTrans] ADD CONSTRAINT [DF_BankRecCompleteTrans_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_BankRecCompleteTrans_OSRECNO] DEFAULT (0) FOR [OSRECNO], CONSTRAINT [DF_BankRecCompleteTrans_RECNO] DEFAULT (0) FOR [RECNO] GO CREATE INDEX [KeyBankAc] ON [dbo].[BankRecCompleteTrans]([BANKAC], [RECNO], [TYPE], [REF], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBatch] ON [dbo].[BankRecCompleteTrans]([BATCH], [PREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecHistory] ADD CONSTRAINT [DF_BankRecHistory_OPENINGBALANCE] DEFAULT (0) FOR [OPENINGBALANCE], CONSTRAINT [DF_BankRecHistory_LODGEMENTS] DEFAULT (0) FOR [LODGEMENTS], CONSTRAINT [DF_BankRecHistory_CHEQUES] DEFAULT (0) FOR [CHEQUES], CONSTRAINT [DF_BankRecHistory_OSLODGEMENTS] DEFAULT (0) FOR [OSLODGEMENTS], CONSTRAINT [DF_BankRecHistory_OSCHEQUES] DEFAULT (0) FOR [OSCHEQUES], CONSTRAINT [DF_BankRecHistory_BANKBAL] DEFAULT (0) FOR [BANKBAL], CONSTRAINT [DF_BankRecHistory_CLOSINGBAL] DEFAULT (0) FOR [CLOSINGBAL], CONSTRAINT [DF_BankRecHistory_DIFF] DEFAULT (0) FOR [DIFF] GO ALTER TABLE [dbo].[BankRecOutstandingTrans] ADD CONSTRAINT [DF_BankRecOutstandingTrans_VALUE] DEFAULT (0) FOR [VALUE] GO CREATE INDEX [KeyBankAc] ON [dbo].[BankRecOutstandingTrans]([BANKAC], [RECNO], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBatch] ON [dbo].[BankRecOutstandingTrans]([BATCH], [PREF], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[BankRecTransactions] ADD CONSTRAINT [DF_BankRecTransactions_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_BankRecTransactions_OSRECNO] DEFAULT (0) FOR [OSRECNO], CONSTRAINT [DF_BankRecTransactions_RECNO] DEFAULT (0) FOR [RECNO], CONSTRAINT [UQ__BankRecTransacti__719CDDE7] UNIQUE NONCLUSTERED ( [RECORDID] ) ON [PRIMARY] GO CREATE INDEX [KeyBankAc] ON [dbo].[BankRecTransactions]([BANKAC], [RECNO], [TYPE], [REF], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyValue] ON [dbo].[BankRecTransactions]([BANKAC], [RECNO], [TYPE], [VALUE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBankDate] ON [dbo].[BankRecTransactions]([BANKAC], [RECNO], [TYPE], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBatch] ON [dbo].[BankRecTransactions]([BATCH], [PREF], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[BankTally] ADD CONSTRAINT [DF_BankTally_RATE] DEFAULT (0) FOR [RATE], CONSTRAINT [DF_BankTally_DIRT] DEFAULT (0) FOR [DIRT], CONSTRAINT [DF_BankTally_RESULT] DEFAULT (0) FOR [RESULT], CONSTRAINT [DF_BankTally_TOTAL] DEFAULT (0) FOR [TOTAL] GO CREATE INDEX [BANKKEY] ON [dbo].[BankTally]([BANK], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[BatchDetails] ADD CONSTRAINT [DF_BatchDetails_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_BatchDetails_VATVAL] DEFAULT (0) FOR [VATVAL], CONSTRAINT [DF_BatchDetails_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_BatchDetails_CURRENCYVAT] DEFAULT (0) FOR [CURRENCYVAT], CONSTRAINT [DF_BatchDetails_ALLOCVALUE] DEFAULT (0) FOR [ALLOCVALUE] GO CREATE INDEX [BDNo] ON [dbo].[BatchDetails]([BATCHNO], [PREF]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [BADOutlayCode] ON [dbo].[BatchDetails]([OUTLAYCODE]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [BDNom] ON [dbo].[BatchDetails]([CODE]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [BDMatter] ON [dbo].[BatchDetails]([MATTER]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [BDSupp] ON [dbo].[BatchDetails]([SUPP]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [BDPref] ON [dbo].[BatchDetails]([PREF]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [VATKey] ON [dbo].[BatchDetails]([YEAR], [PERNO], [TYPE], [VATCODE], [DATE]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [AllocsKey] ON [dbo].[BatchDetails]([ALLOCBATCH], [ALLOCPREF]) WITH FILLFACTOR = 70 ON [PRIMARY] GO ALTER TABLE [dbo].[BatchH] ADD CONSTRAINT [DF_BatchH_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_BatchH_SUBTOT] DEFAULT (0) FOR [SUBTOT], CONSTRAINT [DF_BatchH_OUTLAYTOT] DEFAULT (0) FOR [OUTLAYTOT], CONSTRAINT [DF_BatchH_VATTOT] DEFAULT (0) FOR [VATTOT], CONSTRAINT [DF_BatchH_FEETOT] DEFAULT (0) FOR [FEETOT], CONSTRAINT [DF_BatchH_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_BatchH_CUROUTLAYTOT] DEFAULT (0) FOR [CUROUTLAYTOT], CONSTRAINT [DF_BatchH_CURVATTOT] DEFAULT (0) FOR [CURVATTOT], CONSTRAINT [DF_BatchH_CURFEETOT] DEFAULT (0) FOR [CURFEETOT], CONSTRAINT [DF_BatchH_WRITEBACKHOURS] DEFAULT (0) FOR [WRITEBACKHOURS], CONSTRAINT [DF_BatchH_WRITEBACKVALUE] DEFAULT (0) FOR [WRITEBACKVALUE], CONSTRAINT [UQ__BatchH__61F08603] UNIQUE NONCLUSTERED ( [BATCHNO] ) ON [PRIMARY] GO CREATE INDEX [BatchAudit] ON [dbo].[BatchH]([PERNO], [YEAR], [ENTRYDATE]) ON [PRIMARY] GO CREATE INDEX [BHMatter] ON [dbo].[BatchH]([MATTER]) ON [PRIMARY] GO CREATE INDEX [BPosted] ON [dbo].[BatchH]([POSTED], [ENTRYDATE]) ON [PRIMARY] GO CREATE INDEX [BHSupp] ON [dbo].[BatchH]([SUPP]) ON [PRIMARY] GO CREATE INDEX [BHNom] ON [dbo].[BatchH]([CODE]) ON [PRIMARY] GO CREATE INDEX [BType] ON [dbo].[BatchH]([TYPE]) ON [PRIMARY] GO CREATE INDEX [BRecon] ON [dbo].[BatchH]([CODE], [RECNO]) ON [PRIMARY] GO CREATE INDEX [KeySearch] ON [dbo].[BillDescriptions]([SEARCHFIELD]) ON [PRIMARY] GO ALTER TABLE [dbo].[BillDetails] ADD CONSTRAINT [DF_BillDetails_NET] DEFAULT (0) FOR [NET], CONSTRAINT [DF_BillDetails_VATRATE] DEFAULT (0) FOR [VATRATE], CONSTRAINT [DF_BillDetails_VATVALUE] DEFAULT (0) FOR [VATVALUE] GO CREATE INDEX [KeyMatter] ON [dbo].[BillDetails]([MATTER], [DRAFTNO], [BILLNO], [LINENO]) ON [PRIMARY] GO CREATE INDEX [KeyBillno] ON [dbo].[BillDetails]([MATTER], [BILLNO], [LINENO]) ON [PRIMARY] GO CREATE INDEX [KeyBillCopy] ON [dbo].[BillDetails]([MATTER], [BILLNO]) ON [PRIMARY] GO CREATE INDEX [KeyChildSeq] ON [dbo].[BillDetails]([DRAFTNO], [LINENO]) ON [PRIMARY] GO ALTER TABLE [dbo].[BillFeeBreakDown] ADD CONSTRAINT [DF_BillFeeBreakDown_PERCENT] DEFAULT (0) FOR [PERCENT], CONSTRAINT [DF_BillFeeBreakDown_CALCULATION] DEFAULT (0) FOR [CALCULATION], CONSTRAINT [DF_BillFeeBreakDown_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_BillFeeBreakDown_VATAMT_1] DEFAULT (0) FOR [VATAMT] GO CREATE INDEX [KeyMatter] ON [dbo].[BillFeeBreakDown]([MATTER], [DRAFTNO], [BILLNO], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyBillNo] ON [dbo].[BillFeeBreakDown]([MATTER], [BILLNO], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[BillHeader] ADD CONSTRAINT [DF_BillHeader_TOTAL] DEFAULT (0) FOR [TOTAL], CONSTRAINT [DF_BillHeader_FEES] DEFAULT (0) FOR [FEES], CONSTRAINT [DF_BillHeader_OUTLAY] DEFAULT (0) FOR [OUTLAY], CONSTRAINT [DF_BillHeader_TOTALVAT] DEFAULT (0) FOR [TOTALVAT], CONSTRAINT [DF_BillHeader_NET0] DEFAULT (0) FOR [NET0], CONSTRAINT [DF_BillHeader_RATE1] DEFAULT (0) FOR [RATE1], CONSTRAINT [DF_BillHeader_NETRATE1] DEFAULT (0) FOR [NETRATE1], CONSTRAINT [DF_BillHeader_VATRATE1] DEFAULT (0) FOR [VATRATE1], CONSTRAINT [DF_BillHeader_RATE2] DEFAULT (0) FOR [RATE2], CONSTRAINT [DF_BillHeader_NETRATE2] DEFAULT (0) FOR [NETRATE2], CONSTRAINT [DF_BillHeader_VATRATE2] DEFAULT (0) FOR [VATRATE2], CONSTRAINT [DF_BillHeader_RATE3] DEFAULT (0) FOR [RATE3], CONSTRAINT [DF_BillHeader_NETRATE3] DEFAULT (0) FOR [NETRATE3], CONSTRAINT [DF_BillHeader_VATRATE3] DEFAULT (0) FOR [VATRATE3], CONSTRAINT [DF_BillHeader_WRITEBACKHOURS] DEFAULT (0) FOR [WRITEBACKHOURS], CONSTRAINT [DF_BillHeader_WRITEBACKVALUE] DEFAULT (0) FOR [WRITEBACKVALUE], CONSTRAINT [DF_BillHeader_ACTIONID] DEFAULT (0) FOR [ACTIONID], CONSTRAINT [DF_BillHeader_FEMISCTOTAL] DEFAULT (0) FOR [FEMISCTOTAL], CONSTRAINT [UQ__BillHeader__7BB05806] UNIQUE NONCLUSTERED ( [MATTER], [DRAFTNO], [BILLNO] ) ON [PRIMARY] GO CREATE INDEX [KeyBillNo] ON [dbo].[BillHeader]([MATTER], [BILLNO]) ON [PRIMARY] GO CREATE INDEX [KeyRelease] ON [dbo].[BillHeader]([RELEASED], [USER], [DATE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [KeyUser] ON [dbo].[BillHeader]([USER], [DATE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [KeyActionID] ON [dbo].[BillHeader]([ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyOpen] ON [dbo].[BillHeader]([OPENINVOICE], [MATTER], [BILLNO]) ON [PRIMARY] GO CREATE INDEX [KeyBatch] ON [dbo].[BillHeader]([BATCHNO]) ON [PRIMARY] GO CREATE INDEX [KeyBillNumber] ON [dbo].[BillHeader]([BILLNO]) ON [PRIMARY] GO ALTER TABLE [dbo].[BranchNominals] ADD CONSTRAINT [DF_BranchNominals_BALANCE] DEFAULT (0) FOR [BALANCE], CONSTRAINT [DF_BranchNominals_CURRENCYBAL] DEFAULT (0) FOR [CURRENCYBAL], CONSTRAINT [DF_BranchNominals_BALANCEFWD] DEFAULT (0) FOR [BALANCEFWD], CONSTRAINT [DF_BranchNominals_CURRENCYBALFWD] DEFAULT (0) FOR [CURRENCYBALFWD], CONSTRAINT [DF_BranchNominals_MONTH1] DEFAULT (0) FOR [MONTH1], CONSTRAINT [DF_BranchNominals_MONTH2] DEFAULT (0) FOR [MONTH2], CONSTRAINT [DF_BranchNominals_MONTH3] DEFAULT (0) FOR [MONTH3], CONSTRAINT [DF_BranchNominals_MONTH4] DEFAULT (0) FOR [MONTH4], CONSTRAINT [DF_BranchNominals_MONTH5] DEFAULT (0) FOR [MONTH5], CONSTRAINT [DF_BranchNominals_MONTH6] DEFAULT (0) FOR [MONTH6], CONSTRAINT [DF_BranchNominals_MONTH7] DEFAULT (0) FOR [MONTH7], CONSTRAINT [DF_BranchNominals_MONTH8] DEFAULT (0) FOR [MONTH8], CONSTRAINT [DF_BranchNominals_MONTH9] DEFAULT (0) FOR [MONTH9], CONSTRAINT [DF_BranchNominals_MONTH10] DEFAULT (0) FOR [MONTH10], CONSTRAINT [DF_BranchNominals_MONTH11] DEFAULT (0) FOR [MONTH11], CONSTRAINT [DF_BranchNominals_MONTH12] DEFAULT (0) FOR [MONTH12], CONSTRAINT [DF_BranchNominals_BUDGET1] DEFAULT (0) FOR [BUDGET1], CONSTRAINT [DF_BranchNominals_BUDGET2] DEFAULT (0) FOR [BUDGET2], CONSTRAINT [DF_BranchNominals_BUDGET3] DEFAULT (0) FOR [BUDGET3], CONSTRAINT [DF_BranchNominals_BUDGET4] DEFAULT (0) FOR [BUDGET4], CONSTRAINT [DF_BranchNominals_BUDGET5] DEFAULT (0) FOR [BUDGET5], CONSTRAINT [DF_BranchNominals_BUDGET6] DEFAULT (0) FOR [BUDGET6], CONSTRAINT [DF_BranchNominals_BUDGET7] DEFAULT (0) FOR [BUDGET7], CONSTRAINT [DF_BranchNominals_BUDGET8] DEFAULT (0) FOR [BUDGET8], CONSTRAINT [DF_BranchNominals_BUDGET9] DEFAULT (0) FOR [BUDGET9], CONSTRAINT [DF_BranchNominals_BUDGET10] DEFAULT (0) FOR [BUDGET10], CONSTRAINT [DF_BranchNominals_BUDGET11] DEFAULT (0) FOR [BUDGET11], CONSTRAINT [DF_BranchNominals_BUDGET12] DEFAULT (0) FOR [BUDGET12], CONSTRAINT [DF_BranchNominals_LASTYEAR1] DEFAULT (0) FOR [LASTYEAR1], CONSTRAINT [DF_BranchNominals_LASTYEAR2] DEFAULT (0) FOR [LASTYEAR2], CONSTRAINT [DF_BranchNominals_LASTYEAR3] DEFAULT (0) FOR [LASTYEAR3], CONSTRAINT [DF_BranchNominals_LASTYEAR4] DEFAULT (0) FOR [LASTYEAR4], CONSTRAINT [DF_BranchNominals_LASTYEAR5] DEFAULT (0) FOR [LASTYEAR5], CONSTRAINT [DF_BranchNominals_LASTYEAR6] DEFAULT (0) FOR [LASTYEAR6], CONSTRAINT [DF_BranchNominals_LASTYEAR7] DEFAULT (0) FOR [LASTYEAR7], CONSTRAINT [DF_BranchNominals_LASTYEAR8] DEFAULT (0) FOR [LASTYEAR8], CONSTRAINT [DF_BranchNominals_LASTYEAR9] DEFAULT (0) FOR [LASTYEAR9], CONSTRAINT [DF_BranchNominals_LASTYEAR10] DEFAULT (0) FOR [LASTYEAR10], CONSTRAINT [DF_BranchNominals_LASTYEAR11] DEFAULT (0) FOR [LASTYEAR11], CONSTRAINT [DF_BranchNominals_LASTYEAR12] DEFAULT (0) FOR [LASTYEAR12], CONSTRAINT [DF_BranchNominals_ACCRUAL] DEFAULT (0) FOR [ACCRUAL] GO CREATE INDEX [KeyConsolidate] ON [dbo].[BranchNominals]([CONSOLIDATETO]) ON [PRIMARY] GO CREATE INDEX [NomTy] ON [dbo].[BranchNominals]([TYPE], [BRANCH], [CODE]) ON [PRIMARY] GO CREATE INDEX [NomSeq] ON [dbo].[BranchNominals]([BRANCH], [PB], [SEQ]) ON [PRIMARY] GO CREATE INDEX [BranchCode] ON [dbo].[BranchNominals]([BRANCH], [CODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[Calendar] ADD UNIQUE NONCLUSTERED ( [CALDATE] ) ON [PRIMARY] , UNIQUE NONCLUSTERED ( [CALDATE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseAssociatesContacts] ADD CONSTRAINT [UQ__CaseAssociatesCo__60A75C0F] UNIQUE NONCLUSTERED ( [NAMECODE], [KEYID] ) ON [PRIMARY] GO CREATE INDEX [KeyNo] ON [dbo].[CaseAssociatesNames]([CONTACTNO]) ON [PRIMARY] GO CREATE INDEX [KeySearch] ON [dbo].[CaseAssociatesNames]([SEARCH]) ON [PRIMARY] GO CREATE INDEX [KeyType] ON [dbo].[CaseAssociatesNames]([TYPE], [CODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseAssoicatesTypes] ADD UNIQUE NONCLUSTERED ( [TYPECODE], [NAMECODE] ) ON [PRIMARY] GO CREATE INDEX [KeySearch] ON [dbo].[CaseAssoicatesTypes]([TYPECODE], [SEARCHCODE]) ON [PRIMARY] GO CREATE INDEX [KeyAssignedContacts] ON [dbo].[CaseContacts]([AssignedContact], [CASECODE], [NAMECODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[CaseUDFAnswers] ADD CONSTRAINT [DF_CaseUDFAnswers_NumberValue] DEFAULT (0) FOR [NumberValue] GO CREATE INDEX [KeyCaseSeq] ON [dbo].[CaseUDFAnswers]([CASECODE], [SEQNO]) ON [PRIMARY] GO CREATE INDEX [Key_SeqNo] ON [dbo].[CaseUDFAnswers]([SEQNO]) ON [PRIMARY] GO CREATE INDEX [Key_UDF] ON [dbo].[CaseUDFAnswers]([UDFFILE], [UDFNAME], [CASECODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[ChargeArrangements] ADD CONSTRAINT [DF_ChargeArrangements_BAND1LIMIT] DEFAULT (0) FOR [BAND1LIMIT], CONSTRAINT [DF_ChargeArrangements_BAND1RATE] DEFAULT (0) FOR [BAND1RATE], CONSTRAINT [DF_ChargeArrangements_BAND2LIMIT] DEFAULT (0) FOR [BAND2LIMIT], CONSTRAINT [DF_ChargeArrangements_BAND2RATE] DEFAULT (0) FOR [BAND2RATE], CONSTRAINT [DF_ChargeArrangements_BAND3LIMIT] DEFAULT (0) FOR [BAND3LIMIT], CONSTRAINT [DF_ChargeArrangements_BAND3RATE] DEFAULT (0) FOR [BAND3RATE], CONSTRAINT [DF_ChargeArrangements_BAND4LIMIT] DEFAULT (0) FOR [BAND4LIMIT], CONSTRAINT [DF_ChargeArrangements_BAND4RATE] DEFAULT (0) FOR [BAND4RATE], CONSTRAINT [DF_ChargeArrangements_BAND5LIMIT] DEFAULT (0) FOR [BAND5LIMIT], CONSTRAINT [DF_ChargeArrangements_BAND5RATE] DEFAULT (0) FOR [BAND5RATE] GO ALTER TABLE [dbo].[ChequeNumbers] ADD CONSTRAINT [DF_ChequeNumbers_LASTCHEQUENO] DEFAULT (0) FOR [LASTCHEQUENO] GO ALTER TABLE [dbo].[ChequeRequisitionDetail] ADD CONSTRAINT [DF_ChequeRequisitionDetail_VALUE] DEFAULT (0) FOR [VALUE] GO CREATE INDEX [KeyReqNo] ON [dbo].[ChequeRequisitionDetail]([REQNO], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyMatter] ON [dbo].[ChequeRequisitionDetail]([MATTER]) ON [PRIMARY] GO CREATE INDEX [KeyNominal] ON [dbo].[ChequeRequisitionDetail]([NOMINAL]) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequeRequisitionHeader] ADD CONSTRAINT [DF_ChequeRequisitionHeader_VALUE] DEFAULT (0) FOR [VALUE] GO CREATE INDEX [KeyFeearn] ON [dbo].[ChequeRequisitionHeader]([FEEEARNER], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyBank] ON [dbo].[ChequeRequisitionHeader]([BANK]) ON [PRIMARY] GO CREATE INDEX [KeyStatus] ON [dbo].[ChequeRequisitionHeader]([WHO], [STATUS]) ON [PRIMARY] GO CREATE INDEX [KeySent] ON [dbo].[ChequeRequisitionHeader]([STATUS], [REQNO]) ON [PRIMARY] GO ALTER TABLE [dbo].[ChequesForPrinting] ADD CONSTRAINT [DF_ChequesForPrinting_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_ChequesForPrinting_INVAMOUNT] DEFAULT (0) FOR [INVAMOUNT] GO CREATE INDEX [KeyBatch] ON [dbo].[ChequesForPrinting]([BATCHNO]) ON [PRIMARY] GO CREATE INDEX [KeyBank] ON [dbo].[ChequesForPrinting]([BANK], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyCase] ON [dbo].[CloseDiary]([CASECODE], [DATE], [ACTIONCODE]) ON [PRIMARY] GO CREATE INDEX [KeyCloseOrder] ON [dbo].[CloseDiary]([CASECODE], [FILENUM], [DATE]) ON [PRIMARY] GO ALTER TABLE [dbo].[CloseDiaryAttachments] ADD CONSTRAINT [DF_CloseDiaryAttachments_DIARYID] DEFAULT (0) FOR [DIARYID], CONSTRAINT [UQ__CloseDiaryAttach__61316BF4] UNIQUE NONCLUSTERED ( [DIARYID], [TRACKREFERENCE] ) ON [PRIMARY] GO CREATE INDEX [KeyCaseCode] ON [dbo].[CloseDiaryAttachments]([CASECODE], [TRACKREFERENCE]) ON [PRIMARY] GO CREATE INDEX [KeyName] ON [dbo].[CloseDiaryAttachments]([NAME], [CASECODE], [TRACKREFERENCE]) ON [PRIMARY] GO CREATE INDEX [KeyType] ON [dbo].[CloseDiaryAttachments]([TYPE]) ON [PRIMARY] GO CREATE INDEX [KeyDocClass] ON [dbo].[CloseDiaryAttachments]([DOCCLASS]) ON [PRIMARY] GO CREATE INDEX [KeyDocument] ON [dbo].[CloseDiaryAttachments]([NAME], [DIARYID]) ON [PRIMARY] GO ALTER TABLE [dbo].[Closed] ADD CONSTRAINT [DF_Closed_ESTFEE] DEFAULT (0) FOR [ESTFEE], CONSTRAINT [DF_Closed_OUTLAYBUD] DEFAULT (0) FOR [OUTLAYBUD], CONSTRAINT [DF_Closed_DEBTBAL] DEFAULT (0) FOR [DEBTBAL], CONSTRAINT [DF_Closed_OUTLAYBAL] DEFAULT (0) FOR [OUTLAYBAL], CONSTRAINT [DF_Closed_CLIENTBAL] DEFAULT (0) FOR [CLIENTBAL], CONSTRAINT [DF_Closed_CLIENTCURBAL] DEFAULT (0) FOR [CLIENTCURBAL], CONSTRAINT [DF_Closed_CLIENTDEPBAL] DEFAULT (0) FOR [CLIENTDEPBAL], CONSTRAINT [DF_Closed_DEBTBALFWD] DEFAULT (0) FOR [DEBTBALFWD], CONSTRAINT [DF_Closed_OUTLAYBALFWD] DEFAULT (0) FOR [OUTLAYBALFWD], CONSTRAINT [DF_Closed_CLIENTBALFWD] DEFAULT (0) FOR [CLIENTBALFWD], CONSTRAINT [DF_Closed_CLIENTCURBALFWD] DEFAULT (0) FOR [CLIENTCURBALFWD], CONSTRAINT [DF_Closed_CLIENTDEPBALFWD] DEFAULT (0) FOR [CLIENTDEPBALFWD], CONSTRAINT [DF_Closed_PENDINGBAL] DEFAULT (0) FOR [PENDINGBAL], CONSTRAINT [DF_Closed_CLIENTMIN] DEFAULT (0) FOR [CLIENTMIN], CONSTRAINT [DF_Closed_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_Closed_FNL_FEES] DEFAULT (0) FOR [FNL_FEES], CONSTRAINT [DF_Closed_FNL_OUTLAY] DEFAULT (0) FOR [FNL_OUTLAY], CONSTRAINT [DF_Closed_FNL_VAT] DEFAULT (0) FOR [FNL_VAT], CONSTRAINT [DF_Closed_FNL_TOTAL] DEFAULT (0) FOR [FNL_TOTAL], CONSTRAINT [DF_Closed_TIMEBAL] DEFAULT (0) FOR [TIMEBAL], CONSTRAINT [DF_Closed_CHARGEBAL] DEFAULT (0) FOR [CHARGEBAL], CONSTRAINT [DF_Closed_CURDEBTBAL] DEFAULT (0) FOR [CURDEBTBAL], CONSTRAINT [DF_Closed_CUROUTLAYBAL] DEFAULT (0) FOR [CUROUTLAYBAL], CONSTRAINT [DF_Closed_CURCLIENTBAL] DEFAULT (0) FOR [CURCLIENTBAL], CONSTRAINT [DF_Closed_CURCLIENTCBAL] DEFAULT (0) FOR [CURCLIENTCBAL], CONSTRAINT [DF_Closed_CURCLIENTDBAL] DEFAULT (0) FOR [CURCLIENTDBAL], CONSTRAINT [DF_Closed_CURDEBTBALFWD] DEFAULT (0) FOR [CURDEBTBALFWD], CONSTRAINT [DF_Closed_CUROUTLAYBALFWD] DEFAULT (0) FOR [CUROUTLAYBALFWD], CONSTRAINT [DF_Closed_CURCLIENTBALFWD] DEFAULT (0) FOR [CURCLIENTBALFWD], CONSTRAINT [DF_Closed_CURCLIENTCBALFWD] DEFAULT (0) FOR [CURCLIENTCBALFWD], CONSTRAINT [DF_Closed_CURCLIENTDBALFWD] DEFAULT (0) FOR [CURCLIENTDBALFWD], CONSTRAINT [DF_Closed_CURPENDINGBAL] DEFAULT (0) FOR [CURPENDINGBAL], CONSTRAINT [DF_Closed_UNALLOCATED] DEFAULT (0) FOR [UNALLOCATED], CONSTRAINT [DF_Closed_COMPOUTLAYLIMIT] DEFAULT (0) FOR [COMPOUTLAYLIMIT], CONSTRAINT [DF_Closed_COMPFEESLIMIT] DEFAULT (0) FOR [COMPFEESLIMIT], CONSTRAINT [DF_Closed_COMPTOTALLIMIT] DEFAULT (0) FOR [COMPTOTALLIMIT] GO CREATE INDEX [CMatterOnly] ON [dbo].[Closed]([CODE]) ON [PRIMARY] GO CREATE INDEX [CMatterOldref] ON [dbo].[Closed]([OTHERREF]) ON [PRIMARY] GO CREATE INDEX [CMatterClient] ON [dbo].[Closed]([CLIENTCODE]) ON [PRIMARY] GO CREATE INDEX [CMatterFe] ON [dbo].[Closed]([FECODE], [CLIENTCODE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [CMatterDept] ON [dbo].[Closed]([DEPT], [CLIENTCODE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [CMatterWType] ON [dbo].[Closed]([WTYPE], [CLIENTCODE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [CMatter3Party] ON [dbo].[Closed]([THIRDPART], [CLIENTCODE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [CMatter3PartSol] ON [dbo].[Closed]([THPARTSOL], [CLIENTCODE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [CKeyUser1] ON [dbo].[Closed]([USER1]) ON [PRIMARY] GO CREATE INDEX [CKeyUser2] ON [dbo].[Closed]([USER2]) ON [PRIMARY] GO CREATE INDEX [CKeyUser3] ON [dbo].[Closed]([USER3]) ON [PRIMARY] GO CREATE INDEX [KeyColour] ON [dbo].[Closed]([FILECOLOUR]) ON [PRIMARY] GO CREATE INDEX [BranchCode] ON [dbo].[Closed]([BRANCH], [CODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[ClosedCaseUDFAnswers] ADD CONSTRAINT [DF_ClosedCaseUDFAnswers_NumberValue] DEFAULT (0) FOR [NumberValue] GO CREATE INDEX [KeyCaseFileNum] ON [dbo].[ClosedCaseUDFAnswers]([CASECODE], [FILENUM]) ON [PRIMARY] GO CREATE INDEX [KeyCaseSeq] ON [dbo].[ClosedCaseUDFAnswers]([CASECODE], [SEQNO]) ON [PRIMARY] GO CREATE INDEX [Key_SeqNo] ON [dbo].[ClosedCaseUDFAnswers]([SEQNO]) ON [PRIMARY] GO ALTER TABLE [dbo].[ClosedMatterLedger] ADD CONSTRAINT [DF_ClosedMatterLedger_VALUED] DEFAULT (0) FOR [VALUED], CONSTRAINT [DF_ClosedMatterLedger_VALUEO] DEFAULT (0) FOR [VALUEO], CONSTRAINT [DF_ClosedMatterLedger_VALUEC] DEFAULT (0) FOR [VALUEC], CONSTRAINT [DF_ClosedMatterLedger_VALUECC] DEFAULT (0) FOR [VALUECC], CONSTRAINT [DF_ClosedMatterLedger_VALUECD] DEFAULT (0) FOR [VALUECD], CONSTRAINT [DF_ClosedMatterLedger_CURVALUED] DEFAULT (0) FOR [CURVALUED], CONSTRAINT [DF_ClosedMatterLedger_CURVALUEO] DEFAULT (0) FOR [CURVALUEO], CONSTRAINT [DF_ClosedMatterLedger_CURVALUEC] DEFAULT (0) FOR [CURVALUEC], CONSTRAINT [DF_ClosedMatterLedger_CURVALUECC] DEFAULT (0) FOR [CURVALUECC], CONSTRAINT [DF_ClosedMatterLedger_CURVALUECD] DEFAULT (0) FOR [CURVALUECD] GO ALTER TABLE [dbo].[CompositeBillBreakDown] ADD CONSTRAINT [DF_CompositeBillBreakDown_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_CompositeBillBreakDown_INCLUDEVALUE] DEFAULT (0) FOR [INCLUDEVALUE], CONSTRAINT [DF_CompositeBillBreakDown_LEDGERREF] DEFAULT (0) FOR [LEDGERREF] GO CREATE INDEX [KeyOutlay] ON [dbo].[CompositeBillBreakDown]([COMPBILLNO], [MATTER]) ON [PRIMARY] GO CREATE INDEX [KeyMatter] ON [dbo].[CompositeBillBreakDown]([COMPBILLNO], [MATTER], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyPostingRef] ON [dbo].[CompositeBillBreakDown]([BATCHNO], [POSTINGREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillDetail] ADD CONSTRAINT [DF_CompositeBillDetail_COMPBILLNO] DEFAULT (0) FOR [COMPBILLNO], CONSTRAINT [DF_CompositeBillDetail_TOTALOUTLAY] DEFAULT (0) FOR [TOTALOUTLAY], CONSTRAINT [DF_CompositeBillDetail_TOTALFEES] DEFAULT (0) FOR [TOTALFEES], CONSTRAINT [DF_CompositeBillDetail_TOTALTIME] DEFAULT (0) FOR [TOTALTIME], CONSTRAINT [UQ__CompositeBillDet__43A1090D] UNIQUE NONCLUSTERED ( [COMPBILLNO], [MATTER], [RECORDID] ) ON [PRIMARY] GO CREATE INDEX [KEYBILLNO] ON [dbo].[CompositeBillDetail]([COMPBILLNO], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KEYFE] ON [dbo].[CompositeBillDetail]([COMPBILLNO], [FEEEARNER], [MATTER]) ON [PRIMARY] GO CREATE INDEX [KEYMATTERLINK] ON [dbo].[CompositeBillDetail]([MATTER], [COMPBILLNO]) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillFees] ADD CONSTRAINT [DF_CompositeBillFees_COMPBILLNO] DEFAULT (0) FOR [COMPBILLNO], CONSTRAINT [DF_CompositeBillFees_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_CompositeBillFees_INCLUDEVALUE] DEFAULT (0) FOR [INCLUDEVALUE], CONSTRAINT [DF_CompositeBillFees_TIME] DEFAULT (0) FOR [TIME] GO CREATE INDEX [KeyBillNo] ON [dbo].[CompositeBillFees]([COMPBILLNO], [MATTER], [FE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyDate] ON [dbo].[CompositeBillFees]([COMPBILLNO], [MATTER], [FE], [DATE], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeBillHeader] ADD CONSTRAINT [DF_CompositeBillHeader_REQOUTLAYLIMIT] DEFAULT (0) FOR [REQOUTLAYLIMIT], CONSTRAINT [DF_CompositeBillHeader_REQFEESLIMIT] DEFAULT (0) FOR [REQFEESLIMIT], CONSTRAINT [DF_CompositeBillHeader_REQTOTALLIMIT] DEFAULT (0) FOR [REQTOTALLIMIT], CONSTRAINT [DF_CompositeBillHeader_TOTALOUTLAY] DEFAULT (0) FOR [TOTALOUTLAY], CONSTRAINT [DF_CompositeBillHeader_TOTALFEES] DEFAULT (0) FOR [TOTALFEES], CONSTRAINT [DF_CompositeBillHeader_TOTALBILL] DEFAULT (0) FOR [TOTALBILL], CONSTRAINT [DF_CompositeBillHeader_BATCHNO] DEFAULT (0) FOR [BATCHNO], CONSTRAINT [DF_CompositeBillHeader_PREF] DEFAULT (0) FOR [PREF] GO CREATE INDEX [KEYBATCHNO] ON [dbo].[CompositeBillHeader]([BATCHNO]) ON [PRIMARY] GO CREATE INDEX [KEYPOSTED] ON [dbo].[CompositeBillHeader]([UPDATED], [COMPDATE]) ON [PRIMARY] GO CREATE INDEX [KEYCLIENT] ON [dbo].[CompositeBillHeader]([REQCLIENT], [COMPBILLNO]) ON [PRIMARY] GO CREATE INDEX [KEYRELEASED] ON [dbo].[CompositeBillHeader]([UPDATED], [USER], [COMPDATE], [REQCLIENT]) ON [PRIMARY] GO CREATE INDEX [KEYUSER] ON [dbo].[CompositeBillHeader]([USER], [COMPDATE], [REQCLIENT]) ON [PRIMARY] GO ALTER TABLE [dbo].[CompositeFEBreakdown] ADD CONSTRAINT [DF_CompositeFEBreakdown_TOTALVALUE] DEFAULT (0) FOR [TOTALVALUE], CONSTRAINT [DF_CompositeFEBreakdown_TOTALTIME] DEFAULT (0) FOR [TOTALTIME] GO CREATE INDEX [KEYFEEEARNER] ON [dbo].[CompositeFEBreakdown]([COMPBILLNO], [FE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [COC_CONCAT] ON [dbo].[ContactCategories]([CONTACT], [CATEGORYTYPE], [CATEGORY]) ON [PRIMARY] GO CREATE INDEX [COC_CATCON] ON [dbo].[ContactCategories]([CATEGORYTYPE], [CATEGORY], [CONTACT]) ON [PRIMARY] GO CREATE INDEX [CLinkA] ON [dbo].[ContactLinks]([CONTACTA], [CONTACTB]) ON [PRIMARY] GO CREATE INDEX [ClinkB] ON [dbo].[ContactLinks]([CONTACTB], [CONTACTA]) ON [PRIMARY] GO ALTER TABLE [dbo].[ContactRequisition] ADD CONSTRAINT [UQ__ContactRequisiti__3BFFE745] UNIQUE NONCLUSTERED ( [NEWCONTACTREF] ) ON [PRIMARY] GO CREATE INDEX [Key_StatusI] ON [dbo].[ContactRequisition]([WHOINCEPT], [STATUS]) ON [PRIMARY] GO CREATE INDEX [Key_StatusA] ON [dbo].[ContactRequisition]([WHOAPPROVAL], [STATUS]) ON [PRIMARY] GO CREATE INDEX [Key_Sent] ON [dbo].[ContactRequisition]([STATUS], [TEMPCONTACTREF]) ON [PRIMARY] GO CREATE INDEX [Key_FE] ON [dbo].[ContactRequisition]([FE], [TEMPCONTACTREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[Contacts] ADD CONSTRAINT [DF_Contacts_StartDate] DEFAULT (getdate()) FOR [StartDate], CONSTRAINT [DF_Contacts_BillBal] DEFAULT (0) FOR [BillBal], CONSTRAINT [DF_Contacts_OutlayBal] DEFAULT (0) FOR [OutlayBal], CONSTRAINT [DF_Contacts_ClientCur] DEFAULT (0) FOR [ClientCur], CONSTRAINT [DF_Contacts_ClientDep] DEFAULT (0) FOR [ClientDep], CONSTRAINT [DF_Contacts_CurBillBal] DEFAULT (0) FOR [CurBillBal], CONSTRAINT [DF_Contacts_CurOutlayBal] DEFAULT (0) FOR [CurOutlayBal], CONSTRAINT [DF_Contacts_CurClientCBal] DEFAULT (0) FOR [CurClientCBal], CONSTRAINT [DF_Contacts_CurClientDBal] DEFAULT (0) FOR [CurClientDBal], CONSTRAINT [DF_Contacts_CompOutlayLimit] DEFAULT (0) FOR [CompOutlayLimit], CONSTRAINT [DF_Contacts_CompFeesLimit] DEFAULT (0) FOR [CompFeesLimit], CONSTRAINT [DF_Contacts_CompTotalLimit] DEFAULT (0) FOR [CompTotalLimit] GO ALTER TABLE [dbo].[CostFees] ADD CONSTRAINT [DF_CostFees_CFBANDLIMIT] DEFAULT (0) FOR [CFBANDLIMIT], CONSTRAINT [DF_CostFees_CFBANDAMT] DEFAULT (0) FOR [CFBANDAMT], CONSTRAINT [DF_CostFees_CFBANDPCENT] DEFAULT (0) FOR [CFBANDPCENT] GO ALTER TABLE [dbo].[CostTransGathering] ADD CONSTRAINT [DF_CostTransGathering_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_CostTransGathering_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_CostTransGathering_CURRENCYVAT] DEFAULT (0) FOR [CURRENCYVAT], CONSTRAINT [DF_CostTransGathering_ALLOCVALUE] DEFAULT (0) FOR [ALLOCVALUE] GO CREATE INDEX [BDMatter] ON [dbo].[CostTransGathering]([MATTER], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[CourtFees] ADD CONSTRAINT [DF_CourtFees_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_CourtFees_CLIENTVALUE] DEFAULT (0) FOR [CLIENTVALUE], UNIQUE NONCLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CreditorsList] ADD CONSTRAINT [DF_CreditorsList_ORIGVALUE] DEFAULT (0) FOR [ORIGVALUE], CONSTRAINT [DF_CreditorsList_OSVALUE] DEFAULT (0) FOR [OSVALUE], CONSTRAINT [DF_CreditorsList_PAYVALUE] DEFAULT (0) FOR [PAYVALUE] GO CREATE INDEX [KeySupplyCode] ON [dbo].[CreditorsList]([SUPPLYCODE], [BATCHNO], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [OPE_KEY] ON [dbo].[DBODSSW21]([OPE_SURNAME], [OPE_FIRSTNAME]) ON [PRIMARY] GO CREATE INDEX [LOG_KEY] ON [dbo].[DBODSSW24]([LOG_DATE], [LOG_TIME]) ON [PRIMARY] GO ALTER TABLE [dbo].[DataFiles] ADD CONSTRAINT [DF_DataFiles_VERSION] DEFAULT (0) FOR [VERSION], CONSTRAINT [UQ__DataFiles__56B3DD81] UNIQUE NONCLUSTERED ( [REALNAME] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtAccounts] ADD CONSTRAINT [DF_DebtAccounts_ACTRNAMT] DEFAULT (0) FOR [ACTRNAMT], CONSTRAINT [DF_DebtAccounts_ACTRNVAT] DEFAULT (0) FOR [ACTRNVAT] GO CREATE INDEX [KeycaseCode] ON [dbo].[DebtAccounts]([ACCASECODE]) ON [PRIMARY] GO CREATE INDEX [KeyAcTrnCode] ON [dbo].[DebtAccounts]([ACTRNCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[DebtCostingLedger] ADD CONSTRAINT [DF_DebtCostingLedger_Value] DEFAULT (0) FOR [Value], CONSTRAINT [DF_DebtCostingLedger_INTEREST] DEFAULT (0) FOR [INTEREST], CONSTRAINT [DF_DebtCostingLedger_COSTS] DEFAULT (0) FOR [COSTS], CONSTRAINT [DF_DebtCostingLedger_BOUNCED] DEFAULT (0) FOR [BOUNCED], CONSTRAINT [DF_DebtCostingLedger_PREMIUMPAID] DEFAULT (0) FOR [PREMIUMPAID], CONSTRAINT [DF_DebtCostingLedger_INTERESTPAID] DEFAULT (0) FOR [INTERESTPAID], CONSTRAINT [DF_DebtCostingLedger_COSTSPAID] DEFAULT (0) FOR [COSTSPAID] GO ALTER TABLE [dbo].[DebtorsLedger] ADD CONSTRAINT [DF_DebtorsLedger_ORIGINAL] DEFAULT (0) FOR [ORIGINAL], CONSTRAINT [DF_DebtorsLedger_OSVALUE] DEFAULT (0) FOR [OSVALUE], CONSTRAINT [DF_DebtorsLedger_ORFEES] DEFAULT (0) FOR [ORFEES], CONSTRAINT [DF_DebtorsLedger_OROUTLAY] DEFAULT (0) FOR [OROUTLAY], CONSTRAINT [DF_DebtorsLedger_ORVAT] DEFAULT (0) FOR [ORVAT], CONSTRAINT [DF_DebtorsLedger_OSFEES] DEFAULT (0) FOR [OSFEES], CONSTRAINT [DF_DebtorsLedger_OSOUTLAY] DEFAULT (0) FOR [OSOUTLAY], CONSTRAINT [DF_DebtorsLedger_OSVAT] DEFAULT (0) FOR [OSVAT] GO CREATE INDEX [DebtMat] ON [dbo].[DebtorsLedger]([MATTER], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [DebtClient] ON [dbo].[DebtorsLedger]([CLIENT], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [DebtBat] ON [dbo].[DebtorsLedger]([BATCHNO], [PREF], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [MESD_KEYMESSAGEHEADING] ON [dbo].[DesktopMessages]([MESSAGE], [HEADING]) ON [PRIMARY] GO CREATE INDEX [MESD_KEYHEADINGMESSAGE] ON [dbo].[DesktopMessages]([HEADING], [MESSAGE]) ON [PRIMARY] GO CREATE INDEX [MESD_KEYNAMEDATETIME] ON [dbo].[DesktopMessages]([NAME], [DATE], [TIME]) ON [PRIMARY] GO ALTER TABLE [dbo].[DesktopNarr] ADD CONSTRAINT [UQ__DesktopNarr__4F47C5E3] UNIQUE NONCLUSTERED ( [CODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryAttachments] ADD CONSTRAINT [DF_DiaryAttachments_DIARYID] DEFAULT (0) FOR [DIARYID], CONSTRAINT [UQ__DiaryAttachments__5B78929E] UNIQUE NONCLUSTERED ( [DIARYID], [TRACKREFERENCE] ) ON [PRIMARY] GO CREATE INDEX [KeyType] ON [dbo].[DiaryAttachments]([TYPE]) ON [PRIMARY] GO CREATE INDEX [KeyName] ON [dbo].[DiaryAttachments]([NAME], [CASECODE], [TRACKREFERENCE]) ON [PRIMARY] GO CREATE INDEX [KeyDocument] ON [dbo].[DiaryAttachments]([NAME], [DIARYID]) ON [PRIMARY] GO CREATE INDEX [KeyDocClass] ON [dbo].[DiaryAttachments]([DOCCLASS]) ON [PRIMARY] GO CREATE INDEX [KeyCaseCode] ON [dbo].[DiaryAttachments]([CASECODE], [TRACKREFERENCE]) ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryDelegations] ADD CONSTRAINT [DF_DiaryDelegations_ACTIONID] DEFAULT (0) FOR [ACTIONID] GO CREATE INDEX [KeyHandler] ON [dbo].[DiaryDelegations]([HANDLER], [DATE], [TIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyHandlerDue] ON [dbo].[DiaryDelegations]([HANDLER], [DUEDATE], [DUETIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyHandlerStatus] ON [dbo].[DiaryDelegations]([HANDLER], [STATUS], [DATE], [TIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyHandlerDueStatus] ON [dbo].[DiaryDelegations]([HANDLER], [STATUS], [DUEDATE], [DUETIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyTeamStatus] ON [dbo].[DiaryDelegations]([TEAM], [STATUS], [DATE], [TIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyTeamStatusDue] ON [dbo].[DiaryDelegations]([TEAM], [STATUS], [DUEDATE], [DUETIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyTeam] ON [dbo].[DiaryDelegations]([TEAM], [DATE], [TIME], [ACTIONID]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyOwner] ON [dbo].[DiaryDelegations]([ACTIONID], [OWNER]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [KeyActionAssignNo] ON [dbo].[DiaryDelegations]([ACTIONID], [AssignNo] DESC ) WITH FILLFACTOR = 90 ON [PRIMARY] GO ALTER TABLE [dbo].[DiaryLinks] ADD CONSTRAINT [DF_DiaryLinks_ActionID] DEFAULT (0) FOR [ActionID], CONSTRAINT [DF_DiaryLinks_ChildId] DEFAULT (0) FOR [ChildId], CONSTRAINT [IX_DiaryLinks] UNIQUE NONCLUSTERED ( [ActionID], [ChildId], [RecordID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DocumentPopCat] ADD UNIQUE NONCLUSTERED ( [CATEGORY] ) ON [PRIMARY] GO CREATE INDEX [KeyCategory] ON [dbo].[DocumentPopups]([CATEGORY]) ON [PRIMARY] GO CREATE INDEX [KeyNewName] ON [dbo].[FieldTransfer]([NEWFIELDPREFIX], [NEWFIELDNAME]) ON [PRIMARY] GO CREATE INDEX [KeyCategory] ON [dbo].[FieldTransfer]([CATEGORY]) ON [PRIMARY] GO CREATE INDEX [FCOL_KEYCODE] ON [dbo].[FileColours]([COLOURCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[FileManagerItems] ADD CONSTRAINT [DF_FileManagerItems_ESTIMATEESTATE] DEFAULT (0) FOR [ESTIMATEESTATE], CONSTRAINT [UQ__FileManagerItems__4F67C174] UNIQUE NONCLUSTERED ( [NUMBER], [ITEMCODE] ) ON [PRIMARY] GO CREATE INDEX [KEYCLIENT] ON [dbo].[FileManagerItems]([CLIENTCODE]) ON [PRIMARY] GO CREATE INDEX [KEYMATTER] ON [dbo].[FileManagerItems]([MATTERCODE]) ON [PRIMARY] GO CREATE INDEX [KEYType] ON [dbo].[FileManagerItems]([ITEMTYPE], [CLIENTCODE], [MATTERCODE]) ON [PRIMARY] GO CREATE INDEX [KeyFE] ON [dbo].[FileManagerItems]([FEEARNER], [ITEMTYPE], [CLIENTCODE], [MATTERCODE]) ON [PRIMARY] GO CREATE INDEX [keysearch] ON [dbo].[FileManagerItems]([SEARCHCODE]) ON [PRIMARY] GO CREATE INDEX [KeyItemCode] ON [dbo].[FileManagerItems]([ITEMCODE]) ON [PRIMARY] GO CREATE INDEX [KeyBoxNo] ON [dbo].[FileManagerItems]([BOXNO]) ON [PRIMARY] GO CREATE INDEX [KEYLOCATION] ON [dbo].[FileManagerItems]([LOCATION], [ITEMTYPE], [CLIENTCODE], [MATTERCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[Forms] ADD CONSTRAINT [DF_Forms_AMOUNT] DEFAULT (0) FOR [AMOUNT] GO ALTER TABLE [dbo].[HandlerBudgets] ADD CONSTRAINT [DF_HandlerBudgets_FeesBudget] DEFAULT (0) FOR [FeesBudget], CONSTRAINT [DF_HandlerBudgets_ChargableTimeBudget] DEFAULT (0) FOR [ChargableTimeBudget], CONSTRAINT [DF_HandlerBudgets_NonChargableTimeBudget] DEFAULT (0) FOR [NonChargableTimeBudget] GO CREATE UNIQUE INDEX [IX_HandlerBudgets] ON [dbo].[HandlerBudgets]([Handler], [Year], [Month]) ON [PRIMARY] GO ALTER TABLE [dbo].[Handlers] ADD CONSTRAINT [DF_Handlers_BUDGET1] DEFAULT (0) FOR [BUDGET1], CONSTRAINT [DF_Handlers_BUDGET2] DEFAULT (0) FOR [BUDGET2], CONSTRAINT [DF_Handlers_BUDGET3] DEFAULT (0) FOR [BUDGET3], CONSTRAINT [DF_Handlers_BUDGET4] DEFAULT (0) FOR [BUDGET4], CONSTRAINT [DF_Handlers_BUDGET5] DEFAULT (0) FOR [BUDGET5], CONSTRAINT [DF_Handlers_BUDGET6] DEFAULT (0) FOR [BUDGET6], CONSTRAINT [DF_Handlers_BUDGET7] DEFAULT (0) FOR [BUDGET7], CONSTRAINT [DF_Handlers_BUDGET8] DEFAULT (0) FOR [BUDGET8], CONSTRAINT [DF_Handlers_BUDGET9] DEFAULT (0) FOR [BUDGET9], CONSTRAINT [DF_Handlers_BUDGET10] DEFAULT (0) FOR [BUDGET10], CONSTRAINT [DF_Handlers_BUDGET11] DEFAULT (0) FOR [BUDGET11], CONSTRAINT [DF_Handlers_BUDGET12] DEFAULT (0) FOR [BUDGET12], CONSTRAINT [DF_Handlers_ACTUAL1] DEFAULT (0) FOR [ACTUAL1], CONSTRAINT [DF_Handlers_ACTUAL2] DEFAULT (0) FOR [ACTUAL2], CONSTRAINT [DF_Handlers_ACTUAL3] DEFAULT (0) FOR [ACTUAL3], CONSTRAINT [DF_Handlers_ACTUAL4] DEFAULT (0) FOR [ACTUAL4], CONSTRAINT [DF_Handlers_ACTUAL5] DEFAULT (0) FOR [ACTUAL5], CONSTRAINT [DF_Handlers_ACTUAL6] DEFAULT (0) FOR [ACTUAL6], CONSTRAINT [DF_Handlers_ACTUAL7] DEFAULT (0) FOR [ACTUAL7], CONSTRAINT [DF_Handlers_ACTUAL8] DEFAULT (0) FOR [ACTUAL8], CONSTRAINT [DF_Handlers_ACTUAL9] DEFAULT (0) FOR [ACTUAL9], CONSTRAINT [DF_Handlers_ACTUAL10] DEFAULT (0) FOR [ACTUAL10], CONSTRAINT [DF_Handlers_ACTUAL11] DEFAULT (0) FOR [ACTUAL11], CONSTRAINT [DF_Handlers_ACTUAL12] DEFAULT (0) FOR [ACTUAL12], CONSTRAINT [DF_Handlers_TEMPCALC] DEFAULT (0) FOR [TEMPCALC], CONSTRAINT [DF_Handlers_NORECENTMATTERS] DEFAULT (0) FOR [NORECENTMATTERS], CONSTRAINT [DF_Handlers_RATE1] DEFAULT (0) FOR [RATE1], CONSTRAINT [DF_Handlers_RATE2] DEFAULT (0) FOR [RATE2], CONSTRAINT [DF_Handlers_RATE3] DEFAULT (0) FOR [RATE3], CONSTRAINT [DF_Handlers_RATE4] DEFAULT (0) FOR [RATE4], CONSTRAINT [DF_Handlers_RATE5] DEFAULT (0) FOR [RATE5] GO CREATE INDEX [KeyLogon] ON [dbo].[Handlers]([LOGON]) ON [PRIMARY] GO CREATE INDEX [KeyTeam] ON [dbo].[Handlers]([TEAM], [CODE]) ON [PRIMARY] GO CREATE INDEX [KeyExchange] ON [dbo].[Handlers]([EXCHANGEALIAS]) ON [PRIMARY] GO ALTER TABLE [dbo].[HandlersDepartments] ADD CONSTRAINT [KeyHandlerDept] UNIQUE NONCLUSTERED ( [Handler], [Department] ) ON [PRIMARY] GO CREATE INDEX [MatterKey] ON [dbo].[InterestCalcHistory]([MATTERREF], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyDate] ON [dbo].[InterestCalcHistory]([DATE], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[InterestRates] ADD CONSTRAINT [UQ__InterestRates__3D9E16F4] UNIQUE NONCLUSTERED ( [DATEFROM], [RECORDID] ) ON [PRIMARY] GO CREATE INDEX [KeyItemCode] ON [dbo].[ItemDiary]([NUMBER], [ITEMCODE], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyNumber] ON [dbo].[ItemDiary]([NUMBER], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyHandler] ON [dbo].[ItemHistory]([HANDLER]) ON [PRIMARY] GO CREATE INDEX [KeyNumber] ON [dbo].[ItemHistory]([NUMBER]) ON [PRIMARY] GO CREATE INDEX [JPER_KeyUserNumber] ON [dbo].[JPermissions]([JPER_UserNumber]) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterLedger] ADD CONSTRAINT [DF_MatterLedger_VALUED] DEFAULT (0) FOR [VALUED], CONSTRAINT [DF_MatterLedger_VALUEO] DEFAULT (0) FOR [VALUEO], CONSTRAINT [DF_MatterLedger_VALUEC] DEFAULT (0) FOR [VALUEC], CONSTRAINT [DF_MatterLedger_VALUECC] DEFAULT (0) FOR [VALUECC], CONSTRAINT [DF_MatterLedger_VALUECD] DEFAULT (0) FOR [VALUECD], CONSTRAINT [DF_MatterLedger_CURVALUED] DEFAULT (0) FOR [CURVALUED], CONSTRAINT [DF_MatterLedger_CURVALUEO] DEFAULT (0) FOR [CURVALUEO], CONSTRAINT [DF_MatterLedger_CURVALUEC] DEFAULT (0) FOR [CURVALUEC], CONSTRAINT [DF_MatterLedger_CURVALUECC] DEFAULT (0) FOR [CURVALUECC], CONSTRAINT [DF_MatterLedger_CURVALUECD] DEFAULT (0) FOR [CURVALUECD] GO CREATE INDEX [MatLed] ON [dbo].[MatterLedger]([MATTER], [DATE]) ON [PRIMARY] GO CREATE INDEX [MatLedAudit] ON [dbo].[MatterLedger]([ENTRYDATE], [MATTER]) ON [PRIMARY] GO CREATE INDEX [MatterBat] ON [dbo].[MatterLedger]([BATCHNO], [PREF]) ON [PRIMARY] GO CREATE INDEX [MatLedC] ON [dbo].[MatterLedger]([CLIENT], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyBilled] ON [dbo].[MatterLedger]([MATTER], [BILLED], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyLRef] ON [dbo].[MatterLedger]([LREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterLedgerClearDown] ADD CONSTRAINT [DF_MatterLedgerClearDown_VALUED] DEFAULT (0) FOR [VALUED], CONSTRAINT [DF_MatterLedgerClearDown_VALUEO] DEFAULT (0) FOR [VALUEO], CONSTRAINT [DF_MatterLedgerClearDown_VALUEC] DEFAULT (0) FOR [VALUEC], CONSTRAINT [DF_MatterLedgerClearDown_VALUECC] DEFAULT (0) FOR [VALUECC], CONSTRAINT [DF_MatterLedgerClearDown_VALUECD] DEFAULT (0) FOR [VALUECD], CONSTRAINT [DF_MatterLedgerClearDown_CURVALUED] DEFAULT (0) FOR [CURVALUED], CONSTRAINT [DF_MatterLedgerClearDown_CURVALUEO] DEFAULT (0) FOR [CURVALUEO], CONSTRAINT [DF_MatterLedgerClearDown_CURVALUEC] DEFAULT (0) FOR [CURVALUEC], CONSTRAINT [DF_MatterLedgerClearDown_CURVALUECC] DEFAULT (0) FOR [CURVALUECC], CONSTRAINT [DF_MatterLedgerClearDown_CURVALUECD] DEFAULT (0) FOR [CURVALUECD] GO CREATE INDEX [MatLed] ON [dbo].[MatterLedgerClearDown]([MATTER], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [MatLedAudit] ON [dbo].[MatterLedgerClearDown]([ENTRYDATE], [MATTER], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [MatterBat] ON [dbo].[MatterLedgerClearDown]([BATCHNO], [PREF], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [MatLedC] ON [dbo].[MatterLedgerClearDown]([CLIENT], [DATE], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[MatterTally] ADD CONSTRAINT [DF_MatterTally_AMOUNT] DEFAULT (0) FOR [AMOUNT], CONSTRAINT [DF_MatterTally_RATE] DEFAULT (0) FOR [RATE], CONSTRAINT [DF_MatterTally_DIRT] DEFAULT (0) FOR [DIRT], CONSTRAINT [DF_MatterTally_RESULT] DEFAULT (0) FOR [RESULT], CONSTRAINT [DF_MatterTally_TOTAL] DEFAULT (0) FOR [TOTAL] GO CREATE INDEX [MATTERKEY] ON [dbo].[MatterTally]([MATTER], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KEYHIGHLOW] ON [dbo].[MatterTally]([MATTER], [HIGHLOW], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[MemorisedBatchD] ADD CONSTRAINT [DF_MemorisedBatchD_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_MemorisedBatchD_VATVAL] DEFAULT (0) FOR [VATVAL] GO CREATE INDEX [BDNo] ON [dbo].[MemorisedBatchD]([MCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[MemorsiedBatchH] ADD CONSTRAINT [DF_MemorsiedBatchH_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [UQ__MemorsiedBatchH__618671AF] UNIQUE NONCLUSTERED ( [MCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MiscCodes] ADD UNIQUE NONCLUSTERED ( [CDETYPE], [CDECODE] ) ON [PRIMARY] , UNIQUE NONCLUSTERED ( [CDECODE] ) ON [PRIMARY] , UNIQUE NONCLUSTERED ( [CDETYPE], [CDECODE], [CDEDESC] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MultiBatchD] ADD CONSTRAINT [DF_MultiBatchD_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_MultiBatchD_VATVAL] DEFAULT (0) FOR [VATVAL], CONSTRAINT [DF_MultiBatchD_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_MultiBatchD_CURRENCYVAT] DEFAULT (0) FOR [CURRENCYVAT], CONSTRAINT [DF_MultiBatchD_ALLOCVALUE] DEFAULT (0) FOR [ALLOCVALUE] GO CREATE INDEX [BDNo] ON [dbo].[MultiBatchD]([BATCHNO], [PREF]) ON [PRIMARY] GO CREATE INDEX [BADOutlayCode] ON [dbo].[MultiBatchD]([OUTLAYCODE]) ON [PRIMARY] GO CREATE INDEX [BDNom] ON [dbo].[MultiBatchD]([CODE]) ON [PRIMARY] GO CREATE INDEX [BDMatter] ON [dbo].[MultiBatchD]([MATTER]) ON [PRIMARY] GO CREATE INDEX [BDSupp] ON [dbo].[MultiBatchD]([SUPP]) ON [PRIMARY] GO CREATE INDEX [BDPref] ON [dbo].[MultiBatchD]([PREF]) ON [PRIMARY] GO CREATE INDEX [VATKey] ON [dbo].[MultiBatchD]([YEAR], [PERNO], [TYPE], [VATCODE], [DATE]) ON [PRIMARY] GO CREATE INDEX [AllocsKey] ON [dbo].[MultiBatchD]([ALLOCBATCH], [ALLOCPREF]) ON [PRIMARY] GO CREATE INDEX [KeyOldFieldName] ON [dbo].[MultiField]([OLDFIELDNAME], [CASEPLAN]) ON [PRIMARY] GO CREATE INDEX [Keycaseplan] ON [dbo].[MultiField]([CASEPLAN]) ON [PRIMARY] GO CREATE INDEX [Keycategory] ON [dbo].[MultiField]([CATEGORY]) ON [PRIMARY] GO ALTER TABLE [dbo].[NewNominal] ADD CONSTRAINT [DF_NewNominal_BALANCE] DEFAULT (0) FOR [BALANCE] GO ALTER TABLE [dbo].[Nominal] ADD CONSTRAINT [DF_Nominal_BALANCE] DEFAULT (0) FOR [BALANCE], CONSTRAINT [DF_Nominal_CURRENCYBAL] DEFAULT (0) FOR [CURRENCYBAL], CONSTRAINT [DF_Nominal_BALANCEFWD] DEFAULT (0) FOR [BALANCEFWD], CONSTRAINT [DF_Nominal_CURRENCYBALFWD] DEFAULT (0) FOR [CURRENCYBALFWD], CONSTRAINT [DF_Nominal_MONTH1] DEFAULT (0) FOR [MONTH1], CONSTRAINT [DF_Nominal_MONTH2] DEFAULT (0) FOR [MONTH2], CONSTRAINT [DF_Nominal_MONTH3] DEFAULT (0) FOR [MONTH3], CONSTRAINT [DF_Nominal_MONTH4] DEFAULT (0) FOR [MONTH4], CONSTRAINT [DF_Nominal_MONTH5] DEFAULT (0) FOR [MONTH5], CONSTRAINT [DF_Nominal_MONTH6] DEFAULT (0) FOR [MONTH6], CONSTRAINT [DF_Nominal_MONTH7] DEFAULT (0) FOR [MONTH7], CONSTRAINT [DF_Nominal_MONTH8] DEFAULT (0) FOR [MONTH8], CONSTRAINT [DF_Nominal_MONTH9] DEFAULT (0) FOR [MONTH9], CONSTRAINT [DF_Nominal_MONTH10] DEFAULT (0) FOR [MONTH10], CONSTRAINT [DF_Nominal_MONTH11] DEFAULT (0) FOR [MONTH11], CONSTRAINT [DF_Nominal_MONTH12] DEFAULT (0) FOR [MONTH12], CONSTRAINT [DF_Nominal_BUDGET1] DEFAULT (0) FOR [BUDGET1], CONSTRAINT [DF_Nominal_BUDGET2] DEFAULT (0) FOR [BUDGET2], CONSTRAINT [DF_Nominal_BUDGET3] DEFAULT (0) FOR [BUDGET3], CONSTRAINT [DF_Nominal_BUDGET4] DEFAULT (0) FOR [BUDGET4], CONSTRAINT [DF_Nominal_BUDGET5] DEFAULT (0) FOR [BUDGET5], CONSTRAINT [DF_Nominal_BUDGET6] DEFAULT (0) FOR [BUDGET6], CONSTRAINT [DF_Nominal_BUDGET7] DEFAULT (0) FOR [BUDGET7], CONSTRAINT [DF_Nominal_BUDGET8] DEFAULT (0) FOR [BUDGET8], CONSTRAINT [DF_Nominal_BUDGET9] DEFAULT (0) FOR [BUDGET9], CONSTRAINT [DF_Nominal_BUDGET10] DEFAULT (0) FOR [BUDGET10], CONSTRAINT [DF_Nominal_BUDGET11] DEFAULT (0) FOR [BUDGET11], CONSTRAINT [DF_Nominal_BUDGET12] DEFAULT (0) FOR [BUDGET12], CONSTRAINT [DF_Nominal_LASTYEAR1] DEFAULT (0) FOR [LASTYEAR1], CONSTRAINT [DF_Nominal_LASTYEAR2] DEFAULT (0) FOR [LASTYEAR2], CONSTRAINT [DF_Nominal_LASTYEAR3] DEFAULT (0) FOR [LASTYEAR3], CONSTRAINT [DF_Nominal_LASTYEAR4] DEFAULT (0) FOR [LASTYEAR4], CONSTRAINT [DF_Nominal_LASTYEAR5] DEFAULT (0) FOR [LASTYEAR5], CONSTRAINT [DF_Nominal_LASTYEAR6] DEFAULT (0) FOR [LASTYEAR6], CONSTRAINT [DF_Nominal_LASTYEAR7] DEFAULT (0) FOR [LASTYEAR7], CONSTRAINT [DF_Nominal_LASTYEAR8] DEFAULT (0) FOR [LASTYEAR8], CONSTRAINT [DF_Nominal_LASTYEAR9] DEFAULT (0) FOR [LASTYEAR9], CONSTRAINT [DF_Nominal_LASTYEAR10] DEFAULT (0) FOR [LASTYEAR10], CONSTRAINT [DF_Nominal_LASTYEAR11] DEFAULT (0) FOR [LASTYEAR11], CONSTRAINT [DF_Nominal_LASTYEAR12] DEFAULT (0) FOR [LASTYEAR12], CONSTRAINT [DF_Nominal_LASTNO] DEFAULT (0) FOR [LASTNO], CONSTRAINT [DF_Nominal_ACCRUAL] DEFAULT (0) FOR [ACCRUAL] GO CREATE INDEX [NomTy] ON [dbo].[Nominal]([TYPE], [CODE]) ON [PRIMARY] GO CREATE INDEX [NomSeq] ON [dbo].[Nominal]([PB], [SEQ]) ON [PRIMARY] GO ALTER TABLE [dbo].[NominalLedger] ADD CONSTRAINT [DF_NominalLedger_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_NominalLedger_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE] GO CREATE INDEX [NXN_NOMTRANS] ON [dbo].[NominalLedger]([CODE], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [NXN_BRANCHCODE] ON [dbo].[NominalLedger]([BRANCH], [CODE], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [NXN_NOMTRANSAUDIT] ON [dbo].[NominalLedger]([ENTRYDATE], [CODE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [NXN_NOMBATCH] ON [dbo].[NominalLedger]([BATCHNO], [PREF], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyContactCode] ON [dbo].[Officers]([CONTACTCODE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyOfficer] ON [dbo].[Officers]([CONTACTOFFICER]) ON [PRIMARY] GO CREATE INDEX [OLX_KEYMATTER] ON [dbo].[OutlayTransfer]([MATTER], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [OLX_KEYRECORDID] ON [dbo].[OutlayTransfer]([RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[OutlookIds] ADD UNIQUE NONCLUSTERED ( [OUTLOOKID] ) ON [PRIMARY] GO CREATE INDEX [KeyActionId] ON [dbo].[OutlookIds]([ACTIONID]) ON [PRIMARY] GO ALTER TABLE [dbo].[PendingOutlay] ADD CONSTRAINT [DF_PendingOutlay_VALUE] DEFAULT (0) FOR [VALUE] GO CREATE INDEX [KeyMatter] ON [dbo].[PendingOutlay]([MATTER], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeySupplier] ON [dbo].[PendingOutlay]([SUPPLIER], [DATE], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[RBatchD] ADD CONSTRAINT [DF_RBatchD_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_RBatchD_VATVAL] DEFAULT (0) FOR [VATVAL], CONSTRAINT [DF_RBatchD_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_RBatchD_CURRENCYVAT] DEFAULT (0) FOR [CURRENCYVAT], CONSTRAINT [DF_RBatchD_ALLOCVALUE] DEFAULT (0) FOR [ALLOCVALUE] GO CREATE INDEX [RBatchH] ON [dbo].[RBatchD]([DATE], [BATCHNO], [PREF], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[RBatchH] ADD CONSTRAINT [DF_RBatchH_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_RBatchH_SUBTOT] DEFAULT (0) FOR [SUBTOT], CONSTRAINT [DF_RBatchH_OUTLAYTOT] DEFAULT (0) FOR [OUTLAYTOT], CONSTRAINT [DF_RBatchH_VATTOT] DEFAULT (0) FOR [VATTOT], CONSTRAINT [DF_RBatchH_FEETOT] DEFAULT (0) FOR [FEETOT], CONSTRAINT [DF_RBatchH_CURRENCYVALUE] DEFAULT (0) FOR [CURRENCYVALUE], CONSTRAINT [DF_RBatchH_CUROUTLAYTOT] DEFAULT (0) FOR [CUROUTLAYTOT], CONSTRAINT [DF_RBatchH_CURVATTOT] DEFAULT (0) FOR [CURVATTOT], CONSTRAINT [DF_RBatchH_CURFEETOT] DEFAULT (0) FOR [CURFEETOT] GO CREATE INDEX [KeyFeeDate] ON [dbo].[RecentMatterList]([FEE], [DateField] DESC , [TIME] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyFeeDateA] ON [dbo].[RecentMatterList]([FEE], [DateField], [TIME]) ON [PRIMARY] GO CREATE INDEX [KeyMatter] ON [dbo].[RecentMatterList]([MATTER]) ON [PRIMARY] GO CREATE INDEX [KEYMESSAGEHEADING] ON [dbo].[SAMMessages]([MESSAGE], [HEADING]) ON [PRIMARY] GO CREATE INDEX [KEYHEADINGMESSAGE] ON [dbo].[SAMMessages]([HEADING], [MESSAGE]) ON [PRIMARY] GO CREATE INDEX [KEYNAMEDATETIME] ON [dbo].[SAMMessages]([NAME], [DATE], [TIME]) ON [PRIMARY] GO CREATE INDEX [KeyDescription] ON [dbo].[StatusCodes]([DESCRIPTION]) ON [PRIMARY] GO ALTER TABLE [dbo].[SupplierLedger] ADD CONSTRAINT [DF_SupplierLedger_ORIGINAL] DEFAULT (0) FOR [ORIGINAL], CONSTRAINT [DF_SupplierLedger_OSVALUE] DEFAULT (0) FOR [OSVALUE], CONSTRAINT [DF_SupplierLedger_THIRDPARTYVALUE] DEFAULT (0) FOR [THIRDPARTYVALUE], CONSTRAINT [DF_SupplierLedger_PENDINGOUTLAY] DEFAULT (0) FOR [PENDINGOUTLAY] GO CREATE INDEX [SupLed] ON [dbo].[SupplierLedger]([SUPP], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [SupledAudit] ON [dbo].[SupplierLedger]([ENTRYDATE], [SUPP], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [SupLedB] ON [dbo].[SupplierLedger]([BATCHNO], [PREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[Suppliers] ADD CONSTRAINT [DF_Suppliers_BALANCE] DEFAULT (0) FOR [BALANCE], CONSTRAINT [DF_Suppliers_BALANCEFWD] DEFAULT (0) FOR [BALANCEFWD], CONSTRAINT [DF_Suppliers_TPBAL] DEFAULT (0) FOR [TPBAL], CONSTRAINT [DF_Suppliers_UNALLOCATED] DEFAULT (0) FOR [UNALLOCATED], CONSTRAINT [DF_Suppliers_PAYRUNTOTAL] DEFAULT (0) FOR [PAYRUNTOTAL] GO CREATE INDEX [SupNom] ON [dbo].[Suppliers]([NOMINAL]) ON [PRIMARY] GO ALTER TABLE [dbo].[SystemUserDefinedFields] ADD CONSTRAINT [DF_SystemUserDefinedFields_LENGTH] DEFAULT (0) FOR [LENGTH], CONSTRAINT [DF_SystemUserDefinedFields_DECMIAL] DEFAULT (0) FOR [DECMIAL], CONSTRAINT [DF_SystemUserDefinedFields_LOW] DEFAULT (0) FOR [LOW], CONSTRAINT [DF_SystemUserDefinedFields_HIGH] DEFAULT (0) FOR [HIGH], CONSTRAINT [DF_SystemUserDefinedFields_TOP] DEFAULT (0) FOR [TOP], CONSTRAINT [DF_SystemUserDefinedFields_LEFT] DEFAULT (0) FOR [LEFT], CONSTRAINT [DF_SystemUserDefinedFields_HEIGHT] DEFAULT (0) FOR [HEIGHT], CONSTRAINT [DF_SystemUserDefinedFields_WIDTH] DEFAULT (0) FOR [WIDTH] GO CREATE INDEX [KeyFieldName] ON [dbo].[SystemUserDefinedFields]([FIELDNAME]) ON [PRIMARY] GO CREATE INDEX [KeyActual] ON [dbo].[SystemUserDefinedFields]([ACTUALNAME]) ON [PRIMARY] GO ALTER TABLE [dbo].[TasksCodes] ADD CONSTRAINT [DF_TasksCodes_CHARGEAMT] DEFAULT (0) FOR [CHARGEAMT] GO CREATE INDEX [KeyDept] ON [dbo].[Team]([DEPT]) ON [PRIMARY] GO ALTER TABLE [dbo].[TeamMembers] ADD UNIQUE NONCLUSTERED ( [HANDLER], [TEAMCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TempBatchD] ADD CONSTRAINT [DF_TempBatchD_Value] DEFAULT (0) FOR [Value], CONSTRAINT [DF_TempBatchD_VATVal] DEFAULT (0) FOR [VATVal], CONSTRAINT [DF_TempBatchD_CurrencyValue] DEFAULT (0) FOR [CurrencyValue], CONSTRAINT [DF_TempBatchD_CurrencyVAT] DEFAULT (0) FOR [CurrencyVAT], CONSTRAINT [DF_TempBatchD_AllocValue] DEFAULT (0) FOR [AllocValue] GO ALTER TABLE [dbo].[TempBatchH] ADD CONSTRAINT [DF_TempBatchH_Value] DEFAULT (0) FOR [Value], CONSTRAINT [DF_TempBatchH_SubTot] DEFAULT (0) FOR [SubTot], CONSTRAINT [DF_TempBatchH_OutlayTot] DEFAULT (0) FOR [OutlayTot], CONSTRAINT [DF_TempBatchH_VATTot] DEFAULT (0) FOR [VATTot], CONSTRAINT [DF_TempBatchH_FeeTot] DEFAULT (0) FOR [FeeTot], CONSTRAINT [DF_TempBatchH_CurrencyValue] DEFAULT (0) FOR [CurrencyValue], CONSTRAINT [DF_TempBatchH_CurOutlayTot] DEFAULT (0) FOR [CurOutlayTot], CONSTRAINT [DF_TempBatchH_CurVATTot] DEFAULT (0) FOR [CurVATTot], CONSTRAINT [DF_TempBatchH_CurFeeTot] DEFAULT (0) FOR [CurFeeTot], CONSTRAINT [DF_TempBatchH_WriteBackHours] DEFAULT (0) FOR [WriteBackHours], CONSTRAINT [DF_TempBatchH_WriteBackValue] DEFAULT (0) FOR [WriteBackValue] GO ALTER TABLE [dbo].[TemplateActionDcouments] ADD CONSTRAINT [UQ__TemplateActionDc__7814D14C] UNIQUE NONCLUSTERED ( [ACTION], [DOCUMENT] ) ON [PRIMARY] , CONSTRAINT [UQ__TemplateActionDc__7908F585] UNIQUE NONCLUSTERED ( [DOCUMENT], [ACTION] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActionUDF] ADD CONSTRAINT [UQ__TemplateActionUD__79FD19BE] UNIQUE NONCLUSTERED ( [FILEPREFIX], [FIELDNAME], [ACTIONCODE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateActions] ADD CONSTRAINT [DF_TemplateActions_ChargeValue] DEFAULT (0) FOR [ChargeValue], CONSTRAINT [UQ__TemplateActions__7AF13DF7] UNIQUE NONCLUSTERED ( [ACTIONCODE] ) ON [PRIMARY] , CONSTRAINT [UQ__TemplateActions__7BE56230] UNIQUE NONCLUSTERED ( [WKTCODE], [ACTIONCODE] ) ON [PRIMARY] GO CREATE INDEX [KeyType] ON [dbo].[TemplateActions]([ACTTYPE], [ACTIONCODE]) ON [PRIMARY] GO CREATE INDEX [KeyStatus] ON [dbo].[TemplateActions]([STATUS], [ACTIONCODE]) ON [PRIMARY] GO CREATE INDEX [KeyMilestone] ON [dbo].[TemplateActions]([MILESTONETYPE], [ACTIONCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateDocumentUDF] ADD UNIQUE NONCLUSTERED ( [DUVDOCCODE], [DUVUVCODE] ) ON [PRIMARY] GO CREATE INDEX [UDD_KEYDOCUMENT] ON [dbo].[TemplateDocumentUDFs]([DOCUMENT], [UDFCODE]) ON [PRIMARY] GO CREATE INDEX [KeyDocument] ON [dbo].[TemplateDocumentUDFs]([DOCUMENT], [UDFCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateDocuments] ADD CONSTRAINT [UQ__TemplateDocument__2BFE89A6] UNIQUE NONCLUSTERED ( [TYPE], [CODE] ) ON [PRIMARY] GO CREATE INDEX [KeyClass] ON [dbo].[TemplateDocuments]([DOCCLASS], [CODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[TemplateNextActions] ADD CONSTRAINT [DF_TemplateNextActions_WHEN] DEFAULT (0) FOR [WHEN], CONSTRAINT [UQ__TemplateNextActi__7EC1CEDB] UNIQUE NONCLUSTERED ( [NEXTACTION], [ACTION] ) ON [PRIMARY] GO CREATE INDEX [KeyAction2] ON [dbo].[TemplateNextActions]([ACTION]) ON [PRIMARY] GO ALTER TABLE [dbo].[Templates] ADD CONSTRAINT [UQ__Templates__3AD6B8E2] UNIQUE NONCLUSTERED ( [WKTYPE], [WKCODE] ) ON [PRIMARY] GO CREATE INDEX [WOR_WKTACTION] ON [dbo].[Templates]([WKACTION], [WKTYPE], [WKCODE]) ON [PRIMARY] GO CREATE INDEX [WOR_WKTACT] ON [dbo].[Templates]([WKACTION]) ON [PRIMARY] GO CREATE INDEX [KeyDepartment] ON [dbo].[Templates]([Dept], [WKCODE]) ON [PRIMARY] GO ALTER TABLE [dbo].[TestTable] ADD CONSTRAINT [DF_TestTable_TestValue] DEFAULT (0) FOR [TestValue] GO ALTER TABLE [dbo].[TimeDayBook] ADD CONSTRAINT [DF_TimeDayBook_TIME] DEFAULT (0) FOR [TIME], CONSTRAINT [DF_TimeDayBook_RATE] DEFAULT (0) FOR [RATE], CONSTRAINT [DF_TimeDayBook_CHARGE] DEFAULT (0) FOR [CHARGE], CONSTRAINT [DF_TimeDayBook_TRACKREF] DEFAULT (0) FOR [TRACKREF] GO CREATE INDEX [KeyMatter] ON [dbo].[TimeDayBook]([MATTER], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyFeeEarn] ON [dbo].[TimeDayBook]([FEEEARN], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyTask] ON [dbo].[TimeDayBook]([TASK]) ON [PRIMARY] GO CREATE INDEX [KeyTeam] ON [dbo].[TimeDayBook]([TEAM]) ON [PRIMARY] GO CREATE INDEX [KeyTrackRef] ON [dbo].[TimeDayBook]([TRACKREF]) ON [PRIMARY] GO ALTER TABLE [dbo].[TimeEntry] ADD CONSTRAINT [DF_TimeEntry_TIME] DEFAULT (0) FOR [TIME], CONSTRAINT [DF_TimeEntry_RATE] DEFAULT (0) FOR [RATE], CONSTRAINT [DF_TimeEntry_CHARGE] DEFAULT (0) FOR [CHARGE], CONSTRAINT [DF_TimeEntry_BILLED] DEFAULT (0) FOR [BILLED], CONSTRAINT [DF_TimeEntry_DOCKET] DEFAULT (0) FOR [DOCKET], CONSTRAINT [DF_TimeEntry_TRACKREF] DEFAULT (0) FOR [TRACKREF], CONSTRAINT [DF_TimeEntry_SHOULDHAVE] DEFAULT (0) FOR [SHOULDHAVE] GO CREATE INDEX [KeyMatter] ON [dbo].[TimeEntry]([MATTER], [DATE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyFeeEarn] ON [dbo].[TimeEntry]([FEEEARN], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeeFeeMater] ON [dbo].[TimeEntry]([FEEEARN], [MATTER], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyTask] ON [dbo].[TimeEntry]([TASK]) ON [PRIMARY] GO CREATE INDEX [KeyNCCCode] ON [dbo].[TimeEntry]([NCCODE], [FEEEARN], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyTeam] ON [dbo].[TimeEntry]([TEAM], [MATTER], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyTrackRef] ON [dbo].[TimeEntry]([TRACKREF], [DATE]) ON [PRIMARY] GO CREATE INDEX [KeyInvoiceNo] ON [dbo].[TimeEntry]([INVOICENO]) ON [PRIMARY] GO CREATE INDEX [KeyPeriod] ON [dbo].[TimeEntry]([MATTER], [PERIOD], [YEAR]) ON [PRIMARY] GO ALTER TABLE [dbo].[TransferList] ADD CONSTRAINT [DF_TransferList_ORIGVALUE] DEFAULT (0) FOR [ORIGVALUE], CONSTRAINT [DF_TransferList_ORIGFEES] DEFAULT (0) FOR [ORIGFEES], CONSTRAINT [DF_TransferList_ORIGVAT] DEFAULT (0) FOR [ORIGVAT], CONSTRAINT [DF_TransferList_ORIGOUTLAY] DEFAULT (0) FOR [ORIGOUTLAY], CONSTRAINT [DF_TransferList_OSVALUE] DEFAULT (0) FOR [OSVALUE], CONSTRAINT [DF_TransferList_OSFEES] DEFAULT (0) FOR [OSFEES], CONSTRAINT [DF_TransferList_OSVAT] DEFAULT (0) FOR [OSVAT], CONSTRAINT [DF_TransferList_OSOUTLAY] DEFAULT (0) FOR [OSOUTLAY], CONSTRAINT [DF_TransferList_TRANSFERVALUE] DEFAULT (0) FOR [TRANSFERVALUE] GO CREATE INDEX [KeyMatter] ON [dbo].[TransferList]([MATTER], [BATCHNO], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[UDFDefinition] ADD UNIQUE NONCLUSTERED ( [UVCODE] ) ON [PRIMARY] GO CREATE INDEX [USE_KEY_UVSHORTCODE] ON [dbo].[UDFDefinition]([UVSHORTCODE]) ON [PRIMARY] GO CREATE INDEX [UDW_UDVWCODE] ON [dbo].[UDFTemplatesWorkTypes]([UDUVCODE]) ON [PRIMARY] GO CREATE INDEX [UDW_KEY_UDWKCODE] ON [dbo].[UDFTemplatesWorkTypes]([UDWKCODE], [UDUVCODE]) ON [PRIMARY] GO CREATE INDEX [UDW_UDWKSEQ] ON [dbo].[UDFTemplatesWorkTypes]([UDWKCODE], [UDSEQ]) ON [PRIMARY] GO ALTER TABLE [dbo].[Undertakings] ADD CONSTRAINT [DF_Undertakings_VALUE] DEFAULT (0) FOR [VALUE] GO CREATE INDEX [KeyMatter] ON [dbo].[Undertakings]([MATTER], [SEQ], [DATE]) ON [PRIMARY] GO ALTER TABLE [dbo].[VATCodes] ADD CONSTRAINT [DF_VATCodes_RATE] DEFAULT (0) FOR [RATE], CONSTRAINT [DF_VATCodes_INVOICESNET] DEFAULT (0) FOR [INVOICESNET], CONSTRAINT [DF_VATCodes_INVOICESVAT] DEFAULT (0) FOR [INVOICESVAT], CONSTRAINT [DF_VATCodes_BILLSNET] DEFAULT (0) FOR [BILLSNET], CONSTRAINT [DF_VATCodes_BILLSVAT] DEFAULT (0) FOR [BILLSVAT], CONSTRAINT [DF_VATCodes_RECEIPTSNET] DEFAULT (0) FOR [RECEIPTSNET], CONSTRAINT [DF_VATCodes_RECEIPTSVAT] DEFAULT (0) FOR [RECEIPTSVAT], CONSTRAINT [DF_VATCodes_PAYMENTSNET] DEFAULT (0) FOR [PAYMENTSNET], CONSTRAINT [DF_VATCodes_PAYMENTSVAT] DEFAULT (0) FOR [PAYMENTSVAT], CONSTRAINT [DF_VATCodes_JOURNALSNET] DEFAULT (0) FOR [JOURNALSNET], CONSTRAINT [DF_VATCodes_JOURNALSVAT] DEFAULT (0) FOR [JOURNALSVAT] GO ALTER TABLE [dbo].[VATReportExtract] ADD CONSTRAINT [DF_VATReportExtract_VALUE] DEFAULT (0) FOR [VALUE], CONSTRAINT [DF_VATReportExtract_VATVAL] DEFAULT (0) FOR [VATVAL], CONSTRAINT [DF_VATReportExtract_UNALLOC] DEFAULT (0) FOR [UNALLOC] GO CREATE INDEX [BDNo] ON [dbo].[VATReportExtract]([BATCHNO], [PREF]) ON [PRIMARY] GO CREATE INDEX [VATKey] ON [dbo].[VATReportExtract]([YEAR], [PERNO], [TYPE], [VATCODE], [DATE]) ON [PRIMARY] GO ALTER TABLE [dbo].[WebAssociates] ADD CONSTRAINT [DF_WebAssociates_AssociateOrder] DEFAULT (0) FOR [AssociateOrder], CONSTRAINT [DF_WebAssociates_PopupSelection] DEFAULT ('N') FOR [PopupSelection], CONSTRAINT [DF_WebAssociates_AllowMultiples] DEFAULT (1) FOR [AllowMultiples], CONSTRAINT [DF_WebAssociates_DefaultMultiples] DEFAULT (1) FOR [DefaultMultiples] GO ALTER TABLE [dbo].[WebFields] ADD CONSTRAINT [DF_WebFields_FieldOrder] DEFAULT (0) FOR [FieldOrder], CONSTRAINT [DF_WebFields_Required] DEFAULT ('N') FOR [Required] GO ALTER TABLE [dbo].[WebForms] ADD CONSTRAINT [DF_WebFroms_Department] DEFAULT (' ') FOR [Department], CONSTRAINT [DF_WebFroms_WorkType] DEFAULT (' ') FOR [WorkType] GO ALTER TABLE [dbo].[Wills] ADD CONSTRAINT [DF_Wills_ESTIMATEESTATE] DEFAULT (0) FOR [ESTIMATEESTATE] GO CREATE INDEX [KeyContact] ON [dbo].[Wills]([CONTACT], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyExecKey] ON [dbo].[Wills]([EXECKEY]) ON [PRIMARY] GO CREATE INDEX [KeyLocation] ON [dbo].[Wills]([LOCATION], [RECORDID]) ON [PRIMARY] GO ALTER TABLE [dbo].[WorkInProgressReport] ADD CONSTRAINT [DF_WorkInProgressReport_WIPHRS] DEFAULT (0) FOR [WIPHRS], CONSTRAINT [DF_WorkInProgressReport_WIPVALUE] DEFAULT (0) FOR [WIPVALUE], CONSTRAINT [DF_WorkInProgressReport_BILLTOTAL] DEFAULT (0) FOR [BILLTOTAL], CONSTRAINT [DF_WorkInProgressReport_BILLFEES] DEFAULT (0) FOR [BILLFEES], CONSTRAINT [DF_WorkInProgressReport_BILLTIMEVAL] DEFAULT (0) FOR [BILLTIMEVAL] GO CREATE INDEX [KEYMATTER] ON [dbo].[WorkInProgressReport]([MATTER], [FECODE], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyFEMatter] ON [dbo].[WorkInProgressReport]([FECODE], [MATTER], [RECORDID]) ON [PRIMARY] GO CREATE INDEX [KeyContact] ON [dbo].[children]([CONTACT]) ON [PRIMARY] GO CREATE INDEX [COH_KEYCONTACT] ON [dbo].[contacthistory]([CONTACT], [DATE]) ON [PRIMARY] GO ALTER TABLE [dbo].[control] ADD CONSTRAINT [DF_control_EICONVERT] DEFAULT (0) FOR [EICONVERT], CONSTRAINT [DF_control_IECONVERT] DEFAULT (0) FOR [IECONVERT], CONSTRAINT [DF_control_THIRDPARTYLIMIT] DEFAULT (0) FOR [THIRDPARTYLIMIT], CONSTRAINT [DF_control_MAXNUMBEROFMATTERS] DEFAULT (0) FOR [MAXNUMBEROFMATTERS], CONSTRAINT [DF_control_OUTLAYBUDGET] DEFAULT (0) FOR [OUTLAYBUDGET], CONSTRAINT [DF_control_LASTRECCLDIFF] DEFAULT (0) FOR [LASTRECCLDIFF], CONSTRAINT [DF_control_LASTRECOLDIFF] DEFAULT (0) FOR [LASTRECOLDIFF], CONSTRAINT [DF_control_LASTRECDRDIFF] DEFAULT (0) FOR [LASTRECDRDIFF], CONSTRAINT [DF_control_LASTRECSUDIFF] DEFAULT (0) FOR [LASTRECSUDIFF], CONSTRAINT [DF_control_LASTRECCLBKDIFF] DEFAULT (0) FOR [LASTRECCLBKDIFF], CONSTRAINT [UQ__control__0B7CAB7B] UNIQUE NONCLUSTERED ( [NEXT_DOC_NO] ) ON [PRIMARY] GO ALTER TABLE [dbo].[csaccounts] ADD CONSTRAINT [DF_csaccounts_ACTRNAMT] DEFAULT (0) FOR [ACTRNAMT], CONSTRAINT [DF_csaccounts_ACTRNVAT] DEFAULT (0) FOR [ACTRNVAT] GO CREATE INDEX [KeyContact] ON [dbo].[deeds]([CONTACT]) ON [PRIMARY] GO CREATE INDEX [KeyLocation] ON [dbo].[deeds]([LOCATION]) ON [PRIMARY] GO ALTER TABLE [dbo].[diary] ADD CONSTRAINT [DF_diary_DELEGATIONSTATUS] DEFAULT (0) FOR [DELEGATIONSTATUS], CONSTRAINT [DF_diary_TxmSent] DEFAULT (0) FOR [TxmSent] GO CREATE INDEX [KeyAction] ON [dbo].[diary]([ACTIONCODE], [CASECODE], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyCase] ON [dbo].[diary]([CASECODE], [DATE], [ACTIONCODE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyCaseDes] ON [dbo].[diary]([CASECODE], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyCaseStatus] ON [dbo].[diary]([CASECODE], [STATUS], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE UNIQUE INDEX [KeyCaseStatusTime] ON [dbo].[diary]([CASECODE], [STATUS], [DATE] DESC , [DYSTARTTIME] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyFeEarner] ON [dbo].[diary]([FNCODE], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyFeProcess] ON [dbo].[diary]([FNCODE], [PROCESSSTATUS], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyFeStatus] ON [dbo].[diary]([FNCODE], [STATUS], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyFnCase] ON [dbo].[diary]([FNCODE], [STATUS], [CASECODE], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyHighLighted] ON [dbo].[diary]([CASECODE], [HIGHLIGHTED], [STATUS], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyOrginalId] ON [dbo].[diary]([ORGINALACTIONID], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyProcess] ON [dbo].[diary]([CASECODE], [PROCESSSTATUS], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyStatus] ON [dbo].[diary]([CASECODE], [STATUS], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyTeam] ON [dbo].[diary]([TEAMCODE], [STATUS], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO CREATE INDEX [KeyTeamCase] ON [dbo].[diary]([TEAMCODE], [STATUS], [CASECODE], [DATE], [ACTIONID]) ON [PRIMARY] GO CREATE INDEX [KeyTypeCase] ON [dbo].[diary]([ACTIONTYPE], [DATE] DESC , [ACTIONID] DESC ) ON [PRIMARY] GO ALTER TABLE [dbo].[diarytemp] ADD CONSTRAINT [DF_diarytemp_ORGINALACTIONID] DEFAULT (0) FOR [ORGINALACTIONID], CONSTRAINT [DF_diarytemp_DELEGATIONSTATUS] DEFAULT (0) FOR [DELEGATIONSTATUS] GO CREATE INDEX [OPE_KEY] ON [dbo].[dssw21]([OPE_SURNAME], [OPE_FIRSTNAME]) ON [PRIMARY] GO CREATE INDEX [LOG_KEY] ON [dbo].[dssw24]([LOG_DATE], [LOG_TIME]) ON [PRIMARY] GO ALTER TABLE [dbo].[matters] ADD CONSTRAINT [DF_matters_EstFee] DEFAULT (0) FOR [EstFee], CONSTRAINT [DF_matters_OutlayBud] DEFAULT (0) FOR [OutlayBud], CONSTRAINT [DF_matters_DebtBal] DEFAULT (0) FOR [DebtBal], CONSTRAINT [DF_matters_OutlayBal] DEFAULT (0) FOR [OutlayBal], CONSTRAINT [DF_matters_ClientBal] DEFAULT (0) FOR [ClientBal], CONSTRAINT [DF_matters_ClientCurBal] DEFAULT (0) FOR [ClientCurBal], CONSTRAINT [DF_matters_ClientDepBal] DEFAULT (0) FOR [ClientDepBal], CONSTRAINT [DF_matters_DebtBalFwd] DEFAULT (0) FOR [DebtBalFwd], CONSTRAINT [DF_matters_OutlayBalFwd] DEFAULT (0) FOR [OutlayBalFwd], CONSTRAINT [DF_matters_ClientBalFwd] DEFAULT (0) FOR [ClientBalFwd], CONSTRAINT [DF_matters_ClientCurBalFwd] DEFAULT (0) FOR [ClientCurBalFwd], CONSTRAINT [DF_matters_ClientDepBalFwd] DEFAULT (0) FOR [ClientDepBalFwd], CONSTRAINT [DF_matters_PendingBal] DEFAULT (0) FOR [PendingBal], CONSTRAINT [DF_matters_ClientMin] DEFAULT (0) FOR [ClientMin], CONSTRAINT [DF_matters_FNL_Fees] DEFAULT (0) FOR [FNL_Fees], CONSTRAINT [DF_matters_FNL_Outlay] DEFAULT (0) FOR [FNL_Outlay], CONSTRAINT [DF_matters_FNL_VAT] DEFAULT (0) FOR [FNL_VAT], CONSTRAINT [DF_matters_FNL_Total] DEFAULT (0) FOR [FNL_Total], CONSTRAINT [DF_matters_TimeBal] DEFAULT (0) FOR [TimeBal], CONSTRAINT [DF_matters_ChargeBal] DEFAULT (0) FOR [ChargeBal], CONSTRAINT [DF_matters_CurDebtBal] DEFAULT (0) FOR [CurDebtBal], CONSTRAINT [DF_matters_CurOutlayBal] DEFAULT (0) FOR [CurOutlayBal], CONSTRAINT [DF_matters_CurClientBal] DEFAULT (0) FOR [CurClientBal], CONSTRAINT [DF_matters_CurClientCBal] DEFAULT (0) FOR [CurClientCBal], CONSTRAINT [DF_matters_CurClientDBal] DEFAULT (0) FOR [CurClientDBal], CONSTRAINT [DF_matters_CurDebtBalFwd] DEFAULT (0) FOR [CurDebtBalFwd], CONSTRAINT [DF_matters_CurOutlayBalFwd] DEFAULT (0) FOR [CurOutlayBalFwd], CONSTRAINT [DF_matters_CurClientBalFwd] DEFAULT (0) FOR [CurClientBalFwd], CONSTRAINT [DF_matters_CurClientCBalFwd] DEFAULT (0) FOR [CurClientCBalFwd], CONSTRAINT [DF_matters_CurClientDBalFwd] DEFAULT (0) FOR [CurClientDBalFwd], CONSTRAINT [DF_matters_CurPendingBal] DEFAULT (0) FOR [CurPendingBal], CONSTRAINT [DF_matters_Unallocated] DEFAULT (0) FOR [Unallocated], CONSTRAINT [DF_matters_CompOutlayLimit] DEFAULT (0) FOR [CompOutlayLimit], CONSTRAINT [DF_matters_CompFeesLimit] DEFAULT (0) FOR [CompFeesLimit], CONSTRAINT [DF_matters_CompTotalLimit] DEFAULT (0) FOR [CompTotalLimit], CONSTRAINT [DF_matters_OriginalDebt] DEFAULT (0) FOR [OriginalDebt], CONSTRAINT [DF_matters_DebtCollected] DEFAULT (0) FOR [DebtCollected], CONSTRAINT [DF_matters_RecoverableCosts] DEFAULT (0) FOR [RecoverableCosts], CONSTRAINT [DF_matters_DebtInterest] DEFAULT (0) FOR [DebtInterest], CONSTRAINT [DF_matters_CollectingBalance] DEFAULT (0) FOR [CollectingBalance] GO CREATE INDEX [KeyBranch] ON [dbo].[matters]([Branch], [Code]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyOldMatter] ON [dbo].[matters]([OldRef]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyClientMatter] ON [dbo].[matters]([ClientCode], [Code]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyFee] ON [dbo].[matters]([FECode], [Code]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyDept] ON [dbo].[matters]([Dept], [Code]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyWorkType] ON [dbo].[matters]([WType], [Code]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyMatterInprogress] ON [dbo].[matters]([PCODE]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyFePCode] ON [dbo].[matters]([PFECODE]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyFileNumber] ON [dbo].[matters]([FileNum]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyUser1] ON [dbo].[matters]([User1]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyUser2] ON [dbo].[matters]([User2]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyUser3] ON [dbo].[matters]([User3]) WITH FILLFACTOR = 70 ON [PRIMARY] GO CREATE INDEX [KeyFileColor] ON [dbo].[matters]([FileColour]) WITH FILLFACTOR = 70 ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.CaseDocuments AS SELECT dbo.diary.CASECODE AS MatterCode, dbo.DiaryAttachments.NAME AS DocumentName, dbo.DiaryAttachments.DOCUMENT, dbo.DiaryAttachments.FILEPATH, dbo.DiaryAttachments.TYPE, dbo.DiaryAttachments.DOCCLASS, dbo.DiaryAttachments.DATEENTERED, dbo.DiaryAttachments.ENTEREDBY, dbo.DiaryAttachments.LASTACCESSDATE, dbo.DiaryAttachments.LASTACCESSBY, dbo.DiaryAttachments.SYSTEM, dbo.DiaryAttachments.DICTATIONFILE, dbo.DiaryAttachments.TRACKREFERENCE, dbo.DiaryAttachments.DIARYID, dbo.diary.FNCODE AS ActionFe, dbo.diary.ACTIONCODE, dbo.diary.ACTIONSTATUS, dbo.diary.STATUS, dbo.diary.[DATE] AS DiaryDate, dbo.diary.ACTIONTYPE, dbo.diary.TEAMCODE, dbo.diary.PUBLISH, dbo.diary.PRIORITY, dbo.diary.ADDRESSTO, dbo.diary.CCTo, dbo.diary.BCCTo, dbo.diary.EMAIL, dbo.diary.SUBJECT FROM dbo.diary RIGHT OUTER JOIN dbo.DiaryAttachments ON dbo.diary.ACTIONID = dbo.DiaryAttachments.DIARYID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.EmailAddressHistory AS SELECT TOP 100 PERCENT CASECODE, ACTIONID, EMAILADDRESS, ADDRESSTO FROM dbo.diary WHERE (ADDRESSTO LIKE '%@%') OR (EMAILADDRESS LIKE '%@%') ORDER BY CASECODE, ACTIONID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.AllocatedBillHeadDetails AS SELECT dbo.Allocations.ABATCHNO, dbo.Suppliers.CODE, dbo.Suppliers.NAME, dbo.Suppliers.ADDRESS, dbo.BatchH.PREF, dbo.BatchH.DATE, dbo.BatchH.REF, dbo.BatchH.NARR, dbo.BatchH.VALUE FROM dbo.Suppliers INNER JOIN dbo.SupplierLedger ON dbo.Suppliers.CODE = dbo.SupplierLedger.SUPP INNER JOIN dbo.Allocations ON dbo.SupplierLedger.BATCHNO = dbo.Allocations.ABATCHNO INNER JOIN dbo.BatchH ON dbo.SupplierLedger.BATCHNO = dbo.BatchH.BATCHNO GROUP BY dbo.Allocations.ABATCHNO, dbo.Suppliers.CODE, dbo.Suppliers.NAME, dbo.Suppliers.ADDRESS, dbo.SupplierLedger.TYPE, dbo.BatchH.PREF, dbo.BatchH.DATE, dbo.BatchH.REF, dbo.BatchH.NARR, dbo.BatchH.VALUE HAVING (dbo.SupplierLedger.TYPE = 'P') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.AllocatedBills AS SELECT dbo.BatchH.BATCHNO, dbo.BatchH.PREF, dbo.BatchH.REF, dbo.BatchH.DATE, dbo.BatchH.NARR, dbo.BatchH.VALUE, dbo.BatchH.VATTOT FROM dbo.Allocations INNER JOIN dbo.BatchH ON dbo.Allocations.BATCHNO = dbo.BatchH.BATCHNO AND dbo.Allocations.PREF = dbo.BatchH.PREF GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.AssociateCategoryView AS SELECT dbo.CaseAssoicatesTypes.NAMECODE, dbo.CaseAssoicatesTypes.TYPECODE, dbo.CaseAssoicatesTypes.SEARCHCODE, dbo.AssociateTypes.DESCRIPTION AS Category FROM dbo.CaseAssoicatesTypes INNER JOIN dbo.AssociateTypes ON dbo.CaseAssoicatesTypes.TYPECODE = dbo.AssociateTypes.CODE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /********************************************************************** * * Recreate Views * **********************************************************************/ Create View [dbo].[CaseDocsBriefsView] AS select DA.[CaseCode] As MatterCode, DA.[TrackReference], BR.[ID] AS BriefID, case when bd.[recordid] is null then 0 else 1 end as DocInBrief, DA.[Type], DA.[DateEntered], DA.[Document], DA.[Source], DA.[LastAccessDate], DA.[EnteredBy], DA.[LastAccessBy], DA.[Name], DA.[FilePath], DA.[DiaryID], DA.[DocClass] from [dbo].[DiaryAttachments] DA INNER JOIN [dbo].[Brief] BR ON BR.[MatterCode] = DA.[CaseCode] INNER JOIN [dbo].[BriefDocuments] BD ON BD.[BriefID] = BR.[ID] AND BD.[TrackReference] = DA.[TrackReference] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.ClientDiary AS SELECT LEFT(CASECODE, 6) AS ClientCode, CASECODE, [DATE], STATUS, ACTIONCODE, ACTIONSTATUS, ACTIONTYPE, PROCESSTYPE, FNCODE, TEAMCODE, TEXT1, TEXT2, DELEGATEDFNR, DELEGATEDDATE, DELEGATEDBACKDATE, [DEFERRED], DUEDATE, IMAGENO, PUBLISH, DYSTARTTIME, DYENDTIME, DURATION, ACTIONID, ORGINALACTIONID, PRIORITY, HIGHLIGHTED, MILESTEONETYPE, ATTACHMENTS, PROCESSSTATUS, WORKPROCESS, BILLABLE, BILLDESCRIPTION, EMAILADDRESS, ADDRESSTO, EMAIL, SUBJECT, DELEGATIONSTATUS, DRAFTBILLNO, CHEQUEREQNO, TxmSent, Location, HearingType, ForCopy FROM dbo.diarytemp GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.CurrentStages AS SELECT TOP 100 PERCENT CASECODE, DATE, STATUS, ACTIONCODE, ACTIONSTATUS, TxmSent, TxmDate, TxmSeqNo, LEFT(CASECODE, 6) AS Expr1, ACTIONID FROM dbo.diary WHERE (TxmSent = 0) AND (STATUS = 0) AND (ACTIONSTATUS = '10' OR ACTIONSTATUS = '13' OR ACTIONSTATUS = '16' OR ACTIONSTATUS = '19' OR ACTIONSTATUS = '22' OR ACTIONSTATUS = '25' OR ACTIONSTATUS = '28' OR ACTIONSTATUS = '31' OR ACTIONSTATUS = '32' OR ACTIONSTATUS = '34' OR ACTIONSTATUS = '37' OR ACTIONSTATUS = '43' OR ACTIONSTATUS = '44' OR ACTIONSTATUS = '45' OR ACTIONSTATUS = '46' OR ACTIONSTATUS = '47' OR ACTIONSTATUS = '49' OR ACTIONSTATUS = '50' OR ACTIONSTATUS = '52' OR ACTIONSTATUS = '54' OR ACTIONSTATUS = '55' OR ACTIONSTATUS = '58' OR ACTIONSTATUS = '59' OR ACTIONSTATUS = '61' OR ACTIONSTATUS = '64' OR ACTIONSTATUS = '65' OR ACTIONSTATUS = '66' OR ACTIONSTATUS = '67' OR ACTIONSTATUS = '68' OR ACTIONSTATUS = '69' OR ACTIONSTATUS = '71' OR ACTIONSTATUS = '73' OR ACTIONSTATUS = '74' OR ACTIONSTATUS = '99') AND (LEFT(CASECODE, 6) = 'XXXXXX') ORDER BY CASECODE, DATE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.FeeAllocated AS SELECT BatchH_1.BATCHNO AS ReceiptBatchNo, BatchH_1.TYPE, dbo.Allocations.ABATCHNO AS InvoiceBatchNo, BatchH_1.TYPE AS Expr3, dbo.Allocations.FEES AS FeesAllocated, BatchH_1.MATTER AS Mattercode, dbo.matters.FECode, BatchH_1.[YEAR] AS ReceiptYear, BatchH_1.PERNO AS ReceiptPeriod, dbo.Allocations.[VALUE] AS TotalReceipt FROM dbo.matters INNER JOIN dbo.BatchH BatchH_1 ON dbo.matters.Code = BatchH_1.MATTER RIGHT OUTER JOIN dbo.Allocations INNER JOIN dbo.BatchH BatchH_2 ON dbo.Allocations.BATCHNO = BatchH_2.BATCHNO ON BatchH_1.BATCHNO = dbo.Allocations.ABATCHNO WHERE (BatchH_1.TYPE = 'R') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.HandlersStats AS SELECT dbo.Handlers.CODE AS SolicitorCode, dbo.Handlers.NAME AS Solicitor, Handlers_1.NAME AS TeamName, dbo.Departments.[DESC] AS Department, ISNULL ((SELECT SUM(TIME) AS TotalRecordedTime FROM dbo.TimeEntry WHERE (DATE >= (SELECT FromDate FROM dbo.KPIParameters)) AND (DATE <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_1)) AND (FEEEARN = dbo.Handlers.CODE) AND (TASK <> 'BILLED') AND (TASK <> 'CREDIT') AND (TASK <> 'WRI') AND (MATTER <> '~')), 0) AS TimeRecorded, ISNULL ((SELECT ChargableTimeBudget FROM dbo.HandlerBudgets AS HandlerBudgets_1 WHERE (Handler = dbo.Handlers.CODE) AND (Month = (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (Year = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_1))), 0) AS TimeWeeklyBudget, ISNULL ((SELECT SUM(TIME) AS TotalRecordedTime FROM dbo.TimeEntry AS TimeEntry_1 WHERE (DATE >= (SELECT StartOfYear FROM dbo.KPIParameters AS KPIParameters_2)) AND (DATE <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_1)) AND (FEEEARN = dbo.Handlers.CODE) AND (TASK <> 'BILLED') AND (TASK <> 'CREDIT') AND (TASK <> 'WRI')), 0) AS TimeRecordedYTD, ISNULL ((SELECT SUM(dbo.BatchDetails.VALUE) AS Expr1 FROM dbo.BatchDetails INNER JOIN dbo.BatchH ON dbo.BatchDetails.BATCHNO = dbo.BatchH.BATCHNO WHERE (dbo.BatchDetails.FEE = dbo.Handlers.CODE) AND (dbo.BatchDetails.TYPE = 'I') AND (dbo.BatchDetails.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (dbo.BatchDetails.PERNO = (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (dbo.BatchDetails.OUTLAY = 'F') AND (dbo.BatchH.INVCR = 'I')), 0) - ISNULL ((SELECT SUM(BatchDetails_1.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_1 INNER JOIN dbo.BatchH AS BatchH_1 ON BatchDetails_1.BATCHNO = BatchH_1.BATCHNO WHERE (BatchDetails_1.FEE = dbo.Handlers.CODE) AND (BatchDetails_1.TYPE = 'I') AND (BatchDetails_1.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_1.PERNO = (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_1.OUTLAY = 'F') AND (BatchH_1.INVCR = 'C')), 0) AS FeesCurrnetPeriod, ISNULL ((SELECT FeesBudget FROM dbo.HandlerBudgets AS HandlerBudgets_1 WHERE (Handler = dbo.Handlers.CODE) AND (Month = (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (Year = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_1))), 0) AS FeesCurrnetBudget, ISNULL ((SELECT SUM(BatchDetails_4.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_4 INNER JOIN dbo.BatchH AS BatchH_4 ON BatchDetails_4.BATCHNO = BatchH_4.BATCHNO WHERE (BatchDetails_4.FEE = dbo.Handlers.CODE) AND (BatchDetails_4.TYPE = 'I') AND (BatchDetails_4.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_4.PERNO = (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1) - 1) AND (BatchDetails_4.OUTLAY = 'F') AND (BatchH_4.INVCR = 'I')), 0) - ISNULL ((SELECT SUM(BatchDetails_1.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_1 INNER JOIN dbo.BatchH AS BatchH_1 ON BatchDetails_1.BATCHNO = BatchH_1.BATCHNO WHERE (BatchDetails_1.FEE = dbo.Handlers.CODE) AND (BatchDetails_1.TYPE = 'I') AND (BatchDetails_1.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_1.PERNO = (SELECT Period - 1 AS Expr1 FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_1.OUTLAY = 'F') AND (BatchH_1.INVCR = 'C')), 0) AS FeesLastPeriod, ISNULL ((SELECT FeesBudget FROM dbo.HandlerBudgets AS HandlersBudgets_2 WHERE (Handler = dbo.Handlers.CODE) AND (Month = (SELECT Period - 1 AS Expr1 FROM dbo.KPIParameters AS KPIParameters_1)) AND (Year = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_1))), 0) AS FeesLastPeriodBudget, ISNULL ((SELECT SUM(BatchDetails_2.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_2 INNER JOIN dbo.BatchH AS BatchH_2 ON BatchDetails_2.BATCHNO = BatchH_2.BATCHNO WHERE (BatchDetails_2.FEE = dbo.Handlers.CODE) AND (BatchDetails_2.TYPE = 'I') AND (BatchDetails_2.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_2.PERNO <= (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_2.OUTLAY = 'F') AND (BatchH_2.INVCR = 'I')), 0) - ISNULL ((SELECT SUM(BatchDetails_3.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_3 INNER JOIN dbo.BatchH AS BatchH_3 ON BatchDetails_3.BATCHNO = BatchH_3.BATCHNO WHERE (BatchDetails_3.FEE = dbo.Handlers.CODE) AND (BatchDetails_3.TYPE = 'I') AND (BatchDetails_3.YEAR = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_3.PERNO <= (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_3.OUTLAY = 'F') AND (BatchH_3.INVCR = 'C')), 0) AS FeeYTD, ISNULL ((SELECT SUM(BatchDetails_4.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_4 INNER JOIN dbo.BatchH AS BatchH_4 ON BatchDetails_4.BATCHNO = BatchH_4.BATCHNO WHERE (BatchDetails_4.FEE = dbo.Handlers.CODE) AND (BatchDetails_4.TYPE = 'I') AND (BatchDetails_4.YEAR = (SELECT Year - 1 AS Expr1 FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_4.PERNO <= (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_4.OUTLAY = 'F') AND (BatchH_4.INVCR = 'I')), 0) - ISNULL ((SELECT SUM(BatchDetails_1.VALUE) AS Expr1 FROM dbo.BatchDetails AS BatchDetails_1 INNER JOIN dbo.BatchH AS BatchH_1 ON BatchDetails_1.BATCHNO = BatchH_1.BATCHNO WHERE (BatchDetails_1.FEE = dbo.Handlers.CODE) AND (BatchDetails_1.TYPE = 'I') AND (BatchDetails_1.YEAR = (SELECT Year - 1 AS Expr1 FROM dbo.KPIParameters AS KPIParameters_3)) AND (BatchDetails_1.PERNO <= (SELECT Period AS Expr1 FROM dbo.KPIParameters AS KPIParameters_1)) AND (BatchDetails_1.OUTLAY = 'F') AND (BatchH_1.INVCR = 'C')), 0) AS FeesYTDLastYear, ISNULL ((SELECT SUM(FeesBudget) AS Expr1 FROM dbo.HandlerBudgets AS HandlersBudgets_1 WHERE (Handler = dbo.Handlers.CODE) AND (Month <= (SELECT Period FROM dbo.KPIParameters AS KPIParameters_1)) AND (Year = (SELECT Year FROM dbo.KPIParameters AS KPIParameters_1))), 0) AS FeesYTDBudget, ISNULL ((SELECT SUM(dbo.DebtorsLedger.OSVALUE) AS Expr1 FROM dbo.DebtorsLedger INNER JOIN dbo.matters ON dbo.DebtorsLedger.MATTER = dbo.matters.Code WHERE (dbo.matters.FECode = dbo.Handlers.CODE) AND (dbo.DebtorsLedger.DATE <= { fn NOW() } - 60) AND (dbo.DebtorsLedger.OSVALUE <> 0)), 0) AS OSInvoicesOver60, ISNULL ((SELECT SUM(DebtorsLedger_1.OSVALUE) AS Expr1 FROM dbo.DebtorsLedger AS DebtorsLedger_1 INNER JOIN dbo.matters AS matters_1 ON DebtorsLedger_1.MATTER = matters_1.Code WHERE (matters_1.FECode = dbo.Handlers.CODE) AND (DebtorsLedger_1.OSVALUE <> 0)), 0) AS OSInvoices, ISNULL ((SELECT SUM(DebtorsLedger_2.OSFEES) AS Expr1 FROM dbo.DebtorsLedger AS DebtorsLedger_2 INNER JOIN dbo.matters AS matters_2 ON DebtorsLedger_2.MATTER = matters_2.Code WHERE (matters_2.FECode = dbo.Handlers.CODE) AND (DebtorsLedger_2.DATE <= { fn NOW() } - 60) AND (DebtorsLedger_2.OSVALUE <> 0)), 0) AS OSFeesOver60, ISNULL ((SELECT SUM(DebtorsLedger_1.OSFEES) AS Expr1 FROM dbo.DebtorsLedger AS DebtorsLedger_1 INNER JOIN dbo.matters AS matters_1 ON DebtorsLedger_1.MATTER = matters_1.Code WHERE (matters_1.FECode = dbo.Handlers.CODE) AND (DebtorsLedger_1.OSVALUE <> 0)), 0) AS OSFees, 000 AS UnBilledOutlay, ISNULL ((SELECT SUM(dbo.BillHeader.TOTAL) AS Expr1 FROM dbo.BillHeader INNER JOIN dbo.matters AS matters_5 ON dbo.BillHeader.MATTER = matters_5.Code WHERE (matters_5.FECode = dbo.Handlers.CODE) AND (dbo.BillHeader.BILLNO = 0)), 0) AS DraftInvoice, ISNULL ((SELECT COUNT(DelType) AS Expr1 FROM dbo.DiaryDelegations WHERE (STATUS = 0) AND (DelType IN ('Created', 'Delegated', 'Released')) AND (HANDLER = dbo.Handlers.CODE)), 0) AS NoDiaryDelOS, ISNULL ((SELECT COUNT(DelType) AS Expr1 FROM dbo.DiaryDelegations AS DiaryDelegations_1 WHERE (STATUS = 0) AND (DelType IN ('Created', 'Delegated', 'Released')) AND (HANDLER = dbo.Handlers.CODE) AND (DUEDATE <= { fn NOW() })), 0) AS NoDiaryDelOSOverdue, ISNULL ((SELECT COUNT(a.DelType) AS Expr1 FROM dbo.DiaryDelegations AS a INNER JOIN dbo.diary AS b ON a.ACTIONID = b.ACTIONID WHERE (a.STATUS = 1) AND (a.DelType = 'Completed') AND (a.HANDLER = dbo.Handlers.CODE)), 0) AS NoDiaryDelComp, ISNULL ((SELECT COUNT(a.DelType) AS Expr1 FROM dbo.DiaryDelegations AS a INNER JOIN dbo.diary AS b ON a.ACTIONID = b.ACTIONID WHERE (a.STATUS = 0) AND (b.PRIORITY = 'H') AND (a.HANDLER = dbo.Handlers.CODE)), 0) AS NoDiaryDelOSHighPriority, ISNULL ((SELECT COUNT(a.MATTER) AS Expr1 FROM dbo.Undertakings AS a INNER JOIN dbo.matters AS b ON a.MATTER = b.Code WHERE (b.FECode = dbo.Handlers.CODE) AND (a.DISCHARGEDATE <> 0)), 0) AS NoUndertakings, ISNULL ((SELECT COUNT(a.MATTER) AS Expr1 FROM dbo.Undertakings AS a INNER JOIN dbo.matters AS b ON a.MATTER = b.Code WHERE (b.FECode = dbo.Handlers.CODE) AND (a.DISCHARGEDATE <> 0) AND (a.DATE <= { fn NOW() } + 30)), 0) AS NoUndertakingsWithin30, ISNULL ((SELECT COUNT(Code) AS Expr1 FROM dbo.matters AS matters_3 WHERE (FECode = dbo.Handlers.CODE)), 0) AS NoActiveMatters, ISNULL ((SELECT COUNT(Code) AS Expr1 FROM dbo.matters AS matters_4 WHERE (FECode = dbo.Handlers.CODE) AND (Started >= (SELECT FromDate FROM dbo.KPIParameters AS KPIParameters_5)) AND (Started <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_4))) + (SELECT COUNT(CODE) AS Expr1 FROM dbo.Closed WHERE (FECODE = dbo.Handlers.CODE) AND (STARTED >= (SELECT FromDate FROM dbo.KPIParameters AS KPIParameters_5)) AND (STARTED <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_4))), 0) AS NoOpenMatters, ISNULL ((SELECT COUNT(Code) AS Expr1 FROM dbo.matters AS matters_4 WHERE (FECode = dbo.Handlers.CODE) AND (Started >= (SELECT StartOfYear FROM dbo.KPIParameters AS KPIParameters_5)) AND (Started <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_4))) + (SELECT COUNT(CODE) AS Expr1 FROM dbo.Closed AS Closed_1 WHERE (FECODE = dbo.Handlers.CODE) AND (STARTED >= (SELECT StartOfYear FROM dbo.KPIParameters AS KPIParameters_5)) AND (STARTED <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_4))), 0) AS NoMattersYTD, ISNULL ((SELECT COUNT(MATTER) AS Expr1 FROM dbo.TimeDayBook WHERE (FEEEARN = dbo.Handlers.CODE)), 0) AS NoUnPostedTimeEntrys, ISNULL ((SELECT COUNT(BillHeader_1.MATTER) AS Expr1 FROM dbo.BillHeader AS BillHeader_1 INNER JOIN dbo.matters AS matters_5 ON BillHeader_1.MATTER = matters_5.Code WHERE (matters_5.FECode = dbo.Handlers.CODE) AND (BillHeader_1.BILLNO = 0)), 0) AS NoDraftInvoice, ISNULL ((SELECT COUNT(StatuteLimits) AS Expr1 FROM dbo.matters AS matters_6 WHERE (StatuteLimits IS NOT NULL) AND (FECode = dbo.Handlers.CODE)), 0) AS NoStatuteOfLimitations, ISNULL ((SELECT COUNT(StatuteLimits) AS Expr1 FROM dbo.matters AS matters_6 WHERE (StatuteLimits IS NOT NULL) AND (FECode = dbo.Handlers.CODE) AND (StatuteLimits <= { fn NOW() } + 30)), 0) AS NoStatuteOfLimitationsWithin30, dbo.Handlers.TEAM, dbo.Handlers.Type, dbo.Handlers.TEAMCODE, ISNULL ((SELECT SUM(TIME) AS TotalRecordedTime FROM dbo.TimeEntry AS TimeEntry_1 WHERE (DATE >= (SELECT StartOfYear FROM dbo.KPIParameters AS KPIParameters_2)) AND (DATE <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_1)) AND (FEEEARN = dbo.Handlers.CODE) AND (MATTER = '~') AND (TASK <> 'BILLED') AND (TASK <> 'CREDIT') AND (TASK <> 'WRI') OR (DATE >= (SELECT StartOfYear FROM dbo.KPIParameters AS KPIParameters_2)) AND (DATE <= (SELECT ToDate FROM dbo.KPIParameters AS KPIParameters_1)) AND (FEEEARN = dbo.Handlers.CODE) AND (TASK <> 'BILLED') AND (TASK <> 'CREDIT') AND (TASK <> 'WRI') AND (REC_IRR = 'N')), 0) AS NonChargableTime, ISNULL ((SELECT SUM(CHARGE) AS TotalCharge FROM dbo.TimeEntry AS TimeEntry_1 WHERE (TIMEORCHARGE <> 'B') AND (REC_IRR <> 'N') AND (FEEEARN = dbo.Handlers.CODE) AND (INVOICENO = 0) AND (MATTER <> '~')), 0) AS WIP FROM dbo.Handlers INNER JOIN dbo.Handlers Handlers_1 ON dbo.Handlers.TEAM = Handlers_1.CODE LEFT OUTER JOIN dbo.Departments ON dbo.Handlers.Dept = dbo.Departments.CODE WHERE (dbo.Handlers.Type = 'L' OR dbo.Handlers.Type = 'P') AND (dbo.Handlers.TEAMCODE <> 'Y') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW [dbo].[HandlersStatsFeByDept] AS SELECT COUNT(CASE WHEN IsNull(TimeRecorded, 0) = 0 THEN NULL ELSE 1 END) AS CountFePer, COUNT(CASE WHEN IsNull(TimeRecordedYTD, 0) = 0 THEN NULL ELSE 1 END) AS CountFEYTD, dbo.Departments.CODE FROM dbo.HandlersStats INNER JOIN dbo.Departments ON dbo.HandlersStats.Department = dbo.Departments.[DESC] GROUP BY dbo.Departments.CODE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW [dbo].[HandlersStatsFeByTeam] AS SELECT COUNT(CASE WHEN IsNull(TimeRecorded, 0) = 0 THEN NULL ELSE 1 END) AS CountFePer, COUNT(CASE WHEN IsNull(TimeRecordedYTD, 0) = 0 THEN NULL ELSE 1 END) AS CountFEYTD, dbo.Handlers.CODE FROM dbo.HandlersStats INNER JOIN dbo.Handlers ON dbo.HandlersStats.TEAM = dbo.Handlers.CODE GROUP BY dbo.Handlers.CODE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.LastBillDate AS SELECT TOP 100 PERCENT dbo.TimeEntry.MATTER, MAX(dbo.TimeEntry.[DATE]) AS LastBillDate FROM dbo.TimeEntry INNER JOIN dbo.matters ON dbo.TimeEntry.MATTER = dbo.matters.Code WHERE (dbo.TimeEntry.TIMEORCHARGE = 'B') GROUP BY dbo.TimeEntry.MATTER ORDER BY dbo.TimeEntry.MATTER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.MatterLastBillDate AS SELECT MATTER AS MatterCode, MAX([DATE]) AS BillDate FROM dbo.DebtorsLedger WHERE (TYPE = 'I') GROUP BY MATTER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.MatterTransactionsBalances AS SELECT SUM(VALUED) AS DebtorsBalance, SUM(VALUEO) AS OutlayBalance, SUM(VALUEC) AS ClientBalance, SUM(VALUECC) AS ClientCCBalance, SUM(VALUECD) AS ClientCDBalance FROM dbo.MatterLedger GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.NoOutstandingTasks AS SELECT TOP 100 PERCENT HANDLER, COUNT(ACTIONID) AS NoOutstandActions FROM dbo.DiaryDelegations WHERE (STATUS = 0) GROUP BY HANDLER ORDER BY HANDLER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.NoOverDuePhoneCalls AS SELECT TOP 100 PERCENT HANDLER, COUNT(ACTIONID) AS NoOutstandActions, ActionType FROM dbo.DiaryDelegations WHERE (STATUS = 0) AND ([DATE] <= { fn NOW() }) GROUP BY HANDLER, ActionType HAVING (ActionType = 'T') ORDER BY HANDLER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.NoOverDueTasks AS SELECT TOP 100 PERCENT HANDLER, COUNT(ACTIONID) AS NoOutstandActions FROM dbo.DiaryDelegations WHERE (STATUS = 0) AND ([DATE] <= { fn NOW() }) GROUP BY HANDLER ORDER BY HANDLER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.OpenClosedMatterLedger AS SELECT ISNULL(dbo.MatterLedger.MATTER, dbo.ClosedMatterLedger.MATTER) AS Matter, ISNULL(dbo.MatterLedger.BATCHNO, dbo.ClosedMatterLedger.BATCHNO) AS BatchNo, ISNULL(dbo.MatterLedger.PREF, dbo.ClosedMatterLedger.PREF) AS Pref, ISNULL(dbo.MatterLedger.[DATE], dbo.ClosedMatterLedger.[DATE]) AS TransDate, ISNULL(dbo.MatterLedger.REF, dbo.ClosedMatterLedger.REF) AS Ref, ISNULL(dbo.MatterLedger.NARR, dbo.ClosedMatterLedger.NARR) AS Narr, ISNULL(dbo.MatterLedger.VALUED, dbo.ClosedMatterLedger.VALUED) AS ValueD, ISNULL(dbo.MatterLedger.VALUEO, dbo.ClosedMatterLedger.VALUEO) AS ValueO, ISNULL(dbo.MatterLedger.VALUEC, dbo.ClosedMatterLedger.VALUEC) AS ValueC, ISNULL(dbo.MatterLedger.FEE, dbo.ClosedMatterLedger.FEE) AS Fee, ISNULL(dbo.MatterLedger.PER, dbo.ClosedMatterLedger.PER) AS Per, ISNULL(dbo.MatterLedger.[YEAR], dbo.ClosedMatterLedger.[YEAR]) AS TranYear, ISNULL(dbo.MatterLedger.ENTRYDATE, dbo.ClosedMatterLedger.ENTRYDATE) AS EntryDate, ISNULL(dbo.MatterLedger.CLIENT, dbo.ClosedMatterLedger.CLIENT) AS Client, ISNULL(dbo.MatterLedger.VALUECC, dbo.ClosedMatterLedger.VALUECC) AS ValueCC, ISNULL(dbo.MatterLedger.VALUECD, dbo.ClosedMatterLedger.VALUECD) AS ValueCD, ISNULL(dbo.MatterLedger.DEPOSITTYPE, dbo.ClosedMatterLedger.DEPOSITTYPE) AS Deposittype, ISNULL(dbo.MatterLedger.LREF, dbo.ClosedMatterLedger.LREF) AS lref FROM dbo.MatterLedger FULL OUTER JOIN dbo.ClosedMatterLedger ON dbo.MatterLedger.MATTER = dbo.ClosedMatterLedger.MATTER AND dbo.MatterLedger.LREF = dbo.ClosedMatterLedger.LREF GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.OpenClosedMatters AS SELECT TOP 100 PERCENT LTRIM(ISNULL(dbo.matters.Code, '') + ISNULL(dbo.Closed.CODE, '')) AS Code, LTRIM(ISNULL(dbo.matters.ClientCode, '') + ISNULL(dbo.Closed.CLIENTCODE, '')) AS ClientCode, LTRIM(ISNULL(dbo.matters.Description, '') + ISNULL(dbo.Closed.DESCRIPTION, '')) AS Description, LTRIM(ISNULL(dbo.matters.Dept, '') + ISNULL(dbo.Closed.DEPT, '')) AS Dept, LTRIM(ISNULL(dbo.matters.FECode, '') + ISNULL(dbo.Closed.FECODE, '')) AS Fecode, LTRIM(ISNULL(dbo.matters.Started, '') + ISNULL(dbo.Closed.STARTED, '')) AS Started, LTRIM(ISNULL(dbo.matters.WType, '') + ISNULL(dbo.Closed.WTYPE, '')) AS Wtype, LTRIM(ISNULL(dbo.matters.User1, '') + ISNULL(dbo.Closed.USER1, '')) AS User1, LTRIM(ISNULL(dbo.matters.User2, '') + ISNULL(dbo.Closed.USER2, '')) AS User2, LTRIM(ISNULL(dbo.matters.User3, '') + ISNULL(dbo.Closed.USER3, '')) AS User3, LTRIM(ISNULL(dbo.matters.OldRef, '') + ISNULL(dbo.Closed.OLDREF, '')) AS OldRef, LTRIM(ISNULL(dbo.matters.FileNum, '') + ISNULL(dbo.Closed.FILENUM, '')) AS FileNum, dbo.matters.Code AS OpenCode, dbo.Closed.CODE AS ClosedCode FROM dbo.matters FULL OUTER JOIN dbo.Closed ON dbo.matters.Code = dbo.Closed.CODE ORDER BY LTRIM(ISNULL(dbo.matters.Code, '') + ISNULL(dbo.Closed.CODE, '')) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.OpenClosedMattersLedger AS SELECT ISNULL(dbo.MatterLedger.MATTER, dbo.ClosedMatterLedger.MATTER) AS Matter, ISNULL(dbo.MatterLedger.BATCHNO, dbo.ClosedMatterLedger.BATCHNO) AS BatchNo, ISNULL(dbo.MatterLedger.PREF, dbo.ClosedMatterLedger.PREF) AS Pref, ISNULL(dbo.MatterLedger.[DATE], dbo.ClosedMatterLedger.[DATE]) AS TransDate, ISNULL(dbo.MatterLedger.REF, dbo.ClosedMatterLedger.REF) AS Ref, ISNULL(dbo.MatterLedger.NARR, dbo.ClosedMatterLedger.NARR) AS Narr, ISNULL(dbo.MatterLedger.VALUED, dbo.ClosedMatterLedger.VALUED) AS ValueD, ISNULL(dbo.MatterLedger.VALUEO, dbo.ClosedMatterLedger.VALUEO) AS ValueO, ISNULL(dbo.MatterLedger.VALUEC, dbo.ClosedMatterLedger.VALUEC) AS ValueC, ISNULL(dbo.MatterLedger.FEE, dbo.ClosedMatterLedger.FEE) AS Fee, ISNULL(dbo.MatterLedger.PER, dbo.ClosedMatterLedger.PER) AS Per, ISNULL(dbo.MatterLedger.[YEAR], dbo.ClosedMatterLedger.[YEAR]) AS TranYear, ISNULL(dbo.MatterLedger.ENTRYDATE, dbo.ClosedMatterLedger.ENTRYDATE) AS EntryDate, ISNULL(dbo.MatterLedger.CLIENT, dbo.ClosedMatterLedger.CLIENT) AS Client, ISNULL(dbo.MatterLedger.VALUECC, dbo.ClosedMatterLedger.VALUECC) AS ValueCC, ISNULL(dbo.MatterLedger.VALUECD, dbo.ClosedMatterLedger.VALUECD) AS ValueCD, ISNULL(dbo.MatterLedger.DEPOSITTYPE, dbo.ClosedMatterLedger.DEPOSITTYPE) AS Deposittype, ISNULL(dbo.MatterLedger.LREF, dbo.ClosedMatterLedger.LREF) AS lref FROM dbo.MatterLedger FULL OUTER JOIN dbo.ClosedMatterLedger ON dbo.MatterLedger.MATTER = dbo.ClosedMatterLedger.MATTER AND dbo.MatterLedger.LREF = dbo.ClosedMatterLedger.LREF GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.Partners AS SELECT CODE, TEAM, TEAMCODE, Type, NAME, RATE, BUDGET1, BUDGET2, BUDGET3, BUDGET4, BUDGET5, BUDGET6, BUDGET7, BUDGET8, BUDGET9, BUDGET10, BUDGET11, BUDGET12, ACTUAL1, ACTUAL2, ACTUAL3, ACTUAL4, ACTUAL5, ACTUAL6, ACTUAL7, ACTUAL8, ACTUAL9, ACTUAL10, ACTUAL11, ACTUAL12, TEMPCALC, LOGON, MAILADDRESS, TIMECOSTER, TEAMLEADER, NORECENTMATTERS, DEFAULTTASK, EXCHANGEALIAS, RATE1, RATE2, RATE3, RATE4, RATE5, SIGNATURE, EMAIL, RETIRED, DELEGATE FROM dbo.Handlers WHERE (Type = 'P') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.ReportInvoices AS SELECT TOP 100 PERCENT dbo.BatchDetails.BATCHNO, dbo.BatchDetails.TYPE, dbo.BatchDetails.PREF, dbo.BatchDetails.REF, dbo.BatchDetails.[DATE], dbo.BatchDetails.NARR, dbo.BatchDetails.[VALUE] AS BatchDValue, dbo.BatchDetails.VATCODE AS BatchDVATCode, dbo.BatchDetails.VATVAL AS BatchDVATValue, dbo.BatchDetails.OUTLAY, dbo.BatchDetails.[YEAR], dbo.BatchDetails.PERNO, dbo.FeeEarnerCodes.NAME, dbo.BatchDetails.CODE, dbo.BatchDetails.FEE, dbo.BatchH.MATTER, dbo.BatchH.INVCR, dbo.BatchH.POSTED, dbo.BatchH.OUTLAYTOT AS BatchHOutlay, dbo.BatchH.VATTOT AS BatchHVAT, dbo.BatchH.FEETOT AS BatchHFee, dbo.BatchH.[VALUE] AS BatchHValue, LTRIM(ISNULL(dbo.matters.Description, '') + ISNULL(dbo.Closed.DESCRIPTION, '')) AS MatterDescription, LTRIM(ISNULL(dbo.matters.ClientCode, '') + ISNULL(dbo.Closed.CLIENTCODE, '')) AS Client FROM dbo.Closed RIGHT OUTER JOIN dbo.BatchH ON dbo.Closed.CODE = dbo.BatchH.MATTER RIGHT OUTER JOIN dbo.BatchDetails LEFT OUTER JOIN dbo.FeeEarnerCodes ON dbo.BatchDetails.FEE COLLATE Latin1_General_CI_AS = dbo.FeeEarnerCodes.CODE ON dbo.BatchH.BATCHNO = dbo.BatchDetails.BATCHNO LEFT OUTER JOIN dbo.matters ON dbo.BatchH.MATTER COLLATE Latin1_General_CI_AS = dbo.matters.Code WHERE (dbo.BatchDetails.TYPE = 'I') ORDER BY dbo.BatchDetails.BATCHNO GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW [dbo].[RevenueOutcomes] AS SELECT TOP 100 PERCENT CASECODE, DATE, STATUS, ACTIONCODE, ACTIONSTATUS, TxmSent, TxmDate, TxmSeqNo, ACTIONID, TEXT1 FROM dbo.diary WHERE (TxmSent = 'false') AND (STATUS = 1) AND (ACTIONCODE = 'O01' OR ACTIONCODE = 'O02' OR ACTIONCODE = 'O03' OR ACTIONCODE = 'O04' OR ACTIONCODE = 'O05' OR ACTIONCODE = 'O06' OR ACTIONCODE = 'O07' OR ACTIONCODE = 'O08' OR ACTIONCODE = 'O19' OR ACTIONCODE = 'O20' OR ACTIONCODE = 'O21' OR ACTIONCODE = 'O23' OR ACTIONCODE = 'O24' OR ACTIONCODE = 'O25' OR ACTIONCODE = 'O28' OR ACTIONCODE = 'O29' OR ACTIONCODE = 'O34') AND (ACTIONSTATUS = 'NA') AND (LEFT(CASECODE, 6) = 'XXXXXX') ORDER BY CASECODE, DATE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW [dbo].[RevenueStages] AS SELECT TOP 100 PERCENT CASECODE, DATE, STATUS, ACTIONCODE, ACTIONSTATUS, TxmSent, TxmDate, TxmSeqNo, ACTIONID FROM dbo.diary WHERE (TxmSent = 'false') AND (STATUS = 1) AND (ACTIONSTATUS = '10' OR ACTIONSTATUS = '13' OR ACTIONSTATUS = '16' OR ACTIONSTATUS = '19' OR ACTIONSTATUS = '22' OR ACTIONSTATUS = '25' OR ACTIONSTATUS = '28' OR ACTIONSTATUS = '31' OR ACTIONSTATUS = '32' OR ACTIONSTATUS = '34' OR ACTIONSTATUS = '37' OR ACTIONSTATUS = '43' OR ACTIONSTATUS = '44' OR ACTIONSTATUS = '45' OR ACTIONSTATUS = '46' OR ACTIONSTATUS = '47' OR ACTIONSTATUS = '49' OR ACTIONSTATUS = '50' OR ACTIONSTATUS = '52' OR ACTIONSTATUS = '54' OR ACTIONSTATUS = '55' OR ACTIONSTATUS = '58' OR ACTIONSTATUS = '59' OR ACTIONSTATUS = '61' OR ACTIONSTATUS = '64' OR ACTIONSTATUS = '65' OR ACTIONSTATUS = '66' OR ACTIONSTATUS = '67' OR ACTIONSTATUS = '68' OR ACTIONSTATUS = '69' OR ACTIONSTATUS = '71' OR ACTIONSTATUS = '73' OR ACTIONSTATUS = '74' OR ACTIONSTATUS = '99') AND (LEFT(CASECODE, 6) = 'XXXXXX') ORDER BY CASECODE, DATE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.Solicitors AS SELECT CODE, TEAM, TEAMCODE, Type, NAME, RATE, BUDGET1, BUDGET2, BUDGET3, BUDGET4, BUDGET5, BUDGET6, BUDGET7, BUDGET8, BUDGET9, BUDGET10, BUDGET11, BUDGET12, ACTUAL1, ACTUAL2, ACTUAL3, ACTUAL4, ACTUAL5, ACTUAL6, ACTUAL7, ACTUAL8, ACTUAL9, ACTUAL10, ACTUAL11, ACTUAL12, TEMPCALC, LOGON, MAILADDRESS, TIMECOSTER, TEAMLEADER, NORECENTMATTERS, DEFAULTTASK, EXCHANGEALIAS, RATE1, RATE2, RATE3, RATE4, RATE5, SIGNATURE, EMAIL, RETIRED, DELEGATE FROM dbo.Handlers WHERE (Type = 'L') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.SupportStaff AS SELECT CODE, TEAM, TEAMCODE, Type, NAME, RATE, BUDGET1, BUDGET2, BUDGET3, BUDGET4, BUDGET5, BUDGET6, BUDGET7, BUDGET8, BUDGET9, BUDGET10, BUDGET11, BUDGET12, ACTUAL1, ACTUAL2, ACTUAL3, ACTUAL4, ACTUAL5, ACTUAL6, ACTUAL7, ACTUAL8, ACTUAL9, ACTUAL10, ACTUAL11, ACTUAL12, TEMPCALC, LOGON, MAILADDRESS, TIMECOSTER, TEAMLEADER, NORECENTMATTERS, DEFAULTTASK, EXCHANGEALIAS, RATE1, RATE2, RATE3, RATE4, RATE5, SIGNATURE, EMAIL, RETIRED, DELEGATE FROM dbo.Handlers WHERE (Type = 'S') GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.TimeEntryLastDate AS SELECT DISTINCT TOP 100 PERCENT MATTER, MAX(DATE) AS LastDate FROM dbo.TimeEntry WHERE (REC_IRR <> 'N') AND (TIMEORCHARGE <> 'B') AND (INVOICENO = 0) AND (MATTER <> '~') GROUP BY MATTER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.TimeLastBilled AS SELECT TOP 100 PERCENT MATTER, MAX([DATE]) AS LastBillDate, MAX(RECORDID) AS RecordID FROM dbo.TimeEntry GROUP BY MATTER, TIMEORCHARGE HAVING (TIMEORCHARGE = 'B') ORDER BY TIMEORCHARGE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create view [dbo].[VWContactAddresses] As select * from [dbo].[ContactAddresses] ( ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.FeMatterWIP AS SELECT TOP 100 PERCENT dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER, SUM(dbo.TimeEntry.CHARGE) AS WIP, dbo.MatterLastBillDate.BillDate, dbo.Contacts.Name, dbo.matters.Description, dbo.matters.FECode, dbo.matters.Dept, dbo.matters.WType, dbo.matters.DebtBal AS DebtorsBalance, dbo.matters.OutlayBal AS OutlayBalance, dbo.matters.ClientBal AS ClientTotalBalance, dbo.matters.ClientCurBal AS ClientDepositeBalance, dbo.matters.ClientDepBal AS ClientBalance, dbo.TimeEntry.TIMEORCHARGE AS TimeOrChange, dbo.TimeEntry.INVOICENO FROM dbo.MatterLastBillDate RIGHT OUTER JOIN dbo.TimeEntry ON dbo.MatterLastBillDate.MatterCode = dbo.TimeEntry.MATTER LEFT OUTER JOIN dbo.Contacts RIGHT OUTER JOIN dbo.matters ON dbo.Contacts.Code = dbo.matters.ClientCode ON dbo.TimeEntry.MATTER = dbo.matters.Code WHERE (dbo.TimeEntry.REC_IRR <> 'N') GROUP BY dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER, dbo.MatterLastBillDate.BillDate, dbo.Contacts.Name, dbo.matters.Description, dbo.matters.FECode, dbo.matters.Dept, dbo.matters.WType, dbo.matters.DebtBal, dbo.matters.OutlayBal, dbo.matters.ClientBal, dbo.matters.ClientCurBal, dbo.matters.ClientDepBal, dbo.TimeEntry.TIMEORCHARGE, dbo.TimeEntry.INVOICENO HAVING (dbo.TimeEntry.MATTER <> '~') AND (dbo.TimeEntry.TIMEORCHARGE <> 'B') AND (dbo.TimeEntry.INVOICENO = 0) ORDER BY dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.FeeBillAnalysis AS SELECT TOP 100 PERCENT dbo.OpenClosedMatters.User3 AS Fecode, dbo.DebtorsLedger.[YEAR], dbo.DebtorsLedger.PER, SUM(dbo.DebtorsLedger.ORFEES) AS ORFees FROM dbo.OpenClosedMatters LEFT OUTER JOIN dbo.DebtorsLedger ON dbo.OpenClosedMatters.Code = dbo.DebtorsLedger.MATTER RIGHT OUTER JOIN dbo.FeeEarnerCodes ON dbo.OpenClosedMatters.Fecode = dbo.FeeEarnerCodes.CODE WHERE (dbo.DebtorsLedger.TYPE = 'I') GROUP BY dbo.DebtorsLedger.[YEAR], dbo.DebtorsLedger.PER, dbo.FeeEarnerCodes.RETIRED, dbo.OpenClosedMatters.ClientCode, dbo.OpenClosedMatters.User3 HAVING (dbo.FeeEarnerCodes.RETIRED <> 'Y') ORDER BY dbo.OpenClosedMatters.User3, dbo.DebtorsLedger.[YEAR], dbo.DebtorsLedger.PER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.MatterDetailView AS SELECT dbo.OpenClosedMatters.Code AS MatterCode, dbo.OpenClosedMatters.ClientCode, dbo.Contacts.Name AS ClientName, dbo.OpenClosedMatters.Description AS MatterDescription, dbo.OpenClosedMatters.Fecode AS FeeEarnerCode, dbo.FeeEarnerCodes.NAME AS FeeEarnerName, dbo.Departments.[DESC] AS Department, dbo.WorkTypes.[DESC] AS WorkType, dbo.OpenClosedMatters.Started, dbo.OpenClosedMatters.User1, dbo.OpenClosedMatters.User2, dbo.OpenClosedMatters.User3, dbo.OpenClosedMatters.OldRef, (CASE ISNULL(dbo.OpenClosedMatters.OpenCode, 'Closed') WHEN 'Closed' THEN 'Closed' ELSE 'Open' END) AS OpenOrClosed, dbo.OpenClosedMatters.Wtype AS WorkTypeCode, dbo.OpenClosedMatters.Dept AS DepartmentCode FROM dbo.OpenClosedMatters INNER JOIN dbo.Contacts ON dbo.OpenClosedMatters.ClientCode = dbo.Contacts.Code INNER JOIN dbo.FeeEarnerCodes ON dbo.OpenClosedMatters.Fecode = dbo.FeeEarnerCodes.CODE INNER JOIN dbo.WorkTypes ON dbo.OpenClosedMatters.Wtype = dbo.WorkTypes.CODE INNER JOIN dbo.Departments ON dbo.OpenClosedMatters.Dept = dbo.Departments.CODE GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.New_FeMatterWIP_View AS SELECT TOP 100 PERCENT dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER, SUM(dbo.TimeEntry.CHARGE) AS WIP, dbo.MatterLastBillDate.BillDate, dbo.Contacts.Name, dbo.matters.Description, dbo.matters.FECode, dbo.matters.Dept, dbo.matters.WType, dbo.matters.DebtBal AS DebtorsBalance, dbo.matters.OutlayBal AS OutlayBalance, dbo.matters.ClientBal AS ClientTotalBalance, dbo.matters.ClientCurBal AS ClientDepositeBalance, dbo.matters.ClientDepBal AS ClientBalance, dbo.TimeEntry.TIMEORCHARGE AS TimeOrChange FROM dbo.MatterLastBillDate RIGHT OUTER JOIN dbo.TimeEntry ON dbo.MatterLastBillDate.MatterCode = dbo.TimeEntry.MATTER LEFT OUTER JOIN dbo.Contacts RIGHT OUTER JOIN dbo.matters ON dbo.Contacts.Code = dbo.matters.ClientCode ON dbo.TimeEntry.MATTER = dbo.matters.Code WHERE (dbo.TimeEntry.REC_IRR <> 'N') AND (dbo.TimeEntry.INVOICENO = 0 OR dbo.TimeEntry.INVOICENO IS NULL) GROUP BY dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER, dbo.MatterLastBillDate.BillDate, dbo.Contacts.Name, dbo.matters.Description, dbo.matters.FECode, dbo.matters.Dept, dbo.matters.WType, dbo.matters.DebtBal, dbo.matters.OutlayBal, dbo.matters.ClientBal, dbo.matters.ClientCurBal, dbo.matters.ClientDepBal, dbo.TimeEntry.TIMEORCHARGE HAVING (dbo.TimeEntry.MATTER <> '~') AND (dbo.TimeEntry.TIMEORCHARGE <> 'B') ORDER BY dbo.TimeEntry.FEEEARN, dbo.TimeEntry.MATTER GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_CreateCalendarStep]( @pStatus Int=0, @pDate DateTime, @pCaseCode char(17), @pActionCode char(15), @pActionStatus char(3), @pFnCode char(4), @pTeamCode char(4), @pText1 varchar(8000), @pSubject varchar(500), @pProcessType char(1), @pTime char(10), @pActionId int=0 output) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @intActionID Int DECLARE @intAssignno int -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Get CaseCode From Matters Table ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @strCaseCode = ( SELECT Top 1 [Code] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail -- Get Next ActionID ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @intActionID = ( SELECT Top 1 ActionID FROM Diary ORDER BY ActionID DESC ) IF @@error <> 0 GOTO Tran_Fail IF @intActionID IS NULL SELECT @intActionID = 0 SELECT @intActionID = @intActionID + 1 -- Write Diary Record ----------------------------------------------------------------------------------------------------------------------------------------- INSERT INTO Diary (Status, CaseCode, ActionCode, ActionStatus, FnCode, TeamCode, Text1, Subject, Publish, ActionType, ProcessType, DYStartTime, ActionId, [Date]) Values (@pStatus, @pCaseCode, @pActionCode, @pActionStatus, @pFnCode, @pTeamCode, @pText1, @pSubject, 'N', 'P', @pProcessType, @pTime, @intActionID, @pDate) IF @@error <> 0 GOTO Tran_Fail -- Write the diary delegation record ------------------------------------------------------------ INSERT INTO [DiaryDelegations] ([ACTIONID] ,[HANDLER] ,[TEAM] ,[DATE] ,[DATER] ,[TIMER] ,[DUEDATE] ,[DUETIME] ,[REVIEW] ,[STATUS] ,[OWNER] ,[DELEGATE] ,[DELEGATESTATUS] ,[ActionType] ,[FromHandler] ,[ReturnedBy] ,[DelType]) VALUES (@intActionID, @pFnCode, @pTeamCode, @pDate, 0, '', @pDate, @pTime, ' ', @pStatus, 'Y', @pFnCode, 0, 'E', ' ', ' ', 'Created') -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail Select @pActionId = @intActionID -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 Select @pActionId = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_CreateDiaryAttachment]( @pDiaryID Int=0, @pCaseCode char(17), @pName char(10), @pDocument char(100), @pFilePath char(255), @pType char(4), @pDocClass char(3), @pDateEntered DateTime, @pEnterBy char(8), @pLastAccessed DateTime, @pLastAccessedby char(8), @pSystem char(1), @pDictationFile char(255), @pTrackRef int=0 output) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @inTrackRef Int DECLARE @strFileName varchar(255) DECLARE @strMatterNo char(8) DECLARE @strClientCode char(8) DECLARE @strDefaultFolder varchar(255) DECLARE @strSource varchar(20) -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Get CaseCode From Matters Table ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @strCaseCode = ( SELECT Top 1 [Code] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail SELECT @strClientCode = ( SELECT Top 1 [ClientCode] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail SELECT @strMatterNo = ( SELECT Top 1 [Matter] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail -- Get Next TrackReference ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @inTrackRef = ( SELECT Top 1 TrackReference FROM DiaryAttachments ORDER BY TrackReference DESC ) IF @@error <> 0 GOTO Tran_Fail IF @inTrackRef IS NULL SELECT @inTrackRef = 0 SELECT @inTrackRef = @inTrackRef + 1 -- Write DiaryAttachment Record ----------------------------------------------------------------------------------------------------------------------------------------- Select @strDefaultFolder = (SELECT SCWPFOLDER FROM SystemConfig) Select @strFileName = (SELECT DCOUMENTFOLDER FROM client WHERE (CLCODE = @strClientCode) ) If rtrim(@strFileName) = '' Update client set DCOUMENTFOLDER= rtrim(@strDefaultFolder)+'\'+@strClientCode where (CLCODE = @strClientCode) SET @pDocument = REPLACE(@pDocument, char(13) + char(10), '_') Select @strFileName = rtrim((SELECT DCOUMENTFOLDER FROM client WHERE (CLCODE = @strClientCode) ) )+'\'+ rtrim(@strMatterNo) +'\' + rtrim(@pDocument) + '_' +rtrim(CAST(@inTrackRef as char)) + '.'+rtrim(@pType) Select @strSource = (Select ProcessType from Diary where actionid=@pDiaryId) If rtrim(@strSource) = 'I' SET @strSource = 'Received E-mail' else SET @strSource = 'Sent E-mail' INSERT INTO DiaryAttachments (DiaryId, TrackReference, CaseCode, [Name], Document, Filepath, Type, DocClass, DateEntered, EnteredBy, LastAccessDate, LastAccessBy, [System], Dictationfile, Source) Values (@pDiaryID, @inTrackRef, @pCaseCode, @pName, @pDocument, @strFileName, left(@pType,3), @pDocClass, @pDateEntered, @pEnterBy, @pLastAccessed, @pLastAccessedby, @pSystem, @pDictationFile, @strSource) IF @@error <> 0 GOTO Tran_Fail -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail Select @pTrackRef = @inTrackRef -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 Select @pTrackRef = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE [dbo].[ky_CreateDiaryStep]( @pStatus Int=0, @pDate DateTime, @pCaseCode char(17), @pActionCode char(15), @pActionStatus char(3), @pFnCode char(4), @pTeamCode char(4), @pText1 varchar(8000), @pAttachments char(1), @pEmailAddress varchar(150), @pAddressTo varchar(2000), @pccTo varchar(2000), @pbccTo varchar(2000), @pemail char(1), @pSubject varchar(500), @pProcessType char(1), @pTime char(10), @pActionId int=0 output) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @intActionID Int DECLARE @intAssignno int DECLARE @pPublish char(1) -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Get CaseCode From Matters Table ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @strCaseCode = ( SELECT Top 1 [Code] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail -- Get Next ActionID ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @intActionID = ( SELECT Top 1 ActionID FROM Diary ORDER BY ActionID DESC ) IF @@error <> 0 GOTO Tran_Fail IF @intActionID IS NULL SELECT @intActionID = 0 SELECT @intActionID = @intActionID + 1 Select @pPublish = (Select PUBLISHER from TemplateActions where actioncode=@pActionCode) IF @pPublish IS NULL SELECT @pPublish = 'N' -- Write Diary Record ----------------------------------------------------------------------------------------------------------------------------------------- INSERT INTO Diary (Status, CaseCode, ActionCode, ActionStatus, FnCode, TeamCode, Text1, Attachments, EmailAddress, AddressTo, ccTo, bccTo, email, Subject, Publish, ActionType, ProcessType, DYStartTime, ActionId, [Date]) Values (@pStatus, @pCaseCode, @pActionCode, @pActionStatus, @pFnCode, @pTeamCode, @pText1, @pAttachments, @pEmailAddress, @pAddressTo, @pccTo, @pbccTo, @pemail, @pSubject, @pPublish, 'E', @pProcessType, @pTime, @intActionID, @pDate) IF @@error <> 0 GOTO Tran_Fail -- Write the diary delegation record ------------------------------------------------------------ INSERT INTO [DiaryDelegations] ([ACTIONID] ,[HANDLER] ,[TEAM] ,[DATE] ,[DATER] ,[TIMER] ,[DUEDATE] ,[DUETIME] ,[REVIEW] ,[STATUS] ,[OWNER] ,[DELEGATE] ,[DELEGATESTATUS] ,[ActionType] ,[FromHandler] ,[ReturnedBy] ,[DelType]) VALUES (@intActionID, @pFnCode, @pTeamCode, @pDate, 0, '', @pDate, @pTime, ' ', @pStatus, 'Y', @pFnCode, 0, 'E', ' ', ' ', 'Created') -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail Select @pActionId = @intActionID -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 Select @pActionId = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_DeleteCalendarStep]( @pOutlookID varchar(256)) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @intActionID Int DECLARE @intAssignno int -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail SELECT @intActionID = ( SELECT ActionID FROM OutlookIds where outlookid = @pOutlookID) IF @@error <> 0 GOTO Tran_Fail -- Write Diary Record ----------------------------------------------------------------------------------------------------------------------------------------- Delete Diary where actionid = @intActionID IF @@error <> 0 GOTO Tran_Fail -- Write the diary delegation record -------------------------------------------------------------- @pActionId int=0 output Delete [DiaryDelegations] where actionid = @intActionID delete OutlookIds where outlookid = @pOutlookID -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Select @pActionId = @intActionID -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 -- Select @pActionId = 0 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_GetFileLocation]( @pTrackRef int, @pFileName char(255), @pFileType char(3), -- @pFileLocation Char(255) output, @pFullFileName char(255) output, @pStatus int output) AS -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- -- Select @pFileLocation = 'c:\dump\' -- Select @pFullFileName = rtrim(@pFileLocation) + rtrim(@pFullFileName) + '_'+CAST(@pTrackRef as char) +'.'+rtrim(@pFileType) Select @pStatus = 1 -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: Select @pStatus = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_UpdateCalendarStep]( @pStatus Int=0, @pDate DateTime, @pCaseCode char(17), @pActionCode char(15), @pActionStatus char(3), @pFnCode char(4), @pTeamCode char(4), @pText1 varchar(8000), @pSubject varchar(500), @pProcessType char(1), @pTime char(10), @pOutlookID varchar(256), @pActionId int=0 output) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @intActionID Int DECLARE @intAssignno int -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Get CaseCode From Matters Table ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @strCaseCode = ( SELECT Top 1 [Code] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail -- Get Next ActionID ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @intActionID = ( SELECT ActionID FROM OutlookIds where outlookid = @pOutlookID) IF @@error <> 0 GOTO Tran_Fail -- Write Diary Record ----------------------------------------------------------------------------------------------------------------------------------------- Update Diary set Status = @pStatus, CaseCode = @pCaseCode, ActionCode = @pActionCode, ActionStatus = @pActionStatus, FnCode = @pFnCode, TeamCode = @pTeamCode, Text1 = @pSubject, Subject = @pSubject, Publish = 'N', ActionType = 'P', ProcessType = 'I', DYStartTime = @pTime, [Date] = @pDate where actionid = @intActionID IF @@error <> 0 GOTO Tran_Fail -- Write the diary delegation record ------------------------------------------------------------ Update [DiaryDelegations] set [HANDLER] = @pFnCode, [TEAM] = @pTeamCode, [DATE] = @pDate, [DATER] = 0 , [TIMER] = '', [DUEDATE] = @pDate, [DUETIME] = @pTime, [REVIEW] = '', [STATUS] = @pStatus where actionid = @intActionID and owner = 'Y' and Deltype = 'Created' -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail Select @pActionId = @intActionID -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 Select @pActionId = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE [dbo].[ky_UpdateDiaryAttachment]( @pDiaryID Int=0, @pCaseCode char(17), @pName char(10), @pDocument char(100), @pFilePath char(255), @pType char(3), @pDocClass char(3), @pDateEntered DateTime, @pEnterBy char(8), @pLastAccessed DateTime, @pLastAccessedby char(8), @pSystem char(1), @pDictationFile char(255), @pUTrackRef Int, @pTrackRef int=0 output) AS SET NOCOUNT ON DECLARE @strcasecode nVarChar(17) DECLARE @inTrackRef Int -- Start Transaction ----------------------------------------------------------------------------------------------------------------------------------------- BEGIN TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail -- Get CaseCode From Matters Table ----------------------------------------------------------------------------------------------------------------------------------------- SELECT @strCaseCode = ( SELECT Top 1 [Code] FROM Matters WHERE code = @pCaseCode ) IF @@error <> 0 GOTO Tran_Fail IF LEN( @strCaseCode ) < 2 GOTO Tran_Fail -- Write DiaryAttachment Record ----------------------------------------------------------------------------------------------------------------------------------------- Update DiaryAttachments set DiaryId = @pDiaryID, CaseCode = @pCaseCode, [Name] = @pName, Document = @pDocument, Filepath = @pFilePath, Type = @pType, DocClass = @pDocClass, DateEntered = @pDateEntered, EnteredBy = @pEnterBy, LastAccessDate = @pLastAccessed, LastAccessBy = @pLastAccessedby, [System] = @pSystem, Dictationfile = @pDictationFile where TrackReference = @pUTrackRef IF @@error <> 0 GOTO Tran_Fail Select @inTrackRef = @pUTrackRef -- Commit Transaction ------------------------------------------------------------------------------------------------------------------ COMMIT TRAN Key_Tran_01 IF @@error <> 0 GOTO Tran_Fail Select @pTrackRef = @inTrackRef -- End Of Processing -------------------------------------------------------------------------------------------------------------------- ExitPoint: Return -- Error Processing ------------------------------------------------------------------------------------------------------------------------------------- Tran_Fail: rollback tran Key_Tran_01 Select @pTrackRef = -1 goto ExitPoint GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE sp_KEYHOUSEEXTRACT AS Declare @Today varchar(12), @SQL nvarchar(2048) set @Today = cast(datepart(dd, getdate()) As varchar(2)) + '/' + cast(datepart(mm, getdate()) As varchar(2)) + '/' + cast(datepart(yyyy, getdate()) as char(4)) TRUNCATE TABLE CLIENTEXTRACT TRUNCATE TABLE DEFENDANTEXTRACT TRUNCATE TABLE OUTLAYEXTRACT TRUNCATE TABLE OUTLAYEXTRACTPETTY TRUNCATE TABLE FEEEXTRACT insert into clientextract(CLIENTID , CLIENTCODEALPHA , CLIENTNAME , CLIENTADD1 , CLIENTADD2 , CLIENTADD3 , CLIENTADD4 , CLIENTADD5 , CLIENTPOSTCODE , CLIENTPHONE , CLIENTFAX , CLIENTEMAIL) select CLIENTID , CLIENTCODEALPHA , CLIENTNAME , CLIENTADD1 , CLIENTADD2 , CLIENTADD3 , CLIENTADD4 , CLIENTADD5 , CLIENTPOSTCODE , CLIENTPHONE , CLIENTFAX , CLIENTEMAIL from ClientAll where ClientAll.CLIENTEXTRACTED is null insert into DEFENDANTEXTRACT( DEFCLIENTCODEALPHA, DEFCASENUMBER ,DEFKEYREF, DEFCORRREF , DEFRECNO, DEFNAME , DEFTA , DEFADD1, DEFADD2 , DEFADD3 , DEFADD4 , DEFADD5 ,DEFRECEIPT, DEFOURREF) SELECT DEFCLIENTCODEALPHA, DEFCASENUMBER ,DEFCLIENTCODEALPHA + '\' + CAST(DEFCASENUMBER AS VARCHAR(20)) , DEFCORRREF , DEFRECNO, DEFNAME , DEFTA , DEFADD1, DEFADD2 , DEFADD3 , DEFADD4 , DEFADD5 ,DEFRECEIPT,DEFOURREF FROM DEFENDANTALL WHERE DEFENDANTALL.DEFEXTRACTED IS NULL and DEFENDANTALL.DEFORGCODE <> 3 and DEFENDANTALL.deforgcode <> 4 INSERT INTO OUTLAYEXTRACT (OUTLAYRECNO, OUTLAYPOSTDATE , OUTLAYEFFECDATE , OUTLAYCLIENTCODE , OUTLAYDEFRECNO, OUTLAYCODE, OUTLAYDESC, OUTLAYAMT , OUTLAYOFFICIAL, OUTLAYSOL ,OUTLAYINVNO, DEFCORRREF, DEFOURREF, DEFORGCODE , OUTLAYFINALBILL) SELECT OUTLAYRECNO, OUTLAYPOSTDATE , OUTLAYEFFECDATE , OUTLAYCLIENTCODE , OUTLAYDEFRECNO, OUTLAYCODE, OUTLAYDESC, OUTLAYAMT , OUTLAYOFFICIAL , DEFOURSOL, OUTLAYINVNO, DEFCORRREF, DEFOURREF, DEFORGCODE, OUTLAYFINALBILL FROM OUTLAY INNER JOIN OUTLAYTYPES ON OUTLAY.OUTLAYCODE = OUTLAYTYPES.OUTLAYTYPECODE INNER JOIN DEFENDANT ON OUTLAYDEFRECNO = DEFENDANT.DEFRECNO WHERE OUTLAYTYPES.OUTLAYTYPEBILLABLE = 'Y' AND OUTLAYTYPEGROUP <> 'P' AND OUTLAYEXTRACTED IS NULL SET @SQL = N'SET DATEFORMAT DMY INSERT INTO OUTLAYEXTRACTPETTY (OUTLAYRECNO, OUTLAYPOSTDATE , OUTLAYEFFECDATE , OUTLAYCLIENTCODE , OUTLAYDEFRECNO, OUTLAYCODE, OUTLAYDESC, OUTLAYAMT , OUTLAYOFFICIAL, OUTLAYSOL , OUTLAYINVNO,DEFCORRREF, DEFOURREF,DEFORGCODE,OUTLAYFINALBILL ) SELECT OUTLAYRECNO, OUTLAYPOSTDATE , OUTLAYEFFECDATE , OUTLAYCLIENTCODE , OUTLAYDEFRECNO, OUTLAYCODE, OUTLAYDESC, OUTLAYAMT , OUTLAYOFFICIAL , DEFOURSOL, OUTLAYINVNO,DEFCORRREF, DEFOURREF, DEFORGCODE,OUTLAYFINALBILL FROM OUTLAY INNER JOIN OUTLAYTYPES ON OUTLAY.OUTLAYCODE = OUTLAYTYPES.OUTLAYTYPECODE INNER JOIN DEFENDANT ON OUTLAYDEFRECNO = DEFENDANT.DEFRECNO WHERE OUTLAYTYPES.OUTLAYTYPEBILLABLE = ''Y'' AND OUTLAYTYPEGROUP = ''P'' AND OUTLAYEXTRACTED IS NULL AND OUTLAYPOSTEDTONOMINAL = ''Y'' and DEFENDANT.DEFORGCODE <> 3 and defendant.deforgcode <> 4 AND OUTLAYEFFECDATE <= ''' + @Today +'''' eXEC sp_executesql @SQL SET @SQL = N'SET DATEFORMAT DMY INSERT INTO FEEEXTRACT (FEERECNO , FEEPOSTDATE , FEEEFFECDATE , FEECLIENTCODE ,FEEDEFRECNO , FEECODE , FEEDESC ,FEEAMT , FEEOFFICIAL, FEESOL, FEEINVNO,DEFCORRREF, DEFOURREF, DEFORGCODE ,FEEFINALBILL) SELECT FEERECNO , FEEPOSTDATE , FEEEFFECDATE , FEECLIENTCODE ,FEEDEFRECNO , FEECODE , FEEDESC ,FEEAMT , FEEOFFICIAL , DEFOURSOL, FEEINVNO, DEFCORRREF, DEFOURREF, DEFORGCODE, FEEFINALBILL FROM FEE INNER JOIN FEETYPES ON FEE.FEECODE = FEETYPES.FEETYPECODE INNER JOIN DEFENDANT ON FEEDEFRECNO = DEFENDANT.DEFRECNO WHERE FEETYPES.FEEBILLABLE = ''Y'' AND FEEEXTRACTED IS NULL AND FEEPOSTEDTONOM = ''Y'' and DEFENDANT.DEFORGCODE <> 3 and defendant.deforgcode <> 4 AND feeEFFECDATE <= ''' + @Today +'''' eXEC sp_executesql @SQL GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO