Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
INSERT INTO [dbo].[ForeignPayment] ([Code], [Value]) VALUES
(908, N'Zbo'),
(8, N'Ostatn transakce skupiny 1'),
(408, N'Doprava'),
(508, N'Cestovn ruch'),
(608, N'Stavebna montn prce'),
(708, N'Prvn,etnaporadensksluby'),
(188, N'Njemn'),
(388, N'Zahranindiplomatick zastoupenv R'),
(308, N'Reklama'),
(488, N'Ostatnsluby'),
(588, N'Vnosyz pmchportfoliovchinvestic'),
(888, N'rokyz portfoliovch investic'),
(808, N'Ostatn vnosy'),
(68, N'Pevody'),
(88, N'Jin pevody'),
(968, N'Transakce s finannmiaktivyve vztahu k zahrani'),
(288, N'Pm a portfoliov investice'),
(688, N'Portfoliov investice dluhov cenn papry'),
(598, N'Osobn transakce s finannmipasvy'),
(988, N'Nkup a prodejnemovitostv tuzemsku')
INSERT INTO [dbo].[Kind] ([Code], [Value]) VALUES
(0, N'Platby za zbo a sluby'),
(1, N'Vztahy ke sttnmu rozpotu a rozpotm mstnch samosprv'),
(2, N'Platby za dodvky investin povahy'),
(3, N'Mzdov a ostatn osobn nklady'),
(4, N'Vztahy ke sttnmu rozpotu a rozpotm mstnch samosprv'),
(5, N'Ostatn finann platby'),
(6, N'Pevody mezi ty tho klienta'),
(7, N'Pokladn pjmy'),
(8, N'Tda zruena'),
(9, N'Vztahy bank ke klientele (pouvaj jen banky)')
INSERT INTO [dbo].[LastNumber] ([Code], [Value]) VALUES
(0, N'Platby podle zvltnch dispozic bank'),
(1, N'Platby na podklad pravomocnho a vykonatelnho rozhodnut pslunho orgnu (pouvaj jen banky)'),
(2, N'vrovateln pepravn a vrovateln platby dodavatelm'),
(3, N'Skldn a vybrn hotovosti u jin banky'),
(4, N'Pednostn platby'),
(5, N'Opravn ztovn (pouvaj jen banky)'),
(6, N'Dobropisy(vratky) na platby bnho roku'),
(7, N'Dobropisy (vratky) na platby minulho roku'),
(8, N'Ostatn bezhotovostn platby'),
(9, N'Hotovostn platby')
INSERT INTO [dbo].[MinistryPredefined] ([Code], [Value]) VALUES
(11, N'Odvody pspvkovch organizac'),
(41, N'Odvody zvodnho stravovn'),
(91, N'Ostatn pevody souvisejc se SR'),
(131, N'Mstn poplatky'),
(151, N'Pevody prostedk elov urench na financovn program reprodukce majetku'),
(181, N'Pevody prostedk na ostatn (neinvestin) ely'),
(261, N'Pjmy od fyzickch osob'),
(271, N'Pjmy od prvnickch osob'),
(281, N'elov prostedky poskytnut ze sttnho rozpotu k vytovn'),
(301, N'Pjmy z vedlej hospodsk a doplkov innosti kol'),
(321, N'Pjmy z prodeje byt do osobnho vlastnictv oban'),
(361, N'Pokuty ukldan a vybran obcemi a kraji'),
(371, N'Sankn poplatky'),
(421, N'Pjmy plynouc z prodeje nemovitho majetku'),
(431, N'Ostatn a nahodil pjmy'),
(461, N'Pspvky pspvkovm organizacm na provoz'),
(491, N'Pspvky a dary mezinrodnm organizacm'),
(501, N'Dotace pspvkovm organizacm na investice'),
(531, N'Ostatn pspvky'),
(551, N'Dotace provozn'),
(561, N'Dotace na investice'),
(571, N'Ostatn platby v souvislosti se sttnm rozpotem'),
(641, N'Ostatn elov dotace ze sttnho rozpotu'),
(711, N'Dotace na investin vstavbu ze sttnch fond'),
(721, N'Dotace krajm a obcm'),
(751, N'Vztahy sttnho rozpotu k bance'),
(761, N'Dvky socilnho zabezpeen vetn specifickch dvek pslunk ozbrojench sil a bezpenostnch sbor a ostatn platby sociln povahy'),
(771, N'Sttn sociln podpora'),
(911, N'Finann vypodn vztah se sttnm rozpotem'),
(9617, N'Vratky pspvk na lensk podly v drustevn stabilizan bytov vstavb'),
(981, N'Mimodn odvody v prbhu roku'),
(991, N'elov prostedky ze sttnho rozpotu poskytnut z vldn rozpotov rezervy'),
(148, N'Platby dan z pjm (z rok) sren bankami'),
(114, N'Bn platby'),
(214, N'Platby domrk'),
(314, N'Platby psluenstv'),
(4146, N'Vratky ve prospch tu daovho subjektu, deklaranta, povinn osoby'),
(514, N'Pevod vyinkasovanch prostedk mezi ty sprvce dan'),
(614, N'Silnin da placen celnmu orgnu'),
(714, N'Sprvn poplatky placen celnmu orgnu'),
(814, N'Ostatn platby dan'),
(914, N'Sloen celn jistoty')
INSERT INTO [dbo].[ReservedSymbol] ([Code], [Value]) VALUES
(5, N'Opravn zatovn'),
(6, N'Neexistujc et'),
(51, N'Platby na zklad pravomocnho a vykonatelnho rozhodnut'),
(1178, N'Ztovn platbyplatebn kartou'),
(2178, N'Ztovn platby soukrommekem'),
(3178, N'Ztovn platby bankovnm ekem')
SET IDENTITY_INSERT [dbo].[AccountType] ON
INSERT INTO [dbo].[AccountType] ([ID], [Shortname], [Fullname]) VALUES (1, N'B', N'Bankovn et'),
(2, N'PNC', NULL),
(3, N'S', N'Spoc et'),
(4, N'KK', N'Kreditn karta'),
(5, N'PP', NULL)
SET IDENTITY_INSERT [dbo].[AccountType] OFF
SET IDENTITY_INSERT [dbo].[Account] ON
INSERT INTO [dbo].[Account] ([ID], [AccountPrefix], [AccountNumber], [BankCode], [AccountName], [Ballance], [AccountTypeID]) VALUES (1, NULL, 226258522, 300, NULL, CAST(0.00 AS Decimal(18, 2)), 5)
,(2, NULL, 241252428, 300, NULL, CAST(0.00 AS Decimal(18, 2)), 4)
,(3, NULL, 281698766, 300, NULL, CAST(0.00 AS Decimal(18, 2)), 2)
,(4, NULL, 272264579, 300, NULL, CAST(0.00 AS Decimal(18, 2)), 3)
,(5, NULL, 167559324, 300, NULL, CAST(0.00 AS Decimal(18, 2)), 1)
,(6, NULL, 1071005073, 5500, NULL, NULL, NULL)
,(7, 94211, 10820184, 8060, NULL, NULL, NULL)
,(8, NULL, 1547799113, 800, NULL, NULL, NULL)
,(9, NULL, 1557544173, 800, NULL, NULL, NULL)
,(10, NULL, 167559324, 300, NULL, NULL, NULL)
,(11, NULL, 1801141, 100, NULL, NULL, NULL)
,(12, NULL, 187078376, 300, NULL, NULL, NULL)
,(13, NULL, 188450301, 600, NULL, NULL, NULL)
,(14, NULL, 2108688838, 2700, NULL, NULL, NULL)
,(15, NULL, 212673266, 300, NULL, NULL, NULL)
,(16, NULL, 213031003, 2700, NULL, NULL, NULL)
,(17, 670100, 2201565859, 6210, NULL, NULL, NULL)
,(18, 670100, 2201748954, 6210, NULL, NULL, NULL)
,(19, NULL, 224261031, 600, NULL, NULL, NULL)
,(20, NULL, 226258522, 300, NULL, NULL, NULL)
,(21, NULL, 241252428, 300, NULL, NULL, NULL)
,(22, NULL, 2601389161, 2010, NULL, NULL, NULL)
,(23, NULL, 2701348025, 2010, NULL, NULL, NULL)
,(24, NULL, 272264579, 300, NULL, NULL, NULL)
,(25, NULL, 279502672, 300, NULL, NULL, NULL)
,(26, NULL, 281698766, 300, NULL, NULL, NULL)
,(27, NULL, 445544, 300, NULL, NULL, NULL)
,(28, 35, 461031379, 800, NULL, NULL, NULL)
,(29, 51, 5389560227, 100, NULL, NULL, NULL)
,(30, 115, 5891410267, 100, NULL, NULL, NULL)
,(31, NULL, 6557065570, 2010, NULL, NULL, NULL)
,(32, NULL, 700135002, 800, NULL, NULL, NULL)
,(33, 7755, 77628111, 710, NULL, NULL, NULL)
,(34, NULL, 7770227, 100, NULL, NULL, NULL)
,(35, NULL, 844844844, 300, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Account] OFF
SET IDENTITY_INSERT [dbo].[ConstantSymbol] ON
INSERT INTO [dbo].[ConstantSymbol] ([ID], [ProvidedID], [Valid], [DomesticPayment], [KindID], [LastNumberID], [MinistryPredefinedID], [ReservedSymbolID], [ForeignPaymentID]) VALUES (1, CAST(1178.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(2, CAST(3558.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(3, CAST(968.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(4, CAST(6898.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(5, CAST(898.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(6, CAST(308.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(7, CAST(1176.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(8, CAST(558.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
,(9, CAST(6178.00 AS Decimal(18, 2)), 0, 1, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[ConstantSymbol] OFF
SET IDENTITY_INSERT [dbo].[TransactionType] ON
INSERT INTO [dbo].[TransactionType] ([ID], [Description]) VALUES (1, N'Trval prkaz elektronicky cslo 840')
,(2, N'Spltka veru')
,(3, N'hrada poplatku z veru')
,(4, N'Spltka hypotky u Hypotecn banky')
,(5, N'Inkaso')
,(6, N'Odchoz hrada')
,(7, N'Spltka kreditn karty')
,(8, N'Prkaz el. bankovnictv k hrade do JP')
,(9, N'Za veden ctu, vpisy a transakce')
,(10, N'Trval prkaz elektronicky cslo 532')
,(11, N'Trval prkaz elektronicky cslo 1221')
,(12, N'Cerpn veru')
,(13, N'Dol platba')
,(14, N'Bezhotovostn prevod EB')
,(15, N'Trval prkaz elektronicky cslo 152')
,(16, N'Spltka spotrebitelskho veru')
,(17, N'Spltka hypotky')
,(18, N'Trval prkaz elektronicky cslo 1248')
,(19, N'Odchoz inkasn platba')
,(20, N'Cerpn veru platebn kartou')
,(21, N'Spltka kontokorentu')
,(22, N'Zctovn poplatku')
,(23, N'Prchoz hrada')
,(24, N'Bezhotovostn prevod el. bankovnictv')
,(25, N'Transakce platebn kartou')
,(26, N'Bezhotovostn prevod')
,(27, N'Nezpoplatnen prevod')
,(28, N'Poplatek-platebn karta')
,(29, N'Trval prkaz elektronicky cslo 247')
,(30, N'Zctovn kladnch roku')
,(31, N'Platba kartou za sluby Cesk poty')
,(32, N'Trval prkaz elektronicky cslo 939')
,(33, N'On-line platba')
SET IDENTITY_INSERT [dbo].[TransactionType] OFF
SET IDENTITY_INSERT [dbo].[Transactions] ON
INSERT INTO [dbo].[Transactions] ([ID], [ProvidedID], [Date], [Amount], [Note], [VariableSymbol], [SpecificSymbol], [ConstantSymbolID], [SenderAccountID], [RecipientAccountID], [TransactionTypeID], [SenderAccountBallance]) VALUES (1, N'7486352382', N'2018-11-24 00:00:00', CAST(-49.50 AS Decimal(18, 2)), N'Cstka: 99 CZK 21.11.2018, Msto: SODEXO - Pankrac, PRAHA', 205000326, 2104568889, 1, 5, NULL, 25, CAST(360.64 AS Decimal(18, 2)))
,(2, N'7486243679', N'2018-11-24 00:00:00', CAST(274.84 AS Decimal(18, 2)), N'', NULL, NULL, NULL, 5, 1, 12, CAST(410.14 AS Decimal(18, 2)))
,(3, N'7486243684', N'2018-11-24 00:00:00', CAST(-69.50 AS Decimal(18, 2)), N'Cstka: 139 CZK 20.11.2018, Msto: RESTAURACE OBEDERIA, PRAHA 4', 205000325, 2104568889, 1, 5, NULL, 25, CAST(135.30 AS Decimal(18, 2)))
,(4, N'7485209977', N'2018-11-24 00:00:00', CAST(-5000.00 AS Decimal(18, 2)), N'', NULL, NULL, NULL, 5, 1, 2, CAST(204.80 AS Decimal(18, 2)))
,(5, N'7485209978', N'2018-11-24 00:00:00', CAST(5000.00 AS Decimal(18, 2)), N'', NULL, NULL, NULL, 5, 4, 27, CAST(5204.80 AS Decimal(18, 2)))
Loading
Loading full blame...