This repository has been archived by the owner on Jun 25, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
dsMySQL2.xsd
281 lines (281 loc) · 56.6 KB
/
dsMySQL2.xsd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsMySQL2" targetNamespace="http://tempuri.org/dsMySQL2.xsd" xmlns:mstns="http://tempuri.org/dsMySQL2.xsd" xmlns="http://tempuri.org/dsMySQL2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="simplyConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="simplyConnectionString1 (MySettings)" PropertyReference="ApplicationSettings.TKSISchedule.MySettings.GlobalReference.Default.simplyConnectionString1" Provider="MySql.Data.MySqlClient" />
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="TKSIJOBSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TKSIJOBSConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TKSISchedule.MySettings.GlobalReference.Default.TKSIJOBSConnectionString" Provider="System.Data.SqlClient" />
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="simplyConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="simplyConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TKSISchedule.MySettings.GlobalReference.Default.simplyConnectionString1" Provider="MySql.Data.MySqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tjourentTableAdapter" GeneratorDataComponentClassName="tjourentTableAdapter" Name="tjourent" UserDataComponentName="tjourentTableAdapter">
<MainSource>
<DbSource ConnectionRef="simplyConnectionString (MySettings)" DbObjectName="simply.tjourent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM `tjourent` WHERE ((`lId` = @Original_lId) AND ((@IsNull_dtASDate = 1 AND `dtASDate` IS NULL) OR (`dtASDate` = @Original_dtASDate)) AND ((@IsNull_tmASTime = 1 AND `tmASTime` IS NULL) OR (`tmASTime` = @Original_tmASTime)) AND ((@IsNull_sASUserId = 1 AND `sASUserId` IS NULL) OR (`sASUserId` = @Original_sASUserId)) AND ((@IsNull_sASOrgId = 1 AND `sASOrgId` IS NULL) OR (`sASOrgId` = @Original_sASOrgId)) AND ((@IsNull_dtJourDate = 1 AND `dtJourDate` IS NULL) OR (`dtJourDate` = @Original_dtJourDate)) AND ((@IsNull_nModule = 1 AND `nModule` IS NULL) OR (`nModule` = @Original_nModule)) AND ((@IsNull_nType = 1 AND `nType` IS NULL) OR (`nType` = @Original_nType)) AND ((@IsNull_sSource = 1 AND `sSource` IS NULL) OR (`sSource` = @Original_sSource)) AND ((@IsNull_sComment = 1 AND `sComment` IS NULL) OR (`sComment` = @Original_sComment)) AND ((@IsNull_lCurrncyId = 1 AND `lCurrncyId` IS NULL) OR (`lCurrncyId` = @Original_lCurrncyId)) AND ((@IsNull_dExchRate = 1 AND `dExchRate` IS NULL) OR (`dExchRate` = @Original_dExchRate)) AND ((@IsNull_lRecId = 1 AND `lRecId` IS NULL) OR (`lRecId` = @Original_lRecId)) AND ((@IsNull_nPymtClass = 1 AND `nPymtClass` IS NULL) OR (`nPymtClass` = @Original_nPymtClass)) AND ((@IsNull_sComment2 = 1 AND `sComment2` IS NULL) OR (`sComment2` = @Original_sComment2)) AND ((@IsNull_dtCmt2Date = 1 AND `dtCmt2Date` IS NULL) OR (`dtCmt2Date` = @Original_dtCmt2Date)) AND ((@IsNull_bExported = 1 AND `bExported` IS NULL) OR (`bExported` = @Original_bExported)) AND (`lCompId` = @Original_lCompId) AND ((@IsNull_bAcctEntry = 1 AND `bAcctEntry` IS NULL) OR (`bAcctEntry` = @Original_bAcctEntry)) AND ((@IsNull_bAEImport = 1 AND `bAEImport` IS NULL) OR (`bAEImport` = @Original_bAEImport)) AND ((@IsNull_bAftYEnd = 1 AND `bAftYEnd` IS NULL) OR (`bAftYEnd` = @Original_bAftYEnd)) AND ((@IsNull_bB4YrStart = 1 AND `bB4YrStart` IS NULL) OR (`bB4YrStart` = @Original_bB4YrStart)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtASDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtASDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tmASTime" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_tmASTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sASUserId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sASUserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sASOrgId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sASOrgId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtJourDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtJourDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nModule" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nModule" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nType" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nType" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sSource" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sSource" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sComment" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sComment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dExchRate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_dExchRate" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nPymtClass" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nPymtClass" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sComment2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sComment2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtCmt2Date" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtCmt2Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bExported" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bExported" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lCompId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCompId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAcctEntry" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAcctEntry" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAEImport" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAEImport" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAftYEnd" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAftYEnd" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bB4YrStart" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bB4YrStart" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO `tjourent` (`lId`, `dtASDate`, `tmASTime`, `sASUserId`, `sASOrgId`, `dtJourDate`, `nModule`, `nType`, `sSource`, `sComment`, `lCurrncyId`, `dExchRate`, `lRecId`, `nPymtClass`, `sComment2`, `dtCmt2Date`, `bExported`, `lCompId`, `bAcctEntry`, `bAEImport`, `bAftYEnd`, `bB4YrStart`) VALUES (@lId, @dtASDate, @tmASTime, @sASUserId, @sASOrgId, @dtJourDate, @nModule, @nType, @sSource, @sComment, @lCurrncyId, @dExchRate, @lRecId, @nPymtClass, @sComment2, @dtCmt2Date, @bExported, @lCompId, @bAcctEntry, @bAEImport, @bAftYEnd, @bB4YrStart)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtASDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tmASTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sASUserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sASOrgId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtJourDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nModule" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nType" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sSource" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sComment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@dExchRate" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nPymtClass" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sComment2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtCmt2Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bExported" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lCompId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCompId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAcctEntry" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAEImport" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAftYEnd" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bB4YrStart" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT `lId`, `dtASDate`, `tmASTime`, `sASUserId`, `sASOrgId`, `dtJourDate`, `nModule`, `nType`, `sSource`, `sComment`, `lCurrncyId`, `dExchRate`, `lRecId`, `nPymtClass`, `sComment2`, `dtCmt2Date`, `bExported`, `lCompId`, `bAcctEntry`, `bAEImport`, `bAftYEnd`, `bB4YrStart` FROM `tjourent`</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE `tjourent` SET `lId` = @lId, `dtASDate` = @dtASDate, `tmASTime` = @tmASTime, `sASUserId` = @sASUserId, `sASOrgId` = @sASOrgId, `dtJourDate` = @dtJourDate, `nModule` = @nModule, `nType` = @nType, `sSource` = @sSource, `sComment` = @sComment, `lCurrncyId` = @lCurrncyId, `dExchRate` = @dExchRate, `lRecId` = @lRecId, `nPymtClass` = @nPymtClass, `sComment2` = @sComment2, `dtCmt2Date` = @dtCmt2Date, `bExported` = @bExported, `lCompId` = @lCompId, `bAcctEntry` = @bAcctEntry, `bAEImport` = @bAEImport, `bAftYEnd` = @bAftYEnd, `bB4YrStart` = @bB4YrStart WHERE ((`lId` = @Original_lId) AND ((@IsNull_dtASDate = 1 AND `dtASDate` IS NULL) OR (`dtASDate` = @Original_dtASDate)) AND ((@IsNull_tmASTime = 1 AND `tmASTime` IS NULL) OR (`tmASTime` = @Original_tmASTime)) AND ((@IsNull_sASUserId = 1 AND `sASUserId` IS NULL) OR (`sASUserId` = @Original_sASUserId)) AND ((@IsNull_sASOrgId = 1 AND `sASOrgId` IS NULL) OR (`sASOrgId` = @Original_sASOrgId)) AND ((@IsNull_dtJourDate = 1 AND `dtJourDate` IS NULL) OR (`dtJourDate` = @Original_dtJourDate)) AND ((@IsNull_nModule = 1 AND `nModule` IS NULL) OR (`nModule` = @Original_nModule)) AND ((@IsNull_nType = 1 AND `nType` IS NULL) OR (`nType` = @Original_nType)) AND ((@IsNull_sSource = 1 AND `sSource` IS NULL) OR (`sSource` = @Original_sSource)) AND ((@IsNull_sComment = 1 AND `sComment` IS NULL) OR (`sComment` = @Original_sComment)) AND ((@IsNull_lCurrncyId = 1 AND `lCurrncyId` IS NULL) OR (`lCurrncyId` = @Original_lCurrncyId)) AND ((@IsNull_dExchRate = 1 AND `dExchRate` IS NULL) OR (`dExchRate` = @Original_dExchRate)) AND ((@IsNull_lRecId = 1 AND `lRecId` IS NULL) OR (`lRecId` = @Original_lRecId)) AND ((@IsNull_nPymtClass = 1 AND `nPymtClass` IS NULL) OR (`nPymtClass` = @Original_nPymtClass)) AND ((@IsNull_sComment2 = 1 AND `sComment2` IS NULL) OR (`sComment2` = @Original_sComment2)) AND ((@IsNull_dtCmt2Date = 1 AND `dtCmt2Date` IS NULL) OR (`dtCmt2Date` = @Original_dtCmt2Date)) AND ((@IsNull_bExported = 1 AND `bExported` IS NULL) OR (`bExported` = @Original_bExported)) AND (`lCompId` = @Original_lCompId) AND ((@IsNull_bAcctEntry = 1 AND `bAcctEntry` IS NULL) OR (`bAcctEntry` = @Original_bAcctEntry)) AND ((@IsNull_bAEImport = 1 AND `bAEImport` IS NULL) OR (`bAEImport` = @Original_bAEImport)) AND ((@IsNull_bAftYEnd = 1 AND `bAftYEnd` IS NULL) OR (`bAftYEnd` = @Original_bAftYEnd)) AND ((@IsNull_bB4YrStart = 1 AND `bB4YrStart` IS NULL) OR (`bB4YrStart` = @Original_bB4YrStart)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtASDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tmASTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sASUserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sASOrgId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtJourDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nModule" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nType" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sSource" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sComment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@dExchRate" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@nPymtClass" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sComment2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtCmt2Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bExported" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lCompId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCompId" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAcctEntry" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAEImport" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bAftYEnd" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@bB4YrStart" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtASDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtASDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtASDate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tmASTime" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_tmASTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tmASTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sASUserId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sASUserId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASUserId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sASOrgId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sASOrgId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sASOrgId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtJourDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtJourDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtJourDate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nModule" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nModule" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nModule" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nType" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nType" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nType" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sSource" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sSource" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sSource" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sComment" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sComment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lCurrncyId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCurrncyId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dExchRate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_dExchRate" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="dExchRate" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lRecId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lRecId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nPymtClass" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_nPymtClass" Precision="0" ProviderType="Int16" Scale="0" Size="0" SourceColumn="nPymtClass" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sComment2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sComment2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sComment2" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtCmt2Date" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtCmt2Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtCmt2Date" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bExported" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bExported" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bExported" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lCompId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lCompId" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAcctEntry" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAcctEntry" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAcctEntry" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAEImport" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAEImport" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAEImport" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bAftYEnd" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bAftYEnd" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bAftYEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bB4YrStart" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_bB4YrStart" Precision="0" ProviderType="UByte" Scale="0" Size="0" SourceColumn="bB4YrStart" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="lId" DataSetColumn="lId" />
<Mapping SourceColumn="dtASDate" DataSetColumn="dtASDate" />
<Mapping SourceColumn="tmASTime" DataSetColumn="tmASTime" />
<Mapping SourceColumn="sASUserId" DataSetColumn="sASUserId" />
<Mapping SourceColumn="sASOrgId" DataSetColumn="sASOrgId" />
<Mapping SourceColumn="dtJourDate" DataSetColumn="dtJourDate" />
<Mapping SourceColumn="nModule" DataSetColumn="nModule" />
<Mapping SourceColumn="nType" DataSetColumn="nType" />
<Mapping SourceColumn="sSource" DataSetColumn="sSource" />
<Mapping SourceColumn="sComment" DataSetColumn="sComment" />
<Mapping SourceColumn="lCurrncyId" DataSetColumn="lCurrncyId" />
<Mapping SourceColumn="dExchRate" DataSetColumn="dExchRate" />
<Mapping SourceColumn="lRecId" DataSetColumn="lRecId" />
<Mapping SourceColumn="nPymtClass" DataSetColumn="nPymtClass" />
<Mapping SourceColumn="sComment2" DataSetColumn="sComment2" />
<Mapping SourceColumn="dtCmt2Date" DataSetColumn="dtCmt2Date" />
<Mapping SourceColumn="bExported" DataSetColumn="bExported" />
<Mapping SourceColumn="lCompId" DataSetColumn="lCompId" />
<Mapping SourceColumn="bAcctEntry" DataSetColumn="bAcctEntry" />
<Mapping SourceColumn="bAEImport" DataSetColumn="bAEImport" />
<Mapping SourceColumn="bAftYEnd" DataSetColumn="bAftYEnd" />
<Mapping SourceColumn="bB4YrStart" DataSetColumn="bB4YrStart" />
</Mappings>
<Sources>
<DbSource ConnectionRef="simplyConnectionString (MySettings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ScalarQueryMaxLID" Modifier="Public" Name="ScalarQueryMaxLID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ScalarQueryMaxLID">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="true">
<CommandText>SELECT MAX(lid) FROM tjourent </CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="dsMySQL2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsMySQL2" msprop:Generator_UserDSName="dsMySQL2">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="tjourent" msprop:Generator_TableClassName="tjourentDataTable" msprop:Generator_TableVarName="tabletjourent" msprop:Generator_TablePropName="tjourent" msprop:Generator_RowDeletingName="tjourentRowDeleting" msprop:Generator_RowChangingName="tjourentRowChanging" msprop:Generator_RowEvHandlerName="tjourentRowChangeEventHandler" msprop:Generator_RowDeletedName="tjourentRowDeleted" msprop:Generator_UserTableName="tjourent" msprop:Generator_RowChangedName="tjourentRowChanged" msprop:Generator_RowEvArgName="tjourentRowChangeEvent" msprop:Generator_RowClassName="tjourentRow">
<xs:complexType>
<xs:sequence>
<xs:element name="lId" msprop:Generator_ColumnVarNameInTable="columnlId" msprop:Generator_ColumnPropNameInRow="lId" msprop:Generator_ColumnPropNameInTable="lIdColumn" msprop:Generator_UserColumnName="lId" type="xs:int" />
<xs:element name="dtASDate" msprop:Generator_ColumnVarNameInTable="columndtASDate" msprop:Generator_ColumnPropNameInRow="dtASDate" msprop:Generator_ColumnPropNameInTable="dtASDateColumn" msprop:Generator_UserColumnName="dtASDate" type="xs:dateTime" minOccurs="0" />
<xs:element name="tmASTime" msprop:Generator_ColumnVarNameInTable="columntmASTime" msprop:Generator_ColumnPropNameInRow="tmASTime" msprop:Generator_ColumnPropNameInTable="tmASTimeColumn" msprop:Generator_UserColumnName="tmASTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="sASUserId" msprop:Generator_ColumnVarNameInTable="columnsASUserId" msprop:Generator_ColumnPropNameInRow="sASUserId" msprop:Generator_ColumnPropNameInTable="sASUserIdColumn" msprop:Generator_UserColumnName="sASUserId" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="14" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sASOrgId" msprop:Generator_ColumnVarNameInTable="columnsASOrgId" msprop:Generator_ColumnPropNameInRow="sASOrgId" msprop:Generator_ColumnPropNameInTable="sASOrgIdColumn" msprop:Generator_UserColumnName="sASOrgId" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="6" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtJourDate" msprop:Generator_ColumnVarNameInTable="columndtJourDate" msprop:Generator_ColumnPropNameInRow="dtJourDate" msprop:Generator_ColumnPropNameInTable="dtJourDateColumn" msprop:Generator_UserColumnName="dtJourDate" type="xs:dateTime" minOccurs="0" />
<xs:element name="nModule" msprop:Generator_ColumnVarNameInTable="columnnModule" msprop:Generator_ColumnPropNameInRow="nModule" msprop:Generator_ColumnPropNameInTable="nModuleColumn" msprop:Generator_UserColumnName="nModule" type="xs:short" minOccurs="0" />
<xs:element name="nType" msprop:Generator_ColumnVarNameInTable="columnnType" msprop:Generator_ColumnPropNameInRow="nType" msprop:Generator_ColumnPropNameInTable="nTypeColumn" msprop:Generator_UserColumnName="nType" type="xs:short" minOccurs="0" />
<xs:element name="sSource" msprop:Generator_ColumnVarNameInTable="columnsSource" msprop:Generator_ColumnPropNameInRow="sSource" msprop:Generator_ColumnPropNameInTable="sSourceColumn" msprop:Generator_UserColumnName="sSource" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sComment" msprop:Generator_ColumnVarNameInTable="columnsComment" msprop:Generator_ColumnPropNameInRow="sComment" msprop:Generator_ColumnPropNameInTable="sCommentColumn" msprop:Generator_UserColumnName="sComment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="75" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="lCurrncyId" msprop:Generator_ColumnVarNameInTable="columnlCurrncyId" msprop:Generator_ColumnPropNameInRow="lCurrncyId" msprop:Generator_ColumnPropNameInTable="lCurrncyIdColumn" msprop:Generator_UserColumnName="lCurrncyId" type="xs:int" minOccurs="0" />
<xs:element name="dExchRate" msprop:Generator_ColumnVarNameInTable="columndExchRate" msprop:Generator_ColumnPropNameInRow="dExchRate" msprop:Generator_ColumnPropNameInTable="dExchRateColumn" msprop:Generator_UserColumnName="dExchRate" type="xs:double" minOccurs="0" />
<xs:element name="lRecId" msprop:Generator_ColumnVarNameInTable="columnlRecId" msprop:Generator_ColumnPropNameInRow="lRecId" msprop:Generator_ColumnPropNameInTable="lRecIdColumn" msprop:Generator_UserColumnName="lRecId" type="xs:int" minOccurs="0" />
<xs:element name="nPymtClass" msprop:Generator_ColumnVarNameInTable="columnnPymtClass" msprop:Generator_ColumnPropNameInRow="nPymtClass" msprop:Generator_ColumnPropNameInTable="nPymtClassColumn" msprop:Generator_UserColumnName="nPymtClass" type="xs:short" minOccurs="0" />
<xs:element name="sComment2" msprop:Generator_ColumnVarNameInTable="columnsComment2" msprop:Generator_ColumnPropNameInRow="sComment2" msprop:Generator_ColumnPropNameInTable="sComment2Column" msprop:Generator_UserColumnName="sComment2" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="75" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="dtCmt2Date" msprop:Generator_ColumnVarNameInTable="columndtCmt2Date" msprop:Generator_ColumnPropNameInRow="dtCmt2Date" msprop:Generator_ColumnPropNameInTable="dtCmt2DateColumn" msprop:Generator_UserColumnName="dtCmt2Date" type="xs:dateTime" minOccurs="0" />
<xs:element name="bExported" msprop:Generator_ColumnVarNameInTable="columnbExported" msprop:Generator_ColumnPropNameInRow="bExported" msprop:Generator_ColumnPropNameInTable="bExportedColumn" msprop:Generator_UserColumnName="bExported" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="lCompId" msprop:Generator_ColumnVarNameInTable="columnlCompId" msprop:Generator_ColumnPropNameInRow="lCompId" msprop:Generator_ColumnPropNameInTable="lCompIdColumn" msprop:Generator_UserColumnName="lCompId" type="xs:int" />
<xs:element name="bAcctEntry" msprop:Generator_ColumnVarNameInTable="columnbAcctEntry" msprop:Generator_ColumnPropNameInRow="bAcctEntry" msprop:Generator_ColumnPropNameInTable="bAcctEntryColumn" msprop:Generator_UserColumnName="bAcctEntry" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="bAEImport" msprop:Generator_ColumnVarNameInTable="columnbAEImport" msprop:Generator_ColumnPropNameInRow="bAEImport" msprop:Generator_ColumnPropNameInTable="bAEImportColumn" msprop:Generator_UserColumnName="bAEImport" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="bAftYEnd" msprop:Generator_ColumnVarNameInTable="columnbAftYEnd" msprop:Generator_ColumnPropNameInRow="bAftYEnd" msprop:Generator_ColumnPropNameInTable="bAftYEndColumn" msprop:Generator_UserColumnName="bAftYEnd" type="xs:unsignedByte" minOccurs="0" />
<xs:element name="bB4YrStart" msprop:Generator_ColumnVarNameInTable="columnbB4YrStart" msprop:Generator_ColumnPropNameInRow="bB4YrStart" msprop:Generator_ColumnPropNameInTable="bB4YrStartColumn" msprop:Generator_UserColumnName="bB4YrStart" type="xs:unsignedByte" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tjourent" />
<xs:field xpath="mstns:lId" />
<xs:field xpath="mstns:lCompId" />
</xs:unique>
</xs:element>
</xs:schema>