Dany De Bontridder wrote:
On Thursday 07 July 2005 10:44, Stan Pinte wrote:
super faisons des essais...envoie moi ton SQL.
Done :-)
corrigé ton SQL:
INSERT INTO formdef (fr_id, fr_label) VALUES (30000, 'TVA déclaration');
--
-- Data for TOC entry 2 (OID 315304)
-- Name: formdef; Type: TABLE DATA; Schema: public; Owner: dany
--
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100170, 30000, 1, 'Prestation [ case 03 ]', '[700%]-[7000005]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100171, 30000, 2, 'Prestation intra [ case 47 ]', '[7000005]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100172, 30000, 3, 'Tva due à 6 % [case 54]', '[4513] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100173, 30000, 4, 'Tva due a 12% [case 54]', '[4512] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100174, 30000, 5, 'Tva due a 21% [case 54]', '[4511] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100175, 30000, 6, 'Exempté intracomm [case 47]', '[4514] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100176, 30000, 7, 'Service et bien divers [case 82]', '[61%]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100177, 30000, 8, 'bien d''invest [ case 83 ]', '[2400%]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100178, 30000, 9, 'TVA déductible [ case 59 ]', 'abs([4117]-[411%])');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100179, 30000, 10, '(TVA non ded -> voiture) Total frais voiture (faire
* 0.21/2) et le soustraire', '[610022]*0.21/2');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES
(100180, 30000, 11, 'Acompte TVA', '[4117]');
_______________________________________________
Phpcompta-contrib mailing list
[email protected]
http://lists.nongnu.org/mailman/listinfo/phpcompta-contrib
