Merge commit 'dkg/master' - monkeysphere - Unnamed repository; edit this file 'description' to name the repository.

diff options

author	Jameson Graef Rollins <jrollins@phys.columbia.edu>	2008-08-16 10:08:24 -0700
committer	Jameson Graef Rollins <jrollins@phys.columbia.edu>	2008-08-16 10:08:24 -0700
commit	9d31bf789228de4126164e4349f19f288c9e7bb0 (patch)
tree	326254a47634c2ba45fcde7e3cb00023d4eec955 /man/man8
parent	1a17d5082447dd76f52df929bfe2f0855512c9f9 (diff)
parent	ae661bf9fd9ce62069a99bb9de16df8b44beee8a (diff)

Merge commit 'dkg/master'

Diffstat (limited to 'man/man8')

0 files changed, 0 insertions, 0 deletions

hl kwa">font-size: 10pt;

}

.error {

        color: #FFFFFF;

        background-color: #FF0000;

}

    H1, H2, H3, H4, H5, H6 {

}

OL {

        list-style-type: upper-alpha;

}

UL.topic {

        list-style-type: upper-alpha;

}

LI.topic {

        font-weight : bold;

}

HR {

        color: #00FF00;

        background-color: #808080;

}

TABLE {

        border-width: medium;

        padding: 3px;

        background-color: #000000;

        width: 90%;

}

CAPTION {

        text-transform: capitalize;

        font-weight : bold;

        font-size: 14pt;

}

TH {

        color: #FFFFFF;

        background-color: #000000;

        text-align: left;

}

TR {

        color: #000000;

        background-color: #000000;

        vertical-align: top;

}

TR.tr0 {

        background-color: #F0F0F0;

}

TR.tr1 {

        background-color: #D8D8D8;

}

TD {

        font-size: 12pt;

}

TD.col0 {

        font-weight : bold;

        width: 20%;

}

TD.col1 {

        font-style: italic;

        width: 15%;

}

TD.col2 {

        font-size: 12px;

}

</style>

    <link rel="stylesheet" type="text/css" media="all" href="all.css">

    <link rel="stylesheet" type="text/css" media="screen" href="screen.css">

    <link rel="stylesheet" type="text/css" media="print" href="print.css">

    <meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

</head>

<body>

    <p><br><br>Dumped on 2007-03-22</p>

<h1><a name="index">Index of database - ledgersmb</a></h1>

