root/trunk/eCard/eCardMVC/adMoto.Payments.Core/Data/Platnosci.dbml @ 970

Wersja 970, 14.0 KB (wprowadzona przez marek, 16 years temu)

re #215 - dodanie nowego projektu z lepsza nazwa i typem projektu
Line 
1<?xml version="1.0" encoding="utf-8"?>
2<Database Name="BAZA_REKLAM_TEST" Class="PlatnosciDataContext" Serialization="Unidirectional" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
3  <Connection Mode="AppSettings" ConnectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;Persist Security Info=True;User ID=wwwadmin" SettingsObjectName="adMoto.Payments.Core.Properties.Settings" SettingsPropertyName="BAZA_REKLAM_TESTConnectionString" Provider="System.Data.SqlClient" />
4  <Table Name="dbo.PlatnosciEcard" Member="PlatnosciEcards">
5    <Type Name="PlatnosciEcard">
6      <Column Name="ORDERNUMBER" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
7      <Column Name="IDFaktury" Type="System.Int32" DbType="Int" CanBeNull="true" />
8      <Column Name="ORDERDESCRIPTION" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
9      <Column Name="nip" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
10      <Column Name="nrZlecenia" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
11      <Column Name="AMOUNT" Type="System.Int32" DbType="Int" CanBeNull="true" />
12      <Column Name="CURRENCY" Type="System.String" DbType="Char(3)" CanBeNull="true" />
13      <Column Name="SESSIONID" Type="System.String" DbType="VarChar(120)" CanBeNull="true" />
14      <Column Name="NAME" Type="System.String" DbType="VarChar(25)" CanBeNull="true" />
15      <Column Name="SURNAME" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
16      <Column Name="AUTODEPOSIT" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
17      <Column Name="LANGUAGE" Type="System.String" DbType="Char(2)" CanBeNull="true" />
18      <Column Name="CHARSET" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
19      <Column Name="COUNTRY" Type="System.String" DbType="Char(3)" CanBeNull="true" />
20      <Column Name="JS" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
21      <Column Name="PAYMENTTYPE" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
22      <Column Name="Data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
23      <Column Name="Status" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
24      <Column Name="Status_data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
25      <Association Name="PlatnosciEcard_PotwierdzeniaEcard" Member="PotwierdzeniaEcards" ThisKey="ORDERNUMBER" OtherKey="ORDERNUMBER" Type="PotwierdzeniaEcard" />
26      <Association Name="FAKTURY_PlatnosciEcard" Member="FAKTURY" ThisKey="IDFaktury" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
27    </Type>
28  </Table>
29  <Table Name="dbo.PotwierdzeniaEcard" Member="PotwierdzeniaEcards">
30    <Type Name="PotwierdzeniaEcard">
31      <Column Name="id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
32      <Column Name="MERCHANTNUMBER" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
33      <Column Name="ORDERNUMBER" Type="System.Int32" DbType="Int" CanBeNull="true" />
34      <Column Name="COMMTYPE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
35      <Column Name="CURRENTSTATE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
36      <Column Name="PREVIOUSSTATE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
37      <Column Name="PAYMENTTYPE" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
38      <Column Name="EVENTTYPE" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
39      <Column Name="PAYMENTNUMBER" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
40      <Column Name="APPROVALCODE" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
41      <Column Name="VALIDATIONCODE" Type="System.String" DbType="Char(3)" CanBeNull="true" />
42      <Column Name="BIN" Type="System.String" DbType="Char(6)" CanBeNull="true" />
43      <Column Name="AUTHTIME" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
44      <Column Name="TYPE" Type="System.String" DbType="Char(2)" CanBeNull="true" />
45      <Column Name="WITHCVC" Type="System.String" DbType="Char(3)" CanBeNull="true" />
46      <Column Name="DATATRANSMISJI" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
47      <Association Name="PlatnosciEcard_PotwierdzeniaEcard" Member="PlatnosciEcard" ThisKey="ORDERNUMBER" OtherKey="ORDERNUMBER" Type="PlatnosciEcard" IsForeignKey="true" />
48    </Type>
49  </Table>
50  <Table Name="dbo.FAKTURA_DETAILS" Member="FAKTURA_DETAILs">
51    <Type Name="FAKTURA_DETAIL">
52      <Column Name="ID_FAKTURA_DETAILS" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
53      <Column Name="ID_FAKTURY" Type="System.Int32" DbType="Int" CanBeNull="true" />
54      <Column Name="ROK" Type="System.Int32" DbType="Int" CanBeNull="true" />
55      <Column Name="MIESIAC" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
56      <Column Name="NAZWA_USLUGI" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
57      <Column Name="SYMBOL_SWW" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
58      <Column Name="JM" Type="System.String" DbType="NVarChar(5)" CanBeNull="true" />
59      <Column Name="ILOSC" Type="System.Int32" DbType="Int" CanBeNull="true" />
60      <Column Name="CENA_JEDN" Type="System.Decimal" DbType="Money" CanBeNull="true" />
61      <Column Name="UPUST_PR" Type="System.Double" DbType="Float" CanBeNull="true" />
62      <Column Name="UPUST_NETTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
63      <Column Name="NETTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
64      <Column Name="S_VAT" Type="System.Double" DbType="Float" CanBeNull="true" />
65      <Column Name="VAT" Type="System.Decimal" DbType="Money" CanBeNull="true" />
66      <Column Name="BRUTTO" Type="System.Decimal" DbType="Money" CanBeNull="true" />
67      <Column Name="TYTUL" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
68      <Column Name="NR_WYDANIA" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
69      <Column Name="TYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
70      <Column Name="PODTYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
71      <Column Name="wyroznienie" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
72      <Column Name="reklamaId" Type="System.Int32" DbType="Int" CanBeNull="true" />
73      <Column Name="msrepl_tran_version" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
74      <Association Name="FAKTURY_FAKTURA_DETAIL" Member="FAKTURY" ThisKey="ID_FAKTURY" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
75    </Type>
76  </Table>
77  <Table Name="dbo.FAKTURY" Member="FAKTURies">
78    <Type Name="FAKTURY">
79      <Column Name="ID_FAKTURY" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
80      <Column Name="NUMER" Type="System.Int32" DbType="Int" CanBeNull="true" />
81      <Column Name="NUMER_ROZ" Type="System.String" DbType="NVarChar(8)" CanBeNull="true" />
82      <Column Name="NUMER_ROK" Type="System.Int32" DbType="Int" CanBeNull="true" />
83      <Column Name="DATA_WYSTAWIENIA" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
84      <Column Name="MIEJSCOWOSC_WYSTAWIENIA" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
85      <Column Name="ID_SPRZEDAWCY" Type="System.Int32" DbType="Int" CanBeNull="true" />
86      <Column Name="ID_NABYWCY" Type="System.Int32" DbType="Int" CanBeNull="true" />
87      <Column Name="DATA_SPRZEDAZY" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
88      <Column Name="PODPIS_WYSTAWIL" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
89      <Column Name="PODPIS_ODEBRAL" Type="System.String" DbType="NVarChar(30)" CanBeNull="true" />
90      <Column Name="opis" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
91      <Column Name="SPOSOB_ZAPLATY" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
92      <Column Name="TERMIN_ZAPLATY" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
93      <Column Name="ZAPLACONO" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
94      <Column Name="BYL_WYDRUK" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
95      <Column Name="NABYWCA_ADRES" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
96      <Column Name="SPRZEDAWCA_ADRES" Type="System.String" DbType="NText" CanBeNull="true" UpdateCheck="Never" />
97      <Column Name="SPRZEDAWCA_NIP" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
98      <Column Name="NABYWCA_NIP" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
99      <Column Name="FAKTURA_TYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
100      <Column Name="FAKTURA_PODTYP" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
101      <Column Name="ID_KONTA" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
102      <Column Name="EKSPORT" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
103      <Column Name="EXPORTED" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
104      <Column Name="ID_TYTUL" Type="System.Int16" DbType="SmallInt" CanBeNull="true" />
105      <Column Name="EXPORTED_DATA" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
106      <Column Name="suma_zaplat" Type="System.Decimal" DbType="Money" CanBeNull="true" />
107      <Column Name="ID_FK_KOR" Type="System.Int32" DbType="Int" CanBeNull="true" />
108      <Column Name="KOREKTA" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
109      <Column Name="zaplata_data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
110      <Column Name="zaplata_opis" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
111      <Column Name="Zaliczka_Brutto" Type="System.Decimal" DbType="Money" CanBeNull="true" />
112      <Column Name="Zaliczka_Data" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
113      <Column Name="waluta_brutto" Type="System.Double" DbType="Float" CanBeNull="true" />
114      <Column Name="waluta_miano" Type="System.String" DbType="NVarChar(4)" CanBeNull="true" />
115      <Column Name="waluta_kurs" Type="System.Double" DbType="Float" CanBeNull="true" />
116      <Column Name="waluta_przelicznik" Type="System.Int32" DbType="Int" CanBeNull="true" />
117      <Column Name="waluta_kurs_z_dnia" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
118      <Column Name="waluta_tabela_nr" Type="System.String" DbType="NVarChar(15)" CanBeNull="true" />
119      <Column Name="idZamowienia" Type="System.Int32" DbType="Int" CanBeNull="true" />
120      <Column Name="idFakturyKorekta" Type="System.Int32" DbType="Int" CanBeNull="true" />
121      <Column Name="idFakturyVAT" Type="System.Int32" DbType="Int" CanBeNull="true" />
122      <Column Name="SystemKsiegowyId" Type="System.Byte" DbType="TinyInt" CanBeNull="true" />
123      <Column Name="ZmianaEmisji" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
124      <Association Name="FAKTURY_PlatnosciEcard" Member="PlatnosciEcards" ThisKey="ID_FAKTURY" OtherKey="IDFaktury" Type="PlatnosciEcard" />
125      <Association Name="FAKTURY_FAKTURA_DETAIL" Member="FAKTURA_DETAILs" ThisKey="ID_FAKTURY" OtherKey="ID_FAKTURY" Type="FAKTURA_DETAIL" />
126      <Association Name="FAKTURY_vPlatnosciEcard" Member="Invoices" Storage="_vDanePlatnosciEcards" ThisKey="ID_FAKTURY" OtherKey="ID_faktury" Type="Invoice" />
127    </Type>
128  </Table>
129  <Table Name="dbo.vDanePlatnosciEcard" Member="Invoices">
130    <Type Name="Invoice">
131      <Column Name="ID_faktury" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
132      <Column Name="Numer" Type="System.Int32" DbType="Int" CanBeNull="true" />
133      <Column Name="Numer_Roz" Type="System.String" DbType="NVarChar(8)" CanBeNull="true" />
134      <Column Name="Numer_Rok" Type="System.Int32" DbType="Int" CanBeNull="true" />
135      <Column Name="SystemKsiegowyId" Type="System.Byte" DbType="TinyInt" CanBeNull="true" />
136      <Column Name="FirstName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
137      <Column Name="LastName" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
138      <Column Name="Address" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
139      <Column Name="PostalCode" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
140      <Column Name="City" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
141      <Column Name="nip" Type="System.String" DbType="NVarChar(4000)" CanBeNull="true" />
142      <Column Name="[Faktura Numer]" Member="Faktura_Numer" Type="System.String" DbType="NVarChar(70)" CanBeNull="true" />
143      <Column Name="Nabywca_nip" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
144      <Column Name="Brutto" Type="System.Decimal" DbType="Decimal(9,2)" CanBeNull="true" />
145      <Column Name="Data_Wystawienia" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
146      <Column Name="Termin_zaplaty" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
147      <Column Name="Sposob_zaplaty" Type="System.String" DbType="NVarChar(20)" CanBeNull="true" />
148      <Column Name="Imie" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
149      <Column Name="Nazwisko" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
150      <Column Name="ulica" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
151      <Column Name="kod" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
152      <Column Name="miasto" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
153      <Column Name="telefon" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
154      <Column Name="waluta_brutto" Type="System.Decimal" DbType="Decimal(9,2)" CanBeNull="true" />
155      <Column Name="waluta_miano" Type="System.String" DbType="NVarChar(4)" CanBeNull="true" />
156      <Association Name="FAKTURY_vPlatnosciEcard" Member="FAKTURY" ThisKey="ID_faktury" OtherKey="ID_FAKTURY" Type="FAKTURY" IsForeignKey="true" />
157    </Type>
158  </Table>
159</Database>
Notatka: Zobacz TracBrowser aby uzyskać więcej informacji.