<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="EXPODataSet" targetNamespace="http://tempuri.org/EXPODataSet.xsd" xmlns:mstns="http://tempuri.org/EXPODataSet.xsd" xmlns="http://tempuri.org/EXPODataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="BAZA_REKLAMConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="BAZA_REKLAMConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ExportFaktur.Properties.Settings.GlobalReference.Default.BAZA_REKLAMConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAKTURYTableAdapter" GeneratorDataComponentClassName="FAKTURYTableAdapter" Name="FAKTURY" UserDataComponentName="FAKTURYTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.FAKTURY" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [FAKTURY] WHERE (([ID_FAKTURY] = @Original_ID_FAKTURY) AND ((@IsNull_NUMER = 1 AND [NUMER] IS NULL) OR ([NUMER] = @Original_NUMER)) AND ((@IsNull_NUMER_ROZ = 1 AND [NUMER_ROZ] IS NULL) OR ([NUMER_ROZ] = @Original_NUMER_ROZ)) AND ((@IsNull_NUMER_ROK = 1 AND [NUMER_ROK] IS NULL) OR ([NUMER_ROK] = @Original_NUMER_ROK)) AND ((@IsNull_DATA_WYSTAWIENIA = 1 AND [DATA_WYSTAWIENIA] IS NULL) OR ([DATA_WYSTAWIENIA] = @Original_DATA_WYSTAWIENIA)) AND ((@IsNull_MIEJSCOWOSC_WYSTAWIENIA = 1 AND [MIEJSCOWOSC_WYSTAWIENIA] IS NULL) OR ([MIEJSCOWOSC_WYSTAWIENIA] = @Original_MIEJSCOWOSC_WYSTAWIENIA)) AND ((@IsNull_ID_SPRZEDAWCY = 1 AND [ID_SPRZEDAWCY] IS NULL) OR ([ID_SPRZEDAWCY] = @Original_ID_SPRZEDAWCY)) AND ((@IsNull_ID_NABYWCY = 1 AND [ID_NABYWCY] IS NULL) OR ([ID_NABYWCY] = @Original_ID_NABYWCY)) AND ((@IsNull_DATA_SPRZEDAZY = 1 AND [DATA_SPRZEDAZY] IS NULL) OR ([DATA_SPRZEDAZY] = @Original_DATA_SPRZEDAZY)) AND ((@IsNull_PODPIS_WYSTAWIL = 1 AND [PODPIS_WYSTAWIL] IS NULL) OR ([PODPIS_WYSTAWIL] = @Original_PODPIS_WYSTAWIL)) AND ((@IsNull_PODPIS_ODEBRAL = 1 AND [PODPIS_ODEBRAL] IS NULL) OR ([PODPIS_ODEBRAL] = @Original_PODPIS_ODEBRAL)) AND ((@IsNull_SPOSOB_ZAPLATY = 1 AND [SPOSOB_ZAPLATY] IS NULL) OR ([SPOSOB_ZAPLATY] = @Original_SPOSOB_ZAPLATY)) AND ((@IsNull_TERMIN_ZAPLATY = 1 AND [TERMIN_ZAPLATY] IS NULL) OR ([TERMIN_ZAPLATY] = @Original_TERMIN_ZAPLATY)) AND ((@IsNull_ZAPLACONO = 1 AND [ZAPLACONO] IS NULL) OR ([ZAPLACONO] = @Original_ZAPLACONO)) AND ((@IsNull_BYL_WYDRUK = 1 AND [BYL_WYDRUK] IS NULL) OR ([BYL_WYDRUK] = @Original_BYL_WYDRUK)) AND ((@IsNull_SPRZEDAWCA_NIP = 1 AND [SPRZEDAWCA_NIP] IS NULL) OR ([SPRZEDAWCA_NIP] = @Original_SPRZEDAWCA_NIP)) AND ((@IsNull_NABYWCA_NIP = 1 AND [NABYWCA_NIP] IS NULL) OR ([NABYWCA_NIP] = @Original_NABYWCA_NIP)) AND ((@IsNull_FAKTURA_TYP = 1 AND [FAKTURA_TYP] IS NULL) OR ([FAKTURA_TYP] = @Original_FAKTURA_TYP)) AND ((@IsNull_FAKTURA_PODTYP = 1 AND [FAKTURA_PODTYP] IS NULL) OR ([FAKTURA_PODTYP] = @Original_FAKTURA_PODTYP)) AND ((@IsNull_ID_KONTA = 1 AND [ID_KONTA] IS NULL) OR ([ID_KONTA] = @Original_ID_KONTA)) AND ([EKSPORT] = @Original_EKSPORT) AND ([EXPORTED] = @Original_EXPORTED) AND ((@IsNull_ID_TYTUL = 1 AND [ID_TYTUL] IS NULL) OR ([ID_TYTUL] = @Original_ID_TYTUL)) AND ((@IsNull_EXPORTED_DATA = 1 AND [EXPORTED_DATA] IS NULL) OR ([EXPORTED_DATA] = @Original_EXPORTED_DATA)) AND ((@IsNull_suma_zaplat = 1 AND [suma_zaplat] IS NULL) OR ([suma_zaplat] = @Original_suma_zaplat)) AND ((@IsNull_ID_FK_KOR = 1 AND [ID_FK_KOR] IS NULL) OR ([ID_FK_KOR] = @Original_ID_FK_KOR)) AND ([KOREKTA] = @Original_KOREKTA) AND ((@IsNull_zaplata_data = 1 AND [zaplata_data] IS NULL) OR ([zaplata_data] = @Original_zaplata_data)) AND ((@IsNull_zaplata_opis = 1 AND [zaplata_opis] IS NULL) OR ([zaplata_opis] = @Original_zaplata_opis)) AND ((@IsNull_Zaliczka_Brutto = 1 AND [Zaliczka_Brutto] IS NULL) OR ([Zaliczka_Brutto] = @Original_Zaliczka_Brutto)) AND ((@IsNull_Zaliczka_Data = 1 AND [Zaliczka_Data] IS NULL) OR ([Zaliczka_Data] = @Original_Zaliczka_Data)) AND ((@IsNull_waluta_brutto = 1 AND [waluta_brutto] IS NULL) OR ([waluta_brutto] = @Original_waluta_brutto)) AND ((@IsNull_waluta_miano = 1 AND [waluta_miano] IS NULL) OR ([waluta_miano] = @Original_waluta_miano)) AND ((@IsNull_waluta_kurs = 1 AND [waluta_kurs] IS NULL) OR ([waluta_kurs] = @Original_waluta_kurs)) AND ((@IsNull_waluta_przelicznik = 1 AND [waluta_przelicznik] IS NULL) OR ([waluta_przelicznik] = @Original_waluta_przelicznik)) AND ((@IsNull_waluta_kurs_z_dnia = 1 AND [waluta_kurs_z_dnia] IS NULL) OR ([waluta_kurs_z_dnia] = @Original_waluta_kurs_z_dnia)) AND ((@IsNull_waluta_tabela_nr = 1 AND [waluta_tabela_nr] IS NULL) OR ([waluta_tabela_nr] = @Original_waluta_tabela_nr)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER_ROZ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NUMER_ROZ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_WYSTAWIENIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATA_WYSTAWIENIA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SPRZEDAZY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATA_SPRZEDAZY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODPIS_WYSTAWIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PODPIS_WYSTAWIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODPIS_ODEBRAL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PODPIS_ODEBRAL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPOSOB_ZAPLATY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SPOSOB_ZAPLATY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TERMIN_ZAPLATY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TERMIN_ZAPLATY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZAPLACONO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ZAPLACONO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BYL_WYDRUK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BYL_WYDRUK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPRZEDAWCA_NIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SPRZEDAWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NABYWCA_NIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NABYWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FAKTURA_TYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_FAKTURA_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FAKTURA_PODTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_FAKTURA_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_KONTA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ID_KONTA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EKSPORT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EKSPORT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EXPORTED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EXPORTED" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_TYTUL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ID_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EXPORTED_DATA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EXPORTED_DATA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_suma_zaplat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_suma_zaplat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_KOREKTA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="KOREKTA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaplata_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_zaplata_data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaplata_opis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_zaplata_opis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zaliczka_Brutto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Zaliczka_Brutto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zaliczka_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Zaliczka_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_brutto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_waluta_brutto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_miano" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_waluta_miano" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_kurs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_waluta_kurs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_kurs_z_dnia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_waluta_kurs_z_dnia" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_tabela_nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_waluta_tabela_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [FAKTURY] ([NUMER], [NUMER_ROZ], [NUMER_ROK], [DATA_WYSTAWIENIA], [MIEJSCOWOSC_WYSTAWIENIA], [ID_SPRZEDAWCY], [ID_NABYWCY], [DATA_SPRZEDAZY], [PODPIS_WYSTAWIL], [PODPIS_ODEBRAL], [opis], [SPOSOB_ZAPLATY], [TERMIN_ZAPLATY], [ZAPLACONO], [BYL_WYDRUK], [NABYWCA_ADRES], [SPRZEDAWCA_ADRES], [SPRZEDAWCA_NIP], [NABYWCA_NIP], [FAKTURA_TYP], [FAKTURA_PODTYP], [ID_KONTA], [EKSPORT], [EXPORTED], [ID_TYTUL], [EXPORTED_DATA], [suma_zaplat], [ID_FK_KOR], [KOREKTA], [zaplata_data], [zaplata_opis], [Zaliczka_Brutto], [Zaliczka_Data], [waluta_brutto], [waluta_miano], [waluta_kurs], [waluta_przelicznik], [waluta_kurs_z_dnia], [waluta_tabela_nr]) VALUES (@NUMER, @NUMER_ROZ, @NUMER_ROK, @DATA_WYSTAWIENIA, @MIEJSCOWOSC_WYSTAWIENIA, @ID_SPRZEDAWCY, @ID_NABYWCY, @DATA_SPRZEDAZY, @PODPIS_WYSTAWIL, @PODPIS_ODEBRAL, @opis, @SPOSOB_ZAPLATY, @TERMIN_ZAPLATY, @ZAPLACONO, @BYL_WYDRUK, @NABYWCA_ADRES, @SPRZEDAWCA_ADRES, @SPRZEDAWCA_NIP, @NABYWCA_NIP, @FAKTURA_TYP, @FAKTURA_PODTYP, @ID_KONTA, @EKSPORT, @EXPORTED, @ID_TYTUL, @EXPORTED_DATA, @suma_zaplat, @ID_FK_KOR, @KOREKTA, @zaplata_data, @zaplata_opis, @Zaliczka_Brutto, @Zaliczka_Data, @waluta_brutto, @waluta_miano, @waluta_kurs, @waluta_przelicznik, @waluta_kurs_z_dnia, @waluta_tabela_nr);
SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (ID_FAKTURY = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NUMER_ROZ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATA_WYSTAWIENIA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATA_SPRZEDAZY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PODPIS_WYSTAWIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PODPIS_ODEBRAL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@opis" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="opis" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPOSOB_ZAPLATY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TERMIN_ZAPLATY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ZAPLACONO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BYL_WYDRUK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NABYWCA_ADRES" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NABYWCA_ADRES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPRZEDAWCA_ADRES" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_ADRES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPRZEDAWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NABYWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@FAKTURA_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@FAKTURA_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ID_KONTA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EKSPORT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EKSPORT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EXPORTED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EXPORTED" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ID_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EXPORTED_DATA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@suma_zaplat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@KOREKTA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="KOREKTA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@zaplata_data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@zaplata_opis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Zaliczka_Brutto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Zaliczka_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@waluta_brutto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@waluta_miano" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@waluta_kurs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@waluta_kurs_z_dnia" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@waluta_tabela_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (SystemKsiegowyId = 2)</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [FAKTURY] SET [NUMER] = @NUMER, [NUMER_ROZ] = @NUMER_ROZ, [NUMER_ROK] = @NUMER_ROK, [DATA_WYSTAWIENIA] = @DATA_WYSTAWIENIA, [MIEJSCOWOSC_WYSTAWIENIA] = @MIEJSCOWOSC_WYSTAWIENIA, [ID_SPRZEDAWCY] = @ID_SPRZEDAWCY, [ID_NABYWCY] = @ID_NABYWCY, [DATA_SPRZEDAZY] = @DATA_SPRZEDAZY, [PODPIS_WYSTAWIL] = @PODPIS_WYSTAWIL, [PODPIS_ODEBRAL] = @PODPIS_ODEBRAL, [opis] = @opis, [SPOSOB_ZAPLATY] = @SPOSOB_ZAPLATY, [TERMIN_ZAPLATY] = @TERMIN_ZAPLATY, [ZAPLACONO] = @ZAPLACONO, [BYL_WYDRUK] = @BYL_WYDRUK, [NABYWCA_ADRES] = @NABYWCA_ADRES, [SPRZEDAWCA_ADRES] = @SPRZEDAWCA_ADRES, [SPRZEDAWCA_NIP] = @SPRZEDAWCA_NIP, [NABYWCA_NIP] = @NABYWCA_NIP, [FAKTURA_TYP] = @FAKTURA_TYP, [FAKTURA_PODTYP] = @FAKTURA_PODTYP, [ID_KONTA] = @ID_KONTA, [EKSPORT] = @EKSPORT, [EXPORTED] = @EXPORTED, [ID_TYTUL] = @ID_TYTUL, [EXPORTED_DATA] = @EXPORTED_DATA, [suma_zaplat] = @suma_zaplat, [ID_FK_KOR] = @ID_FK_KOR, [KOREKTA] = @KOREKTA, [zaplata_data] = @zaplata_data, [zaplata_opis] = @zaplata_opis, [Zaliczka_Brutto] = @Zaliczka_Brutto, [Zaliczka_Data] = @Zaliczka_Data, [waluta_brutto] = @waluta_brutto, [waluta_miano] = @waluta_miano, [waluta_kurs] = @waluta_kurs, [waluta_przelicznik] = @waluta_przelicznik, [waluta_kurs_z_dnia] = @waluta_kurs_z_dnia, [waluta_tabela_nr] = @waluta_tabela_nr WHERE (([ID_FAKTURY] = @Original_ID_FAKTURY) AND ((@IsNull_NUMER = 1 AND [NUMER] IS NULL) OR ([NUMER] = @Original_NUMER)) AND ((@IsNull_NUMER_ROZ = 1 AND [NUMER_ROZ] IS NULL) OR ([NUMER_ROZ] = @Original_NUMER_ROZ)) AND ((@IsNull_NUMER_ROK = 1 AND [NUMER_ROK] IS NULL) OR ([NUMER_ROK] = @Original_NUMER_ROK)) AND ((@IsNull_DATA_WYSTAWIENIA = 1 AND [DATA_WYSTAWIENIA] IS NULL) OR ([DATA_WYSTAWIENIA] = @Original_DATA_WYSTAWIENIA)) AND ((@IsNull_MIEJSCOWOSC_WYSTAWIENIA = 1 AND [MIEJSCOWOSC_WYSTAWIENIA] IS NULL) OR ([MIEJSCOWOSC_WYSTAWIENIA] = @Original_MIEJSCOWOSC_WYSTAWIENIA)) AND ((@IsNull_ID_SPRZEDAWCY = 1 AND [ID_SPRZEDAWCY] IS NULL) OR ([ID_SPRZEDAWCY] = @Original_ID_SPRZEDAWCY)) AND ((@IsNull_ID_NABYWCY = 1 AND [ID_NABYWCY] IS NULL) OR ([ID_NABYWCY] = @Original_ID_NABYWCY)) AND ((@IsNull_DATA_SPRZEDAZY = 1 AND [DATA_SPRZEDAZY] IS NULL) OR ([DATA_SPRZEDAZY] = @Original_DATA_SPRZEDAZY)) AND ((@IsNull_PODPIS_WYSTAWIL = 1 AND [PODPIS_WYSTAWIL] IS NULL) OR ([PODPIS_WYSTAWIL] = @Original_PODPIS_WYSTAWIL)) AND ((@IsNull_PODPIS_ODEBRAL = 1 AND [PODPIS_ODEBRAL] IS NULL) OR ([PODPIS_ODEBRAL] = @Original_PODPIS_ODEBRAL)) AND ((@IsNull_SPOSOB_ZAPLATY = 1 AND [SPOSOB_ZAPLATY] IS NULL) OR ([SPOSOB_ZAPLATY] = @Original_SPOSOB_ZAPLATY)) AND ((@IsNull_TERMIN_ZAPLATY = 1 AND [TERMIN_ZAPLATY] IS NULL) OR ([TERMIN_ZAPLATY] = @Original_TERMIN_ZAPLATY)) AND ((@IsNull_ZAPLACONO = 1 AND [ZAPLACONO] IS NULL) OR ([ZAPLACONO] = @Original_ZAPLACONO)) AND ((@IsNull_BYL_WYDRUK = 1 AND [BYL_WYDRUK] IS NULL) OR ([BYL_WYDRUK] = @Original_BYL_WYDRUK)) AND ((@IsNull_SPRZEDAWCA_NIP = 1 AND [SPRZEDAWCA_NIP] IS NULL) OR ([SPRZEDAWCA_NIP] = @Original_SPRZEDAWCA_NIP)) AND ((@IsNull_NABYWCA_NIP = 1 AND [NABYWCA_NIP] IS NULL) OR ([NABYWCA_NIP] = @Original_NABYWCA_NIP)) AND ((@IsNull_FAKTURA_TYP = 1 AND [FAKTURA_TYP] IS NULL) OR ([FAKTURA_TYP] = @Original_FAKTURA_TYP)) AND ((@IsNull_FAKTURA_PODTYP = 1 AND [FAKTURA_PODTYP] IS NULL) OR ([FAKTURA_PODTYP] = @Original_FAKTURA_PODTYP)) AND ((@IsNull_ID_KONTA = 1 AND [ID_KONTA] IS NULL) OR ([ID_KONTA] = @Original_ID_KONTA)) AND ([EKSPORT] = @Original_EKSPORT) AND ([EXPORTED] = @Original_EXPORTED) AND ((@IsNull_ID_TYTUL = 1 AND [ID_TYTUL] IS NULL) OR ([ID_TYTUL] = @Original_ID_TYTUL)) AND ((@IsNull_EXPORTED_DATA = 1 AND [EXPORTED_DATA] IS NULL) OR ([EXPORTED_DATA] = @Original_EXPORTED_DATA)) AND ((@IsNull_suma_zaplat = 1 AND [suma_zaplat] IS NULL) OR ([suma_zaplat] = @Original_suma_zaplat)) AND ((@IsNull_ID_FK_KOR = 1 AND [ID_FK_KOR] IS NULL) OR ([ID_FK_KOR] = @Original_ID_FK_KOR)) AND ([KOREKTA] = @Original_KOREKTA) AND ((@IsNull_zaplata_data = 1 AND [zaplata_data] IS NULL) OR ([zaplata_data] = @Original_zaplata_data)) AND ((@IsNull_zaplata_opis = 1 AND [zaplata_opis] IS NULL) OR ([zaplata_opis] = @Original_zaplata_opis)) AND ((@IsNull_Zaliczka_Brutto = 1 AND [Zaliczka_Brutto] IS NULL) OR ([Zaliczka_Brutto] = @Original_Zaliczka_Brutto)) AND ((@IsNull_Zaliczka_Data = 1 AND [Zaliczka_Data] IS NULL) OR ([Zaliczka_Data] = @Original_Zaliczka_Data)) AND ((@IsNull_waluta_brutto = 1 AND [waluta_brutto] IS NULL) OR ([waluta_brutto] = @Original_waluta_brutto)) AND ((@IsNull_waluta_miano = 1 AND [waluta_miano] IS NULL) OR ([waluta_miano] = @Original_waluta_miano)) AND ((@IsNull_waluta_kurs = 1 AND [waluta_kurs] IS NULL) OR ([waluta_kurs] = @Original_waluta_kurs)) AND ((@IsNull_waluta_przelicznik = 1 AND [waluta_przelicznik] IS NULL) OR ([waluta_przelicznik] = @Original_waluta_przelicznik)) AND ((@IsNull_waluta_kurs_z_dnia = 1 AND [waluta_kurs_z_dnia] IS NULL) OR ([waluta_kurs_z_dnia] = @Original_waluta_kurs_z_dnia)) AND ((@IsNull_waluta_tabela_nr = 1 AND [waluta_tabela_nr] IS NULL) OR ([waluta_tabela_nr] = @Original_waluta_tabela_nr)));
SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (ID_FAKTURY = @ID_FAKTURY)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NUMER_ROZ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATA_WYSTAWIENIA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DATA_SPRZEDAZY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PODPIS_WYSTAWIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PODPIS_ODEBRAL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@opis" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="opis" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPOSOB_ZAPLATY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TERMIN_ZAPLATY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ZAPLACONO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BYL_WYDRUK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NABYWCA_ADRES" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="NABYWCA_ADRES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPRZEDAWCA_ADRES" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_ADRES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SPRZEDAWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NABYWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@FAKTURA_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@FAKTURA_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ID_KONTA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EKSPORT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EKSPORT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@EXPORTED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EXPORTED" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ID_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EXPORTED_DATA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@suma_zaplat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@KOREKTA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="KOREKTA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@zaplata_data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@zaplata_opis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Zaliczka_Brutto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Zaliczka_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@waluta_brutto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@waluta_miano" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@waluta_kurs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@waluta_kurs_z_dnia" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@waluta_tabela_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NUMER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER_ROZ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NUMER_ROZ" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NUMER_ROZ" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NUMER_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUMER_ROK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_WYSTAWIENIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATA_WYSTAWIENIA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MIEJSCOWOSC_WYSTAWIENIA" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_SPRZEDAWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_SPRZEDAWCY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_NABYWCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_NABYWCY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DATA_SPRZEDAZY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DATA_SPRZEDAZY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DATA_SPRZEDAZY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODPIS_WYSTAWIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PODPIS_WYSTAWIL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_WYSTAWIL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODPIS_ODEBRAL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PODPIS_ODEBRAL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PODPIS_ODEBRAL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPOSOB_ZAPLATY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SPOSOB_ZAPLATY" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPOSOB_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TERMIN_ZAPLATY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TERMIN_ZAPLATY" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TERMIN_ZAPLATY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZAPLACONO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ZAPLACONO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ZAPLACONO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BYL_WYDRUK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BYL_WYDRUK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BYL_WYDRUK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPRZEDAWCA_NIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SPRZEDAWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SPRZEDAWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NABYWCA_NIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NABYWCA_NIP" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NABYWCA_NIP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FAKTURA_TYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_FAKTURA_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_TYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FAKTURA_PODTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_FAKTURA_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FAKTURA_PODTYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_KONTA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ID_KONTA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_KONTA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EKSPORT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EKSPORT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_EXPORTED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="EXPORTED" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_TYTUL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_ID_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ID_TYTUL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EXPORTED_DATA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EXPORTED_DATA" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EXPORTED_DATA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_suma_zaplat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_suma_zaplat" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="suma_zaplat" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FK_KOR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FK_KOR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_KOREKTA" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="KOREKTA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaplata_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_zaplata_data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="zaplata_data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaplata_opis" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_zaplata_opis" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="zaplata_opis" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zaliczka_Brutto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Zaliczka_Brutto" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Zaliczka_Brutto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Zaliczka_Data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Zaliczka_Data" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Zaliczka_Data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_brutto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_waluta_brutto" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_brutto" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_miano" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_waluta_miano" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_miano" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_kurs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_waluta_kurs" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="waluta_kurs" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_waluta_przelicznik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_przelicznik" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_kurs_z_dnia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_waluta_kurs_z_dnia" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="waluta_kurs_z_dnia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_waluta_tabela_nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_waluta_tabela_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="waluta_tabela_nr" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID_FAKTURY" ColumnName="ID_FAKTURY" DataSourceName="BAZA_REKLAM_TEST.dbo.FAKTURY" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_FAKTURY" DataSetColumn="ID_FAKTURY" />
              <Mapping SourceColumn="NUMER_ROZ" DataSetColumn="NUMER_ROZ" />
              <Mapping SourceColumn="NUMER_ROK" DataSetColumn="NUMER_ROK" />
              <Mapping SourceColumn="DATA_WYSTAWIENIA" DataSetColumn="DATA_WYSTAWIENIA" />
              <Mapping SourceColumn="MIEJSCOWOSC_WYSTAWIENIA" DataSetColumn="MIEJSCOWOSC_WYSTAWIENIA" />
              <Mapping SourceColumn="ID_SPRZEDAWCY" DataSetColumn="ID_SPRZEDAWCY" />
              <Mapping SourceColumn="ID_NABYWCY" DataSetColumn="ID_NABYWCY" />
              <Mapping SourceColumn="DATA_SPRZEDAZY" DataSetColumn="DATA_SPRZEDAZY" />
              <Mapping SourceColumn="PODPIS_WYSTAWIL" DataSetColumn="PODPIS_WYSTAWIL" />
              <Mapping SourceColumn="PODPIS_ODEBRAL" DataSetColumn="PODPIS_ODEBRAL" />
              <Mapping SourceColumn="opis" DataSetColumn="opis" />
              <Mapping SourceColumn="SPOSOB_ZAPLATY" DataSetColumn="SPOSOB_ZAPLATY" />
              <Mapping SourceColumn="TERMIN_ZAPLATY" DataSetColumn="TERMIN_ZAPLATY" />
              <Mapping SourceColumn="ZAPLACONO" DataSetColumn="ZAPLACONO" />
              <Mapping SourceColumn="BYL_WYDRUK" DataSetColumn="BYL_WYDRUK" />
              <Mapping SourceColumn="NABYWCA_ADRES" DataSetColumn="NABYWCA_ADRES" />
              <Mapping SourceColumn="SPRZEDAWCA_ADRES" DataSetColumn="SPRZEDAWCA_ADRES" />
              <Mapping SourceColumn="SPRZEDAWCA_NIP" DataSetColumn="SPRZEDAWCA_NIP" />
              <Mapping SourceColumn="NABYWCA_NIP" DataSetColumn="NABYWCA_NIP" />
              <Mapping SourceColumn="FAKTURA_TYP" DataSetColumn="FAKTURA_TYP" />
              <Mapping SourceColumn="FAKTURA_PODTYP" DataSetColumn="FAKTURA_PODTYP" />
              <Mapping SourceColumn="ID_KONTA" DataSetColumn="ID_KONTA" />
              <Mapping SourceColumn="EKSPORT" DataSetColumn="EKSPORT" />
              <Mapping SourceColumn="EXPORTED" DataSetColumn="EXPORTED" />
              <Mapping SourceColumn="ID_TYTUL" DataSetColumn="ID_TYTUL" />
              <Mapping SourceColumn="EXPORTED_DATA" DataSetColumn="EXPORTED_DATA" />
              <Mapping SourceColumn="suma_zaplat" DataSetColumn="suma_zaplat" />
              <Mapping SourceColumn="ID_FK_KOR" DataSetColumn="ID_FK_KOR" />
              <Mapping SourceColumn="KOREKTA" DataSetColumn="KOREKTA" />
              <Mapping SourceColumn="zaplata_data" DataSetColumn="zaplata_data" />
              <Mapping SourceColumn="zaplata_opis" DataSetColumn="zaplata_opis" />
              <Mapping SourceColumn="Zaliczka_Brutto" DataSetColumn="Zaliczka_Brutto" />
              <Mapping SourceColumn="Zaliczka_Data" DataSetColumn="Zaliczka_Data" />
              <Mapping SourceColumn="waluta_brutto" DataSetColumn="waluta_brutto" />
              <Mapping SourceColumn="waluta_miano" DataSetColumn="waluta_miano" />
              <Mapping SourceColumn="waluta_kurs" DataSetColumn="waluta_kurs" />
              <Mapping SourceColumn="waluta_przelicznik" DataSetColumn="waluta_przelicznik" />
              <Mapping SourceColumn="waluta_kurs_z_dnia" DataSetColumn="waluta_kurs_z_dnia" />
              <Mapping SourceColumn="waluta_tabela_nr" DataSetColumn="waluta_tabela_nr" />
              <Mapping SourceColumn="NUMER" DataSetColumn="NUMER" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.FAKTURY" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByNotExported" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByNotExported" GeneratorSourceName="FillByNotExported" GetMethodModifier="Public" GetMethodName="GetDataByNotExported" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByNotExported" UserSourceName="FillByNotExported">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT BYL_WYDRUK, DATA_SPRZEDAZY, DATA_WYSTAWIENIA, EKSPORT, EXPORTED, EXPORTED_DATA, FAKTURA_PODTYP, FAKTURA_TYP, ID_FAKTURY, ID_FK_KOR, ID_KONTA, ID_NABYWCY, ID_SPRZEDAWCY, ID_TYTUL, KOREKTA, MIEJSCOWOSC_WYSTAWIENIA, NABYWCA_ADRES, NABYWCA_NIP, NUMER, NUMER_ROK, NUMER_ROZ, PODPIS_ODEBRAL, PODPIS_WYSTAWIL, SPOSOB_ZAPLATY, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, TERMIN_ZAPLATY, ZAPLACONO, Zaliczka_Brutto, Zaliczka_Data, opis, suma_zaplat, waluta_brutto, waluta_kurs, waluta_kurs_z_dnia, waluta_miano, waluta_przelicznik, waluta_tabela_nr, zaplata_data, zaplata_opis FROM FAKTURY WHERE (NUMER_ROK &gt;= 2008) AND (EXPORTED = 0) AND (SystemKsiegowyId = 2) AND KOREKTA=0 ORDER BY ID_NABYWCY</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FAKTURA_DETAILSTableAdapter" GeneratorDataComponentClassName="FAKTURA_DETAILSTableAdapter" Name="FAKTURA_DETAILS" UserDataComponentName="FAKTURA_DETAILSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.FAKTURA_DETAILS" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[FAKTURA_DETAILS] WHERE (([ID_FAKTURA_DETAILS] = @Original_ID_FAKTURA_DETAILS) AND ((@IsNull_ID_FAKTURY = 1 AND [ID_FAKTURY] IS NULL) OR ([ID_FAKTURY] = @Original_ID_FAKTURY)) AND ((@IsNull_ROK = 1 AND [ROK] IS NULL) OR ([ROK] = @Original_ROK)) AND ((@IsNull_MIESIAC = 1 AND [MIESIAC] IS NULL) OR ([MIESIAC] = @Original_MIESIAC)) AND ((@IsNull_NAZWA_USLUGI = 1 AND [NAZWA_USLUGI] IS NULL) OR ([NAZWA_USLUGI] = @Original_NAZWA_USLUGI)) AND ((@IsNull_SYMBOL_SWW = 1 AND [SYMBOL_SWW] IS NULL) OR ([SYMBOL_SWW] = @Original_SYMBOL_SWW)) AND ((@IsNull_JM = 1 AND [JM] IS NULL) OR ([JM] = @Original_JM)) AND ((@IsNull_ILOSC = 1 AND [ILOSC] IS NULL) OR ([ILOSC] = @Original_ILOSC)) AND ((@IsNull_CENA_JEDN = 1 AND [CENA_JEDN] IS NULL) OR ([CENA_JEDN] = @Original_CENA_JEDN)) AND ((@IsNull_UPUST_PR = 1 AND [UPUST_PR] IS NULL) OR ([UPUST_PR] = @Original_UPUST_PR)) AND ((@IsNull_UPUST_NETTO = 1 AND [UPUST_NETTO] IS NULL) OR ([UPUST_NETTO] = @Original_UPUST_NETTO)) AND ((@IsNull_NETTO = 1 AND [NETTO] IS NULL) OR ([NETTO] = @Original_NETTO)) AND ((@IsNull_S_VAT = 1 AND [S_VAT] IS NULL) OR ([S_VAT] = @Original_S_VAT)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_BRUTTO = 1 AND [BRUTTO] IS NULL) OR ([BRUTTO] = @Original_BRUTTO)) AND ((@IsNull_TYTUL = 1 AND [TYTUL] IS NULL) OR ([TYTUL] = @Original_TYTUL)) AND ((@IsNull_NR_WYDANIA = 1 AND [NR_WYDANIA] IS NULL) OR ([NR_WYDANIA] = @Original_NR_WYDANIA)) AND ((@IsNull_TYP = 1 AND [TYP] IS NULL) OR ([TYP] = @Original_TYP)) AND ((@IsNull_PODTYP = 1 AND [PODTYP] IS NULL) OR ([PODTYP] = @Original_PODTYP)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURA_DETAILS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURA_DETAILS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MIESIAC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_MIESIAC" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAZWA_USLUGI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NAZWA_USLUGI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYMBOL_SWW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SYMBOL_SWW" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CENA_JEDN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CENA_JEDN" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UPUST_PR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_UPUST_PR" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UPUST_NETTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_UPUST_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NETTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_S_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_S_VAT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BRUTTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_BRUTTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TYTUL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NR_WYDANIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NR_WYDANIA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[FAKTURA_DETAILS] ([ID_FAKTURY], [ROK], [MIESIAC], [NAZWA_USLUGI], [SYMBOL_SWW], [JM], [ILOSC], [CENA_JEDN], [UPUST_PR], [UPUST_NETTO], [NETTO], [S_VAT], [VAT], [BRUTTO], [TYTUL], [NR_WYDANIA], [TYP], [PODTYP]) VALUES (@ID_FAKTURY, @ROK, @MIESIAC, @NAZWA_USLUGI, @SYMBOL_SWW, @JM, @ILOSC, @CENA_JEDN, @UPUST_PR, @UPUST_NETTO, @NETTO, @S_VAT, @VAT, @BRUTTO, @TYTUL, @NR_WYDANIA, @TYP, @PODTYP);
SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM FAKTURA_DETAILS WHERE (ID_FAKTURA_DETAILS = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@MIESIAC" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NAZWA_USLUGI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SYMBOL_SWW" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CENA_JEDN" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UPUST_PR" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UPUST_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@S_VAT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BRUTTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NR_WYDANIA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM dbo.FAKTURA_DETAILS</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[FAKTURA_DETAILS] SET [ID_FAKTURY] = @ID_FAKTURY, [ROK] = @ROK, [MIESIAC] = @MIESIAC, [NAZWA_USLUGI] = @NAZWA_USLUGI, [SYMBOL_SWW] = @SYMBOL_SWW, [JM] = @JM, [ILOSC] = @ILOSC, [CENA_JEDN] = @CENA_JEDN, [UPUST_PR] = @UPUST_PR, [UPUST_NETTO] = @UPUST_NETTO, [NETTO] = @NETTO, [S_VAT] = @S_VAT, [VAT] = @VAT, [BRUTTO] = @BRUTTO, [TYTUL] = @TYTUL, [NR_WYDANIA] = @NR_WYDANIA, [TYP] = @TYP, [PODTYP] = @PODTYP WHERE (([ID_FAKTURA_DETAILS] = @Original_ID_FAKTURA_DETAILS) AND ((@IsNull_ID_FAKTURY = 1 AND [ID_FAKTURY] IS NULL) OR ([ID_FAKTURY] = @Original_ID_FAKTURY)) AND ((@IsNull_ROK = 1 AND [ROK] IS NULL) OR ([ROK] = @Original_ROK)) AND ((@IsNull_MIESIAC = 1 AND [MIESIAC] IS NULL) OR ([MIESIAC] = @Original_MIESIAC)) AND ((@IsNull_NAZWA_USLUGI = 1 AND [NAZWA_USLUGI] IS NULL) OR ([NAZWA_USLUGI] = @Original_NAZWA_USLUGI)) AND ((@IsNull_SYMBOL_SWW = 1 AND [SYMBOL_SWW] IS NULL) OR ([SYMBOL_SWW] = @Original_SYMBOL_SWW)) AND ((@IsNull_JM = 1 AND [JM] IS NULL) OR ([JM] = @Original_JM)) AND ((@IsNull_ILOSC = 1 AND [ILOSC] IS NULL) OR ([ILOSC] = @Original_ILOSC)) AND ((@IsNull_CENA_JEDN = 1 AND [CENA_JEDN] IS NULL) OR ([CENA_JEDN] = @Original_CENA_JEDN)) AND ((@IsNull_UPUST_PR = 1 AND [UPUST_PR] IS NULL) OR ([UPUST_PR] = @Original_UPUST_PR)) AND ((@IsNull_UPUST_NETTO = 1 AND [UPUST_NETTO] IS NULL) OR ([UPUST_NETTO] = @Original_UPUST_NETTO)) AND ((@IsNull_NETTO = 1 AND [NETTO] IS NULL) OR ([NETTO] = @Original_NETTO)) AND ((@IsNull_S_VAT = 1 AND [S_VAT] IS NULL) OR ([S_VAT] = @Original_S_VAT)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_BRUTTO = 1 AND [BRUTTO] IS NULL) OR ([BRUTTO] = @Original_BRUTTO)) AND ((@IsNull_TYTUL = 1 AND [TYTUL] IS NULL) OR ([TYTUL] = @Original_TYTUL)) AND ((@IsNull_NR_WYDANIA = 1 AND [NR_WYDANIA] IS NULL) OR ([NR_WYDANIA] = @Original_NR_WYDANIA)) AND ((@IsNull_TYP = 1 AND [TYP] IS NULL) OR ([TYP] = @Original_TYP)) AND ((@IsNull_PODTYP = 1 AND [PODTYP] IS NULL) OR ([PODTYP] = @Original_PODTYP)));
SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM FAKTURA_DETAILS WHERE (ID_FAKTURA_DETAILS = @ID_FAKTURA_DETAILS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@MIESIAC" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NAZWA_USLUGI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SYMBOL_SWW" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@JM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CENA_JEDN" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@UPUST_PR" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@UPUST_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@S_VAT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@BRUTTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NR_WYDANIA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURA_DETAILS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURA_DETAILS" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_FAKTURY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ROK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ROK" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MIESIAC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_MIESIAC" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MIESIAC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NAZWA_USLUGI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NAZWA_USLUGI" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NAZWA_USLUGI" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SYMBOL_SWW" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SYMBOL_SWW" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SYMBOL_SWW" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_JM" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="JM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ILOSC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ILOSC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CENA_JEDN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CENA_JEDN" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CENA_JEDN" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UPUST_PR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_UPUST_PR" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="UPUST_PR" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UPUST_NETTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_UPUST_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="UPUST_NETTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NETTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_NETTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="NETTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_S_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_S_VAT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="S_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VAT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_VAT" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BRUTTO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_BRUTTO" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="BRUTTO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TYTUL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TYTUL" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYTUL" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NR_WYDANIA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NR_WYDANIA" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NR_WYDANIA" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PODTYP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PODTYP" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PODTYP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="ID_FAKTURA_DETAILS" ColumnName="ID_FAKTURA_DETAILS" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_FAKTURA_DETAILS" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_FAKTURA_DETAILS" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_FAKTURA_DETAILS" DataSetColumn="ID_FAKTURA_DETAILS" />
              <Mapping SourceColumn="ID_FAKTURY" DataSetColumn="ID_FAKTURY" />
              <Mapping SourceColumn="ROK" DataSetColumn="ROK" />
              <Mapping SourceColumn="MIESIAC" DataSetColumn="MIESIAC" />
              <Mapping SourceColumn="NAZWA_USLUGI" DataSetColumn="NAZWA_USLUGI" />
              <Mapping SourceColumn="SYMBOL_SWW" DataSetColumn="SYMBOL_SWW" />
              <Mapping SourceColumn="JM" DataSetColumn="JM" />
              <Mapping SourceColumn="ILOSC" DataSetColumn="ILOSC" />
              <Mapping SourceColumn="CENA_JEDN" DataSetColumn="CENA_JEDN" />
              <Mapping SourceColumn="UPUST_PR" DataSetColumn="UPUST_PR" />
              <Mapping SourceColumn="UPUST_NETTO" DataSetColumn="UPUST_NETTO" />
              <Mapping SourceColumn="NETTO" DataSetColumn="NETTO" />
              <Mapping SourceColumn="S_VAT" DataSetColumn="S_VAT" />
              <Mapping SourceColumn="VAT" DataSetColumn="VAT" />
              <Mapping SourceColumn="BRUTTO" DataSetColumn="BRUTTO" />
              <Mapping SourceColumn="TYTUL" DataSetColumn="TYTUL" />
              <Mapping SourceColumn="NR_WYDANIA" DataSetColumn="NR_WYDANIA" />
              <Mapping SourceColumn="TYP" DataSetColumn="TYP" />
              <Mapping SourceColumn="PODTYP" DataSetColumn="PODTYP" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.FAKTURA_DETAILS" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdFaktury" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByIdFaktury" GeneratorSourceName="FillByIdFaktury" GetMethodModifier="Public" GetMethodName="GetDataByIdFaktury" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByIdFaktury" UserSourceName="FillByIdFaktury">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM dbo.FAKTURA_DETAILS where Id_faktury = @idFaktury</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="idFaktury" ColumnName="ID_FAKTURY" DataSourceName="BAZA_REKLAM_TEST.dbo.FAKTURA_DETAILS" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idFaktury" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_FAKTURY" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="KLIENCITableAdapter" GeneratorDataComponentClassName="KLIENCITableAdapter" Name="KLIENCI" UserDataComponentName="KLIENCITableAdapter">
            <MainSource>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.KLIENCI" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [KLIENCI] WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ((@IsNull_LastName = 1 AND [LastName] IS NULL) OR ([LastName] = @Original_LastName)) AND ((@IsNull_OrganizationName = 1 AND [OrganizationName] IS NULL) OR ([OrganizationName] = @Original_OrganizationName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Country = 1 AND [Country] IS NULL) OR ([Country] = @Original_Country)) AND ((@IsNull_Nip = 1 AND [Nip] IS NULL) OR ([Nip] = @Original_Nip)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ((@IsNull_PhoneNumber = 1 AND [PhoneNumber] IS NULL) OR ([PhoneNumber] = @Original_PhoneNumber)) AND ((@IsNull_FaxNumber = 1 AND [FaxNumber] IS NULL) OR ([FaxNumber] = @Original_FaxNumber)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_osw_nr = 1 AND [osw_nr] IS NULL) OR ([osw_nr] = @Original_osw_nr)) AND ((@IsNull_osw_wazne_do = 1 AND [osw_wazne_do] IS NULL) OR ([osw_wazne_do] = @Original_osw_wazne_do)) AND ((@IsNull_Adres_Fkatura = 1 AND [Adres_Fkatura] IS NULL) OR ([Adres_Fkatura] = @Original_Adres_Fkatura)) AND ((@IsNull_Old_ID = 1 AND [Old_ID] IS NULL) OR ([Old_ID] = @Original_Old_ID)) AND ((@IsNull_Adres_Kor = 1 AND [Adres_Kor] IS NULL) OR ([Adres_Kor] = @Original_Adres_Kor)) AND ([Platnik_VAT] = @Original_Platnik_VAT) AND ([Aktywny] = @Original_Aktywny) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Last_Modify = 1 AND [Last_Modify] IS NULL) OR ([Last_Modify] = @Original_Last_Modify)) AND ((@IsNull_Modify_User = 1 AND [Modify_User] IS NULL) OR ([Modify_User] = @Original_Modify_User)) AND ((@IsNull_http = 1 AND [http] IS NULL) OR ([http] = @Original_http)) AND ((@IsNull_VIES = 1 AND [VIES] IS NULL) OR ([VIES] = @Original_VIES)) AND ((@IsNull_regon = 1 AND [regon] IS NULL) OR ([regon] = @Original_regon)) AND ((@IsNull_krs = 1 AND [krs] IS NULL) OR ([krs] = @Original_krs)) AND ((@IsNull_nipKraj = 1 AND [nipKraj] IS NULL) OR ([nipKraj] = @Original_nipKraj)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrganizationName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OrganizationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PostalCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Country" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhoneNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PhoneNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FaxNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FaxNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_osw_nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_osw_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_osw_wazne_do" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_osw_wazne_do" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Adres_Fkatura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Adres_Fkatura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Adres_Kor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Adres_Kor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Platnik_VAT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Platnik_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Aktywny" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Aktywny" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Last_Modify" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Last_Modify" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Modify_User" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Modify_User" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_http" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_http" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VIES" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_VIES" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_regon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_regon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_krs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_krs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nipKraj" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nipKraj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [KLIENCI] ([FirstName], [LastName], [OrganizationName], [Address], [City], [State], [PostalCode], [Country], [Nip], [ContactName], [PhoneNumber], [FaxNumber], [Note], [data], [osw_nr], [osw_wazne_do], [Adres_Fkatura], [Old_ID], [Adres_Kor], [Platnik_VAT], [Aktywny], [Email], [UserName], [Last_Modify], [Modify_User], [http], [VIES], [regon], [krs], [nipKraj]) VALUES (@FirstName, @LastName, @OrganizationName, @Address, @City, @State, @PostalCode, @Country, @Nip, @ContactName, @PhoneNumber, @FaxNumber, @Note, @data, @osw_nr, @osw_wazne_do, @Adres_Fkatura, @Old_ID, @Adres_Kor, @Platnik_VAT, @Aktywny, @Email, @UserName, @Last_Modify, @Modify_User, @http, @VIES, @regon, @krs, @nipKraj);
SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj FROM KLIENCI WHERE (CustomerID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrganizationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PhoneNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FaxNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@osw_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@osw_wazne_do" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Adres_Fkatura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adres_Kor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Platnik_VAT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Platnik_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Aktywny" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Aktywny" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Last_Modify" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Modify_User" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@http" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@VIES" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@regon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@krs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nipKraj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT        CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, 
                         osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, 
                         nipKraj
FROM            KLIENCI</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [KLIENCI] SET [FirstName] = @FirstName, [LastName] = @LastName, [OrganizationName] = @OrganizationName, [Address] = @Address, [City] = @City, [State] = @State, [PostalCode] = @PostalCode, [Country] = @Country, [Nip] = @Nip, [ContactName] = @ContactName, [PhoneNumber] = @PhoneNumber, [FaxNumber] = @FaxNumber, [Note] = @Note, [data] = @data, [osw_nr] = @osw_nr, [osw_wazne_do] = @osw_wazne_do, [Adres_Fkatura] = @Adres_Fkatura, [Old_ID] = @Old_ID, [Adres_Kor] = @Adres_Kor, [Platnik_VAT] = @Platnik_VAT, [Aktywny] = @Aktywny, [Email] = @Email, [UserName] = @UserName, [Last_Modify] = @Last_Modify, [Modify_User] = @Modify_User, [http] = @http, [VIES] = @VIES, [regon] = @regon, [krs] = @krs, [nipKraj] = @nipKraj WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ((@IsNull_LastName = 1 AND [LastName] IS NULL) OR ([LastName] = @Original_LastName)) AND ((@IsNull_OrganizationName = 1 AND [OrganizationName] IS NULL) OR ([OrganizationName] = @Original_OrganizationName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Country = 1 AND [Country] IS NULL) OR ([Country] = @Original_Country)) AND ((@IsNull_Nip = 1 AND [Nip] IS NULL) OR ([Nip] = @Original_Nip)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ((@IsNull_PhoneNumber = 1 AND [PhoneNumber] IS NULL) OR ([PhoneNumber] = @Original_PhoneNumber)) AND ((@IsNull_FaxNumber = 1 AND [FaxNumber] IS NULL) OR ([FaxNumber] = @Original_FaxNumber)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_osw_nr = 1 AND [osw_nr] IS NULL) OR ([osw_nr] = @Original_osw_nr)) AND ((@IsNull_osw_wazne_do = 1 AND [osw_wazne_do] IS NULL) OR ([osw_wazne_do] = @Original_osw_wazne_do)) AND ((@IsNull_Adres_Fkatura = 1 AND [Adres_Fkatura] IS NULL) OR ([Adres_Fkatura] = @Original_Adres_Fkatura)) AND ((@IsNull_Old_ID = 1 AND [Old_ID] IS NULL) OR ([Old_ID] = @Original_Old_ID)) AND ((@IsNull_Adres_Kor = 1 AND [Adres_Kor] IS NULL) OR ([Adres_Kor] = @Original_Adres_Kor)) AND ([Platnik_VAT] = @Original_Platnik_VAT) AND ([Aktywny] = @Original_Aktywny) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Last_Modify = 1 AND [Last_Modify] IS NULL) OR ([Last_Modify] = @Original_Last_Modify)) AND ((@IsNull_Modify_User = 1 AND [Modify_User] IS NULL) OR ([Modify_User] = @Original_Modify_User)) AND ((@IsNull_http = 1 AND [http] IS NULL) OR ([http] = @Original_http)) AND ((@IsNull_VIES = 1 AND [VIES] IS NULL) OR ([VIES] = @Original_VIES)) AND ((@IsNull_regon = 1 AND [regon] IS NULL) OR ([regon] = @Original_regon)) AND ((@IsNull_krs = 1 AND [krs] IS NULL) OR ([krs] = @Original_krs)) AND ((@IsNull_nipKraj = 1 AND [nipKraj] IS NULL) OR ([nipKraj] = @Original_nipKraj)));
SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj FROM KLIENCI WHERE (CustomerID = @CustomerID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OrganizationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PhoneNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FaxNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@osw_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@osw_wazne_do" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Adres_Fkatura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adres_Kor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Platnik_VAT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Platnik_VAT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Aktywny" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Aktywny" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Last_Modify" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Modify_User" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@http" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@VIES" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@regon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@krs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nipKraj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrganizationName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OrganizationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OrganizationName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PostalCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Country" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nip" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Nip" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nip" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ContactName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ContactName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhoneNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PhoneNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PhoneNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FaxNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FaxNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FaxNumber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_data" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="data" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_osw_nr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_osw_nr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="osw_nr" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_osw_wazne_do" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_osw_wazne_do" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="osw_wazne_do" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Adres_Fkatura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Adres_Fkatura" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Adres_Fkatura" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Old_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Old_ID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Adres_Kor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Adres_Kor" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adres_Kor" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Platnik_VAT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Platnik_VAT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Aktywny" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Aktywny" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Last_Modify" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Last_Modify" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Last_Modify" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Modify_User" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Modify_User" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Modify_User" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_http" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_http" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="http" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VIES" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_VIES" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="VIES" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_regon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_regon" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="regon" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_krs" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_krs" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="krs" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nipKraj" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nipKraj" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nipKraj" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="CustomerID" ColumnName="CustomerID" DataSourceName="BAZA_REKLAM_TEST.dbo.KLIENCI" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="OrganizationName" DataSetColumn="OrganizationName" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="PostalCode" DataSetColumn="PostalCode" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="Nip" DataSetColumn="Nip" />
              <Mapping SourceColumn="ContactName" DataSetColumn="ContactName" />
              <Mapping SourceColumn="PhoneNumber" DataSetColumn="PhoneNumber" />
              <Mapping SourceColumn="FaxNumber" DataSetColumn="FaxNumber" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="data" DataSetColumn="data" />
              <Mapping SourceColumn="osw_nr" DataSetColumn="osw_nr" />
              <Mapping SourceColumn="osw_wazne_do" DataSetColumn="osw_wazne_do" />
              <Mapping SourceColumn="Adres_Fkatura" DataSetColumn="Adres_Fkatura" />
              <Mapping SourceColumn="Old_ID" DataSetColumn="Old_ID" />
              <Mapping SourceColumn="Adres_Kor" DataSetColumn="Adres_Kor" />
              <Mapping SourceColumn="Platnik_VAT" DataSetColumn="Platnik_VAT" />
              <Mapping SourceColumn="Aktywny" DataSetColumn="Aktywny" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Last_Modify" DataSetColumn="Last_Modify" />
              <Mapping SourceColumn="Modify_User" DataSetColumn="Modify_User" />
              <Mapping SourceColumn="http" DataSetColumn="http" />
              <Mapping SourceColumn="VIES" DataSetColumn="VIES" />
              <Mapping SourceColumn="regon" DataSetColumn="regon" />
              <Mapping SourceColumn="krs" DataSetColumn="krs" />
              <Mapping SourceColumn="nipKraj" DataSetColumn="nipKraj" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.KLIENCI" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCustomerId" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByCustomerId" GeneratorSourceName="FillByCustomerId" GetMethodModifier="Public" GetMethodName="GetDataByCustomerId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByCustomerId" UserSourceName="FillByCustomerId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT Address, Adres_Fkatura, Adres_Kor, Aktywny, City, ContactName, Country, CustomerID, Email, FaxNumber, FirstName, LastName, Last_Modify, Modify_User, Nip, Note, Old_ID, OrganizationName, PhoneNumber, Platnik_VAT, PostalCode, State, UserName, VIES, data, http, krs, nipKraj, osw_nr, osw_wazne_do, regon FROM KLIENCI WHERE (CustomerID = @custId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="custId" ColumnName="CustomerID" DataSourceName="BAZA_REKLAM_TEST.dbo.KLIENCI" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@custId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="BAZA_REKLAMConnectionString (Settings)" DbObjectName="BAZA_REKLAM_TEST.dbo.KLIENCI" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTop10" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetDataByTop10" GeneratorSourceName="FillByTop10" GetMethodModifier="Public" GetMethodName="GetDataByTop10" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataByTop10" UserSourceName="FillByTop10">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT TOP 10 Address, Adres_Fkatura, Adres_Kor, Aktywny, City, ContactName, Country, CustomerID, Email, FaxNumber, FirstName, LastName, Last_Modify, Modify_User, Nip, Note, Old_ID, OrganizationName, PhoneNumber, Platnik_VAT, PostalCode, State, UserName, VIES, data, http, krs, nipKraj, osw_nr, osw_wazne_do, regon FROM KLIENCI</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="EXPODataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="EXPODataSet" msprop:Generator_DataSetName="EXPODataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="FAKTURY" msprop:Generator_UserTableName="FAKTURY" msprop:Generator_RowDeletedName="FAKTURYRowDeleted" msprop:Generator_RowChangedName="FAKTURYRowChanged" msprop:Generator_RowClassName="FAKTURYRow" msprop:Generator_RowChangingName="FAKTURYRowChanging" msprop:Generator_RowEvArgName="FAKTURYRowChangeEvent" msprop:Generator_RowEvHandlerName="FAKTURYRowChangeEventHandler" msprop:Generator_TableClassName="FAKTURYDataTable" msprop:Generator_TableVarName="tableFAKTURY" msprop:Generator_RowDeletingName="FAKTURYRowDeleting" msprop:Generator_TablePropName="FAKTURY">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_FAKTURY" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID_FAKTURY" msprop:Generator_ColumnPropNameInRow="ID_FAKTURY" msprop:Generator_ColumnVarNameInTable="columnID_FAKTURY" msprop:Generator_ColumnPropNameInTable="ID_FAKTURYColumn" type="xs:int" />
              <xs:element name="NUMER" msprop:Generator_UserColumnName="NUMER" msprop:Generator_ColumnPropNameInRow="NUMER" msprop:Generator_ColumnVarNameInTable="columnNUMER" msprop:Generator_ColumnPropNameInTable="NUMERColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NUMER_ROZ" msprop:Generator_UserColumnName="NUMER_ROZ" msprop:Generator_ColumnPropNameInRow="NUMER_ROZ" msprop:Generator_ColumnVarNameInTable="columnNUMER_ROZ" msprop:Generator_ColumnPropNameInTable="NUMER_ROZColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NUMER_ROK" msprop:Generator_UserColumnName="NUMER_ROK" msprop:Generator_ColumnPropNameInRow="NUMER_ROK" msprop:Generator_ColumnVarNameInTable="columnNUMER_ROK" msprop:Generator_ColumnPropNameInTable="NUMER_ROKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DATA_WYSTAWIENIA" msprop:Generator_UserColumnName="DATA_WYSTAWIENIA" msprop:Generator_ColumnPropNameInRow="DATA_WYSTAWIENIA" msprop:Generator_ColumnVarNameInTable="columnDATA_WYSTAWIENIA" msprop:Generator_ColumnPropNameInTable="DATA_WYSTAWIENIAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MIEJSCOWOSC_WYSTAWIENIA" msprop:Generator_UserColumnName="MIEJSCOWOSC_WYSTAWIENIA" msprop:Generator_ColumnPropNameInRow="MIEJSCOWOSC_WYSTAWIENIA" msprop:Generator_ColumnVarNameInTable="columnMIEJSCOWOSC_WYSTAWIENIA" msprop:Generator_ColumnPropNameInTable="MIEJSCOWOSC_WYSTAWIENIAColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_SPRZEDAWCY" msprop:Generator_UserColumnName="ID_SPRZEDAWCY" msprop:Generator_ColumnPropNameInRow="ID_SPRZEDAWCY" msprop:Generator_ColumnVarNameInTable="columnID_SPRZEDAWCY" msprop:Generator_ColumnPropNameInTable="ID_SPRZEDAWCYColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ID_NABYWCY" msprop:Generator_UserColumnName="ID_NABYWCY" msprop:Generator_ColumnPropNameInRow="ID_NABYWCY" msprop:Generator_ColumnVarNameInTable="columnID_NABYWCY" msprop:Generator_ColumnPropNameInTable="ID_NABYWCYColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DATA_SPRZEDAZY" msprop:Generator_UserColumnName="DATA_SPRZEDAZY" msprop:Generator_ColumnPropNameInRow="DATA_SPRZEDAZY" msprop:Generator_ColumnVarNameInTable="columnDATA_SPRZEDAZY" msprop:Generator_ColumnPropNameInTable="DATA_SPRZEDAZYColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PODPIS_WYSTAWIL" msprop:Generator_UserColumnName="PODPIS_WYSTAWIL" msprop:Generator_ColumnPropNameInRow="PODPIS_WYSTAWIL" msprop:Generator_ColumnVarNameInTable="columnPODPIS_WYSTAWIL" msprop:Generator_ColumnPropNameInTable="PODPIS_WYSTAWILColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PODPIS_ODEBRAL" msprop:Generator_UserColumnName="PODPIS_ODEBRAL" msprop:Generator_ColumnPropNameInRow="PODPIS_ODEBRAL" msprop:Generator_ColumnVarNameInTable="columnPODPIS_ODEBRAL" msprop:Generator_ColumnPropNameInTable="PODPIS_ODEBRALColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="opis" msprop:Generator_UserColumnName="opis" msprop:Generator_ColumnPropNameInRow="opis" msprop:Generator_ColumnVarNameInTable="columnopis" msprop:Generator_ColumnPropNameInTable="opisColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SPOSOB_ZAPLATY" msprop:Generator_UserColumnName="SPOSOB_ZAPLATY" msprop:Generator_ColumnPropNameInRow="SPOSOB_ZAPLATY" msprop:Generator_ColumnVarNameInTable="columnSPOSOB_ZAPLATY" msprop:Generator_ColumnPropNameInTable="SPOSOB_ZAPLATYColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TERMIN_ZAPLATY" msprop:Generator_UserColumnName="TERMIN_ZAPLATY" msprop:Generator_ColumnPropNameInRow="TERMIN_ZAPLATY" msprop:Generator_ColumnVarNameInTable="columnTERMIN_ZAPLATY" msprop:Generator_ColumnPropNameInTable="TERMIN_ZAPLATYColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ZAPLACONO" msprop:Generator_UserColumnName="ZAPLACONO" msprop:Generator_ColumnPropNameInRow="ZAPLACONO" msprop:Generator_ColumnVarNameInTable="columnZAPLACONO" msprop:Generator_ColumnPropNameInTable="ZAPLACONOColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="BYL_WYDRUK" msprop:Generator_UserColumnName="BYL_WYDRUK" msprop:Generator_ColumnPropNameInRow="BYL_WYDRUK" msprop:Generator_ColumnVarNameInTable="columnBYL_WYDRUK" msprop:Generator_ColumnPropNameInTable="BYL_WYDRUKColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="NABYWCA_ADRES" msprop:Generator_UserColumnName="NABYWCA_ADRES" msprop:Generator_ColumnPropNameInRow="NABYWCA_ADRES" msprop:Generator_ColumnVarNameInTable="columnNABYWCA_ADRES" msprop:Generator_ColumnPropNameInTable="NABYWCA_ADRESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SPRZEDAWCA_ADRES" msprop:Generator_UserColumnName="SPRZEDAWCA_ADRES" msprop:Generator_ColumnPropNameInRow="SPRZEDAWCA_ADRES" msprop:Generator_ColumnVarNameInTable="columnSPRZEDAWCA_ADRES" msprop:Generator_ColumnPropNameInTable="SPRZEDAWCA_ADRESColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SPRZEDAWCA_NIP" msprop:Generator_UserColumnName="SPRZEDAWCA_NIP" msprop:Generator_ColumnPropNameInRow="SPRZEDAWCA_NIP" msprop:Generator_ColumnVarNameInTable="columnSPRZEDAWCA_NIP" msprop:Generator_ColumnPropNameInTable="SPRZEDAWCA_NIPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NABYWCA_NIP" msprop:Generator_UserColumnName="NABYWCA_NIP" msprop:Generator_ColumnPropNameInRow="NABYWCA_NIP" msprop:Generator_ColumnVarNameInTable="columnNABYWCA_NIP" msprop:Generator_ColumnPropNameInTable="NABYWCA_NIPColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FAKTURA_TYP" msprop:Generator_UserColumnName="FAKTURA_TYP" msprop:Generator_ColumnPropNameInRow="FAKTURA_TYP" msprop:Generator_ColumnVarNameInTable="columnFAKTURA_TYP" msprop:Generator_ColumnPropNameInTable="FAKTURA_TYPColumn" type="xs:short" minOccurs="0" />
              <xs:element name="FAKTURA_PODTYP" msprop:Generator_UserColumnName="FAKTURA_PODTYP" msprop:Generator_ColumnPropNameInRow="FAKTURA_PODTYP" msprop:Generator_ColumnVarNameInTable="columnFAKTURA_PODTYP" msprop:Generator_ColumnPropNameInTable="FAKTURA_PODTYPColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ID_KONTA" msprop:Generator_UserColumnName="ID_KONTA" msprop:Generator_ColumnPropNameInRow="ID_KONTA" msprop:Generator_ColumnVarNameInTable="columnID_KONTA" msprop:Generator_ColumnPropNameInTable="ID_KONTAColumn" type="xs:short" minOccurs="0" />
              <xs:element name="EKSPORT" msprop:Generator_UserColumnName="EKSPORT" msprop:Generator_ColumnPropNameInRow="EKSPORT" msprop:Generator_ColumnVarNameInTable="columnEKSPORT" msprop:Generator_ColumnPropNameInTable="EKSPORTColumn" type="xs:boolean" />
              <xs:element name="EXPORTED" msprop:Generator_UserColumnName="EXPORTED" msprop:Generator_ColumnPropNameInRow="EXPORTED" msprop:Generator_ColumnVarNameInTable="columnEXPORTED" msprop:Generator_ColumnPropNameInTable="EXPORTEDColumn" type="xs:boolean" />
              <xs:element name="ID_TYTUL" msprop:Generator_UserColumnName="ID_TYTUL" msprop:Generator_ColumnPropNameInRow="ID_TYTUL" msprop:Generator_ColumnVarNameInTable="columnID_TYTUL" msprop:Generator_ColumnPropNameInTable="ID_TYTULColumn" type="xs:short" minOccurs="0" />
              <xs:element name="EXPORTED_DATA" msprop:Generator_UserColumnName="EXPORTED_DATA" msprop:Generator_ColumnPropNameInRow="EXPORTED_DATA" msprop:Generator_ColumnVarNameInTable="columnEXPORTED_DATA" msprop:Generator_ColumnPropNameInTable="EXPORTED_DATAColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="suma_zaplat" msprop:Generator_UserColumnName="suma_zaplat" msprop:Generator_ColumnPropNameInRow="suma_zaplat" msprop:Generator_ColumnVarNameInTable="columnsuma_zaplat" msprop:Generator_ColumnPropNameInTable="suma_zaplatColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ID_FK_KOR" msprop:Generator_UserColumnName="ID_FK_KOR" msprop:Generator_ColumnPropNameInRow="ID_FK_KOR" msprop:Generator_ColumnVarNameInTable="columnID_FK_KOR" msprop:Generator_ColumnPropNameInTable="ID_FK_KORColumn" type="xs:int" minOccurs="0" />
              <xs:element name="KOREKTA" msprop:Generator_UserColumnName="KOREKTA" msprop:Generator_ColumnPropNameInRow="KOREKTA" msprop:Generator_ColumnVarNameInTable="columnKOREKTA" msprop:Generator_ColumnPropNameInTable="KOREKTAColumn" type="xs:unsignedByte" />
              <xs:element name="zaplata_data" msprop:Generator_UserColumnName="zaplata_data" msprop:Generator_ColumnPropNameInRow="zaplata_data" msprop:Generator_ColumnVarNameInTable="columnzaplata_data" msprop:Generator_ColumnPropNameInTable="zaplata_dataColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="zaplata_opis" msprop:Generator_UserColumnName="zaplata_opis" msprop:Generator_ColumnPropNameInRow="zaplata_opis" msprop:Generator_ColumnVarNameInTable="columnzaplata_opis" msprop:Generator_ColumnPropNameInTable="zaplata_opisColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Zaliczka_Brutto" msprop:Generator_UserColumnName="Zaliczka_Brutto" msprop:Generator_ColumnPropNameInRow="Zaliczka_Brutto" msprop:Generator_ColumnVarNameInTable="columnZaliczka_Brutto" msprop:Generator_ColumnPropNameInTable="Zaliczka_BruttoColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Zaliczka_Data" msprop:Generator_UserColumnName="Zaliczka_Data" msprop:Generator_ColumnPropNameInRow="Zaliczka_Data" msprop:Generator_ColumnVarNameInTable="columnZaliczka_Data" msprop:Generator_ColumnPropNameInTable="Zaliczka_DataColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="waluta_brutto" msprop:Generator_UserColumnName="waluta_brutto" msprop:Generator_ColumnPropNameInRow="waluta_brutto" msprop:Generator_ColumnVarNameInTable="columnwaluta_brutto" msprop:Generator_ColumnPropNameInTable="waluta_bruttoColumn" type="xs:double" minOccurs="0" />
              <xs:element name="waluta_miano" msprop:Generator_UserColumnName="waluta_miano" msprop:Generator_ColumnPropNameInRow="waluta_miano" msprop:Generator_ColumnVarNameInTable="columnwaluta_miano" msprop:Generator_ColumnPropNameInTable="waluta_mianoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="waluta_kurs" msprop:Generator_UserColumnName="waluta_kurs" msprop:Generator_ColumnPropNameInRow="waluta_kurs" msprop:Generator_ColumnVarNameInTable="columnwaluta_kurs" msprop:Generator_ColumnPropNameInTable="waluta_kursColumn" type="xs:double" minOccurs="0" />
              <xs:element name="waluta_przelicznik" msprop:Generator_UserColumnName="waluta_przelicznik" msprop:Generator_ColumnPropNameInRow="waluta_przelicznik" msprop:Generator_ColumnVarNameInTable="columnwaluta_przelicznik" msprop:Generator_ColumnPropNameInTable="waluta_przelicznikColumn" type="xs:int" minOccurs="0" />
              <xs:element name="waluta_kurs_z_dnia" msprop:Generator_UserColumnName="waluta_kurs_z_dnia" msprop:Generator_ColumnPropNameInRow="waluta_kurs_z_dnia" msprop:Generator_ColumnVarNameInTable="columnwaluta_kurs_z_dnia" msprop:Generator_ColumnPropNameInTable="waluta_kurs_z_dniaColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="waluta_tabela_nr" msprop:Generator_UserColumnName="waluta_tabela_nr" msprop:Generator_ColumnPropNameInRow="waluta_tabela_nr" msprop:Generator_ColumnVarNameInTable="columnwaluta_tabela_nr" msprop:Generator_ColumnPropNameInTable="waluta_tabela_nrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pelny_numer" msdata:ReadOnly="true" msdata:Expression="NUMER + '/' + NUMER_ROZ + '/' + NUMER_ROK" msprop:Generator_UserColumnName="Pelny_numer" msprop:Generator_ColumnVarNameInTable="columnPelny_numer" msprop:Generator_ColumnPropNameInRow="Pelny_numer" msprop:Generator_ColumnPropNameInTable="Pelny_numerColumn" type="xs:string" minOccurs="0" />
              <xs:element name="Exportuj" msprop:Generator_UserColumnName="Exportuj" msprop:Generator_ColumnPropNameInRow="Exportuj" msprop:Generator_ColumnVarNameInTable="columnExportuj" msprop:Generator_ColumnPropNameInTable="ExportujColumn" type="xs:boolean" default="true" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FAKTURA_DETAILS" msprop:Generator_UserTableName="FAKTURA_DETAILS" msprop:Generator_RowDeletedName="FAKTURA_DETAILSRowDeleted" msprop:Generator_RowChangedName="FAKTURA_DETAILSRowChanged" msprop:Generator_RowClassName="FAKTURA_DETAILSRow" msprop:Generator_RowChangingName="FAKTURA_DETAILSRowChanging" msprop:Generator_RowEvArgName="FAKTURA_DETAILSRowChangeEvent" msprop:Generator_RowEvHandlerName="FAKTURA_DETAILSRowChangeEventHandler" msprop:Generator_TableClassName="FAKTURA_DETAILSDataTable" msprop:Generator_TableVarName="tableFAKTURA_DETAILS" msprop:Generator_RowDeletingName="FAKTURA_DETAILSRowDeleting" msprop:Generator_TablePropName="FAKTURA_DETAILS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_FAKTURA_DETAILS" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID_FAKTURA_DETAILS" msprop:Generator_ColumnPropNameInRow="ID_FAKTURA_DETAILS" msprop:Generator_ColumnVarNameInTable="columnID_FAKTURA_DETAILS" msprop:Generator_ColumnPropNameInTable="ID_FAKTURA_DETAILSColumn" type="xs:int" />
              <xs:element name="ID_FAKTURY" msprop:Generator_UserColumnName="ID_FAKTURY" msprop:Generator_ColumnPropNameInRow="ID_FAKTURY" msprop:Generator_ColumnVarNameInTable="columnID_FAKTURY" msprop:Generator_ColumnPropNameInTable="ID_FAKTURYColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ROK" msprop:Generator_UserColumnName="ROK" msprop:Generator_ColumnPropNameInRow="ROK" msprop:Generator_ColumnVarNameInTable="columnROK" msprop:Generator_ColumnPropNameInTable="ROKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MIESIAC" msprop:Generator_UserColumnName="MIESIAC" msprop:Generator_ColumnPropNameInRow="MIESIAC" msprop:Generator_ColumnVarNameInTable="columnMIESIAC" msprop:Generator_ColumnPropNameInTable="MIESIACColumn" type="xs:short" minOccurs="0" />
              <xs:element name="NAZWA_USLUGI" msprop:Generator_UserColumnName="NAZWA_USLUGI" msprop:Generator_ColumnPropNameInRow="NAZWA_USLUGI" msprop:Generator_ColumnVarNameInTable="columnNAZWA_USLUGI" msprop:Generator_ColumnPropNameInTable="NAZWA_USLUGIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SYMBOL_SWW" msprop:Generator_UserColumnName="SYMBOL_SWW" msprop:Generator_ColumnPropNameInRow="SYMBOL_SWW" msprop:Generator_ColumnVarNameInTable="columnSYMBOL_SWW" msprop:Generator_ColumnPropNameInTable="SYMBOL_SWWColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="JM" msprop:Generator_UserColumnName="JM" msprop:Generator_ColumnPropNameInRow="JM" msprop:Generator_ColumnVarNameInTable="columnJM" msprop:Generator_ColumnPropNameInTable="JMColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ILOSC" msprop:Generator_UserColumnName="ILOSC" msprop:Generator_ColumnPropNameInRow="ILOSC" msprop:Generator_ColumnVarNameInTable="columnILOSC" msprop:Generator_ColumnPropNameInTable="ILOSCColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CENA_JEDN" msprop:Generator_UserColumnName="CENA_JEDN" msprop:Generator_ColumnPropNameInRow="CENA_JEDN" msprop:Generator_ColumnVarNameInTable="columnCENA_JEDN" msprop:Generator_ColumnPropNameInTable="CENA_JEDNColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="UPUST_PR" msprop:Generator_UserColumnName="UPUST_PR" msprop:Generator_ColumnPropNameInRow="UPUST_PR" msprop:Generator_ColumnVarNameInTable="columnUPUST_PR" msprop:Generator_ColumnPropNameInTable="UPUST_PRColumn" type="xs:double" minOccurs="0" />
              <xs:element name="UPUST_NETTO" msprop:Generator_UserColumnName="UPUST_NETTO" msprop:Generator_ColumnPropNameInRow="UPUST_NETTO" msprop:Generator_ColumnVarNameInTable="columnUPUST_NETTO" msprop:Generator_ColumnPropNameInTable="UPUST_NETTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="NETTO" msprop:Generator_UserColumnName="NETTO" msprop:Generator_ColumnPropNameInRow="NETTO" msprop:Generator_ColumnVarNameInTable="columnNETTO" msprop:Generator_ColumnPropNameInTable="NETTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="S_VAT" msprop:Generator_UserColumnName="S_VAT" msprop:Generator_ColumnPropNameInRow="S_VAT" msprop:Generator_ColumnVarNameInTable="columnS_VAT" msprop:Generator_ColumnPropNameInTable="S_VATColumn" type="xs:double" minOccurs="0" />
              <xs:element name="VAT" msprop:Generator_UserColumnName="VAT" msprop:Generator_ColumnPropNameInRow="VAT" msprop:Generator_ColumnVarNameInTable="columnVAT" msprop:Generator_ColumnPropNameInTable="VATColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="BRUTTO" msprop:Generator_UserColumnName="BRUTTO" msprop:Generator_ColumnPropNameInRow="BRUTTO" msprop:Generator_ColumnVarNameInTable="columnBRUTTO" msprop:Generator_ColumnPropNameInTable="BRUTTOColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TYTUL" msprop:Generator_UserColumnName="TYTUL" msprop:Generator_ColumnPropNameInRow="TYTUL" msprop:Generator_ColumnVarNameInTable="columnTYTUL" msprop:Generator_ColumnPropNameInTable="TYTULColumn" type="xs:short" minOccurs="0" />
              <xs:element name="NR_WYDANIA" msprop:Generator_UserColumnName="NR_WYDANIA" msprop:Generator_ColumnPropNameInRow="NR_WYDANIA" msprop:Generator_ColumnVarNameInTable="columnNR_WYDANIA" msprop:Generator_ColumnPropNameInTable="NR_WYDANIAColumn" type="xs:short" minOccurs="0" />
              <xs:element name="TYP" msprop:Generator_UserColumnName="TYP" msprop:Generator_ColumnPropNameInRow="TYP" msprop:Generator_ColumnVarNameInTable="columnTYP" msprop:Generator_ColumnPropNameInTable="TYPColumn" type="xs:short" minOccurs="0" />
              <xs:element name="PODTYP" msprop:Generator_UserColumnName="PODTYP" msprop:Generator_ColumnPropNameInRow="PODTYP" msprop:Generator_ColumnVarNameInTable="columnPODTYP" msprop:Generator_ColumnPropNameInTable="PODTYPColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="KLIENCI" msprop:Generator_UserTableName="KLIENCI" msprop:Generator_RowDeletedName="KLIENCIRowDeleted" msprop:Generator_RowChangedName="KLIENCIRowChanged" msprop:Generator_RowClassName="KLIENCIRow" msprop:Generator_RowChangingName="KLIENCIRowChanging" msprop:Generator_RowEvArgName="KLIENCIRowChangeEvent" msprop:Generator_RowEvHandlerName="KLIENCIRowChangeEventHandler" msprop:Generator_TableClassName="KLIENCIDataTable" msprop:Generator_TableVarName="tableKLIENCI" msprop:Generator_RowDeletingName="KLIENCIRowDeleting" msprop:Generator_TablePropName="KLIENCI">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" type="xs:int" />
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrganizationName" msprop:Generator_UserColumnName="OrganizationName" msprop:Generator_ColumnPropNameInRow="OrganizationName" msprop:Generator_ColumnVarNameInTable="columnOrganizationName" msprop:Generator_ColumnPropNameInTable="OrganizationNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_UserColumnName="Address" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInTable="AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode" msprop:Generator_UserColumnName="PostalCode" msprop:Generator_ColumnPropNameInRow="PostalCode" msprop:Generator_ColumnVarNameInTable="columnPostalCode" msprop:Generator_ColumnPropNameInTable="PostalCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nip" msprop:Generator_UserColumnName="Nip" msprop:Generator_ColumnPropNameInRow="Nip" msprop:Generator_ColumnVarNameInTable="columnNip" msprop:Generator_ColumnPropNameInTable="NipColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ContactName" msprop:Generator_UserColumnName="ContactName" msprop:Generator_ColumnPropNameInRow="ContactName" msprop:Generator_ColumnVarNameInTable="columnContactName" msprop:Generator_ColumnPropNameInTable="ContactNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNumber" msprop:Generator_UserColumnName="PhoneNumber" msprop:Generator_ColumnPropNameInRow="PhoneNumber" msprop:Generator_ColumnVarNameInTable="columnPhoneNumber" msprop:Generator_ColumnPropNameInTable="PhoneNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FaxNumber" msprop:Generator_UserColumnName="FaxNumber" msprop:Generator_ColumnPropNameInRow="FaxNumber" msprop:Generator_ColumnVarNameInTable="columnFaxNumber" msprop:Generator_ColumnPropNameInTable="FaxNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="data" msprop:Generator_UserColumnName="data" msprop:Generator_ColumnPropNameInRow="data" msprop:Generator_ColumnVarNameInTable="columndata" msprop:Generator_ColumnPropNameInTable="dataColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="osw_nr" msprop:Generator_UserColumnName="osw_nr" msprop:Generator_ColumnPropNameInRow="osw_nr" msprop:Generator_ColumnVarNameInTable="columnosw_nr" msprop:Generator_ColumnPropNameInTable="osw_nrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="osw_wazne_do" msprop:Generator_UserColumnName="osw_wazne_do" msprop:Generator_ColumnPropNameInRow="osw_wazne_do" msprop:Generator_ColumnVarNameInTable="columnosw_wazne_do" msprop:Generator_ColumnPropNameInTable="osw_wazne_doColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Adres_Fkatura" msprop:Generator_UserColumnName="Adres_Fkatura" msprop:Generator_ColumnPropNameInRow="Adres_Fkatura" msprop:Generator_ColumnVarNameInTable="columnAdres_Fkatura" msprop:Generator_ColumnPropNameInTable="Adres_FkaturaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Old_ID" msprop:Generator_UserColumnName="Old_ID" msprop:Generator_ColumnPropNameInRow="Old_ID" msprop:Generator_ColumnVarNameInTable="columnOld_ID" msprop:Generator_ColumnPropNameInTable="Old_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Adres_Kor" msprop:Generator_UserColumnName="Adres_Kor" msprop:Generator_ColumnPropNameInRow="Adres_Kor" msprop:Generator_ColumnVarNameInTable="columnAdres_Kor" msprop:Generator_ColumnPropNameInTable="Adres_KorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Platnik_VAT" msprop:Generator_UserColumnName="Platnik_VAT" msprop:Generator_ColumnPropNameInRow="Platnik_VAT" msprop:Generator_ColumnVarNameInTable="columnPlatnik_VAT" msprop:Generator_ColumnPropNameInTable="Platnik_VATColumn" type="xs:boolean" />
              <xs:element name="Aktywny" msprop:Generator_UserColumnName="Aktywny" msprop:Generator_ColumnPropNameInRow="Aktywny" msprop:Generator_ColumnVarNameInTable="columnAktywny" msprop:Generator_ColumnPropNameInTable="AktywnyColumn" type="xs:boolean" />
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_UserColumnName="UserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Last_Modify" msprop:Generator_UserColumnName="Last_Modify" msprop:Generator_ColumnPropNameInRow="Last_Modify" msprop:Generator_ColumnVarNameInTable="columnLast_Modify" msprop:Generator_ColumnPropNameInTable="Last_ModifyColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Modify_User" msprop:Generator_UserColumnName="Modify_User" msprop:Generator_ColumnPropNameInRow="Modify_User" msprop:Generator_ColumnVarNameInTable="columnModify_User" msprop:Generator_ColumnPropNameInTable="Modify_UserColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="http" msprop:Generator_UserColumnName="http" msprop:Generator_ColumnPropNameInRow="http" msprop:Generator_ColumnVarNameInTable="columnhttp" msprop:Generator_ColumnPropNameInTable="httpColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VIES" msprop:Generator_UserColumnName="VIES" msprop:Generator_ColumnPropNameInRow="VIES" msprop:Generator_ColumnVarNameInTable="columnVIES" msprop:Generator_ColumnPropNameInTable="VIESColumn" type="xs:short" minOccurs="0" />
              <xs:element name="regon" msprop:Generator_UserColumnName="regon" msprop:Generator_ColumnPropNameInRow="regon" msprop:Generator_ColumnVarNameInTable="columnregon" msprop:Generator_ColumnPropNameInTable="regonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="krs" msprop:Generator_UserColumnName="krs" msprop:Generator_ColumnPropNameInRow="krs" msprop:Generator_ColumnVarNameInTable="columnkrs" msprop:Generator_ColumnPropNameInTable="krsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nipKraj" msprop:Generator_UserColumnName="nipKraj" msprop:Generator_ColumnVarNameInTable="columnnipKraj" msprop:Generator_ColumnPropNameInRow="nipKraj" msprop:Generator_ColumnPropNameInTable="nipKrajColumn" 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:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAKTURY" />
      <xs:field xpath="mstns:ID_FAKTURY" />
    </xs:unique>
    <xs:unique name="FAKTURA_DETAILS_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FAKTURA_DETAILS" />
      <xs:field xpath="mstns:ID_FAKTURA_DETAILS" />
    </xs:unique>
    <xs:unique name="KLIENCI_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:KLIENCI" />
      <xs:field xpath="mstns:CustomerID" />
    </xs:unique>
  </xs:element>
</xs:schema>