[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
r167 - in gnue-invoice: forms schema scripts
From: |
kilo |
Subject: |
r167 - in gnue-invoice: forms schema scripts |
Date: |
Thu, 9 Dec 2004 06:53:23 -0600 (CST) |
Author: kilo
Date: 2004-12-09 06:53:21 -0600 (Thu, 09 Dec 2004)
New Revision: 167
Modified:
gnue-invoice/forms/INV_Head.gfd
gnue-invoice/forms/ITEM_Item.gfd
gnue-invoice/schema/invoice-en.gsd
gnue-invoice/schema/invoice-hu.gsd
gnue-invoice/schema/invoice.gcd
gnue-invoice/scripts/setup-db.sh
Log:
GNUe Invoice.
Follow the merge with data and forms.
Modified: gnue-invoice/forms/INV_Head.gfd
===================================================================
--- gnue-invoice/forms/INV_Head.gfd 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/forms/INV_Head.gfd 2004-12-09 12:53:21 UTC (rev 167)
@@ -93,7 +93,7 @@
fk_description="ITEM_shortName" fk_key="gnue_id"
fk_source="dts_ITEM_Item" maxLength="32"/>
<field name="fldInvProductPrice" field="INV_product"
- fk_description="ITEM_price" fk_key="gnue_id"
+ fk_description="SALES_price" fk_key="gnue_id"
fk_source="dts_ITEM_Item" readonly="Y" />
<field name="fldInvQuantity" field="INV_quantity" maxLength="10"
typecast="number" >
Modified: gnue-invoice/forms/ITEM_Item.gfd
===================================================================
--- gnue-invoice/forms/ITEM_Item.gfd 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/forms/ITEM_Item.gfd 2004-12-09 12:53:21 UTC (rev 167)
@@ -43,11 +43,11 @@
fk_key="gnue_id" fk_source="dts_ITEM_ItemType" maxLength="32"/>
<field name="fldItemShortname" field="ITEM_shortName" maxLength="35"/>
<field name="fldItemLongname" field="ITEM_longName" maxLength="40"/>
- <field name="fldItemPrice" field="ITEM_price" maxLength="10"
+ <field name="fldItemPrice" field="SALES_price" maxLength="10"
typecast="number"/>
<field name="fldItemUnit" field="ITEM_unit" fk_description="ITEM_value"
fk_key="gnue_id" fk_source="dts_ITEM_UnitType" maxLength="32"/>
- <field name="fldItemVat" field="ITEM_vat" fk_description="TAX_name"
+ <field name="fldItemVat" field="SALES_vat" fk_description="TAX_name"
fk_key="gnue_id" fk_source="dts_TAX_Vat" maxLength="32"/>
</block>
</logic>
Modified: gnue-invoice/schema/invoice-en.gsd
===================================================================
--- gnue-invoice/schema/invoice-en.gsd 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/schema/invoice-en.gsd 2004-12-09 12:53:21 UTC (rev 167)
@@ -210,11 +210,11 @@
<column field="gnue_modifydate" type="datetime"/>
<column field="gnue_modifyuser" type="string(8)"/>
<column field="ITEM_longName" type="string(70)"/>
- <column field="ITEM_price" type="number(10.2)"/>
+ <column field="SALES_price" type="number(10.2)"/>
<column field="ITEM_shortName" type="string(35)"/>
<column field="ITEM_type" type="string(32)"/>
<column field="ITEM_unit" type="string(32)"/>
- <column field="ITEM_vat" type="string(32)"/>
+ <column field="SALES_vat" type="string(32)"/>
</definition>
<rows>
<row>
@@ -222,66 +222,66 @@
<value field="gnue_createuser"></value>
<value field="gnue_id">04158385481881526447158761849008</value>
<value field="ITEM_longName">Product 1</value>
- <value field="ITEM_price">111.0</value>
+ <value field="SALES_price">111.0</value>
<value field="ITEM_shortName">P1</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">57445813928883582611439670876543</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:55.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">49204821349422150287827256527230</value>
<value field="ITEM_longName">Product 2</value>
- <value field="ITEM_price">222.0</value>
+ <value field="SALES_price">222.0</value>
<value field="ITEM_shortName">P2</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">87347199152063042221294657166837</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:30:37.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">46134812820645557405896786798854</value>
<value field="ITEM_longName">Product 3</value>
- <value field="ITEM_price">333.0</value>
+ <value field="SALES_price">333.0</value>
<value field="ITEM_shortName">P3</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">69531208624436427107481042556058</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:02.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">04158385481881526447158761849009</value>
<value field="ITEM_longName">Service 1</value>
- <value field="ITEM_price">111.0</value>
+ <value field="SALES_price">111.0</value>
<value field="ITEM_shortName">S1</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:55.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">49204821349422150287827256527231</value>
<value field="ITEM_longName">Service 2</value>
- <value field="ITEM_price">222.0</value>
+ <value field="SALES_price">222.0</value>
<value field="ITEM_shortName">S2</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:30:37.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">46134812820645557405896786798855</value>
<value field="ITEM_longName">Service 3</value>
- <value field="ITEM_price">333.0</value>
+ <value field="SALES_price">333.0</value>
<value field="ITEM_shortName">S3</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
</rows>
</tabledata>
Modified: gnue-invoice/schema/invoice-hu.gsd
===================================================================
--- gnue-invoice/schema/invoice-hu.gsd 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/schema/invoice-hu.gsd 2004-12-09 12:53:21 UTC (rev 167)
@@ -203,11 +203,11 @@
<column field="gnue_modifydate" type="datetime"/>
<column field="gnue_modifyuser" type="string(8)"/>
<column field="ITEM_longName" type="string(70)"/>
- <column field="ITEM_price" type="number(10.2)"/>
+ <column field="SALES_price" type="number(10.2)"/>
<column field="ITEM_shortName" type="string(35)"/>
<column field="ITEM_type" type="string(32)"/>
<column field="ITEM_unit" type="string(32)"/>
- <column field="ITEM_vat" type="string(32)"/>
+ <column field="SALES_vat" type="string(32)"/>
</definition>
<rows>
<row>
@@ -215,66 +215,66 @@
<value field="gnue_createuser"></value>
<value field="gnue_id">04158385481881526447158761849008</value>
<value field="ITEM_longName">Termek 1</value>
- <value field="ITEM_price">111.0</value>
+ <value field="SALES_price">111.0</value>
<value field="ITEM_shortName">T1</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">57445813928883582611439670876543</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:55.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">49204821349422150287827256527230</value>
<value field="ITEM_longName">Termek 2</value>
- <value field="ITEM_price">222.0</value>
+ <value field="SALES_price">222.0</value>
<value field="ITEM_shortName">T2</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">87347199152063042221294657166837</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:30:37.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">46134812820645557405896786798854</value>
<value field="ITEM_longName">Termek 3</value>
- <value field="ITEM_price">333.0</value>
+ <value field="SALES_price">333.0</value>
<value field="ITEM_shortName">T3</value>
<value field="ITEM_type">96658201192246170490324758930242</value>
<value field="ITEM_unit">69531208624436427107481042556058</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:02.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">04158385481881526447158761849009</value>
<value field="ITEM_longName">Szolgaltatas 1</value>
- <value field="ITEM_price">111.0</value>
+ <value field="SALES_price">111.0</value>
<value field="ITEM_shortName">S1</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:28:55.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">49204821349422150287827256527231</value>
<value field="ITEM_longName">Szolgaltatas 2</value>
- <value field="ITEM_price">222.0</value>
+ <value field="SALES_price">222.0</value>
<value field="ITEM_shortName">S2</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
<row>
<value field="gnue_createdate">2004-10-14 13:30:37.00</value>
<value field="gnue_createuser"></value>
<value field="gnue_id">46134812820645557405896786798855</value>
<value field="ITEM_longName">Szolgaltatas 3</value>
- <value field="ITEM_price">333.0</value>
+ <value field="SALES_price">333.0</value>
<value field="ITEM_shortName">S3</value>
<value field="ITEM_type">17527929513744924781765541414167</value>
<value field="ITEM_unit">87347199152063042221294657166838</value>
- <value field="ITEM_vat">61602943621389663558226281311093</value>
+ <value field="SALES_vat">61602943621389663558226281311093</value>
</row>
</rows>
</tabledata>
Modified: gnue-invoice/schema/invoice.gcd
===================================================================
--- gnue-invoice/schema/invoice.gcd 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/schema/invoice.gcd 2004-12-09 12:53:21 UTC (rev 167)
@@ -40,7 +40,7 @@
************************************************-->
<class name="Item" comment="One item (line) on an invoice">
<property name="head" type="INV_Head" nullable="False"
comment="link with invoice head" />
- <property name="product" type="SALES_Item" nullable="False"
comment="" />
+ <property name="product" type="ITEM_Item" nullable="False"
comment="" />
<property name="quantity" type="number(10,2)" nullable="False"
comment="" />
<property name="note" type="string"
comment="" />
Modified: gnue-invoice/scripts/setup-db.sh
===================================================================
--- gnue-invoice/scripts/setup-db.sh 2004-12-09 12:17:47 UTC (rev 166)
+++ gnue-invoice/scripts/setup-db.sh 2004-12-09 12:53:21 UTC (rev 167)
@@ -5,6 +5,7 @@
gsscvs --connection=invoice-backend --createdb gnue.gsd
+#prerequisits
gcdcvs --connection=invoice-backend "$PACKAGEDIR/base/location/loc.gcd" \
"$PACKAGEDIR/base/party/party.gcd" \
"$PACKAGEDIR/base/item/item.gcd" \
@@ -14,4 +15,4 @@
gcdcvs --connection=invoice-backend ../schema/invoice.gcd
#standard data
-#gsscvs --connection=invoice-backend ../schema/invoice-en.gsd
+gsscvs --connection=invoice-backend ../schema/invoice-en.gsd
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- r167 - in gnue-invoice: forms schema scripts,
kilo <=