From: Mitterwald, H. <mit...@co...> - 2001-02-16 11:59:44
|
Once upon a time.... ok, I like to get sql-ledger really usable in germany. There are some chart of accounts (Kontenrahmen) around here that rather everybody should use. I up to now know the "Industriekontenrahmen" and saw the one from Datev. As Datev is rather commonly used I like to convert it to the sql-ledger structure. The datev chart of accounts has a "kontoart" that I think equals to the category in sql-ledger. I sorted and counted them (well, my database did it :-) ) These are the categories up to now: art | count | ledger-category --------------------------------+-------+----------------- Kursaufwand | 1 | Kursertrag | 1 | Summenvortrag | 1 | Kassenkonto | 3 | Q Erl=F6sschm=E4lerung | 9 | Aufwandsschm=E4lerung | 9 | Saldovortrag | 17 | Finanzkonto | 29 | Einkauf | 47 | L Eigenkapital | 58 | Q Neutrale Aufwendungen | 71 | Statistikkonto (Bestandsgr=F6=DFe) | 73 | Neutrale Erl=F6se | 80 | Verkauf | 94 | I Fremdkapital | 96 | L Anlageverm=F6gen | 100 | A Sonstiges Bilanzkonto | 108 | Umlaufverm=F6gen | 137 | A? (if A means "Bestand") Kosten | 146 | E categories in sql-ledger A ... Asset (Anlage, Bestand?) L ... Liability (Verpflichtungen) Q ... Equity (Eigenkapital) I ... Income (Einkommen?, Ertrag(=3DGewinn)?) E ... Expense (Kosten) Comments, extensions, etc? I am not really shure if I have to assign the categories to each konto individually. But as I still remember the "Kontenarten" are of the same Type here. Best regards, Holger |