Samuele Locatelli
1520 lines
134 KiB
XML
1520 lines
134 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_Report" targetNamespace="http://tempuri.org/DS_Report.xsd" xmlns:mstns="http://tempuri.org/DS_Report.xsd" xmlns="http://tempuri.org/DS_Report.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="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MoonPro_MAGConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MoonPro_MAGConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MagData.Properties.Settings.GlobalReference.Default.MoonPro_MAGConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PrintJobQueueTableAdapter" GeneratorDataComponentClassName="PrintJobQueueTableAdapter" Name="PrintJobQueue" UserDataComponentName="PrintJobQueueTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.PrintJobQueue" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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 [PrintJobQueue] WHERE (([IdxPrintJob] = @Original_IdxPrintJob) AND ([TipoReport] = @Original_TipoReport) AND ([KeyParam] = @Original_KeyParam) AND ([prtName] = @Original_prtName) AND ([dtStart] = @Original_dtStart) AND ((@IsNull_dtEnd = 1 AND [dtEnd] IS NULL) OR ([dtEnd] = @Original_dtEnd)) AND ([stato] = @Original_stato) AND ((@IsNull_dtLastTry = 1 AND [dtLastTry] IS NULL) OR ([dtLastTry] = @Original_dtLastTry)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPrintJob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPrintJob" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoReport" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReport" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyParam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyParam" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prtName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prtName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtStart" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_stato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtLastTry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtLastTry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO [PrintJobQueue] ([printerQueue], [keyParam], [dtStart], [dtEnd], [stato], [dtLastTry]) VALUES (@printerQueue, @keyParam, @dtStart, @dtEnd, @stato, @dtLastTry);
|
|
SELECT IdxPrintJob, printerQueue, keyParam, dtStart, dtEnd, stato, dtLastTry FROM PrintJobQueue WHERE (IdxPrintJob = SCOPE_IDENTITY())</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@printerQueue" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="printerQueue" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@keyParam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="keyParam" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtStart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtLastTry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT * FROM PrintJobQueue</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE [PrintJobQueue] SET [TipoReport] = @TipoReport, [KeyParam] = @KeyParam, [prtName] = @prtName, [dtStart] = @dtStart, [dtEnd] = @dtEnd, [stato] = @stato, [dtLastTry] = @dtLastTry WHERE (([IdxPrintJob] = @Original_IdxPrintJob) AND ([TipoReport] = @Original_TipoReport) AND ([KeyParam] = @Original_KeyParam) AND ([prtName] = @Original_prtName) AND ([dtStart] = @Original_dtStart) AND ((@IsNull_dtEnd = 1 AND [dtEnd] IS NULL) OR ([dtEnd] = @Original_dtEnd)) AND ([stato] = @Original_stato) AND ((@IsNull_dtLastTry = 1 AND [dtLastTry] IS NULL) OR ([dtLastTry] = @Original_dtLastTry)));
|
|
SELECT IdxPrintJob, TipoReport, KeyParam, prtName, dtStart, dtEnd, stato, dtLastTry FROM PrintJobQueue WHERE (IdxPrintJob = @IdxPrintJob)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TipoReport" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReport" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyParam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyParam" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prtName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prtName" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtStart" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@stato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dtLastTry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdxPrintJob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdxPrintJob" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TipoReport" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TipoReport" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_KeyParam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="KeyParam" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prtName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="prtName" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtStart" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtStart" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtEnd" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_stato" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="stato" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dtLastTry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dtLastTry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dtLastTry" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="false" AutogeneratedName="IdxPrintJob" ColumnName="IdxPrintJob" DataSourceName="MoonPro_MAG.dbo.PrintJobQueue" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxPrintJob" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdxPrintJob" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="IdxPrintJob" DataSetColumn="IdxPrintJob" />
|
|
<Mapping SourceColumn="TipoReport" DataSetColumn="TipoReport" />
|
|
<Mapping SourceColumn="KeyParam" DataSetColumn="KeyParam" />
|
|
<Mapping SourceColumn="prtName" DataSetColumn="prtName" />
|
|
<Mapping SourceColumn="dtStart" DataSetColumn="dtStart" />
|
|
<Mapping SourceColumn="dtEnd" DataSetColumn="dtEnd" />
|
|
<Mapping SourceColumn="stato" DataSetColumn="stato" />
|
|
<Mapping SourceColumn="dtLastTry" DataSetColumn="dtLastTry" />
|
|
</Mappings>
|
|
<Sources>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_chiudiZoombie" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="chiudiZoombie" Modifier="Public" Name="chiudiZoombie" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="chiudiZoombie">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_chiudiZoombie</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@dtLastTryMax" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_getByQueue" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByQueue" GetMethodModifier="Public" GetMethodName="getByQueue" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByQueue" UserSourceName="getByQueue">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_getByQueue</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@queue" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_getByQueueAll" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getByQueueAll" GetMethodModifier="Public" GetMethodName="getByQueueAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getByQueueAll" UserSourceName="getByQueueAll">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_getByQueueAll</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@queue" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_getFirtsByParam" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getFirtsByParam" GetMethodModifier="Public" GetMethodName="getFirtsByParam" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getFirtsByParam" UserSourceName="getFirtsByParam">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_getFirtsByParam</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@keyParam" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_getNext" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getNext" GetMethodModifier="Public" GetMethodName="getNext" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getNext" UserSourceName="getNext">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_getNext</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_getWaiting" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="getWaiting" GetMethodModifier="Public" GetMethodName="getWaiting" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="getWaiting" UserSourceName="getWaiting">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_getWaiting</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="insertQuery" Modifier="Public" Name="insertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="insertQuery">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_insert</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@TipoReport" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@keyParam" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@prtName" Precision="0" ProviderType="VarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_updateLastTry" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateLastTry" Modifier="Public" Name="updateLastTry" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="updateLastTry">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_updateLastTry</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@keyParam" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_PJQ_updateStato" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="updateStato" Modifier="Public" Name="updateStato" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="updateStato">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_PJQ_updateStato</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdxPrintJob" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@stato" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prt_CartellinoFinitiOdetteTableAdapter" GeneratorDataComponentClassName="stp_prt_CartellinoFinitiOdetteTableAdapter" Name="stp_prt_CartellinoFinitiOdette" UserDataComponentName="stp_prt_CartellinoFinitiOdetteTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_prt_CartellinoFinitiOdette" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_prt_CartellinoFinitiOdette</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CampoUDC" DataSetColumn="CampoUDC" />
|
|
<Mapping SourceColumn="Campo1_1" DataSetColumn="Campo1_1" />
|
|
<Mapping SourceColumn="Campo1_2" DataSetColumn="Campo1_2" />
|
|
<Mapping SourceColumn="Campo1_3" DataSetColumn="Campo1_3" />
|
|
<Mapping SourceColumn="Campo1_4" DataSetColumn="Campo1_4" />
|
|
<Mapping SourceColumn="Campo1_5" DataSetColumn="Campo1_5" />
|
|
<Mapping SourceColumn="Campo2_1" DataSetColumn="Campo2_1" />
|
|
<Mapping SourceColumn="Campo2_2" DataSetColumn="Campo2_2" />
|
|
<Mapping SourceColumn="Campo2_3" DataSetColumn="Campo2_3" />
|
|
<Mapping SourceColumn="Campo2_4" DataSetColumn="Campo2_4" />
|
|
<Mapping SourceColumn="Campo2_5" DataSetColumn="Campo2_5" />
|
|
<Mapping SourceColumn="Campo3_1" DataSetColumn="Campo3_1" />
|
|
<Mapping SourceColumn="Campo3_2" DataSetColumn="Campo3_2" />
|
|
<Mapping SourceColumn="Campo3_3" DataSetColumn="Campo3_3" />
|
|
<Mapping SourceColumn="Campo3_4" DataSetColumn="Campo3_4" />
|
|
<Mapping SourceColumn="Campo3_5" DataSetColumn="Campo3_5" />
|
|
<Mapping SourceColumn="Campo4_1" DataSetColumn="Campo4_1" />
|
|
<Mapping SourceColumn="Campo4_2" DataSetColumn="Campo4_2" />
|
|
<Mapping SourceColumn="Campo4_3" DataSetColumn="Campo4_3" />
|
|
<Mapping SourceColumn="Campo4_4" DataSetColumn="Campo4_4" />
|
|
<Mapping SourceColumn="Campo4_5" DataSetColumn="Campo4_5" />
|
|
<Mapping SourceColumn="Campo5_1" DataSetColumn="Campo5_1" />
|
|
<Mapping SourceColumn="Campo5_2" DataSetColumn="Campo5_2" />
|
|
<Mapping SourceColumn="Campo5_3" DataSetColumn="Campo5_3" />
|
|
<Mapping SourceColumn="Campo5_4" DataSetColumn="Campo5_4" />
|
|
<Mapping SourceColumn="Campo5_5" DataSetColumn="Campo5_5" />
|
|
<Mapping SourceColumn="Campo6_1" DataSetColumn="Campo6_1" />
|
|
<Mapping SourceColumn="Campo6_2" DataSetColumn="Campo6_2" />
|
|
<Mapping SourceColumn="Campo6_3" DataSetColumn="Campo6_3" />
|
|
<Mapping SourceColumn="Campo6_4" DataSetColumn="Campo6_4" />
|
|
<Mapping SourceColumn="Campo6_5" DataSetColumn="Campo6_5" />
|
|
<Mapping SourceColumn="Campo7_1" DataSetColumn="Campo7_1" />
|
|
<Mapping SourceColumn="Campo7_2" DataSetColumn="Campo7_2" />
|
|
<Mapping SourceColumn="Campo7_3" DataSetColumn="Campo7_3" />
|
|
<Mapping SourceColumn="Campo7_4" DataSetColumn="Campo7_4" />
|
|
<Mapping SourceColumn="Campo7_5" DataSetColumn="Campo7_5" />
|
|
<Mapping SourceColumn="Campo8_1" DataSetColumn="Campo8_1" />
|
|
<Mapping SourceColumn="Campo8_2" DataSetColumn="Campo8_2" />
|
|
<Mapping SourceColumn="Campo8_3" DataSetColumn="Campo8_3" />
|
|
<Mapping SourceColumn="Campo8_4" DataSetColumn="Campo8_4" />
|
|
<Mapping SourceColumn="Campo8_5" DataSetColumn="Campo8_5" />
|
|
<Mapping SourceColumn="Campo9_1" DataSetColumn="Campo9_1" />
|
|
<Mapping SourceColumn="Campo9_2" DataSetColumn="Campo9_2" />
|
|
<Mapping SourceColumn="Campo9_3" DataSetColumn="Campo9_3" />
|
|
<Mapping SourceColumn="Campo9_4" DataSetColumn="Campo9_4" />
|
|
<Mapping SourceColumn="Campo9_5" DataSetColumn="Campo9_5" />
|
|
<Mapping SourceColumn="Campo10_1" DataSetColumn="Campo10_1" />
|
|
<Mapping SourceColumn="Campo10_2" DataSetColumn="Campo10_2" />
|
|
<Mapping SourceColumn="Campo10_3" DataSetColumn="Campo10_3" />
|
|
<Mapping SourceColumn="Campo10_4" DataSetColumn="Campo10_4" />
|
|
<Mapping SourceColumn="Campo10_5" DataSetColumn="Campo10_5" />
|
|
<Mapping SourceColumn="Campo11_1_1" DataSetColumn="Campo11_1_1" />
|
|
<Mapping SourceColumn="Campo11_1_2" DataSetColumn="Campo11_1_2" />
|
|
<Mapping SourceColumn="Campo11_1_3" DataSetColumn="Campo11_1_3" />
|
|
<Mapping SourceColumn="Campo11_1_4" DataSetColumn="Campo11_1_4" />
|
|
<Mapping SourceColumn="Campo11_1_5" DataSetColumn="Campo11_1_5" />
|
|
<Mapping SourceColumn="Campo11_2_1" DataSetColumn="Campo11_2_1" />
|
|
<Mapping SourceColumn="Campo11_2_2" DataSetColumn="Campo11_2_2" />
|
|
<Mapping SourceColumn="Campo11_2_3" DataSetColumn="Campo11_2_3" />
|
|
<Mapping SourceColumn="Campo11_2_4" DataSetColumn="Campo11_2_4" />
|
|
<Mapping SourceColumn="Campo11_2_5" DataSetColumn="Campo11_2_5" />
|
|
<Mapping SourceColumn="Campo12_1" DataSetColumn="Campo12_1" />
|
|
<Mapping SourceColumn="Campo12_2" DataSetColumn="Campo12_2" />
|
|
<Mapping SourceColumn="Campo12_3" DataSetColumn="Campo12_3" />
|
|
<Mapping SourceColumn="Campo12_4" DataSetColumn="Campo12_4" />
|
|
<Mapping SourceColumn="Campo12_5" DataSetColumn="Campo12_5" />
|
|
<Mapping SourceColumn="Campo13_1" DataSetColumn="Campo13_1" />
|
|
<Mapping SourceColumn="Campo13_2" DataSetColumn="Campo13_2" />
|
|
<Mapping SourceColumn="Campo13_3" DataSetColumn="Campo13_3" />
|
|
<Mapping SourceColumn="Campo13_4" DataSetColumn="Campo13_4" />
|
|
<Mapping SourceColumn="Campo13_5" DataSetColumn="Campo13_5" />
|
|
<Mapping SourceColumn="Campo14_1" DataSetColumn="Campo14_1" />
|
|
<Mapping SourceColumn="Campo14_2" DataSetColumn="Campo14_2" />
|
|
<Mapping SourceColumn="Campo14_3" DataSetColumn="Campo14_3" />
|
|
<Mapping SourceColumn="Campo14_4" DataSetColumn="Campo14_4" />
|
|
<Mapping SourceColumn="Campo14_5" DataSetColumn="Campo14_5" />
|
|
<Mapping SourceColumn="Campo15_1" DataSetColumn="Campo15_1" />
|
|
<Mapping SourceColumn="Campo15_2" DataSetColumn="Campo15_2" />
|
|
<Mapping SourceColumn="Campo15_3" DataSetColumn="Campo15_3" />
|
|
<Mapping SourceColumn="Campo15_4" DataSetColumn="Campo15_4" />
|
|
<Mapping SourceColumn="Campo15_5" DataSetColumn="Campo15_5" />
|
|
<Mapping SourceColumn="Campo16_1" DataSetColumn="Campo16_1" />
|
|
<Mapping SourceColumn="Campo16_2" DataSetColumn="Campo16_2" />
|
|
<Mapping SourceColumn="Campo16_3" DataSetColumn="Campo16_3" />
|
|
<Mapping SourceColumn="Campo16_4" DataSetColumn="Campo16_4" />
|
|
<Mapping SourceColumn="Campo16_5" DataSetColumn="Campo16_5" />
|
|
<Mapping SourceColumn="BarcodeBaseUrl" DataSetColumn="BarcodeBaseUrl" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prt_CartellinoPedaneTableAdapter" GeneratorDataComponentClassName="stp_prt_CartellinoPedaneTableAdapter" Name="stp_prt_CartellinoPedane" UserDataComponentName="stp_prt_CartellinoPedaneTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_prt_CartellinoPedane" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_prt_CartellinoPedane</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="CodPedana" DataSetColumn="CodPedana" />
|
|
<Mapping SourceColumn="NumPedana" DataSetColumn="NumPedana" />
|
|
<Mapping SourceColumn="PesoPedana" DataSetColumn="PesoPedana" />
|
|
<Mapping SourceColumn="DescDest_1" DataSetColumn="DescDest_1" />
|
|
<Mapping SourceColumn="DescDest_2" DataSetColumn="DescDest_2" />
|
|
<Mapping SourceColumn="DescDest_3" DataSetColumn="DescDest_3" />
|
|
<Mapping SourceColumn="NumColli" DataSetColumn="NumColli" />
|
|
<Mapping SourceColumn="DataPedana" DataSetColumn="DataPedana" />
|
|
<Mapping SourceColumn="BarcodeBaseUrl" DataSetColumn="BarcodeBaseUrl" />
|
|
<Mapping SourceColumn="DescPack" DataSetColumn="DescPack" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prt_CartellinoSemilavoratiTableAdapter" GeneratorDataComponentClassName="stp_prt_CartellinoSemilavoratiTableAdapter" Name="stp_prt_CartellinoSemilavorati" UserDataComponentName="stp_prt_CartellinoSemilavoratiTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.dbo.stp_prt_CartellinoSemilavorati" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_prt_CartellinoSemilavorati</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DataDDT" DataSetColumn="DataDDT" />
|
|
<Mapping SourceColumn="NumDDT" DataSetColumn="NumDDT" />
|
|
<Mapping SourceColumn="DescFornit" DataSetColumn="DescFornit" />
|
|
<Mapping SourceColumn="DescArticolo" DataSetColumn="DescArticolo" />
|
|
<Mapping SourceColumn="CodInterno" DataSetColumn="CodInterno" />
|
|
<Mapping SourceColumn="Lotto" DataSetColumn="Lotto" />
|
|
<Mapping SourceColumn="DataLotto" DataSetColumn="DataLotto" />
|
|
<Mapping SourceColumn="NoteLotto" DataSetColumn="NoteLotto" />
|
|
<Mapping SourceColumn="BarcodeBaseUrl" DataSetColumn="BarcodeBaseUrl" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prt_ReportPackListTableAdapter" GeneratorDataComponentClassName="stp_prt_ReportPackListTableAdapter" Name="stp_prt_ReportPackList" UserDataComponentName="stp_prt_ReportPackListTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.rep.stp_prt_ReportPackList" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>rep.stp_prt_ReportPackList</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@keyVal" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@OnlySend" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="PackListID" DataSetColumn="PackListID" />
|
|
<Mapping SourceColumn="PackDescr" DataSetColumn="PackDescr" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
|
|
<Mapping SourceColumn="AL" DataSetColumn="AL" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="DescAL" DataSetColumn="DescAL" />
|
|
<Mapping SourceColumn="Lotto" DataSetColumn="Lotto" />
|
|
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="CodArtCliente" DataSetColumn="CodArtCliente" />
|
|
<Mapping SourceColumn="DescDest_1" DataSetColumn="DescDest_1" />
|
|
<Mapping SourceColumn="DescDest_2" DataSetColumn="DescDest_2" />
|
|
<Mapping SourceColumn="DescDest_3" DataSetColumn="DescDest_3" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stp_prt_ReportPackListFullTableAdapter" GeneratorDataComponentClassName="stp_prt_ReportPackListFullTableAdapter" Name="stp_prt_ReportPackListFull" UserDataComponentName="stp_prt_ReportPackListFullTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MoonPro_MAGConnectionString (Settings)" DbObjectName="MoonPro_MAG.rep.stp_prt_ReportPackListFull" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>rep.stp_prt_ReportPackListFull</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@keyVal" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@OnlySend" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="PackListID" DataSetColumn="PackListID" />
|
|
<Mapping SourceColumn="PackDescr" DataSetColumn="PackDescr" />
|
|
<Mapping SourceColumn="ModDate" DataSetColumn="ModDate" />
|
|
<Mapping SourceColumn="CodCliente" DataSetColumn="CodCliente" />
|
|
<Mapping SourceColumn="StatusPack" DataSetColumn="StatusPack" />
|
|
<Mapping SourceColumn="DescStatusPack" DataSetColumn="DescStatusPack" />
|
|
<Mapping SourceColumn="OrderListID" DataSetColumn="OrderListID" />
|
|
<Mapping SourceColumn="ExtOrdCod" DataSetColumn="ExtOrdCod" />
|
|
<Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
|
|
<Mapping SourceColumn="CodArt" DataSetColumn="CodArt" />
|
|
<Mapping SourceColumn="QtyOrd" DataSetColumn="QtyOrd" />
|
|
<Mapping SourceColumn="OrdDescr" DataSetColumn="OrdDescr" />
|
|
<Mapping SourceColumn="CodCliOrd" DataSetColumn="CodCliOrd" />
|
|
<Mapping SourceColumn="CodDestinazione" DataSetColumn="CodDestinazione" />
|
|
<Mapping SourceColumn="DescrArt" DataSetColumn="DescrArt" />
|
|
<Mapping SourceColumn="RagSociale" DataSetColumn="RagSociale" />
|
|
<Mapping SourceColumn="Indirizzo" DataSetColumn="Indirizzo" />
|
|
<Mapping SourceColumn="Localita" DataSetColumn="Localita" />
|
|
<Mapping SourceColumn="Cap" DataSetColumn="Cap" />
|
|
<Mapping SourceColumn="Provincia" DataSetColumn="Provincia" />
|
|
<Mapping SourceColumn="Nazione" DataSetColumn="Nazione" />
|
|
<Mapping SourceColumn="DescDestinazione" DataSetColumn="DescDestinazione" />
|
|
<Mapping SourceColumn="DestIndirizzo" DataSetColumn="DestIndirizzo" />
|
|
<Mapping SourceColumn="DestCap" DataSetColumn="DestCap" />
|
|
<Mapping SourceColumn="DestLocalita" DataSetColumn="DestLocalita" />
|
|
<Mapping SourceColumn="DestProvincia" DataSetColumn="DestProvincia" />
|
|
<Mapping SourceColumn="DestNazione" DataSetColumn="DestNazione" />
|
|
<Mapping SourceColumn="AL" DataSetColumn="AL" />
|
|
<Mapping SourceColumn="StatusAL" DataSetColumn="StatusAL" />
|
|
<Mapping SourceColumn="DescAL" DataSetColumn="DescAL" />
|
|
<Mapping SourceColumn="Peso" DataSetColumn="Peso" />
|
|
<Mapping SourceColumn="Tara" DataSetColumn="Tara" />
|
|
<Mapping SourceColumn="UDC" DataSetColumn="UDC" />
|
|
<Mapping SourceColumn="ALOrder" DataSetColumn="ALOrder" />
|
|
<Mapping SourceColumn="Lotto" DataSetColumn="Lotto" />
|
|
<Mapping SourceColumn="Qta" DataSetColumn="Qta" />
|
|
<Mapping SourceColumn="IdxODL" DataSetColumn="IdxODL" />
|
|
<Mapping SourceColumn="RifExt" DataSetColumn="RifExt" />
|
|
<Mapping SourceColumn="DtCrea" DataSetColumn="DtCrea" />
|
|
<Mapping SourceColumn="Attivo" DataSetColumn="Attivo" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_Report" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_UserDSName="DS_Report" msprop:Generator_DataSetName="DS_Report">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="PrintJobQueue" msprop:Generator_RowEvHandlerName="PrintJobQueueRowChangeEventHandler" msprop:Generator_RowDeletedName="PrintJobQueueRowDeleted" msprop:Generator_RowDeletingName="PrintJobQueueRowDeleting" msprop:Generator_RowEvArgName="PrintJobQueueRowChangeEvent" msprop:Generator_TablePropName="PrintJobQueue" msprop:Generator_RowChangedName="PrintJobQueueRowChanged" msprop:Generator_RowChangingName="PrintJobQueueRowChanging" msprop:Generator_TableClassName="PrintJobQueueDataTable" msprop:Generator_RowClassName="PrintJobQueueRow" msprop:Generator_TableVarName="tablePrintJobQueue" msprop:Generator_UserTableName="PrintJobQueue">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="IdxPrintJob" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdxPrintJob" msprop:Generator_ColumnPropNameInTable="IdxPrintJobColumn" msprop:Generator_ColumnVarNameInTable="columnIdxPrintJob" msprop:Generator_UserColumnName="IdxPrintJob" type="xs:int" />
|
|
<xs:element name="TipoReport" msprop:Generator_ColumnPropNameInRow="TipoReport" msprop:Generator_ColumnPropNameInTable="TipoReportColumn" msprop:Generator_ColumnVarNameInTable="columnTipoReport" msprop:Generator_UserColumnName="TipoReport">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KeyParam" msprop:Generator_ColumnPropNameInRow="KeyParam" msprop:Generator_ColumnPropNameInTable="KeyParamColumn" msprop:Generator_ColumnVarNameInTable="columnKeyParam" msprop:Generator_UserColumnName="KeyParam">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="prtName" msprop:Generator_ColumnPropNameInRow="prtName" msprop:Generator_ColumnPropNameInTable="prtNameColumn" msprop:Generator_ColumnVarNameInTable="columnprtName" msprop:Generator_UserColumnName="prtName">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="dtStart" msprop:Generator_ColumnPropNameInRow="dtStart" msprop:Generator_ColumnPropNameInTable="dtStartColumn" msprop:Generator_ColumnVarNameInTable="columndtStart" msprop:Generator_UserColumnName="dtStart" type="xs:dateTime" />
|
|
<xs:element name="dtEnd" msprop:Generator_ColumnPropNameInRow="dtEnd" msprop:Generator_ColumnPropNameInTable="dtEndColumn" msprop:Generator_ColumnVarNameInTable="columndtEnd" msprop:Generator_UserColumnName="dtEnd" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="stato" msprop:Generator_ColumnPropNameInRow="stato" msprop:Generator_ColumnPropNameInTable="statoColumn" msprop:Generator_ColumnVarNameInTable="columnstato" msprop:Generator_UserColumnName="stato" type="xs:int" />
|
|
<xs:element name="dtLastTry" msprop:Generator_ColumnPropNameInRow="dtLastTry" msprop:Generator_ColumnPropNameInTable="dtLastTryColumn" msprop:Generator_ColumnVarNameInTable="columndtLastTry" msprop:Generator_UserColumnName="dtLastTry" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prt_CartellinoFinitiOdette" msprop:Generator_RowEvHandlerName="stp_prt_CartellinoFinitiOdetteRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_prt_CartellinoFinitiOdetteRowDeleted" msprop:Generator_RowDeletingName="stp_prt_CartellinoFinitiOdetteRowDeleting" msprop:Generator_RowEvArgName="stp_prt_CartellinoFinitiOdetteRowChangeEvent" msprop:Generator_TablePropName="stp_prt_CartellinoFinitiOdette" msprop:Generator_RowChangedName="stp_prt_CartellinoFinitiOdetteRowChanged" msprop:Generator_RowChangingName="stp_prt_CartellinoFinitiOdetteRowChanging" msprop:Generator_TableClassName="stp_prt_CartellinoFinitiOdetteDataTable" msprop:Generator_RowClassName="stp_prt_CartellinoFinitiOdetteRow" msprop:Generator_TableVarName="tablestp_prt_CartellinoFinitiOdette" msprop:Generator_UserTableName="stp_prt_CartellinoFinitiOdette">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CampoUDC" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="CampoUDC" msprop:Generator_ColumnPropNameInTable="CampoUDCColumn" msprop:Generator_ColumnVarNameInTable="columnCampoUDC" msprop:Generator_UserColumnName="CampoUDC">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo1_1" msprop:Generator_ColumnPropNameInTable="Campo1_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo1_1" msprop:Generator_UserColumnName="Campo1_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_2" msprop:Generator_ColumnPropNameInRow="Campo1_2" msprop:Generator_ColumnPropNameInTable="Campo1_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo1_2" msprop:Generator_UserColumnName="Campo1_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_3" msprop:Generator_ColumnPropNameInRow="Campo1_3" msprop:Generator_ColumnPropNameInTable="Campo1_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo1_3" msprop:Generator_UserColumnName="Campo1_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo1_4" msprop:Generator_ColumnPropNameInTable="Campo1_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo1_4" msprop:Generator_UserColumnName="Campo1_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="363" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo1_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo1_5" msprop:Generator_ColumnPropNameInTable="Campo1_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo1_5" msprop:Generator_UserColumnName="Campo1_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo2_1" msprop:Generator_ColumnPropNameInTable="Campo2_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo2_1" msprop:Generator_UserColumnName="Campo2_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="13" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo2_2" msprop:Generator_ColumnPropNameInTable="Campo2_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo2_2" msprop:Generator_UserColumnName="Campo2_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo2_3" msprop:Generator_ColumnPropNameInTable="Campo2_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo2_3" msprop:Generator_UserColumnName="Campo2_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo2_4" msprop:Generator_ColumnPropNameInTable="Campo2_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo2_4" msprop:Generator_UserColumnName="Campo2_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo2_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo2_5" msprop:Generator_ColumnPropNameInTable="Campo2_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo2_5" msprop:Generator_UserColumnName="Campo2_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo3_1" msprop:Generator_ColumnPropNameInTable="Campo3_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo3_1" msprop:Generator_UserColumnName="Campo3_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="21" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo3_2" msprop:Generator_ColumnPropNameInTable="Campo3_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo3_2" msprop:Generator_UserColumnName="Campo3_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo3_3" msprop:Generator_ColumnPropNameInTable="Campo3_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo3_3" msprop:Generator_UserColumnName="Campo3_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo3_4" msprop:Generator_ColumnPropNameInTable="Campo3_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo3_4" msprop:Generator_UserColumnName="Campo3_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo3_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo3_5" msprop:Generator_ColumnPropNameInTable="Campo3_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo3_5" msprop:Generator_UserColumnName="Campo3_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo4_1" msprop:Generator_ColumnPropNameInTable="Campo4_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo4_1" msprop:Generator_UserColumnName="Campo4_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="24" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo4_2" msprop:Generator_ColumnPropNameInTable="Campo4_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo4_2" msprop:Generator_UserColumnName="Campo4_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="18" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo4_3" msprop:Generator_ColumnPropNameInTable="Campo4_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo4_3" msprop:Generator_UserColumnName="Campo4_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo4_4" msprop:Generator_ColumnPropNameInTable="Campo4_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo4_4" msprop:Generator_UserColumnName="Campo4_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo4_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo4_5" msprop:Generator_ColumnPropNameInTable="Campo4_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo4_5" msprop:Generator_UserColumnName="Campo4_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo5_1" msprop:Generator_ColumnPropNameInTable="Campo5_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo5_1" msprop:Generator_UserColumnName="Campo5_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="17" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo5_2" msprop:Generator_ColumnPropNameInTable="Campo5_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo5_2" msprop:Generator_UserColumnName="Campo5_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo5_3" msprop:Generator_ColumnPropNameInTable="Campo5_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo5_3" msprop:Generator_UserColumnName="Campo5_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo5_4" msprop:Generator_ColumnPropNameInTable="Campo5_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo5_4" msprop:Generator_UserColumnName="Campo5_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo5_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo5_5" msprop:Generator_ColumnPropNameInTable="Campo5_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo5_5" msprop:Generator_UserColumnName="Campo5_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo6_1" msprop:Generator_ColumnPropNameInTable="Campo6_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo6_1" msprop:Generator_UserColumnName="Campo6_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="18" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo6_2" msprop:Generator_ColumnPropNameInTable="Campo6_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo6_2" msprop:Generator_UserColumnName="Campo6_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo6_3" msprop:Generator_ColumnPropNameInTable="Campo6_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo6_3" msprop:Generator_UserColumnName="Campo6_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo6_4" msprop:Generator_ColumnPropNameInTable="Campo6_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo6_4" msprop:Generator_UserColumnName="Campo6_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo6_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo6_5" msprop:Generator_ColumnPropNameInTable="Campo6_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo6_5" msprop:Generator_UserColumnName="Campo6_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo7_1" msprop:Generator_ColumnPropNameInTable="Campo7_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo7_1" msprop:Generator_UserColumnName="Campo7_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="19" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo7_2" msprop:Generator_ColumnPropNameInTable="Campo7_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo7_2" msprop:Generator_UserColumnName="Campo7_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo7_3" msprop:Generator_ColumnPropNameInTable="Campo7_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo7_3" msprop:Generator_UserColumnName="Campo7_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo7_4" msprop:Generator_ColumnPropNameInTable="Campo7_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo7_4" msprop:Generator_UserColumnName="Campo7_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo7_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo7_5" msprop:Generator_ColumnPropNameInTable="Campo7_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo7_5" msprop:Generator_UserColumnName="Campo7_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo8_1" msprop:Generator_ColumnPropNameInTable="Campo8_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo8_1" msprop:Generator_UserColumnName="Campo8_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="19" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_2" msprop:Generator_ColumnPropNameInRow="Campo8_2" msprop:Generator_ColumnPropNameInTable="Campo8_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo8_2" msprop:Generator_UserColumnName="Campo8_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo8_3" msprop:Generator_ColumnPropNameInTable="Campo8_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo8_3" msprop:Generator_UserColumnName="Campo8_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="51" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo8_4" msprop:Generator_ColumnPropNameInTable="Campo8_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo8_4" msprop:Generator_UserColumnName="Campo8_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo8_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo8_5" msprop:Generator_ColumnPropNameInTable="Campo8_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo8_5" msprop:Generator_UserColumnName="Campo8_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo9_1" msprop:Generator_ColumnPropNameInTable="Campo9_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo9_1" msprop:Generator_UserColumnName="Campo9_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="16" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo9_2" msprop:Generator_ColumnPropNameInTable="Campo9_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo9_2" msprop:Generator_UserColumnName="Campo9_2" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Campo9_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo9_3" msprop:Generator_ColumnPropNameInTable="Campo9_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo9_3" msprop:Generator_UserColumnName="Campo9_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo9_4" msprop:Generator_ColumnPropNameInTable="Campo9_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo9_4" msprop:Generator_UserColumnName="Campo9_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo9_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo9_5" msprop:Generator_ColumnPropNameInTable="Campo9_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo9_5" msprop:Generator_UserColumnName="Campo9_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="8" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo10_1" msprop:Generator_ColumnPropNameInTable="Campo10_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo10_1" msprop:Generator_UserColumnName="Campo10_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="16" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_2" msprop:Generator_ColumnPropNameInRow="Campo10_2" msprop:Generator_ColumnPropNameInTable="Campo10_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo10_2" msprop:Generator_UserColumnName="Campo10_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo10_3" msprop:Generator_ColumnPropNameInTable="Campo10_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo10_3" msprop:Generator_UserColumnName="Campo10_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo10_4" msprop:Generator_ColumnPropNameInTable="Campo10_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo10_4" msprop:Generator_UserColumnName="Campo10_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo10_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo10_5" msprop:Generator_ColumnPropNameInTable="Campo10_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo10_5" msprop:Generator_UserColumnName="Campo10_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_1_1" msprop:Generator_ColumnPropNameInTable="Campo11_1_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_1" msprop:Generator_UserColumnName="Campo11_1_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_1_2" msprop:Generator_ColumnPropNameInTable="Campo11_1_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_2" msprop:Generator_UserColumnName="Campo11_1_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_1_3" msprop:Generator_ColumnPropNameInTable="Campo11_1_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_3" msprop:Generator_UserColumnName="Campo11_1_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_1_4" msprop:Generator_ColumnPropNameInTable="Campo11_1_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_4" msprop:Generator_UserColumnName="Campo11_1_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_1_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_1_5" msprop:Generator_ColumnPropNameInTable="Campo11_1_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_1_5" msprop:Generator_UserColumnName="Campo11_1_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_2_1" msprop:Generator_ColumnPropNameInTable="Campo11_2_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_1" msprop:Generator_UserColumnName="Campo11_2_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="27" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_2" msprop:Generator_ColumnPropNameInRow="Campo11_2_2" msprop:Generator_ColumnPropNameInTable="Campo11_2_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_2" msprop:Generator_UserColumnName="Campo11_2_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_3" msprop:Generator_ColumnPropNameInRow="Campo11_2_3" msprop:Generator_ColumnPropNameInTable="Campo11_2_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_3" msprop:Generator_UserColumnName="Campo11_2_3">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_2_4" msprop:Generator_ColumnPropNameInTable="Campo11_2_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_4" msprop:Generator_UserColumnName="Campo11_2_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo11_2_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo11_2_5" msprop:Generator_ColumnPropNameInTable="Campo11_2_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo11_2_5" msprop:Generator_UserColumnName="Campo11_2_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="11" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo12_1" msprop:Generator_ColumnPropNameInTable="Campo12_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo12_1" msprop:Generator_UserColumnName="Campo12_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="22" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo12_2" msprop:Generator_ColumnPropNameInTable="Campo12_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo12_2" msprop:Generator_UserColumnName="Campo12_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo12_3" msprop:Generator_ColumnPropNameInTable="Campo12_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo12_3" msprop:Generator_UserColumnName="Campo12_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo12_4" msprop:Generator_ColumnPropNameInTable="Campo12_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo12_4" msprop:Generator_UserColumnName="Campo12_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo12_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo12_5" msprop:Generator_ColumnPropNameInTable="Campo12_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo12_5" msprop:Generator_UserColumnName="Campo12_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo13_1" msprop:Generator_ColumnPropNameInTable="Campo13_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo13_1" msprop:Generator_UserColumnName="Campo13_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo13_2" msprop:Generator_ColumnPropNameInTable="Campo13_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo13_2" msprop:Generator_UserColumnName="Campo13_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo13_3" msprop:Generator_ColumnPropNameInTable="Campo13_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo13_3" msprop:Generator_UserColumnName="Campo13_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo13_4" msprop:Generator_ColumnPropNameInTable="Campo13_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo13_4" msprop:Generator_UserColumnName="Campo13_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo13_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo13_5" msprop:Generator_ColumnPropNameInTable="Campo13_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo13_5" msprop:Generator_UserColumnName="Campo13_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo14_1" msprop:Generator_ColumnPropNameInTable="Campo14_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo14_1" msprop:Generator_UserColumnName="Campo14_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo14_2" msprop:Generator_ColumnPropNameInTable="Campo14_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo14_2" msprop:Generator_UserColumnName="Campo14_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo14_3" msprop:Generator_ColumnPropNameInTable="Campo14_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo14_3" msprop:Generator_UserColumnName="Campo14_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo14_4" msprop:Generator_ColumnPropNameInTable="Campo14_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo14_4" msprop:Generator_UserColumnName="Campo14_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo14_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo14_5" msprop:Generator_ColumnPropNameInTable="Campo14_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo14_5" msprop:Generator_UserColumnName="Campo14_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo15_1" msprop:Generator_ColumnPropNameInTable="Campo15_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo15_1" msprop:Generator_UserColumnName="Campo15_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="21" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_2" msprop:Generator_ColumnPropNameInRow="Campo15_2" msprop:Generator_ColumnPropNameInTable="Campo15_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo15_2" msprop:Generator_UserColumnName="Campo15_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo15_3" msprop:Generator_ColumnPropNameInTable="Campo15_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo15_3" msprop:Generator_UserColumnName="Campo15_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="51" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo15_4" msprop:Generator_ColumnPropNameInTable="Campo15_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo15_4" msprop:Generator_UserColumnName="Campo15_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo15_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo15_5" msprop:Generator_ColumnPropNameInTable="Campo15_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo15_5" msprop:Generator_UserColumnName="Campo15_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo16_1" msprop:Generator_ColumnPropNameInTable="Campo16_1Column" msprop:Generator_ColumnVarNameInTable="columnCampo16_1" msprop:Generator_UserColumnName="Campo16_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="24" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_2" msprop:Generator_ColumnPropNameInRow="Campo16_2" msprop:Generator_ColumnPropNameInTable="Campo16_2Column" msprop:Generator_ColumnVarNameInTable="columnCampo16_2" msprop:Generator_UserColumnName="Campo16_2">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo16_3" msprop:Generator_ColumnPropNameInTable="Campo16_3Column" msprop:Generator_ColumnVarNameInTable="columnCampo16_3" msprop:Generator_UserColumnName="Campo16_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="51" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_4" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo16_4" msprop:Generator_ColumnPropNameInTable="Campo16_4Column" msprop:Generator_ColumnVarNameInTable="columnCampo16_4" msprop:Generator_UserColumnName="Campo16_4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Campo16_5" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Campo16_5" msprop:Generator_ColumnPropNameInTable="Campo16_5Column" msprop:Generator_ColumnVarNameInTable="columnCampo16_5" msprop:Generator_UserColumnName="Campo16_5" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="9" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="BarcodeBaseUrl" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="BarcodeBaseUrl" msprop:Generator_ColumnPropNameInTable="BarcodeBaseUrlColumn" msprop:Generator_ColumnVarNameInTable="columnBarcodeBaseUrl" msprop:Generator_UserColumnName="BarcodeBaseUrl" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prt_CartellinoPedane" msprop:Generator_RowClassName="stp_prt_CartellinoPedaneRow" msprop:Generator_RowEvHandlerName="stp_prt_CartellinoPedaneRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_prt_CartellinoPedaneRowDeleted" msprop:Generator_RowDeletingName="stp_prt_CartellinoPedaneRowDeleting" msprop:Generator_RowEvArgName="stp_prt_CartellinoPedaneRowChangeEvent" msprop:Generator_TablePropName="stp_prt_CartellinoPedane" msprop:Generator_RowChangedName="stp_prt_CartellinoPedaneRowChanged" msprop:Generator_RowChangingName="stp_prt_CartellinoPedaneRowChanging" msprop:Generator_TableClassName="stp_prt_CartellinoPedaneDataTable" msprop:Generator_UserTableName="stp_prt_CartellinoPedane" msprop:Generator_TableVarName="tablestp_prt_CartellinoPedane">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="CodPedana" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="CodPedana" msprop:Generator_ColumnPropNameInTable="CodPedanaColumn" msprop:Generator_ColumnVarNameInTable="columnCodPedana" msprop:Generator_UserColumnName="CodPedana">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumPedana" msprop:Generator_ColumnPropNameInRow="NumPedana" msprop:Generator_ColumnPropNameInTable="NumPedanaColumn" msprop:Generator_ColumnVarNameInTable="columnNumPedana" msprop:Generator_UserColumnName="NumPedana">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="PesoPedana" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="PesoPedana" msprop:Generator_ColumnPropNameInTable="PesoPedanaColumn" msprop:Generator_ColumnVarNameInTable="columnPesoPedana" msprop:Generator_UserColumnName="PesoPedana" type="xs:decimal" />
|
|
<xs:element name="DescDest_1" msprop:Generator_ColumnPropNameInRow="DescDest_1" msprop:Generator_ColumnPropNameInTable="DescDest_1Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_1" msprop:Generator_UserColumnName="DescDest_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDest_2" msprop:Generator_ColumnPropNameInRow="DescDest_2" msprop:Generator_ColumnPropNameInTable="DescDest_2Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_2" msprop:Generator_UserColumnName="DescDest_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDest_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescDest_3" msprop:Generator_ColumnPropNameInTable="DescDest_3Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_3" msprop:Generator_UserColumnName="DescDest_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="365" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="NumColli" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumColli" msprop:Generator_ColumnPropNameInTable="NumColliColumn" msprop:Generator_ColumnVarNameInTable="columnNumColli" msprop:Generator_UserColumnName="NumColli" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DataPedana" msprop:Generator_ColumnPropNameInRow="DataPedana" msprop:Generator_ColumnPropNameInTable="DataPedanaColumn" msprop:Generator_ColumnVarNameInTable="columnDataPedana" msprop:Generator_UserColumnName="DataPedana" type="xs:dateTime" />
|
|
<xs:element name="BarcodeBaseUrl" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="BarcodeBaseUrl" msprop:Generator_ColumnPropNameInTable="BarcodeBaseUrlColumn" msprop:Generator_ColumnVarNameInTable="columnBarcodeBaseUrl" msprop:Generator_UserColumnName="BarcodeBaseUrl" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescPack" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescPack" msprop:Generator_ColumnPropNameInTable="DescPackColumn" msprop:Generator_ColumnVarNameInTable="columnDescPack" msprop:Generator_UserColumnName="DescPack" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="503" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prt_CartellinoSemilavorati" msprop:Generator_RowEvHandlerName="stp_prt_CartellinoSemilavoratiRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_prt_CartellinoSemilavoratiRowDeleted" msprop:Generator_RowDeletingName="stp_prt_CartellinoSemilavoratiRowDeleting" msprop:Generator_RowEvArgName="stp_prt_CartellinoSemilavoratiRowChangeEvent" msprop:Generator_TablePropName="stp_prt_CartellinoSemilavorati" msprop:Generator_RowChangedName="stp_prt_CartellinoSemilavoratiRowChanged" msprop:Generator_RowChangingName="stp_prt_CartellinoSemilavoratiRowChanging" msprop:Generator_TableClassName="stp_prt_CartellinoSemilavoratiDataTable" msprop:Generator_RowClassName="stp_prt_CartellinoSemilavoratiRow" msprop:Generator_TableVarName="tablestp_prt_CartellinoSemilavorati" msprop:Generator_UserTableName="stp_prt_CartellinoSemilavorati">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DataDDT" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DataDDT" msprop:Generator_ColumnPropNameInTable="DataDDTColumn" msprop:Generator_ColumnVarNameInTable="columnDataDDT" msprop:Generator_UserColumnName="DataDDT" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="NumDDT" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="NumDDT" msprop:Generator_ColumnPropNameInTable="NumDDTColumn" msprop:Generator_ColumnVarNameInTable="columnNumDDT" msprop:Generator_UserColumnName="NumDDT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescFornit" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescFornit" msprop:Generator_ColumnPropNameInTable="DescFornitColumn" msprop:Generator_ColumnVarNameInTable="columnDescFornit" msprop:Generator_UserColumnName="DescFornit" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescArticolo" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescArticolo" msprop:Generator_ColumnPropNameInTable="DescArticoloColumn" msprop:Generator_ColumnVarNameInTable="columnDescArticolo" msprop:Generator_UserColumnName="DescArticolo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodInterno" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="CodInterno" msprop:Generator_ColumnPropNameInTable="CodInternoColumn" msprop:Generator_ColumnVarNameInTable="columnCodInterno" msprop:Generator_UserColumnName="CodInterno" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Lotto" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="Lotto" msprop:Generator_ColumnPropNameInTable="LottoColumn" msprop:Generator_ColumnVarNameInTable="columnLotto" msprop:Generator_UserColumnName="Lotto">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="15" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DataLotto" msprop:Generator_ColumnPropNameInRow="DataLotto" msprop:Generator_ColumnPropNameInTable="DataLottoColumn" msprop:Generator_ColumnVarNameInTable="columnDataLotto" msprop:Generator_UserColumnName="DataLotto" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="NoteLotto" msprop:Generator_ColumnPropNameInRow="NoteLotto" msprop:Generator_ColumnPropNameInTable="NoteLottoColumn" msprop:Generator_ColumnVarNameInTable="columnNoteLotto" msprop:Generator_UserColumnName="NoteLotto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="BarcodeBaseUrl" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="BarcodeBaseUrl" msprop:Generator_ColumnPropNameInTable="BarcodeBaseUrlColumn" msprop:Generator_ColumnVarNameInTable="columnBarcodeBaseUrl" msprop:Generator_UserColumnName="BarcodeBaseUrl" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prt_ReportPackList" msprop:Generator_RowClassName="stp_prt_ReportPackListRow" msprop:Generator_RowEvHandlerName="stp_prt_ReportPackListRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_prt_ReportPackListRowDeleted" msprop:Generator_RowDeletingName="stp_prt_ReportPackListRowDeleting" msprop:Generator_RowEvArgName="stp_prt_ReportPackListRowChangeEvent" msprop:Generator_TablePropName="stp_prt_ReportPackList" msprop:Generator_RowChangedName="stp_prt_ReportPackListRowChanged" msprop:Generator_RowChangingName="stp_prt_ReportPackListRowChanging" msprop:Generator_TableClassName="stp_prt_ReportPackListDataTable" msprop:Generator_UserTableName="stp_prt_ReportPackList" msprop:Generator_TableVarName="tablestp_prt_ReportPackList">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="PackListID" msprop:Generator_ColumnPropNameInRow="PackListID" msprop:Generator_ColumnPropNameInTable="PackListIDColumn" msprop:Generator_ColumnVarNameInTable="columnPackListID" msprop:Generator_UserColumnName="PackListID" type="xs:int" />
|
|
<xs:element name="PackDescr" msprop:Generator_ColumnPropNameInRow="PackDescr" msprop:Generator_ColumnPropNameInTable="PackDescrColumn" msprop:Generator_ColumnVarNameInTable="columnPackDescr" msprop:Generator_UserColumnName="PackDescr">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSociale" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_ColumnVarNameInTable="columnRagSociale" msprop:Generator_UserColumnName="RagSociale">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AL" msprop:Generator_ColumnPropNameInRow="AL" msprop:Generator_ColumnPropNameInTable="ALColumn" msprop:Generator_ColumnVarNameInTable="columnAL" msprop:Generator_UserColumnName="AL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Peso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_UserColumnName="Peso" type="xs:decimal" />
|
|
<xs:element name="Tara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_UserColumnName="Tara" type="xs:decimal" />
|
|
<xs:element name="DescAL" msprop:Generator_ColumnPropNameInRow="DescAL" msprop:Generator_ColumnPropNameInTable="DescALColumn" msprop:Generator_ColumnVarNameInTable="columnDescAL" msprop:Generator_UserColumnName="DescAL">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Lotto" msprop:Generator_ColumnPropNameInRow="Lotto" msprop:Generator_ColumnPropNameInTable="LottoColumn" msprop:Generator_ColumnVarNameInTable="columnLotto" msprop:Generator_UserColumnName="Lotto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnVarNameInTable="columnCodArt" msprop:Generator_UserColumnName="CodArt" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="UDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_UserColumnName="UDC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_UserColumnName="Qta" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="CodArtCliente" msprop:Generator_ColumnPropNameInRow="CodArtCliente" msprop:Generator_ColumnPropNameInTable="CodArtClienteColumn" msprop:Generator_ColumnVarNameInTable="columnCodArtCliente" msprop:Generator_UserColumnName="CodArtCliente" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDest_1" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescDest_1" msprop:Generator_ColumnPropNameInTable="DescDest_1Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_1" msprop:Generator_UserColumnName="DescDest_1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDest_2" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescDest_2" msprop:Generator_ColumnPropNameInTable="DescDest_2Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_2" msprop:Generator_UserColumnName="DescDest_2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDest_3" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="DescDest_3" msprop:Generator_ColumnPropNameInTable="DescDest_3Column" msprop:Generator_ColumnVarNameInTable="columnDescDest_3" msprop:Generator_UserColumnName="DescDest_3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="stp_prt_ReportPackListFull" msprop:Generator_RowEvHandlerName="stp_prt_ReportPackListFullRowChangeEventHandler" msprop:Generator_RowDeletedName="stp_prt_ReportPackListFullRowDeleted" msprop:Generator_RowDeletingName="stp_prt_ReportPackListFullRowDeleting" msprop:Generator_RowEvArgName="stp_prt_ReportPackListFullRowChangeEvent" msprop:Generator_TablePropName="stp_prt_ReportPackListFull" msprop:Generator_RowChangedName="stp_prt_ReportPackListFullRowChanged" msprop:Generator_RowChangingName="stp_prt_ReportPackListFullRowChanging" msprop:Generator_TableClassName="stp_prt_ReportPackListFullDataTable" msprop:Generator_RowClassName="stp_prt_ReportPackListFullRow" msprop:Generator_TableVarName="tablestp_prt_ReportPackListFull" msprop:Generator_UserTableName="stp_prt_ReportPackListFull">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="PackListID" msprop:Generator_ColumnPropNameInRow="PackListID" msprop:Generator_ColumnPropNameInTable="PackListIDColumn" msprop:Generator_ColumnVarNameInTable="columnPackListID" msprop:Generator_UserColumnName="PackListID" type="xs:int" />
|
|
<xs:element name="PackDescr" msprop:Generator_ColumnPropNameInRow="PackDescr" msprop:Generator_ColumnPropNameInTable="PackDescrColumn" msprop:Generator_ColumnVarNameInTable="columnPackDescr" msprop:Generator_UserColumnName="PackDescr">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ModDate" msprop:Generator_ColumnPropNameInRow="ModDate" msprop:Generator_ColumnPropNameInTable="ModDateColumn" msprop:Generator_ColumnVarNameInTable="columnModDate" msprop:Generator_UserColumnName="ModDate" type="xs:dateTime" />
|
|
<xs:element name="CodCliente" msprop:Generator_ColumnPropNameInRow="CodCliente" msprop:Generator_ColumnPropNameInTable="CodClienteColumn" msprop:Generator_ColumnVarNameInTable="columnCodCliente" msprop:Generator_UserColumnName="CodCliente">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="StatusPack" msprop:Generator_ColumnPropNameInRow="StatusPack" msprop:Generator_ColumnPropNameInTable="StatusPackColumn" msprop:Generator_ColumnVarNameInTable="columnStatusPack" msprop:Generator_UserColumnName="StatusPack" type="xs:int" />
|
|
<xs:element name="DescStatusPack" msprop:Generator_ColumnPropNameInRow="DescStatusPack" msprop:Generator_ColumnPropNameInTable="DescStatusPackColumn" msprop:Generator_ColumnVarNameInTable="columnDescStatusPack" msprop:Generator_UserColumnName="DescStatusPack" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="OrderListID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="OrderListID" msprop:Generator_ColumnPropNameInTable="OrderListIDColumn" msprop:Generator_ColumnVarNameInTable="columnOrderListID" msprop:Generator_UserColumnName="OrderListID" type="xs:int" />
|
|
<xs:element name="ExtOrdCod" msprop:Generator_ColumnPropNameInRow="ExtOrdCod" msprop:Generator_ColumnPropNameInTable="ExtOrdCodColumn" msprop:Generator_ColumnVarNameInTable="columnExtOrdCod" msprop:Generator_UserColumnName="ExtOrdCod">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_UserColumnName="DueDate" type="xs:dateTime" />
|
|
<xs:element name="CodArt" msprop:Generator_ColumnPropNameInRow="CodArt" msprop:Generator_ColumnPropNameInTable="CodArtColumn" msprop:Generator_ColumnVarNameInTable="columnCodArt" msprop:Generator_UserColumnName="CodArt">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="QtyOrd" msprop:Generator_ColumnPropNameInRow="QtyOrd" msprop:Generator_ColumnPropNameInTable="QtyOrdColumn" msprop:Generator_ColumnVarNameInTable="columnQtyOrd" msprop:Generator_UserColumnName="QtyOrd" type="xs:int" />
|
|
<xs:element name="OrdDescr" msprop:Generator_ColumnPropNameInRow="OrdDescr" msprop:Generator_ColumnPropNameInTable="OrdDescrColumn" msprop:Generator_ColumnVarNameInTable="columnOrdDescr" msprop:Generator_UserColumnName="OrdDescr" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodCliOrd" msprop:Generator_ColumnPropNameInRow="CodCliOrd" msprop:Generator_ColumnPropNameInTable="CodCliOrdColumn" msprop:Generator_ColumnVarNameInTable="columnCodCliOrd" msprop:Generator_UserColumnName="CodCliOrd">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CodDestinazione" msprop:Generator_ColumnPropNameInRow="CodDestinazione" msprop:Generator_ColumnPropNameInTable="CodDestinazioneColumn" msprop:Generator_ColumnVarNameInTable="columnCodDestinazione" msprop:Generator_UserColumnName="CodDestinazione">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescrArt" msprop:Generator_ColumnPropNameInRow="DescrArt" msprop:Generator_ColumnPropNameInTable="DescrArtColumn" msprop:Generator_ColumnVarNameInTable="columnDescrArt" msprop:Generator_UserColumnName="DescrArt">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RagSociale" msprop:Generator_ColumnPropNameInRow="RagSociale" msprop:Generator_ColumnPropNameInTable="RagSocialeColumn" msprop:Generator_ColumnVarNameInTable="columnRagSociale" msprop:Generator_UserColumnName="RagSociale">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Indirizzo" msprop:Generator_ColumnPropNameInRow="Indirizzo" msprop:Generator_ColumnPropNameInTable="IndirizzoColumn" msprop:Generator_ColumnVarNameInTable="columnIndirizzo" msprop:Generator_UserColumnName="Indirizzo">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Localita" msprop:Generator_ColumnPropNameInRow="Localita" msprop:Generator_ColumnPropNameInTable="LocalitaColumn" msprop:Generator_ColumnVarNameInTable="columnLocalita" msprop:Generator_UserColumnName="Localita">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Cap" msprop:Generator_ColumnPropNameInRow="Cap" msprop:Generator_ColumnPropNameInTable="CapColumn" msprop:Generator_ColumnVarNameInTable="columnCap" msprop:Generator_UserColumnName="Cap">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Provincia" msprop:Generator_ColumnPropNameInRow="Provincia" msprop:Generator_ColumnPropNameInTable="ProvinciaColumn" msprop:Generator_ColumnVarNameInTable="columnProvincia" msprop:Generator_UserColumnName="Provincia">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Nazione" msprop:Generator_ColumnPropNameInRow="Nazione" msprop:Generator_ColumnPropNameInTable="NazioneColumn" msprop:Generator_ColumnVarNameInTable="columnNazione" msprop:Generator_UserColumnName="Nazione">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DescDestinazione" msprop:Generator_ColumnPropNameInRow="DescDestinazione" msprop:Generator_ColumnPropNameInTable="DescDestinazioneColumn" msprop:Generator_ColumnVarNameInTable="columnDescDestinazione" msprop:Generator_UserColumnName="DescDestinazione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestIndirizzo" msprop:Generator_ColumnPropNameInRow="DestIndirizzo" msprop:Generator_ColumnPropNameInTable="DestIndirizzoColumn" msprop:Generator_ColumnVarNameInTable="columnDestIndirizzo" msprop:Generator_UserColumnName="DestIndirizzo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestCap" msprop:Generator_ColumnPropNameInRow="DestCap" msprop:Generator_ColumnPropNameInTable="DestCapColumn" msprop:Generator_ColumnVarNameInTable="columnDestCap" msprop:Generator_UserColumnName="DestCap" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestLocalita" msprop:Generator_ColumnPropNameInRow="DestLocalita" msprop:Generator_ColumnPropNameInTable="DestLocalitaColumn" msprop:Generator_ColumnVarNameInTable="columnDestLocalita" msprop:Generator_UserColumnName="DestLocalita" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestProvincia" msprop:Generator_ColumnPropNameInRow="DestProvincia" msprop:Generator_ColumnPropNameInTable="DestProvinciaColumn" msprop:Generator_ColumnVarNameInTable="columnDestProvincia" msprop:Generator_UserColumnName="DestProvincia" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DestNazione" msprop:Generator_ColumnPropNameInRow="DestNazione" msprop:Generator_ColumnPropNameInTable="DestNazioneColumn" msprop:Generator_ColumnVarNameInTable="columnDestNazione" msprop:Generator_UserColumnName="DestNazione" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="AL" msprop:Generator_ColumnPropNameInRow="AL" msprop:Generator_ColumnPropNameInTable="ALColumn" msprop:Generator_ColumnVarNameInTable="columnAL" msprop:Generator_UserColumnName="AL" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="StatusAL" msprop:Generator_ColumnPropNameInRow="StatusAL" msprop:Generator_ColumnPropNameInTable="StatusALColumn" msprop:Generator_ColumnVarNameInTable="columnStatusAL" msprop:Generator_UserColumnName="StatusAL" type="xs:int" minOccurs="0" />
|
|
<xs:element name="DescAL" msprop:Generator_ColumnPropNameInRow="DescAL" msprop:Generator_ColumnPropNameInTable="DescALColumn" msprop:Generator_ColumnVarNameInTable="columnDescAL" msprop:Generator_UserColumnName="DescAL" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Peso" msprop:Generator_ColumnPropNameInRow="Peso" msprop:Generator_ColumnPropNameInTable="PesoColumn" msprop:Generator_ColumnVarNameInTable="columnPeso" msprop:Generator_UserColumnName="Peso" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="Tara" msprop:Generator_ColumnPropNameInRow="Tara" msprop:Generator_ColumnPropNameInTable="TaraColumn" msprop:Generator_ColumnVarNameInTable="columnTara" msprop:Generator_UserColumnName="Tara" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="UDC" msprop:Generator_ColumnPropNameInRow="UDC" msprop:Generator_ColumnPropNameInTable="UDCColumn" msprop:Generator_ColumnVarNameInTable="columnUDC" msprop:Generator_UserColumnName="UDC" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="ALOrder" msprop:Generator_ColumnPropNameInRow="ALOrder" msprop:Generator_ColumnPropNameInTable="ALOrderColumn" msprop:Generator_ColumnVarNameInTable="columnALOrder" msprop:Generator_UserColumnName="ALOrder" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Lotto" msprop:Generator_ColumnPropNameInRow="Lotto" msprop:Generator_ColumnPropNameInTable="LottoColumn" msprop:Generator_ColumnVarNameInTable="columnLotto" msprop:Generator_UserColumnName="Lotto" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Qta" msprop:Generator_ColumnPropNameInRow="Qta" msprop:Generator_ColumnPropNameInTable="QtaColumn" msprop:Generator_ColumnVarNameInTable="columnQta" msprop:Generator_UserColumnName="Qta" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="IdxODL" msprop:Generator_ColumnPropNameInRow="IdxODL" msprop:Generator_ColumnPropNameInTable="IdxODLColumn" msprop:Generator_ColumnVarNameInTable="columnIdxODL" msprop:Generator_UserColumnName="IdxODL" type="xs:int" minOccurs="0" />
|
|
<xs:element name="RifExt" msprop:Generator_ColumnPropNameInRow="RifExt" msprop:Generator_ColumnPropNameInTable="RifExtColumn" msprop:Generator_ColumnVarNameInTable="columnRifExt" msprop:Generator_UserColumnName="RifExt" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DtCrea" msprop:Generator_ColumnPropNameInRow="DtCrea" msprop:Generator_ColumnPropNameInTable="DtCreaColumn" msprop:Generator_ColumnVarNameInTable="columnDtCrea" msprop:Generator_UserColumnName="DtCrea" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="Attivo" msprop:Generator_ColumnPropNameInRow="Attivo" msprop:Generator_ColumnPropNameInTable="AttivoColumn" msprop:Generator_ColumnVarNameInTable="columnAttivo" msprop:Generator_UserColumnName="Attivo" type="xs:boolean" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:PrintJobQueue" />
|
|
<xs:field xpath="mstns:IdxPrintJob" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_prt_CartellinoFinitiOdette_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_prt_CartellinoFinitiOdette" />
|
|
<xs:field xpath="mstns:CampoUDC" />
|
|
</xs:unique>
|
|
<xs:unique name="stp_prt_CartellinoPedane_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:stp_prt_CartellinoPedane" />
|
|
<xs:field xpath="mstns:CodPedana" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |