[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue-luca] r20 - trunk/finance
|
From: |
reinhard |
|
Subject: |
[gnue-luca] r20 - trunk/finance |
|
Date: |
Tue, 19 Apr 2005 06:04:29 -0500 (CDT) |
Author: reinhard
Date: 2005-04-19 06:04:28 -0500 (Tue, 19 Apr 2005)
New Revision: 20
Added:
trunk/finance/sample.gsd
Log:
Added sample data for finance.
Added: trunk/finance/sample.gsd
===================================================================
--- trunk/finance/sample.gsd 2005-03-08 14:41:17 UTC (rev 19)
+++ trunk/finance/sample.gsd 2005-04-19 11:04:28 UTC (rev 20)
@@ -0,0 +1,390 @@
+<?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">
+ <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>
+ <value field="base_name">Austria Elektrohandels-GmbH</value>
+ <value field="gnue_createdate">2005-01-06 15:03:58.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">91094290434119931310213246688146</value>
+ <value field="gnue_modifydate">2005-01-06 15:04:20.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ </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>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gl_last">0</value>
+ <value field="gl_name">2005</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gnue_createdate">2005-01-06 18:43:40.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">08707244106186611057597752213911</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ </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>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-01-31</value>
+ <value field="gl_name">2005-01</value>
+ <value field="gl_start">2005-01-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">96457246257757312367947163050767</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-02-28</value>
+ <value field="gl_name">2005-02</value>
+ <value field="gl_start">2005-02-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">26566190075159312437816969037735</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-03-31</value>
+ <value field="gl_name">2005-03</value>
+ <value field="gl_start">2005-03-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">11403566266893144269362603941322</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-04-30</value>
+ <value field="gl_name">2005-04</value>
+ <value field="gl_start">2005-04-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:51.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">65042701227545921632176299585868</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-05-31</value>
+ <value field="gl_name">2005-05</value>
+ <value field="gl_start">2005-05-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">52865974180378441347755431348791</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-06-30</value>
+ <value field="gl_name">2005-06</value>
+ <value field="gl_start">2005-06-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">45936868937509442548254107512933</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-07-31</value>
+ <value field="gl_name">2005-07</value>
+ <value field="gl_start">2005-07-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">53916323249580892691069522358047</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-08-31</value>
+ <value field="gl_name">2005-08</value>
+ <value field="gl_start">2005-08-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">94604205766403576882966176991904</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-09-30</value>
+ <value field="gl_name">2005-09</value>
+ <value field="gl_start">2005-09-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">04716849784578880511559163597537</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-10-31</value>
+ <value field="gl_name">2005-10</value>
+ <value field="gl_start">2005-10-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:52.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">41966380879682144849489245522503</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-11-30</value>
+ <value field="gl_name">2005-11</value>
+ <value field="gl_start">2005-11-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">61541187827672041407414194078418</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="gl_active">TRUE</value>
+ <value field="gl_end">2005-12-31</value>
+ <value field="gl_name">2005-12</value>
+ <value field="gl_start">2005-12-01</value>
+ <value field="gl_year">08707244106186611057597752213911</value>
+ <value field="gnue_createdate">2005-01-06 18:43:53.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">54695970128650629486074312380880</value>
+ <value field="gnue_modifydate">2005-01-06 18:43:53.00</value>
+ <value field="gnue_modifyuser"></value>
+ </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>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_convthis">1.0</value>
+ <value field="base_name">Euro</value>
+ <value field="base_roundunit">0.01</value>
+ <value field="gnue_createdate">2005-01-06 15:12:14.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">64212593627632873997674178988436</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_code">CHF</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_convthis">1.5</value>
+ <value field="base_name">Schweizer Franken</value>
+ <value field="base_roundunit">0.05</value>
+ <value field="gnue_createdate">2005-01-06 15:12:43.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">59379523677550241392464670647506</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="base_code">USD</value>
+ <value field="base_company">91094290434119931310213246688146</value>
+ <value field="base_convbase">1.0</value>
+ <value field="base_convthis">1.3</value>
+ <value field="base_name">US-Dollar</value>
+ <value field="base_roundunit">0.01</value>
+ <value field="gnue_createdate">2005-01-06 15:13:41.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">02986444346920780637752429821320</value>
+ <value field="gnue_modifydate">2005-01-06 15:14:07.00</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ </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>
+ <value field="base_currency">64212593627632873997674178988436</value>
+ <value field="gnue_createdate">2005-01-06 15:14:22.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">33052316175028759424603146486089</value>
+ <value field="gnue_modifydate">2005-01-06 15:15:17.00</value>
+ <value field="gnue_modifyuser"></value>
+ </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>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue-luca] r20 - trunk/finance,
reinhard <=