﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="HistorialPagos" targetNamespace="http://tempuri.org/HistorialPagos.xsd" xmlns:mstns="http://tempuri.org/HistorialPagos.xsd" xmlns="http://tempuri.org/HistorialPagos.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=172.27.100.77;Initial Catalog=LIQUIDACION;Persist Security Info=True;User ID=liquidacion;Password=Liquidacion2012" IsAppSettingsProperty="false" Modifier="Assembly" Name="win-e9s1rnffod0.LIQUIDACION.dbo" ParameterPrefix="@" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VIEW_HISTORIAL_PAGOSTableAdapter" GeneratorDataComponentClassName="VIEW_HISTORIAL_PAGOSTableAdapter" Name="VIEW_HISTORIAL_PAGOS" UserDataComponentName="VIEW_HISTORIAL_PAGOSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="win-e9s1rnffod0.LIQUIDACION.dbo" DbObjectName="LIQUIDACION.dbo.VIEW_HISTORIAL_PAGOS" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM VIEW_HISTORIAL_PAGOS</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDRETROACTIVOHISTORICOPAGOS" DataSetColumn="IDRETROACTIVOHISTORICOPAGOS" />
              <Mapping SourceColumn="IDSOLICITUD" DataSetColumn="IDSOLICITUD" />
              <Mapping SourceColumn="RHP_IDPERIODONOMINA" DataSetColumn="RHP_IDPERIODONOMINA" />
              <Mapping SourceColumn="ANIO" DataSetColumn="ANIO" />
              <Mapping SourceColumn="MES" DataSetColumn="MES" />
              <Mapping SourceColumn="GRUPO_PAGO_NOMINA" DataSetColumn="GRUPO_PAGO_NOMINA" />
              <Mapping SourceColumn="RHP_IDCONCEPTO" DataSetColumn="RHP_IDCONCEPTO" />
              <Mapping SourceColumn="RHP_DESCRIPCIONCONCEPTO" DataSetColumn="RHP_DESCRIPCIONCONCEPTO" />
              <Mapping SourceColumn="FAC_NOMBRE" DataSetColumn="FAC_NOMBRE" />
              <Mapping SourceColumn="RHP_VALORDEVENGADO" DataSetColumn="RHP_VALORDEVENGADO" />
              <Mapping SourceColumn="RHP_VALORDEDUCIDO" DataSetColumn="RHP_VALORDEDUCIDO" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="HistorialPagos" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="HistorialPagos" msprop:Generator_UserDSName="HistorialPagos">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="VIEW_HISTORIAL_PAGOS" msprop:Generator_TableClassName="VIEW_HISTORIAL_PAGOSDataTable" msprop:Generator_TableVarName="tableVIEW_HISTORIAL_PAGOS" msprop:Generator_TablePropName="VIEW_HISTORIAL_PAGOS" msprop:Generator_RowDeletingName="VIEW_HISTORIAL_PAGOSRowDeleting" msprop:Generator_UserTableName="VIEW_HISTORIAL_PAGOS" msprop:Generator_RowChangingName="VIEW_HISTORIAL_PAGOSRowChanging" msprop:Generator_RowEvHandlerName="VIEW_HISTORIAL_PAGOSRowChangeEventHandler" msprop:Generator_RowDeletedName="VIEW_HISTORIAL_PAGOSRowDeleted" msprop:Generator_RowEvArgName="VIEW_HISTORIAL_PAGOSRowChangeEvent" msprop:Generator_RowChangedName="VIEW_HISTORIAL_PAGOSRowChanged" msprop:Generator_RowClassName="VIEW_HISTORIAL_PAGOSRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDRETROACTIVOHISTORICOPAGOS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDRETROACTIVOHISTORICOPAGOS" msprop:Generator_ColumnPropNameInRow="IDRETROACTIVOHISTORICOPAGOS" msprop:Generator_ColumnPropNameInTable="IDRETROACTIVOHISTORICOPAGOSColumn" msprop:Generator_UserColumnName="IDRETROACTIVOHISTORICOPAGOS" type="xs:decimal" />
              <xs:element name="IDSOLICITUD" msprop:Generator_ColumnVarNameInTable="columnIDSOLICITUD" msprop:Generator_ColumnPropNameInRow="IDSOLICITUD" msprop:Generator_ColumnPropNameInTable="IDSOLICITUDColumn" msprop:Generator_UserColumnName="IDSOLICITUD" type="xs:decimal" />
              <xs:element name="RHP_IDPERIODONOMINA" msprop:Generator_ColumnVarNameInTable="columnRHP_IDPERIODONOMINA" msprop:Generator_ColumnPropNameInRow="RHP_IDPERIODONOMINA" msprop:Generator_ColumnPropNameInTable="RHP_IDPERIODONOMINAColumn" msprop:Generator_UserColumnName="RHP_IDPERIODONOMINA">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ANIO" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnANIO" msprop:Generator_ColumnPropNameInRow="ANIO" msprop:Generator_ColumnPropNameInTable="ANIOColumn" msprop:Generator_UserColumnName="ANIO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MES" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnMES" msprop:Generator_ColumnPropNameInRow="MES" msprop:Generator_ColumnPropNameInTable="MESColumn" msprop:Generator_UserColumnName="MES" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GRUPO_PAGO_NOMINA" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnGRUPO_PAGO_NOMINA" msprop:Generator_ColumnPropNameInRow="GRUPO_PAGO_NOMINA" msprop:Generator_ColumnPropNameInTable="GRUPO_PAGO_NOMINAColumn" msprop:Generator_UserColumnName="GRUPO_PAGO_NOMINA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="24" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RHP_IDCONCEPTO" msprop:Generator_ColumnVarNameInTable="columnRHP_IDCONCEPTO" msprop:Generator_ColumnPropNameInRow="RHP_IDCONCEPTO" msprop:Generator_ColumnPropNameInTable="RHP_IDCONCEPTOColumn" msprop:Generator_UserColumnName="RHP_IDCONCEPTO">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RHP_DESCRIPCIONCONCEPTO" msprop:Generator_ColumnVarNameInTable="columnRHP_DESCRIPCIONCONCEPTO" msprop:Generator_ColumnPropNameInRow="RHP_DESCRIPCIONCONCEPTO" msprop:Generator_ColumnPropNameInTable="RHP_DESCRIPCIONCONCEPTOColumn" msprop:Generator_UserColumnName="RHP_DESCRIPCIONCONCEPTO">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FAC_NOMBRE" msprop:Generator_ColumnVarNameInTable="columnFAC_NOMBRE" msprop:Generator_ColumnPropNameInRow="FAC_NOMBRE" msprop:Generator_ColumnPropNameInTable="FAC_NOMBREColumn" msprop:Generator_UserColumnName="FAC_NOMBRE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RHP_VALORDEVENGADO" msprop:Generator_ColumnVarNameInTable="columnRHP_VALORDEVENGADO" msprop:Generator_ColumnPropNameInRow="RHP_VALORDEVENGADO" msprop:Generator_ColumnPropNameInTable="RHP_VALORDEVENGADOColumn" msprop:Generator_UserColumnName="RHP_VALORDEVENGADO" type="xs:decimal" />
              <xs:element name="RHP_VALORDEDUCIDO" msprop:Generator_ColumnVarNameInTable="columnRHP_VALORDEDUCIDO" msprop:Generator_ColumnPropNameInRow="RHP_VALORDEDUCIDO" msprop:Generator_ColumnPropNameInTable="RHP_VALORDEDUCIDOColumn" msprop:Generator_UserColumnName="RHP_VALORDEDUCIDO" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VIEW_HISTORIAL_PAGOS" />
      <xs:field xpath="mstns:IDRETROACTIVOHISTORICOPAGOS" />
    </xs:unique>
  </xs:element>
</xs:schema>