ikiwiki-upstream - Unnamed repository; edit this file to name it for gitweb.

summary refs log tree commit diff

path: root/doc/tips/vim_syntax_highlighting

diff options

Diffstat (limited to 'doc/tips/vim_syntax_highlighting')

0 files changed, 0 insertions, 0 deletions

name>

</title>

<para>

<title>

Structure of <structname>acc_trans</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>chart_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.chart"/>

</para>

</listitem>

</varlistentry>

<term><structfield>amount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>source</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>cleared</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>fx_transaction</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>project_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>invoice_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on acc_trans</title>

<term>acc_trans_chart_id_key</term>

<listitem><para>chart_id</para></listitem>

</varlistentry>

<term>acc_trans_source_key</term>

<listitem><para>lower(source)</para></listitem>

</varlistentry>

<term>acc_trans_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

<term>acc_trans_transdate_key</term>

<listitem><para>transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.ap"

               xreflabel="public.ap">

        <title id="public.table.ap-title">

Table:

</title>

<para>

<title>

Structure of <structname>ap</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>invnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

<para>

Used to be customer_id, but customer is now metadata. You need to push to entity

</para>

</listitem>

</varlistentry>

<term><structfield>taxincluded</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>amount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>netamount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>datepaid</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>duedate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>invoice</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>ordnumber</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>quonumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>intnotes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>department_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shipvia</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>ponumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>shippingpoint</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>terms</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on ap</title>

</varlistentry>

<term>ap_invnumber_key</term>

<listitem><para>invnumber</para></listitem>

</varlistentry>

<term>ap_ordnumber_key</term>

<listitem><para>ordnumber</para></listitem>

</varlistentry>

<term>ap_quonumber_key</term>

<listitem><para>quonumber</para></listitem>

</varlistentry>

<term>ap_transdate_key</term>

<listitem><para>transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.ar"

               xreflabel="public.ar">

        <title id="public.table.ar-title">

Table:

</title>

<para>

<title>

Structure of <structname>ar</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>invnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

<para>

Used to be customer_id, but customer is now metadata. You need to push to entity

</para>

</listitem>

</varlistentry>

<term><structfield>taxincluded</structfield></term>

<type>boolean</type>

</para>

</listitem>

</varlistentry>

<term><structfield>amount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>netamount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>datepaid</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>duedate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>invoice</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>shippingpoint</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>terms</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>ordnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>quonumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>intnotes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>department_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shipvia</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>ponumber</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on ar</title>

</varlistentry>

<term>ar_invnumber_key</term>

<listitem><para>invnumber</para></listitem>

</varlistentry>

<term>ar_ordnumber_key</term>

<listitem><para>ordnumber</para></listitem>

</varlistentry>

<term>ar_quonumber_key</term>

<listitem><para>quonumber</para></listitem>

</varlistentry>

<term>ar_transdate_key</term>

<listitem><para>transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.assembly"

               xreflabel="public.assembly">

        <title id="public.table.assembly-title">

Table:

<structname>assembly</structname>

</title>

<para>

<title>

Structure of <structname>assembly</structname>

</title>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<type>boolean</type>

</para>

</listitem>

</varlistentry>

<type>boolean</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on assembly</title>

<term>assembly_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.audittrail"

               xreflabel="public.audittrail">

        <title id="public.table.audittrail-title">

Table:

<structname>audittrail</structname>

</title>

<para>

<title>

Structure of <structname>audittrail</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>tablename</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>reference</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>formname</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>action</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

<type>timestamp without time zone</type>

<literal>DEFAULT now()</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>bigserial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on audittrail</title>

<term>audittrail_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.business"

               xreflabel="public.business">

        <title id="public.table.business-title">

Table:

<structname>business</structname>

</title>

<para>

<title>

Structure of <structname>business</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>discount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.chart"

               xreflabel="public.chart">

        <title id="public.table.chart-title">

Table:

