· 9 years ago · Nov 11, 2016, 10:00 AM
1DB Update Script (incase you didnt have it):
2
3-- PBI 11583 Reporting App: Add jasper config repdef
4-- This column may not have been added to sites because of post-deployment scripts missing, so also checking in this release
5exec sp_csa_table_column_add
6 @table_name = 'repdef',
7 @new_column_name = 'report_description',
8 @new_column_datatype = 'ut_txtnum',
9 @new_column_allow_nulls = 1,
10 @new_column_default_value = NULL
11
12exec sp_csa_table_column_add
13 @table_name = 'repdef',
14 @new_column_name = 'JasperPath',
15 @new_column_datatype = 'ut_txtstr',
16 @new_column_allow_nulls = 1,
17 @new_column_default_value = NULL
18
19exec sp_csa_table_column_add
20 @table_name = 'repdef',
21 @new_column_name = 'JasperResource',
22 @new_column_datatype = 'ut_txtstr',
23 @new_column_allow_nulls = 1,
24 @new_column_default_value = NULL
25
26IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 3)
27begin
28 EXEC sp_addextendedproperty
29 @name = N'MS_Description',
30 @value = '[Deprecated] MS Reporting Services: Use this for the name of the report when using Microsoft reporting services. Deprecated when using JasperSoft reporting.',
31 @level0type = N'Schema', @level0name = 'dbo',
32 @level1type = N'Table', @level1name = 'repdef',
33 @level2type = N'Column', @level2name = 'repnam';
34end
35
36IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 4)
37begin
38 EXEC sp_addextendedproperty
39 @name = N'MS_Description',
40 @value = 'This is the report title, not a description.',
41 @level0type = N'Schema', @level0name = 'dbo',
42 @level1type = N'Table', @level1name = 'repdef',
43 @level2type = N'Column', @level2name = 'repdes';
44end
45
46IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 66)
47begin
48 EXEC sp_addextendedproperty
49 @name = N'MS_Description',
50 @value = '[Deprecated] VB Reports: Use this for the name of the executable to run when using VB reports. Deprecated.',
51 @level0type = N'Schema', @level0name = 'dbo',
52 @level1type = N'Table', @level1name = 'repdef',
53 @level2type = N'Column', @level2name = 'prgnam';
54end
55
56IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 67)
57begin
58 EXEC sp_addextendedproperty
59 @name = N'MS_Description',
60 @value = '[Deprecated] MS Reporting Services: Use this for the path to the report when using Microsoft reporting services. Deprecated when using JasperSoft reporting.',
61 @level0type = N'Schema', @level0name = 'dbo',
62 @level1type = N'Table', @level1name = 'repdef',
63 @level2type = N'Column', @level2name = 'webpath';
64end
65
66IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 68)
67begin
68 EXEC sp_addextendedproperty
69 @name = N'MS_Description',
70 @value = '[Deprecated] VB Report parameters form: Use this to define a period when using VB report filter page. Deprecated when using Reporting App.',
71 @level0type = N'Schema', @level0name = 'dbo',
72 @level1type = N'Table', @level1name = 'repdef',
73 @level2type = N'Column', @level2name = 'perreq';
74end
75
76IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 69)
77begin
78 EXEC sp_addextendedproperty
79 @name = N'MS_Description',
80 @value = '[Deprecated] VB Report parameters form: Use this to state all buttons needed when using VB report filter page. Deprecated when using Reporting App.',
81 @level0type = N'Schema', @level0name = 'dbo',
82 @level1type = N'Table', @level1name = 'repdef',
83 @level2type = N'Column', @level2name = 'allbtn';
84end
85
86IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 72)
87begin
88 EXEC sp_addextendedproperty
89 @name = N'MS_Description',
90 @value = 'JapserSoft: Use this to provide a full description of the report when using JasperSoft.',
91 @level0type = N'Schema', @level0name = 'dbo',
92 @level1type = N'Table', @level1name = 'repdef',
93 @level2type = N'Column', @level2name = 'report_description';
94end
95
96IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 73)
97begin
98 EXEC sp_addextendedproperty
99 @name = N'MS_Description',
100 @value = 'JapserSoft: Use this to set the JasperSoft resource path.',
101 @level0type = N'Schema', @level0name = 'dbo',
102 @level1type = N'Table', @level1name = 'repdef',
103 @level2type = N'Column', @level2name = 'JasperPath';
104end
105
106IF NOT EXISTS (SELECT * FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('repdef') AND [name] = N'MS_Description' AND [minor_id] = 74)
107begin
108 EXEC sp_addextendedproperty
109 @name = N'MS_Description',
110 @value = 'JapserSoft: Use this to set the JasperSoft resource name.',
111 @level0type = N'Schema', @level0name = 'dbo',
112 @level1type = N'Table', @level1name = 'repdef',
113 @level2type = N'Column', @level2name = 'JasperResource';
114end
115
116
117
118Table drop/create:
119
120/******************************************************************************/
121/* */
122/* Central Systems & Automation Ltd. Copyright (c) 1999 - 2014 */
123/* Registered in England Reg. No. : 2209595 */
124/* */
125/******************************************************************************/
126
127/* Drop the table if it already exists. */
128IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'repdef')
129 BEGIN
130 PRINT 'Dropping Table repdef'
131 DROP Table repdef
132 END
133GO
134
135/* Create the new table. */
136PRINT 'Creating Table repdef'
137GO
138CREATE TABLE dbo.repdef
139(
140 [repnum] [ut_repnum] NOT NULL ,
141 [repgrp] [ut_repgrp] NOT NULL ,
142 [repnam] [ut_repnam] NULL ,
143 [repdes] [ut_txtnum] NULL ,
144 [numarg] [ut_reparg] NULL ,
145 [repti1] [ut_txtnum] NULL ,
146 [repty1] [ut_reptyp] NULL ,
147 [repaff1] [ut_repcol] NULL ,
148 [repcol1] [ut_repcol] NULL ,
149 [repti2] [ut_txtnum] NULL ,
150 [repty2] [ut_reptyp] NULL ,
151 [repaff2] [ut_repcol] NULL ,
152 [repcol2] [ut_repcol] NULL ,
153 [repti3] [ut_txtnum] NULL ,
154 [repty3] [ut_reptyp] NULL ,
155 [repaff3] [ut_repcol] NULL ,
156 [repcol3] [ut_repcol] NULL ,
157 [repti4] [ut_txtnum] NULL ,
158 [repty4] [ut_reptyp] NULL ,
159 [repaff4] [ut_repcol] NULL ,
160 [repcol4] [ut_repcol] NULL ,
161 [repti5] [ut_txtnum] NULL ,
162 [repty5] [ut_reptyp] NULL ,
163 [repaff5] [ut_repcol] NULL ,
164 [repcol5] [ut_repcol] NULL ,
165 [repti6] [ut_txtnum] NULL ,
166 [repty6] [ut_reptyp] NULL ,
167 [repaff6] [ut_repcol] NULL ,
168 [repcol6] [ut_repcol] NULL ,
169 [repti7] [ut_txtnum] NULL ,
170 [repty7] [ut_reptyp] NULL ,
171 [repaff7] [ut_repcol] NULL ,
172 [repcol7] [ut_repcol] NULL ,
173 [repti8] [ut_txtnum] NULL ,
174 [repty8] [ut_reptyp] NULL ,
175 [repaff8] [ut_repcol] NULL ,
176 [repcol8] [ut_repcol] NULL ,
177 [repti9] [ut_txtnum] NULL,
178 [repty9] [ut_reptyp] NULL,
179 [repaff9] [ut_repcol] NULL,
180 [repcol9] [ut_repcol] NULL,
181 [reptiA] [ut_txtnum] NULL,
182 [reptyA] [ut_reptyp] NULL,
183 [repaffA] [ut_repcol] NULL,
184 [repcolA] [ut_repcol] NULL,
185 [reptiB] [ut_txtnum] NULL,
186 [reptyB] [ut_reptyp] NULL,
187 [repaffB] [ut_repcol] NULL,
188 [repcolB] [ut_repcol] NULL,
189 [reptiC] [ut_txtnum] NULL,
190 [reptyC] [ut_reptyp] NULL,
191 [repaffC] [ut_repcol] NULL,
192 [repcolC] [ut_repcol] NULL,
193 [reptiD] [ut_txtnum] NULL,
194 [reptyD] [ut_reptyp] NULL,
195 [repaffD] [ut_repcol] NULL,
196 [repcolD] [ut_repcol] NULL,
197 [reptiE] [ut_txtnum] NULL,
198 [reptyE] [ut_reptyp] NULL,
199 [repaffE] [ut_repcol] NULL,
200 [repcolE] [ut_repcol] NULL,
201 [reptiF] [ut_txtnum] NULL,
202 [reptyF] [ut_reptyp] NULL,
203 [repaffF] [ut_repcol] NULL,
204 [repcolF] [ut_repcol] NULL,
205 [prgnam] [ut_repprg] NULL ,
206 [webpath] [ut_web_reports_path] NULL,
207 [perreq] [ut_repper] NULL ,
208 [allbtn] [ut_repallbuttons] NULL ,
209 [perwar] [ut_perlim] NULL ,
210 [permax] [ut_perlim] NULL ,
211 [report_description] [ut_txtnum] NULL ,
212 [JasperPath] [ut_txtstr] NULL ,
213 [JasperResource] [ut_txtstr] NULL ,
214 CONSTRAINT pk_repdef PRIMARY KEY CLUSTERED (repnum, repgrp)
215)
216GO
217
218
219
220
221Populate:
222
223SET NOCOUNT ON
224
225-- Set up the temporary table for the data merge.
226SELECT repnum, repgrp, repnam, repdes, numarg, repti1, repty1, repaff1, repcol1, repti2, repty2, repaff2, repcol2, repti3, repty3, repaff3, repcol3, repti4, repty4, repaff4, repcol4, repti5, repty5, repaff5, repcol5, repti6, repty6, repaff6, repcol6, repti7, repty7, repaff7, repcol7, repti8, repty8, repaff8, repcol8, repti9, repty9, repaff9, repcol9, reptiA, reptyA, repaffA, repcolA, reptiB, reptyB, repaffB, repcolB, reptiC, reptyC, repaffC, repcolC, reptiD, reptyD, repaffD, repcolD, reptiE, reptyE, repaffE, repcolE, reptiF, reptyF, repaffF, repcolF, prgnam, webpath, perreq, allbtn, perwar, permax, report_description, JasperPath, JasperResource
227INTO #repdef
228FROM repdef
229WHERE 1 = 0
230
231
232-- Insert your new data in the correct place below.
233INSERT INTO #repdef VALUES (1, 1, 'EIRDocRep', 70014, 1, 70150, 2011, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'EIRReport.exe', null, 0, 1, null, null, 72007, null, null);
234INSERT INTO #repdef VALUES (2, 0, 'ConInvRep', 70003, 8, 70100, 1008, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, 70104, 1004, null, null, 4015, 1023, null, null, 70106, 999, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'coninv.exe', '/CMS/Dev_CMS/General Reports/coninv', 0, 7, null, null, 72008, null, null);
235INSERT INTO #repdef VALUES (3, 0, 'ConBalRep', 70005, 5, 70100, 1008, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'conbal.exe', '/CMS/Dev_CMS/General Reports/conbal', 0, 7, null, null, 72009, null, null);
236INSERT INTO #repdef VALUES (4, 0, 'ConHisRep', 70006, 1, 70109, 2, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'conhis.exe', '/CMS/Dev_CMS/General Reports/conhis', 102, 7, null, null, 72010, null, null);
237INSERT INTO #repdef VALUES (5, 4, 'PerformRep', 70007, 2, 70894, 1049, '1083', 'lh.shipping_line', 70152, 1083, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'performance.exe', '/CMS/Dev_CMS/General Reports/performance', 12, 7, null, null, 72011, null, null);
238INSERT INTO #repdef VALUES (6, 2, 'ThrPutRep', 70008, 1, 26345, 1033, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'thruput.exe', '/CMS/Dev_CMS/Vessel Reports/thruput', 12, 7, null, null, 72012, null, null);
239INSERT INTO #repdef VALUES (7, 3, 'RailThrPutRep', 70033, 1, 26346, 1034, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'thruputrail.exe', '/CMS/Dev_CMS/Rail Reports/ThruPutRail', 12, 7, null, null, 72013, null, null);
240INSERT INTO #repdef VALUES (8, 0, 'FruExImRep', 70009, 2, 70100, 1008, null, null, 26283, 1031, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'frustrated.exe', '/CMS/Dev_CMS/General Reports/frustrated', 0, 7, null, null, 72014, null, null);
241INSERT INTO #repdef VALUES (9, 1, 'EIRTallyRep', 70010, 4, 70100, 1008, null, null, 70114, 999, null, null, 70115, 1006, null, null, 70102, 1002, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'eirtally.exe', '/CMS/Dev_CMS/Road Reports/eirtally', 12, 7, null, null, 72015, null, null);
242INSERT INTO #repdef VALUES (10, 0, 'ConDwTRep', 70011, 10, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, 26265, 1004, null, null, 31381, 1042, null, null, 70111, 999, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'condwltime.exe', '/CMS/Dev_CMS/General Reports/condwltime', 2, 7, null, null, 72016, null, null);
243INSERT INTO #repdef VALUES (11, 1, 'VehDwTRep', 70012, 3, 70100, 1008, null, null, 70137, 1028, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'vcldwelltime.exe', '/CMS/Dev_CMS/Road Reports/vcldwelltime', 2, 7, null, null, 72017, null, null);
244INSERT INTO #repdef VALUES (12, 0, 'LocUseRep', 70013, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'locuse.exe', '/CMS/Dev_CMS/General Reports/locuse', 0, 7, null, null, 72018, null, null);
245INSERT INTO #repdef VALUES (13, 1, 'GHouseRep', 70015, 2, 70100, 1008, null, null, 26105, 1028, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'GatHse.exe', '/CMS/Dev_CMS/Road Reports/GatHse', 12, 7, null, null, 72019, null, null);
246INSERT INTO #repdef VALUES (14, 8, 'Alarms', 70080, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'alarms.exe', '/CMS/Dev_CMS/System Reports/alarms', 12, 7, null, null, 72020, null, null);
247INSERT INTO #repdef VALUES (15, 8, 'UsrAct', 70081, 3, 70800, 1007, null, null, 2102, 1064, null, null, 111, 1063, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'usract.exe', '/CMS/Dev_CMS/System Reports/usract', 12, 7, null, null, 72021, null, null);
248INSERT INTO #repdef VALUES (16, 2, 'VLoadList', 70016, 7, 26283, 1031, '1084', 'lh.shipping_line', 70152, 1084, null, null, 70175, 1020, null, null, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70107, 1001, null, null, 26031, 1039, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessLoad.exe', '/CMS/Dev_CMS/Vessel Reports/VessLoad', 0, 7, null, null, 72022, null, null);
249INSERT INTO #repdef VALUES (17, 2, 'VDischargeList', 70017, 7, 26283, 1031, '1021', 'lh.shipping_line', 70152, 1021, null, null, 70175, 1022, null, null, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessDischarge.exe', '/CMS/Dev_CMS/Vessel Reports/VessDischarge', 0, 7, null, null, 72023, null, null);
250INSERT INTO #repdef VALUES (19, 3, 'RLoadList', 70024, 7, 26283, 1032, '1024', 'lh.shipping_line', 30455, 1024, null, null, 70175, 1020, null, null, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RailLoad.exe', '/CMS/Dev_CMS/Rail Reports/RailLoad', 0, 7, null, null, 72024, null, null);
251INSERT INTO #repdef VALUES (20, 3, 'RDischargeList', 70025, 7, 26283, 1032, '1025', 'lh.shipping_line', 30455, 1025, null, null, 70175, 1022, null, null, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RailDischarge.exe', '/CMS/Dev_CMS/Rail Reports/RailDischarge', 0, 7, null, null, 72025, null, null);
252INSERT INTO #repdef VALUES (21, 1, 'AvgVehDwTRep', 70028, 4, 70100, 1008, '0', null, 70070, 1035, null, null, 70137, 1028, null, null, 70265, 1499, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'AvgVclDwell.exe', '/CMS/Dev_CMS/Road Reports/AvgVclDwell', 12, 7, null, null, 72026, null, null);
253INSERT INTO #repdef VALUES (22, 1, 'LorriesPerHour', 70029, 3, 70100, 1008, null, null, 70137, 1028, null, null, 70265, 1499, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'LorriesPerHour.exe', '/CMS/Dev_CMS/Road Reports/LorriesPerHour', 12, 7, null, null, 72027, null, null);
254INSERT INTO #repdef VALUES (23, 0, 'StorageTimes', 70031, 1, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'StorageTimes.exe', '/CMS/Dev_CMS/General Reports/StorageTimes', 12, 7, null, null, 72028, null, null);
255INSERT INTO #repdef VALUES (24, 4, 'AvgStorageTime', 70030, 5, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70102, 1002, null, null, 70103, 1003, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'AvgStorageTime.exe', '/CMS/Dev_CMS/General Reports/AvgStorageTime', 12, 7, null, null, 72029, null, null);
256INSERT INTO #repdef VALUES (25, 4, 'Moves', 70032, 1, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Moves.exe', '/CMS/Dev_CMS/General Reports/Moves', 12, 7, null, null, 72030, null, null);
257INSERT INTO #repdef VALUES (26, 3, 'RailWagons', 70034, 2, 30455, 1024, null, null, 30287, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RailWagons.exe', '/CMS/Dev_CMS/Rail Reports/RailWagons', 0, 7, null, null, 72031, null, null);
258INSERT INTO #repdef VALUES (27, 1, 'Hazreport', 70040, 1, 70150, 2011, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Hazreport.exe', null, 0, 1, null, null, 72032, null, null);
259INSERT INTO #repdef VALUES (28, 9, 'InvoiceRep', 70051, 2, 26465, 2, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Invoice.exe', '/CMS/Dev_CMS/File-Data Reports/Invoice', 0, 7, null, null, 72033, null, null);
260INSERT INTO #repdef VALUES (29, 4, 'MovesSummary', 70053, 3, 70100, 1008, null, null, 70250, 1057, null, null, 70198, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MovesSummary.exe', '/CMS/Dev_CMS/General Reports/movementsummary', 12, 7, null, null, 72034, null, null);
261INSERT INTO #repdef VALUES (30, 9, 'TEUConRep', 70052, 1, 26465, 2, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TEUCon.exe', '/CMS/Dev_CMS/File-Data Reports/TEUCon', 0, 7, null, null, 72035, null, null);
262INSERT INTO #repdef VALUES (31, 0, 'ConInvContRep', 70063, 8, 70100, 1008, null, null, 70101, 3, null, null, 50026, 1, null, null, 70103, 1003, null, null, 70104, 1004, null, null, 4015, 1023, null, null, 70106, 999, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'coninvcont.exe', '/CMS/Dev_CMS/General Reports/coninvcont', 0, 7, null, null, 72036, null, null);
263INSERT INTO #repdef VALUES (32, 0, 'ConInspectRep', 70074, 4, 70100, 1008, null, null, 70070, 1035, null, null, 70109, 1, null, null, 70077, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'coninspect.exe', '/CMS/Dev_CMS/General Reports/coninspect', 112, 7, null, null, 72037, null, null);
264INSERT INTO #repdef VALUES (33, 2, 'VLoadTally', 70087, 5, 26283, 1031, '1084', 'lh.shipping_line', 70152, 1084, '1039', 'lh.lodref', 70175, 1020, null, null, 70107, 1001, null, null, 26031, 1039, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessLoadTally.exe', '/CMS/Dev_CMS/Vessel Reports/VessLoadTally', 0, 7, null, null, 72038, null, null);
265INSERT INTO #repdef VALUES (34, 2, 'VDischargeTally', 70088, 5, 26283, 1031, '1021', 'lh.shipping_line', 70152, 1021, '1039', 'lh.lodref', 70175, 1022, null, null, 70107, 1001, null, null, 26031, 1039, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessDischargeTally.exe', '/CMS/Dev_CMS/Vessel Reports/VessDischargeTally', 0, 7, null, null, 72039, null, null);
266INSERT INTO #repdef VALUES (35, 2, 'VGeneralStmt', 70467, 4, 26283, 1031, '1084', 'lh.shipping_line', 70152, 1084, '1039', 'lh.lodref', 70135, 1040, null, null, 26031, 1039, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessGeneral.exe', '/CMS/Dev_CMS/Vessel Reports/VessGeneral', 0, 7, null, null, 72040, null, null);
267INSERT INTO #repdef VALUES (36, 0, 'ContainerEnquiry', 30100, 2, 70109, 2, null, null, 30301, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ContainerEnquiry.exe', '/CMS/Dev_CMS/General Reports/ContainerEnquiry', 0, 7, null, null, 72041, null, null);
268INSERT INTO #repdef VALUES (37, 3, 'VesselSignOff', 70205, 2, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VesselSignOff.exe', '/CMS/Dev_CMS/Rail Reports/VesselSignOff', 0, 7, null, null, 72042, null, null);
269INSERT INTO #repdef VALUES (38, 3, 'VesselCatchers', 70214, 2, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VesselCatchers.exe', '/CMS/Dev_CMS/Rail Reports/VesselCatchers', 0, 7, null, null, 72043, null, null);
270INSERT INTO #repdef VALUES (39, 3, 'RailListLoadedStatus', 70216, 3, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RailLoadListLoadedStatus.exe', '/CMS/Dev_CMS/Rail Reports/RailLoadListLoadedStatus', 0, 7, null, null, 72044, null, null);
271INSERT INTO #repdef VALUES (40, 3, 'RailLoadList', 70223, 3, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RailLoadList.exe', '/CMS/Dev_CMS/Rail Reports/RailLoadList', 0, 7, null, null, 72045, null, null);
272INSERT INTO #repdef VALUES (41, 3, 'DocumentsSignOff', 70224, 2, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'DocumentsSignOff.exe', '/CMS/Dev_CMS/Rail Reports/DocumentsSignOff', 0, 7, null, null, 72046, null, null);
273INSERT INTO #repdef VALUES (42, 3, 'HazardousChecklist', 70225, 2, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'HazardousChecklist.exe', '/CMS/Dev_CMS/Rail Reports/HazardousChecklist', 0, 7, null, null, 72047, null, null);
274INSERT INTO #repdef VALUES (43, 3, 'TrainLoading', 70230, 3, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, 30287, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TrainLoading.exe', '/CMS/Dev_CMS/Rail Reports/TrainLoading', 0, 7, null, null, 72048, null, null);
275INSERT INTO #repdef VALUES (44, 4, 'ConMoves', 70468, 2, 70100, 1008, null, null, 70102, 1002, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConMoves.exe', '/CMS/Dev_CMS/General Reports/ConMoves', 112, 7, null, null, 72049, null, null);
276INSERT INTO #repdef VALUES (45, 0, 'ConInvBySL', 70615, 4, 70100, 1008, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70175, 1020, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConInvBySL.exe', '/CMS/Dev_CMS/General Reports/coninvbyshippingline', 0, 7, null, null, 72050, null, null);
277INSERT INTO #repdef VALUES (46, 4, 'ConMoves2', 70242, 3, 70100, 1008, null, null, 70102, 1002, null, null, 70210, 2001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConMoves2.exe', '/CMS/Dev_CMS/General Reports/ConMoves2', 112, 7, null, null, 72051, null, null);
278INSERT INTO #repdef VALUES (47, 3, 'TrainLoadingFullUK', 70240, 3, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, 30287, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TrainLoadingFullUK.exe', '/CMS/Dev_CMS/Rail Reports/TrainLoadingFullUK', 0, 7, null, null, 72052, null, null);
279INSERT INTO #repdef VALUES (48, 3, 'TrainLoadingFullChan', 70241, 3, 70236, 1042, '1043', 'cdenum', 70196, 1043, null, null, 30287, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TrainLoadingFullChan.exe', '/CMS/Dev_CMS/Rail Reports/TrainLoadingFullChan', 0, 7, null, null, 72053, null, null);
280INSERT INTO #repdef VALUES (49, 3, 'TrainDesk', 70540, 1, 26283, 1032, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TrainDesk.exe', '/CMS/Dev_CMS/Rail Reports/TrainDesk', 0, 7, null, null, 72054, null, null);
281INSERT INTO #repdef VALUES (50, 1, 'LorriesPerDay', 70560, 5, 70100, 1008, null, null, 70137, 1028, null, null, 70070, 1035, null, null, 26044, 1058, null, null, 70101, 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'LorriesPerDay.exe', '/CMS/Dev_CMS/Road Reports/LorriesPerDay', 12, 7, null, null, 72055, null, null);
282INSERT INTO #repdef VALUES (51, 1, 'VehDwTSummary', 70260, 3, 70100, 1008, null, null, 70137, 1028, null, null, 70264, 2004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'vehdwtsummary.exe', '/CMS/Dev_CMS/Road Reports/vehdwtsummary', 112, 7, null, null, 72056, null, null);
283INSERT INTO #repdef VALUES (52, 4, 'MovesPerHour', 70267, 2, 70100, 1008, null, null, 70265, 1499, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MovesPerHour.exe', '/CMS/Dev_CMS/General Reports/movesperhour', 12, 7, null, null, 72057, null, null);
284INSERT INTO #repdef VALUES (53, 9, 'MSCConStsRep', 70272, 1, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MSCConSts.exe', '/CMS/Dev_CMS/File-Data Reports/MSCConStsRep', 112, 7, null, null, 72058, null, null);
285INSERT INTO #repdef VALUES (54, 4, 'ConMovesPins', 70475, 3, 70100, 1008, null, null, 70102, 1002, null, null, 70210, 2001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConMovesPins.exe', '/CMS/Dev_CMS/General Reports/ConMovesPins', 112, 7, null, null, 72059, null, null);
286INSERT INTO #repdef VALUES (55, 0, 'ConInvWithBookingRef', 70476, 8, 70100, 1008, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, 70104, 1004, null, null, 4015, 1023, null, null, 70106, 999, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'None', '/CMS/Dev_CMS/General Reports/Container Inventory With Booking Ref', 0, 7, null, null, 72060, null, null);
287INSERT INTO #repdef VALUES (56, 0, 'ConHaz', 31345, 5, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 30146, 1, null, null, 30147, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'None', '/CMS/Dev_CMS/General Reports/Container Hazardous', 0, 7, null, null, 72061, null, null);
288INSERT INTO #repdef VALUES (57, 3, 'RDischargeListDiscrp', 70477, 6, 26283, 1032, '1025', 'lh.shipping_line', 30455, 1025, null, null, 70100, 1008, null, null, 26280, 1036, null, null, 26281, 1035, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'RDischargeListDiscrp.exe', '/CMS/Dev_CMS/Rail Reports/RailDischargeDiscrep', 0, 7, null, null, 72062, null, null);
289INSERT INTO #repdef VALUES (58, 9, 'InvoiceSpecificRep', 70478, 3, 26465, 2, null, null, 70107, 1001, null, null, 70479, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'InvoiceSpecific.exe', '/CMS/Dev_CMS/File-Data Reports/InvoiceSpecific', 0, 7, null, null, 72063, null, null);
290INSERT INTO #repdef VALUES (59, 4, 'MovesSummaryOC', 70561, 3, 70100, 1008, null, null, 70250, 1057, null, null, 70198, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/MovementSummaryOwnerChange', 12, 7, null, null, 72064, null, null);
291INSERT INTO #repdef VALUES (60, 1, 'EIRDocRepWeb', 70814, 1, 70150, 2011, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'EIRReport.exe', '/CMS/Dev_CMS/Road Reports/EIRReport', 0, 7, null, null, 72065, null, null);
292INSERT INTO #repdef VALUES (61, 0, 'ConInvStmt', 70824, 2, 70100, 1008, null, null, 70070, 1035, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/coninv_stmt', 0, 7, null, null, 72066, null, null);
293INSERT INTO #repdef VALUES (62, 4, 'conoper', 70825, 2, 70070, 1035, null, null, 70826, 1059, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/conoper', 112, 7, null, null, 72067, null, null);
294INSERT INTO #repdef VALUES (63, 4, 'SlineThrPut', 70828, 3, 70502, 1008, null, null, 26283, 1049, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/Shipping Line Throughput', 112, 7, null, null, 72068, null, null);
295INSERT INTO #repdef VALUES (64, 0, 'ConinvDetention', 70282, 3, 70283, 2006, null, null, 70100, 1008, null, null, 70102, 1002, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConinvDetention.exe', '/CMS/Dev_CMS/General Reports/coninvdetention', 0, 7, null, null, 72069, null, null);
296INSERT INTO #repdef VALUES (65, 4, 'MHE Performance', 70835, 10, 2102, 1010, null, null, 70832, 1062, null, null, 70836, 1061, null, null, 70100, 1008, null, null, 70837, 1042, null, null, 70838, 1042, null, null, 70839, 1042, null, null, 70840, 1042, null, null, 70841, 1042, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MHEPerfRep.exe', '/CMS/Dev_CMS/General Reports/MHE performance', 112, 7, null, null, 72070, null, null);
297INSERT INTO #repdef VALUES (66, 4, 'MHE Moves', 70860, 4, 2102, 1064, null, null, 4104, 1062, null, null, 4268, 1067, null, null, 70836, 1061, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MHEMovesRep.exe', '/CMS/Dev_CMS/General Reports/MHE moves', 112, 7, null, null, 72071, null, null);
298INSERT INTO #repdef VALUES (67, 4, 'Container Throughput', 70617, 1, 70066, 1065, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/Container Throughput', 12, 7, null, null, 72072, null, null);
299INSERT INTO #repdef VALUES (68, 3, 'TrainDischrgFullChan', 70864, 3, 70236, 1042, '1066', 'cdenum', 70196, 1066, null, null, 30287, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '/CMS/Dev_CMS/Rail Reports/TrainDischrgFullChan', 0, 7, null, null, 72073, null, null);
300INSERT INTO #repdef VALUES (69, 9, 'CustomsAuditFile', 70866, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/File-Data Reports/CustomsAuditFile', 112, 4, null, null, 72074, null, null);
301INSERT INTO #repdef VALUES (70, 4, 'ConStsChangeByLoc', 70872, 1, 70100, 1008, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ConStsChangeByLocation', 112, 4, null, null, 72075, null, null);
302INSERT INTO #repdef VALUES (71, 0, 'HazardContRep', 70867, 6, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, 31442, 2001, null, null, 30147, 2001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/HazardContRep', 0, 7, null, null, 72076, null, null);
303INSERT INTO #repdef VALUES (72, 0, 'ConHisSummRep', 70873, 1, 70109, 2, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/conhis_summary', 0, 7, null, null, 72077, null, null);
304INSERT INTO #repdef VALUES (73, 2, 'VLoadManifest', 70879, 8, 26283, 1031, '1084', 'lh.shipping_line', 70152, 1084, '1039', 'lh.lodref', 26109, 1039, null, null, 70175, 1020, null, null, 70100, 1008, null, null, 71030, 1004, null, null, 70103, 1071, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessLoadManifest.exe', '/CMS/Dev_CMS/Vessel Reports/VessLoadManifest', 0, 7, null, null, 72078, null, null);
305INSERT INTO #repdef VALUES (74, 2, 'VDischargeManifest', 70877, 8, 26283, 1031, '1021', 'lh.shipping_line', 70152, 1021, '1039', 'lh.lodref', 26109, 1039, null, null, 70175, 1022, null, null, 70100, 1008, null, null, 71030, 1004, null, null, 70103, 1071, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'VessDischargeManifest.exe', '/CMS/Dev_CMS/Vessel Reports/VessDischargeManifest', 0, 7, null, null, 72079, null, null);
306INSERT INTO #repdef VALUES (75, 0, 'ConPluginRep', 70881, 4, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ConPluginRep', 0, 7, null, null, 72080, null, null);
307INSERT INTO #repdef VALUES (76, 4, 'ConOperRep', 70882, 5, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, 70826, 1059, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ConOperRep', 112, 7, null, null, 72081, null, null);
308INSERT INTO #repdef VALUES (77, 1, 'VehDwTBookedRep', 70883, 3, 70100, 1008, null, null, 70137, 1028, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'n/a', '/CMS/Dev_CMS/Road Reports/vcldwellbookedtime', 2, 7, null, null, 72082, null, null);
309INSERT INTO #repdef VALUES (78, 2, 'VesselPerformanceExt', 70957, 3, 26283, 1031, '1084', 'shipping_line', 70152, 1084, null, null, 70955, 1076, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Vessel Reports/VessPerformance', 0, 7, null, null, 72083, null, null);
310INSERT INTO #repdef VALUES (79, 2, 'VesselPerformanceInt', 70956, 3, 26283, 1031, '1084', 'shipping_line', 70152, 1084, null, null, 70955, 1077, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Vessel Reports/VessPerformance', 0, 7, null, null, 72084, null, null);
311INSERT INTO #repdef VALUES (80, 4, 'ConOutMoves', 70958, 10, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, 70065, 1002, null, null, 70103, 1003, null, null, 70058, 1055, null, null, 70123, 1004, null, null, 70104, 1004, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ConOutMoves', 112, 7, null, null, 72085, null, null);
312INSERT INTO #repdef VALUES (81, 2, 'thruput_dg_oog', 70963, 2, 70894, 1033, '1083', 'lh.shipping_line', 70152, 1083, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Vessel Reports/thruput_dg_oog', 112, 7, null, null, 72086, null, null);
313INSERT INTO #repdef VALUES (82, 9, 'StoreLiftRep', 71031, 4, 26341, 1026, '1027', 'clientcategory', 26342, 1027, null, null, 26465, 1, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/File-Data Reports/StoreLiftRep', 102, 7, null, null, 72087, null, null);
314INSERT INTO #repdef VALUES (83, 9, 'HazContainerFile', 70971, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/File-Data Reports/HazContainerFile', 0, 7, null, null, 72088, null, null);
315INSERT INTO #repdef VALUES (84, 1, 'GateHouseRep', 70972, 2, 70100, 1008, null, null, 26105, 1028, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Road Reports/GateHouseLog', 12, 7, null, null, 72089, null, null);
316INSERT INTO #repdef VALUES (85, 0, 'StockReport', 70990, 4, 70100, 1053, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/StockReport', 0, 7, null, null, 72090, null, null);
317INSERT INTO #repdef VALUES (86, 4, 'ConHandlingMoves', 70991, 9, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, 70065, 1002, null, null, 70103, 1003, null, null, 70058, 1080, null, null, 70123, 1004, null, null, 70104, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ConHandlingMoves', 112, 7, null, null, 72091, null, null);
318INSERT INTO #repdef VALUES (87, 2, 'Mother Vessel Load', 70992, 2, 26283, 1033, '1082', 'lh.shipping_line', 70152, 1082, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MotherVesselLoad.exe', '/CMS/Dev_CMS/Vessel Reports/MotherVesselLoad', 0, 7, null, null, 72092, null, null);
319INSERT INTO #repdef VALUES (88, 2, 'Mother Vessel Disch', 70993, 2, 26283, 1033, '1081', 'lh.shipping_line', 70152, 1081, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'MotherVesselDischarge.exe', '/CMS/Dev_CMS/Vessel Reports/MotherVesselDischarge', 0, 7, null, null, 72093, null, null);
320INSERT INTO #repdef VALUES (89, 4, 'ConMoves3', 71170, 3, 70100, 1008, null, null, 70102, 1002, null, null, 70210, 2001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ConMoves3.exe', '/CMS/Dev_CMS/General Reports/ConMoves3', 112, 7, null, null, 72094, null, null);
321INSERT INTO #repdef VALUES (90, 2, 'StatementOfFact', 71200, 3, 26283, 1031, '1084', 'shipping_line', 70152, 1084, null, null, 31101, 1042, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Vessel Reports/StatementOfFact', 0, 7, null, null, 72095, null, null);
322INSERT INTO #repdef VALUES (91, 4, 'ContainerPlugin', 71273, 4, 70100, 1008, null, null, 70070, 1035, null, null, 70109, 1, null, null, 70077, 1004, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/ContainerPlugin', 112, 7, null, null, 72096, null, null);
323INSERT INTO #repdef VALUES (92, 1, 'TripTicketRep', 71274, 2, 71275, 1085, null, null, 71275, 1086, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Road Reports/TripTicket', 112, 7, null, null, 72097, null, null);
324INSERT INTO #repdef VALUES (93, 1, 'CARGODESPATCHNOTE', 71289, 2, 21782, 1028, null, null, 4124, 3, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'NA', '/CMS/Dev_CMS/Road Reports/CARGODESPATCHNOTE', 112, 7, null, null, 72098, null, null);
325INSERT INTO #repdef VALUES (94, 0, 'ContainerInvVGM', 71290, 9, 70100, 1008, null, null, 70101, 3, null, null, 70102, 1002, null, null, 70103, 1003, null, null, 70104, 1004, null, null, 27314, 1004, null, null, 4015, 1023, null, null, 70106, 999, null, null, 70107, 1001, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'NA', '/CMS/Dev_CMS/General Reports/Container Inventory VGM', 0, 7, null, null, 72099, null, null);
326INSERT INTO #repdef VALUES (95, 0, 'ReeferStocklist', 71292, 6, 70109, 1, null, null, 70100, 1008, null, null, 70071, 1036, null, null, 70070, 1035, null, null, 70239, 1068, null, null, 70152, 1060, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'N/A', '/CMS/Dev_CMS/General Reports/Reefer Stocklist', 102, 7, null, null, 72100, null, null);
327INSERT INTO #repdef VALUES (96, 4, 'ConMovesBillofLading', 70481, 2, 70100, 1008, null, null, 70102, 1002, null, null, 70210, 1002, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'N/A', '/CMS/Dev_CMS/General Reports/ConMovesBillofLading', 112, 7, null, null, 72101, null, null);
328INSERT INTO #repdef VALUES (97, 1, 'WeightReceipt', 72003, 2, 70305, 1085, null, null, 71275, 1086, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/Road Reports/WeightReceipt', 0, 7, null, null, 72102, null, null);
329INSERT INTO #repdef VALUES (98, 0, 'ConBookingsOverview', 71295, 1, 70101, 1088, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'na', '/CMS/Dev_CMS/General Reports/container_bookings_overview', 3, 7, null, null, 72104, null, null);
330INSERT INTO #repdef VALUES (1000, 2, 'TerminalDeparture', 26360, 3, 26283, 1031, '1084', 'lh.shipping_line', 70152, 1084, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'TerminalDeparture.exe', '/CMS/Dev_CMS/Vessel Reports/TerminalDeparture', 0, 7, null, null, 72003, null, null);
331
332-- *************************************************************************
333-- Do not edit anything below this line unless the table schema has changed.
334-- *************************************************************************
335
336-- Update any records that are in the temporary table and in the actual table.
337UPDATE repdef
338SET repdef.repnam = #repdef.repnam
339 , repdef.repdes = #repdef.repdes
340 , repdef.numarg = #repdef.numarg
341 , repdef.repti1 = #repdef.repti1
342 , repdef.repty1 = #repdef.repty1
343 , repdef.repaff1 = #repdef.repaff1
344 , repdef.repcol1 = #repdef.repcol1
345 , repdef.repti2 = #repdef.repti2
346 , repdef.repty2 = #repdef.repty2
347 , repdef.repaff2 = #repdef.repaff2
348 , repdef.repcol2 = #repdef.repcol2
349 , repdef.repti3 = #repdef.repti3
350 , repdef.repty3 = #repdef.repty3
351 , repdef.repaff3 = #repdef.repaff3
352 , repdef.repcol3 = #repdef.repcol3
353 , repdef.repti4 = #repdef.repti4
354 , repdef.repty4 = #repdef.repty4
355 , repdef.repaff4 = #repdef.repaff4
356 , repdef.repcol4 = #repdef.repcol4
357 , repdef.repti5 = #repdef.repti5
358 , repdef.repty5 = #repdef.repty5
359 , repdef.repaff5 = #repdef.repaff5
360 , repdef.repcol5 = #repdef.repcol5
361 , repdef.repti6 = #repdef.repti6
362 , repdef.repty6 = #repdef.repty6
363 , repdef.repaff6 = #repdef.repaff6
364 , repdef.repcol6 = #repdef.repcol6
365 , repdef.repti7 = #repdef.repti7
366 , repdef.repty7 = #repdef.repty7
367 , repdef.repaff7 = #repdef.repaff7
368 , repdef.repcol7 = #repdef.repcol7
369 , repdef.repti8 = #repdef.repti8
370 , repdef.repty8 = #repdef.repty8
371 , repdef.repaff8 = #repdef.repaff8
372 , repdef.repcol8 = #repdef.repcol8
373 , repdef.repti9 = #repdef.repti9
374 , repdef.repty9 = #repdef.repty9
375 , repdef.repaff9 = #repdef.repaff9
376 , repdef.repcol9 = #repdef.repcol9
377 , repdef.reptiA = #repdef.reptiA
378 , repdef.reptyA = #repdef.reptyA
379 , repdef.repaffA = #repdef.repaffA
380 , repdef.repcolA = #repdef.repcolA
381 , repdef.reptiB = #repdef.reptiB
382 , repdef.reptyB = #repdef.reptyB
383 , repdef.repaffB = #repdef.repaffB
384 , repdef.repcolB = #repdef.repcolB
385 , repdef.reptiC = #repdef.reptiC
386 , repdef.reptyC = #repdef.reptyC
387 , repdef.repaffC = #repdef.repaffC
388 , repdef.repcolC = #repdef.repcolC
389 , repdef.reptiD = #repdef.reptiD
390 , repdef.reptyD = #repdef.reptyD
391 , repdef.repaffD = #repdef.repaffD
392 , repdef.repcolD = #repdef.repcolD
393 , repdef.reptiE = #repdef.reptiE
394 , repdef.reptyE = #repdef.reptyE
395 , repdef.repaffE = #repdef.repaffE
396 , repdef.repcolE = #repdef.repcolE
397 , repdef.reptiF = #repdef.reptiF
398 , repdef.reptyF = #repdef.reptyF
399 , repdef.repaffF = #repdef.repaffF
400 , repdef.repcolF = #repdef.repcolF
401 , repdef.prgnam = #repdef.prgnam
402 , repdef.webpath = #repdef.webpath
403 , repdef.perreq = #repdef.perreq
404 , repdef.allbtn = #repdef.allbtn
405 , repdef.perwar = #repdef.perwar
406 , repdef.permax = #repdef.permax
407 , repdef.report_description = #repdef.report_description
408 , repdef.JasperPath = #repdef.JasperPath
409 , repdef.JasperResource = #repdef.JasperResource
410FROM repdef
411INNER JOIN #repdef
412 on repdef.repnum = #repdef.repnum
413 and repdef.repgrp = #repdef.repgrp
414
415-- Insert any records that exist in the temporary table and do not exist in the actaul table.
416INSERT INTO repdef (repnum, repgrp, repnam, repdes, numarg, repti1, repty1, repaff1, repcol1, repti2, repty2, repaff2, repcol2, repti3, repty3, repaff3, repcol3, repti4, repty4, repaff4, repcol4, repti5, repty5, repaff5, repcol5, repti6, repty6, repaff6, repcol6, repti7, repty7, repaff7, repcol7, repti8, repty8, repaff8, repcol8, repti9, repty9, repaff9, repcol9, reptiA, reptyA, repaffA, repcolA, reptiB, reptyB, repaffB, repcolB, reptiC, reptyC, repaffC, repcolC, reptiD, reptyD, repaffD, repcolD, reptiE, reptyE, repaffE, repcolE, reptiF, reptyF, repaffF, repcolF, prgnam, webpath, perreq, allbtn, perwar, permax, report_description, JasperPath, JasperResource)
417SELECT repnum, repgrp, repnam, repdes, numarg, repti1, repty1, repaff1, repcol1, repti2, repty2, repaff2, repcol2, repti3, repty3, repaff3, repcol3, repti4, repty4, repaff4, repcol4, repti5, repty5, repaff5, repcol5, repti6, repty6, repaff6, repcol6, repti7, repty7, repaff7, repcol7, repti8, repty8, repaff8, repcol8, repti9, repty9, repaff9, repcol9, reptiA, reptyA, repaffA, repcolA, reptiB, reptyB, repaffB, repcolB, reptiC, reptyC, repaffC, repcolC, reptiD, reptyD, repaffD, repcolD, reptiE, reptyE, repaffE, repcolE, reptiF, reptyF, repaffF, repcolF, prgnam, webpath, perreq, allbtn, perwar, permax, report_description, JasperPath, JasperResource
418FROM #repdef
419WHERE NOT EXISTS
420(
421 SELECT NULL
422 FROM repdef
423 WHERE repdef.repnum = #repdef.repnum
424 and repdef.repgrp = #repdef.repgrp
425);
426
427DROP TABLE #repdef;