Fix #7123 - getting abra ready to test

[Pman.Xtuple] / pgsql.initdata / xtpos.pkgreport.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = xtpos, pg_catalog;

--
-- Data for Name: pkgreport; Type: TABLE DATA; Schema: xtpos; Owner: admin
--

SET SESSION AUTHORIZATION DEFAULT;

ALTER TABLE pkgreport DISABLE TRIGGER ALL;

COPY pkgreport (report_id, report_name, report_sys, report_source, report_descrip, report_grade, report_loaddate) FROM stdin;
431     DetailedRegisterHistory \N      <!DOCTYPE openRPTDef>\n<report>\n <title>Detailed Register History</title>\n <name>DetailedRegisterHistory</name>\n <description>Detailed history of cash register activity.</description>\n <size>Letter</size>\n <portrait/>\n <topmargin>50</topmargin>\n <bottommargin>50</bottommargin>\n <rightmargin>50</rightmargin>\n <leftmargin>50</leftmargin>\n <querysource loadFromDb="true" >\n  <name>detail</name>\n  <mqlgroup>display</mqlgroup>\n  <mqlname>detailedRegisterHistory</mqlname>\n </querysource>\n <querysource>\n  <name>header</name>\n  <sql>SELECT formatDate(&lt;? value("startDate" ?>, 'Earliest') AS start,\n       formatDate(&lt;? value("endDate"   ?>, 'Latest')   AS end,\n       &lt;? if exists("warehous_id") ?> warehous_code &lt;? else ?> 'ALL' &lt;? endif ?> AS site,\n       &lt;? if exists("terminal_id") ?> terminal_number &lt;? else ?> 'ALL' &lt;? endif ?> AS terminal\n\n&lt;? if exists("warehous_id") ?>\n  FROM whsinfo\n  &lt;? if exists("terminal_id") ?>\n    , xtpos.terminal\n  &lt;? endif ?>\n&lt;? elseif exists ("terminal_id") ?>\n  FROM xtpos.terminal\n&lt;? endif ?>\n\nWHERE TRUE\n&lt;? if exists("warehous_id") ?>\n  AND (warehous_id=&lt;? value("warehous_id") ?>)\n&lt;? endif ?>\n&lt;? if exists("terminal_id") ?>\n  AND (terminal_id=&lt;? value("terminal_id") ?>)\n&lt;? endif ?>\nLIMIT 1;</sql>\n </querysource>\n <pghead>\n  <height>165</height>\n  <label>\n   <rect>\n    <x>443</x>\n    <y>9.09091</y>\n    <width>294.955</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>16</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Detailed Register Report</string>\n  </label>\n  <label>\n   <rect>\n    <x>519</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Site:</string>\n  </label>\n  <label>\n   <rect>\n    <x>520</x>\n    <y>63</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Terminal:</string>\n  </label>\n  <label>\n   <rect>\n    <x>520</x>\n    <y>76</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>From:</string>\n  </label>\n  <label>\n   <rect>\n    <x>520</x>\n    <y>89</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>To:</string>\n  </label>\n  <field>\n   <rect>\n    <x>623.944</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>header</query>\n    <column>site</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>624.519</x>\n    <y>63</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>header</query>\n    <column>terminal</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>624.519</x>\n    <y>76</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>header</query>\n    <column>start</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>624.232</x>\n    <y>89</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>header</query>\n    <column>end</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>10.5</x>\n    <y>116.088</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Site:</string>\n  </label>\n  <field>\n   <rect>\n    <x>137</x>\n    <y>116.088</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>warehous_code</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>640</x>\n    <y>151</y>\n    <width>60</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Line Tax</string>\n  </label>\n  <label>\n   <rect>\n    <x>240.029</x>\n    <y>151.088</y>\n    <width>60</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>User/Item</string>\n  </label>\n  <label>\n   <rect>\n    <x>240</x>\n    <y>136</y>\n    <width>60</width>\n    <height>13.8</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Sales Rep/</string>\n  </label>\n  <label>\n   <rect>\n    <x>125.029</x>\n    <y>151.088</y>\n    <width>110</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Date &amp; Time</string>\n  </label>\n  <label>\n   <rect>\n    <x>60</x>\n    <y>149</y>\n    <width>60</width>\n    <height>14.7</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Transaction</string>\n  </label>\n  <label>\n   <rect>\n    <x>407.058</x>\n    <y>116.088</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Terminal:</string>\n  </label>\n  <field>\n   <rect>\n    <x>517.971</x>\n    <y>116.088</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>10</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>terminal_number</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>498.985</x>\n    <y>137.378</y>\n    <width>98</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Register Cash</string>\n  </label>\n  <label>\n   <rect>\n    <x>301.029</x>\n    <y>148.864</y>\n    <width>125</width>\n    <height>14.724</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Customer/Description</string>\n  </label>\n  <label>\n   <rect>\n    <x>423</x>\n    <y>151</y>\n    <width>75</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Line Total</string>\n  </label>\n  <label>\n   <rect>\n    <x>422.985</x>\n    <y>137.378</y>\n    <width>75</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Tendered/</string>\n  </label>\n  <label>\n   <rect>\n    <x>510</x>\n    <y>151</y>\n    <width>60</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Unit Price</string>\n  </label>\n  <label>\n   <rect>\n    <x>578.073</x>\n    <y>151.088</y>\n    <width>60</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Qty</string>\n  </label>\n  <label>\n   <rect>\n    <x>599.015</x>\n    <y>137.378</y>\n    <width>75</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Transfer</string>\n  </label>\n  <label>\n   <rect>\n    <x>675</x>\n    <y>137.378</y>\n    <width>75</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Adjustment</string>\n  </label>\n  <line>\n   <xstart>12.0584</xstart>\n   <ystart>131.088</ystart>\n   <xend>742.058</xend>\n   <yend>131.088</yend>\n   <weight>3</weight>\n  </line>\n </pghead>\n <section>\n  <name>detail</name>\n  <group>\n   <name>Terminal</name>\n   <column>terminal_id</column>\n   <pagebreak when="after foot" />\n   <head>\n    <height>18.3604</height>\n   </head>\n   <foot>\n    <height>20</height>\n   </foot>\n  </group>\n  <group>\n   <name>spacer</name>\n   <column>f_timestamp</column>\n   <head>\n    <height>9.44485</height>\n    <line>\n     <xstart>20</xstart>\n     <ystart>3.15142</ystart>\n     <xend>750</xend>\n     <yend>3.15142</yend>\n     <weight>0</weight>\n    </line>\n   </head>\n   <foot>\n    <height>12.5332</height>\n   </foot>\n  </group>\n  <detail>\n   <key>\n    <query>detail</query>\n   </key>\n   <height>18.3076</height>\n   <field>\n    <rect>\n     <x>125</x>\n     <y>-6.32827e-15</y>\n     <width>110</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_timestamp</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>5</x>\n     <y>-6.32827e-15</y>\n     <width>50</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>type</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>60</x>\n     <y>-6.32827e-15</y>\n     <width>60</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>transaction</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>240</x>\n     <y>7.10541e-15</y>\n     <width>60</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>usrrepitem</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>423</x>\n     <y>6.32827e-15</y>\n     <width>75</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_tendered</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>510</x>\n     <y>-6.21725e-15</y>\n     <width>60</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>checkunit_qtdisplayrole</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>578</x>\n     <y>-6.21725e-15</y>\n     <width>60</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_qtyNCard</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>499</x>\n     <y>4</y>\n     <width>98</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_cashslsamt</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>599</x>\n     <y>4</y>\n     <width>75</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_transferamt</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>675</x>\n     <y>4</y>\n     <width>75</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_adjustamt</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>639.527</x>\n     <y>0</y>\n     <width>60</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_linetax</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>301</x>\n     <y>0</y>\n     <width>125</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>descrip</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <pgfoot>\n  <height>27.6102</height>\n  <label>\n   <rect>\n    <x>619.239</x>\n    <y>16.7789</y>\n    <width>11.4</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>of</string>\n  </label>\n  <field>\n   <rect>\n    <x>81.5789</x>\n    <y>16.7789</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>report_date</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>560</x>\n    <y>16.8</y>\n    <width>57.6</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_number</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>635</x>\n    <y>16.8</y>\n    <width>73.2</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_count</column>\n   </data>\n  </field>\n </pgfoot>\n</report>\n       Detailed history of cash register activity.     0       \N
432     RetailRegisterHistory   \N      <!DOCTYPE openRPTDef>\n<report>\n <title>Retail Register History</title>\n <name>RetailRegisterHistory</name>\n <description></description>\n <parameter default="51" active="true" listtype="static" type="integer" name="regdetail_id" >\n  <description>Register Detail Id</description>\n </parameter>\n <size>Letter</size>\n <portrait/>\n <topmargin>50</topmargin>\n <bottommargin>50</bottommargin>\n <rightmargin>50</rightmargin>\n <leftmargin>50</leftmargin>\n <querysource loadFromDb="true" >\n  <name>detail</name>\n  <mqlgroup>registerhistory</mqlgroup>\n  <mqlname>detail</mqlname>\n </querysource>\n <rpthead>\n  <height>140</height>\n  <label>\n   <rect>\n    <x>425</x>\n    <y>6</y>\n    <width>316</width>\n    <height>35</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>18</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Register History</string>\n  </label>\n  <field>\n   <rect>\n    <x>130</x>\n    <y>45</y>\n    <width>150</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>site_param</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>590</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Username</string>\n  </label>\n  <line>\n   <xstart>4</xstart>\n   <ystart>137</ystart>\n   <xend>744</xend>\n   <yend>137</yend>\n   <weight>2</weight>\n  </line>\n  <field>\n   <rect>\n    <x>130</x>\n    <y>60</y>\n    <width>150</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>start_param</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>130</x>\n    <y>75</y>\n    <width>150</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>end_param</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>180</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Start Balance</string>\n  </label>\n  <label>\n   <rect>\n    <x>124</x>\n    <y>120</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Type</string>\n  </label>\n  <label>\n   <rect>\n    <x>25</x>\n    <y>45</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Site:</string>\n  </label>\n  <label>\n   <rect>\n    <x>25</x>\n    <y>60</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Start Date:</string>\n  </label>\n  <label>\n   <rect>\n    <x>25</x>\n    <y>75</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>End Date:</string>\n  </label>\n  <label>\n   <rect>\n    <x>670</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Journal #</string>\n  </label>\n  <label>\n   <rect>\n    <x>510</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>End Balance</string>\n  </label>\n  <label>\n   <rect>\n    <x>430</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Adjustment</string>\n  </label>\n  <label>\n   <rect>\n    <x>345</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Transfer</string>\n  </label>\n  <label>\n   <rect>\n    <x>65</x>\n    <y>120</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Terminal</string>\n  </label>\n  <label>\n   <rect>\n    <x>5</x>\n    <y>120</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Site</string>\n  </label>\n  <label>\n   <rect>\n    <x>260</x>\n    <y>120</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Cash Sales</string>\n  </label>\n </rpthead>\n <pghead>\n  <firstpage/>\n  <height>0</height>\n </pghead>\n <pghead>\n  <height>25</height>\n  <label>\n   <rect>\n    <x>510</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>End Balance</string>\n  </label>\n  <label>\n   <rect>\n    <x>590</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Username</string>\n  </label>\n  <label>\n   <rect>\n    <x>55</x>\n    <y>5</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Terminal</string>\n  </label>\n  <label>\n   <rect>\n    <x>345</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Transfer</string>\n  </label>\n  <label>\n   <rect>\n    <x>120</x>\n    <y>5</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Type</string>\n  </label>\n  <label>\n   <rect>\n    <x>180</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Start Balance</string>\n  </label>\n  <label>\n   <rect>\n    <x>430</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Adjustment</string>\n  </label>\n  <label>\n   <rect>\n    <x>670</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Journal #</string>\n  </label>\n  <label>\n   <rect>\n    <x>5</x>\n    <y>5</y>\n    <width>50</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Site</string>\n  </label>\n  <line>\n   <xstart>4</xstart>\n   <ystart>22</ystart>\n   <xend>744</xend>\n   <yend>22</yend>\n   <weight>2</weight>\n  </line>\n  <label>\n   <rect>\n    <x>260</x>\n    <y>5</y>\n    <width>75</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Cash Sales</string>\n  </label>\n </pghead>\n <section>\n  <name>detail</name>\n  <detail>\n   <key>\n    <query>detail</query>\n   </key>\n   <height>15</height>\n   <field>\n    <rect>\n     <x>510</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_endbal</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>430</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_adjustment</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>185</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_startbal</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>345</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_transferamt</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>65</x>\n     <y>0</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>terminal_number</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>125</x>\n     <y>0</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_type</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>5</x>\n     <y>0</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>warehous_code</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>590</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>regdetail_username</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>670</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_journalnumber</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>265</x>\n     <y>0</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_cashslsamt</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <pgfoot>\n  <height>35</height>\n  <label>\n   <rect>\n    <x>600</x>\n    <y>5</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Page:</string>\n  </label>\n  <field>\n   <rect>\n    <x>90</x>\n    <y>5</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>report_date</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>690</x>\n    <y>5</y>\n    <width>40</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_number</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>0</x>\n    <y>5</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Report Date:</string>\n  </label>\n </pgfoot>\n</report>\n   \N      0       \N
433     RetailRegisterReceipt   \N      <!DOCTYPE openRPTDef>\n<report>\n <title>Retail Register Receipt</title>\n <name>RetailRegisterReceipt</name>\n <description></description>\n <parameter default="51" active="true" listtype="static" type="integer" name="regdetail_id" >\n  <description>Register Detail Id</description>\n </parameter>\n <size>Letter</size>\n <portrait/>\n <topmargin>50</topmargin>\n <bottommargin>50</bottommargin>\n <rightmargin>50</rightmargin>\n <leftmargin>50</leftmargin>\n <querysource loadFromDb="true" >\n  <name>detail</name>\n  <mqlgroup>registerreceipt</mqlgroup>\n  <mqlname>detail</mqlname>\n </querysource>\n <querysource loadFromDb="true" >\n  <name>checks</name>\n  <mqlgroup>registerreceipt</mqlgroup>\n  <mqlname>checks</mqlname>\n </querysource>\n <querysource loadFromDb="true" >\n  <name>creditcards</name>\n  <mqlgroup>registerreceipt</mqlgroup>\n  <mqlname>creditcards</mqlname>\n </querysource>\n <rpthead>\n  <height>45</height>\n  <label>\n   <rect>\n    <x>425</x>\n    <y>6</y>\n    <width>316</width>\n    <height>35</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>18</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Register Posting Receipt</string>\n  </label>\n </rpthead>\n <pghead>\n  <firstpage/>\n  <height>0</height>\n </pghead>\n <section>\n  <name>detail</name>\n  <detail>\n   <key>\n    <query>detail</query>\n   </key>\n   <height>230</height>\n   <field>\n    <rect>\n     <x>425</x>\n     <y>40</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_cashslsamt</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>425</x>\n     <y>85</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_endbal</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>425</x>\n     <y>70</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_adjustment</column>\n    </data>\n   </field>\n   <label>\n    <rect>\n     <x>20</x>\n     <y>55</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Site:</string>\n   </label>\n   <field>\n    <rect>\n     <x>130</x>\n     <y>55</y>\n     <width>150</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>warehous_code</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>130</x>\n     <y>25</y>\n     <width>150</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_type</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>425</x>\n     <y>25</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_startbal</column>\n    </data>\n   </field>\n   <label>\n    <rect>\n     <x>20</x>\n     <y>25</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Type:</string>\n   </label>\n   <label>\n    <rect>\n     <x>310</x>\n     <y>55</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Transfer:</string>\n   </label>\n   <label>\n    <rect>\n     <x>310</x>\n     <y>40</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Cash Sales:</string>\n   </label>\n   <field>\n    <rect>\n     <x>425</x>\n     <y>55</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_transferamt</column>\n    </data>\n   </field>\n   <label>\n    <rect>\n     <x>20</x>\n     <y>40</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Time:</string>\n   </label>\n   <field>\n    <rect>\n     <x>130</x>\n     <y>70</y>\n     <width>150</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>terminal_number</column>\n    </data>\n   </field>\n   <label>\n    <rect>\n     <x>310</x>\n     <y>70</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Adjustment:</string>\n   </label>\n   <field>\n    <rect>\n     <x>130</x>\n     <y>40</y>\n     <width>150</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_post_time</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>95</x>\n     <y>135</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>bankaccnt_name</column>\n    </data>\n   </field>\n   <label>\n    <rect>\n     <x>310</x>\n     <y>85</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Ending Balance:</string>\n   </label>\n   <label>\n    <rect>\n     <x>310</x>\n     <y>25</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Starting Balance:</string>\n   </label>\n   <label>\n    <rect>\n     <x>10</x>\n     <y>135</y>\n     <width>75</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <string>Bank Account:</string>\n   </label>\n   <label>\n    <rect>\n     <x>20</x>\n     <y>70</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Terminal:</string>\n   </label>\n   <label>\n    <rect>\n     <x>5</x>\n     <y>117</y>\n     <width>200</width>\n     <height>14</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>10</size>\n     <weight>normal</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <string>Bank Transfer Summary</string>\n   </label>\n   <field>\n    <rect>\n     <x>640</x>\n     <y>175</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_cashdep_amount</column>\n    </data>\n   </field>\n   <line>\n    <xstart>4</xstart>\n    <ystart>172</ystart>\n    <xend>744</xend>\n    <yend>172</yend>\n    <weight>2</weight>\n   </line>\n   <label>\n    <rect>\n     <x>635</x>\n     <y>155</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Amount</string>\n   </label>\n   <label>\n    <rect>\n     <x>10</x>\n     <y>155</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <string>Type</string>\n   </label>\n   <label>\n    <rect>\n     <x>10</x>\n     <y>175</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <string>Cash</string>\n   </label>\n   <label>\n    <rect>\n     <x>10</x>\n     <y>190</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <string>Checks</string>\n   </label>\n   <label>\n    <rect>\n     <x>520</x>\n     <y>210</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <string>Total</string>\n   </label>\n   <field>\n    <rect>\n     <x>640</x>\n     <y>190</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_checkdep_amount</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>640</x>\n     <y>210</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_deposit_amount</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <section>\n  <name>checks</name>\n  <group>\n   <name>checkGroup</name>\n   <column>_nada</column>\n   <head>\n    <height>50</height>\n    <label>\n     <rect>\n      <x>10</x>\n      <y>30</y>\n      <width>100</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Sale Number</string>\n    </label>\n    <label>\n     <rect>\n      <x>125</x>\n      <y>30</y>\n      <width>100</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Document</string>\n    </label>\n    <label>\n     <rect>\n      <x>635</x>\n      <y>30</y>\n      <width>100</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Amount</string>\n    </label>\n    <label>\n     <rect>\n      <x>5</x>\n      <y>10</y>\n      <width>200</width>\n      <height>14</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>10</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Check Deposit Detail</string>\n    </label>\n    <line>\n     <xstart>5</xstart>\n     <ystart>45</ystart>\n     <xend>740</xend>\n     <yend>45</yend>\n     <weight>2</weight>\n    </line>\n   </head>\n   <foot>\n    <height>21.4187</height>\n    <field>\n     <rect>\n      <x>635</x>\n      <y>5</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <data>\n      <query>checks</query>\n      <column>salehead_checkamt</column>\n     </data>\n     <tracktotal subtotal="true" builtin="true" >qty</tracktotal>\n    </field>\n    <label>\n     <rect>\n      <x>520</x>\n      <y>5</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Total</string>\n    </label>\n   </foot>\n  </group>\n  <detail>\n   <key>\n    <query>checks</query>\n   </key>\n   <height>15</height>\n   <field>\n    <rect>\n     <x>635</x>\n     <y>1</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>checks</query>\n     <column>f_amount</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>125</x>\n     <y>1</y>\n     <width>200</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>checks</query>\n     <column>salehead_checknumber</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>10</x>\n     <y>1</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>checks</query>\n     <column>salehead_number</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <section>\n  <name>creditcards</name>\n  <group>\n   <name>creditcardGroup</name>\n   <column></column>\n   <head>\n    <height>49.6275</height>\n    <label>\n     <rect>\n      <x>5</x>\n      <y>10</y>\n      <width>200</width>\n      <height>14</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>10</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Credit Card Payment Summary</string>\n    </label>\n    <label>\n     <rect>\n      <x>9.13175</x>\n      <y>26.527</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Type</string>\n    </label>\n    <line>\n     <xstart>5.60138</xstart>\n     <ystart>43.6733</ystart>\n     <xend>738.37</xend>\n     <yend>43.6633</yend>\n     <weight>2</weight>\n    </line>\n    <label>\n     <rect>\n      <x>635</x>\n      <y>26.8448</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Amount</string>\n    </label>\n   </head>\n   <foot>\n    <height>20</height>\n    <field>\n     <rect>\n      <x>635</x>\n      <y>5</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <data>\n      <query>creditcards</query>\n      <column>amount</column>\n     </data>\n     <tracktotal subtotal="true" builtin="true" >qty</tracktotal>\n    </field>\n    <label>\n     <rect>\n      <x>520</x>\n      <y>5</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Total</string>\n    </label>\n   </foot>\n  </group>\n  <detail>\n   <key>\n    <query>creditcards</query>\n   </key>\n   <height>15</height>\n   <field>\n    <rect>\n     <x>635</x>\n     <y>0</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>creditcards</query>\n     <column>f_amount</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>10</x>\n     <y>0</y>\n     <width>150</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>creditcards</query>\n     <column>f_type</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <pgfoot>\n  <height>25</height>\n  <label>\n   <rect>\n    <x>600</x>\n    <y>5</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Page:</string>\n  </label>\n  <field>\n   <rect>\n    <x>90</x>\n    <y>5</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>report_date</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>690</x>\n    <y>5</y>\n    <width>40</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_number</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>0</x>\n    <y>5</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Report Date:</string>\n  </label>\n </pgfoot>\n</report>\n      \N      0       \N
434     RetailSaleReceipt       \N      <!DOCTYPE openRPTDef>\n<report>\n <title>Retail Sale Receipt</title>\n <name>RetailSaleReceipt</name>\n <description></description>\n <size>Letter</size>\n <portrait/>\n <topmargin>50</topmargin>\n <bottommargin>50</bottommargin>\n <rightmargin>50</rightmargin>\n <leftmargin>50</leftmargin>\n <querysource loadFromDb="true" >\n  <name>detail</name>\n  <mqlgroup>salereceipt</mqlgroup>\n  <mqlname>detail</mqlname>\n </querysource>\n <querysource loadFromDb="true" >\n  <name>payments</name>\n  <mqlgroup>salereceipt</mqlgroup>\n  <mqlname>payments</mqlname>\n </querysource>\n <querysource loadFromDb="true" >\n  <name>totals</name>\n  <mqlgroup>salereceipt</mqlgroup>\n  <mqlname>totals</mqlname>\n </querysource>\n <rpthead>\n  <height>45</height>\n  <field>\n   <rect>\n    <x>5</x>\n    <y>14</y>\n    <width>455</width>\n    <height>29</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>14</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>f_company_name</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>500</x>\n    <y>10</y>\n    <width>250</width>\n    <height>33</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>18</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <data>\n    <query>detail</query>\n    <column>f_receipt_type</column>\n   </data>\n  </field>\n </rpthead>\n <pghead>\n  <firstpage/>\n  <height>9</height>\n </pghead>\n <section>\n  <name>detail</name>\n  <group>\n   <name>detailGroup</name>\n   <column>salehead_number</column>\n   <head>\n    <height>140</height>\n    <field>\n     <rect>\n      <x>120</x>\n      <y>16</y>\n      <width>125</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>salehead_number</column>\n     </data>\n    </field>\n    <label>\n     <rect>\n      <x>13.9</x>\n      <y>16</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Number:</string>\n    </label>\n    <label>\n     <rect>\n      <x>10</x>\n      <y>31.875</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Time:</string>\n    </label>\n    <field>\n     <rect>\n      <x>120</x>\n      <y>31.875</y>\n      <width>125</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>f_time</column>\n     </data>\n    </field>\n    <label>\n     <rect>\n      <x>10</x>\n      <y>46</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Site:</string>\n    </label>\n    <label>\n     <rect>\n      <x>10</x>\n      <y>60</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Terminal:</string>\n    </label>\n    <label>\n     <rect>\n      <x>405</x>\n      <y>16</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Customer Number:</string>\n    </label>\n    <field>\n     <rect>\n      <x>120</x>\n      <y>60</y>\n      <width>125</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>terminal_number</column>\n     </data>\n    </field>\n    <field>\n     <rect>\n      <x>120</x>\n      <y>46</y>\n      <width>125</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>warehous_code</column>\n     </data>\n    </field>\n    <field>\n     <rect>\n      <x>515</x>\n      <y>16</y>\n      <width>200</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>cust_number</column>\n     </data>\n    </field>\n    <label>\n     <rect>\n      <x>405</x>\n      <y>31.875</y>\n      <width>100</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Name:</string>\n    </label>\n    <field>\n     <rect>\n      <x>515</x>\n      <y>31.875</y>\n      <width>200</width>\n      <height>15</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <data>\n      <query>detail</query>\n      <column>f_name</column>\n     </data>\n    </field>\n    <text>\n     <rect>\n      <x>515</x>\n      <y>46</y>\n      <width>200</width>\n      <height>15</height>\n     </rect>\n     <bottompad>0</bottompad>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <top/>\n     <data>\n      <query>detail</query>\n      <column>f_address</column>\n     </data>\n    </text>\n    <line>\n     <xstart>5</xstart>\n     <ystart>134</ystart>\n     <xend>745</xend>\n     <yend>134</yend>\n     <weight>2</weight>\n    </line>\n    <label>\n     <rect>\n      <x>10</x>\n      <y>120</y>\n      <width>50</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Line #</string>\n    </label>\n    <label>\n     <rect>\n      <x>100</x>\n      <y>120</y>\n      <width>100</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Item Number</string>\n    </label>\n    <label>\n     <rect>\n      <x>210</x>\n      <y>120</y>\n      <width>300</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <left/>\n     <vcenter/>\n     <string>Description</string>\n    </label>\n    <label>\n     <rect>\n      <x>520</x>\n      <y>121</y>\n      <width>50</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Qty.</string>\n    </label>\n    <label>\n     <rect>\n      <x>580</x>\n      <y>120</y>\n      <width>50</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Price</string>\n    </label>\n    <label>\n     <rect>\n      <x>640</x>\n      <y>120</y>\n      <width>100</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Extended</string>\n    </label>\n    <barcode>\n     <rect>\n      <x>268</x>\n      <y>21</y>\n      <width>138</width>\n      <height>36</height>\n     </rect>\n     <format>3of9</format>\n     <maxlength>5</maxlength>\n     <left/>\n     <narrowBarWidth>0.01</narrowBarWidth>\n     <data>\n      <query>detail</query>\n      <column>salehead_number</column>\n     </data>\n    </barcode>\n   </head>\n   <foot>\n    <height>30</height>\n    <text>\n     <rect>\n      <x>75</x>\n      <y>10</y>\n      <width>670</width>\n      <height>10</height>\n     </rect>\n     <bottompad>0</bottompad>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>bold</weight>\n     </font>\n     <left/>\n     <top/>\n     <data>\n      <query>detail</query>\n      <column>salehead_notes</column>\n     </data>\n    </text>\n    <label>\n     <rect>\n      <x>15</x>\n      <y>10</y>\n      <width>45</width>\n      <height>10</height>\n     </rect>\n     <font>\n      <face>Arial</face>\n      <size>8</size>\n      <weight>normal</weight>\n     </font>\n     <right/>\n     <vcenter/>\n     <string>Notes:</string>\n    </label>\n   </foot>\n  </group>\n  <detail>\n   <key>\n    <query>detail</query>\n   </key>\n   <height>66</height>\n   <field>\n    <rect>\n     <x>10</x>\n     <y>6</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>saleitem_linenumber</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>90</x>\n     <y>6</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>item_number</column>\n    </data>\n   </field>\n   <barcode>\n    <rect>\n     <x>100.405</x>\n     <y>23.4693</y>\n     <width>350</width>\n     <height>32.5</height>\n    </rect>\n    <format>3of9</format>\n    <maxlength>13</maxlength>\n    <left/>\n    <narrowBarWidth>0.01</narrowBarWidth>\n    <data>\n     <query>detail</query>\n     <column>item_number</column>\n    </data>\n   </barcode>\n   <field>\n    <rect>\n     <x>210</x>\n     <y>6</y>\n     <width>300</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>item_descrip1</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>520</x>\n     <y>6</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_qty</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>580</x>\n     <y>6</y>\n     <width>50</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_price</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>640</x>\n     <y>6</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>f_extended</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <section>\n  <name>totals</name>\n  <detail>\n   <key>\n    <query>totals</query>\n   </key>\n   <height>15</height>\n   <field>\n    <rect>\n     <x>635</x>\n     <y>0</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>totals</query>\n     <column>f_amount</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>520</x>\n     <y>0</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>totals</query>\n     <column>type</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <section>\n  <name>payments</name>\n  <detail>\n   <key>\n    <query>payments</query>\n   </key>\n   <height>15</height>\n   <field>\n    <rect>\n     <x>635</x>\n     <y>0</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>payments</query>\n     <column>f_amount</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>520</x>\n     <y>0</y>\n     <width>100</width>\n     <height>15</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>normal</weight>\n    </font>\n    <right/>\n    <vcenter/>\n    <data>\n     <query>payments</query>\n     <column>type</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <pgfoot>\n  <height>25</height>\n  <label>\n   <rect>\n    <x>615</x>\n    <y>0</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Page:</string>\n  </label>\n  <field>\n   <rect>\n    <x>90</x>\n    <y>0</y>\n    <width>100</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>report_date</column>\n   </data>\n  </field>\n  <field>\n   <rect>\n    <x>705</x>\n    <y>0</y>\n    <width>40</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>bold</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_number</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>0</x>\n    <y>0</y>\n    <width>85</width>\n    <height>15</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Report Date:</string>\n  </label>\n </pgfoot>\n</report>\n  \N      0       \N
463     RetailSitesReport       \N      <!DOCTYPE openRPTDef>\n<report>\n <title>List Retail Sites</title>\n <name>RetailSitesReport</name>\n <description>Show the basic information about all defined retail sites - part of the xtpos package.</description>\n <size>Letter</size>\n <portrait/>\n <topmargin>100</topmargin>\n <bottommargin>100</bottommargin>\n <rightmargin>100</rightmargin>\n <leftmargin>100</leftmargin>\n <querysource loadFromDb="true" >\n  <name>detail</name>\n  <mqlgroup>retailsite</mqlgroup>\n  <mqlname>getapi_retailsite</mqlname>\n </querysource>\n <pghead>\n  <firstpage/>\n  <height>100</height>\n  <label>\n   <rect>\n    <x>400</x>\n    <y>16.8613</y>\n    <width>200</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>18</size>\n    <weight>bold</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Retail Sites</string>\n  </label>\n  <label>\n   <rect>\n    <x>514.24</x>\n    <y>77</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Check Clearing Account</string>\n  </label>\n  <line>\n   <xstart>10</xstart>\n   <ystart>90</ystart>\n   <xend>640</xend>\n   <yend>90</yend>\n   <weight>0</weight>\n  </line>\n  <label>\n   <rect>\n    <x>389.416</x>\n    <y>77</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Register Adjustment Account</string>\n  </label>\n  <label>\n   <rect>\n    <x>275.466</x>\n    <y>77</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Register Asset Account</string>\n  </label>\n  <label>\n   <rect>\n    <x>100</x>\n    <y>77</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Quotes Expire After # Days</string>\n  </label>\n  <label>\n   <rect>\n    <x>20</x>\n    <y>77</y>\n    <width>50</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Site</string>\n  </label>\n </pghead>\n <pghead>\n  <height>70</height>\n  <label>\n   <rect>\n    <x>100</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Quotes Expire After # Days</string>\n  </label>\n  <line>\n   <xstart>10</xstart>\n   <ystart>60</ystart>\n   <xend>640</xend>\n   <yend>60</yend>\n   <weight>0</weight>\n  </line>\n  <label>\n   <rect>\n    <x>20</x>\n    <y>50</y>\n    <width>50</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <hcenter/>\n   <vcenter/>\n   <string>Site</string>\n  </label>\n  <label>\n   <rect>\n    <x>510</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Check Clearing Account</string>\n  </label>\n  <label>\n   <rect>\n    <x>390</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Register Adjustment Account</string>\n  </label>\n  <label>\n   <rect>\n    <x>280</x>\n    <y>50</y>\n    <width>100</width>\n    <height>12.5</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <string>Register Asset Account</string>\n  </label>\n </pghead>\n <section>\n  <name>unnamed</name>\n  <detail>\n   <key>\n    <query>detail</query>\n   </key>\n   <height>40</height>\n   <field>\n    <rect>\n     <x>25.5923</x>\n     <y>4</y>\n     <width>50</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>site</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>105.96</x>\n     <y>4</y>\n     <width>100</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>quote_days</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>279.452</x>\n     <y>4</y>\n     <width>100</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>asset</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>390.684</x>\n     <y>4</y>\n     <width>100</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>adjustment</column>\n    </data>\n   </field>\n   <field>\n    <rect>\n     <x>508.085</x>\n     <y>4</y>\n     <width>100</width>\n     <height>12.5</height>\n    </rect>\n    <font>\n     <face>Arial</face>\n     <size>8</size>\n     <weight>bold</weight>\n    </font>\n    <left/>\n    <vcenter/>\n    <data>\n     <query>detail</query>\n     <column>check_clearing</column>\n    </data>\n   </field>\n  </detail>\n </section>\n <pgfoot>\n  <height>50</height>\n  <label>\n   <rect>\n    <x>3</x>\n    <y>27</y>\n    <width>100</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Report Date:</string>\n  </label>\n  <field>\n   <rect>\n    <x>103</x>\n    <y>27</y>\n    <width>100</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>report_date</column>\n   </data>\n  </field>\n  <label>\n   <rect>\n    <x>435</x>\n    <y>27</y>\n    <width>100</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <right/>\n   <vcenter/>\n   <string>Page:</string>\n  </label>\n  <field>\n   <rect>\n    <x>535</x>\n    <y>27</y>\n    <width>100</width>\n    <height>25</height>\n   </rect>\n   <font>\n    <face>Arial</face>\n    <size>8</size>\n    <weight>normal</weight>\n   </font>\n   <left/>\n   <vcenter/>\n   <data>\n    <query>Context Query</query>\n    <column>page_number</column>\n   </data>\n  </field>\n </pgfoot>\n</report>\n  Show the basic information about all defined retail sites - part of the xtpos package.  0       \N
\.


ALTER TABLE pkgreport ENABLE TRIGGER ALL;

--
-- PostgreSQL database dump complete
--