<structname>chart</structname>

</title>

<para>

<title>

Structure of <structname>chart</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>accno</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>charttype</structfield></term>

                <type>character(1)</type>

                <literal>DEFAULT &apos;A&apos;::bpchar</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>category</structfield></term>

                <type>character(1)</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>gifi_accno</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>contra</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on chart</title>

<term>chart_category_key</term>

<listitem><para>category</para></listitem>

</varlistentry>

<term>chart_gifi_accno_key</term>

<listitem><para>gifi_accno</para></listitem>

</varlistentry>

<term>chart_id_key</term>

</varlistentry>

<term>chart_link_key</term>

</varlistentry>

</variablelist>

<title>

Tables referencing acc_trans via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.acc-trans"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.partstax"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.tax"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.company"

               xreflabel="public.company">

        <title id="public.table.company-title">

Table:

<structname>company</structname>

</title>

<para>

<title>

Structure of <structname>company</structname>

</title>

<type>serial</type>

<literal>UNIQUE</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>legal_name</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_class_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity-class"/>

</para>

</listitem>

</varlistentry>

<term><structfield>primary_location_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.location"/>

</para>

<para>

This is the location that should show up by default for any forms

</para>

</listitem>

</varlistentry>

</para>

<para>

In the US this would be a EIN.

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on company</title>

