1170 lines
200 KiB
XML
1170 lines
200 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="DS_import" targetNamespace="http://tempuri.org/DS_import.xsd" xmlns:mstns="http://tempuri.org/DS_import.xsd" xmlns="http://tempuri.org/DS_import.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="1" FunctionsComponentName="caricaSwingData" GeneratorFunctionsComponentClassName="caricaSwingData" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="caricaSwingData" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
<Connections>
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="si_dt30ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="si_dt30ConnectionString (Settings)" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.si_dt30ConnectionString" Provider="System.Data.OleDb" />
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Equa_XPSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Equa_XPSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.XPS_data.Properties.Settings.GlobalReference.Default.Equa_XPSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="aclTableAdapter" GeneratorDataComponentClassName="aclTableAdapter" Name="acl" UserDataComponentName="aclTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="si_dt30ConnectionString (Settings)" DbObjectName="acl" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
<DeleteCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>DELETE FROM `acl` WHERE ((`clcodcn` = ?) AND ((? = 1 AND `clragd` IS NULL) OR (`clragd` = ?)) AND ((? = 1 AND `cl_flcanc` IS NULL) OR (`cl_flcanc` = ?)) AND ((? = 1 AND `clcod` IS NULL) OR (`clcod` = ?)) AND ((? = 1 AND `clcdpiva` IS NULL) OR (`clcdpiva` = ?)) AND ((? = 1 AND `clindi` IS NULL) OR (`clindi` = ?)) AND ((? = 1 AND `clloca` IS NULL) OR (`clloca` = ?)) AND ((? = 1 AND `clcapo` IS NULL) OR (`clcapo` = ?)) AND ((? = 1 AND `clprov` IS NULL) OR (`clprov` = ?)) AND ((? = 1 AND `cldist` IS NULL) OR (`cldist` = ?)) AND ((? = 1 AND `clstat` IS NULL) OR (`clstat` = ?)) AND ((? = 1 AND `clstatiso` IS NULL) OR (`clstatiso` = ?)) AND ((? = 1 AND `clcdfi` IS NULL) OR (`clcdfi` = ?)) AND ((? = 1 AND `clindidomfisc` IS NULL) OR (`clindidomfisc` = ?)) AND ((? = 1 AND `cllocadomfisc` IS NULL) OR (`cllocadomfisc` = ?)) AND ((? = 1 AND `clcapodomfisc` IS NULL) OR (`clcapodomfisc` = ?)) AND ((? = 1 AND `clprovdomfisc` IS NULL) OR (`clprovdomfisc` = ?)) AND ((? = 1 AND `cldistdomfisc` IS NULL) OR (`cldistdomfisc` = ?)) AND ((? = 1 AND `clstatdomfisc` IS NULL) OR (`clstatdomfisc` = ?)) AND ((? = 1 AND `clstatisodomfisc` IS NULL) OR (`clstatisodomfisc` = ?)) AND ((? = 1 AND `clalle` IS NULL) OR (`clalle` = ?)) AND ((? = 1 AND `clfldi` IS NULL) OR (`clfldi` = ?)) AND ((? = 1 AND `clcognom` IS NULL) OR (`clcognom` = ?)) AND ((? = 1 AND `clnome` IS NULL) OR (`clnome` = ?)) AND ((? = 1 AND `cldtna` IS NULL) OR (`cldtna` = ?)) AND ((? = 1 AND `clcona` IS NULL) OR (`clcona` = ?)) AND ((? = 1 AND `clprna` IS NULL) OR (`clprna` = ?)) AND ((? = 1 AND `cluscn` IS NULL) OR (`cluscn` = ?)) AND ((? = 1 AND `clstna` IS NULL) OR (`clstna` = ?)) AND ((? = 1 AND `clsess` IS NULL) OR (`clsess` = ?)) AND ((? = 1 AND `clrita` IS NULL) OR (`clrita` = ?)) AND ((? = 1 AND `cl_zona` IS NULL) OR (`cl_zona` = ?)) AND ((? = 1 AND `clcategoria` IS NULL) OR (`clcategoria` = ?)) AND ((? = 1 AND `clcategoria2` IS NULL) OR (`clcategoria2` = ?)) AND ((? = 1 AND `cl_sett_att1` IS NULL) OR (`cl_sett_att1` = ?)) AND ((? = 1 AND `cl_sett_att2` IS NULL) OR (`cl_sett_att2` = ?)) AND ((? = 1 AND `cl_categco` IS NULL) OR (`cl_categco` = ?)) AND ((? = 1 AND `cl_ling` IS NULL) OR (`cl_ling` = ?)) AND ((? = 1 AND `cl_filiale` IS NULL) OR (`cl_filiale` = ?)) AND ((? = 1 AND `cl_cod_old` IS NULL) OR (`cl_cod_old` = ?)) AND ((? = 1 AND `cl_cod_gruppo` IS NULL) OR (`cl_cod_gruppo` = ?)) AND ((? = 1 AND `cl_vt1` IS NULL) OR (`cl_vt1` = ?)) AND ((? = 1 AND `cl_vt2` IS NULL) OR (`cl_vt2` = ?)) AND ((? = 1 AND `cl_vt3` IS NULL) OR (`cl_vt3` = ?)) AND ((? = 1 AND `cl_vt4` IS NULL) OR (`cl_vt4` = ?)) AND ((? = 1 AND `abc_pa_sol_csolv_ID` IS NULL) OR (`abc_pa_sol_csolv_ID` = ?)) AND ((? = 1 AND `cl_solv_dtupd` IS NULL) OR (`cl_solv_dtupd` = ?)) AND ((? = 1 AND `cldtfineutil` IS NULL) OR (`cldtfineutil` = ?)) AND ((? = 1 AND `cl_fl_decod_anag` IS NULL) OR (`cl_fl_decod_anag` = ?)) AND ((? = 1 AND `clindirec` IS NULL) OR (`clindirec` = ?)) AND ((? = 1 AND `cllocarec` IS NULL) OR (`cllocarec` = ?)) AND ((? = 1 AND `clcaporec` IS NULL) OR (`clcaporec` = ?)) AND ((? = 1 AND `clprovrec` IS NULL) OR (`clprovrec` = ?)) AND ((? = 1 AND `clnfaxrec` IS NULL) OR (`clnfaxrec` = ?)) AND ((? = 1 AND `cltelerec` IS NULL) OR (`cltelerec` = ?)) AND ((? = 1 AND `clprcinps` IS NULL) OR (`clprcinps` = ?)) AND ((? = 1 AND `clsuffreplica` IS NULL) OR (`clsuffreplica` = ?)) AND ((? = 1 AND `cldtins` IS NULL) OR (`cldtins` = ?)) AND ((? = 1 AND `cldtvalidini` IS NULL) OR (`cldtvalidini` = ?)) AND ((? = 1 AND `clcdaccisa` IS NULL) OR (`clcdaccisa` = ?)) AND ((? = 1 AND `clnicciaa` IS NULL) OR (`clnicciaa` = ?)) AND ((? = 1 AND `clnregimp` IS NULL) OR (`clnregimp` = ?)) AND ((? = 1 AND `clcod_estero` IS NULL) OR (`clcod_estero` = ?)) AND ((? = 1 AND `clemail` IS NULL) OR (`clemail` = ?)) AND ((? = 1 AND `clwww` IS NULL) OR (`clwww` = ?)) AND ((? = 1 AND `clctrib` IS NULL) OR (`clctrib` = ?)) AND ((? = 1 AND `clCodCausRit` IS NULL) OR (`clCodCausRit` = ?)) AND ((? = 1 AND `clQuadro` IS NULL) OR (`clQuadro` = ?)) AND ((? = 1 AND `cl_destStampe` IS NULL) OR (`cl_destStampe` = ?)) AND ((? = 1 AND `clragd_n` IS NULL) OR (`clragd_n` = ?)) AND ((? = 1 AND `clindi_n` IS NULL) OR (`clindi_n` = ?)) AND ((? = 1 AND `clloca_n` IS NULL) OR (`clloca_n` = ?)) AND ((? = 1 AND `clindidomfisc_n` IS NULL) OR (`clindidomfisc_n` = ?)) AND ((? = 1 AND `cllocadomfisc_n` IS NULL) OR (`cllocadomfisc_n` = ?)) AND ((? = 1 AND `clindirec_n` IS NULL) OR (`clindirec_n` = ?)) AND ((? = 1 AND `cllocarec_n` IS NULL) OR (`cllocarec_n` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcodcn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcodcn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clragd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clragd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_flcanc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_flcanc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcod" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdpiva" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdpiva" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clloca" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clloca" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcapo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcapo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprov" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprov" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldist" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cldist" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstat" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatiso" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatiso" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdfi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdfi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindidomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindidomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocadomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocadomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcapodomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcapodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprovdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprovdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldistdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cldistdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatisodomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatisodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clalle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clalle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clfldi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clfldi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcognom" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcognom" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtna" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcona" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cluscn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cluscn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clsess" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clsess" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clrita" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_clrita" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_zona" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_zona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcategoria" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcategoria" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcategoria2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcategoria2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_sett_att1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_sett_att1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_sett_att2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_sett_att2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_categco" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_categco" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_ling" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_ling" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_filiale" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_filiale" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_cod_old" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_cod_old" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_cod_gruppo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_cod_gruppo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_abc_pa_sol_csolv_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_abc_pa_sol_csolv_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_solv_dtupd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cl_solv_dtupd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtfineutil" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtfineutil" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_fl_decod_anag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_fl_decod_anag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindirec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindirec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocarec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocarec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcaporec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcaporec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprovrec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprovrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnfaxrec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnfaxrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cltelerec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cltelerec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprcinps" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_clprcinps" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clsuffreplica" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clsuffreplica" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtins" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtins" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtvalidini" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtvalidini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdaccisa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdaccisa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnicciaa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnicciaa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnregimp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnregimp" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcod_estero" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcod_estero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clemail" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clemail" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clwww" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clwww" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clctrib" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clctrib" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clCodCausRit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clCodCausRit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clQuadro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clQuadro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_destStampe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_destStampe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clragd_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clragd_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindi_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindi_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clloca_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clloca_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindidomfisc_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindidomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocadomfisc_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocadomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindirec_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindirec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocarec_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocarec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</DeleteCommand>
|
|
<InsertCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>INSERT INTO `acl` (`clcodcn`, `clragd`, `cl_flcanc`, `clcod`, `clcdpiva`, `clindi`, `clloca`, `clcapo`, `clprov`, `cldist`, `clstat`, `clstatiso`, `clcdfi`, `cltele`, `clnfax`, `clindidomfisc`, `cllocadomfisc`, `clcapodomfisc`, `clprovdomfisc`, `cldistdomfisc`, `clstatdomfisc`, `clstatisodomfisc`, `clteledomfisc`, `clnfaxdomfisc`, `clalle`, `clfldi`, `clcognom`, `clnome`, `cldtna`, `clcona`, `clprna`, `cluscn`, `clstna`, `clsess`, `clrita`, `clannot1`, `clannot2`, `cl_zona`, `clcategoria`, `clcategoria2`, `cl_sett_att1`, `cl_sett_att2`, `clnote`, `cl_categco`, `cl_ling`, `cl_filiale`, `cl_cod_old`, `cl_cod_gruppo`, `cl_vt1`, `cl_vt2`, `cl_vt3`, `cl_vt4`, `abc_pa_sol_csolv_ID`, `cl_solv_dtupd`, `cldtfineutil`, `cl_fl_decod_anag`, `clindirec`, `cllocarec`, `clcaporec`, `clprovrec`, `clnfaxrec`, `cltelerec`, `clprcinps`, `clsuffreplica`, `cldtins`, `cldtvalidini`, `clcdaccisa`, `clnicciaa`, `clnregimp`, `clcod_estero`, `clemail`, `clwww`, `clctrib`, `clCodCausRit`, `clQuadro`, `cl_destStampe`, `clragd_n`, `clindi_n`, `clloca_n`, `clindidomfisc_n`, `cllocadomfisc_n`, `clindirec_n`, `cllocarec_n`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcodcn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcodcn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clragd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_flcanc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcod" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdpiva" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clloca" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcapo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprov" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cldist" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstat" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatiso" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdfi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cltele" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="cltele" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfax" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnfax" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindidomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocadomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcapodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprovdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cldistdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatisodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clteledomfisc" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clteledomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfaxdomfisc" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnfaxdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clalle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clfldi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcognom" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtna" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cluscn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clsess" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="clrita" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clannot1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clannot1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clannot2" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clannot2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_zona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcategoria" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcategoria2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_sett_att1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_sett_att2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnote" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_categco" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_ling" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_filiale" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_cod_old" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_cod_gruppo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="abc_pa_sol_csolv_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cl_solv_dtupd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtfineutil" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_fl_decod_anag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindirec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocarec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcaporec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprovrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfaxrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cltelerec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="clprcinps" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clsuffreplica" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtins" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtvalidini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdaccisa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnicciaa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnregimp" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcod_estero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clemail" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clwww" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clctrib" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clCodCausRit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clQuadro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_destStampe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clragd_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindi_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clloca_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindidomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocadomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindirec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocarec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</InsertCommand>
|
|
<SelectCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>SELECT clcodcn, clragd, cl_flcanc, clcod, clcdpiva, clindi, clloca, clcapo, clprov, cldist, clstat, clstatiso, clcdfi, cltele, clnfax, clindidomfisc, cllocadomfisc, clcapodomfisc, clprovdomfisc, cldistdomfisc, clstatdomfisc, clstatisodomfisc, clteledomfisc, clnfaxdomfisc, clalle, clfldi, clcognom, clnome, cldtna, clcona, clprna, cluscn, clstna, clsess, clrita, clannot1, clannot2, cl_zona, clcategoria, clcategoria2, cl_sett_att1, cl_sett_att2, clnote, cl_categco, cl_ling, cl_filiale, cl_cod_old, cl_cod_gruppo, cl_vt1, cl_vt2, cl_vt3, cl_vt4, abc_pa_sol_csolv_ID, cl_solv_dtupd, cldtfineutil, cl_fl_decod_anag, clindirec, cllocarec, clcaporec, clprovrec, clnfaxrec, cltelerec, clprcinps, clsuffreplica, cldtins, cldtvalidini, clcdaccisa, clnicciaa, clnregimp, clcod_estero, clemail, clwww, clctrib, clCodCausRit, clQuadro, cl_destStampe, clragd_n, clindi_n, clloca_n, clindidomfisc_n, cllocadomfisc_n, clindirec_n, cllocarec_n FROM acl</CommandText>
|
|
<Parameters />
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
<UpdateCommand>
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
<CommandText>UPDATE `acl` SET `clcodcn` = ?, `clragd` = ?, `cl_flcanc` = ?, `clcod` = ?, `clcdpiva` = ?, `clindi` = ?, `clloca` = ?, `clcapo` = ?, `clprov` = ?, `cldist` = ?, `clstat` = ?, `clstatiso` = ?, `clcdfi` = ?, `cltele` = ?, `clnfax` = ?, `clindidomfisc` = ?, `cllocadomfisc` = ?, `clcapodomfisc` = ?, `clprovdomfisc` = ?, `cldistdomfisc` = ?, `clstatdomfisc` = ?, `clstatisodomfisc` = ?, `clteledomfisc` = ?, `clnfaxdomfisc` = ?, `clalle` = ?, `clfldi` = ?, `clcognom` = ?, `clnome` = ?, `cldtna` = ?, `clcona` = ?, `clprna` = ?, `cluscn` = ?, `clstna` = ?, `clsess` = ?, `clrita` = ?, `clannot1` = ?, `clannot2` = ?, `cl_zona` = ?, `clcategoria` = ?, `clcategoria2` = ?, `cl_sett_att1` = ?, `cl_sett_att2` = ?, `clnote` = ?, `cl_categco` = ?, `cl_ling` = ?, `cl_filiale` = ?, `cl_cod_old` = ?, `cl_cod_gruppo` = ?, `cl_vt1` = ?, `cl_vt2` = ?, `cl_vt3` = ?, `cl_vt4` = ?, `abc_pa_sol_csolv_ID` = ?, `cl_solv_dtupd` = ?, `cldtfineutil` = ?, `cl_fl_decod_anag` = ?, `clindirec` = ?, `cllocarec` = ?, `clcaporec` = ?, `clprovrec` = ?, `clnfaxrec` = ?, `cltelerec` = ?, `clprcinps` = ?, `clsuffreplica` = ?, `cldtins` = ?, `cldtvalidini` = ?, `clcdaccisa` = ?, `clnicciaa` = ?, `clnregimp` = ?, `clcod_estero` = ?, `clemail` = ?, `clwww` = ?, `clctrib` = ?, `clCodCausRit` = ?, `clQuadro` = ?, `cl_destStampe` = ?, `clragd_n` = ?, `clindi_n` = ?, `clloca_n` = ?, `clindidomfisc_n` = ?, `cllocadomfisc_n` = ?, `clindirec_n` = ?, `cllocarec_n` = ? WHERE ((`clcodcn` = ?) AND ((? = 1 AND `clragd` IS NULL) OR (`clragd` = ?)) AND ((? = 1 AND `cl_flcanc` IS NULL) OR (`cl_flcanc` = ?)) AND ((? = 1 AND `clcod` IS NULL) OR (`clcod` = ?)) AND ((? = 1 AND `clcdpiva` IS NULL) OR (`clcdpiva` = ?)) AND ((? = 1 AND `clindi` IS NULL) OR (`clindi` = ?)) AND ((? = 1 AND `clloca` IS NULL) OR (`clloca` = ?)) AND ((? = 1 AND `clcapo` IS NULL) OR (`clcapo` = ?)) AND ((? = 1 AND `clprov` IS NULL) OR (`clprov` = ?)) AND ((? = 1 AND `cldist` IS NULL) OR (`cldist` = ?)) AND ((? = 1 AND `clstat` IS NULL) OR (`clstat` = ?)) AND ((? = 1 AND `clstatiso` IS NULL) OR (`clstatiso` = ?)) AND ((? = 1 AND `clcdfi` IS NULL) OR (`clcdfi` = ?)) AND ((? = 1 AND `clindidomfisc` IS NULL) OR (`clindidomfisc` = ?)) AND ((? = 1 AND `cllocadomfisc` IS NULL) OR (`cllocadomfisc` = ?)) AND ((? = 1 AND `clcapodomfisc` IS NULL) OR (`clcapodomfisc` = ?)) AND ((? = 1 AND `clprovdomfisc` IS NULL) OR (`clprovdomfisc` = ?)) AND ((? = 1 AND `cldistdomfisc` IS NULL) OR (`cldistdomfisc` = ?)) AND ((? = 1 AND `clstatdomfisc` IS NULL) OR (`clstatdomfisc` = ?)) AND ((? = 1 AND `clstatisodomfisc` IS NULL) OR (`clstatisodomfisc` = ?)) AND ((? = 1 AND `clalle` IS NULL) OR (`clalle` = ?)) AND ((? = 1 AND `clfldi` IS NULL) OR (`clfldi` = ?)) AND ((? = 1 AND `clcognom` IS NULL) OR (`clcognom` = ?)) AND ((? = 1 AND `clnome` IS NULL) OR (`clnome` = ?)) AND ((? = 1 AND `cldtna` IS NULL) OR (`cldtna` = ?)) AND ((? = 1 AND `clcona` IS NULL) OR (`clcona` = ?)) AND ((? = 1 AND `clprna` IS NULL) OR (`clprna` = ?)) AND ((? = 1 AND `cluscn` IS NULL) OR (`cluscn` = ?)) AND ((? = 1 AND `clstna` IS NULL) OR (`clstna` = ?)) AND ((? = 1 AND `clsess` IS NULL) OR (`clsess` = ?)) AND ((? = 1 AND `clrita` IS NULL) OR (`clrita` = ?)) AND ((? = 1 AND `cl_zona` IS NULL) OR (`cl_zona` = ?)) AND ((? = 1 AND `clcategoria` IS NULL) OR (`clcategoria` = ?)) AND ((? = 1 AND `clcategoria2` IS NULL) OR (`clcategoria2` = ?)) AND ((? = 1 AND `cl_sett_att1` IS NULL) OR (`cl_sett_att1` = ?)) AND ((? = 1 AND `cl_sett_att2` IS NULL) OR (`cl_sett_att2` = ?)) AND ((? = 1 AND `cl_categco` IS NULL) OR (`cl_categco` = ?)) AND ((? = 1 AND `cl_ling` IS NULL) OR (`cl_ling` = ?)) AND ((? = 1 AND `cl_filiale` IS NULL) OR (`cl_filiale` = ?)) AND ((? = 1 AND `cl_cod_old` IS NULL) OR (`cl_cod_old` = ?)) AND ((? = 1 AND `cl_cod_gruppo` IS NULL) OR (`cl_cod_gruppo` = ?)) AND ((? = 1 AND `cl_vt1` IS NULL) OR (`cl_vt1` = ?)) AND ((? = 1 AND `cl_vt2` IS NULL) OR (`cl_vt2` = ?)) AND ((? = 1 AND `cl_vt3` IS NULL) OR (`cl_vt3` = ?)) AND ((? = 1 AND `cl_vt4` IS NULL) OR (`cl_vt4` = ?)) AND ((? = 1 AND `abc_pa_sol_csolv_ID` IS NULL) OR (`abc_pa_sol_csolv_ID` = ?)) AND ((? = 1 AND `cl_solv_dtupd` IS NULL) OR (`cl_solv_dtupd` = ?)) AND ((? = 1 AND `cldtfineutil` IS NULL) OR (`cldtfineutil` = ?)) AND ((? = 1 AND `cl_fl_decod_anag` IS NULL) OR (`cl_fl_decod_anag` = ?)) AND ((? = 1 AND `clindirec` IS NULL) OR (`clindirec` = ?)) AND ((? = 1 AND `cllocarec` IS NULL) OR (`cllocarec` = ?)) AND ((? = 1 AND `clcaporec` IS NULL) OR (`clcaporec` = ?)) AND ((? = 1 AND `clprovrec` IS NULL) OR (`clprovrec` = ?)) AND ((? = 1 AND `clnfaxrec` IS NULL) OR (`clnfaxrec` = ?)) AND ((? = 1 AND `cltelerec` IS NULL) OR (`cltelerec` = ?)) AND ((? = 1 AND `clprcinps` IS NULL) OR (`clprcinps` = ?)) AND ((? = 1 AND `clsuffreplica` IS NULL) OR (`clsuffreplica` = ?)) AND ((? = 1 AND `cldtins` IS NULL) OR (`cldtins` = ?)) AND ((? = 1 AND `cldtvalidini` IS NULL) OR (`cldtvalidini` = ?)) AND ((? = 1 AND `clcdaccisa` IS NULL) OR (`clcdaccisa` = ?)) AND ((? = 1 AND `clnicciaa` IS NULL) OR (`clnicciaa` = ?)) AND ((? = 1 AND `clnregimp` IS NULL) OR (`clnregimp` = ?)) AND ((? = 1 AND `clcod_estero` IS NULL) OR (`clcod_estero` = ?)) AND ((? = 1 AND `clemail` IS NULL) OR (`clemail` = ?)) AND ((? = 1 AND `clwww` IS NULL) OR (`clwww` = ?)) AND ((? = 1 AND `clctrib` IS NULL) OR (`clctrib` = ?)) AND ((? = 1 AND `clCodCausRit` IS NULL) OR (`clCodCausRit` = ?)) AND ((? = 1 AND `clQuadro` IS NULL) OR (`clQuadro` = ?)) AND ((? = 1 AND `cl_destStampe` IS NULL) OR (`cl_destStampe` = ?)) AND ((? = 1 AND `clragd_n` IS NULL) OR (`clragd_n` = ?)) AND ((? = 1 AND `clindi_n` IS NULL) OR (`clindi_n` = ?)) AND ((? = 1 AND `clloca_n` IS NULL) OR (`clloca_n` = ?)) AND ((? = 1 AND `clindidomfisc_n` IS NULL) OR (`clindidomfisc_n` = ?)) AND ((? = 1 AND `cllocadomfisc_n` IS NULL) OR (`cllocadomfisc_n` = ?)) AND ((? = 1 AND `clindirec_n` IS NULL) OR (`clindirec_n` = ?)) AND ((? = 1 AND `cllocarec_n` IS NULL) OR (`cllocarec_n` = ?)))</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcodcn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcodcn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clragd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_flcanc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcod" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdpiva" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clloca" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcapo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprov" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cldist" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstat" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatiso" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdfi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cltele" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="cltele" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfax" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnfax" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindidomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocadomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcapodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprovdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cldistdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstatisodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clteledomfisc" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clteledomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfaxdomfisc" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnfaxdomfisc" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clalle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clfldi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcognom" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtna" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cluscn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clstna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clsess" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="clrita" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clannot1" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clannot1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clannot2" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clannot2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_zona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcategoria" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcategoria2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_sett_att1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_sett_att2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnote" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="clnote" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_categco" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_ling" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_filiale" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_cod_old" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_cod_gruppo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_vt4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="abc_pa_sol_csolv_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cl_solv_dtupd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtfineutil" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_fl_decod_anag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindirec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocarec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcaporec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clprovrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnfaxrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cltelerec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="clprcinps" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clsuffreplica" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtins" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cldtvalidini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcdaccisa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnicciaa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clnregimp" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clcod_estero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clemail" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clwww" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clctrib" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clCodCausRit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clQuadro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cl_destStampe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clragd_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindi_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clloca_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindidomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocadomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="clindirec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cllocarec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcodcn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcodcn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clragd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clragd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_flcanc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_flcanc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_flcanc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcod" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcod" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdpiva" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdpiva" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdpiva" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clloca" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clloca" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcapo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcapo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprov" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprov" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprov" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldist" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cldist" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldist" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstat" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstat" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatiso" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatiso" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatiso" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdfi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdfi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdfi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindidomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindidomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocadomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocadomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcapodomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcapodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcapodomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprovdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprovdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldistdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cldistdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cldistdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatdomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatdomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatdomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstatisodomfisc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstatisodomfisc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstatisodomfisc" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clalle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clalle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clalle" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clfldi" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clfldi" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clfldi" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcognom" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcognom" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcognom" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnome" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnome" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnome" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtna" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcona" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cluscn" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cluscn" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cluscn" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clstna" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clstna" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clstna" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clsess" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clsess" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsess" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clrita" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_clrita" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clrita" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_zona" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_zona" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_zona" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcategoria" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcategoria" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcategoria2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcategoria2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcategoria2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_sett_att1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_sett_att1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_sett_att2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_sett_att2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_sett_att2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_categco" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_categco" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_categco" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_ling" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_ling" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_ling" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_filiale" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_filiale" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_filiale" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_cod_old" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_cod_old" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_old" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_cod_gruppo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_cod_gruppo" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_cod_gruppo" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt1" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt1" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt2" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt2" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt3" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt3" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt3" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_vt4" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_vt4" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_vt4" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_abc_pa_sol_csolv_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_abc_pa_sol_csolv_ID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="abc_pa_sol_csolv_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_solv_dtupd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cl_solv_dtupd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cl_solv_dtupd" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtfineutil" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtfineutil" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtfineutil" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_fl_decod_anag" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_fl_decod_anag" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_fl_decod_anag" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindirec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindirec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocarec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocarec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcaporec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcaporec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcaporec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprovrec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clprovrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clprovrec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnfaxrec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnfaxrec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnfaxrec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cltelerec" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cltelerec" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cltelerec" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clprcinps" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_clprcinps" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="clprcinps" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clsuffreplica" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clsuffreplica" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clsuffreplica" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtins" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtins" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtins" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cldtvalidini" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cldtvalidini" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cldtvalidini" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcdaccisa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcdaccisa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcdaccisa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnicciaa" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnicciaa" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnicciaa" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clnregimp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clnregimp" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clnregimp" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clcod_estero" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clcod_estero" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clcod_estero" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clemail" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clemail" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clemail" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clwww" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clwww" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clwww" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clctrib" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clctrib" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clctrib" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clCodCausRit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clCodCausRit" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clCodCausRit" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clQuadro" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clQuadro" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clQuadro" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cl_destStampe" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cl_destStampe" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cl_destStampe" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clragd_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clragd_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clragd_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindi_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindi_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindi_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clloca_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clloca_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clloca_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindidomfisc_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindidomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindidomfisc_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocadomfisc_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocadomfisc_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocadomfisc_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_clindirec_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_clindirec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="clindirec_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cllocarec_n" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="true" SourceVersion="Original" />
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cllocarec_n" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cllocarec_n" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</UpdateCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="clcodcn" DataSetColumn="clcodcn" />
|
|
<Mapping SourceColumn="clragd" DataSetColumn="clragd" />
|
|
<Mapping SourceColumn="cl_flcanc" DataSetColumn="cl_flcanc" />
|
|
<Mapping SourceColumn="clcod" DataSetColumn="clcod" />
|
|
<Mapping SourceColumn="clcdpiva" DataSetColumn="clcdpiva" />
|
|
<Mapping SourceColumn="clindi" DataSetColumn="clindi" />
|
|
<Mapping SourceColumn="clloca" DataSetColumn="clloca" />
|
|
<Mapping SourceColumn="clcapo" DataSetColumn="clcapo" />
|
|
<Mapping SourceColumn="clprov" DataSetColumn="clprov" />
|
|
<Mapping SourceColumn="cldist" DataSetColumn="cldist" />
|
|
<Mapping SourceColumn="clstat" DataSetColumn="clstat" />
|
|
<Mapping SourceColumn="clstatiso" DataSetColumn="clstatiso" />
|
|
<Mapping SourceColumn="clcdfi" DataSetColumn="clcdfi" />
|
|
<Mapping SourceColumn="cltele" DataSetColumn="cltele" />
|
|
<Mapping SourceColumn="clnfax" DataSetColumn="clnfax" />
|
|
<Mapping SourceColumn="clindidomfisc" DataSetColumn="clindidomfisc" />
|
|
<Mapping SourceColumn="cllocadomfisc" DataSetColumn="cllocadomfisc" />
|
|
<Mapping SourceColumn="clcapodomfisc" DataSetColumn="clcapodomfisc" />
|
|
<Mapping SourceColumn="clprovdomfisc" DataSetColumn="clprovdomfisc" />
|
|
<Mapping SourceColumn="cldistdomfisc" DataSetColumn="cldistdomfisc" />
|
|
<Mapping SourceColumn="clstatdomfisc" DataSetColumn="clstatdomfisc" />
|
|
<Mapping SourceColumn="clstatisodomfisc" DataSetColumn="clstatisodomfisc" />
|
|
<Mapping SourceColumn="clteledomfisc" DataSetColumn="clteledomfisc" />
|
|
<Mapping SourceColumn="clnfaxdomfisc" DataSetColumn="clnfaxdomfisc" />
|
|
<Mapping SourceColumn="clalle" DataSetColumn="clalle" />
|
|
<Mapping SourceColumn="clfldi" DataSetColumn="clfldi" />
|
|
<Mapping SourceColumn="clcognom" DataSetColumn="clcognom" />
|
|
<Mapping SourceColumn="clnome" DataSetColumn="clnome" />
|
|
<Mapping SourceColumn="cldtna" DataSetColumn="cldtna" />
|
|
<Mapping SourceColumn="clcona" DataSetColumn="clcona" />
|
|
<Mapping SourceColumn="clprna" DataSetColumn="clprna" />
|
|
<Mapping SourceColumn="cluscn" DataSetColumn="cluscn" />
|
|
<Mapping SourceColumn="clstna" DataSetColumn="clstna" />
|
|
<Mapping SourceColumn="clsess" DataSetColumn="clsess" />
|
|
<Mapping SourceColumn="clrita" DataSetColumn="clrita" />
|
|
<Mapping SourceColumn="clannot1" DataSetColumn="clannot1" />
|
|
<Mapping SourceColumn="clannot2" DataSetColumn="clannot2" />
|
|
<Mapping SourceColumn="cl_zona" DataSetColumn="cl_zona" />
|
|
<Mapping SourceColumn="clcategoria" DataSetColumn="clcategoria" />
|
|
<Mapping SourceColumn="clcategoria2" DataSetColumn="clcategoria2" />
|
|
<Mapping SourceColumn="cl_sett_att1" DataSetColumn="cl_sett_att1" />
|
|
<Mapping SourceColumn="cl_sett_att2" DataSetColumn="cl_sett_att2" />
|
|
<Mapping SourceColumn="clnote" DataSetColumn="clnote" />
|
|
<Mapping SourceColumn="cl_categco" DataSetColumn="cl_categco" />
|
|
<Mapping SourceColumn="cl_ling" DataSetColumn="cl_ling" />
|
|
<Mapping SourceColumn="cl_filiale" DataSetColumn="cl_filiale" />
|
|
<Mapping SourceColumn="cl_cod_old" DataSetColumn="cl_cod_old" />
|
|
<Mapping SourceColumn="cl_cod_gruppo" DataSetColumn="cl_cod_gruppo" />
|
|
<Mapping SourceColumn="cl_vt1" DataSetColumn="cl_vt1" />
|
|
<Mapping SourceColumn="cl_vt2" DataSetColumn="cl_vt2" />
|
|
<Mapping SourceColumn="cl_vt3" DataSetColumn="cl_vt3" />
|
|
<Mapping SourceColumn="cl_vt4" DataSetColumn="cl_vt4" />
|
|
<Mapping SourceColumn="abc_pa_sol_csolv_ID" DataSetColumn="abc_pa_sol_csolv_ID" />
|
|
<Mapping SourceColumn="cl_solv_dtupd" DataSetColumn="cl_solv_dtupd" />
|
|
<Mapping SourceColumn="cldtfineutil" DataSetColumn="cldtfineutil" />
|
|
<Mapping SourceColumn="cl_fl_decod_anag" DataSetColumn="cl_fl_decod_anag" />
|
|
<Mapping SourceColumn="clindirec" DataSetColumn="clindirec" />
|
|
<Mapping SourceColumn="cllocarec" DataSetColumn="cllocarec" />
|
|
<Mapping SourceColumn="clcaporec" DataSetColumn="clcaporec" />
|
|
<Mapping SourceColumn="clprovrec" DataSetColumn="clprovrec" />
|
|
<Mapping SourceColumn="clnfaxrec" DataSetColumn="clnfaxrec" />
|
|
<Mapping SourceColumn="cltelerec" DataSetColumn="cltelerec" />
|
|
<Mapping SourceColumn="clprcinps" DataSetColumn="clprcinps" />
|
|
<Mapping SourceColumn="clsuffreplica" DataSetColumn="clsuffreplica" />
|
|
<Mapping SourceColumn="cldtins" DataSetColumn="cldtins" />
|
|
<Mapping SourceColumn="cldtvalidini" DataSetColumn="cldtvalidini" />
|
|
<Mapping SourceColumn="clcdaccisa" DataSetColumn="clcdaccisa" />
|
|
<Mapping SourceColumn="clnicciaa" DataSetColumn="clnicciaa" />
|
|
<Mapping SourceColumn="clnregimp" DataSetColumn="clnregimp" />
|
|
<Mapping SourceColumn="clcod_estero" DataSetColumn="clcod_estero" />
|
|
<Mapping SourceColumn="clemail" DataSetColumn="clemail" />
|
|
<Mapping SourceColumn="clwww" DataSetColumn="clwww" />
|
|
<Mapping SourceColumn="clctrib" DataSetColumn="clctrib" />
|
|
<Mapping SourceColumn="clCodCausRit" DataSetColumn="clCodCausRit" />
|
|
<Mapping SourceColumn="clQuadro" DataSetColumn="clQuadro" />
|
|
<Mapping SourceColumn="cl_destStampe" DataSetColumn="cl_destStampe" />
|
|
<Mapping SourceColumn="clragd_n" DataSetColumn="clragd_n" />
|
|
<Mapping SourceColumn="clindi_n" DataSetColumn="clindi_n" />
|
|
<Mapping SourceColumn="clloca_n" DataSetColumn="clloca_n" />
|
|
<Mapping SourceColumn="clindidomfisc_n" DataSetColumn="clindidomfisc_n" />
|
|
<Mapping SourceColumn="cllocadomfisc_n" DataSetColumn="cllocadomfisc_n" />
|
|
<Mapping SourceColumn="clindirec_n" DataSetColumn="clindirec_n" />
|
|
<Mapping SourceColumn="cllocarec_n" DataSetColumn="cllocarec_n" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources>
|
|
<DbSource ConnectionRef="Equa_XPSConnectionString (Settings)" DbObjectName="Equa_XPS_prod.dbo.stp_CaricaAnagCliSwing" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="stp_CaricaAnagCliSwing" MethodsParameterType="CLR" Modifier="Public" Name="stp_CaricaAnagCliSwing" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="stp_CaricaAnagCliSwing">
|
|
<SelectCommand>
|
|
<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
|
|
<CommandText>dbo.stp_CaricaAnagCliSwing</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="InputOutput" ParameterName="@esito" Precision="0" ProviderType="NVarChar" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</Sources>
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="DS_import" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DS_import" msprop:Generator_UserDSName="DS_import">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="acl" msprop:Generator_UserTableName="acl" msprop:Generator_RowEvArgName="aclRowChangeEvent" msprop:Generator_TableVarName="tableacl" msprop:Generator_TablePropName="acl" msprop:Generator_RowDeletingName="aclRowDeleting" msprop:Generator_RowChangingName="aclRowChanging" msprop:Generator_RowDeletedName="aclRowDeleted" msprop:Generator_RowEvHandlerName="aclRowChangeEventHandler" msprop:Generator_TableClassName="aclDataTable" msprop:Generator_RowChangedName="aclRowChanged" msprop:Generator_RowClassName="aclRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="clcodcn" msprop:Generator_ColumnVarNameInTable="columnclcodcn" msprop:Generator_ColumnPropNameInRow="clcodcn" msprop:Generator_ColumnPropNameInTable="clcodcnColumn" msprop:Generator_UserColumnName="clcodcn">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clragd" msprop:Generator_ColumnVarNameInTable="columnclragd" msprop:Generator_ColumnPropNameInRow="clragd" msprop:Generator_ColumnPropNameInTable="clragdColumn" msprop:Generator_UserColumnName="clragd" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="50" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_flcanc" msprop:Generator_ColumnVarNameInTable="columncl_flcanc" msprop:Generator_ColumnPropNameInRow="cl_flcanc" msprop:Generator_ColumnPropNameInTable="cl_flcancColumn" msprop:Generator_UserColumnName="cl_flcanc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcod" msprop:Generator_ColumnVarNameInTable="columnclcod" msprop:Generator_ColumnPropNameInRow="clcod" msprop:Generator_ColumnPropNameInTable="clcodColumn" msprop:Generator_UserColumnName="clcod" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcdpiva" msprop:Generator_ColumnVarNameInTable="columnclcdpiva" msprop:Generator_ColumnPropNameInRow="clcdpiva" msprop:Generator_ColumnPropNameInTable="clcdpivaColumn" msprop:Generator_UserColumnName="clcdpiva" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="12" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindi" msprop:Generator_ColumnVarNameInTable="columnclindi" msprop:Generator_ColumnPropNameInRow="clindi" msprop:Generator_ColumnPropNameInTable="clindiColumn" msprop:Generator_UserColumnName="clindi" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clloca" msprop:Generator_ColumnVarNameInTable="columnclloca" msprop:Generator_ColumnPropNameInRow="clloca" msprop:Generator_ColumnPropNameInTable="cllocaColumn" msprop:Generator_UserColumnName="clloca" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcapo" msprop:Generator_ColumnVarNameInTable="columnclcapo" msprop:Generator_ColumnPropNameInRow="clcapo" msprop:Generator_ColumnPropNameInTable="clcapoColumn" msprop:Generator_UserColumnName="clcapo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clprov" msprop:Generator_ColumnVarNameInTable="columnclprov" msprop:Generator_ColumnPropNameInRow="clprov" msprop:Generator_ColumnPropNameInTable="clprovColumn" msprop:Generator_UserColumnName="clprov" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cldist" msprop:Generator_ColumnVarNameInTable="columncldist" msprop:Generator_ColumnPropNameInRow="cldist" msprop:Generator_ColumnPropNameInTable="cldistColumn" msprop:Generator_UserColumnName="cldist" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clstat" msprop:Generator_ColumnVarNameInTable="columnclstat" msprop:Generator_ColumnPropNameInRow="clstat" msprop:Generator_ColumnPropNameInTable="clstatColumn" msprop:Generator_UserColumnName="clstat" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clstatiso" msprop:Generator_ColumnVarNameInTable="columnclstatiso" msprop:Generator_ColumnPropNameInRow="clstatiso" msprop:Generator_ColumnPropNameInTable="clstatisoColumn" msprop:Generator_UserColumnName="clstatiso" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcdfi" msprop:Generator_ColumnVarNameInTable="columnclcdfi" msprop:Generator_ColumnPropNameInRow="clcdfi" msprop:Generator_ColumnPropNameInTable="clcdfiColumn" msprop:Generator_UserColumnName="clcdfi" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="16" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cltele" msprop:Generator_ColumnVarNameInTable="columncltele" msprop:Generator_ColumnPropNameInRow="cltele" msprop:Generator_ColumnPropNameInTable="clteleColumn" msprop:Generator_UserColumnName="cltele" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnfax" msprop:Generator_ColumnVarNameInTable="columnclnfax" msprop:Generator_ColumnPropNameInRow="clnfax" msprop:Generator_ColumnPropNameInTable="clnfaxColumn" msprop:Generator_UserColumnName="clnfax" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindidomfisc" msprop:Generator_ColumnVarNameInTable="columnclindidomfisc" msprop:Generator_ColumnPropNameInRow="clindidomfisc" msprop:Generator_ColumnPropNameInTable="clindidomfiscColumn" msprop:Generator_UserColumnName="clindidomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cllocadomfisc" msprop:Generator_ColumnVarNameInTable="columncllocadomfisc" msprop:Generator_ColumnPropNameInRow="cllocadomfisc" msprop:Generator_ColumnPropNameInTable="cllocadomfiscColumn" msprop:Generator_UserColumnName="cllocadomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcapodomfisc" msprop:Generator_ColumnVarNameInTable="columnclcapodomfisc" msprop:Generator_ColumnPropNameInRow="clcapodomfisc" msprop:Generator_ColumnPropNameInTable="clcapodomfiscColumn" msprop:Generator_UserColumnName="clcapodomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clprovdomfisc" msprop:Generator_ColumnVarNameInTable="columnclprovdomfisc" msprop:Generator_ColumnPropNameInRow="clprovdomfisc" msprop:Generator_ColumnPropNameInTable="clprovdomfiscColumn" msprop:Generator_UserColumnName="clprovdomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cldistdomfisc" msprop:Generator_ColumnVarNameInTable="columncldistdomfisc" msprop:Generator_ColumnPropNameInRow="cldistdomfisc" msprop:Generator_ColumnPropNameInTable="cldistdomfiscColumn" msprop:Generator_UserColumnName="cldistdomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clstatdomfisc" msprop:Generator_ColumnVarNameInTable="columnclstatdomfisc" msprop:Generator_ColumnPropNameInRow="clstatdomfisc" msprop:Generator_ColumnPropNameInTable="clstatdomfiscColumn" msprop:Generator_UserColumnName="clstatdomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clstatisodomfisc" msprop:Generator_ColumnVarNameInTable="columnclstatisodomfisc" msprop:Generator_ColumnPropNameInRow="clstatisodomfisc" msprop:Generator_ColumnPropNameInTable="clstatisodomfiscColumn" msprop:Generator_UserColumnName="clstatisodomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clteledomfisc" msprop:Generator_ColumnVarNameInTable="columnclteledomfisc" msprop:Generator_ColumnPropNameInRow="clteledomfisc" msprop:Generator_ColumnPropNameInTable="clteledomfiscColumn" msprop:Generator_UserColumnName="clteledomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnfaxdomfisc" msprop:Generator_ColumnVarNameInTable="columnclnfaxdomfisc" msprop:Generator_ColumnPropNameInRow="clnfaxdomfisc" msprop:Generator_ColumnPropNameInTable="clnfaxdomfiscColumn" msprop:Generator_UserColumnName="clnfaxdomfisc" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clalle" msprop:Generator_ColumnVarNameInTable="columnclalle" msprop:Generator_ColumnPropNameInRow="clalle" msprop:Generator_ColumnPropNameInTable="clalleColumn" msprop:Generator_UserColumnName="clalle" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clfldi" msprop:Generator_ColumnVarNameInTable="columnclfldi" msprop:Generator_ColumnPropNameInRow="clfldi" msprop:Generator_ColumnPropNameInTable="clfldiColumn" msprop:Generator_UserColumnName="clfldi" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcognom" msprop:Generator_ColumnVarNameInTable="columnclcognom" msprop:Generator_ColumnPropNameInRow="clcognom" msprop:Generator_ColumnPropNameInTable="clcognomColumn" msprop:Generator_UserColumnName="clcognom" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="18" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnome" msprop:Generator_ColumnVarNameInTable="columnclnome" msprop:Generator_ColumnPropNameInRow="clnome" msprop:Generator_ColumnPropNameInTable="clnomeColumn" msprop:Generator_UserColumnName="clnome" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="16" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cldtna" msprop:Generator_ColumnVarNameInTable="columncldtna" msprop:Generator_ColumnPropNameInRow="cldtna" msprop:Generator_ColumnPropNameInTable="cldtnaColumn" msprop:Generator_UserColumnName="cldtna" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="clcona" msprop:Generator_ColumnVarNameInTable="columnclcona" msprop:Generator_ColumnPropNameInRow="clcona" msprop:Generator_ColumnPropNameInTable="clconaColumn" msprop:Generator_UserColumnName="clcona" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clprna" msprop:Generator_ColumnVarNameInTable="columnclprna" msprop:Generator_ColumnPropNameInRow="clprna" msprop:Generator_ColumnPropNameInTable="clprnaColumn" msprop:Generator_UserColumnName="clprna" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cluscn" msprop:Generator_ColumnVarNameInTable="columncluscn" msprop:Generator_ColumnPropNameInRow="cluscn" msprop:Generator_ColumnPropNameInTable="cluscnColumn" msprop:Generator_UserColumnName="cluscn" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="6" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clstna" msprop:Generator_ColumnVarNameInTable="columnclstna" msprop:Generator_ColumnPropNameInRow="clstna" msprop:Generator_ColumnPropNameInTable="clstnaColumn" msprop:Generator_UserColumnName="clstna" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clsess" msprop:Generator_ColumnVarNameInTable="columnclsess" msprop:Generator_ColumnPropNameInRow="clsess" msprop:Generator_ColumnPropNameInTable="clsessColumn" msprop:Generator_UserColumnName="clsess" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clrita" msprop:Generator_ColumnVarNameInTable="columnclrita" msprop:Generator_ColumnPropNameInRow="clrita" msprop:Generator_ColumnPropNameInTable="clritaColumn" msprop:Generator_UserColumnName="clrita" type="xs:float" minOccurs="0" />
|
|
<xs:element name="clannot1" msprop:Generator_ColumnVarNameInTable="columnclannot1" msprop:Generator_ColumnPropNameInRow="clannot1" msprop:Generator_ColumnPropNameInTable="clannot1Column" msprop:Generator_UserColumnName="clannot1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clannot2" msprop:Generator_ColumnVarNameInTable="columnclannot2" msprop:Generator_ColumnPropNameInRow="clannot2" msprop:Generator_ColumnPropNameInTable="clannot2Column" msprop:Generator_UserColumnName="clannot2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_zona" msprop:Generator_ColumnVarNameInTable="columncl_zona" msprop:Generator_ColumnPropNameInRow="cl_zona" msprop:Generator_ColumnPropNameInTable="cl_zonaColumn" msprop:Generator_UserColumnName="cl_zona" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcategoria" msprop:Generator_ColumnVarNameInTable="columnclcategoria" msprop:Generator_ColumnPropNameInRow="clcategoria" msprop:Generator_ColumnPropNameInTable="clcategoriaColumn" msprop:Generator_UserColumnName="clcategoria" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcategoria2" msprop:Generator_ColumnVarNameInTable="columnclcategoria2" msprop:Generator_ColumnPropNameInRow="clcategoria2" msprop:Generator_ColumnPropNameInTable="clcategoria2Column" msprop:Generator_UserColumnName="clcategoria2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_sett_att1" msprop:Generator_ColumnVarNameInTable="columncl_sett_att1" msprop:Generator_ColumnPropNameInRow="cl_sett_att1" msprop:Generator_ColumnPropNameInTable="cl_sett_att1Column" msprop:Generator_UserColumnName="cl_sett_att1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_sett_att2" msprop:Generator_ColumnVarNameInTable="columncl_sett_att2" msprop:Generator_ColumnPropNameInRow="cl_sett_att2" msprop:Generator_ColumnPropNameInTable="cl_sett_att2Column" msprop:Generator_UserColumnName="cl_sett_att2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnote" msprop:Generator_ColumnVarNameInTable="columnclnote" msprop:Generator_ColumnPropNameInRow="clnote" msprop:Generator_ColumnPropNameInTable="clnoteColumn" msprop:Generator_UserColumnName="clnote" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="536870910" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_categco" msprop:Generator_ColumnVarNameInTable="columncl_categco" msprop:Generator_ColumnPropNameInRow="cl_categco" msprop:Generator_ColumnPropNameInTable="cl_categcoColumn" msprop:Generator_UserColumnName="cl_categco" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_ling" msprop:Generator_ColumnVarNameInTable="columncl_ling" msprop:Generator_ColumnPropNameInRow="cl_ling" msprop:Generator_ColumnPropNameInTable="cl_lingColumn" msprop:Generator_UserColumnName="cl_ling" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_filiale" msprop:Generator_ColumnVarNameInTable="columncl_filiale" msprop:Generator_ColumnPropNameInRow="cl_filiale" msprop:Generator_ColumnPropNameInTable="cl_filialeColumn" msprop:Generator_UserColumnName="cl_filiale" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_cod_old" msprop:Generator_ColumnVarNameInTable="columncl_cod_old" msprop:Generator_ColumnPropNameInRow="cl_cod_old" msprop:Generator_ColumnPropNameInTable="cl_cod_oldColumn" msprop:Generator_UserColumnName="cl_cod_old" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_cod_gruppo" msprop:Generator_ColumnVarNameInTable="columncl_cod_gruppo" msprop:Generator_ColumnPropNameInRow="cl_cod_gruppo" msprop:Generator_ColumnPropNameInTable="cl_cod_gruppoColumn" msprop:Generator_UserColumnName="cl_cod_gruppo" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_vt1" msprop:Generator_ColumnVarNameInTable="columncl_vt1" msprop:Generator_ColumnPropNameInRow="cl_vt1" msprop:Generator_ColumnPropNameInTable="cl_vt1Column" msprop:Generator_UserColumnName="cl_vt1" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_vt2" msprop:Generator_ColumnVarNameInTable="columncl_vt2" msprop:Generator_ColumnPropNameInRow="cl_vt2" msprop:Generator_ColumnPropNameInTable="cl_vt2Column" msprop:Generator_UserColumnName="cl_vt2" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_vt3" msprop:Generator_ColumnVarNameInTable="columncl_vt3" msprop:Generator_ColumnPropNameInRow="cl_vt3" msprop:Generator_ColumnPropNameInTable="cl_vt3Column" msprop:Generator_UserColumnName="cl_vt3" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_vt4" msprop:Generator_ColumnVarNameInTable="columncl_vt4" msprop:Generator_ColumnPropNameInRow="cl_vt4" msprop:Generator_ColumnPropNameInTable="cl_vt4Column" msprop:Generator_UserColumnName="cl_vt4" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="abc_pa_sol_csolv_ID" msprop:Generator_ColumnVarNameInTable="columnabc_pa_sol_csolv_ID" msprop:Generator_ColumnPropNameInRow="abc_pa_sol_csolv_ID" msprop:Generator_ColumnPropNameInTable="abc_pa_sol_csolv_IDColumn" msprop:Generator_UserColumnName="abc_pa_sol_csolv_ID" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_solv_dtupd" msprop:Generator_ColumnVarNameInTable="columncl_solv_dtupd" msprop:Generator_ColumnPropNameInRow="cl_solv_dtupd" msprop:Generator_ColumnPropNameInTable="cl_solv_dtupdColumn" msprop:Generator_UserColumnName="cl_solv_dtupd" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="cldtfineutil" msprop:Generator_ColumnVarNameInTable="columncldtfineutil" msprop:Generator_ColumnPropNameInRow="cldtfineutil" msprop:Generator_ColumnPropNameInTable="cldtfineutilColumn" msprop:Generator_UserColumnName="cldtfineutil" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="cl_fl_decod_anag" msprop:Generator_ColumnVarNameInTable="columncl_fl_decod_anag" msprop:Generator_ColumnPropNameInRow="cl_fl_decod_anag" msprop:Generator_ColumnPropNameInTable="cl_fl_decod_anagColumn" msprop:Generator_UserColumnName="cl_fl_decod_anag" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="1" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindirec" msprop:Generator_ColumnVarNameInTable="columnclindirec" msprop:Generator_ColumnPropNameInRow="clindirec" msprop:Generator_ColumnPropNameInTable="clindirecColumn" msprop:Generator_UserColumnName="clindirec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cllocarec" msprop:Generator_ColumnVarNameInTable="columncllocarec" msprop:Generator_ColumnPropNameInRow="cllocarec" msprop:Generator_ColumnPropNameInTable="cllocarecColumn" msprop:Generator_UserColumnName="cllocarec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcaporec" msprop:Generator_ColumnVarNameInTable="columnclcaporec" msprop:Generator_ColumnPropNameInRow="clcaporec" msprop:Generator_ColumnPropNameInTable="clcaporecColumn" msprop:Generator_UserColumnName="clcaporec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clprovrec" msprop:Generator_ColumnVarNameInTable="columnclprovrec" msprop:Generator_ColumnPropNameInRow="clprovrec" msprop:Generator_ColumnPropNameInTable="clprovrecColumn" msprop:Generator_UserColumnName="clprovrec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnfaxrec" msprop:Generator_ColumnVarNameInTable="columnclnfaxrec" msprop:Generator_ColumnPropNameInRow="clnfaxrec" msprop:Generator_ColumnPropNameInTable="clnfaxrecColumn" msprop:Generator_UserColumnName="clnfaxrec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cltelerec" msprop:Generator_ColumnVarNameInTable="columncltelerec" msprop:Generator_ColumnPropNameInRow="cltelerec" msprop:Generator_ColumnPropNameInTable="cltelerecColumn" msprop:Generator_UserColumnName="cltelerec" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clprcinps" msprop:Generator_ColumnVarNameInTable="columnclprcinps" msprop:Generator_ColumnPropNameInRow="clprcinps" msprop:Generator_ColumnPropNameInTable="clprcinpsColumn" msprop:Generator_UserColumnName="clprcinps" type="xs:float" minOccurs="0" />
|
|
<xs:element name="clsuffreplica" msprop:Generator_ColumnVarNameInTable="columnclsuffreplica" msprop:Generator_ColumnPropNameInRow="clsuffreplica" msprop:Generator_ColumnPropNameInTable="clsuffreplicaColumn" msprop:Generator_UserColumnName="clsuffreplica" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cldtins" msprop:Generator_ColumnVarNameInTable="columncldtins" msprop:Generator_ColumnPropNameInRow="cldtins" msprop:Generator_ColumnPropNameInTable="cldtinsColumn" msprop:Generator_UserColumnName="cldtins" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="cldtvalidini" msprop:Generator_ColumnVarNameInTable="columncldtvalidini" msprop:Generator_ColumnPropNameInRow="cldtvalidini" msprop:Generator_ColumnPropNameInTable="cldtvalidiniColumn" msprop:Generator_UserColumnName="cldtvalidini" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="clcdaccisa" msprop:Generator_ColumnVarNameInTable="columnclcdaccisa" msprop:Generator_ColumnPropNameInRow="clcdaccisa" msprop:Generator_ColumnPropNameInTable="clcdaccisaColumn" msprop:Generator_UserColumnName="clcdaccisa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnicciaa" msprop:Generator_ColumnVarNameInTable="columnclnicciaa" msprop:Generator_ColumnPropNameInRow="clnicciaa" msprop:Generator_ColumnPropNameInTable="clnicciaaColumn" msprop:Generator_UserColumnName="clnicciaa" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clnregimp" msprop:Generator_ColumnVarNameInTable="columnclnregimp" msprop:Generator_ColumnPropNameInRow="clnregimp" msprop:Generator_ColumnPropNameInTable="clnregimpColumn" msprop:Generator_UserColumnName="clnregimp" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clcod_estero" msprop:Generator_ColumnVarNameInTable="columnclcod_estero" msprop:Generator_ColumnPropNameInRow="clcod_estero" msprop:Generator_ColumnPropNameInTable="clcod_esteroColumn" msprop:Generator_UserColumnName="clcod_estero" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="25" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clemail" msprop:Generator_ColumnVarNameInTable="columnclemail" msprop:Generator_ColumnPropNameInRow="clemail" msprop:Generator_ColumnPropNameInTable="clemailColumn" msprop:Generator_UserColumnName="clemail" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clwww" msprop:Generator_ColumnVarNameInTable="columnclwww" msprop:Generator_ColumnPropNameInRow="clwww" msprop:Generator_ColumnPropNameInTable="clwwwColumn" msprop:Generator_UserColumnName="clwww" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clctrib" msprop:Generator_ColumnVarNameInTable="columnclctrib" msprop:Generator_ColumnPropNameInRow="clctrib" msprop:Generator_ColumnPropNameInTable="clctribColumn" msprop:Generator_UserColumnName="clctrib" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clCodCausRit" msprop:Generator_ColumnVarNameInTable="columnclCodCausRit" msprop:Generator_ColumnPropNameInRow="clCodCausRit" msprop:Generator_ColumnPropNameInTable="clCodCausRitColumn" msprop:Generator_UserColumnName="clCodCausRit" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="10" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clQuadro" msprop:Generator_ColumnVarNameInTable="columnclQuadro" msprop:Generator_ColumnPropNameInRow="clQuadro" msprop:Generator_ColumnPropNameInTable="clQuadroColumn" msprop:Generator_UserColumnName="clQuadro" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="3" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cl_destStampe" msprop:Generator_ColumnVarNameInTable="columncl_destStampe" msprop:Generator_ColumnPropNameInRow="cl_destStampe" msprop:Generator_ColumnPropNameInTable="cl_destStampeColumn" msprop:Generator_UserColumnName="cl_destStampe" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clragd_n" msprop:Generator_ColumnVarNameInTable="columnclragd_n" msprop:Generator_ColumnPropNameInRow="clragd_n" msprop:Generator_ColumnPropNameInTable="clragd_nColumn" msprop:Generator_UserColumnName="clragd_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindi_n" msprop:Generator_ColumnVarNameInTable="columnclindi_n" msprop:Generator_ColumnPropNameInRow="clindi_n" msprop:Generator_ColumnPropNameInTable="clindi_nColumn" msprop:Generator_UserColumnName="clindi_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clloca_n" msprop:Generator_ColumnVarNameInTable="columnclloca_n" msprop:Generator_ColumnPropNameInRow="clloca_n" msprop:Generator_ColumnPropNameInTable="clloca_nColumn" msprop:Generator_UserColumnName="clloca_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindidomfisc_n" msprop:Generator_ColumnVarNameInTable="columnclindidomfisc_n" msprop:Generator_ColumnPropNameInRow="clindidomfisc_n" msprop:Generator_ColumnPropNameInTable="clindidomfisc_nColumn" msprop:Generator_UserColumnName="clindidomfisc_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cllocadomfisc_n" msprop:Generator_ColumnVarNameInTable="columncllocadomfisc_n" msprop:Generator_ColumnPropNameInRow="cllocadomfisc_n" msprop:Generator_ColumnPropNameInTable="cllocadomfisc_nColumn" msprop:Generator_UserColumnName="cllocadomfisc_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="clindirec_n" msprop:Generator_ColumnVarNameInTable="columnclindirec_n" msprop:Generator_ColumnPropNameInRow="clindirec_n" msprop:Generator_ColumnPropNameInTable="clindirec_nColumn" msprop:Generator_UserColumnName="clindirec_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="cllocarec_n" msprop:Generator_ColumnVarNameInTable="columncllocarec_n" msprop:Generator_ColumnPropNameInRow="cllocarec_n" msprop:Generator_ColumnPropNameInTable="cllocarec_nColumn" msprop:Generator_UserColumnName="cllocarec_n" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//mstns:acl" />
|
|
<xs:field xpath="mstns:clcodcn" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
</xs:schema> |