<?xml version="1.0" encoding="utf-8"?>
<Database Name="BAZA_REKLAM_TEST" Class="PlatnosciDataContext" Serialization="Unidirectional" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;Persist Security Info=True;User ID=wwwadmin" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="BAZA_REKLAM_TESTConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.PlatnosciEcard" Member="PlatnosciEcards">
    <Type Name="PlatnosciEcard">
      <Column Name="ORDERNUMBER" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="IDFaktury" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ORDERDESCRIPTION" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="nip" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="nrZlecenia" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="AMOUNT" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="CURRENCY" Type="System.String" DbType="Char(3)" CanBeNull="true" />
      <Column Name="SESSIONID" Type="System.String" DbType="VarChar(120)" CanBeNull="true" />
      <Column Name="NAME" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
      <Column Name="SURNAME" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
      <Column Name="AUTODEPOSIT" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="LANGUAGE" Type="System.String" DbType="Char(2)" CanBeNull="true" />
      <Column Name="CHARSET" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="COUNTRY" Type="System.String" DbType="Char(3)" CanBeNull="true" />
      <Column Name="JS" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PAYMENTTYPE" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="Data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Status" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="Status_data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Association Name="PlatnosciEcard_PotwierdzeniaEcard" Member="PotwierdzeniaEcards" ThisKey="ORDERNUMBER" OtherKey="ORDERNUMBER" Type="PotwierdzeniaEcard" />
      <Association Name="FAKTURY_PlatnosciEcard" Member="FAKTURY" ThisKey="IDFaktury" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.PotwierdzeniaEcard" Member="PotwierdzeniaEcards">
    <Type Name="PotwierdzeniaEcard">
      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="MERCHANTNUMBER" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="ORDERNUMBER" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="COMMTYPE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="CURRENTSTATE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="PREVIOUSSTATE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="PAYMENTTYPE" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="EVENTTYPE" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="PAYMENTNUMBER" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="APPROVALCODE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="VALIDATIONCODE" Type="System.String" DbType="Char(3)" CanBeNull="true" />
      <Column Name="BIN" Type="System.String" DbType="Char(6)" CanBeNull="true" />
      <Column Name="AUTHTIME" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="TYPE" Type="System.String" DbType="Char(2)" CanBeNull="true" />
      <Column Name="WITHCVC" Type="System.String" DbType="Char(3)" CanBeNull="true" />
      <Column Name="DATATRANSMISJI" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Association Name="PlatnosciEcard_PotwierdzeniaEcard" Member="PlatnosciEcard" ThisKey="ORDERNUMBER" OtherKey="ORDERNUMBER" Type="PlatnosciEcard" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.FAKTURA_DETAILS" Member="FAKTURA_DETAILs">
    <Type Name="FAKTURA_DETAIL">
      <Column Name="ID_FAKTURA_DETAILS" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_FAKTURY" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ROK" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="MIESIAC" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="NAZWA_USLUGI" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
      <Column Name="SYMBOL_SWW" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="JM" Type="System.String" DbType="NVarChar(5)" CanBeNull="true" />
      <Column Name="ILOSC" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="CENA_JEDN" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="UPUST_PR" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Column Name="UPUST_NETTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="NETTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="S_VAT" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Column Name="VAT" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="BRUTTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="TYTUL" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="NR_WYDANIA" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="TYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="PODTYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="wyroznienie" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="reklamaId" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="msrepl_tran_version" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
      <Association Name="FAKTURY_FAKTURA_DETAIL" Member="FAKTURY" ThisKey="ID_FAKTURY" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.FAKTURY" Member="FAKTURies">
    <Type Name="FAKTURY">
      <Column Name="ID_FAKTURY" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="NUMER" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="NUMER_ROZ" Type="System.String" DbType="NVarChar(8)" CanBeNull="true" />
      <Column Name="NUMER_ROK" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="DATA_WYSTAWIENIA" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="MIEJSCOWOSC_WYSTAWIENIA" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="ID_SPRZEDAWCY" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="ID_NABYWCY" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="DATA_SPRZEDAZY" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="PODPIS_WYSTAWIL" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="PODPIS_ODEBRAL" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
      <Column Name="opis" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="SPOSOB_ZAPLATY" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="TERMIN_ZAPLATY" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="ZAPLACONO" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="BYL_WYDRUK" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="NABYWCA_ADRES" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="SPRZEDAWCA_ADRES" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
      <Column Name="SPRZEDAWCA_NIP" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="NABYWCA_NIP" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="FAKTURA_TYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="FAKTURA_PODTYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="ID_KONTA" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="EKSPORT" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="EXPORTED" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Column Name="ID_TYTUL" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
      <Column Name="EXPORTED_DATA" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="suma_zaplat" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="ID_FK_KOR" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="KOREKTA" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="zaplata_data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="zaplata_opis" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Zaliczka_Brutto" Type="System.Decimal" DbType="Money" CanBeNull="true" />
      <Column Name="Zaliczka_Data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="waluta_brutto" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Column Name="waluta_miano" Type="System.String" DbType="NVarChar(4)" CanBeNull="true" />
      <Column Name="waluta_kurs" Type="System.Double" DbType="Float" CanBeNull="true" />
      <Column Name="waluta_przelicznik" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="waluta_kurs_z_dnia" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
      <Column Name="waluta_tabela_nr" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
      <Column Name="idZamowienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idFakturyKorekta" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="idFakturyVAT" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="SystemKsiegowyId" Type="System.Byte" DbType="TinyInt" CanBeNull="true" />
      <Column Name="ZmianaEmisji" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
      <Association Name="FAKTURY_PlatnosciEcard" Member="PlatnosciEcards" ThisKey="ID_FAKTURY" OtherKey="IDFaktury" Type="PlatnosciEcard" />
      <Association Name="FAKTURY_FAKTURA_DETAIL" Member="FAKTURA_DETAILs" ThisKey="ID_FAKTURY" OtherKey="ID_FAKTURY" Type="FAKTURA_DETAIL" />
      <Association Name="FAKTURY_vPlatnosciEcard" Member="vPlatnosciEcards" Storage="_vDanePlatnosciEcards" ThisKey="ID_FAKTURY" OtherKey="ID_faktury" Type="vPlatnosciEcard" />
    </Type>
  </Table>
  <Table Name="dbo.vDanePlatnosciEcard" Member="vPlatnosciEcards">
    <Type Name="vPlatnosciEcard">
      <Column Name="ID_faktury" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
      <Column Name="Numer" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="Numer_Roz" Type="System.String" DbType="NVarChar(8)" CanBeNull="true" />
      <Column Name="Numer_Rok" Type="System.Int32" DbType="Int" CanBeNull="true" />
      <Column Name="SystemKsiegowyId" Type="System.Byte" DbType="TinyInt" CanBeNull="true" />
      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="LastName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Address" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="PostalCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="City" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="nip" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
      <Column Name="[Faktura Numer]" Member="Faktura_Numer" Type="System.String" DbType="NVarChar(70)" CanBeNull="true" />
      <Column Name="Nabywca_nip" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Brutto" Type="System.Decimal" DbType="Decimal(9,2)" CanBeNull="true" />
      <Column Name="Data_Wystawienia" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Termin_zaplaty" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="Sposob_zaplaty" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
      <Column Name="Imie" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="Nazwisko" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="ulica" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="kod" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="miasto" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="telefon" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
      <Column Name="waluta_brutto" Type="System.Decimal" DbType="Decimal(9,2)" CanBeNull="true" />
      <Column Name="waluta_miano" Type="System.String" DbType="NVarChar(4)" CanBeNull="true" />
      <Association Name="FAKTURY_vPlatnosciEcard" Member="FAKTURY" ThisKey="ID_faktury" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
    </Type>
  </Table>
</Database>