· 6 years ago · Jun 25, 2019, 11:56 AM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : dkoddev03
5 Source Server Type : SQL Server
6 Source Server Version : 11002100
7 Source Host : dkoddev03:1433
8 Source Catalog : PMDv3
9 Source Schema : dbo
10
11 Target Server Type : SQL Server
12 Target Server Version : 11002100
13 File Encoding : 65001
14
15 Date: 25/06/2019 13:49:10
16*/
17
18
19-- ----------------------------
20-- Table structure for InvoiceInterpretedQueue
21-- ----------------------------
22IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[InvoiceInterpretedQueue]') AND type IN ('U'))
23 DROP TABLE [dbo].[InvoiceInterpretedQueue]
24GO
25
26CREATE TABLE [dbo].[InvoiceInterpretedQueue] (
27 [Docid] int NOT NULL
28)
29GO
30
31ALTER TABLE [dbo].[InvoiceInterpretedQueue] SET (LOCK_ESCALATION = TABLE)
32GO
33
34
35-- ----------------------------
36-- Table structure for InvoiceTransferredQueue
37-- ----------------------------
38IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[InvoiceTransferredQueue]') AND type IN ('U'))
39 DROP TABLE [dbo].[InvoiceTransferredQueue]
40GO
41
42CREATE TABLE [dbo].[InvoiceTransferredQueue] (
43 [Docid] int NOT NULL
44)
45GO
46
47ALTER TABLE [dbo].[InvoiceTransferredQueue] SET (LOCK_ESCALATION = TABLE)
48GO
49
50
51-- ----------------------------
52-- Table structure for rawInterpretIdentify
53-- ----------------------------
54IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInterpretIdentify]') AND type IN ('U'))
55 DROP TABLE [dbo].[rawInterpretIdentify]
56GO
57
58CREATE TABLE [dbo].[rawInterpretIdentify] (
59 [Docid] int NOT NULL,
60 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
61 [InvoiceEventTime] datetime NULL,
62 [Appendices] int NULL,
63 [Pages] int NULL,
64 [DefinitionID] int NULL,
65 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
66 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
67 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
68 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
69 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
70 [DefinitionAutoApprove] int NULL,
71 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL
72)
73GO
74
75ALTER TABLE [dbo].[rawInterpretIdentify] SET (LOCK_ESCALATION = TABLE)
76GO
77
78
79-- ----------------------------
80-- Table structure for rawInterpretInvoiceLog
81-- ----------------------------
82IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInterpretInvoiceLog]') AND type IN ('U'))
83 DROP TABLE [dbo].[rawInterpretInvoiceLog]
84GO
85
86CREATE TABLE [dbo].[rawInterpretInvoiceLog] (
87 [ID] int IDENTITY(1,1) NOT NULL,
88 [invoiceStart] datetime NULL,
89 [invoiceEnd] datetime NULL,
90 [Appendices] int NULL,
91 [Pages] int NULL,
92 [Originator] varchar(100) COLLATE Danish_Norwegian_CI_AS NULL,
93 [Title] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
94 [JGuid] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
95 [docid] int NULL,
96 [IGuid] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
97 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
98 [buyerid] varchar(50) COLLATE Danish_Norwegian_CI_AS DEFAULT ((0)) NOT NULL,
99 [InvoiceComplete] int NULL,
100 [DefAutoApproveEnabled] int NULL,
101 [DefinitionID] int NULL
102)
103GO
104
105ALTER TABLE [dbo].[rawInterpretInvoiceLog] SET (LOCK_ESCALATION = TABLE)
106GO
107
108
109-- ----------------------------
110-- Table structure for rawInterpretJobLog
111-- ----------------------------
112IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInterpretJobLog]') AND type IN ('U'))
113 DROP TABLE [dbo].[rawInterpretJobLog]
114GO
115
116CREATE TABLE [dbo].[rawInterpretJobLog] (
117 [ID] int IDENTITY(1,1) NOT NULL,
118 [jobStart] datetime NULL,
119 [jobEnd] datetime NULL,
120 [hostName] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
121 [jobName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
122 [pid] int NULL,
123 [userName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
124 [JGuid] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
125 [interpretedInvoices] int DEFAULT ((0)) NULL
126)
127GO
128
129ALTER TABLE [dbo].[rawInterpretJobLog] SET (LOCK_ESCALATION = TABLE)
130GO
131
132
133-- ----------------------------
134-- Table structure for rawInvoiceIdentified
135-- ----------------------------
136IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceIdentified]') AND type IN ('U'))
137 DROP TABLE [dbo].[rawInvoiceIdentified]
138GO
139
140CREATE TABLE [dbo].[rawInvoiceIdentified] (
141 [Docid] int NOT NULL,
142 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
143 [InvoiceEventTime] datetime NULL,
144 [Appendices] int NULL,
145 [Pages] int NULL,
146 [DefinitionID] int NULL,
147 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
148 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
149 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
150 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
151 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
152 [DefinitionAutoApprove] int NULL,
153 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL
154)
155GO
156
157ALTER TABLE [dbo].[rawInvoiceIdentified] SET (LOCK_ESCALATION = TABLE)
158GO
159
160
161-- ----------------------------
162-- Table structure for rawInvoiceInterpret
163-- ----------------------------
164IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceInterpret]') AND type IN ('U'))
165 DROP TABLE [dbo].[rawInvoiceInterpret]
166GO
167
168CREATE TABLE [dbo].[rawInvoiceInterpret] (
169 [Docid] int NOT NULL,
170 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
171 [InvoiceEventTime] datetime NULL,
172 [Appendices] int NULL,
173 [Pages] int NULL,
174 [DefinitionID] int NULL,
175 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
176 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
177 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
178 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
179 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
180 [DefinitionAutoApprove] int NULL,
181 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL
182)
183GO
184
185ALTER TABLE [dbo].[rawInvoiceInterpret] SET (LOCK_ESCALATION = TABLE)
186GO
187
188
189-- ----------------------------
190-- Table structure for rawInvoiceInterpreted
191-- ----------------------------
192IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceInterpreted]') AND type IN ('U'))
193 DROP TABLE [dbo].[rawInvoiceInterpreted]
194GO
195
196CREATE TABLE [dbo].[rawInvoiceInterpreted] (
197 [Docid] int NOT NULL,
198 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
199 [InvoiceEventTime] datetime NULL,
200 [Appendices] int NULL,
201 [Pages] int NULL,
202 [DefinitionID] int NULL,
203 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
204 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
205 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
206 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
207 [DefinitionAutoApprove] int NULL,
208 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
209 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
210 [eiFieldCompleteCount] int NULL,
211 [eiFieldHasErrorCount] int NULL,
212 [eiFieldInterpretErrorCount] int NULL,
213 [eiFieldManualEntryCount] int NULL,
214 [eiFieldRetypeCount] int NULL,
215 [eiFieldValidationErrorCount] int NULL
216)
217GO
218
219ALTER TABLE [dbo].[rawInvoiceInterpreted] SET (LOCK_ESCALATION = TABLE)
220GO
221
222
223-- ----------------------------
224-- Table structure for rawInvoiceInterpretedField
225-- ----------------------------
226IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceInterpretedField]') AND type IN ('U'))
227 DROP TABLE [dbo].[rawInvoiceInterpretedField]
228GO
229
230CREATE TABLE [dbo].[rawInvoiceInterpretedField] (
231 [id] int IDENTITY(1,1) NOT NULL,
232 [Timestamp] datetime DEFAULT (getdate()) NULL,
233 [Docid] int NOT NULL,
234 [DefinitionID] int NULL,
235 [FieldName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
236 [FieldStatus] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
237 [FieldValue] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL
238)
239GO
240
241ALTER TABLE [dbo].[rawInvoiceInterpretedField] SET (LOCK_ESCALATION = TABLE)
242GO
243
244
245-- ----------------------------
246-- Table structure for rawInvoiceTransfer
247-- ----------------------------
248IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceTransfer]') AND type IN ('U'))
249 DROP TABLE [dbo].[rawInvoiceTransfer]
250GO
251
252CREATE TABLE [dbo].[rawInvoiceTransfer] (
253 [Id] int IDENTITY(1,1) NOT NULL,
254 [Docid] int NOT NULL,
255 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
256 [InvoiceEventTime] datetime NULL,
257 [Appendices] int NULL,
258 [Pages] int NULL,
259 [DefinitionID] int NULL,
260 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
261 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
262 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
263 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
264 [Source] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
265 [DefinitionAutoApprove] int NULL,
266 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL
267)
268GO
269
270ALTER TABLE [dbo].[rawInvoiceTransfer] SET (LOCK_ESCALATION = TABLE)
271GO
272
273
274-- ----------------------------
275-- Table structure for rawInvoiceTransferred
276-- ----------------------------
277IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceTransferred]') AND type IN ('U'))
278 DROP TABLE [dbo].[rawInvoiceTransferred]
279GO
280
281CREATE TABLE [dbo].[rawInvoiceTransferred] (
282 [Docid] int NOT NULL,
283 [Status] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
284 [InvoiceEventTime] datetime NULL,
285 [Appendices] int NULL,
286 [Pages] int NULL,
287 [DefinitionID] int NULL,
288 [Originator] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
289 [MailTitle] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
290 [JGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
291 [IGUID] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
292 [DefinitionAutoApprove] int NULL,
293 [BuyerNumber] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL
294)
295GO
296
297ALTER TABLE [dbo].[rawInvoiceTransferred] SET (LOCK_ESCALATION = TABLE)
298GO
299
300
301-- ----------------------------
302-- Table structure for rawInvoiceTransferredField
303-- ----------------------------
304IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawInvoiceTransferredField]') AND type IN ('U'))
305 DROP TABLE [dbo].[rawInvoiceTransferredField]
306GO
307
308CREATE TABLE [dbo].[rawInvoiceTransferredField] (
309 [id] int IDENTITY(1,1) NOT NULL,
310 [Timestamp] datetime DEFAULT (getdate()) NULL,
311 [Docid] int NULL,
312 [DefinitionID] int NULL,
313 [FieldName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
314 [FieldStatus] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
315 [FieldValue] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL
316)
317GO
318
319ALTER TABLE [dbo].[rawInvoiceTransferredField] SET (LOCK_ESCALATION = TABLE)
320GO
321
322
323-- ----------------------------
324-- Table structure for rawTransferInvoiceLog
325-- ----------------------------
326IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawTransferInvoiceLog]') AND type IN ('U'))
327 DROP TABLE [dbo].[rawTransferInvoiceLog]
328GO
329
330CREATE TABLE [dbo].[rawTransferInvoiceLog] (
331 [ID] int IDENTITY(1,1) NOT NULL,
332 [invoiceStart] datetime NULL,
333 [invoiceEnd] datetime NULL,
334 [Appendices] int NULL,
335 [Pages] int NULL,
336 [Originator] varchar(100) COLLATE Danish_Norwegian_CI_AS NOT NULL,
337 [Title] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
338 [JGuid] varchar(50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
339 [docid] int NULL,
340 [IGuid] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
341 [supplierno] int NULL,
342 [auto] smallint NULL,
343 [buyernumber] varchar(50) COLLATE Danish_Norwegian_CI_AS DEFAULT ((0)) NOT NULL,
344 [source] int DEFAULT ((0)) NOT NULL
345)
346GO
347
348ALTER TABLE [dbo].[rawTransferInvoiceLog] SET (LOCK_ESCALATION = TABLE)
349GO
350
351
352-- ----------------------------
353-- Table structure for rawTransferJobLog
354-- ----------------------------
355IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[rawTransferJobLog]') AND type IN ('U'))
356 DROP TABLE [dbo].[rawTransferJobLog]
357GO
358
359CREATE TABLE [dbo].[rawTransferJobLog] (
360 [ID] int IDENTITY(1,1) NOT NULL,
361 [jobStart] datetime NULL,
362 [jobEnd] datetime NULL,
363 [hostName] varchar(255) COLLATE Danish_Norwegian_CI_AS NULL,
364 [jobName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
365 [pid] int NULL,
366 [userName] varchar(50) COLLATE Danish_Norwegian_CI_AS NULL,
367 [JGuid] varchar(50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
368 [source] int NULL,
369 [transferredInvoices] int NULL,
370 [transferAttempts] int NULL
371)
372GO
373
374ALTER TABLE [dbo].[rawTransferJobLog] SET (LOCK_ESCALATION = TABLE)
375GO
376
377
378-- ----------------------------
379-- Table structure for reportInterpreted
380-- ----------------------------
381IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[reportInterpreted]') AND type IN ('U'))
382 DROP TABLE [dbo].[reportInterpreted]
383GO
384
385CREATE TABLE [dbo].[reportInterpreted] (
386 [DocID] int NOT NULL,
387 [Appendices] int NOT NULL,
388 [Pages] int NOT NULL,
389 [DefinitionID] int NOT NULL,
390 [MailOriginator] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
391 [MailTitle] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
392 [InterpretJGUID] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
393 [Source] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
394 [Buyer] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
395 [AutoApproved] bit NOT NULL,
396 [Status] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
397 [ImportFileName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
398 [ReceivedTime] datetime NOT NULL,
399 [Interpreted] datetime NOT NULL,
400 [SupplierNumber] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
401 [SupplierName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
402 [DefinitionStatus] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
403 [AttachementName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL
404)
405GO
406
407ALTER TABLE [dbo].[reportInterpreted] SET (LOCK_ESCALATION = TABLE)
408GO
409
410
411-- ----------------------------
412-- Table structure for reportTransferred
413-- ----------------------------
414IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[reportTransferred]') AND type IN ('U'))
415 DROP TABLE [dbo].[reportTransferred]
416GO
417
418CREATE TABLE [dbo].[reportTransferred] (
419 [DocID] int NOT NULL,
420 [Appendices] int NOT NULL,
421 [Pages] int NOT NULL,
422 [DefinitionID] int NOT NULL,
423 [MailOriginator] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
424 [MailTitle] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
425 [InterpretJGUID] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
426 [Source] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
427 [Buyer] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
428 [AutoApproved] bit NOT NULL,
429 [Status] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
430 [ImportFileName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
431 [ReceivedTime] datetime NOT NULL,
432 [Interpreted] datetime NOT NULL,
433 [SupplierNumber] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
434 [SupplierName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
435 [InvoiceNumber] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
436 [DefinitionStatus] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
437 [AttachementName] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
438 [TransferJGUID] varchar(8000) COLLATE Danish_Norwegian_CI_AS NULL,
439 [Transferred] datetime NULL,
440 [ApprovedTime] datetime NULL,
441 [ChangedFields] int NULL,
442 [AutomaticFields] int NULL
443)
444GO
445
446ALTER TABLE [dbo].[reportTransferred] SET (LOCK_ESCALATION = TABLE)
447GO
448
449
450-- ----------------------------
451-- Primary Key structure for table InvoiceInterpretedQueue
452-- ----------------------------
453ALTER TABLE [dbo].[InvoiceInterpretedQueue] ADD CONSTRAINT [PK__InvoiceI__3EF6AC35B29DCB9B] PRIMARY KEY CLUSTERED ([Docid])
454WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
455ON [PRIMARY]
456GO
457
458
459-- ----------------------------
460-- Primary Key structure for table InvoiceTransferredQueue
461-- ----------------------------
462ALTER TABLE [dbo].[InvoiceTransferredQueue] ADD CONSTRAINT [PK__InvoiceT__3EF6AC35AA657CB3] PRIMARY KEY CLUSTERED ([Docid])
463WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
464ON [PRIMARY]
465GO
466
467
468-- ----------------------------
469-- Primary Key structure for table rawInterpretIdentify
470-- ----------------------------
471ALTER TABLE [dbo].[rawInterpretIdentify] ADD CONSTRAINT [PK__rawInter__3EF6AC35380AC7E9] PRIMARY KEY CLUSTERED ([Docid])
472WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
473ON [PRIMARY]
474GO
475
476
477-- ----------------------------
478-- Primary Key structure for table rawInterpretInvoiceLog
479-- ----------------------------
480ALTER TABLE [dbo].[rawInterpretInvoiceLog] ADD CONSTRAINT [PK__InvoiceL__3214EC2725B985B1] PRIMARY KEY CLUSTERED ([ID])
481WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
482ON [PRIMARY]
483GO
484
485
486-- ----------------------------
487-- Primary Key structure for table rawInterpretJobLog
488-- ----------------------------
489ALTER TABLE [dbo].[rawInterpretJobLog] ADD CONSTRAINT [PK__JobLog__3214EC27A52A91CC] PRIMARY KEY CLUSTERED ([ID])
490WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
491ON [PRIMARY]
492GO
493
494
495-- ----------------------------
496-- Primary Key structure for table rawInvoiceIdentified
497-- ----------------------------
498ALTER TABLE [dbo].[rawInvoiceIdentified] ADD CONSTRAINT [PK__rawInvoi__3EF6AC35A0661C34] PRIMARY KEY CLUSTERED ([Docid])
499WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
500ON [PRIMARY]
501GO
502
503
504-- ----------------------------
505-- Primary Key structure for table rawInvoiceInterpret
506-- ----------------------------
507ALTER TABLE [dbo].[rawInvoiceInterpret] ADD CONSTRAINT [PK__rawInvoi__3EF6AC35737E2494] PRIMARY KEY CLUSTERED ([Docid])
508WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
509ON [PRIMARY]
510GO
511
512
513-- ----------------------------
514-- Triggers structure for table rawInvoiceInterpreted
515-- ----------------------------
516CREATE TRIGGER [dbo].[interpretedQueueTrig]
517ON [dbo].[rawInvoiceInterpreted]
518WITH EXECUTE AS CALLER
519FOR INSERT
520AS
521BEGIN
522 -- SET NOCOUNT ON added to prevent extra result sets from
523 -- interfering with SELECT statements.
524 SET NOCOUNT ON;
525
526 INSERT INTO [dbo].[InvoiceInterpretedQueue]
527 values ((select Docid from inserted))
528
529 -- Insert statements for trigger here
530
531END
532GO
533
534
535-- ----------------------------
536-- Primary Key structure for table rawInvoiceInterpreted
537-- ----------------------------
538ALTER TABLE [dbo].[rawInvoiceInterpreted] ADD CONSTRAINT [PK__rawInvoi__3EF6AC35794C030C] PRIMARY KEY CLUSTERED ([Docid])
539WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
540ON [PRIMARY]
541GO
542
543
544-- ----------------------------
545-- Primary Key structure for table rawInvoiceInterpretedField
546-- ----------------------------
547ALTER TABLE [dbo].[rawInvoiceInterpretedField] ADD CONSTRAINT [PK__rawInvoi__3213E83FE7052001] PRIMARY KEY CLUSTERED ([id])
548WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
549ON [PRIMARY]
550GO
551
552
553-- ----------------------------
554-- Primary Key structure for table rawInvoiceTransfer
555-- ----------------------------
556ALTER TABLE [dbo].[rawInvoiceTransfer] ADD CONSTRAINT [PK__rawInvoi__3214EC07130002ED] PRIMARY KEY CLUSTERED ([Id])
557WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
558ON [PRIMARY]
559GO
560
561
562-- ----------------------------
563-- Triggers structure for table rawInvoiceTransferred
564-- ----------------------------
565CREATE TRIGGER [dbo].[transferred2QueueTrig]
566ON [dbo].[rawInvoiceTransferred]
567WITH EXECUTE AS CALLER
568FOR INSERT
569AS
570BEGIN
571 -- SET NOCOUNT ON added to prevent extra result sets from
572 -- interfering with SELECT statements.
573 SET NOCOUNT ON;
574
575 INSERT INTO [dbo].[InvoiceTransferredQueue]
576 values ((select Docid from inserted))
577
578 -- Insert statements for trigger here
579
580END
581GO
582
583
584-- ----------------------------
585-- Primary Key structure for table rawInvoiceTransferred
586-- ----------------------------
587ALTER TABLE [dbo].[rawInvoiceTransferred] ADD CONSTRAINT [PK__rawInvoi__3EF6AC35CA3926B2] PRIMARY KEY CLUSTERED ([Docid])
588WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
589ON [PRIMARY]
590GO
591
592
593-- ----------------------------
594-- Primary Key structure for table rawInvoiceTransferredField
595-- ----------------------------
596ALTER TABLE [dbo].[rawInvoiceTransferredField] ADD CONSTRAINT [PK__rawInvoi__3213E83FE7052001_copy1] PRIMARY KEY CLUSTERED ([id])
597WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
598ON [PRIMARY]
599GO
600
601
602-- ----------------------------
603-- Primary Key structure for table rawTransferInvoiceLog
604-- ----------------------------
605ALTER TABLE [dbo].[rawTransferInvoiceLog] ADD CONSTRAINT [PK__Transfer__20541B85F20EA961] PRIMARY KEY CLUSTERED ([ID])
606WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
607ON [PRIMARY]
608GO
609
610
611-- ----------------------------
612-- Primary Key structure for table rawTransferJobLog
613-- ----------------------------
614ALTER TABLE [dbo].[rawTransferJobLog] ADD CONSTRAINT [PK__rawTrans__20541B857357ECA9] PRIMARY KEY CLUSTERED ([JGuid])
615WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
616ON [PRIMARY]
617GO
618
619
620-- ----------------------------
621-- Primary Key structure for table reportInterpreted
622-- ----------------------------
623ALTER TABLE [dbo].[reportInterpreted] ADD CONSTRAINT [PK__finInter__3EF1888D63349F20] PRIMARY KEY CLUSTERED ([DocID])
624WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
625ON [PRIMARY]
626GO
627
628
629-- ----------------------------
630-- Primary Key structure for table reportTransferred
631-- ----------------------------
632ALTER TABLE [dbo].[reportTransferred] ADD CONSTRAINT [PK__finInter__3EF1888D63349F20_copy1] PRIMARY KEY CLUSTERED ([DocID])
633WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
634ON [PRIMARY]
635GO