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> _______________________________________________ Commit-gnue mailing list [email protected] http://lists.gnu.org/mailman/listinfo/commit-gnue
