r129 - gnue-invoice/reports

[btami]

Author: btami
Date: 2004-11-23 07:30:52 -0600 (Tue, 23 Nov 2004)
New Revision: 129

Added:
   gnue-invoice/reports/invoice.grd
Log:
GNUe Invoice
started invoice grd

Added: gnue-invoice/reports/invoice.grd
===================================================================
--- gnue-invoice/reports/invoice.grd    2004-11-23 11:52:49 UTC (rev 128)
+++ gnue-invoice/reports/invoice.grd    2004-11-23 13:30:52 UTC (rev 129)
@@ -0,0 +1,67 @@
+<?xml version="1.0" encoding="iso8859-1"?>
+
+<report title="GNUe Invoice">
+  <!--*****************************************************
+                        Parameters
+  ******************************************************-->
+  <parameters>
+    <parameter name="INV_number" type="char" description="Incoice Number"/>
+  </parameters>
+  
+  <sources>
+  <!--*****************************************************
+                        Datasources
+  ******************************************************-->
+  <datasource name="dts" connection="invoice" table="INV_Head">
+    <condition>
+     <eq>
+       <cfield name="INV_number"/>
+       <cparam name="INV_number"/>
+     </eq>
+    </condition>
+  </datasource>
+  <datasource name="dts_PARTY_PartyBuyer" connection="invoice" prequery="Y"
+              table="PARTY_Party"/>
+  <datasource name="dts_INV_PaymentMethod" connection="invoice" prequery="Y"
+              table="INV_PaymentMethod"/>
+  <datasource name="dtsINV_Item" connection="invoice" detaillink="INV_Head"
+              master="dts" masterlink="gnue_id" table="INV_Item"/>
+  <datasource name="dts_ITEM_Item" connection="invoice" prequery="Y"
+              table="ITEM_Item"/>
+  <datasource name="dtsITEM_Item" connection="invoice" table="ITEM_Item"/>
+  </sources>
+
+  <!--*****************************************************
+                        Layout
+  ******************************************************-->
+  <layout xmlns:out="GNUe:Reports:Char" suppressGNUeTags="Y">
+
+  <out:report width="80" height="22">
+
+    <section name="head" source="dts">
+      <out:pageheader height="15">
+        <out:label x="60" y="1" width="20">Invoice No.</out:label>
+        <out:label x="0" y="9" width="12">dateDelivery</out:label>
+        <out:label x="20" y="9" width="5">dateDue</out:label>
+        <out:label x="40" y="10" width="4">dateIssued</out:label>
+        <out:label x="60" y="2" width="20"><field 
name="INV_number"/></out:label>
+        <out:label x="0" y="10" width="12"><field 
name="INV_dateDelivery"/></out:label>
+        <out:label x="20" y="10" width="5"><field 
name="INV_dateDue"/></out:label>
+        <out:label x="40" y="10" width="4"><field 
name="INV_dateIssued"/></out:label>
+      </out:pageheader>
+
+      <out:pagefooter height="3">
+        <out:label x="0" y="1" width="80">GNU Enterprise</out:label>
+      </out:pagefooter>
+
+      <section name="detail" source="dtsINV_Item">
+        <out:detail height="2">
+          <out:label x="20" y="0" width="15"><field 
name="INV_quantity"/></out:label>
+          <out:label x="40" y="0" width="25"><field 
name="INV_valueNet"/></out:label>
+        </out:detail>
+      </section>
+    </section>
+
+  </out:report>
+  </layout>
+</report>