<term>company_legal_name_check</term>

            <listitem><para>CHECK ((legal_name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing company_to_contact via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.company-to-contact"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.company-to-entity"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.company-to-location"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.company-to-contact"

               xreflabel="public.company_to_contact">

        <title id="public.table.company-to-contact-title">

Table:

<structname>company_to_contact</structname>

</title>

<para>

To keep track of the relationship between multiple contact methods and a single company

</para>

<para>

<title>

Structure of <structname>company_to_contact</structname>

</title>

<term><structfield>company_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.company"/>

</para>

</listitem>

</varlistentry>

<term><structfield>contact_class_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.contact-class"/>

</para>

</listitem>

</varlistentry>

<term><structfield>contact</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on company_to_contact</title>

<term>company_to_contact_contact_check</term>

            <listitem><para>CHECK ((contact ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.company-to-entity"

               xreflabel="public.company_to_entity">

        <title id="public.table.company-to-entity-title">

Table:

<structname>company_to_entity</structname>

</title>

<para>

<title>

Structure of <structname>company_to_entity</structname>

</title>

<term><structfield>company_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.company"/>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>related_how</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>created</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on company_to_entity</title>

<term>company_to_entity_check</term>

            <listitem><para>CHECK ((entity_id &lt;&gt; company_id))</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.company-to-location"

               xreflabel="public.company_to_location">

        <title id="public.table.company-to-location-title">

Table:

<structname>company_to_location</structname>

</title>

<para>

<title>

Structure of <structname>company_to_location</structname>

</title>

<term><structfield>location_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.location"/>

</para>

</listitem>

</varlistentry>

<term><structfield>company_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.company"/>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.contact-class"

               xreflabel="public.contact_class">

        <title id="public.table.contact-class-title">

Table:

<structname>contact_class</structname>

</title>

<para>

<title>

Structure of <structname>contact_class</structname>

</title>

<type>serial</type>

<literal>UNIQUE</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>class</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on contact_class</title>

<term>contact_class_class_check</term>

            <listitem><para>CHECK ((&quot;class&quot; ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing company_to_contact via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.company-to-contact"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-contact"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.country"

               xreflabel="public.country">

        <title id="public.table.country-title">

Table:

<structname>country</structname>

</title>

<para>

<title>

Structure of <structname>country</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>short_name</structfield></term>

</para>

</listitem>

</varlistentry>

</para>

<para>

The ITU Telecommunication Standardization Sector code for calling internationally. For example, the US is 1, Great Britain is 44

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on country</title>

<term>country_name_check</term>

            <listitem><para>CHECK ((name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

<term>country_short_name_check</term>

            <listitem><para>CHECK ((short_name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing location via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.location"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.custom-field-catalog"

               xreflabel="public.custom_field_catalog">

        <title id="public.table.custom-field-catalog-title">

Table:

<structname>custom_field_catalog</structname>

</title>

<para>

<title>

Structure of <structname>custom_field_catalog</structname>

</title>

<term><structfield>field_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>table_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.custom-table-catalog"/>

</para>

</listitem>

</varlistentry>

<term><structfield>field_name</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.custom-table-catalog"

               xreflabel="public.custom_table_catalog">

        <title id="public.table.custom-table-catalog-title">

Table:

<structname>custom_table_catalog</structname>

</title>

<para>

<title>

Structure of <structname>custom_table_catalog</structname>

</title>

<term><structfield>table_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>extends</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>table_name</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing custom_field_catalog via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.custom-field-catalog"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.customer"

               xreflabel="public.customer">

        <title id="public.table.customer-title">

Table:

<structname>customer</structname>

</title>

<para>

This is now a metadata table that holds information specific to customers. Source info is not part of the entity management

</para>

<para>

<title>

Structure of <structname>customer</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

<para>

This is the relationship between entities and customers

</para>

</listitem>

</varlistentry>

<term><structfield>discount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>taxincluded</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>creditlimit</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>terms</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

<term><structfield>customernumber</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>business_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(34)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(11)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>pricegroup_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>startdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>enddate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>invoice_notes</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on customer</title>

<term>customer_customernumber_key</term>

<listitem><para>customernumber</para></listitem>

</varlistentry>

<term>customer_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.customertax"

               xreflabel="public.customertax">

        <title id="public.table.customertax-title">

Table:

<structname>customertax</structname>

</title>

<para>

<title>

Structure of <structname>customertax</structname>

</title>

<term><structfield>customer_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>chart_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on customertax</title>

<term>customer_customer_id_key</term>

<listitem><para>customer_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.defaults"

               xreflabel="public.defaults">

        <title id="public.table.defaults-title">

Table:

<structname>defaults</structname>

</title>

<para>

<title>

Structure of <structname>defaults</structname>

</title>

<term><structfield>setting_key</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>value</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.department"

               xreflabel="public.department">

        <title id="public.table.department-title">

Table:

<structname>department</structname>

</title>

<para>

<title>

Structure of <structname>department</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character(1)</type>

                <literal>DEFAULT &apos;P&apos;::bpchar</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on department</title>

<term>department_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.dpt-trans"

               xreflabel="public.dpt_trans">

        <title id="public.table.dpt-trans-title">

Table:

<structname>dpt_trans</structname>

</title>

<para>

<title>

Structure of <structname>dpt_trans</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>department_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.employee"

               xreflabel="public.employee">

        <title id="public.table.employee-title">

Table:

<structname>employee</structname>

</title>

<para>

Is a metadata table specific to employees

</para>

<para>

<title>

Structure of <structname>employee</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>login</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>startdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>enddate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sales</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(34)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(11)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>managerid</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>employeenumber</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.entity"

               xreflabel="public.entity">

        <title id="public.table.entity-title">

Table:

<structname>entity</structname>

</title>

<para>

The primary entity table to map to all contacts

</para>

<para>

<title>

Structure of <structname>entity</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</para>

<para>

This is the common name of an entity. If it was a person it may be Joshua Drake, a company Acme Corp. You may also choose to use a domain such as commandprompt.com

</para>

</listitem>

</varlistentry>

<term><structfield>entity_class</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity-class"/>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on entity</title>

<term>entity_name_check</term>

            <listitem><para>CHECK ((name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing ap via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.ap"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.ar"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.company"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.company-to-entity"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.customer"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.employee"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.entity-class-to-entity"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.entity-other-name"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.oe"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.partsvendor"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-entity"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.vendor"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.entity-class"

               xreflabel="public.entity_class">

        <title id="public.table.entity-class-title">

Table:

<structname>entity_class</structname>

</title>

<para>

Defines the class type such as vendor, customer, contact, employee

</para>

<para>

<title>

Structure of <structname>entity_class</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

<para>

The first 7 values are reserved and permanent

</para>

</listitem>

</varlistentry>

<term><structfield>class</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>active</structfield></term>

<type>boolean</type>

<literal>DEFAULT true</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on entity_class</title>

<term>entity_class_class_check</term>

            <listitem><para>CHECK ((&quot;class&quot; ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing company via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.company"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.entity"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.entity-class-to-entity"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.entity-class-to-entity"

               xreflabel="public.entity_class_to_entity">

        <title id="public.table.entity-class-to-entity-title">

Table:

<structname>entity_class_to_entity</structname>

</title>

<para>

Relation builder for classes to entity

</para>

<para>

<title>

Structure of <structname>entity_class_to_entity</structname>

</title>

<term><structfield>entity_class_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity-class"/>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.entity-other-name"

               xreflabel="public.entity_other_name">

        <title id="public.table.entity-other-name-title">

Table:

<structname>entity_other_name</structname>

</title>

<para>

Similar to company_other_name, a person may be jd, Joshua Drake, linuxpoet... all are the same person.

</para>

<para>

<title>

Structure of <structname>entity_other_name</structname>

</title>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>other_name</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on entity_other_name</title>

<term>entity_other_name_other_name_check</term>

            <listitem><para>CHECK ((other_name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.exchangerate"

               xreflabel="public.exchangerate">

        <title id="public.table.exchangerate-title">

Table:

<structname>exchangerate</structname>

</title>

<para>

<title>

Structure of <structname>exchangerate</structname>

</title>

                <type>character(3)</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on exchangerate</title>

<term>exchangerate_ct_key</term>

<listitem><para>curr, transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.gifi"

               xreflabel="public.gifi">

        <title id="public.table.gifi-title">

Table:

</title>

<para>

<title>

Structure of <structname>gifi</structname>

</title>

<term><structfield>accno</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.gl"

               xreflabel="public.gl">

        <title id="public.table.gl-title">

Table:

</title>

<para>

<title>

Structure of <structname>gl</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>reference</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>department_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on gl</title>

<term>gl_description_key</term>

<listitem><para>lower(description)</para></listitem>

</varlistentry>

</varlistentry>

<term>gl_reference_key</term>

<listitem><para>reference</para></listitem>

</varlistentry>

<term>gl_transdate_key</term>

<listitem><para>transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.inventory"

               xreflabel="public.inventory">

        <title id="public.table.inventory-title">

Table:

<structname>inventory</structname>

</title>

<para>

<title>

Structure of <structname>inventory</structname>

</title>

<term><structfield>warehouse_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>orderitems_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shippingdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.invoice"

               xreflabel="public.invoice">

        <title id="public.table.invoice-title">

Table:

<structname>invoice</structname>

</title>

<para>

<title>

Structure of <structname>invoice</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>allocated</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>fxsellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>discount</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>assemblyitem</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

                <type>character varying(5)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>project_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>deliverydate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>serialnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on invoice</title>

<term>invoice_id_key</term>

</varlistentry>

<term>invoice_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.jcitems"

               xreflabel="public.jcitems">

        <title id="public.table.jcitems-title">

Table:

<structname>jcitems</structname>

</title>

<para>

<title>

Structure of <structname>jcitems</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>project_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>allocated</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>fxsellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>serialnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>checkedin</structfield></term>

<type>timestamp with time zone</type>

</para>

</listitem>

</varlistentry>

<term><structfield>checkedout</structfield></term>

<type>timestamp with time zone</type>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on jcitems</title>

<term>jcitems_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.language"

               xreflabel="public.language">

        <title id="public.table.language-title">

Table:

<structname>language</structname>

</title>

<para>

<title>

Structure of <structname>language</structname>

</title>

                <type>character varying(6)</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.location"

               xreflabel="public.location">

        <title id="public.table.location-title">

Table:

<structname>location</structname>

</title>

<para>

<title>

Structure of <structname>location</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>line_three</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>city_province</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>country_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.country"/>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on location</title>

<term>location_city_province_check</term>

            <listitem><para>CHECK ((city_province ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

<term>location_line_one_check</term>

            <listitem><para>CHECK ((line_one ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

<term>location_mail_code_check</term>

            <listitem><para>CHECK ((mail_code ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing company via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.company"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.company-to-location"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-company"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.makemodel"

               xreflabel="public.makemodel">

        <title id="public.table.makemodel-title">

Table:

<structname>makemodel</structname>

</title>

<para>

<title>

Structure of <structname>makemodel</structname>

</title>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>model</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on makemodel</title>

<term>makemodel_make_key</term>

<listitem><para>lower(make)</para></listitem>

</varlistentry>

<term>makemodel_model_key</term>

<listitem><para>lower(model)</para></listitem>

</varlistentry>

<term>makemodel_parts_id_key</term>

<listitem><para>parts_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.oe"

               xreflabel="public.oe">

        <title id="public.table.oe-title">

Table:

</title>

<para>

<title>

Structure of <structname>oe</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>ordnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>amount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>netamount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>reqdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>taxincluded</structfield></term>

<type>boolean</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shippingpoint</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>closed</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>quotation</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>quonumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>intnotes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>department_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shipvia</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>ponumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>terms</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

<term><structfield>oe_class_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.oe-class"/>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on oe</title>

</varlistentry>

<term>oe_ordnumber_key</term>

<listitem><para>ordnumber</para></listitem>

</varlistentry>

<term>oe_transdate_key</term>

<listitem><para>transdate</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.oe-class"

               xreflabel="public.oe_class">

        <title id="public.table.oe-class-title">

Table:

<structname>oe_class</structname>

</title>

<para>

This could probably be done better. But I need to remove the customer_id/vendor_id relationship and instead rely on a classification

</para>

<para>

<title>

Structure of <structname>oe_class</structname>

</title>

<type>smallint</type>

<literal>UNIQUE</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>oe_class</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on oe_class</title>

<term>oe_class_id_check</term>

            <listitem><para>CHECK (((id = 1) OR (id = 2)))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing oe via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.oe"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.orderitems"

               xreflabel="public.orderitems">

        <title id="public.table.orderitems-title">

Table:

<structname>orderitems</structname>

</title>

<para>

<title>

Structure of <structname>orderitems</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>discount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(5)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>project_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>reqdate</structfield></term>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>serialnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on orderitems</title>

<term>orderitems_id_key</term>

</varlistentry>

<term>orderitems_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.parts"

               xreflabel="public.parts">

        <title id="public.table.parts-title">

Table:

<structname>parts</structname>

</title>

<para>

<title>

Structure of <structname>parts</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>partnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character varying(5)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>listprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>lastcost</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>priceupdate</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>weight</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>onhand</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>notes</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>makemodel</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>assembly</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>alternate</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>inventory_accno_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>income_accno_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>expense_accno_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>obsolete</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>image</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>drawing</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>microfiche</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>partsgroup_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>project_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>avgcost</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on parts</title>

<term>parts_description_key</term>

<listitem><para>lower(description)</para></listitem>

</varlistentry>

<term>parts_id_key</term>

</varlistentry>

<term>parts_partnumber_key</term>

<listitem><para>lower(partnumber)</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing partstax via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.partstax"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.partscustomer"

               xreflabel="public.partscustomer">

        <title id="public.table.partscustomer-title">

Table:

<structname>partscustomer</structname>

</title>

<para>

<title>

Structure of <structname>partscustomer</structname>

</title>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>customer_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>pricegroup_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>pricebreak</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>sellprice</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>validfrom</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>validto</structfield></term>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.partsgroup"

               xreflabel="public.partsgroup">

        <title id="public.table.partsgroup-title">

Table:

<structname>partsgroup</structname>

</title>

<para>

<title>

Structure of <structname>partsgroup</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>partsgroup</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on partsgroup</title>

<term>partsgroup_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.partstax"

               xreflabel="public.partstax">

        <title id="public.table.partstax-title">

Table:

<structname>partstax</structname>

</title>

<para>

<title>

Structure of <structname>partstax</structname>

</title>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.parts"/>

</para>

</listitem>

</varlistentry>

<term><structfield>chart_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.chart"/>

</para>

</listitem>

</varlistentry>

<term><structfield>taxcategory_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.taxcategory"/>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on partstax</title>

<term>partstax_parts_id_key</term>

<listitem><para>parts_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.partsvendor"

               xreflabel="public.partsvendor">

        <title id="public.table.partsvendor-title">

Table:

<structname>partsvendor</structname>

</title>

<para>

<title>

Structure of <structname>partsvendor</structname>

</title>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>partnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>leadtime</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

<term><structfield>lastcost</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on partsvendor</title>

<term>partsvendor_parts_id_key</term>

<listitem><para>parts_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.person"

               xreflabel="public.person">

        <title id="public.table.person-title">

Table:

<structname>person</structname>

</title>

<para>

Every person, must have an entity to derive a common or display name. The correct way to get class information on a person would be person.entity_id->entity_class_to_entity.entity_id.

</para>

<para>

<title>

Structure of <structname>person</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>salutation_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.salutation"/>

</para>

</listitem>

</varlistentry>

<term><structfield>first_name</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>middle_name</structfield></term>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>primary_location_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.location"/>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on person</title>

<term>person_first_name_check</term>

            <listitem><para>CHECK ((first_name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

<term>person_last_name_check</term>

            <listitem><para>CHECK ((last_name ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing ap via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.ap"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.ar"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.audittrail"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.gl"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.inventory"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.jcitems"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.oe"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-company"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-contact"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.person-to-entity"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.person-to-company"

               xreflabel="public.person_to_company">

        <title id="public.table.person-to-company-title">

Table:

<structname>person_to_company</structname>

</title>

<para>

<title>

Structure of <structname>person_to_company</structname>

</title>

<term><structfield>location_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.location"/>

</para>

</listitem>

</varlistentry>

<term><structfield>person_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.person-to-contact"

               xreflabel="public.person_to_contact">

        <title id="public.table.person-to-contact-title">

Table:

<structname>person_to_contact</structname>

</title>

<para>

To keep track of the relationship between multiple contact methods and a single individual

</para>

<para>

<title>

Structure of <structname>person_to_contact</structname>

</title>

<term><structfield>person_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>contact_class_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.contact-class"/>

</para>

</listitem>

</varlistentry>

<term><structfield>contact</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on person_to_contact</title>

<term>person_to_contact_contact_check</term>

            <listitem><para>CHECK ((contact ~ &apos;[[:alnum:]_]&apos;::text))</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.person-to-entity"

               xreflabel="public.person_to_entity">

        <title id="public.table.person-to-entity-title">

Table:

<structname>person_to_entity</structname>

</title>

<para>

<title>

Structure of <structname>person_to_entity</structname>

</title>

<term><structfield>person_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.person"/>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>related_how</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>created</structfield></term>

                <literal>DEFAULT (&apos;now&apos;::text)::date</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Constraints on person_to_entity</title>

<term>person_to_entity_check</term>

            <listitem><para>CHECK ((entity_id &lt;&gt; person_id))</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.pricegroup"

               xreflabel="public.pricegroup">

        <title id="public.table.pricegroup-title">

Table:

<structname>pricegroup</structname>

</title>

<para>

<title>

Structure of <structname>pricegroup</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>pricegroup</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on pricegroup</title>

<term>pricegroup_id_key</term>

</varlistentry>

<term>pricegroup_pricegroup_key</term>

<listitem><para>pricegroup</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.project"

               xreflabel="public.project">

        <title id="public.table.project-title">

Table:

<structname>project</structname>

</title>

<para>

<title>

Structure of <structname>project</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>projectnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>startdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>enddate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>parts_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>production</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>completed</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>customer_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on project</title>

<term>project_id_key</term>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.recurring"

               xreflabel="public.recurring">

        <title id="public.table.recurring-title">

Table:

<structname>recurring</structname>

</title>

<para>

<title>

Structure of <structname>recurring</structname>

</title>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>reference</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>startdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>nextdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>enddate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>repeat</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>howmany</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>payment</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.recurringemail"

               xreflabel="public.recurringemail">

        <title id="public.table.recurringemail-title">

Table:

<structname>recurringemail</structname>

</title>

<para>

<title>

Structure of <structname>recurringemail</structname>

</title>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>formname</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>format</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>message</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.recurringprint"

               xreflabel="public.recurringprint">

        <title id="public.table.recurringprint-title">

Table:

<structname>recurringprint</structname>

</title>

<para>

<title>

Structure of <structname>recurringprint</structname>

</title>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>formname</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>format</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>printer</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.salutation"

               xreflabel="public.salutation">

        <title id="public.table.salutation-title">

Table:

<structname>salutation</structname>

</title>

<para>

<title>

Structure of <structname>salutation</structname>

</title>

<type>serial</type>

<literal>UNIQUE</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>salutation</structfield></term>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing person via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.person"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.shipto"

               xreflabel="public.shipto">

        <title id="public.table.shipto-title">

Table:

<structname>shipto</structname>

</title>

<para>

<title>

Structure of <structname>shipto</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptoname</structfield></term>

                <type>character varying(64)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptoaddress1</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptoaddress2</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptocity</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptostate</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptozipcode</structfield></term>

                <type>character varying(10)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptocountry</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptocontact</structfield></term>

                <type>character varying(64)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptophone</structfield></term>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptofax</structfield></term>

                <type>character varying(20)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>shiptoemail</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>entry_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on shipto</title>

<term>shipto_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.sic"

               xreflabel="public.sic">

        <title id="public.table.sic-title">

Table:

</title>

<para>

<title>

Structure of <structname>sic</structname>

</title>

                <type>character varying(6)</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>sictype</structfield></term>

                <type>character(1)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.status"

               xreflabel="public.status">

        <title id="public.table.status-title">

Table:

<structname>status</structname>

</title>

<para>

<title>

Structure of <structname>status</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>formname</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>printed</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>emailed</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>spoolfile</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on status</title>

<term>status_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.tax"

               xreflabel="public.tax">

        <title id="public.table.tax-title">

Table:

</title>

<para>

<title>

Structure of <structname>tax</structname>

</title>

<term><structfield>chart_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.chart"/>

</para>

</listitem>

</varlistentry>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>taxnumber</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>validto</structfield></term>

</para>

</listitem>

</varlistentry>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>taxmodule_id</structfield></term>

<type>integer</type>

                <literal>DEFAULT 1</literal>

                <literal>REFERENCES</literal> <xref linkend="public.table.taxmodule"/>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.taxcategory"

               xreflabel="public.taxcategory">

        <title id="public.table.taxcategory-title">

Table:

<structname>taxcategory</structname>

</title>

<para>

<title>

Structure of <structname>taxcategory</structname>

</title>

<term><structfield>taxcategory_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>taxcategoryname</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>taxmodule_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.taxmodule"/>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing partstax via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.partstax"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.taxmodule"

               xreflabel="public.taxmodule">

        <title id="public.table.taxmodule-title">

Table:

<structname>taxmodule</structname>

</title>

<para>

<title>

Structure of <structname>taxmodule</structname>

</title>

<term><structfield>taxmodule_id</structfield></term>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>taxmodulename</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>

Tables referencing tax via Foreign Key Constraints

</title>

<para>

              <xref linkend="public.table.tax"/>

</para>

</listitem>

<para>

              <xref linkend="public.table.taxcategory"/>

</para>

</listitem>

</itemizedlist>

</para>

</section>

      <section id="public.table.transactions"

               xreflabel="public.transactions">

        <title id="public.table.transactions-title">

Table:

<structname>transactions</structname>

</title>

<para>

<title>

Structure of <structname>transactions</structname>

</title>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>table_name</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.translation"

               xreflabel="public.translation">

        <title id="public.table.translation-title">

Table:

<structname>translation</structname>

</title>

<para>

<title>

Structure of <structname>translation</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on translation</title>

<term>translation_trans_id_key</term>

<listitem><para>trans_id</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.vendor"

               xreflabel="public.vendor">

        <title id="public.table.vendor-title">

Table:

<structname>vendor</structname>

</title>

<para>

Now a meta data table

</para>

<para>

<title>

Structure of <structname>vendor</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>entity_id</structfield></term>

<type>integer</type>

                <literal>REFERENCES</literal> <xref linkend="public.table.entity"/>

</para>

</listitem>

</varlistentry>

<term><structfield>terms</structfield></term>

<type>smallint</type>

</para>

</listitem>

</varlistentry>

<term><structfield>taxincluded</structfield></term>

<type>boolean</type>

<literal>DEFAULT false</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>vendornumber</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

</para>

</listitem>

</varlistentry>

<term><structfield>gifi_accno</structfield></term>

                <type>character varying(30)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>business_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

<term><structfield>taxnumber</structfield></term>

                <type>character varying(32)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>discount</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

<term><structfield>creditlimit</structfield></term>

<type>numeric</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(34)</type>

</para>

</listitem>

</varlistentry>

                <type>character varying(11)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>language_code</structfield></term>

                <type>character varying(6)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>pricegroup_id</structfield></term>

<type>integer</type>

</para>

</listitem>

</varlistentry>

                <type>character(3)</type>

</para>

</listitem>

</varlistentry>

<term><structfield>startdate</structfield></term>

</para>

</listitem>

</varlistentry>

<term><structfield>enddate</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

<title>Indexes on vendor</title>

<term>vendor_id_key</term>

</varlistentry>

<term>vendor_vendornumber_key</term>

<listitem><para>vendornumber</para></listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.vendortax"

               xreflabel="public.vendortax">

        <title id="public.table.vendortax-title">

Table:

<structname>vendortax</structname>

</title>

<para>

<title>

Structure of <structname>vendortax</structname>

</title>

<term><structfield>vendor_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>chart_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.warehouse"

               xreflabel="public.warehouse">

        <title id="public.table.warehouse-title">

Table:

<structname>warehouse</structname>

</title>

<para>

<title>

Structure of <structname>warehouse</structname>

</title>

<type>serial</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>description</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

      <section id="public.table.yearend"

               xreflabel="public.yearend">

        <title id="public.table.yearend-title">

Table:

<structname>yearend</structname>

</title>

<para>

<title>

Structure of <structname>yearend</structname>

</title>

<term><structfield>trans_id</structfield></term>

<type>integer</type>

<literal>PRIMARY KEY</literal>

</para>

</listitem>

</varlistentry>

<term><structfield>transdate</structfield></term>

</para>

</listitem>

</varlistentry>

</variablelist>

</para>

</section>

    <section id="public.function.add-custom-field-character-varying-character-varying-character-varying"

             xreflabel="publicadd_custom_field( character varying, character varying, character varying )">

      <title id="public.function.add-custom-field-character-varying-character-varying-character-varying-title">


context:
space:
mode: