Inversiones/InversionesDataSet1.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="InversionesDataSet1" targetNamespace="http://tempuri.org/InversionesDataSet1.xsd" xmlns:mstns="http://tempuri.org/InversionesDataSet1.xsd" xmlns="http://tempuri.org/InversionesDataSet1.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="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="InversionesConnectionString5" IsAppSettingsProperty="true" Modifier="Assembly" Name="InversionesConnectionString5 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Inversiones.My.MySettings.GlobalReference.Default.InversionesConnectionString5" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="cnInversiones" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="cnInversiones (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Inversiones.My.MySettings.GlobalReference.Default.cnInversiones" 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="cnInversiones (MySettings)" 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="cnInversiones (MySettings)" 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.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="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.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 [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="true">
                    <CommandText>INSERT INTO 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="CodEmpr" ColumnName="CodEmpr" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Descrip" ColumnName="Descrip" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SAP_BD" ColumnName="SAP_BD" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        CodEmpr, Descrip, SAP_BD
FROM            EMPR</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       EMPR
SET                Descrip = @Descrip, SAP_BD = @SAP_BD
WHERE        (CodEmpr = @Original_CodEmpr);     
SELECT CodEmpr, Descrip, SAP_BD FROM EMPR WHERE (CodEmpr = @CodEmpr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Descrip" ColumnName="Descrip" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Descrip" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Descrip" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SAP_BD" ColumnName="SAP_BD" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@SAP_BD" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="SAP_BD" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CodEmpr" ColumnName="CodEmpr" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodEmpr" ColumnName="CodEmpr" DataSourceName="Inversiones_20190711.dbo.EMPR" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodEmpr" 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="cnInversiones (MySettings)" 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="cnInversiones (MySettings)" 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="cnInversiones (MySettings)" 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>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BAN0TableAdapter" GeneratorDataComponentClassName="BAN0TableAdapter" Name="BAN0" UserDataComponentName="BAN0TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190620.dbo.BAN0" 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="true">
                    <CommandText>DELETE FROM BAN0
WHERE        (CodBanco = @Original_CodBanco)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO BAN0
                         (CodBanco, CodPais, NombreBanco)
VALUES        (@CodBanco,@CodPais,@NombreBanco); 
SELECT CodBanco, CodPais, NombreBanco FROM BAN0 WHERE (CodBanco = @CodBanco)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CodPais" ColumnName="CodPais" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NombreBanco" ColumnName="NombreBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NombreBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NombreBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        CodBanco, CodPais, NombreBanco
FROM            BAN0</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       BAN0
SET                CodBanco = @CodBanco, CodPais = @CodPais, NombreBanco = @NombreBanco
WHERE        (CodBanco = @Original_CodBanco); 
SELECT CodBanco, CodPais, NombreBanco FROM BAN0 WHERE (CodBanco = @CodBanco)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CodPais" ColumnName="CodPais" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(3)" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="3" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NombreBanco" ColumnName="NombreBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NombreBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NombreBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190620.dbo.BAN0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodBanco" DataSetColumn="CodBanco" />
              <Mapping SourceColumn="CodPais" DataSetColumn="CodPais" />
              <Mapping SourceColumn="NombreBanco" DataSetColumn="NombreBanco" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BAN1TableAdapter" GeneratorDataComponentClassName="BAN1TableAdapter" Name="BAN1" UserDataComponentName="BAN1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.BAN1" 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 [BAN1] WHERE (([Id] = @Original_Id) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_Activo = 1 AND [Activo] IS NULL) OR ([Activo] = @Original_Activo)) AND ((@IsNull_NombreCuenta = 1 AND [NombreCuenta] IS NULL) OR ([NombreCuenta] = @Original_NombreCuenta)) AND ((@IsNull_TipoCuenta = 1 AND [TipoCuenta] IS NULL) OR ([TipoCuenta] = @Original_TipoCuenta)) AND ((@IsNull_CuentaContable = 1 AND [CuentaContable] IS NULL) OR ([CuentaContable] = @Original_CuentaContable)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodBanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEmpr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_NumCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NombreCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NombreCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NombreCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NombreCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CuentaContable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CuentaContable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CuentaContable" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CuentaContable" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [BAN1] ([CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta], [TipoCuenta], [CuentaContable]) VALUES (@CodBanco, @CodEmpr, @NumCuenta, @Activo, @NombreCuenta, @TipoCuenta, @CuentaContable);
SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable FROM BAN1 WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="@NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NombreCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NombreCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CuentaContable" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CuentaContable" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable
FROM            BAN1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       BAN1
SET                CodBanco = @CodBanco, CodEmpr = @CodEmpr, NumCuenta = @NumCuenta, Activo = @Activo, NombreCuenta = @NombreCuenta, TipoCuenta = @TipoCuenta, CuentaContable = @CuentaContable
WHERE        (Id = @Original_Id) AND (@IsNull_CodBanco = 1 AND CodBanco IS NULL OR
                         CodBanco = @Original_CodBanco) AND (@IsNull_CodEmpr = 1 AND CodEmpr IS NULL OR
                         CodEmpr = @Original_CodEmpr) AND (@IsNull_NumCuenta = 1 AND NumCuenta IS NULL OR
                         NumCuenta = @Original_NumCuenta) AND (@IsNull_Activo = 1 AND Activo IS NULL OR
                         Activo = @Original_Activo) AND (@IsNull_NombreCuenta = 1 AND NombreCuenta IS NULL OR
                         NombreCuenta = @Original_NombreCuenta) AND (@IsNull_TipoCuenta = 1 AND TipoCuenta IS NULL OR
                         TipoCuenta = @Original_TipoCuenta) AND (@IsNull_CuentaContable = 1 AND CuentaContable IS NULL OR
                         CuentaContable = @Original_CuentaContable); 
SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta, CuentaContable FROM BAN1 WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CodEmpr" ColumnName="CodEmpr" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NumCuenta" ColumnName="NumCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Activo" ColumnName="Activo" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Activo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Activo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NombreCuenta" ColumnName="NombreCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@NombreCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NombreCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TipoCuenta" ColumnName="TipoCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@TipoCuenta" Precision="0" Scale="0" Size="10" SourceColumn="TipoCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CuentaContable" ColumnName="CuentaContable" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@CuentaContable" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CuentaContable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_Id" ColumnName="Id" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_CodBanco" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodBanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_CodEmpr" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEmpr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_CodEmpr" ColumnName="CodEmpr" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_NumCuenta" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_NumCuenta" ColumnName="NumCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_Activo" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_Activo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Activo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_Activo" ColumnName="Activo" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@Original_Activo" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="Activo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_NombreCuenta" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_NombreCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NombreCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_NombreCuenta" ColumnName="NombreCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Original_NombreCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="NombreCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_TipoCuenta" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_TipoCuenta" ColumnName="TipoCuenta" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoCuenta" Precision="0" Scale="0" Size="10" SourceColumn="TipoCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IsNull_CuentaContable" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IsNull_CuentaContable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CuentaContable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_CuentaContable" ColumnName="CuentaContable" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_CuentaContable" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CuentaContable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="Inversiones_20190711.dbo.BAN1" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodBanco" DataSetColumn="CodBanco" />
              <Mapping SourceColumn="CodEmpr" DataSetColumn="CodEmpr" />
              <Mapping SourceColumn="NumCuenta" DataSetColumn="NumCuenta" />
              <Mapping SourceColumn="Activo" DataSetColumn="Activo" />
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="NombreCuenta" DataSetColumn="NombreCuenta" />
              <Mapping SourceColumn="TipoCuenta" DataSetColumn="TipoCuenta" />
              <Mapping SourceColumn="CuentaContable" DataSetColumn="CuentaContable" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190620.dbo.BAN1" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta FROM BAN1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FPAGTableAdapter" GeneratorDataComponentClassName="FPAGTableAdapter" Name="FPAG" UserDataComponentName="FPAGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190620.dbo.FPAG" 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].[FPAG] WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FPAG] ([Codigo], [Nombre]) VALUES (@Codigo, @Nombre);
SELECT Codigo, Nombre FROM FPAG WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre FROM dbo.FPAG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FPAG] SET [Codigo] = @Codigo, [Nombre] = @Nombre WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)));
SELECT Codigo, Nombre FROM FPAG WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PIN0TableAdapter" GeneratorDataComponentClassName="PIN0TableAdapter" Name="PIN0" UserDataComponentName="PIN0TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.PIN0" 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].[PIN0] WHERE (([DocId] = @Original_DocId) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_DocEst = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_DocEst)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Original_CodIF)) AND ((@IsNull_CodEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Original_CodEmis)) AND ((@IsNull_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi] = @Original_CodCalRi)) AND ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR ([CodECalRi] = @Original_CodECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) OR ([OFon] = @Original_OFon)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR ([Coment] = @Original_Coment)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([Just] = @Original_Just)) AND ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR ([TipoOper] = @Original_TipoOper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL) OR ([DocBase] = @Original_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] IS NULL) OR ([MontoInv] = @Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AND [Rendimiento] IS NULL) OR ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNull_Plazo = 1 AND [Plazo] IS NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_PlazoFact = 1 AND [PlazoFact] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) AND ((@IsNull_Ingresos = 1 AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ingresos)) AND ((@IsNull_FechaDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Original_FechaDoc)) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DocEst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DocEst" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Asunto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEmpr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodIF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodCalRi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodECalRi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_OFon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OFon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Coment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Coment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Just" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Just" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoOper" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoOper" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MontoInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MontoInv" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Precio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Precio" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rendimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rendimiento" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlazoFact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PlazoFact" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ingresos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Ingresos" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FechaDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AutEstado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AutEstado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoMerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoMerc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PIN0] ([CodInv], [DocEst], [Asunto], [CodEmpr], [CodIF], [CodEmis], [CodCalRi], [CodECalRi], [OFon], [Coment], [Just], [TipoOper], [DocBase], [MontoInv], [Precio], [Rendimiento], [Plazo], [PlazoFact], [Ingresos], [FechaDoc], [AutEstado], [TipoMerc], [CodPais]) VALUES (@CodInv, @DocEst, @Asunto, @CodEmpr, @CodIF, @CodEmis, @CodCalRi, @CodECalRi, @OFon, @Coment, @Just, @TipoOper, @DocBase, @MontoInv, @Precio, @Rendimiento, @Plazo, @PlazoFact, @Ingresos, @FechaDoc, @AutEstado, @TipoMerc, @CodPais);
SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM PIN0 WHERE (DocId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocEst" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="@CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="@OFon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Coment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Just" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoOper" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MontoInv" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Precio" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rendimiento" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PlazoFact" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Ingresos" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AutEstado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoMerc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM dbo.PIN0</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PIN0] SET [CodInv] = @CodInv, [DocEst] = @DocEst, [Asunto] = @Asunto, [CodEmpr] = @CodEmpr, [CodIF] = @CodIF, [CodEmis] = @CodEmis, [CodCalRi] = @CodCalRi, [CodECalRi] = @CodECalRi, [OFon] = @OFon, [Coment] = @Coment, [Just] = @Just, [TipoOper] = @TipoOper, [DocBase] = @DocBase, [MontoInv] = @MontoInv, [Precio] = @Precio, [Rendimiento] = @Rendimiento, [Plazo] = @Plazo, [PlazoFact] = @PlazoFact, [Ingresos] = @Ingresos, [FechaDoc] = @FechaDoc, [AutEstado] = @AutEstado, [TipoMerc] = @TipoMerc, [CodPais] = @CodPais WHERE (([DocId] = @Original_DocId) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_DocEst = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_DocEst)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Original_CodIF)) AND ((@IsNull_CodEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Original_CodEmis)) AND ((@IsNull_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi] = @Original_CodCalRi)) AND ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR ([CodECalRi] = @Original_CodECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) OR ([OFon] = @Original_OFon)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR ([Coment] = @Original_Coment)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([Just] = @Original_Just)) AND ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR ([TipoOper] = @Original_TipoOper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL) OR ([DocBase] = @Original_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] IS NULL) OR ([MontoInv] = @Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AND [Rendimiento] IS NULL) OR ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNull_Plazo = 1 AND [Plazo] IS NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_PlazoFact = 1 AND [PlazoFact] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) AND ((@IsNull_Ingresos = 1 AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ingresos)) AND ((@IsNull_FechaDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Original_FechaDoc)) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstado)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @Original_CodPais)));
SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM PIN0 WHERE (DocId = @DocId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DocEst" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="@CodIF" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="@OFon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Coment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Just" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoOper" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MontoInv" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Precio" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Rendimiento" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PlazoFact" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Ingresos" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AutEstado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoMerc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPais" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DocEst" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DocEst" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DocEst" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Asunto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodEmpr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodIF" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodIF" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodEmis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodEmis" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_CodCalRi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodECalRi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodECalRi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_OFon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OFon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OFon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Coment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Coment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Coment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Just" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Just" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Just" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoOper" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoOper" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoOper" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DocBase" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DocBase" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MontoInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MontoInv" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="MontoInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Precio" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Precio" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Precio" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Precio" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rendimiento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Rendimiento" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Rendimiento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Plazo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Plazo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlazoFact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PlazoFact" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PlazoFact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ingresos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Ingresos" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="Ingresos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaDoc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FechaDoc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaDoc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AutEstado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AutEstado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AutEstado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipoMerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipoMerc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoMerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPais" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPais" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="false" AutogeneratedName="DocId" ColumnName="DocId" DataSourceName="Inversiones_20190711.dbo.PIN0" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DocId" DataSetColumn="DocId" />
              <Mapping SourceColumn="CodInv" DataSetColumn="CodInv" />
              <Mapping SourceColumn="DocEst" DataSetColumn="DocEst" />
              <Mapping SourceColumn="Asunto" DataSetColumn="Asunto" />
              <Mapping SourceColumn="CodEmpr" DataSetColumn="CodEmpr" />
              <Mapping SourceColumn="CodIF" DataSetColumn="CodIF" />
              <Mapping SourceColumn="CodEmis" DataSetColumn="CodEmis" />
              <Mapping SourceColumn="CodCalRi" DataSetColumn="CodCalRi" />
              <Mapping SourceColumn="CodECalRi" DataSetColumn="CodECalRi" />
              <Mapping SourceColumn="OFon" DataSetColumn="OFon" />
              <Mapping SourceColumn="Coment" DataSetColumn="Coment" />
              <Mapping SourceColumn="Just" DataSetColumn="Just" />
              <Mapping SourceColumn="TipoOper" DataSetColumn="TipoOper" />
              <Mapping SourceColumn="DocBase" DataSetColumn="DocBase" />
              <Mapping SourceColumn="MontoInv" DataSetColumn="MontoInv" />
              <Mapping SourceColumn="Precio" DataSetColumn="Precio" />
              <Mapping SourceColumn="Rendimiento" DataSetColumn="Rendimiento" />
              <Mapping SourceColumn="Plazo" DataSetColumn="Plazo" />
              <Mapping SourceColumn="PlazoFact" DataSetColumn="PlazoFact" />
              <Mapping SourceColumn="Ingresos" DataSetColumn="Ingresos" />
              <Mapping SourceColumn="FechaDoc" DataSetColumn="FechaDoc" />
              <Mapping SourceColumn="AutEstado" DataSetColumn="AutEstado" />
              <Mapping SourceColumn="TipoMerc" DataSetColumn="TipoMerc" />
              <Mapping SourceColumn="CodPais" DataSetColumn="CodPais" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CALRITableAdapter" GeneratorDataComponentClassName="CALRITableAdapter" Name="CALRI" UserDataComponentName="CALRITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.CALRI" 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].[CALRI] WHERE (([CodCalRi] = @Original_CodCalRi) 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_CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" 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].[CALRI] ([CodCalRi], [Descrip]) VALUES (@CodCalRi, @Descrip);