<ul>

    <li><a name="public.schema">public</a></li><ul>

        <li><a href="#public.table.acc-trans">acc_trans</a></li><li><a href="#public.table.ap">ap</a></li><li><a href="#public.table.ar">ar</a></li><li><a href="#public.table.assembly">assembly</a></li><li><a href="#public.table.audittrail">audittrail</a></li><li><a href="#public.table.business">business</a></li><li><a href="#public.table.chart">chart</a></li><li><a href="#public.table.custom-field-catalog">custom_field_catalog</a></li><li><a href="#public.table.custom-table-catalog">custom_table_catalog</a></li><li><a href="#public.table.customer">customer</a></li><li><a href="#public.table.customertax">customertax</a></li><li><a href="#public.table.defaults">defaults</a></li><li><a href="#public.table.department">department</a></li><li><a href="#public.table.dpt-trans">dpt_trans</a></li><li><a href="#public.table.employee">employee</a></li><li><a href="#public.table.exchangerate">exchangerate</a></li><li><a href="#public.table.gifi">gifi</a></li><li><a href="#public.table.gl">gl</a></li><li><a href="#public.table.inventory">inventory</a></li><li><a href="#public.table.invoice">invoice</a></li><li><a href="#public.table.jcitems">jcitems</a></li><li><a href="#public.table.language">language</a></li><li><a href="#public.table.makemodel">makemodel</a></li><li><a href="#public.table.oe">oe</a></li><li><a href="#public.table.orderitems">orderitems</a></li><li><a href="#public.table.parts">parts</a></li><li><a href="#public.table.partscustomer">partscustomer</a></li><li><a href="#public.table.partsgroup">partsgroup</a></li><li><a href="#public.table.partstax">partstax</a></li><li><a href="#public.table.partsvendor">partsvendor</a></li><li><a href="#public.table.pricegroup">pricegroup</a></li><li><a href="#public.table.project">project</a></li><li><a href="#public.table.recurring">recurring</a></li><li><a href="#public.table.recurringemail">recurringemail</a></li><li><a href="#public.table.recurringprint">recurringprint</a></li><li><a href="#public.table.shipto">shipto</a></li><li><a href="#public.table.sic">sic</a></li><li><a href="#public.table.status">status</a></li><li><a href="#public.table.tax">tax</a></li><li><a href="#public.table.taxcategory">taxcategory</a></li><li><a href="#public.table.taxmodule">taxmodule</a></li><li><a href="#public.table.transactions">transactions</a></li><li><a href="#public.table.translation">translation</a></li><li><a href="#public.table.vendor">vendor</a></li><li><a href="#public.table.vendortax">vendortax</a></li><li><a href="#public.table.warehouse">warehouse</a></li><li><a href="#public.table.yearend">yearend</a></li>

    <li><a href="#public.function.add-custom-field-character-varying-character-varying-character-varying">add_custom_field( character varying, character varying, character varying )</a></li><li><a href="#public.function.avgcost-integer">avgcost( integer )</a></li><li><a href="#public.function.check-department">check_department(  )</a></li><li><a href="#public.function.check-inventory">check_inventory(  )</a></li><li><a href="#public.function.del-customer">del_customer(  )</a></li><li><a href="#public.function.del-department">del_department(  )</a></li><li><a href="#public.function.del-exchangerate">del_exchangerate(  )</a></li><li><a href="#public.function.del-recurring">del_recurring(  )</a></li><li><a href="#public.function.del-vendor">del_vendor(  )</a></li><li><a href="#public.function.del-yearend">del_yearend(  )</a></li><li><a href="#public.function.drop-custom-field-character-varying-character-varying">drop_custom_field( character varying, character varying )</a></li><li><a href="#public.function.lastcost-integer">lastcost( integer )</a></li><li><a href="#public.function.trigger-parts-short">trigger_parts_short(  )</a></li><li><a href="#public.function.update-user-integer-text">update_user( integer, text )</a></li>

</ul>

<hr>

<h2>Table:

            <a name="public.table.acc-trans">acc_trans</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>acc_trans Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>trans_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

                  <a href="#public.table.chart">chart.id</a>

</td>

<td>chart_id</td>

<td>integer</td>

<td>

NOT NULL

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>source</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>cleared</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>fx_transaction</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>project_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invoice_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>entry_id</td>

<td>serial</td>

<td>

PRIMARY KEY

</td>

</tr>

</table>

acc_trans_chart_id_key chart_id

acc_trans_source_key lower(source)

acc_trans_trans_id_key trans_id

acc_trans_transdate_key transdate

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.ap">ap</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>ap Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>integer</td>

<td>

PRIMARY KEY

DEFAULT nextval('id'::regclass)

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>vendor_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>taxincluded</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>netamount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>datepaid</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>duedate</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>invoice</td>

<td>boolean</td>

<td>

DEFAULT false

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ordnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

                <td>character(3)</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>notes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>employee_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

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

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>quonumber</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>intnotes</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>department_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>shipvia</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>language_code</td>

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

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>ponumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>shippingpoint</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>terms</td>

<td>smallint</td>

<td>

</td>

</tr>

</table>

ap_employee_id_key employee_id

ap_id_key id

ap_invnumber_key invnumber

ap_ordnumber_key ordnumber

ap_quonumber_key quonumber

ap_transdate_key transdate

ap_vendor_id_key vendor_id

        <a href="#index">Index</a> -

        <a href="#public.schema">Schema public</a>

<hr>

<h2>Table:

            <a name="public.table.ar">ar</a>

</h2>

        <table width="100%" cellspacing="0" cellpadding="3">

<caption>ar Structure</caption>

<tr>

<th>Description</th>

</tr>

            <tr class="tr0">

<td>

</td>

<td>integer</td>

<td>

PRIMARY KEY

DEFAULT nextval('id'::regclass)

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>invnumber</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>transdate</td>

<td>

DEFAULT ('now'::text)::date

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>customer_id</td>

<td>integer</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>

<td>taxincluded</td>

<td>boolean</td>

<td>

</td>

</tr>

            <tr class="tr1">

<td>

</td>

<td>amount</td>

<td>numeric</td>

<td>

</td>

</tr>

            <tr class="tr0">

<td>

</td>


context:
space:
mode: