[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue-luca] r21 - in trunk: . bin etc modules modules/base modules/finan
From: |
reinhard |
Subject: |
[gnue-luca] r21 - in trunk: . bin etc modules modules/base modules/finance |
Date: |
Thu, 28 Jul 2005 01:12:54 -0500 (CDT) |
Author: reinhard
Date: 2005-07-28 01:12:51 -0500 (Thu, 28 Jul 2005)
New Revision: 21
Added:
trunk/bin/
trunk/bin/form-acc
trunk/bin/load-demo
trunk/bin/server
trunk/bin/setupdb
trunk/etc/
trunk/etc/connections.conf
trunk/modules/
trunk/modules/base/
trunk/modules/finance/
trunk/modules/finance/test.gsd
Removed:
trunk/base/
trunk/finance/
Modified:
trunk/
trunk/modules/base/demo.gsd
trunk/modules/finance/acc-main.gfd
trunk/modules/finance/gl.gcd
trunk/modules/finance/sample.gsd
Log:
Restructured directory tree, created a few helper scripts, created own
connections.conf to run luca self-contained, started to create separate
classes for transaction entry (gl_batch, gl_batchitem).
Property changes on: trunk
___________________________________________________________________
Name: svn:ignore
+ luca.db*
Added: trunk/bin/form-acc
===================================================================
--- trunk/bin/form-acc 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/bin/form-acc 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+# Prefer CVS versions if available
+if [ "`type -t gcvs`" == "file" ]; then
+ gnue_forms="gfcvs"
+else
+ gnue_forms="gnue-forms"
+fi
+
+${gnue_forms} --connections=etc/connections.conf \
+ $* \
+ modules/finance/acc-main.gfd
Property changes on: trunk/bin/form-acc
___________________________________________________________________
Name: svn:executable
+ *
Added: trunk/bin/load-demo
===================================================================
--- trunk/bin/load-demo 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/bin/load-demo 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+# Prefer CVS versions if available
+if [ "`type -t gcvs`" == "file" ]; then
+ gnue_schema="gsscvs"
+else
+ gnue_schema="gnue-schema"
+fi
+
+${gnue_schema} --connections=etc/connections.conf \
+ --connection=gnue \
+ `find modules -name "*.gsd"`
Property changes on: trunk/bin/load-demo
___________________________________________________________________
Name: svn:executable
+ *
Added: trunk/bin/server
===================================================================
--- trunk/bin/server 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/bin/server 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,14 @@
+#!/bin/sh
+
+# Prefer CVS versions if available
+if [ "`type -t gcvs`" == "file" ]; then
+ gnue_appserver="gacvs"
+else
+ gnue_appserver="gnue-appserver"
+fi
+
+${gnue_appserver} --connections=etc/connections.conf \
+ --connection=gnue \
+ --modulepath=modules \
+ --no-detach \
+ $*
Property changes on: trunk/bin/server
___________________________________________________________________
Name: svn:executable
+ *
Added: trunk/bin/setupdb
===================================================================
--- trunk/bin/setupdb 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/bin/setupdb 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,17 @@
+#!/bin/sh
+
+# Prefer CVS versions if available
+if [ "`type -t gcvs`" == "file" ]; then
+ python="gcvs"
+ gnue_schema="gsscvs"
+else
+ python="python"
+ gnue_schema="gnue-schema"
+fi
+
+DATADIR=`echo -e "import gnue.paths\nprint gnue.paths.data" | ${python}`
+
+${gnue_schema} --connections=etc/connections.conf \
+ --connection=gnue \
+ --createdb \
+ "${DATADIR}/share/gnue/appserver/gnue.gsd"
Property changes on: trunk/bin/setupdb
___________________________________________________________________
Name: svn:executable
+ *
Added: trunk/etc/connections.conf
===================================================================
--- trunk/etc/connections.conf 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/etc/connections.conf 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,16 @@
+# Connection definitions for GNUe-Luca
+
+[gnue]
+comment = GNUe-Luca Test Database
+provider = sqlite2
+dbname = ./luca.db
+
+[appserver]
+comment = GNUe-Luca Server
+provider = appserver
+rpctype = xmlrpc
+host = localhost
+port = 8765
+transport = http
+base_company = demoa
+gl_year = 2005
Copied: trunk/modules/base (from rev 20, trunk/base)
Modified: trunk/modules/base/demo.gsd
===================================================================
--- trunk/base/demo.gsd 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/modules/base/demo.gsd 2005-07-28 06:12:51 UTC (rev 21)
@@ -2,15 +2,6 @@
<schema author="gnue-gsdgen" title="Appserver Data Dump" version="1.0">
<data>
<tabledata name="base_company_dump" tablename="base_company">
- <definition>
- <column field="base_code" type="string(8)"/>
- <column field="base_name" type="string(35)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_code">demoa</value>
@@ -24,19 +15,6 @@
</rows>
</tabledata>
<tabledata name="base_currency_dump" tablename="base_currency">
- <definition>
- <column field="base_code" type="string(8)"/>
- <column field="base_company" type="string(32)"/>
- <column field="base_convbase" type="number(14.2)"/>
- <column field="base_convthis" type="number(14.2)"/>
- <column field="base_name" type="string(35)"/>
- <column field="base_roundunit" type="number(14.2)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_code">EUR</value>
@@ -80,15 +58,6 @@
</rows>
</tabledata>
<tabledata name="base_parameters_dump" tablename="base_parameters">
- <definition>
- <column field="base_company" type="string(32)"/>
- <column field="base_currency" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_company">91094290434119931310213246688146</value>
Copied: trunk/modules/finance (from rev 20, trunk/finance)
Modified: trunk/modules/finance/acc-main.gfd
===================================================================
--- trunk/finance/acc-main.gfd 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/modules/finance/acc-main.gfd 2005-07-28 06:12:51 UTC (rev 21)
@@ -36,32 +36,22 @@
table="gl_period"
prequery="Y">
<condition>
- <eq><cfield name="gl_active" /><cconst value="True" /></eq>
+ <eq><cfield name="gl_active" /><cconst value="1" /></eq>
</condition>
</datasource>
<datasource name="dtsPeriod" connection="appserver" table="gl_period" />
- <datasource name="dtsJournal" connection="appserver" table="gl_journal"
+ <datasource name="dtsBatch" connection="appserver" table="gl_batch"
master="dtsPeriod" masterlink="gnue_id" detaillink="gl_period">
- <condition>
- <null><cfield name="gl_posted" /></null>
- </condition>
</datasource>
- <datasource name="dtsTrans" connection="appserver" table="gl_trans"
- master="dtsJournal" masterlink="gnue_id" detaillink="gl_journal">
+ <datasource name="dtsBatchitem" connection="appserver" table="gl_batchitem"
+ master="dtsBatch" masterlink="gnue_id" detaillink="gl_batch">
<sortorder>
<sortfield name="gl_serial" />
</sortorder>
</datasource>
- <datasource name="dtsEntry" connection="appserver" table="gl_entry"
- master="dtsTrans" masterlink="gnue_id" detaillink="gl_trans">
- <sortorder>
- <sortfield name="gl_serial" />
- </sortorder>
- </datasource>
-
<logic>
<block name="blk">
<field name="fldPeriod" fk_source="dtsPeriodDropdown" fk_key="gnue_id"
@@ -70,32 +60,35 @@
<![CDATA[
# FIXME: This is necessary because a dropdown-source (without
# block) cannot be a master.
- dtsPeriod.createResultSet ({'gnue_id': blk.fldPeriod.get()})
- # Most of the time, the user will want to continue to enter
- # transactions at the end of the journal
- blkTrans.lastRecord ()
- if not blkTrans.isEmpty ():
- blkTrans.newRecord ()
+ period_id = blk.fldPeriod.get ()
+ if period_id and (period_id != blkPeriod.fldId):
+ dtsPeriod.createResultSet ({'gnue_id': period_id}, readOnly =
True, query = True)
+ # Most of the time, the user will want to continue to enter
+ # transactions at the end of the batch
+ blkBatchitem.lastRecord ()
+ if not blkBatchitem.isEmpty ():
+ blkBatchitem.newRecord ()
+ setFocus (blkBatchitem.fldDoctype)
]]>
</trigger>
</field>
</block>
- <block name="blkPeriod" datasource="dtsPeriod" />
+ <block name="blkPeriod" datasource="dtsPeriod">
+ <field name="fldId" field="gnue_id" />
+ </block>
- <block name="blkJournal" datasource="dtsJournal">
+ <block name="blkBatch" datasource="dtsBatch">
<field name="fldSerial" field="gl_serial" />
</block>
- <block name="blkTrans" datasource="dtsTrans" rows="10"
+ <block name="blkBatchitem" datasource="dtsBatchitem" rows="10"
autoCommit="True" autoNextRecord="True">
<field name="fldDoctype" fk_source="dtsDoctypeDropdown" fk_key="gnue_id"
fk_description="gl_code" />
<field name="fldNumber" field="gl_number" typecast="number" />
<field name="fldDate" field="gl_date" typecast="date" />
</block>
-
- <!-- <block name="blkEntry" datasource="dtsEntry" /> -->
</logic>
<layout xmlns:Char="GNUe:Layout:Char" Char:height="20" Char:width="80">
@@ -105,11 +98,11 @@
<entry name="entPeriod"
Char:height="1" Char:width="17" Char:x="10" Char:y="1"
block="blk" field="fldPeriod" style="dropdown" />
- <label text="Journal:"
+ <label text="Batch:"
Char:height="1" Char:width="8" Char:x="29" Char:y="1" />
- <entry name="entJournal"
+ <entry name="entBatch"
Char:height="1" Char:width="17" Char:x="38" Char:y="1"
- block="blkJournal" field="fldSerial" style="label" />
+ block="blkBatch" field="fldSerial" style="label" />
<label text="Document:"
Char:height="1" Char:width="9" Char:x="1" Char:y="3" />
@@ -117,13 +110,13 @@
Char:height="1" Char:width="5" Char:x="28" Char:y="3" />
<entry name="entDoctype"
Char:height="1" Char:width="8" Char:x="1" Char:y="4"
- block="blkTrans" field="fldDoctype" style="dropdown" />
+ block="blkBatchitem" field="fldDoctype" style="dropdown" />
<entry name="entNumber"
Char:height="1" Char:width="17" Char:x="10" Char:y="4"
- block="blkTrans" field="fldNumber" />
+ block="blkBatchitem" field="fldNumber" />
<entry name="entDate"
Char:height="1" Char:width="10" Char:x="28" Char:y="4"
- block="blkTrans" field="fldDate" displaymask="%x" inputmask="%x"/>
+ block="blkBatchitem" field="fldDate" displaymask="%x" inputmask="%x"/>
</page>
</layout>
</form>
Modified: trunk/modules/finance/gl.gcd
===================================================================
--- trunk/finance/gl.gcd 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/modules/finance/gl.gcd 2005-07-28 06:12:51 UTC (rev 21)
@@ -24,6 +24,11 @@
$Id: gl.gcd 6208 2004-08-25 16:49:04Z reinhard $ -->
<module name="gl" comment="General Ledger">
+
+ <!-- =================================================================== -->
+ <!-- Basic classes -->
+ <!-- =================================================================== -->
+
<class name="year" filter="base_company" comment="Fiscal year">
<property name="name" type="string(17)" nullable="False" />
<property name="start" type="date" nullable="False" />
@@ -127,6 +132,10 @@
<property name="account" type="gl_account" />
</class>
+ <!-- =================================================================== -->
+ <!-- Final transaction store classes - all transactions end up here -->
+ <!-- =================================================================== -->
+
<class name="journal" filter="gl_year" comment="General Ledger Journal">
<property name="period" type="gl_period" nullable="False" />
<property name="serial" type="number(6)" />
@@ -227,4 +236,67 @@
]]>
</procedure>
</class>
+
+ <!-- =================================================================== -->
+ <!-- Batch classes for transaction entry -->
+ <!-- =================================================================== -->
+
+ <class name="batch" filter="gl_year" comment="General Ledger Batch">
+ <property name="period" type="gl_period" nullable="False" />
+ <property name="serial" type="number(6)" />
+ <property name="last" type="number(6)" comment="Last item serial" />
+ <property name="balanced" type="boolean" nullable="False">
+ <![CDATA[
+ # Find out whether the batch is balanced
+ # for item in find ('batchitem', conditions = {'gl_batch': self}):
+ # if not item.gl_balanced:
+ # return False
+ return True
+ ]]>
+ </property>
+ <procedure name="post">
+ <![CDATA[
+ if not self.balanced:
+ abort (message ('journalImbalanced'))
+ # here goes the code...
+ ]]>
+ </procedure>
+ <procedure name="OnInit">
+ <![CDATA[
+ self.last = 0
+ ]]>
+ </procedure>
+ <procedure name="OnValidate">
+ <![CDATA[
+ if not self.period.active:
+ abort (message ('periodInactive'))
+ if not self.serial:
+ self.period.year.last += 1
+ self.serial = self.period.year.last
+ ]]>
+ </procedure>
+ </class>
+
+ <class name="batchitem" filter="gl_year" comment="General Ledger Batch Item">
+ <property name="batch" type="gl_batch" nullable="False" />
+ <property name="serial" type="number(6)" comment="Pos. in batch" />
+ <property name="doctype" type="gl_doctype" comment="Document type" />
+ <property name="number" type="string(17)" comment="Document number" />
+ <property name="date" type="date" comment="Document date" />
+ <property name="currency" type="base_currency" nullable="False" />
+ <property name="last" type="number(6)" comment="Last entry serial"
/>
+ <procedure name="OnInit">
+ <![CDATA[
+ self.currency = (find ('base_parameters') [0]).base_currency
+ ]]>
+ </procedure>
+ <procedure name="OnValidate">
+ <![CDATA[
+ if not self.serial:
+ self.batch.last += 1
+ self.serial = self.batch.last
+ self.last = 0
+ ]]>
+ </procedure>
+ </class>
</module>
Modified: trunk/modules/finance/sample.gsd
===================================================================
--- trunk/finance/sample.gsd 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/modules/finance/sample.gsd 2005-07-28 06:12:51 UTC (rev 21)
@@ -2,15 +2,6 @@
<schema author="gnue-gsdgen" title="Appserver Data Dump" version="1.0">
<data>
<tabledata name="base_company_dump" tablename="base_company">
- <definition>
- <column field="base_code" type="string(8)"/>
- <column field="base_name" type="string(35)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_code">demoa</value>
@@ -24,20 +15,6 @@
</rows>
</tabledata>
<tabledata name="gl_year_dump" tablename="gl_year">
- <definition>
- <column field="base_company" type="string(32)"/>
- <column field="gl_active" type="boolean"/>
- <column field="gl_end" type="date"/>
- <column field="gl_last" type="number(6)"/>
- <column field="gl_name" type="string(17)"/>
- <column field="gl_previous" type="string(32)"/>
- <column field="gl_start" type="date"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_company">91094290434119931310213246688146</value>
@@ -55,19 +32,6 @@
</rows>
</tabledata>
<tabledata name="gl_period_dump" tablename="gl_period">
- <definition>
- <column field="base_company" type="string(32)"/>
- <column field="gl_active" type="boolean"/>
- <column field="gl_end" type="date"/>
- <column field="gl_name" type="string(17)"/>
- <column field="gl_start" type="date"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_company">91094290434119931310213246688146</value>
@@ -227,35 +191,7 @@
</row>
</rows>
</tabledata>
- <tabledata name="gl_journal_dump" tablename="gl_journal">
- <definition>
- <column field="gl_last" type="number(6)"/>
- <column field="gl_period" type="string(32)"/>
- <column field="gl_posted" type="date"/>
- <column field="gl_serial" type="number(6)"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
- <rows/>
- </tabledata>
<tabledata name="base_currency_dump" tablename="base_currency">
- <definition>
- <column field="base_code" type="string(8)"/>
- <column field="base_company" type="string(32)"/>
- <column field="base_convbase" type="number(14.2)"/>
- <column field="base_convthis" type="number(14.2)"/>
- <column field="base_name" type="string(35)"/>
- <column field="base_roundunit" type="number(14.2)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_code">EUR</value>
@@ -299,15 +235,6 @@
</rows>
</tabledata>
<tabledata name="base_parameters_dump" tablename="base_parameters">
- <definition>
- <column field="base_company" type="string(32)"/>
- <column field="base_currency" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
<rows>
<row>
<value field="base_company">91094290434119931310213246688146</value>
@@ -320,71 +247,5 @@
</row>
</rows>
</tabledata>
- <tabledata name="gl_account_dump" tablename="gl_account">
- <definition>
- <column field="gl_active" type="boolean"/>
- <column field="gl_currency" type="string(32)"/>
- <column field="gl_name" type="string(35)"/>
- <column field="gl_number" type="string(17)"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
- <rows/>
- </tabledata>
- <tabledata name="gl_doctype_dump" tablename="gl_doctype">
- <definition>
- <column field="gl_account" type="string(32)"/>
- <column field="gl_code" type="string(8)"/>
- <column field="gl_name" type="string(35)"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
- <rows/>
- </tabledata>
- <tabledata name="gl_trans_dump" tablename="gl_trans">
- <definition>
- <column field="gl_currency" type="string(32)"/>
- <column field="gl_date" type="date"/>
- <column field="gl_doctype" type="string(32)"/>
- <column field="gl_journal" type="string(32)"/>
- <column field="gl_last" type="number(6)"/>
- <column field="gl_number" type="string(17)"/>
- <column field="gl_serial" type="number(6)"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
- <rows/>
- </tabledata>
- <tabledata name="gl_entry_dump" tablename="gl_entry">
- <definition>
- <column field="gl_account" type="string(32)"/>
- <column field="gl_amounta" type="number(14.2)"/>
- <column field="gl_amountb" type="number(14.2)"/>
- <column field="gl_amountt" type="number(14.2)"/>
- <column field="gl_comment" type="string(70)"/>
- <column field="gl_credit" type="boolean"/>
- <column field="gl_serial" type="number(6)"/>
- <column field="gl_trans" type="string(32)"/>
- <column field="gl_year" type="string(32)"/>
- <column field="gnue_createdate" type="datetime"/>
- <column field="gnue_createuser" type="string(8)"/>
- <column field="gnue_id" key="Y" type="string(32)"/>
- <column field="gnue_modifydate" type="datetime"/>
- <column field="gnue_modifyuser" type="string(8)"/>
- </definition>
- <rows/>
- </tabledata>
</data>
</schema>
Added: trunk/modules/finance/test.gsd
===================================================================
--- trunk/finance/test.gsd 2005-04-19 11:04:28 UTC (rev 20)
+++ trunk/modules/finance/test.gsd 2005-07-28 06:12:51 UTC (rev 21)
@@ -0,0 +1,450 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<schema author="gnue-gsdgen" title="Appserver Data Dump" version="1.0">
+ <data>
+ <tabledata name="base_company_dump" tablename="base_company">
+ <primarykey name="pk_base_company">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-06 15:03:58,00</value>
+ <value field="gnue_id">91094290434119931310213246688146</value>
+ <value field="base_name">Austria Elektrohandels-GmbH</value>
+ <value field="base_name">Austria Elektrohandels-GmbH</value>
+ <value field="gnue_createdate">2005-01-06 15:03:58,00</value>
+ <value field="gnue_id">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 15:04:20,00</value>
+ <value field="gnue_modifydate">2005-01-06 15:04:20,00</value>
+ <value field="base_code">demoa</value>
+ <value field="base_code">demoa</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_year_dump" tablename="gl_year">
+ <primarykey name="pk_gl_year">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gl_name">2005</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gnue_createdate">2005-01-06 18:43:40,00</value>
+ <value field="gl_name">2005</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_active">TRUE</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_id">08707244106186611057597752213911</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gnue_createdate">2005-01-06 18:43:40,00</value>
+ <value field="gnue_id">08707244106186611057597752213911</value>
+ <value field="gl_last">0</value>
+ <value field="gl_last">0</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_period_dump" tablename="gl_period">
+ <primarykey name="pk_gl_period">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gl_end">2005-09-30</value>
+ <value field="gl_end">2005-09-30</value>
+ <value field="gl_start">2005-09-01</value>
+ <value field="gl_name">2005-09</value>
+ <value field="gl_name">2005-09</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">04716849784578880511559163597537</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">04716849784578880511559163597537</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-09-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-01-31</value>
+ <value field="gl_end">2005-01-31</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gl_name">2005-01</value>
+ <value field="gl_name">2005-01</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">96457246257757312367947163050767</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ <value field="gnue_id">96457246257757312367947163050767</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-08-31</value>
+ <value field="gl_end">2005-08-31</value>
+ <value field="gl_start">2005-08-01</value>
+ <value field="gl_name">2005-08</value>
+ <value field="gl_name">2005-08</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">94604205766403576882966176991904</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">94604205766403576882966176991904</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-08-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-07-31</value>
+ <value field="gl_end">2005-07-31</value>
+ <value field="gl_start">2005-07-01</value>
+ <value field="gl_name">2005-07</value>
+ <value field="gl_name">2005-07</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">53916323249580892691069522358047</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">53916323249580892691069522358047</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-07-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-11-30</value>
+ <value field="gl_end">2005-11-30</value>
+ <value field="gl_start">2005-11-01</value>
+ <value field="gl_name">2005-11</value>
+ <value field="gl_name">2005-11</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">61541187827672041407414194078418</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53,00</value>
+ <value field="gnue_id">61541187827672041407414194078418</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_start">2005-11-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-02-28</value>
+ <value field="gl_end">2005-02-28</value>
+ <value field="gl_start">2005-02-01</value>
+ <value field="gl_name">2005-02</value>
+ <value field="gl_name">2005-02</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">26566190075159312437816969037735</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ <value field="gnue_id">26566190075159312437816969037735</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_start">2005-02-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-03-31</value>
+ <value field="gl_end">2005-03-31</value>
+ <value field="gl_start">2005-03-01</value>
+ <value field="gl_name">2005-03</value>
+ <value field="gl_name">2005-03</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">11403566266893144269362603941322</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ <value field="gnue_id">11403566266893144269362603941322</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_start">2005-03-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-04-30</value>
+ <value field="gl_end">2005-04-30</value>
+ <value field="gl_start">2005-04-01</value>
+ <value field="gl_name">2005-04</value>
+ <value field="gl_name">2005-04</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">65042701227545921632176299585868</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ <value field="gnue_id">65042701227545921632176299585868</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-04-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-10-31</value>
+ <value field="gl_end">2005-10-31</value>
+ <value field="gl_start">2005-10-01</value>
+ <value field="gl_name">2005-10</value>
+ <value field="gl_name">2005-10</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">41966380879682144849489245522503</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">41966380879682144849489245522503</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_start">2005-10-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-05-31</value>
+ <value field="gl_end">2005-05-31</value>
+ <value field="gl_start">2005-05-01</value>
+ <value field="gl_name">2005-05</value>
+ <value field="gl_name">2005-05</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">52865974180378441347755431348791</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">52865974180378441347755431348791</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-05-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gl_start">2005-12-01</value>
+ <value field="gl_name">2005-12</value>
+ <value field="gl_name">2005-12</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">54695970128650629486074312380880</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53,00</value>
+ <value field="gnue_id">54695970128650629486074312380880</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_start">2005-12-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53,00</value>
+ </row>
+ <row>
+ <value field="gl_end">2005-06-30</value>
+ <value field="gl_end">2005-06-30</value>
+ <value field="gl_start">2005-06-01</value>
+ <value field="gl_name">2005-06</value>
+ <value field="gl_name">2005-06</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">45936868937509442548254107512933</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ <value field="gnue_id">45936868937509442548254107512933</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_start">2005-06-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52,00</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_journal_dump" tablename="gl_journal">
+ <primarykey name="pk_gl_journal">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows/>
+ </tabledata>
+ <tabledata name="base_currency_dump" tablename="base_currency">
+ <primarykey name="pk_base_currency">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="base_name">US-Dollar</value>
+ <value field="gnue_createdate">2005-01-06 15:13:41,00</value>
+ <value field="gnue_id">02986444346920780637752429821320</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_code">USD</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_code">USD</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="gnue_createdate">2005-01-06 15:13:41,00</value>
+ <value field="gnue_id">02986444346920780637752429821320</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="base_name">US-Dollar</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ </row>
+ <row>
+ <value field="base_name">Schweizer Franken</value>
+ <value field="gnue_createdate">2005-01-06 15:12:43,00</value>
+ <value field="gnue_id">59379523677550241392464670647506</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_code">CHF</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_code">CHF</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="gnue_createdate">2005-01-06 15:12:43,00</value>
+ <value field="gnue_id">59379523677550241392464670647506</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="base_name">Schweizer Franken</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ </row>
+ <row>
+ <value field="base_name">Euro</value>
+ <value field="gnue_createdate">2005-01-06 15:12:14,00</value>
+ <value field="gnue_id">64212593627632873997674178988436</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_code">EUR</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_code">EUR</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="gnue_createdate">2005-01-06 15:12:14,00</value>
+ <value field="gnue_id">64212593627632873997674178988436</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07,00</value>
+ <value field="base_name">Euro</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_roundunit">0.0</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="base_parameters_dump" tablename="base_parameters">
+ <primarykey name="pk_base_parameters">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-06 15:14:22,00</value>
+ <value field="gnue_modifydate">2005-01-06 15:15:17,00</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gnue_id">33052316175028759424603146486089</value>
+ <value field="base_currency">64212593627632873997674178988436</value>
+ <value field="gnue_modifydate">2005-01-06 15:15:17,00</value>
+ <value field="gnue_id">33052316175028759424603146486089</value>
+ <value field="base_currency">64212593627632873997674178988436</value>
+ <value field="gnue_createdate">2005-01-06 15:14:22,00</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_account_dump" tablename="gl_account">
+ <primarykey name="pk_gl_account">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gl_number">2700</value>
+ <value field="gl_currency">64212593627632873997674178988436</value>
+ <value field="gnue_modifydate">2005-07-20 16:14:43,00</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-07-20 16:14:06,00</value>
+ <value field="gnue_id">12f0b87c71177315a637d12046d631c2</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gl_currency">64212593627632873997674178988436</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_id">12f0b87c71177315a637d12046d631c2</value>
+ <value field="gl_number">2700</value>
+ <value field="gl_name">Kassa</value>
+ <value field="gl_name">Kassa</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gnue_createdate">2005-07-20 16:14:06,00</value>
+ <value field="gnue_modifydate">2005-07-20 16:14:43,00</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_doctype_dump" tablename="gl_doctype">
+ <primarykey name="pk_gl_doctype">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows>
+ <row>
+ <value field="gl_account">12f0b87c71177315a637d12046d631c2</value>
+ <value field="gnue_createdate">2005-07-20 16:15:48,00</value>
+ <value field="gl_name">Kassa</value>
+ <value field="gnue_modifydate">2005-07-20 16:16:03,00</value>
+ <value field="gnue_createdate">2005-07-20 16:15:48,00</value>
+ <value field="gnue_id">3fca3df4068cf276a20b253765cd41c8</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gl_code">KA</value>
+ <value field="gnue_id">3fca3df4068cf276a20b253765cd41c8</value>
+ <value field="gnue_modifydate">2005-07-20 16:16:03,00</value>
+ <value field="gl_account">12f0b87c71177315a637d12046d631c2</value>
+ <value field="gl_code">KA</value>
+ <value field="gl_name">Kassa</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="gl_trans_dump" tablename="gl_trans">
+ <primarykey name="pk_gl_trans">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows/>
+ </tabledata>
+ <tabledata name="gl_entry_dump" tablename="gl_entry">
+ <primarykey name="pk_gl_entry">
+ <pkfield name="gnue_id"/>
+ </primarykey>
+ <rows/>
+ </tabledata>
+ </data>
+</schema>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue-luca] r21 - in trunk: . bin etc modules modules/base modules/finance,
reinhard <=