SELECT CodCalRi, Descrip FROM CALRI WHERE (CodCalRi = @CodCalRi)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" 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 CodCalRi, Descrip FROM dbo.CALRI</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[CALRI] SET [CodCalRi] = @CodCalRi, [Descrip] = @Descrip WHERE (([CodCalRi] = @Original_CodCalRi) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)));
SELECT CodCalRi, Descrip FROM CALRI WHERE (CodCalRi = @CodCalRi)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" 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_CodCalRi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodCalRi" 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="CodCalRi" DataSetColumn="CodCalRi" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RPAGTableAdapter" GeneratorDataComponentClassName="RPAGTableAdapter" Name="RPAG" UserDataComponentName="RPAGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.RPAG" 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 [RPAG] WHERE (([RPID] = @Original_RPID) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_AFavorDe = 1 AND [AFavorDe] IS NULL) OR ([AFavorDe] = @Original_AFavorDe)) AND ((@IsNull_FormaPagID = 1 AND [FormaPagID] IS NULL) OR ([FormaPagID] = @Original_FormaPagID)) AND ((@IsNull_MontoPago = 1 AND [MontoPago] IS NULL) OR ([MontoPago] = @Original_MontoPago)) AND ((@IsNull_FechaPago = 1 AND [FechaPago] IS NULL) OR ([FechaPago] = @Original_FechaPago)) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_SaldoContable = 1 AND [SaldoContable] IS NULL) OR ([SaldoContable] = @Original_SaldoContable)) AND ((@IsNull_Concepto = 1 AND [Concepto] IS NULL) OR ([Concepto] = @Original_Concepto)) AND ((@IsNull_UCodigo = 1 AND [UCodigo] IS NULL) OR ([UCodigo] = @Original_UCodigo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RPID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AFavorDe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AFavorDe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AFavorDe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AFavorDe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FormaPagID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FormaPagID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FormaPagID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FormaPagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MontoPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MontoPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MontoPago" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MontoPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FechaPago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodBanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaldoContable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaldoContable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SaldoContable" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="SaldoContable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Concepto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Concepto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Concepto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Concepto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UCodigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO RPAG
                         (CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo)
