Inversiones/dsInversiones.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsInversiones" targetNamespace="http://tempuri.org/dsInversiones.xsd" xmlns:mstns="http://tempuri.org/dsInversiones.xsd" xmlns="http://tempuri.org/dsInversiones.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=XOMBRA\SQL2014;Initial Catalog=Inversiones_20190620;Integrated Security=True" IsAppSettingsProperty="false" Modifier="Assembly" Name="xombra\sql2014.Inversiones_20190620.dbo" ParameterPrefix="@" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ECALRITableAdapter" GeneratorDataComponentClassName="ECALRITableAdapter" Name="ECALRI" UserDataComponentName="ECALRITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.ECALRI" 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 [dbo].[ECALRI] WHERE (([CodECalRi] = @Original_CodECalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodECalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ECALRI] ([CodECalRi], [Descrip]) VALUES (@CodECalRi, @Descrip);
SELECT CodECalRi, Descrip FROM ECALRI WHERE (CodECalRi = @CodECalRi)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodECalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodECalRi, Descrip FROM dbo.ECALRI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ECALRI] SET [CodECalRi] = @CodECalRi, [Descrip] = @Descrip WHERE (([CodECalRi] = @Original_CodECalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)));
SELECT CodECalRi, Descrip FROM ECALRI WHERE (CodECalRi = @CodECalRi)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodECalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodECalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodECalRi" DataSetColumn="CodECalRi" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EMISTableAdapter" GeneratorDataComponentClassName="EMISTableAdapter" Name="EMIS" UserDataComponentName="EMISTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.EMIS" 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 [dbo].[EMIS] WHERE (([CodEmis] = @Original_CodEmis) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EMIS] ([Descrip], [Estado]) VALUES (@Descrip, @Estado);
SELECT CodEmis, Descrip, Estado FROM EMIS WHERE (CodEmis = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodEmis, Descrip, Estado FROM dbo.EMIS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EMIS] SET [Descrip] = @Descrip, [Estado] = @Estado WHERE (([CodEmis] = @Original_CodEmis) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Estado = 1 AND [Estado] IS NULL) OR ([Estado] = @Original_Estado)));
SELECT CodEmis, Descrip, Estado FROM EMIS WHERE (CodEmis = @CodEmis)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Estado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodEmis" ColumnName="CodEmis" DataSourceName="Inversiones_20190620.dbo.EMIS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CodEmis" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodEmis" DataSetColumn="CodEmis" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EMPRTableAdapter" GeneratorDataComponentClassName="EMPRTableAdapter" Name="EMPR" UserDataComponentName="EMPRTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.EMPR" 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 [dbo].[EMPR] WHERE (([CodEmpr] = @Original_CodEmpr) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_SAP_BD = 1 AND [SAP_BD] IS NULL) OR ([SAP_BD] = @Original_SAP_BD)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SAP_BD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[EMPR] ([CodEmpr], [Descrip], [SAP_BD]) VALUES (@CodEmpr, @Descrip, @SAP_BD);
SELECT CodEmpr, Descrip, SAP_BD FROM EMPR WHERE (CodEmpr = @CodEmpr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodEmpr, Descrip, SAP_BD FROM dbo.EMPR</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[EMPR] SET [CodEmpr] = @CodEmpr, [Descrip] = @Descrip, [SAP_BD] = @SAP_BD WHERE (([CodEmpr] = @Original_CodEmpr) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_SAP_BD = 1 AND [SAP_BD] IS NULL) OR ([SAP_BD] = @Original_SAP_BD)));
SELECT CodEmpr, Descrip, SAP_BD FROM EMPR WHERE (CodEmpr = @CodEmpr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SAP_BD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodEmpr" DataSetColumn="CodEmpr" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
              <Mapping SourceColumn="SAP_BD" DataSetColumn="SAP_BD" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="INFITableAdapter" GeneratorDataComponentClassName="INFITableAdapter" Name="INFI" UserDataComponentName="INFITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.INFI" 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 [dbo].[INFI] WHERE (([CodIF] = @Original_CodIF) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[INFI] ([CodIF], [Descrip], [Tipo]) VALUES (@CodIF, @Descrip, @Tipo);
SELECT CodIF, Descrip, Tipo FROM INFI WHERE (CodIF = @CodIF)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodIF, Descrip, Tipo FROM dbo.INFI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[INFI] SET [CodIF] = @CodIF, [Descrip] = @Descrip, [Tipo] = @Tipo WHERE (([CodIF] = @Original_CodIF) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_Tipo = 1 AND [Tipo] IS NULL) OR ([Tipo] = @Original_Tipo)));
SELECT CodIF, Descrip, Tipo FROM INFI WHERE (CodIF = @CodIF)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tipo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Tipo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tipo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodIF" DataSetColumn="CodIF" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PAISTableAdapter" GeneratorDataComponentClassName="PAISTableAdapter" Name="PAIS" UserDataComponentName="PAISTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.PAIS" 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 [dbo].[PAIS] WHERE (([CodPais] = @Original_CodPais) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_RelInv = 1 AND [RelInv] IS NULL) OR ([RelInv] = @Original_RelInv)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RelInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RelInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PAIS] ([CodPais], [Descrip], [RelInv]) VALUES (@CodPais, @Descrip, @RelInv);
SELECT CodPais, Descrip, RelInv FROM PAIS WHERE (CodPais = @CodPais)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RelInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodPais, Descrip, RelInv FROM dbo.PAIS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PAIS] SET [CodPais] = @CodPais, [Descrip] = @Descrip, [RelInv] = @RelInv WHERE (([CodPais] = @Original_CodPais) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)) AND ((@IsNull_RelInv = 1 AND [RelInv] IS NULL) OR ([RelInv] = @Original_RelInv)));
SELECT CodPais, Descrip, RelInv FROM PAIS WHERE (CodPais = @CodPais)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RelInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descrip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RelInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RelInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RelInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodPais" DataSetColumn="CodPais" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
              <Mapping SourceColumn="RelInv" DataSetColumn="RelInv" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SP_InventarioMasterTableAdapter" GeneratorDataComponentClassName="SP_InventarioMasterTableAdapter" Name="SP_InventarioMaster" UserDataComponentName="SP_InventarioMasterTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="xombra\sql2014.Inversiones_20190620.dbo" DbObjectName="Inversiones_20190620.dbo.SP_InventarioMaster" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SP_InventarioMaster</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodInv" DataSetColumn="CodInv" />
              <Mapping SourceColumn="CodIF" DataSetColumn="CodIF" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="CodEmpr" DataSetColumn="CodEmpr" />
              <Mapping SourceColumn="NombreManIF" DataSetColumn="NombreManIF" />
              <Mapping SourceColumn="CodManIF" DataSetColumn="CodManIF" />
              <Mapping SourceColumn="CodEmis" DataSetColumn="CodEmis" />
              <Mapping SourceColumn="iCasaBanco" DataSetColumn="iCasaBanco" />
              <Mapping SourceColumn="vCasaBanco" DataSetColumn="vCasaBanco" />
              <Mapping SourceColumn="TipoMerc" DataSetColumn="TipoMerc" />
              <Mapping SourceColumn="CodCalRi" DataSetColumn="CodCalRi" />
              <Mapping SourceColumn="CodECalRi" DataSetColumn="CodECalRi" />
              <Mapping SourceColumn="ValorNominal" DataSetColumn="ValorNominal" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsInversiones" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dsInversiones" msprop:Generator_UserDSName="dsInversiones">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ECALRI" msprop:Generator_TableClassName="ECALRIDataTable" msprop:Generator_TableVarName="tableECALRI" msprop:Generator_TablePropName="ECALRI" msprop:Generator_RowDeletingName="ECALRIRowDeleting" msprop:Generator_RowChangingName="ECALRIRowChanging" msprop:Generator_RowEvHandlerName="ECALRIRowChangeEventHandler" msprop:Generator_RowDeletedName="ECALRIRowDeleted" msprop:Generator_UserTableName="ECALRI" msprop:Generator_RowChangedName="ECALRIRowChanged" msprop:Generator_RowEvArgName="ECALRIRowChangeEvent" msprop:Generator_RowClassName="ECALRIRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodECalRi" msprop:Generator_ColumnVarNameInTable="columnCodECalRi" msprop:Generator_ColumnPropNameInRow="CodECalRi" msprop:Generator_ColumnPropNameInTable="CodECalRiColumn" msprop:Generator_UserColumnName="CodECalRi">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descrip" msprop:Generator_ColumnVarNameInTable="columnDescrip" msprop:Generator_ColumnPropNameInRow="Descrip" msprop:Generator_ColumnPropNameInTable="DescripColumn" msprop:Generator_UserColumnName="Descrip" 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:element name="EMIS" msprop:Generator_TableClassName="EMISDataTable" msprop:Generator_TableVarName="tableEMIS" msprop:Generator_TablePropName="EMIS" msprop:Generator_RowDeletingName="EMISRowDeleting" msprop:Generator_RowChangingName="EMISRowChanging" msprop:Generator_RowEvHandlerName="EMISRowChangeEventHandler" msprop:Generator_RowDeletedName="EMISRowDeleted" msprop:Generator_UserTableName="EMIS" msprop:Generator_RowChangedName="EMISRowChanged" msprop:Generator_RowEvArgName="EMISRowChangeEvent" msprop:Generator_RowClassName="EMISRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodEmis" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCodEmis" msprop:Generator_ColumnPropNameInRow="CodEmis" msprop:Generator_ColumnPropNameInTable="CodEmisColumn" msprop:Generator_UserColumnName="CodEmis" type="xs:int" />
              <xs:element name="Descrip" msprop:Generator_ColumnVarNameInTable="columnDescrip" msprop:Generator_ColumnPropNameInRow="Descrip" msprop:Generator_ColumnPropNameInTable="DescripColumn" msprop:Generator_UserColumnName="Descrip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EMPR" msprop:Generator_TableClassName="EMPRDataTable" msprop:Generator_TableVarName="tableEMPR" msprop:Generator_TablePropName="EMPR" msprop:Generator_RowDeletingName="EMPRRowDeleting" msprop:Generator_RowChangingName="EMPRRowChanging" msprop:Generator_RowEvHandlerName="EMPRRowChangeEventHandler" msprop:Generator_RowDeletedName="EMPRRowDeleted" msprop:Generator_UserTableName="EMPR" msprop:Generator_RowChangedName="EMPRRowChanged" msprop:Generator_RowEvArgName="EMPRRowChangeEvent" msprop:Generator_RowClassName="EMPRRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodEmpr" msprop:Generator_ColumnVarNameInTable="columnCodEmpr" msprop:Generator_ColumnPropNameInRow="CodEmpr" msprop:Generator_ColumnPropNameInTable="CodEmprColumn" msprop:Generator_UserColumnName="CodEmpr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descrip" msprop:Generator_ColumnVarNameInTable="columnDescrip" msprop:Generator_ColumnPropNameInRow="Descrip" msprop:Generator_ColumnPropNameInTable="DescripColumn" msprop:Generator_UserColumnName="Descrip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SAP_BD" msprop:Generator_ColumnVarNameInTable="columnSAP_BD" msprop:Generator_ColumnPropNameInRow="SAP_BD" msprop:Generator_ColumnPropNameInTable="SAP_BDColumn" msprop:Generator_UserColumnName="SAP_BD" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="INFI" msprop:Generator_TableClassName="INFIDataTable" msprop:Generator_TableVarName="tableINFI" msprop:Generator_TablePropName="INFI" msprop:Generator_RowDeletingName="INFIRowDeleting" msprop:Generator_RowChangingName="INFIRowChanging" msprop:Generator_RowEvHandlerName="INFIRowChangeEventHandler" msprop:Generator_RowDeletedName="INFIRowDeleted" msprop:Generator_UserTableName="INFI" msprop:Generator_RowChangedName="INFIRowChanged" msprop:Generator_RowEvArgName="INFIRowChangeEvent" msprop:Generator_RowClassName="INFIRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodIF" msprop:Generator_ColumnVarNameInTable="columnCodIF" msprop:Generator_ColumnPropNameInRow="CodIF" msprop:Generator_ColumnPropNameInTable="CodIFColumn" msprop:Generator_UserColumnName="CodIF">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descrip" msprop:Generator_ColumnVarNameInTable="columnDescrip" msprop:Generator_ColumnPropNameInRow="Descrip" msprop:Generator_ColumnPropNameInTable="DescripColumn" msprop:Generator_UserColumnName="Descrip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" msprop:Generator_UserColumnName="Tipo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PAIS" msprop:Generator_TableClassName="PAISDataTable" msprop:Generator_TableVarName="tablePAIS" msprop:Generator_TablePropName="PAIS" msprop:Generator_RowDeletingName="PAISRowDeleting" msprop:Generator_RowChangingName="PAISRowChanging" msprop:Generator_RowEvHandlerName="PAISRowChangeEventHandler" msprop:Generator_RowDeletedName="PAISRowDeleted" msprop:Generator_UserTableName="PAIS" msprop:Generator_RowChangedName="PAISRowChanged" msprop:Generator_RowEvArgName="PAISRowChangeEvent" msprop:Generator_RowClassName="PAISRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodPais" msprop:Generator_ColumnVarNameInTable="columnCodPais" msprop:Generator_ColumnPropNameInRow="CodPais" msprop:Generator_ColumnPropNameInTable="CodPaisColumn" msprop:Generator_UserColumnName="CodPais">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descrip" msprop:Generator_ColumnVarNameInTable="columnDescrip" msprop:Generator_ColumnPropNameInRow="Descrip" msprop:Generator_ColumnPropNameInTable="DescripColumn" msprop:Generator_UserColumnName="Descrip" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RelInv" msprop:Generator_ColumnVarNameInTable="columnRelInv" msprop:Generator_ColumnPropNameInRow="RelInv" msprop:Generator_ColumnPropNameInTable="RelInvColumn" msprop:Generator_UserColumnName="RelInv" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SP_InventarioMaster" msprop:Generator_TableClassName="SP_InventarioMasterDataTable" msprop:Generator_TableVarName="tableSP_InventarioMaster" msprop:Generator_TablePropName="SP_InventarioMaster" msprop:Generator_RowDeletingName="SP_InventarioMasterRowDeleting" msprop:Generator_RowChangingName="SP_InventarioMasterRowChanging" msprop:Generator_RowEvHandlerName="SP_InventarioMasterRowChangeEventHandler" msprop:Generator_RowDeletedName="SP_InventarioMasterRowDeleted" msprop:Generator_UserTableName="SP_InventarioMaster" msprop:Generator_RowChangedName="SP_InventarioMasterRowChanged" msprop:Generator_RowEvArgName="SP_InventarioMasterRowChangeEvent" msprop:Generator_RowClassName="SP_InventarioMasterRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodInv" msprop:Generator_ColumnVarNameInTable="columnCodInv" msprop:Generator_ColumnPropNameInRow="CodInv" msprop:Generator_ColumnPropNameInTable="CodInvColumn" msprop:Generator_UserColumnName="CodInv" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodIF" msprop:Generator_ColumnVarNameInTable="columnCodIF" msprop:Generator_ColumnPropNameInRow="CodIF" msprop:Generator_ColumnPropNameInTable="CodIFColumn" msprop:Generator_UserColumnName="CodIF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodEmpr" msprop:Generator_ColumnVarNameInTable="columnCodEmpr" msprop:Generator_ColumnPropNameInRow="CodEmpr" msprop:Generator_ColumnPropNameInTable="CodEmprColumn" msprop:Generator_UserColumnName="CodEmpr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NombreManIF" msprop:Generator_ColumnVarNameInTable="columnNombreManIF" msprop:Generator_ColumnPropNameInRow="NombreManIF" msprop:Generator_ColumnPropNameInTable="NombreManIFColumn" msprop:Generator_UserColumnName="NombreManIF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodManIF" msprop:Generator_ColumnVarNameInTable="columnCodManIF" msprop:Generator_ColumnPropNameInRow="CodManIF" msprop:Generator_ColumnPropNameInTable="CodManIFColumn" msprop:Generator_UserColumnName="CodManIF" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodEmis" msprop:Generator_ColumnVarNameInTable="columnCodEmis" msprop:Generator_ColumnPropNameInRow="CodEmis" msprop:Generator_ColumnPropNameInTable="CodEmisColumn" msprop:Generator_UserColumnName="CodEmis" type="xs:int" minOccurs="0" />
              <xs:element name="iCasaBanco" msprop:Generator_ColumnVarNameInTable="columniCasaBanco" msprop:Generator_ColumnPropNameInRow="iCasaBanco" msprop:Generator_ColumnPropNameInTable="iCasaBancoColumn" msprop:Generator_UserColumnName="iCasaBanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vCasaBanco" msprop:Generator_ColumnVarNameInTable="columnvCasaBanco" msprop:Generator_ColumnPropNameInRow="vCasaBanco" msprop:Generator_ColumnPropNameInTable="vCasaBancoColumn" msprop:Generator_UserColumnName="vCasaBanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoMerc" msprop:Generator_ColumnVarNameInTable="columnTipoMerc" msprop:Generator_ColumnPropNameInRow="TipoMerc" msprop:Generator_ColumnPropNameInTable="TipoMercColumn" msprop:Generator_UserColumnName="TipoMerc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodCalRi" msprop:Generator_ColumnVarNameInTable="columnCodCalRi" msprop:Generator_ColumnPropNameInRow="CodCalRi" msprop:Generator_ColumnPropNameInTable="CodCalRiColumn" msprop:Generator_UserColumnName="CodCalRi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodECalRi" msprop:Generator_ColumnVarNameInTable="columnCodECalRi" msprop:Generator_ColumnPropNameInRow="CodECalRi" msprop:Generator_ColumnPropNameInTable="CodECalRiColumn" msprop:Generator_UserColumnName="CodECalRi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValorNominal" msprop:Generator_ColumnVarNameInTable="columnValorNominal" msprop:Generator_ColumnPropNameInRow="ValorNominal" msprop:Generator_ColumnPropNameInTable="ValorNominalColumn" msprop:Generator_UserColumnName="ValorNominal" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ECALRI" />
      <xs:field xpath="mstns:CodECalRi" />
    </xs:unique>
    <xs:unique name="EMIS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EMIS" />
      <xs:field xpath="mstns:CodEmis" />
    </xs:unique>
    <xs:unique name="EMPR_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EMPR" />
      <xs:field xpath="mstns:CodEmpr" />
    </xs:unique>
    <xs:unique name="INFI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:INFI" />
      <xs:field xpath="mstns:CodIF" />
    </xs:unique>
    <xs:unique name="PAIS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PAIS" />
      <xs:field xpath="mstns:CodPais" />
    </xs:unique>
  </xs:element>
</xs:schema>