Revision 7ab5a4f6
Von Udo Spallek vor fast 18 Jahren hinzugefügt
| sql/Leerer-Kontenrahmen-chart.sql | ||
|---|---|---|
| 1 |
-- changes on system tables |
|
| 2 |
-- TODO Make me Update2 |
|
| 3 |
|
|
| 4 |
-- Minimal COA |
|
| 1 |
-- Minimal Chart of Accounts |
|
| 5 | 2 |
|
| 6 | 3 |
INSERT INTO chart ( |
| 7 |
accno, description, charttype, category, link, |
|
| 8 |
gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, |
|
| 9 |
pos_eur, datevautomatik, new_chart_id, valid_from |
|
| 4 |
id, accno, description, charttype, category, |
|
| 5 |
|
|
| 6 |
link, -- create links to all forms as default |
|
| 7 |
|
|
| 8 |
gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz, |
|
| 9 |
pos_eur, datevautomatik, new_chart_id, valid_from |
|
| 10 |
|
|
| 10 | 11 |
) VALUES ( |
| 11 |
' ', 'Nicht zugeordnet' 'A', '', '', |
|
| 12 |
'', 0, 0, 0, 0, |
|
| 13 |
0, FALSE, 0, now() |
|
| 12 |
|
|
| 13 |
0, '0', 'Nicht zugeordnet', 'A', 'A', |
|
| 14 |
'AR:AP:IC:AR_amount:AR_paid:AP_amount:AP_paid:IC_sale:IC_cogs:IC_income:IC_expense', |
|
| 15 |
'', 0, 0 , 0, 0, |
|
| 16 |
0, FALSE, 0 , now() |
|
| 14 | 17 |
); |
| 15 | 18 |
|
| 16 |
-- Minimal Tax Konfiguration |
|
| 19 |
-- Minimal Tax-o-matic Configuration |
|
| 20 |
|
|
| 21 |
INSERT INTO tax ( |
|
| 22 |
id, chart_id, rate, taxnumber, taxkey, taxdescription |
|
| 23 |
) VALUES ( |
|
| 24 |
'0', '0', '0', '0', '0', 'ohne Steuerautomatik'); |
|
| 25 |
|
|
| 26 |
|
|
| 27 |
INSERT INTO taxkeys ( |
|
| 28 |
id, chart_id, tax_id, taxkey_id, pos_ustva, startdate |
|
| 29 |
) VALUES ( |
|
| 30 |
0, 0, 0, 0, 0, '1970-01-01' |
|
| 31 |
); |
|
| 32 |
|
|
| 33 |
DELETE FROM tax_zones; |
|
| 34 |
|
|
| 35 |
INSERT INTO tax_zones ( |
|
| 36 |
id, description |
|
| 37 |
) VALUES ( |
|
| 38 |
0, 'keiner' |
|
| 39 |
); |
|
| 40 |
|
|
| 41 |
|
|
| 42 |
-- Minimal buchungsgruppen |
|
| 43 |
INSERT INTO buchungsgruppen ( |
|
| 44 |
id, description, inventory_accno_id, |
|
| 45 |
income_accno_id_0, expense_accno_id_0, income_accno_id_1, |
|
| 46 |
expense_accno_id_1, income_accno_id_2, expense_accno_id_2, |
|
| 47 |
income_accno_id_3, expense_accno_id_3 |
|
| 48 |
) VALUES ( |
|
| 49 |
0, 'keine', 0, |
|
| 50 |
0, 0, 0, |
|
| 51 |
0, 0, 0, |
|
| 52 |
0, 0 |
|
| 53 |
); |
|
| 54 |
|
|
| 55 |
-- Minimal |
|
| 56 |
|
|
| 57 |
INSERT INTO customer ( |
|
| 58 |
id, name |
|
| 59 |
) VALUES ( 0, ' keiner'); |
|
| 60 |
|
|
| 61 |
INSERT INTO vendor ( |
|
| 62 |
id, name |
|
| 63 |
) VALUES ( 0, ' keiner'); |
|
| 64 |
|
|
| 65 |
|
|
| 66 |
|
|
| 67 |
-- Minimal defaults |
|
| 68 |
|
|
| 69 |
update defaults set |
|
| 70 |
inventory_accno_id = 0, |
|
| 71 |
income_accno_id = 0, |
|
| 72 |
expense_accno_id = 0, |
|
| 73 |
fxgain_accno_id = 0, |
|
| 74 |
fxloss_accno_id = 0, |
|
| 75 |
invnumber = '1', |
|
| 76 |
sonumber = '1', |
|
| 77 |
ponumber = '1', |
|
| 78 |
sqnumber = '1', |
|
| 79 |
rfqnumber = '1', |
|
| 80 |
customernumber = '1', |
|
| 81 |
vendornumber = '1', |
|
| 82 |
articlenumber = '1', |
|
| 83 |
servicenumber = '1', |
|
| 84 |
rmanumber = '1', |
|
| 85 |
cnnumber = '1', |
|
| 86 |
coa = 'Leerer-Kontenrahmen', |
|
| 87 |
curr = 'EUR:USD', |
|
| 88 |
weightunit = 'kg'; |
|
| 17 | 89 |
|
| 18 |
INSERT INTO tax |
|
| 19 |
(chart_id, rate, taxnumber, taxkey, taxdescription) |
|
| 20 |
VALUES ('0', '0', '0', '0', 'ohne Steuerautomatik');
|
|
| 90 |
|
|
Auch abrufbar als: Unified diff
Weitere Grundeinstellungen fuer leeren Kontenrahmen.