VALUES        (@CodInv,@AFavorDe,@FormaPagID,@MontoPago,@FechaPago,@CodBanco,@NumCuenta,@SaldoContable,@Concepto,@UCodigo); 
SELECT RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo FROM RPAG WHERE (RPID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CodInv" ColumnName="CodInv" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(20)" DbType="AnsiString" Direction="Input" ParameterName="@CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="AFavorDe" ColumnName="AFavorDe" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@AFavorDe" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="AFavorDe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FormaPagID" ColumnName="FormaPagID" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@FormaPagID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="FormaPagID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MontoPago" ColumnName="MontoPago" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="numeric(18, 2)" DbType="Decimal" Direction="Input" ParameterName="@MontoPago" Precision="18" ProviderType="Decimal" Scale="2" Size="9" SourceColumn="MontoPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="FechaPago" ColumnName="FechaPago" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@FechaPago" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="FechaPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="CodBanco" ColumnName="CodBanco" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="NumCuenta" ColumnName="NumCuenta" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SaldoContable" ColumnName="SaldoContable" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="numeric(18, 6)" DbType="Decimal" Direction="Input" ParameterName="@SaldoContable" Precision="18" ProviderType="Decimal" Scale="6" Size="9" SourceColumn="SaldoContable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Concepto" ColumnName="Concepto" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(254)" DbType="AnsiString" Direction="Input" ParameterName="@Concepto" Precision="0" ProviderType="VarChar" Scale="0" Size="254" SourceColumn="Concepto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UCodigo" ColumnName="UCodigo" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo
FROM            RPAG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [RPAG] SET [CodInv] = @CodInv, [AFavorDe] = @AFavorDe, [FormaPagID] = @FormaPagID, [MontoPago] = @MontoPago, [FechaPago] = @FechaPago, [CodBanco] = @CodBanco, [NumCuenta] = @NumCuenta, [SaldoContable] = @SaldoContable, [Concepto] = @Concepto, [UCodigo] = @UCodigo WHERE (([RPID] = @Original_RPID) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_AFavorDe = 1 AND [AFavorDe] IS NULL) OR ([AFavorDe] = @Original_AFavorDe)) AND ((@IsNull_FormaPagID = 1 AND [FormaPagID] IS NULL) OR ([FormaPagID] = @Original_FormaPagID)) AND ((@IsNull_MontoPago = 1 AND [MontoPago] IS NULL) OR ([MontoPago] = @Original_MontoPago)) AND ((@IsNull_FechaPago = 1 AND [FechaPago] IS NULL) OR ([FechaPago] = @Original_FechaPago)) AND ((@IsNull_CodBanco = 1 AND [CodBanco] IS NULL) OR ([CodBanco] = @Original_CodBanco)) AND ((@IsNull_NumCuenta = 1 AND [NumCuenta] IS NULL) OR ([NumCuenta] = @Original_NumCuenta)) AND ((@IsNull_SaldoContable = 1 AND [SaldoContable] IS NULL) OR ([SaldoContable] = @Original_SaldoContable)) AND ((@IsNull_Concepto = 1 AND [Concepto] IS NULL) OR ([Concepto] = @Original_Concepto)) AND ((@IsNull_UCodigo = 1 AND [UCodigo] IS NULL) OR ([UCodigo] = @Original_UCodigo)));
SELECT RPID, CodInv, AFavorDe, FormaPagID, MontoPago, FechaPago, CodBanco, NumCuenta, SaldoContable, Concepto, UCodigo FROM RPAG WHERE (RPID = @RPID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AFavorDe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AFavorDe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FormaPagID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FormaPagID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MontoPago" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MontoPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaPago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaPago" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@SaldoContable" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="SaldoContable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Concepto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Concepto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RPID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodInv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodInv" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodInv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AFavorDe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AFavorDe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AFavorDe" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AFavorDe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FormaPagID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FormaPagID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FormaPagID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FormaPagID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MontoPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MontoPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_MontoPago" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="MontoPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FechaPago" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FechaPago" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_FechaPago" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaPago" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodBanco" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumCuenta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaldoContable" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaldoContable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_SaldoContable" Precision="18" ProviderType="Decimal" Scale="6" Size="0" SourceColumn="SaldoContable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Concepto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Concepto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Concepto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Concepto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UCodigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RPID" ColumnName="RPID" DataSourceName="Inversiones_20190711.dbo.RPAG" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RPID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RPID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RPID" DataSetColumn="RPID" />
              <Mapping SourceColumn="CodInv" DataSetColumn="CodInv" />
              <Mapping SourceColumn="AFavorDe" DataSetColumn="AFavorDe" />
              <Mapping SourceColumn="FormaPagID" DataSetColumn="FormaPagID" />
              <Mapping SourceColumn="MontoPago" DataSetColumn="MontoPago" />
              <Mapping SourceColumn="FechaPago" DataSetColumn="FechaPago" />
              <Mapping SourceColumn="CodBanco" DataSetColumn="CodBanco" />
              <Mapping SourceColumn="NumCuenta" DataSetColumn="NumCuenta" />
              <Mapping SourceColumn="SaldoContable" DataSetColumn="SaldoContable" />
              <Mapping SourceColumn="Concepto" DataSetColumn="Concepto" />
              <Mapping SourceColumn="UCodigo" DataSetColumn="UCodigo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BAN2TableAdapter" GeneratorDataComponentClassName="BAN2TableAdapter" Name="BAN2" UserDataComponentName="BAN2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.BAN2" 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].[BAN2] WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BAN2] ([Codigo], [Nombre]) VALUES (@Codigo, @Nombre);
SELECT Codigo, Nombre FROM BAN2 WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nombre FROM dbo.BAN2</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BAN2] SET [Codigo] = @Codigo, [Nombre] = @Nombre WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Nombre = 1 AND [Nombre] IS NULL) OR ([Nombre] = @Original_Nombre)));
SELECT Codigo, Nombre FROM BAN2 WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OFONTableAdapter" GeneratorDataComponentClassName="OFONTableAdapter" Name="OFON" UserDataComponentName="OFONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.OFON" 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].[OFON] WHERE (([Codigo] = @Original_Codigo) 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_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" 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].[OFON] ([Codigo], [Descrip]) VALUES (@Codigo, @Descrip);
SELECT Codigo, Descrip FROM OFON WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" 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 Codigo, Descrip FROM dbo.OFON</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[OFON] SET [Codigo] = @Codigo, [Descrip] = @Descrip WHERE (([Codigo] = @Original_Codigo) AND ((@IsNull_Descrip = 1 AND [Descrip] IS NULL) OR ([Descrip] = @Original_Descrip)));
SELECT Codigo, Descrip FROM OFON WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" 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_Codigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Codigo" 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="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Descrip" DataSetColumn="Descrip" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DEP0TableAdapter" GeneratorDataComponentClassName="DEP0TableAdapter" Name="DEP0" UserDataComponentName="DEP0TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.DEP0" 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="true">
                    <CommandText>DELETE FROM DEP0
