kivitendo/sql/Leerer-Kontenrahmen-chart.sql @ 99158d6b
| 7ab5a4f6 | Udo Spallek | -- Minimal Chart of Accounts
|
||
| c8b11e54 | Udo Spallek | |||
INSERT INTO chart (
|
||||
| 7ab5a4f6 | Udo Spallek | id, accno, description, charttype, category,
|
||
link, -- create links to all forms as default
|
||||
gifi_accno, taxkey_id, pos_ustva, pos_bwa, pos_bilanz,
|
||||
pos_eur, datevautomatik, new_chart_id, valid_from
|
||||
| c8b11e54 | Udo Spallek | ) VALUES (
|
||
| 7ab5a4f6 | Udo Spallek | |||
0, '0', 'Nicht zugeordnet', 'A', 'A',
|
||||
'AR:AP:IC:AR_amount:AR_paid:AP_amount:AP_paid:IC_sale:IC_cogs:IC_income:IC_expense',
|
||||
'', 0, 0 , 0, 0,
|
||||
0, FALSE, 0 , now()
|
||||
| c8b11e54 | Udo Spallek | );
|
||
| 7ab5a4f6 | Udo Spallek | -- Minimal Tax-o-matic Configuration
|
||
INSERT INTO tax (
|
||||
id, chart_id, rate, taxnumber, taxkey, taxdescription
|
||||
) VALUES (
|
||||
'0', '0', '0', '0', '0', 'ohne Steuerautomatik');
|
||||
INSERT INTO taxkeys (
|
||||
id, chart_id, tax_id, taxkey_id, pos_ustva, startdate
|
||||
) VALUES (
|
||||
0, 0, 0, 0, 0, '1970-01-01'
|
||||
);
|
||||
DELETE FROM tax_zones;
|
||||
INSERT INTO tax_zones (
|
||||
id, description
|
||||
) VALUES (
|
||||
0, 'keiner'
|
||||
);
|
||||
-- Minimal buchungsgruppen
|
||||
INSERT INTO buchungsgruppen (
|
||||
id, description, inventory_accno_id,
|
||||
income_accno_id_0, expense_accno_id_0, income_accno_id_1,
|
||||
expense_accno_id_1, income_accno_id_2, expense_accno_id_2,
|
||||
income_accno_id_3, expense_accno_id_3
|
||||
) VALUES (
|
||||
0, 'keine', 0,
|
||||
0, 0, 0,
|
||||
0, 0, 0,
|
||||
0, 0
|
||||
);
|
||||
-- Minimal
|
||||
INSERT INTO customer (
|
||||
id, name
|
||||
) VALUES ( 0, ' keiner');
|
||||
INSERT INTO vendor (
|
||||
id, name
|
||||
) VALUES ( 0, ' keiner');
|
||||
-- Minimal defaults
|
||||
update defaults set
|
||||
inventory_accno_id = 0,
|
||||
income_accno_id = 0,
|
||||
expense_accno_id = 0,
|
||||
fxgain_accno_id = 0,
|
||||
fxloss_accno_id = 0,
|
||||
invnumber = '1',
|
||||
sonumber = '1',
|
||||
ponumber = '1',
|
||||
sqnumber = '1',
|
||||
rfqnumber = '1',
|
||||
customernumber = '1',
|
||||
vendornumber = '1',
|
||||
articlenumber = '1',
|
||||
servicenumber = '1',
|
||||
rmanumber = '1',
|
||||
cnnumber = '1',
|
||||
coa = 'Leerer-Kontenrahmen',
|
||||
curr = 'EUR:USD',
|
||||
weightunit = 'kg';
|
||||
| c8b11e54 | Udo Spallek | |||
| 7ab5a4f6 | Udo Spallek |