Revision 2e1e2d4c
Von Udo Spallek vor mehr als 18 Jahren hinzugefügt
| sql/Germany-DATEV-SKR03EU-chart.sql | ||
|---|---|---|
| 388 | 388 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.07','1772','12','Steuerpflicht. EG-Lieferungen 7%'); |
| 389 | 389 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1772'),'0.16','1773','13','Steuerpflicht. EG-Lieferungen 16%'); |
| 390 | 390 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.07','1572','18','Steuerpflicht. EG-Erwerb 7%'); |
| 391 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.16','1573','19','Steuerpflicht. EG-Erwerb 16%'); |
|
| 391 |
insert into tax (chart_id,rate,taxnumber, taxkey, taxdescription) values ((select id from chart where accno = '1572'),'0.16','1573','19','Steuerpflicht. EG-Erwerb 16%'); |
|
| 392 |
|
|
| 393 |
-- UStVA Link to SKR03/2006 |
|
| 394 |
-- Let this structure like it is, please. |
|
| 395 |
-- This structure is based on the sequence of the USTVA 2006 |
|
| 396 |
-- Created by Udo Spallek |
|
| 397 |
-- |
|
| 398 |
-- 1. Page UStVA |
|
| 399 |
|
|
| 400 |
UPDATE chart SET pos_ustva=41 WHERE accno IN ('8125', '8130', '8140', '8724', '8808', '8828');
|
|
| 401 |
UPDATE chart SET pos_ustva=44 WHERE accno IN ('8135');
|
|
| 402 |
UPDATE chart SET pos_ustva=49 WHERE accno IN ('');
|
|
| 403 |
UPDATE chart SET pos_ustva=43 WHERE accno IN ('2402', '8120', '8150', '8505', '8625', '8705', '8807', '8827');
|
|
| 404 |
UPDATE chart SET pos_ustva=48 WHERE accno IN ('8100', '8110', '8504', '8609');
|
|
| 405 |
UPDATE chart SET pos_ustva=51 WHERE accno IN ('1717', '2404', '2405', '2700', '2705', '2707', '2709', '8196', '8315', '8400', '8595', '8600', '8611', '8640', '8720', '8726', '8735', '8760', '8790', '8801', '8809', '8820', '8910', '8920', '8921', '8922', '8925', '8935', '8940');
|
|
| 406 |
UPDATE chart SET pos_ustva=511 WHERE accno IN ('1775');
|
|
| 407 |
UPDATE chart SET pos_ustva=86 WHERE accno IN ('1711', '2401', '2403', '8300', '8310', '8506', '8591', '8630', '8710', '8725', '8731', '8750', '8780', '8915', '8930', '8932', '8945');
|
|
| 408 |
UPDATE chart SET pos_ustva=861 WHERE accno IN ('1771');
|
|
| 409 |
UPDATE chart SET pos_ustva=35 WHERE accno IN ('2407', '2409', '8723', '8729', '8736', '8764', '8794');
|
|
| 410 |
UPDATE chart SET pos_ustva=36 WHERE accno IN ('');
|
|
| 411 |
UPDATE chart SET pos_ustva=77 WHERE accno IN ('');
|
|
| 412 |
UPDATE chart SET pos_ustva=76 WHERE accno IN ('8190');
|
|
| 413 |
UPDATE chart SET pos_ustva=80 WHERE accno IN ('');
|
|
| 414 |
UPDATE chart SET pos_ustva=91 WHERE accno IN ('');
|
|
| 415 |
UPDATE chart SET pos_ustva=97 WHERE accno IN ('3425', '3725');
|
|
| 416 |
UPDATE chart SET pos_ustva=971 WHERE accno IN ('1773');
|
|
| 417 |
UPDATE chart SET pos_ustva=93 WHERE accno IN ('3420', '3724');
|
|
| 418 |
UPDATE chart SET pos_ustva=931 WHERE accno IN ('1772');
|
|
| 419 |
UPDATE chart SET pos_ustva=95 WHERE accno IN ('3727');
|
|
| 420 |
UPDATE chart SET pos_ustva=98 WHERE accno IN ('');
|
|
| 421 |
UPDATE chart SET pos_ustva=94 WHERE accno IN ('');
|
|
| 422 |
UPDATE chart SET pos_ustva=96 WHERE accno IN ('1784');
|
|
| 423 |
UPDATE chart SET pos_ustva=42 WHERE accno IN ('');
|
|
| 424 |
UPDATE chart SET pos_ustva=60 WHERE accno IN ('8337');
|
|
| 425 |
UPDATE chart SET pos_ustva=45 WHERE accno IN ('8338', '8339', '8950');
|
|
| 426 |
-- 2. Seite UStVA |
|
| 427 |
UPDATE chart SET pos_ustva=52 WHERE accno IN ('');
|
|
| 428 |
UPDATE chart SET pos_ustva=53 WHERE accno IN ('');
|
|
| 429 |
UPDATE chart SET pos_ustva=73 WHERE accno IN ('');
|
|
| 430 |
UPDATE chart SET pos_ustva=74 WHERE accno IN ('');
|
|
| 431 |
UPDATE chart SET pos_ustva=84 WHERE accno IN ('3110', '3115', '3120', '3125');
|
|
| 432 |
UPDATE chart SET pos_ustva=85 WHERE accno IN ('1785', '1786');
|
|
| 433 |
UPDATE chart SET pos_ustva=65 WHERE accno IN ('1782');
|
|
| 434 |
UPDATE chart SET pos_ustva=66 WHERE accno IN ('1570', '1571', '1575', '1576');
|
|
| 435 |
UPDATE chart SET pos_ustva=61 WHERE accno IN ('1572', '1573');
|
|
| 436 |
UPDATE chart SET pos_ustva=62 WHERE accno IN ('1588');
|
|
| 437 |
UPDATE chart SET pos_ustva=67 WHERE accno IN ('1578', '1579');
|
|
| 438 |
UPDATE chart SET pos_ustva=63 WHERE accno IN ('1577');
|
|
| 439 |
UPDATE chart SET pos_ustva=64 WHERE accno IN ('1556', '1557', '1558', '1559');
|
|
| 440 |
UPDATE chart SET pos_ustva=59 WHERE accno IN ('');
|
|
| 441 |
UPDATE chart SET pos_ustva=69 WHERE accno IN ('1783');
|
|
| 442 |
UPDATE chart SET pos_ustva=39 WHERE accno IN ('1781');
|
|
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 252 | 252 |
alter table invoice add column transdate text; |
| 253 | 253 |
alter table invoice add column cusordnumber text; |
| 254 | 254 |
-- |
| 255 |
-- UStVA Link to SKR03/2006 |
|
| 256 |
-- Let this structure like it is, please. |
|
| 257 |
-- This structure is based on the sequence of the USTVA 2006 |
|
| 258 |
-- Created by Udo Spallek |
|
| 259 |
-- |
|
| 260 |
-- 1. Page UStVA |
|
| 261 |
UPDATE chart SET pos_ustva=41 WHERE accno IN ('8125', '8130', '8140', '8724', '8808', '8828');
|
|
| 262 |
UPDATE chart SET pos_ustva=44 WHERE accno IN ('8135');
|
|
| 263 |
UPDATE chart SET pos_ustva=49 WHERE accno IN ('');
|
|
| 264 |
UPDATE chart SET pos_ustva=43 WHERE accno IN ('2402', '8120', '8150', '8505', '8625', '8705', '8807', '8827');
|
|
| 265 |
UPDATE chart SET pos_ustva=48 WHERE accno IN ('8100', '8110', '8504', '8609');
|
|
| 266 |
UPDATE chart SET pos_ustva=51 WHERE accno IN ('1717', '2404', '2405', '2700', '2705', '2707', '2709', '8196', '8315', '8400', '8595', '8600', '8611', '8640', '8720', '8726', '8735', '8760', '8790', '8801', '8809', '8820', '8910', '8920', '8921', '8922', '8925', '8935', '8940');
|
|
| 267 |
UPDATE chart SET pos_ustva=511 WHERE accno IN ('1775');
|
|
| 268 |
UPDATE chart SET pos_ustva=86 WHERE accno IN ('1711', '2401', '2403', '8300', '8310', '8506', '8591', '8630', '8710', '8725', '8731', '8750', '8780', '8915', '8930', '8932', '8945');
|
|
| 269 |
UPDATE chart SET pos_ustva=861 WHERE accno IN ('1771');
|
|
| 270 |
UPDATE chart SET pos_ustva=35 WHERE accno IN ('2407', '2409', '8723', '8729', '8736', '8764', '8794');
|
|
| 271 |
UPDATE chart SET pos_ustva=36 WHERE accno IN ('');
|
|
| 272 |
UPDATE chart SET pos_ustva=77 WHERE accno IN ('');
|
|
| 273 |
UPDATE chart SET pos_ustva=76 WHERE accno IN ('8190');
|
|
| 274 |
UPDATE chart SET pos_ustva=80 WHERE accno IN ('');
|
|
| 275 |
UPDATE chart SET pos_ustva=91 WHERE accno IN ('');
|
|
| 276 |
UPDATE chart SET pos_ustva=97 WHERE accno IN ('3425', '3725');
|
|
| 277 |
UPDATE chart SET pos_ustva=971 WHERE accno IN ('1773');
|
|
| 278 |
UPDATE chart SET pos_ustva=93 WHERE accno IN ('3420', '3724');
|
|
| 279 |
UPDATE chart SET pos_ustva=931 WHERE accno IN ('1772');
|
|
| 280 |
UPDATE chart SET pos_ustva=95 WHERE accno IN ('3727');
|
|
| 281 |
UPDATE chart SET pos_ustva=98 WHERE accno IN ('');
|
|
| 282 |
UPDATE chart SET pos_ustva=94 WHERE accno IN ('');
|
|
| 283 |
UPDATE chart SET pos_ustva=96 WHERE accno IN ('1784');
|
|
| 284 |
UPDATE chart SET pos_ustva=42 WHERE accno IN ('');
|
|
| 285 |
UPDATE chart SET pos_ustva=60 WHERE accno IN ('8337');
|
|
| 286 |
UPDATE chart SET pos_ustva=45 WHERE accno IN ('8338', '8339', '8950');
|
|
| 287 |
-- 2. Page UStVA |
|
| 288 |
UPDATE chart SET pos_ustva=52 WHERE accno IN ('');
|
|
| 289 |
UPDATE chart SET pos_ustva=53 WHERE accno IN ('');
|
|
| 290 |
UPDATE chart SET pos_ustva=73 WHERE accno IN ('');
|
|
| 291 |
UPDATE chart SET pos_ustva=74 WHERE accno IN ('');
|
|
| 292 |
UPDATE chart SET pos_ustva=84 WHERE accno IN ('3110', '3115', '3120', '3125');
|
|
| 293 |
UPDATE chart SET pos_ustva=85 WHERE accno IN ('1785', '1786');
|
|
| 294 |
UPDATE chart SET pos_ustva=65 WHERE accno IN ('1782');
|
|
| 295 |
UPDATE chart SET pos_ustva=66 WHERE accno IN ('1570', '1571', '1575', '1576');
|
|
| 296 |
UPDATE chart SET pos_ustva=61 WHERE accno IN ('1572', '1573');
|
|
| 297 |
UPDATE chart SET pos_ustva=62 WHERE accno IN ('1588');
|
|
| 298 |
UPDATE chart SET pos_ustva=67 WHERE accno IN ('1578', '1579');
|
|
| 299 |
UPDATE chart SET pos_ustva=63 WHERE accno IN ('1577');
|
|
| 300 |
UPDATE chart SET pos_ustva=64 WHERE accno IN ('1556', '1557', '1558', '1559');
|
|
| 301 |
UPDATE chart SET pos_ustva=59 WHERE accno IN ('');
|
|
| 302 |
UPDATE chart SET pos_ustva=69 WHERE accno IN ('1783');
|
|
| 303 |
UPDATE chart SET pos_ustva=39 WHERE accno IN ('1781');
|
|
| 304 |
-- |
|
| 255 | 305 |
|
| 256 | 306 |
update defaults set version = '2.1.2'; |
| 307 |
|
|
| 308 |
|
|
| sql/liste.sql | ||
|---|---|---|
| 373 | 373 |
UPDATE chart set taxkey_id=0, pos_bwa=35 WHERE accno='2215'; |
| 374 | 374 |
UPDATE chart set taxkey_id=0, pos_bwa=35 WHERE accno='2218'; |
| 375 | 375 |
|
| 376 |
-- UStVA Link to SKR03/2006 |
|
| 377 |
-- Let this structure like it is, please. |
|
| 378 |
-- This structure is based on the sequence of the USTVA 2006 |
|
| 379 |
-- The old statements above, will be mixed in the next version |
|
| 380 |
-- Created by Udo Spallek |
|
| 381 |
-- |
|
| 382 |
-- 1. Page UStVA |
|
| 376 | 383 |
|
| 377 |
|
|
| 378 |
|
|
| 384 |
UPDATE chart SET pos_ustva=41 WHERE accno IN ('8125', '8130', '8140', '8724', '8808', '8828');
|
|
| 385 |
UPDATE chart SET pos_ustva=44 WHERE accno IN ('8135');
|
|
| 386 |
UPDATE chart SET pos_ustva=49 WHERE accno IN ('');
|
|
| 387 |
UPDATE chart SET pos_ustva=43 WHERE accno IN ('2402', '8120', '8150', '8505', '8625', '8705', '8807', '8827');
|
|
| 388 |
UPDATE chart SET pos_ustva=48 WHERE accno IN ('8100', '8110', '8504', '8609');
|
|
| 389 |
UPDATE chart SET pos_ustva=51 WHERE accno IN ('1717', '2404', '2405', '2700', '2705', '2707', '2709', '8196', '8315', '8400', '8595', '8600', '8611', '8640', '8720', '8726', '8735', '8760', '8790', '8801', '8809', '8820', '8910', '8920', '8921', '8922', '8925', '8935', '8940');
|
|
| 390 |
UPDATE chart SET pos_ustva=511 WHERE accno IN ('1775');
|
|
| 391 |
UPDATE chart SET pos_ustva=86 WHERE accno IN ('1711', '2401', '2403', '8300', '8310', '8506', '8591', '8630', '8710', '8725', '8731', '8750', '8780', '8915', '8930', '8932', '8945');
|
|
| 392 |
UPDATE chart SET pos_ustva=861 WHERE accno IN ('1771');
|
|
| 393 |
UPDATE chart SET pos_ustva=35 WHERE accno IN ('2407', '2409', '8723', '8729', '8736', '8764', '8794');
|
|
| 394 |
UPDATE chart SET pos_ustva=36 WHERE accno IN ('');
|
|
| 395 |
UPDATE chart SET pos_ustva=77 WHERE accno IN ('');
|
|
| 396 |
UPDATE chart SET pos_ustva=76 WHERE accno IN ('8190');
|
|
| 397 |
UPDATE chart SET pos_ustva=80 WHERE accno IN ('');
|
|
| 398 |
UPDATE chart SET pos_ustva=91 WHERE accno IN ('');
|
|
| 399 |
UPDATE chart SET pos_ustva=97 WHERE accno IN ('3425', '3725');
|
|
| 400 |
UPDATE chart SET pos_ustva=971 WHERE accno IN ('1773');
|
|
| 401 |
UPDATE chart SET pos_ustva=93 WHERE accno IN ('3420', '3724');
|
|
| 402 |
UPDATE chart SET pos_ustva=931 WHERE accno IN ('1772');
|
|
| 403 |
UPDATE chart SET pos_ustva=95 WHERE accno IN ('3727');
|
|
| 404 |
UPDATE chart SET pos_ustva=98 WHERE accno IN ('');
|
|
| 405 |
UPDATE chart SET pos_ustva=94 WHERE accno IN ('');
|
|
| 406 |
UPDATE chart SET pos_ustva=96 WHERE accno IN ('1784');
|
|
| 407 |
UPDATE chart SET pos_ustva=42 WHERE accno IN ('');
|
|
| 408 |
UPDATE chart SET pos_ustva=60 WHERE accno IN ('8337');
|
|
| 409 |
UPDATE chart SET pos_ustva=45 WHERE accno IN ('8338', '8339', '8950');
|
|
| 410 |
-- 2. Seite UStVA |
|
| 411 |
UPDATE chart SET pos_ustva=52 WHERE accno IN ('');
|
|
| 412 |
UPDATE chart SET pos_ustva=53 WHERE accno IN ('');
|
|
| 413 |
UPDATE chart SET pos_ustva=73 WHERE accno IN ('');
|
|
| 414 |
UPDATE chart SET pos_ustva=74 WHERE accno IN ('');
|
|
| 415 |
UPDATE chart SET pos_ustva=84 WHERE accno IN ('3110', '3115', '3120', '3125');
|
|
| 416 |
UPDATE chart SET pos_ustva=85 WHERE accno IN ('1785', '1786');
|
|
| 417 |
UPDATE chart SET pos_ustva=65 WHERE accno IN ('1782');
|
|
| 418 |
UPDATE chart SET pos_ustva=66 WHERE accno IN ('1570', '1571', '1575', '1576');
|
|
| 419 |
UPDATE chart SET pos_ustva=61 WHERE accno IN ('1572', '1573');
|
|
| 420 |
UPDATE chart SET pos_ustva=62 WHERE accno IN ('1588');
|
|
| 421 |
UPDATE chart SET pos_ustva=67 WHERE accno IN ('1578', '1579');
|
|
| 422 |
UPDATE chart SET pos_ustva=63 WHERE accno IN ('1577');
|
|
| 423 |
UPDATE chart SET pos_ustva=64 WHERE accno IN ('1556', '1557', '1558', '1559');
|
|
| 424 |
UPDATE chart SET pos_ustva=59 WHERE accno IN ('');
|
|
| 425 |
UPDATE chart SET pos_ustva=69 WHERE accno IN ('1783');
|
|
| 426 |
UPDATE chart SET pos_ustva=39 WHERE accno IN ('1781');
|
|
Auch abrufbar als: Unified diff
Bug 262 fixed!
USTVA UPDATE der Positionen und Verknuepfungen.
Die UPDATEs sind relativ vollstaendig und sortiert,
so dass eine weitere Pflege einfach ist. taxkey's sind noch nicht
integriert, deshalb sind einige updates in liste.aql doppelt gemoppelt,
was m.E. unproblematisch ist, gleiches gilt für
den Germany-DATEV-SKR03EU-chart.sql