WHERE        (DEPID = @Original_DEPID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO DEP0
                         (DEPID, DEPNombre)
VALUES        (@DEPID,@DEPNombre); 
SELECT DEPID, DEPNombre FROM DEP0 WHERE (DEPID = @DEPID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="DEPNombre" ColumnName="DEPNombre" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@DEPNombre" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="DEPNombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        DEPID, DEPNombre
FROM            DEP0</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       DEP0
SET                DEPNombre = @DEPNombre
WHERE        (DEPID = @Original_DEPID); 
SELECT DEPID, DEPNombre FROM DEP0 WHERE (DEPID = @DEPID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="DEPNombre" ColumnName="DEPNombre" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@DEPNombre" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="DEPNombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Original_DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.DEP0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DEPID" DataSetColumn="DEPID" />
              <Mapping SourceColumn="DEPNombre" DataSetColumn="DEPNombre" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="USR0TableAdapter" GeneratorDataComponentClassName="USR0TableAdapter" Name="USR0" UserDataComponentName="USR0TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cnInversiones (MySettings)" DbObjectName="Inversiones_20190711.dbo.USR0" 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 [USR0] WHERE (([UCodigo] = @Original_UCodigo) AND ((@IsNull_UNombre = 1 AND [UNombre] IS NULL) OR ([UNombre] = @Original_UNombre)) AND ((@IsNull_DEPID = 1 AND [DEPID] IS NULL) OR ([DEPID] = @Original_DEPID)) AND ((@IsNull_SUser = 1 AND [SUser] IS NULL) OR ([SUser] = @Original_SUser)) AND ((@IsNull_Bloqueado = 1 AND [Bloqueado] IS NULL) OR ([Bloqueado] = @Original_Bloqueado)) AND ((@IsNull_Clave1 = 1 AND [Clave1] IS NULL) OR ([Clave1] = @Original_Clave1)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UNombre" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UNombre" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UNombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UNombre" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DEPID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DEPID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_SUser" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="SUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bloqueado" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bloqueado" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_Bloqueado" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Bloqueado" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Clave1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Clave1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Clave1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Clave1" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO USR0
                         (UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1)
VALUES        (@UCodigo,@UNombre,@DEPID,@SUser,@Bloqueado,@Clave1); 
SELECT UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1 FROM USR0 WHERE (UCodigo = @UCodigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UCodigo" ColumnName="UCodigo" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="UNombre" ColumnName="UNombre" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@UNombre" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="UNombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SUser" ColumnName="SUser" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@SUser" Precision="0" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="SUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Bloqueado" ColumnName="Bloqueado" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@Bloqueado" Precision="0" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="Bloqueado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Clave1" ColumnName="Clave1" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Clave1" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="Clave1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1
FROM            USR0</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       USR0
SET                UNombre = @UNombre, DEPID = @DEPID, SUser = @SUser, Bloqueado = @Bloqueado, Clave1 = @Clave1
WHERE        (UCodigo = @Original_UCodigo); 
SELECT UCodigo, UNombre, DEPID, SUser, Bloqueado, Clave1 FROM USR0 WHERE (UCodigo = @UCodigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="UNombre" ColumnName="UNombre" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@UNombre" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="UNombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DEPID" ColumnName="DEPID" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@DEPID" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="DEPID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="SUser" ColumnName="SUser" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@SUser" Precision="0" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="SUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Bloqueado" ColumnName="Bloqueado" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@Bloqueado" Precision="0" ProviderType="TinyInt" Scale="0" Size="1" SourceColumn="Bloqueado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Clave1" ColumnName="Clave1" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Clave1" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="Clave1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_UCodigo" ColumnName="UCodigo" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@Original_UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UCodigo" ColumnName="UCodigo" DataSourceName="Inversiones_20190711.dbo.USR0" DataTypeServer="varchar(10)" DbType="AnsiString" Direction="Input" ParameterName="@UCodigo" Precision="0" ProviderType="VarChar" Scale="0" Size="10" SourceColumn="UCodigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UCodigo" DataSetColumn="UCodigo" />
              <Mapping SourceColumn="UNombre" DataSetColumn="UNombre" />
              <Mapping SourceColumn="DEPID" DataSetColumn="DEPID" />
              <Mapping SourceColumn="SUser" DataSetColumn="SUser" />
              <Mapping SourceColumn="Bloqueado" DataSetColumn="Bloqueado" />
              <Mapping SourceColumn="Clave1" DataSetColumn="Clave1" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="InversionesDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="InversionesDataSet1" msprop:Generator_UserDSName="InversionesDataSet1">
    <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:element name="BAN0" msprop:Generator_TableClassName="BAN0DataTable" msprop:Generator_TableVarName="tableBAN0" msprop:Generator_RowChangedName="BAN0RowChanged" msprop:Generator_TablePropName="BAN0" msprop:Generator_RowDeletingName="BAN0RowDeleting" msprop:Generator_RowChangingName="BAN0RowChanging" msprop:Generator_RowEvHandlerName="BAN0RowChangeEventHandler" msprop:Generator_RowDeletedName="BAN0RowDeleted" msprop:Generator_RowClassName="BAN0Row" msprop:Generator_UserTableName="BAN0" msprop:Generator_RowEvArgName="BAN0RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodBanco" msprop:Generator_ColumnVarNameInTable="columnCodBanco" msprop:Generator_ColumnPropNameInRow="CodBanco" msprop:Generator_ColumnPropNameInTable="CodBancoColumn" msprop:Generator_UserColumnName="CodBanco">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPais" msprop:Generator_ColumnVarNameInTable="columnCodPais" msprop:Generator_ColumnPropNameInRow="CodPais" msprop:Generator_ColumnPropNameInTable="CodPaisColumn" msprop:Generator_UserColumnName="CodPais" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NombreBanco" msprop:Generator_ColumnVarNameInTable="columnNombreBanco" msprop:Generator_ColumnPropNameInRow="NombreBanco" msprop:Generator_ColumnPropNameInTable="NombreBancoColumn" msprop:Generator_UserColumnName="NombreBanco" 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="BAN1" msprop:Generator_TableClassName="BAN1DataTable" msprop:Generator_TableVarName="tableBAN1" msprop:Generator_TablePropName="BAN1" msprop:Generator_RowDeletingName="BAN1RowDeleting" msprop:Generator_RowChangingName="BAN1RowChanging" msprop:Generator_RowEvHandlerName="BAN1RowChangeEventHandler" msprop:Generator_RowDeletedName="BAN1RowDeleted" msprop:Generator_UserTableName="BAN1" msprop:Generator_RowChangedName="BAN1RowChanged" msprop:Generator_RowEvArgName="BAN1RowChangeEvent" msprop:Generator_RowClassName="BAN1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodBanco" msprop:Generator_ColumnVarNameInTable="columnCodBanco" msprop:Generator_ColumnPropNameInRow="CodBanco" msprop:Generator_ColumnPropNameInTable="CodBancoColumn" msprop:Generator_UserColumnName="CodBanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </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="NumCuenta" msprop:Generator_ColumnVarNameInTable="columnNumCuenta" msprop:Generator_ColumnPropNameInRow="NumCuenta" msprop:Generator_ColumnPropNameInTable="NumCuentaColumn" msprop:Generator_UserColumnName="NumCuenta" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Activo" msprop:Generator_ColumnVarNameInTable="columnActivo" msprop:Generator_ColumnPropNameInRow="Activo" msprop:Generator_ColumnPropNameInTable="ActivoColumn" msprop:Generator_UserColumnName="Activo" type="xs:boolean" minOccurs="0" />
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
              <xs:element name="NombreCuenta" msprop:Generator_ColumnVarNameInTable="columnNombreCuenta" msprop:Generator_ColumnPropNameInRow="NombreCuenta" msprop:Generator_ColumnPropNameInTable="NombreCuentaColumn" msprop:Generator_UserColumnName="NombreCuenta" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoCuenta" msprop:Generator_ColumnVarNameInTable="columnTipoCuenta" msprop:Generator_ColumnPropNameInRow="TipoCuenta" msprop:Generator_ColumnPropNameInTable="TipoCuentaColumn" msprop:Generator_UserColumnName="TipoCuenta" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CuentaContable" msprop:Generator_ColumnVarNameInTable="columnCuentaContable" msprop:Generator_ColumnPropNameInRow="CuentaContable" msprop:Generator_ColumnPropNameInTable="CuentaContableColumn" msprop:Generator_UserColumnName="CuentaContable" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FPAG" msprop:Generator_TableClassName="FPAGDataTable" msprop:Generator_TableVarName="tableFPAG" msprop:Generator_RowChangedName="FPAGRowChanged" msprop:Generator_TablePropName="FPAG" msprop:Generator_RowDeletingName="FPAGRowDeleting" msprop:Generator_RowChangingName="FPAGRowChanging" msprop:Generator_RowEvHandlerName="FPAGRowChangeEventHandler" msprop:Generator_RowDeletedName="FPAGRowDeleted" msprop:Generator_RowClassName="FPAGRow" msprop:Generator_UserTableName="FPAG" msprop:Generator_RowEvArgName="FPAGRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre" 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="PIN0" msprop:Generator_TableClassName="PIN0DataTable" msprop:Generator_TableVarName="tablePIN0" msprop:Generator_TablePropName="PIN0" msprop:Generator_RowDeletingName="PIN0RowDeleting" msprop:Generator_RowChangingName="PIN0RowChanging" msprop:Generator_RowEvHandlerName="PIN0RowChangeEventHandler" msprop:Generator_RowDeletedName="PIN0RowDeleted" msprop:Generator_UserTableName="PIN0" msprop:Generator_RowChangedName="PIN0RowChanged" msprop:Generator_RowEvArgName="PIN0RowChangeEvent" msprop:Generator_RowClassName="PIN0Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DocId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnDocId" msprop:Generator_ColumnPropNameInRow="DocId" msprop:Generator_ColumnPropNameInTable="DocIdColumn" msprop:Generator_UserColumnName="DocId" type="xs:int" />
              <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="DocEst" msprop:Generator_ColumnVarNameInTable="columnDocEst" msprop:Generator_ColumnPropNameInRow="DocEst" msprop:Generator_ColumnPropNameInTable="DocEstColumn" msprop:Generator_UserColumnName="DocEst" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Asunto" msprop:Generator_ColumnVarNameInTable="columnAsunto" msprop:Generator_ColumnPropNameInRow="Asunto" msprop:Generator_ColumnPropNameInTable="AsuntoColumn" msprop:Generator_UserColumnName="Asunto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </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="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="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="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="OFon" msprop:Generator_ColumnVarNameInTable="columnOFon" msprop:Generator_ColumnPropNameInRow="OFon" msprop:Generator_ColumnPropNameInTable="OFonColumn" msprop:Generator_UserColumnName="OFon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Coment" msprop:Generator_ColumnVarNameInTable="columnComent" msprop:Generator_ColumnPropNameInRow="Coment" msprop:Generator_ColumnPropNameInTable="ComentColumn" msprop:Generator_UserColumnName="Coment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Just" msprop:Generator_ColumnVarNameInTable="columnJust" msprop:Generator_ColumnPropNameInRow="Just" msprop:Generator_ColumnPropNameInTable="JustColumn" msprop:Generator_UserColumnName="Just" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipoOper" msprop:Generator_ColumnVarNameInTable="columnTipoOper" msprop:Generator_ColumnPropNameInRow="TipoOper" msprop:Generator_ColumnPropNameInTable="TipoOperColumn" msprop:Generator_UserColumnName="TipoOper" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DocBase" msprop:Generator_ColumnVarNameInTable="columnDocBase" msprop:Generator_ColumnPropNameInRow="DocBase" msprop:Generator_ColumnPropNameInTable="DocBaseColumn" msprop:Generator_UserColumnName="DocBase" type="xs:int" minOccurs="0" />
              <xs:element name="MontoInv" msprop:Generator_ColumnVarNameInTable="columnMontoInv" msprop:Generator_ColumnPropNameInRow="MontoInv" msprop:Generator_ColumnPropNameInTable="MontoInvColumn" msprop:Generator_UserColumnName="MontoInv" type="xs:decimal" minOccurs="0" />
              <xs:element name="Precio" msprop:Generator_ColumnVarNameInTable="columnPrecio" msprop:Generator_ColumnPropNameInRow="Precio" msprop:Generator_ColumnPropNameInTable="PrecioColumn" msprop:Generator_UserColumnName="Precio" type="xs:decimal" minOccurs="0" />
              <xs:element name="Rendimiento" msprop:Generator_ColumnVarNameInTable="columnRendimiento" msprop:Generator_ColumnPropNameInRow="Rendimiento" msprop:Generator_ColumnPropNameInTable="RendimientoColumn" msprop:Generator_UserColumnName="Rendimiento" type="xs:decimal" minOccurs="0" />
              <xs:element name="Plazo" msprop:Generator_ColumnVarNameInTable="columnPlazo" msprop:Generator_ColumnPropNameInRow="Plazo" msprop:Generator_ColumnPropNameInTable="PlazoColumn" msprop:Generator_UserColumnName="Plazo" type="xs:int" minOccurs="0" />
              <xs:element name="PlazoFact" msprop:Generator_ColumnVarNameInTable="columnPlazoFact" msprop:Generator_ColumnPropNameInRow="PlazoFact" msprop:Generator_ColumnPropNameInTable="PlazoFactColumn" msprop:Generator_UserColumnName="PlazoFact" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ingresos" msprop:Generator_ColumnVarNameInTable="columnIngresos" msprop:Generator_ColumnPropNameInRow="Ingresos" msprop:Generator_ColumnPropNameInTable="IngresosColumn" msprop:Generator_UserColumnName="Ingresos" type="xs:decimal" minOccurs="0" />
              <xs:element name="FechaDoc" msprop:Generator_ColumnVarNameInTable="columnFechaDoc" msprop:Generator_ColumnPropNameInRow="FechaDoc" msprop:Generator_ColumnPropNameInTable="FechaDocColumn" msprop:Generator_UserColumnName="FechaDoc" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AutEstado" msprop:Generator_ColumnVarNameInTable="columnAutEstado" msprop:Generator_ColumnPropNameInRow="AutEstado" msprop:Generator_ColumnPropNameInTable="AutEstadoColumn" msprop:Generator_UserColumnName="AutEstado" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </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="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPais" msprop:Generator_ColumnVarNameInTable="columnCodPais" msprop:Generator_ColumnPropNameInRow="CodPais" msprop:Generator_ColumnPropNameInTable="CodPaisColumn" msprop:Generator_UserColumnName="CodPais" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CALRI" msprop:Generator_TableClassName="CALRIDataTable" msprop:Generator_TableVarName="tableCALRI" msprop:Generator_RowChangedName="CALRIRowChanged" msprop:Generator_TablePropName="CALRI" msprop:Generator_RowDeletingName="CALRIRowDeleting" msprop:Generator_RowChangingName="CALRIRowChanging" msprop:Generator_RowEvHandlerName="CALRIRowChangeEventHandler" msprop:Generator_RowDeletedName="CALRIRowDeleted" msprop:Generator_RowClassName="CALRIRow" msprop:Generator_UserTableName="CALRI" msprop:Generator_RowEvArgName="CALRIRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodCalRi" msprop:Generator_ColumnVarNameInTable="columnCodCalRi" msprop:Generator_ColumnPropNameInRow="CodCalRi" msprop:Generator_ColumnPropNameInTable="CodCalRiColumn" msprop:Generator_UserColumnName="CodCalRi">
                <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="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RPAG" msprop:Generator_TableClassName="RPAGDataTable" msprop:Generator_TableVarName="tableRPAG" msprop:Generator_RowChangedName="RPAGRowChanged" msprop:Generator_TablePropName="RPAG" msprop:Generator_RowDeletingName="RPAGRowDeleting" msprop:Generator_RowChangingName="RPAGRowChanging" msprop:Generator_RowEvHandlerName="RPAGRowChangeEventHandler" msprop:Generator_RowDeletedName="RPAGRowDeleted" msprop:Generator_RowClassName="RPAGRow" msprop:Generator_UserTableName="RPAG" msprop:Generator_RowEvArgName="RPAGRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RPID" msprop:Generator_ColumnVarNameInTable="columnRPID" msprop:Generator_ColumnPropNameInRow="RPID" msprop:Generator_ColumnPropNameInTable="RPIDColumn" msprop:Generator_UserColumnName="RPID" type="xs:int" />
              <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="AFavorDe" msprop:Generator_ColumnVarNameInTable="columnAFavorDe" msprop:Generator_ColumnPropNameInRow="AFavorDe" msprop:Generator_ColumnPropNameInTable="AFavorDeColumn" msprop:Generator_UserColumnName="AFavorDe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FormaPagID" msprop:Generator_ColumnVarNameInTable="columnFormaPagID" msprop:Generator_ColumnPropNameInRow="FormaPagID" msprop:Generator_ColumnPropNameInTable="FormaPagIDColumn" msprop:Generator_UserColumnName="FormaPagID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MontoPago" msprop:Generator_ColumnVarNameInTable="columnMontoPago" msprop:Generator_ColumnPropNameInRow="MontoPago" msprop:Generator_ColumnPropNameInTable="MontoPagoColumn" msprop:Generator_UserColumnName="MontoPago" type="xs:decimal" minOccurs="0" />
              <xs:element name="FechaPago" msprop:Generator_ColumnVarNameInTable="columnFechaPago" msprop:Generator_ColumnPropNameInRow="FechaPago" msprop:Generator_ColumnPropNameInTable="FechaPagoColumn" msprop:Generator_UserColumnName="FechaPago" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CodBanco" msprop:Generator_ColumnVarNameInTable="columnCodBanco" msprop:Generator_ColumnPropNameInRow="CodBanco" msprop:Generator_ColumnPropNameInTable="CodBancoColumn" msprop:Generator_UserColumnName="CodBanco" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumCuenta" msprop:Generator_ColumnVarNameInTable="columnNumCuenta" msprop:Generator_ColumnPropNameInRow="NumCuenta" msprop:Generator_ColumnPropNameInTable="NumCuentaColumn" msprop:Generator_UserColumnName="NumCuenta" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SaldoContable" msprop:Generator_ColumnVarNameInTable="columnSaldoContable" msprop:Generator_ColumnPropNameInRow="SaldoContable" msprop:Generator_ColumnPropNameInTable="SaldoContableColumn" msprop:Generator_UserColumnName="SaldoContable" type="xs:decimal" minOccurs="0" />
              <xs:element name="Concepto" msprop:Generator_ColumnVarNameInTable="columnConcepto" msprop:Generator_ColumnPropNameInRow="Concepto" msprop:Generator_ColumnPropNameInTable="ConceptoColumn" msprop:Generator_UserColumnName="Concepto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="254" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UCodigo" msprop:Generator_ColumnVarNameInTable="columnUCodigo" msprop:Generator_ColumnPropNameInRow="UCodigo" msprop:Generator_ColumnPropNameInTable="UCodigoColumn" msprop:Generator_UserColumnName="UCodigo" 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="BAN2" msprop:Generator_TableClassName="BAN2DataTable" msprop:Generator_TableVarName="tableBAN2" msprop:Generator_TablePropName="BAN2" msprop:Generator_RowDeletingName="BAN2RowDeleting" msprop:Generator_RowChangingName="BAN2RowChanging" msprop:Generator_RowEvHandlerName="BAN2RowChangeEventHandler" msprop:Generator_RowDeletedName="BAN2RowDeleted" msprop:Generator_UserTableName="BAN2" msprop:Generator_RowChangedName="BAN2RowChanged" msprop:Generator_RowEvArgName="BAN2RowChangeEvent" msprop:Generator_RowClassName="BAN2Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre" 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="OFON" msprop:Generator_TableClassName="OFONDataTable" msprop:Generator_TableVarName="tableOFON" msprop:Generator_RowChangedName="OFONRowChanged" msprop:Generator_TablePropName="OFON" msprop:Generator_RowDeletingName="OFONRowDeleting" msprop:Generator_RowChangingName="OFONRowChanging" msprop:Generator_RowEvHandlerName="OFONRowChangeEventHandler" msprop:Generator_RowDeletedName="OFONRowDeleted" msprop:Generator_RowClassName="OFONRow" msprop:Generator_UserTableName="OFON" msprop:Generator_RowEvArgName="OFONRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DEP0" msprop:Generator_TableClassName="DEP0DataTable" msprop:Generator_TableVarName="tableDEP0" msprop:Generator_RowChangedName="DEP0RowChanged" msprop:Generator_TablePropName="DEP0" msprop:Generator_RowDeletingName="DEP0RowDeleting" msprop:Generator_RowChangingName="DEP0RowChanging" msprop:Generator_RowEvHandlerName="DEP0RowChangeEventHandler" msprop:Generator_RowDeletedName="DEP0RowDeleted" msprop:Generator_RowClassName="DEP0Row" msprop:Generator_UserTableName="DEP0" msprop:Generator_RowEvArgName="DEP0RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DEPID" msprop:Generator_ColumnVarNameInTable="columnDEPID" msprop:Generator_ColumnPropNameInRow="DEPID" msprop:Generator_ColumnPropNameInTable="DEPIDColumn" msprop:Generator_UserColumnName="DEPID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DEPNombre" msprop:Generator_ColumnVarNameInTable="columnDEPNombre" msprop:Generator_ColumnPropNameInRow="DEPNombre" msprop:Generator_ColumnPropNameInTable="DEPNombreColumn" msprop:Generator_UserColumnName="DEPNombre">
                <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="USR0" msprop:Generator_TableClassName="USR0DataTable" msprop:Generator_TableVarName="tableUSR0" msprop:Generator_RowChangedName="USR0RowChanged" msprop:Generator_TablePropName="USR0" msprop:Generator_RowDeletingName="USR0RowDeleting" msprop:Generator_RowChangingName="USR0RowChanging" msprop:Generator_RowEvHandlerName="USR0RowChangeEventHandler" msprop:Generator_RowDeletedName="USR0RowDeleted" msprop:Generator_RowClassName="USR0Row" msprop:Generator_UserTableName="USR0" msprop:Generator_RowEvArgName="USR0RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UCodigo" msprop:Generator_ColumnVarNameInTable="columnUCodigo" msprop:Generator_ColumnPropNameInRow="UCodigo" msprop:Generator_ColumnPropNameInTable="UCodigoColumn" msprop:Generator_UserColumnName="UCodigo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UNombre" msprop:Generator_ColumnVarNameInTable="columnUNombre" msprop:Generator_ColumnPropNameInRow="UNombre" msprop:Generator_ColumnPropNameInTable="UNombreColumn" msprop:Generator_UserColumnName="UNombre" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DEPID" msprop:Generator_ColumnVarNameInTable="columnDEPID" msprop:Generator_ColumnPropNameInRow="DEPID" msprop:Generator_ColumnPropNameInTable="DEPIDColumn" msprop:Generator_UserColumnName="DEPID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUser" msprop:Generator_ColumnVarNameInTable="columnSUser" msprop:Generator_ColumnPropNameInRow="SUser" msprop:Generator_ColumnPropNameInTable="SUserColumn" msprop:Generator_UserColumnName="SUser" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Bloqueado" msprop:Generator_ColumnVarNameInTable="columnBloqueado" msprop:Generator_ColumnPropNameInRow="Bloqueado" msprop:Generator_ColumnPropNameInTable="BloqueadoColumn" msprop:Generator_UserColumnName="Bloqueado" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Clave1" msprop:Generator_ColumnVarNameInTable="columnClave1" msprop:Generator_ColumnPropNameInRow="Clave1" msprop:Generator_ColumnPropNameInTable="Clave1Column" msprop:Generator_UserColumnName="Clave1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </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: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:unique name="BAN0_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BAN0" />
      <xs:field xpath="mstns:CodBanco" />
    </xs:unique>
    <xs:unique name="BAN1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BAN1" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="FPAG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FPAG" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="PIN0_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PIN0" />
      <xs:field xpath="mstns:DocId" />
    </xs:unique>
    <xs:unique name="CALRI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CALRI" />
      <xs:field xpath="mstns:CodCalRi" />
    </xs:unique>
    <xs:unique name="RPAG_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RPAG" />
      <xs:field xpath="mstns:RPID" />
    </xs:unique>
    <xs:unique name="BAN2_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BAN2" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="OFON_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OFON" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
    <xs:unique name="DEP0_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DEP0" />
      <xs:field xpath="mstns:DEPID" />
    </xs:unique>
    <xs:unique name="USR0_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:USR0" />
      <xs:field xpath="mstns:UCodigo" />
    </xs:unique>
  </xs:element>
</xs:schema>