From ef056eb05078c4acc4138e59244d71a810945af9 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Mon, 7 May 2007 06:06:38 +0000 Subject: Adding db documentation to /trunk/ git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1147 4979c152-3d1c-0410-bac9-87ea11338e46 --- doc/database/ledgersmb.dia | 14123 +++++++++++++++++++++++++++++++++++ doc/database/ledgersmb.dot | 118 + doc/database/ledgersmb.html | 9495 ++++++++++++++++++++++++ doc/database/ledgersmb.neato | 110 + doc/database/ledgersmb.xml | 9721 ++++++++++++++++++++++++ doc/database/ledgersmb.zigzag.dia | 14219 ++++++++++++++++++++++++++++++++++++ 6 files changed, 47786 insertions(+) create mode 100644 doc/database/ledgersmb.dia create mode 100644 doc/database/ledgersmb.dot create mode 100644 doc/database/ledgersmb.html create mode 100644 doc/database/ledgersmb.neato create mode 100644 doc/database/ledgersmb.xml create mode 100644 doc/database/ledgersmb.zigzag.dia (limited to 'doc') diff --git a/doc/database/ledgersmb.dia b/doc/database/ledgersmb.dia new file mode 100644 index 00000000..6972d12b --- /dev/null +++ b/doc/database/ledgersmb.dia @@ -0,0 +1,14123 @@ + + + + + + + + + + + + + + + + + + + + + + + + #acc_trans# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # source# + + + #text# + + + + + + + + + + + + + + + + + + + + # cleared# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # fx_transaction# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # memo# + + + #text# + + + + + + + + + + + + + + + + + + + + # invoice_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ap# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # invnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # paid# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # datepaid# + + + #date# + + + + + + + + + + + + + + + + + + + + # duedate# + + + #date# + + + + + + + + + + + + + + + + + + + + # invoice# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # till# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ar# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # invnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # paid# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # datepaid# + + + #date# + + + + + + + + + + + + + + + + + + + + # duedate# + + + #date# + + + + + + + + + + + + + + + + + + + + # invoice# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # till# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #assembly# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # bom# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # adj# + + + #boolean# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #audittrail# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # tablename# + + + #text# + + + + + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # action# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #timestamp without time zone# + + + + #now()# + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #bigserial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #business# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #chart# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # charttype# + + + #character(1)# + + + + #'A'::bpchar# + + + + + + + + + + + + + + + + # category# + + + #character(1)# + + + + + + + + + + + + + + + + + + + + # link# + + + #text# + + + + + + + + + + + + + + + + + + + + # gifi_accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # contra# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_field_catalog# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # field_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # table_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # field_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_table_catalog# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # table_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # extends# + + + #text# + + + + + + + + + + + + + + + + + + + + # table_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #customer# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # contact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # phone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # fax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # creditlimit# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # customernumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # cc# + + + #text# + + + + + + + + + + + + + + + + + + + + # bcc# + + + #text# + + + + + + + + + + + + + + + + + + + + # business_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # sic_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #customertax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #defaults# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # setting_key# + + + #text# + + + + + + + + + + + + + + + + + + + + # value# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #department# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # role# + + + #character(1)# + + + + #'P'::bpchar# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #dpt_trans# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #employee# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # login# + + + #text# + + + + + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # workphone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # homephone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # role# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # sales# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # ssn# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # managerid# + + + #integer# + + + + + + + + + + + + + + + + + + + + # employeenumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # dob# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #exchangerate# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # buy# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sell# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #gifi# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #gl# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #inventory# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # warehouse_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # orderitems_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # shippingdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #invoice# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('invoicei ... lass)# + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #integer# + + + + + + + + + + + + + + + + + + + + # allocated# + + + #integer# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # fxsellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # discount# + + + #real# + + + + + + + + + + + + + + + + + + + + # assemblyitem# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # deliverydate# + + + #date# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #jcitems# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('jcitemsi ... lass)# + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # allocated# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # fxsellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # checkedin# + + + #timestamp with time zone# + + + + + + + + + + + + + + + + + + + + # checkedout# + + + #timestamp with time zone# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #language# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #makemodel# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # make# + + + #text# + + + + + + + + + + + + + + + + + + + + # model# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #oe# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # reqdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # closed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # quotation# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #orderitems# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('orderite ... lass)# + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # reqdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # ship# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #parts# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # partnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # listprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # lastcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # priceupdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # weight# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # onhand# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # makemodel# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # assembly# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # alternate# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # rop# + + + #real# + + + + + + + + + + + + + + + + + + + + # inventory_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # income_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # expense_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # bin# + + + #text# + + + + + + + + + + + + + + + + + + + + # obsolete# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # bom# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # image# + + + #text# + + + + + + + + + + + + + + + + + + + + # drawing# + + + #text# + + + + + + + + + + + + + + + + + + + + # microfiche# + + + #text# + + + + + + + + + + + + + + + + + + + + # partsgroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # avgcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partscustomer# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # pricebreak# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # validfrom# + + + #date# + + + + + + + + + + + + + + + + + + + + # validto# + + + #date# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partsgroup# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # partsgroup# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxcategory_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partsvendor# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # partnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # leadtime# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # lastcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #pricegroup# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # pricegroup# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #project# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # projectnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # production# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # completed# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurring# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # nextdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # repeat# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # howmany# + + + #integer# + + + + + + + + + + + + + + + + + + + + # payment# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurringemail# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # format# + + + #text# + + + + + + + + + + + + + + + + + + + + # message# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurringprint# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # format# + + + #text# + + + + + + + + + + + + + + + + + + + + # printer# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #shipto# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shiptoname# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # shiptoaddress1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptoaddress2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptocity# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptostate# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptozipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # shiptocountry# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptocontact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # shiptophone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # shiptofax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # shiptoemail# + + + #text# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #sic# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # sictype# + + + #character(1)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #status# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # printed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # emailed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # spoolfile# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #tax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # rate# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # validto# + + + #date# + + + + + + + + + + + + + + + + + + + + # pass# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #integer# + + + + #1# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #taxcategory# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # taxcategory_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # taxcategoryname# + + + #text# + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #taxmodule# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # taxmodulename# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #transactions# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # table_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #translation# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #vendor# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # contact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # phone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # fax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # vendornumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # cc# + + + #text# + + + + + + + + + + + + + + + + + + + + # bcc# + + + #text# + + + + + + + + + + + + + + + + + + + + # gifi_accno# + + + #character varying(30)# + + + + + + + + + + + + + + + + + + + + # business_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # sic_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # creditlimit# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #vendortax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #warehouse# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #yearend# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #acc_trans_chart_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_field_catalog_table_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_parts_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_chart_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_taxcategory_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #tax_chart_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #tax_taxmodule_id_fkey# + + + + + + + + + + + + + + + + + + + + + + + + + + #taxcategory_taxmodule_id_fkey# + + + + + + + + + + + + + + + diff --git a/doc/database/ledgersmb.dot b/doc/database/ledgersmb.dot new file mode 100644 index 00000000..96c7749e --- /dev/null +++ b/doc/database/ledgersmb.dot @@ -0,0 +1,118 @@ +digraph g { +graph [ +rankdir = "LR", +concentrate = true, +ratio = auto +]; +node [ +fontsize = "10", +shape = record +]; +edge [ +]; + +"acc_trans" [shape = plaintext, label = <
\N
trans_id integer
chart_id integer FK
amount numeric
transdate date
source text
cleared boolean
fx_transaction boolean
project_id integer
memo text
invoice_id integer
entry_id serial PK
> ]; + +"ap" [shape = plaintext, label = <
\N
id integer PK
invnumber text
transdate date
vendor_id integer
taxincluded boolean
amount numeric
netamount numeric
paid numeric
datepaid date
duedate date
invoice boolean
ordnumber text
curr character(3)
notes text
employee_id integer
till character varying(20)
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
shippingpoint text
terms smallint
> ]; + +"ar" [shape = plaintext, label = <
\N
id integer PK
invnumber text
transdate date
customer_id integer
taxincluded boolean
amount numeric
netamount numeric
paid numeric
datepaid date
duedate date
invoice boolean
shippingpoint text
terms smallint
notes text
curr character(3)
ordnumber text
employee_id integer
till character varying(20)
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
> ]; + +"assembly" [shape = plaintext, label = <
\N
id integer PK
parts_id integer PK
qty numeric
bom boolean
adj boolean
> ]; + +"audittrail" [shape = plaintext, label = <
\N
trans_id integer
tablename text
reference text
formname text
action text
transdate timestamp without time zone
employee_id integer
entry_id bigserial PK
> ]; + +"business" [shape = plaintext, label = <
\N
id integer PK
description text
discount numeric
> ]; + +"chart" [shape = plaintext, label = <
\N
id integer PK
accno text
description text
charttype character(1)
category character(1)
link text
gifi_accno text
contra boolean
> ]; + +"custom_field_catalog" [shape = plaintext, label = <
\N
field_id serial PK
table_id integer FK
field_name text
> ]; + +"custom_table_catalog" [shape = plaintext, label = <
\N
table_id serial PK
extends text
table_name text
> ]; + +"customer" [shape = plaintext, label = <
\N
id integer PK
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
contact character varying(64)
phone character varying(20)
fax character varying(20)
email text
notes text
discount numeric
taxincluded boolean
creditlimit numeric
terms smallint
customernumber character varying(32)
cc text
bcc text
business_id integer
taxnumber character varying(32)
sic_code character varying(6)
iban character varying(34)
bic character varying(11)
employee_id integer
language_code character varying(6)
pricegroup_id integer
curr character(3)
startdate date
enddate date
> ]; + +"customertax" [shape = plaintext, label = <
\N
customer_id integer PK
chart_id integer PK
> ]; + +"defaults" [shape = plaintext, label = <
\N
setting_key text PK
value text
> ]; + +"department" [shape = plaintext, label = <
\N
id integer PK
description text
role character(1)
> ]; + +"dpt_trans" [shape = plaintext, label = <
\N
trans_id integer PK
department_id integer
> ]; + +"employee" [shape = plaintext, label = <
\N
id integer PK
login text
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
workphone character varying(20)
homephone character varying(20)
startdate date
enddate date
notes text
role character varying(20)
sales boolean
email text
ssn character varying(20)
iban character varying(34)
bic character varying(11)
managerid integer
employeenumber character varying(32)
dob date
> ]; + +"exchangerate" [shape = plaintext, label = <
\N
curr character(3) PK
transdate date PK
buy numeric
sell numeric
> ]; + +"gifi" [shape = plaintext, label = <
\N
accno text PK
description text
> ]; + +"gl" [shape = plaintext, label = <
\N
id integer PK
reference text
description text
transdate date
employee_id integer
notes text
department_id integer
> ]; + +"inventory" [shape = plaintext, label = <
\N
warehouse_id integer
parts_id integer
trans_id integer
orderitems_id integer
qty numeric
shippingdate date
employee_id integer
entry_id serial PK
> ]; + +"invoice" [shape = plaintext, label = <
\N
id integer PK
trans_id integer
parts_id integer
description text
qty integer
allocated integer
sellprice numeric
fxsellprice numeric
discount real
assemblyitem boolean
unit character varying(5)
project_id integer
deliverydate date
serialnumber text
notes text
> ]; + +"jcitems" [shape = plaintext, label = <
\N
id integer PK
project_id integer
parts_id integer
description text
qty numeric
allocated numeric
sellprice numeric
fxsellprice numeric
serialnumber text
checkedin timestamp with time zone
checkedout timestamp with time zone
employee_id integer
notes text
> ]; + +"language" [shape = plaintext, label = <
\N
code character varying(6) PK
description text
> ]; + +"makemodel" [shape = plaintext, label = <
\N
parts_id integer PK
make text
model text
> ]; + +"oe" [shape = plaintext, label = <
\N
id integer PK
ordnumber text
transdate date
vendor_id integer
customer_id integer
amount numeric
netamount numeric
reqdate date
taxincluded boolean
shippingpoint text
notes text
curr character(3)
employee_id integer
closed boolean
quotation boolean
quonumber text
intnotes text
department_id integer
shipvia text
language_code character varying(6)
ponumber text
terms smallint
> ]; + +"orderitems" [shape = plaintext, label = <
\N
id integer PK
trans_id integer
parts_id integer
description text
qty numeric
sellprice numeric
discount numeric
unit character varying(5)
project_id integer
reqdate date
ship numeric
serialnumber text
notes text
> ]; + +"parts" [shape = plaintext, label = <
\N
id integer PK
partnumber text
description text
unit character varying(5)
listprice numeric
sellprice numeric
lastcost numeric
priceupdate date
weight numeric
onhand numeric
notes text
makemodel boolean
assembly boolean
alternate boolean
rop real
inventory_accno_id integer
income_accno_id integer
expense_accno_id integer
bin text
obsolete boolean
bom boolean
image text
drawing text
microfiche text
partsgroup_id integer
project_id integer
avgcost numeric
> ]; + +"partscustomer" [shape = plaintext, label = <
\N
parts_id integer
customer_id integer
pricegroup_id integer
pricebreak numeric
sellprice numeric
validfrom date
validto date
curr character(3)
entry_id serial PK
> ]; + +"partsgroup" [shape = plaintext, label = <
\N
id integer PK
partsgroup text
> ]; + +"partstax" [shape = plaintext, label = <
\N
parts_id integer PK FK
chart_id integer PK FK
taxcategory_id integer FK
> ]; + +"partsvendor" [shape = plaintext, label = <
\N
vendor_id integer
parts_id integer
partnumber text
leadtime smallint
lastcost numeric
curr character(3)
entry_id serial PK
> ]; + +"pricegroup" [shape = plaintext, label = <
\N
id integer PK
pricegroup text
> ]; + +"project" [shape = plaintext, label = <
\N
id integer PK
projectnumber text
description text
startdate date
enddate date
parts_id integer
production numeric
completed numeric
customer_id integer
> ]; + +"recurring" [shape = plaintext, label = <
\N
id integer PK
reference text
startdate date
nextdate date
enddate date
repeat smallint
unit character varying(6)
howmany integer
payment boolean
> ]; + +"recurringemail" [shape = plaintext, label = <
\N
id integer PK
formname text
format text
message text
> ]; + +"recurringprint" [shape = plaintext, label = <
\N
id integer PK
formname text
format text
printer text
> ]; + +"shipto" [shape = plaintext, label = <
\N
trans_id integer
shiptoname character varying(64)
shiptoaddress1 character varying(32)
shiptoaddress2 character varying(32)
shiptocity character varying(32)
shiptostate character varying(32)
shiptozipcode character varying(10)
shiptocountry character varying(32)
shiptocontact character varying(64)
shiptophone character varying(20)
shiptofax character varying(20)
shiptoemail text
entry_id serial PK
> ]; + +"sic" [shape = plaintext, label = <
\N
code character varying(6) PK
sictype character(1)
description text
> ]; + +"status" [shape = plaintext, label = <
\N
trans_id integer PK
formname text
printed boolean
emailed boolean
spoolfile text
> ]; + +"tax" [shape = plaintext, label = <
\N
chart_id integer PK FK
rate numeric
taxnumber text
validto date
pass integer
taxmodule_id integer FK
> ]; + +"taxcategory" [shape = plaintext, label = <
\N
taxcategory_id serial PK
taxcategoryname text
taxmodule_id integer FK
> ]; + +"taxmodule" [shape = plaintext, label = <
\N
taxmodule_id serial PK
taxmodulename text
> ]; + +"transactions" [shape = plaintext, label = <
\N
id integer PK
table_name text
> ]; + +"translation" [shape = plaintext, label = <
\N
trans_id integer PK
language_code character varying(6) PK
description text
> ]; + +"vendor" [shape = plaintext, label = <
\N
id integer PK
name character varying(64)
address1 character varying(32)
address2 character varying(32)
city character varying(32)
state character varying(32)
zipcode character varying(10)
country character varying(32)
contact character varying(64)
phone character varying(20)
fax character varying(20)
email text
notes text
terms smallint
taxincluded boolean
vendornumber character varying(32)
cc text
bcc text
gifi_accno character varying(30)
business_id integer
taxnumber character varying(32)
sic_code character varying(6)
discount numeric
creditlimit numeric
iban character varying(34)
bic character varying(11)
employee_id integer
language_code character varying(6)
pricegroup_id integer
curr character(3)
startdate date
enddate date
> ]; + +"vendortax" [shape = plaintext, label = <
\N
vendor_id integer PK
chart_id integer PK
> ]; + +"warehouse" [shape = plaintext, label = <
\N
id integer PK
description text
> ]; + +"yearend" [shape = plaintext, label = <
\N
trans_id integer PK
transdate date
> ]; + + + +"acc_trans":rtcol2 -> "chart":ltcol1 [label="acc_trans_chart_id_fkey"]; +"custom_field_catalog":rtcol2 -> "custom_table_catalog":ltcol1 [label="custom_field_catalog_table_id_fkey"]; +"partstax":rtcol1 -> "parts":ltcol1 [label="partstax_parts_id_fkey"]; +"partstax":rtcol2 -> "chart":ltcol1 [label="partstax_chart_id_fkey"]; +"partstax":rtcol3 -> "taxcategory":ltcol1 [label="partstax_taxcategory_id_fkey"]; +"tax":rtcol1 -> "chart":ltcol1 [label="tax_chart_id_fkey"]; +"tax":rtcol6 -> "taxmodule":ltcol1 [label="tax_taxmodule_id_fkey"]; +"taxcategory":rtcol3 -> "taxmodule":ltcol1 [label="taxcategory_taxmodule_id_fkey"]; +} diff --git a/doc/database/ledgersmb.html b/doc/database/ledgersmb.html new file mode 100644 index 00000000..1011d507 --- /dev/null +++ b/doc/database/ledgersmb.html @@ -0,0 +1,9495 @@ + + + + + + Index for ledgersmb + + + + + + + + + + +



Dumped on 2007-03-22

+

Index of database - ledgersmb

+ + + + + + + +
+

Table: + acc_trans +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
acc_trans Structure
F-KeyNameTypeDescription
+ + trans_idinteger + + + + + + +
+ + + chart.id + + + chart_idinteger + + + + + + + NOT NULL + + + +
+ + amountnumeric + + + + + + +
+ + transdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + sourcetext + + + + + + +
+ + clearedboolean + + + + DEFAULT false + + +
+ + fx_transactionboolean + + + + DEFAULT false + + +
+ + project_idinteger + + + + + + +
+ + memotext + + + + + + +
+ + invoice_idinteger + + + + + + +
+ + + + entry_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + 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 + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + ap +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ap Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + invnumbertext + + + + + + +
+ + transdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + vendor_idinteger + + + + + + +
+ + taxincludedboolean + + + + DEFAULT false + + +
+ + amountnumeric + + + + + + +
+ + netamountnumeric + + + + + + +
+ + paidnumeric + + + + + + +
+ + datepaiddate + + + + + + +
+ + duedatedate + + + + + + +
+ + invoiceboolean + + + + DEFAULT false + + +
+ + ordnumbertext + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + notestext + + + + + + +
+ + employee_idinteger + + + + + + +
+ + tillcharacter varying(20) + + + + + + +
+ + quonumbertext + + + + + + +
+ + intnotestext + + + + + + +
+ + department_idinteger + + + + + + +
+ + shipviatext + + + + + + +
+ + language_codecharacter varying(6) + + + + + + +
+ + ponumbertext + + + + + + +
+ + shippingpointtext + + + + + + +
+ + termssmallint + + + + + + +
+ + + + + + + + + + + + + + + + + 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 + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + ar +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ar Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + invnumbertext + + + + + + +
+ + transdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + customer_idinteger + + + + + + +
+ + taxincludedboolean + + + + + + +
+ + amountnumeric + + + + + + +
+ + netamountnumeric + + + + + + +
+ + paidnumeric + + + + + + +
+ + datepaiddate + + + + + + +
+ + duedatedate + + + + + + +
+ + invoiceboolean + + + + DEFAULT false + + +
+ + shippingpointtext + + + + + + +
+ + termssmallint + + + + + + +
+ + notestext + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + ordnumbertext + + + + + + +
+ + employee_idinteger + + + + + + +
+ + tillcharacter varying(20) + + + + + + +
+ + quonumbertext + + + + + + +
+ + intnotestext + + + + + + +
+ + department_idinteger + + + + + + +
+ + shipviatext + + + + + + +
+ + language_codecharacter varying(6) + + + + + + +
+ + ponumbertext + + + + + + +
+ + + + + + + + + + + + + + + + + ar_customer_id_key customer_id + + ar_employee_id_key employee_id + + ar_id_key id + + ar_invnumber_key invnumber + + ar_ordnumber_key ordnumber + + ar_quonumber_key quonumber + + ar_transdate_key transdate + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + assembly +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
assembly Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + parts_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + qtynumeric + + + + + + +
+ + bomboolean + + + + + + +
+ + adjboolean + + + + + + +
+ + + + + + + + + + + + + + + + + assembly_id_key id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + audittrail +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
audittrail Structure
F-KeyNameTypeDescription
+ + trans_idinteger + + + + + + +
+ + tablenametext + + + + + + +
+ + referencetext + + + + + + +
+ + formnametext + + + + + + +
+ + actiontext + + + + + + +
+ + transdatetimestamp without time zone + + + + DEFAULT now() + + +
+ + employee_idinteger + + + + + + +
+ + + + entry_idbigserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + audittrail_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + business +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
business Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + descriptiontext + + + + + + +
+ + discountnumeric + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + chart +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
chart Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + accnotext + + + NOT NULL + + + +
+ + descriptiontext + + + + + + +
+ + charttypecharacter(1) + + + + DEFAULT 'A'::bpchar + + +
+ + categorycharacter(1) + + + + + + +
+ + linktext + + + + + + +
+ + gifi_accnotext + + + + + + +
+ + contraboolean + + + + DEFAULT false + + +
+ + + + + + + + + + + + + +

Tables referencing this one via Foreign Key Constraints:

+ + + + + + + + + + + + chart_category_key category + + chart_gifi_accno_key gifi_accno + + chart_id_key id + + chart_link_key link + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + custom_field_catalog +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
custom_field_catalog Structure
F-KeyNameTypeDescription
+ + + + field_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + custom_table_catalog.table_id + + + table_idinteger + + + + + + + + + + +
+ + field_nametext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + custom_table_catalog +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
custom_table_catalog Structure
F-KeyNameTypeDescription
+ + + + table_idserial + + PRIMARY KEY + + + + + + + + + +
+ + extendstext + + + + + + +
+ + table_nametext + + + + + + +
+ + + + + + + + + + + + + +

Tables referencing this one via Foreign Key Constraints:

+ + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + customer +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
customer Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + namecharacter varying(64) + + + + + + +
+ + address1character varying(32) + + + + + + +
+ + address2character varying(32) + + + + + + +
+ + citycharacter varying(32) + + + + + + +
+ + statecharacter varying(32) + + + + + + +
+ + zipcodecharacter varying(10) + + + + + + +
+ + countrycharacter varying(32) + + + + + + +
+ + contactcharacter varying(64) + + + + + + +
+ + phonecharacter varying(20) + + + + + + +
+ + faxcharacter varying(20) + + + + + + +
+ + emailtext + + + + + + +
+ + notestext + + + + + + +
+ + discountnumeric + + + + + + +
+ + taxincludedboolean + + + + DEFAULT false + + +
+ + creditlimitnumeric + + + + + + +
+ + termssmallint + + + + + + +
+ + customernumbercharacter varying(32) + + + + + + +
+ + cctext + + + + + + +
+ + bcctext + + + + + + +
+ + business_idinteger + + + + + + +
+ + taxnumbercharacter varying(32) + + + + + + +
+ + sic_codecharacter varying(6) + + + + + + +
+ + ibancharacter varying(34) + + + + + + +
+ + biccharacter varying(11) + + + + + + +
+ + employee_idinteger + + + + + + +
+ + language_codecharacter varying(6) + + + + + + +
+ + pricegroup_idinteger + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + startdatedate + + + + + + +
+ + enddatedate + + + + + + +
+ + + + + + + + + + + + + + + + + customer_contact_key lower((contact)::text) + + customer_customernumber_key customernumber + + customer_id_key id + + customer_name_key lower((name)::text) + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + customertax +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
customertax Structure
F-KeyNameTypeDescription
+ + + + customer_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + chart_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + customer_customer_id_key customer_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + defaults +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
defaults Structure
F-KeyNameTypeDescription
+ + + + setting_keytext + + PRIMARY KEY + + + + + + + + + +
+ + valuetext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + department +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
department Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + descriptiontext + + + + + + +
+ + rolecharacter(1) + + + + DEFAULT 'P'::bpchar + + +
+ + + + + + + + + + + + + + + + + department_id_key id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + dpt_trans +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
dpt_trans Structure
F-KeyNameTypeDescription
+ + + + trans_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + department_idinteger + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + employee +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
employee Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + logintext + + + + + + +
+ + namecharacter varying(64) + + + + + + +
+ + address1character varying(32) + + + + + + +
+ + address2character varying(32) + + + + + + +
+ + citycharacter varying(32) + + + + + + +
+ + statecharacter varying(32) + + + + + + +
+ + zipcodecharacter varying(10) + + + + + + +
+ + countrycharacter varying(32) + + + + + + +
+ + workphonecharacter varying(20) + + + + + + +
+ + homephonecharacter varying(20) + + + + + + +
+ + startdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + enddatedate + + + + + + +
+ + notestext + + + + + + +
+ + rolecharacter varying(20) + + + + + + +
+ + salesboolean + + + + DEFAULT false + + +
+ + emailtext + + + + + + +
+ + ssncharacter varying(20) + + + + + + +
+ + ibancharacter varying(34) + + + + + + +
+ + biccharacter varying(11) + + + + + + +
+ + manageridinteger + + + + + + +
+ + employeenumbercharacter varying(32) + + + + + + +
+ + dobdate + + + + + + +
+ + + + + + + + + + + + + + + + + employee_id_key id + + employee_name_key lower((name)::text) + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + exchangerate +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
exchangerate Structure
F-KeyNameTypeDescription
+ + + + currcharacter(3) + + PRIMARY KEY + + + + + + + + + +
+ + + + transdatedate + + PRIMARY KEY + + + + + + + + + +
+ + buynumeric + + + + + + +
+ + sellnumeric + + + + + + +
+ + + + + + + + + + + + + + + + + exchangerate_ct_key curr, transdate + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + gifi +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
gifi Structure
F-KeyNameTypeDescription
+ + + + accnotext + + PRIMARY KEY + + + + + + + + + +
+ + descriptiontext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + gl +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
gl Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + referencetext + + + + + + +
+ + descriptiontext + + + + + + +
+ + transdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + employee_idinteger + + + + + + +
+ + notestext + + + + + + +
+ + department_idinteger + + + + + + +
+ + + + + + + + + + + + + + + + + gl_description_key lower(description) + + gl_employee_id_key employee_id + + gl_id_key id + + gl_reference_key reference + + gl_transdate_key transdate + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + inventory +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
inventory Structure
F-KeyNameTypeDescription
+ + warehouse_idinteger + + + + + + +
+ + parts_idinteger + + + + + + +
+ + trans_idinteger + + + + + + +
+ + orderitems_idinteger + + + + + + +
+ + qtynumeric + + + + + + +
+ + shippingdatedate + + + + + + +
+ + employee_idinteger + + + + + + +
+ + + + entry_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + invoice +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
invoice Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('invoiceid'::regclass) + + +
+ + trans_idinteger + + + + + + +
+ + parts_idinteger + + + + + + +
+ + descriptiontext + + + + + + +
+ + qtyinteger + + + + + + +
+ + allocatedinteger + + + + + + +
+ + sellpricenumeric + + + + + + +
+ + fxsellpricenumeric + + + + + + +
+ + discountreal + + + + + + +
+ + assemblyitemboolean + + + + DEFAULT false + + +
+ + unitcharacter varying(5) + + + + + + +
+ + project_idinteger + + + + + + +
+ + deliverydatedate + + + + + + +
+ + serialnumbertext + + + + + + +
+ + notestext + + + + + + +
+ + + + + + + + + + + + + + + + + invoice_id_key id + + invoice_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + jcitems +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
jcitems Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('jcitemsid'::regclass) + + +
+ + project_idinteger + + + + + + +
+ + parts_idinteger + + + + + + +
+ + descriptiontext + + + + + + +
+ + qtynumeric + + + + + + +
+ + allocatednumeric + + + + + + +
+ + sellpricenumeric + + + + + + +
+ + fxsellpricenumeric + + + + + + +
+ + serialnumbertext + + + + + + +
+ + checkedintimestamp with time zone + + + + + + +
+ + checkedouttimestamp with time zone + + + + + + +
+ + employee_idinteger + + + + + + +
+ + notestext + + + + + + +
+ + + + + + + + + + + + + + + + + jcitems_id_key id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + language +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
language Structure
F-KeyNameTypeDescription
+ + + + codecharacter varying(6) + + PRIMARY KEY + + + + + + + + + +
+ + descriptiontext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + makemodel +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
makemodel Structure
F-KeyNameTypeDescription
+ + + + parts_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + maketext + + + + + + +
+ + modeltext + + + + + + +
+ + + + + + + + + + + + + + + + + makemodel_make_key lower(make) + + makemodel_model_key lower(model) + + makemodel_parts_id_key parts_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + oe +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
oe Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + ordnumbertext + + + + + + +
+ + transdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + vendor_idinteger + + + + + + +
+ + customer_idinteger + + + + + + +
+ + amountnumeric + + + + + + +
+ + netamountnumeric + + + + + + +
+ + reqdatedate + + + + + + +
+ + taxincludedboolean + + + + + + +
+ + shippingpointtext + + + + + + +
+ + notestext + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + employee_idinteger + + + + + + +
+ + closedboolean + + + + DEFAULT false + + +
+ + quotationboolean + + + + DEFAULT false + + +
+ + quonumbertext + + + + + + +
+ + intnotestext + + + + + + +
+ + department_idinteger + + + + + + +
+ + shipviatext + + + + + + +
+ + language_codecharacter varying(6) + + + + + + +
+ + ponumbertext + + + + + + +
+ + termssmallint + + + + + + +
+ + + + + + + + + + + + + + + + + oe_employee_id_key employee_id + + oe_id_key id + + oe_ordnumber_key ordnumber + + oe_transdate_key transdate + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + orderitems +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
orderitems Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('orderitemsid'::regclass) + + +
+ + trans_idinteger + + + + + + +
+ + parts_idinteger + + + + + + +
+ + descriptiontext + + + + + + +
+ + qtynumeric + + + + + + +
+ + sellpricenumeric + + + + + + +
+ + discountnumeric + + + + + + +
+ + unitcharacter varying(5) + + + + + + +
+ + project_idinteger + + + + + + +
+ + reqdatedate + + + + + + +
+ + shipnumeric + + + + + + +
+ + serialnumbertext + + + + + + +
+ + notestext + + + + + + +
+ + + + + + + + + + + + + + + + + orderitems_id_key id + + orderitems_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + parts +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
parts Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + partnumbertext + + + + + + +
+ + descriptiontext + + + + + + +
+ + unitcharacter varying(5) + + + + + + +
+ + listpricenumeric + + + + + + +
+ + sellpricenumeric + + + + + + +
+ + lastcostnumeric + + + + + + +
+ + priceupdatedate + + + + DEFAULT ('now'::text)::date + + +
+ + weightnumeric + + + + + + +
+ + onhandnumeric + + + + + + +
+ + notestext + + + + + + +
+ + makemodelboolean + + + + DEFAULT false + + +
+ + assemblyboolean + + + + DEFAULT false + + +
+ + alternateboolean + + + + DEFAULT false + + +
+ + ropreal + + + + + + +
+ + inventory_accno_idinteger + + + + + + +
+ + income_accno_idinteger + + + + + + +
+ + expense_accno_idinteger + + + + + + +
+ + bintext + + + + + + +
+ + obsoleteboolean + + + + DEFAULT false + + +
+ + bomboolean + + + + DEFAULT false + + +
+ + imagetext + + + + + + +
+ + drawingtext + + + + + + +
+ + microfichetext + + + + + + +
+ + partsgroup_idinteger + + + + + + +
+ + project_idinteger + + + + + + +
+ + avgcostnumeric + + + + + + +
+ + + + + + + + + + + + + +

Tables referencing this one via Foreign Key Constraints:

+ + + + + + + + parts_description_key lower(description) + + parts_id_key id + + parts_partnumber_key lower(partnumber) + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + partscustomer +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
partscustomer Structure
F-KeyNameTypeDescription
+ + parts_idinteger + + + + + + +
+ + customer_idinteger + + + + + + +
+ + pricegroup_idinteger + + + + + + +
+ + pricebreaknumeric + + + + + + +
+ + sellpricenumeric + + + + + + +
+ + validfromdate + + + + + + +
+ + validtodate + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + + + entry_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + partsgroup +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
partsgroup Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + partsgrouptext + + + + + + +
+ + + + + + + + + + + + + + + + + partsgroup_id_key id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + partstax +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
partstax Structure
F-KeyNameTypeDescription
+ + + parts.id + + + + + parts_idinteger + + + + + + PRIMARY KEY + + + + + + + + + +
+ + + chart.id + + + + + chart_idinteger + + + + + + PRIMARY KEY + + + + + + + + + +
+ + + taxcategory.taxcategory_id + + + taxcategory_idinteger + + + + + + + + + + +
+ + + + + + + + + + + + + + + + + partstax_parts_id_key parts_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + partsvendor +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
partsvendor Structure
F-KeyNameTypeDescription
+ + vendor_idinteger + + + + + + +
+ + parts_idinteger + + + + + + +
+ + partnumbertext + + + + + + +
+ + leadtimesmallint + + + + + + +
+ + lastcostnumeric + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + + + entry_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + partsvendor_parts_id_key parts_id + + partsvendor_vendor_id_key vendor_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + pricegroup +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
pricegroup Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + pricegrouptext + + + + + + +
+ + + + + + + + + + + + + + + + + pricegroup_id_key id + + pricegroup_pricegroup_key pricegroup + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + project +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
project Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + projectnumbertext + + + + + + +
+ + descriptiontext + + + + + + +
+ + startdatedate + + + + + + +
+ + enddatedate + + + + + + +
+ + parts_idinteger + + + + + + +
+ + productionnumeric + + + + + + +
+ + completednumeric + + + + + + +
+ + customer_idinteger + + + + + + +
+ + + + + + + + + + + + + + + + + project_id_key id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + recurring +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
recurring Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + + + +
+ + referencetext + + + + + + +
+ + startdatedate + + + + + + +
+ + nextdatedate + + + + + + +
+ + enddatedate + + + + + + +
+ + repeatsmallint + + + + + + +
+ + unitcharacter varying(6) + + + + + + +
+ + howmanyinteger + + + + + + +
+ + paymentboolean + + + + DEFAULT false + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + recurringemail +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
recurringemail Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + + + +
+ + formnametext + + + + + + +
+ + formattext + + + + + + +
+ + messagetext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + recurringprint +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
recurringprint Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + + + +
+ + formnametext + + + + + + +
+ + formattext + + + + + + +
+ + printertext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + shipto +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
shipto Structure
F-KeyNameTypeDescription
+ + trans_idinteger + + + + + + +
+ + shiptonamecharacter varying(64) + + + + + + +
+ + shiptoaddress1character varying(32) + + + + + + +
+ + shiptoaddress2character varying(32) + + + + + + +
+ + shiptocitycharacter varying(32) + + + + + + +
+ + shiptostatecharacter varying(32) + + + + + + +
+ + shiptozipcodecharacter varying(10) + + + + + + +
+ + shiptocountrycharacter varying(32) + + + + + + +
+ + shiptocontactcharacter varying(64) + + + + + + +
+ + shiptophonecharacter varying(20) + + + + + + +
+ + shiptofaxcharacter varying(20) + + + + + + +
+ + shiptoemailtext + + + + + + +
+ + + + entry_idserial + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + shipto_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + sic +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
sic Structure
F-KeyNameTypeDescription
+ + + + codecharacter varying(6) + + PRIMARY KEY + + + + + + + + + +
+ + sictypecharacter(1) + + + + + + +
+ + descriptiontext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + status +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
status Structure
F-KeyNameTypeDescription
+ + + + trans_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + formnametext + + + + + + +
+ + printedboolean + + + + DEFAULT false + + +
+ + emailedboolean + + + + DEFAULT false + + +
+ + spoolfiletext + + + + + + +
+ + + + + + + + + + + + + + + + + status_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + tax +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
tax Structure
F-KeyNameTypeDescription
+ + + chart.id + + + + + chart_idinteger + + + + + + PRIMARY KEY + + + + + + + + + +
+ + ratenumeric + + + + + + +
+ + taxnumbertext + + + + + + +
+ + validtodate + + + + + + +
+ + passinteger + + + NOT NULL + + + +
+ + + taxmodule.taxmodule_id + + + taxmodule_idinteger + + + + + + + NOT NULL + DEFAULT 1 + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + taxcategory +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
taxcategory Structure
F-KeyNameTypeDescription
+ + + + taxcategory_idserial + + PRIMARY KEY + + + + + + + + + +
+ + taxcategorynametext + + + NOT NULL + + + +
+ + + taxmodule.taxmodule_id + + + taxmodule_idinteger + + + + + + + NOT NULL + + + +
+ + + + + + + + + + + + + +

Tables referencing this one via Foreign Key Constraints:

+ + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + taxmodule +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
taxmodule Structure
F-KeyNameTypeDescription
+ + + + taxmodule_idserial + + PRIMARY KEY + + + + + + + + + +
+ + taxmodulenametext + + + NOT NULL + + + +
+ + + + + + + + + + + + + +

Tables referencing this one via Foreign Key Constraints:

+ + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + transactions +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
transactions Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + + + +
+ + table_nametext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + translation +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
translation Structure
F-KeyNameTypeDescription
+ + + + trans_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + language_codecharacter varying(6) + + PRIMARY KEY + + + + + + + + + +
+ + descriptiontext + + + + + + +
+ + + + + + + + + + + + + + + + + translation_trans_id_key trans_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + vendor +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
vendor Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + namecharacter varying(64) + + + + + + +
+ + address1character varying(32) + + + + + + +
+ + address2character varying(32) + + + + + + +
+ + citycharacter varying(32) + + + + + + +
+ + statecharacter varying(32) + + + + + + +
+ + zipcodecharacter varying(10) + + + + + + +
+ + countrycharacter varying(32) + + + + + + +
+ + contactcharacter varying(64) + + + + + + +
+ + phonecharacter varying(20) + + + + + + +
+ + faxcharacter varying(20) + + + + + + +
+ + emailtext + + + + + + +
+ + notestext + + + + + + +
+ + termssmallint + + + + + + +
+ + taxincludedboolean + + + + DEFAULT false + + +
+ + vendornumbercharacter varying(32) + + + + + + +
+ + cctext + + + + + + +
+ + bcctext + + + + + + +
+ + gifi_accnocharacter varying(30) + + + + + + +
+ + business_idinteger + + + + + + +
+ + taxnumbercharacter varying(32) + + + + + + +
+ + sic_codecharacter varying(6) + + + + + + +
+ + discountnumeric + + + + + + +
+ + creditlimitnumeric + + + + + + +
+ + ibancharacter varying(34) + + + + + + +
+ + biccharacter varying(11) + + + + + + +
+ + employee_idinteger + + + + + + +
+ + language_codecharacter varying(6) + + + + + + +
+ + pricegroup_idinteger + + + + + + +
+ + currcharacter(3) + + + + + + +
+ + startdatedate + + + + + + +
+ + enddatedate + + + + + + +
+ + + + + + + + + + + + + + + + + vendor_contact_key lower((contact)::text) + + vendor_id_key id + + vendor_name_key lower((name)::text) + + vendor_vendornumber_key vendornumber + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + vendortax +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
vendortax Structure
F-KeyNameTypeDescription
+ + + + vendor_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + chart_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + + + + + + + + + + + + + + + + vendortax_vendor_id_key vendor_id + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + warehouse +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
warehouse Structure
F-KeyNameTypeDescription
+ + + + idinteger + + PRIMARY KEY + + + + + + + DEFAULT nextval('id'::regclass) + + +
+ + descriptiontext + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ +
+

Table: + yearend +

+ + + + + + + + + + + + + + + + + + + + + + + + + + +
yearend Structure
F-KeyNameTypeDescription
+ + + + trans_idinteger + + PRIMARY KEY + + + + + + + + + +
+ + transdatedate + + + + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +

+ Index - + Schema public +

+ + + + +
+

Function: + add_custom_field( character varying, character varying, character varying ) +

+

Returns: boolean

+

Language: PLPGSQL

+ + 
+DECLARE
+table_name ALIAS FOR $1;
+new_field_name ALIAS FOR $2;
+field_datatype ALIAS FOR $3;
+
+BEGIN
+	EXECUTE 'SELECT TABLE_ID FROM custom_table_catalog 
+		WHERE extends = ''' || table_name || ''' ';
+	IF NOT FOUND THEN
+		BEGIN
+			INSERT INTO custom_table_catalog (extends) 
+				VALUES (table_name);
+			EXECUTE 'CREATE TABLE custom_'||table_name || 
+				' (row_id INT PRIMARY KEY)';
+		EXCEPTION WHEN duplicate_table THEN
+			-- do nothing
+		END;
+	END IF;
+	EXECUTE 'INSERT INTO custom_field_catalog (field_name, table_id)
+	VALUES ( ''' || new_field_name ||''', (SELECT table_id FROM custom_table_catalog
+		WHERE extends = '''|| table_name || '''))';
+	EXECUTE 'ALTER TABLE custom_'||table_name || ' ADD COLUMN ' 
+		|| new_field_name || ' ' || field_datatype;
+	RETURN TRUE;
+END;
+
+ +
+

Function: + avgcost( integer ) +

+

Returns: double precision

+

Language: PLPGSQL

+ + 
+
+DECLARE
+
+v_cost float;
+v_qty float;
+v_parts_id alias for $1;
+
+BEGIN
+
+  SELECT INTO v_cost, v_qty SUM(i.sellprice * i.qty), SUM(i.qty)
+  FROM invoice i
+  JOIN ap a ON (a.id = i.trans_id)
+  WHERE i.parts_id = v_parts_id;
+  
+  IF v_cost IS NULL THEN
+    v_cost := 0;
+  END IF;
+
+  IF NOT v_qty IS NULL THEN
+    IF v_qty = 0 THEN
+      v_cost := 0;
+    ELSE
+      v_cost := v_cost/v_qty;
+    END IF;
+  END IF;
+
+RETURN v_cost;
+END;
+
+ +
+

Function: + check_department( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+
+declare
+  dpt_id int;
+
+begin
+ 
+  if new.department_id = 0 then
+    delete from dpt_trans where trans_id = new.id;
+    return NULL;
+  end if;
+
+  select into dpt_id trans_id from dpt_trans where trans_id = new.id;
+  
+  if dpt_id > 0 then
+    update dpt_trans set department_id = new.department_id where trans_id = dpt_id;
+  else
+    insert into dpt_trans (trans_id, department_id) values (new.id, new.department_id);
+  end if;
+return NULL;
+
+end;
+
+ +
+

Function: + check_inventory( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+
+declare
+  itemid int;
+  row_data inventory%rowtype;
+
+begin
+
+  if not old.quotation then
+    for row_data in select * from inventory where trans_id = old.id loop
+      select into itemid id from orderitems where trans_id = old.id and id = row_data.orderitems_id;
+
+      if itemid is null then
+	delete from inventory where trans_id = old.id and orderitems_id = row_data.orderitems_id;
+      end if;
+    end loop;
+  end if;
+return old;
+end;
+
+ +
+

Function: + del_customer( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+begin
+  delete from shipto where trans_id = old.id;
+  delete from customertax where customer_id = old.id;
+  delete from partscustomer where customer_id = old.id;
+  return NULL;
+end;
+
+ +
+

Function: + del_department( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+begin
+  delete from dpt_trans where trans_id = old.id;
+  return NULL;
+end;
+
+ +
+

Function: + del_exchangerate( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+
+declare
+  t_transdate date;
+  t_curr char(3);
+  t_id int;
+  d_curr text;
+
+begin
+
+  select into d_curr substr(value,1,3) from defaults where setting_key = 'curr';
+  
+  if TG_RELNAME = 'ar' then
+    select into t_curr, t_transdate curr, transdate from ar where id = old.id;
+  end if;
+  if TG_RELNAME = 'ap' then
+    select into t_curr, t_transdate curr, transdate from ap where id = old.id;
+  end if;
+  if TG_RELNAME = 'oe' then
+    select into t_curr, t_transdate curr, transdate from oe where id = old.id;
+  end if;
+
+  if d_curr != t_curr then
+
+    select into t_id a.id from acc_trans ac
+    join ar a on (a.id = ac.trans_id)
+    where a.curr = t_curr
+    and ac.transdate = t_transdate
+
+    except select a.id from ar a where a.id = old.id
+    
+    union
+    
+    select a.id from acc_trans ac
+    join ap a on (a.id = ac.trans_id)
+    where a.curr = t_curr
+    and ac.transdate = t_transdate
+    
+    except select a.id from ap a where a.id = old.id
+    
+    union
+    
+    select o.id from oe o
+    where o.curr = t_curr
+    and o.transdate = t_transdate
+    
+    except select o.id from oe o where o.id = old.id;
+
+    if not found then
+      delete from exchangerate where curr = t_curr and transdate = t_transdate;
+    end if;
+  end if;
+return old;
+
+end;
+
+ +
+

Function: + del_recurring( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+BEGIN
+  DELETE FROM recurring WHERE id = old.id;
+  DELETE FROM recurringemail WHERE id = old.id;
+  DELETE FROM recurringprint WHERE id = old.id;
+  RETURN NULL;
+END;
+
+ +
+

Function: + del_vendor( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+begin
+  delete from shipto where trans_id = old.id;
+  delete from vendortax where vendor_id = old.id;
+  delete from partsvendor where vendor_id = old.id;
+  return NULL;
+end;
+
+ +
+

Function: + del_yearend( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+begin
+  delete from yearend where trans_id = old.id;
+  return NULL;
+end;
+
+ +
+

Function: + drop_custom_field( character varying, character varying ) +

+

Returns: boolean

+

Language: PLPGSQL

+ + 
+DECLARE
+table_name ALIAS FOR $1;
+custom_field_name ALIAS FOR $2;
+BEGIN
+	DELETE FROM custom_field_catalog 
+	WHERE field_name = custom_field_name AND 
+		table_id = (SELECT table_id FROM custom_table_catalog 
+			WHERE extends = table_name);
+	EXECUTE 'ALTER TABLE custom_' || table_name || 
+		' DROP COLUMN ' || custom_field_name;
+	RETURN TRUE;	
+END;
+
+ +
+

Function: + lastcost( integer ) +

+

Returns: double precision

+

Language: PLPGSQL

+ + 
+
+DECLARE
+
+v_cost float;
+v_parts_id alias for $1;
+
+BEGIN
+
+  SELECT INTO v_cost sellprice FROM invoice i
+  JOIN ap a ON (a.id = i.trans_id)
+  WHERE i.parts_id = v_parts_id
+  ORDER BY a.transdate desc, a.id desc
+  LIMIT 1;
+
+  IF v_cost IS NULL THEN
+    v_cost := 0;
+  END IF;
+
+RETURN v_cost;
+END;
+
+ +
+

Function: + trigger_parts_short( ) +

+

Returns: "trigger"

+

Language: PLPGSQL

+ + 
+BEGIN
+  IF NEW.onhand >= NEW.rop THEN
+    NOTIFY parts_short;
+  END IF;
+  RETURN NEW;
+END;
+
+ +
+

Function: + update_user( integer, text ) +

+

Returns: integer

+

Language: SQL

+

Takes int4 which is users.id and text which is username. Will update username based on id. Username is unique

+ 
+   UPDATE users SET username = '$2' WHERE id = $1;
+   SELECT 1;
+
+ + + +

Generated by PostgreSQL Autodoc

+

W3C HTML 4.01 Strict

+ diff --git a/doc/database/ledgersmb.neato b/doc/database/ledgersmb.neato new file mode 100644 index 00000000..278993c7 --- /dev/null +++ b/doc/database/ledgersmb.neato @@ -0,0 +1,110 @@ +digraph g { +node [ fontsize = "10", shape = record ]; +edge []; + +"acc_trans" [shape = record, label = "{ \N| trans_id: integer\lchart_id: integer\lamount: numeric\ltransdate: date\lsource: text\lcleared: boolean\lfx_transaction: boolean\lproject_id: integer\lmemo: text\linvoice_id: integer\lentry_id: serial\l}" ]; + +"ap" [shape = record, label = "{ \N| id: integer\linvnumber: text\ltransdate: date\lvendor_id: integer\ltaxincluded: boolean\lamount: numeric\lnetamount: numeric\lpaid: numeric\ldatepaid: date\lduedate: date\linvoice: boolean\lordnumber: text\lcurr: character(3)\lnotes: text\lemployee_id: integer\ltill: character varying(20)\lquonumber: text\lintnotes: text\ldepartment_id: integer\lshipvia: text\llanguage_code: character varying(6)\lponumber: text\lshippingpoint: text\lterms: smallint\l}" ]; + +"ar" [shape = record, label = "{ \N| id: integer\linvnumber: text\ltransdate: date\lcustomer_id: integer\ltaxincluded: boolean\lamount: numeric\lnetamount: numeric\lpaid: numeric\ldatepaid: date\lduedate: date\linvoice: boolean\lshippingpoint: text\lterms: smallint\lnotes: text\lcurr: character(3)\lordnumber: text\lemployee_id: integer\ltill: character varying(20)\lquonumber: text\lintnotes: text\ldepartment_id: integer\lshipvia: text\llanguage_code: character varying(6)\lponumber: text\l}" ]; + +"assembly" [shape = record, label = "{ \N| id: integer\lparts_id: integer\lqty: numeric\lbom: boolean\ladj: boolean\l}" ]; + +"audittrail" [shape = record, label = "{ \N| trans_id: integer\ltablename: text\lreference: text\lformname: text\laction: text\ltransdate: timestamp without time zone\lemployee_id: integer\lentry_id: bigserial\l}" ]; + +"business" [shape = record, label = "{ \N| id: integer\ldescription: text\ldiscount: numeric\l}" ]; + +"chart" [shape = record, label = "{ \N| id: integer\laccno: text\ldescription: text\lcharttype: character(1)\lcategory: character(1)\llink: text\lgifi_accno: text\lcontra: boolean\l}" ]; + +"custom_field_catalog" [shape = record, label = "{ \N| field_id: serial\ltable_id: integer\lfield_name: text\l}" ]; + +"custom_table_catalog" [shape = record, label = "{ \N| table_id: serial\lextends: text\ltable_name: text\l}" ]; + +"customer" [shape = record, label = "{ \N| id: integer\lname: character varying(64)\laddress1: character varying(32)\laddress2: character varying(32)\lcity: character varying(32)\lstate: character varying(32)\lzipcode: character varying(10)\lcountry: character varying(32)\lcontact: character varying(64)\lphone: character varying(20)\lfax: character varying(20)\lemail: text\lnotes: text\ldiscount: numeric\ltaxincluded: boolean\lcreditlimit: numeric\lterms: smallint\lcustomernumber: character varying(32)\lcc: text\lbcc: text\lbusiness_id: integer\ltaxnumber: character varying(32)\lsic_code: character varying(6)\liban: character varying(34)\lbic: character varying(11)\lemployee_id: integer\llanguage_code: character varying(6)\lpricegroup_id: integer\lcurr: character(3)\lstartdate: date\lenddate: date\l}" ]; + +"customertax" [shape = record, label = "{ \N| customer_id: integer\lchart_id: integer\l}" ]; + +"defaults" [shape = record, label = "{ \N| setting_key: text\lvalue: text\l}" ]; + +"department" [shape = record, label = "{ \N| id: integer\ldescription: text\lrole: character(1)\l}" ]; + +"dpt_trans" [shape = record, label = "{ \N| trans_id: integer\ldepartment_id: integer\l}" ]; + +"employee" [shape = record, label = "{ \N| id: integer\llogin: text\lname: character varying(64)\laddress1: character varying(32)\laddress2: character varying(32)\lcity: character varying(32)\lstate: character varying(32)\lzipcode: character varying(10)\lcountry: character varying(32)\lworkphone: character varying(20)\lhomephone: character varying(20)\lstartdate: date\lenddate: date\lnotes: text\lrole: character varying(20)\lsales: boolean\lemail: text\lssn: character varying(20)\liban: character varying(34)\lbic: character varying(11)\lmanagerid: integer\lemployeenumber: character varying(32)\ldob: date\l}" ]; + +"exchangerate" [shape = record, label = "{ \N| curr: character(3)\ltransdate: date\lbuy: numeric\lsell: numeric\l}" ]; + +"gifi" [shape = record, label = "{ \N| accno: text\ldescription: text\l}" ]; + +"gl" [shape = record, label = "{ \N| id: integer\lreference: text\ldescription: text\ltransdate: date\lemployee_id: integer\lnotes: text\ldepartment_id: integer\l}" ]; + +"inventory" [shape = record, label = "{ \N| warehouse_id: integer\lparts_id: integer\ltrans_id: integer\lorderitems_id: integer\lqty: numeric\lshippingdate: date\lemployee_id: integer\lentry_id: serial\l}" ]; + +"invoice" [shape = record, label = "{ \N| id: integer\ltrans_id: integer\lparts_id: integer\ldescription: text\lqty: integer\lallocated: integer\lsellprice: numeric\lfxsellprice: numeric\ldiscount: real\lassemblyitem: boolean\lunit: character varying(5)\lproject_id: integer\ldeliverydate: date\lserialnumber: text\lnotes: text\l}" ]; + +"jcitems" [shape = record, label = "{ \N| id: integer\lproject_id: integer\lparts_id: integer\ldescription: text\lqty: numeric\lallocated: numeric\lsellprice: numeric\lfxsellprice: numeric\lserialnumber: text\lcheckedin: timestamp with time zone\lcheckedout: timestamp with time zone\lemployee_id: integer\lnotes: text\l}" ]; + +"language" [shape = record, label = "{ \N| code: character varying(6)\ldescription: text\l}" ]; + +"makemodel" [shape = record, label = "{ \N| parts_id: integer\lmake: text\lmodel: text\l}" ]; + +"oe" [shape = record, label = "{ \N| id: integer\lordnumber: text\ltransdate: date\lvendor_id: integer\lcustomer_id: integer\lamount: numeric\lnetamount: numeric\lreqdate: date\ltaxincluded: boolean\lshippingpoint: text\lnotes: text\lcurr: character(3)\lemployee_id: integer\lclosed: boolean\lquotation: boolean\lquonumber: text\lintnotes: text\ldepartment_id: integer\lshipvia: text\llanguage_code: character varying(6)\lponumber: text\lterms: smallint\l}" ]; + +"orderitems" [shape = record, label = "{ \N| id: integer\ltrans_id: integer\lparts_id: integer\ldescription: text\lqty: numeric\lsellprice: numeric\ldiscount: numeric\lunit: character varying(5)\lproject_id: integer\lreqdate: date\lship: numeric\lserialnumber: text\lnotes: text\l}" ]; + +"parts" [shape = record, label = "{ \N| id: integer\lpartnumber: text\ldescription: text\lunit: character varying(5)\llistprice: numeric\lsellprice: numeric\llastcost: numeric\lpriceupdate: date\lweight: numeric\lonhand: numeric\lnotes: text\lmakemodel: boolean\lassembly: boolean\lalternate: boolean\lrop: real\linventory_accno_id: integer\lincome_accno_id: integer\lexpense_accno_id: integer\lbin: text\lobsolete: boolean\lbom: boolean\limage: text\ldrawing: text\lmicrofiche: text\lpartsgroup_id: integer\lproject_id: integer\lavgcost: numeric\l}" ]; + +"partscustomer" [shape = record, label = "{ \N| parts_id: integer\lcustomer_id: integer\lpricegroup_id: integer\lpricebreak: numeric\lsellprice: numeric\lvalidfrom: date\lvalidto: date\lcurr: character(3)\lentry_id: serial\l}" ]; + +"partsgroup" [shape = record, label = "{ \N| id: integer\lpartsgroup: text\l}" ]; + +"partstax" [shape = record, label = "{ \N| parts_id: integer\lchart_id: integer\ltaxcategory_id: integer\l}" ]; + +"partsvendor" [shape = record, label = "{ \N| vendor_id: integer\lparts_id: integer\lpartnumber: text\lleadtime: smallint\llastcost: numeric\lcurr: character(3)\lentry_id: serial\l}" ]; + +"pricegroup" [shape = record, label = "{ \N| id: integer\lpricegroup: text\l}" ]; + +"project" [shape = record, label = "{ \N| id: integer\lprojectnumber: text\ldescription: text\lstartdate: date\lenddate: date\lparts_id: integer\lproduction: numeric\lcompleted: numeric\lcustomer_id: integer\l}" ]; + +"recurring" [shape = record, label = "{ \N| id: integer\lreference: text\lstartdate: date\lnextdate: date\lenddate: date\lrepeat: smallint\lunit: character varying(6)\lhowmany: integer\lpayment: boolean\l}" ]; + +"recurringemail" [shape = record, label = "{ \N| id: integer\lformname: text\lformat: text\lmessage: text\l}" ]; + +"recurringprint" [shape = record, label = "{ \N| id: integer\lformname: text\lformat: text\lprinter: text\l}" ]; + +"shipto" [shape = record, label = "{ \N| trans_id: integer\lshiptoname: character varying(64)\lshiptoaddress1: character varying(32)\lshiptoaddress2: character varying(32)\lshiptocity: character varying(32)\lshiptostate: character varying(32)\lshiptozipcode: character varying(10)\lshiptocountry: character varying(32)\lshiptocontact: character varying(64)\lshiptophone: character varying(20)\lshiptofax: character varying(20)\lshiptoemail: text\lentry_id: serial\l}" ]; + +"sic" [shape = record, label = "{ \N| code: character varying(6)\lsictype: character(1)\ldescription: text\l}" ]; + +"status" [shape = record, label = "{ \N| trans_id: integer\lformname: text\lprinted: boolean\lemailed: boolean\lspoolfile: text\l}" ]; + +"tax" [shape = record, label = "{ \N| chart_id: integer\lrate: numeric\ltaxnumber: text\lvalidto: date\lpass: integer\ltaxmodule_id: integer\l}" ]; + +"taxcategory" [shape = record, label = "{ \N| taxcategory_id: serial\ltaxcategoryname: text\ltaxmodule_id: integer\l}" ]; + +"taxmodule" [shape = record, label = "{ \N| taxmodule_id: serial\ltaxmodulename: text\l}" ]; + +"transactions" [shape = record, label = "{ \N| id: integer\ltable_name: text\l}" ]; + +"translation" [shape = record, label = "{ \N| trans_id: integer\llanguage_code: character varying(6)\ldescription: text\l}" ]; + +"vendor" [shape = record, label = "{ \N| id: integer\lname: character varying(64)\laddress1: character varying(32)\laddress2: character varying(32)\lcity: character varying(32)\lstate: character varying(32)\lzipcode: character varying(10)\lcountry: character varying(32)\lcontact: character varying(64)\lphone: character varying(20)\lfax: character varying(20)\lemail: text\lnotes: text\lterms: smallint\ltaxincluded: boolean\lvendornumber: character varying(32)\lcc: text\lbcc: text\lgifi_accno: character varying(30)\lbusiness_id: integer\ltaxnumber: character varying(32)\lsic_code: character varying(6)\ldiscount: numeric\lcreditlimit: numeric\liban: character varying(34)\lbic: character varying(11)\lemployee_id: integer\llanguage_code: character varying(6)\lpricegroup_id: integer\lcurr: character(3)\lstartdate: date\lenddate: date\l}" ]; + +"vendortax" [shape = record, label = "{ \N| vendor_id: integer\lchart_id: integer\l}" ]; + +"warehouse" [shape = record, label = "{ \N| id: integer\ldescription: text\l}" ]; + +"yearend" [shape = record, label = "{ \N| trans_id: integer\ltransdate: date\l}" ]; + + +"acc_trans" -> "chart" [label="acc_trans_chart_id_fkey"]; +"custom_field_catalog" -> "custom_table_catalog" [label="custom_field_catalog_table_id_fkey"]; +"partstax" -> "parts" [label="partstax_parts_id_fkey"]; +"partstax" -> "chart" [label="partstax_chart_id_fkey"]; +"partstax" -> "taxcategory" [label="partstax_taxcategory_id_fkey"]; +"tax" -> "chart" [label="tax_chart_id_fkey"]; +"tax" -> "taxmodule" [label="tax_taxmodule_id_fkey"]; +"taxcategory" -> "taxmodule" [label="taxcategory_taxmodule_id_fkey"]; +} + + diff --git a/doc/database/ledgersmb.xml b/doc/database/ledgersmb.xml new file mode 100644 index 00000000..82672ad6 --- /dev/null +++ b/doc/database/ledgersmb.xml @@ -0,0 +1,9721 @@ + + + +ledgersmb Model + + + + + + Schema public + Standard public schema + + +
+ + Table: + + <structname>acc_trans</structname> + + + + + + + + Structure of <structname>acc_trans</structname> + + + + + trans_id + + integer + + + + + + + + + + + + + + chart_id + + integer + + + + + + + + NOT NULL + + + + + + + REFERENCES + + + + + + + + + amount + + numeric + + + + + + + + + + + + + + transdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + source + + text + + + + + + + + + + + + + + cleared + + boolean + + + + + + DEFAULT false + + + + + + + + + + fx_transaction + + boolean + + + + + + DEFAULT false + + + + + + + + + + project_id + + integer + + + + + + + + + + + + + + memo + + text + + + + + + + + + + + + + + invoice_id + + integer + + + + + + + + + + + + + + entry_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on acc_trans + + + 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 + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>ap</structname> + + + + + + + + Structure of <structname>ap</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + invnumber + + text + + + + + + + + + + + + + + transdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + vendor_id + + integer + + + + + + + + + + + + + + taxincluded + + boolean + + + + + + DEFAULT false + + + + + + + + + + amount + + numeric + + + + + + + + + + + + + + netamount + + numeric + + + + + + + + + + + + + + paid + + numeric + + + + + + + + + + + + + + datepaid + + date + + + + + + + + + + + + + + duedate + + date + + + + + + + + + + + + + + invoice + + boolean + + + + + + DEFAULT false + + + + + + + + + + ordnumber + + text + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + till + + character varying(20) + + + + + + + + + + + + + + quonumber + + text + + + + + + + + + + + + + + intnotes + + text + + + + + + + + + + + + + + department_id + + integer + + + + + + + + + + + + + + shipvia + + text + + + + + + + + + + + + + + language_code + + character varying(6) + + + + + + + + + + + + + + ponumber + + text + + + + + + + + + + + + + + shippingpoint + + text + + + + + + + + + + + + + + terms + + smallint + + + + + + + + + + + + + + + + + + + + Indexes on ap + + + 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 + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>ar</structname> + + + + + + + + Structure of <structname>ar</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + invnumber + + text + + + + + + + + + + + + + + transdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + customer_id + + integer + + + + + + + + + + + + + + taxincluded + + boolean + + + + + + + + + + + + + + amount + + numeric + + + + + + + + + + + + + + netamount + + numeric + + + + + + + + + + + + + + paid + + numeric + + + + + + + + + + + + + + datepaid + + date + + + + + + + + + + + + + + duedate + + date + + + + + + + + + + + + + + invoice + + boolean + + + + + + DEFAULT false + + + + + + + + + + shippingpoint + + text + + + + + + + + + + + + + + terms + + smallint + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + ordnumber + + text + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + till + + character varying(20) + + + + + + + + + + + + + + quonumber + + text + + + + + + + + + + + + + + intnotes + + text + + + + + + + + + + + + + + department_id + + integer + + + + + + + + + + + + + + shipvia + + text + + + + + + + + + + + + + + language_code + + character varying(6) + + + + + + + + + + + + + + ponumber + + text + + + + + + + + + + + + + + + + + + + + Indexes on ar + + + ar_customer_id_key + customer_id + + + + + + ar_employee_id_key + employee_id + + + + + + ar_id_key + id + + + + + + ar_invnumber_key + invnumber + + + + + + ar_ordnumber_key + ordnumber + + + + + + ar_quonumber_key + quonumber + + + + + + ar_transdate_key + transdate + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>assembly</structname> + + + + + + + + Structure of <structname>assembly</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + parts_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + qty + + numeric + + + + + + + + + + + + + + bom + + boolean + + + + + + + + + + + + + + adj + + boolean + + + + + + + + + + + + + + + + + + + + Indexes on assembly + + + assembly_id_key + id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>audittrail</structname> + + + + + + + + Structure of <structname>audittrail</structname> + + + + + trans_id + + integer + + + + + + + + + + + + + + tablename + + text + + + + + + + + + + + + + + reference + + text + + + + + + + + + + + + + + formname + + text + + + + + + + + + + + + + + action + + text + + + + + + + + + + + + + + transdate + + timestamp without time zone + + + + + + DEFAULT now() + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + entry_id + + bigserial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on audittrail + + + audittrail_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>business</structname> + + + + + + + + Structure of <structname>business</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + discount + + numeric + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>chart</structname> + + + + + + + + Structure of <structname>chart</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + accno + + text + + + + NOT NULL + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + charttype + + character(1) + + + + + + DEFAULT 'A'::bpchar + + + + + + + + + + category + + character(1) + + + + + + + + + + + + + + link + + text + + + + + + + + + + + + + + gifi_accno + + text + + + + + + + + + + + + + + contra + + boolean + + + + + + DEFAULT false + + + + + + + + + + + + + + + + Indexes on chart + + + chart_category_key + category + + + + + + chart_gifi_accno_key + gifi_accno + + + + + + chart_id_key + id + + + + + + chart_link_key + link + + + + + + + + + + + Tables referencing acc_trans via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>custom_field_catalog</structname> + + + + + + + + Structure of <structname>custom_field_catalog</structname> + + + + + field_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + table_id + + integer + + + + + + + + + + + + + REFERENCES + + + + + + + + + field_name + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>custom_table_catalog</structname> + + + + + + + + Structure of <structname>custom_table_catalog</structname> + + + + + table_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + extends + + text + + + + + + + + + + + + + + table_name + + text + + + + + + + + + + + + + + + + + + + + + + + Tables referencing custom_field_catalog via Foreign Key Constraints + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>customer</structname> + + + + + + + + Structure of <structname>customer</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + name + + character varying(64) + + + + + + + + + + + + + + address1 + + character varying(32) + + + + + + + + + + + + + + address2 + + character varying(32) + + + + + + + + + + + + + + city + + character varying(32) + + + + + + + + + + + + + + state + + character varying(32) + + + + + + + + + + + + + + zipcode + + character varying(10) + + + + + + + + + + + + + + country + + character varying(32) + + + + + + + + + + + + + + contact + + character varying(64) + + + + + + + + + + + + + + phone + + character varying(20) + + + + + + + + + + + + + + fax + + character varying(20) + + + + + + + + + + + + + + email + + text + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + discount + + numeric + + + + + + + + + + + + + + taxincluded + + boolean + + + + + + DEFAULT false + + + + + + + + + + creditlimit + + numeric + + + + + + + + + + + + + + terms + + smallint + + + + + + + + + + + + + + customernumber + + character varying(32) + + + + + + + + + + + + + + cc + + text + + + + + + + + + + + + + + bcc + + text + + + + + + + + + + + + + + business_id + + integer + + + + + + + + + + + + + + taxnumber + + character varying(32) + + + + + + + + + + + + + + sic_code + + character varying(6) + + + + + + + + + + + + + + iban + + character varying(34) + + + + + + + + + + + + + + bic + + character varying(11) + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + language_code + + character varying(6) + + + + + + + + + + + + + + pricegroup_id + + integer + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + startdate + + date + + + + + + + + + + + + + + enddate + + date + + + + + + + + + + + + + + + + + + + + Indexes on customer + + + customer_contact_key + lower((contact)::text) + + + + + + customer_customernumber_key + customernumber + + + + + + customer_id_key + id + + + + + + customer_name_key + lower((name)::text) + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>customertax</structname> + + + + + + + + Structure of <structname>customertax</structname> + + + + + customer_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + chart_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on customertax + + + customer_customer_id_key + customer_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>defaults</structname> + + + + + + + + Structure of <structname>defaults</structname> + + + + + setting_key + + text + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + value + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>department</structname> + + + + + + + + Structure of <structname>department</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + role + + character(1) + + + + + + DEFAULT 'P'::bpchar + + + + + + + + + + + + + + + + Indexes on department + + + department_id_key + id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>dpt_trans</structname> + + + + + + + + Structure of <structname>dpt_trans</structname> + + + + + trans_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + department_id + + integer + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>employee</structname> + + + + + + + + Structure of <structname>employee</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + login + + text + + + + + + + + + + + + + + name + + character varying(64) + + + + + + + + + + + + + + address1 + + character varying(32) + + + + + + + + + + + + + + address2 + + character varying(32) + + + + + + + + + + + + + + city + + character varying(32) + + + + + + + + + + + + + + state + + character varying(32) + + + + + + + + + + + + + + zipcode + + character varying(10) + + + + + + + + + + + + + + country + + character varying(32) + + + + + + + + + + + + + + workphone + + character varying(20) + + + + + + + + + + + + + + homephone + + character varying(20) + + + + + + + + + + + + + + startdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + enddate + + date + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + role + + character varying(20) + + + + + + + + + + + + + + sales + + boolean + + + + + + DEFAULT false + + + + + + + + + + email + + text + + + + + + + + + + + + + + ssn + + character varying(20) + + + + + + + + + + + + + + iban + + character varying(34) + + + + + + + + + + + + + + bic + + character varying(11) + + + + + + + + + + + + + + managerid + + integer + + + + + + + + + + + + + + employeenumber + + character varying(32) + + + + + + + + + + + + + + dob + + date + + + + + + + + + + + + + + + + + + + + Indexes on employee + + + employee_id_key + id + + + + + + employee_name_key + lower((name)::text) + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>exchangerate</structname> + + + + + + + + Structure of <structname>exchangerate</structname> + + + + + curr + + character(3) + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + transdate + + date + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + buy + + numeric + + + + + + + + + + + + + + sell + + numeric + + + + + + + + + + + + + + + + + + + + Indexes on exchangerate + + + exchangerate_ct_key + curr, transdate + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>gifi</structname> + + + + + + + + Structure of <structname>gifi</structname> + + + + + accno + + text + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>gl</structname> + + + + + + + + Structure of <structname>gl</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + reference + + text + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + transdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + department_id + + integer + + + + + + + + + + + + + + + + + + + + Indexes on gl + + + gl_description_key + lower(description) + + + + + + gl_employee_id_key + employee_id + + + + + + gl_id_key + id + + + + + + gl_reference_key + reference + + + + + + gl_transdate_key + transdate + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>inventory</structname> + + + + + + + + Structure of <structname>inventory</structname> + + + + + warehouse_id + + integer + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + trans_id + + integer + + + + + + + + + + + + + + orderitems_id + + integer + + + + + + + + + + + + + + qty + + numeric + + + + + + + + + + + + + + shippingdate + + date + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + entry_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>invoice</structname> + + + + + + + + Structure of <structname>invoice</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('invoiceid'::regclass) + + + + + + + + + + + + trans_id + + integer + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + qty + + integer + + + + + + + + + + + + + + allocated + + integer + + + + + + + + + + + + + + sellprice + + numeric + + + + + + + + + + + + + + fxsellprice + + numeric + + + + + + + + + + + + + + discount + + real + + + + + + + + + + + + + + assemblyitem + + boolean + + + + + + DEFAULT false + + + + + + + + + + unit + + character varying(5) + + + + + + + + + + + + + + project_id + + integer + + + + + + + + + + + + + + deliverydate + + date + + + + + + + + + + + + + + serialnumber + + text + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + + + + + + + Indexes on invoice + + + invoice_id_key + id + + + + + + invoice_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>jcitems</structname> + + + + + + + + Structure of <structname>jcitems</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('jcitemsid'::regclass) + + + + + + + + + + + + project_id + + integer + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + qty + + numeric + + + + + + + + + + + + + + allocated + + numeric + + + + + + + + + + + + + + sellprice + + numeric + + + + + + + + + + + + + + fxsellprice + + numeric + + + + + + + + + + + + + + serialnumber + + text + + + + + + + + + + + + + + checkedin + + timestamp with time zone + + + + + + + + + + + + + + checkedout + + timestamp with time zone + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + + + + + + + Indexes on jcitems + + + jcitems_id_key + id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>language</structname> + + + + + + + + Structure of <structname>language</structname> + + + + + code + + character varying(6) + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>makemodel</structname> + + + + + + + + Structure of <structname>makemodel</structname> + + + + + parts_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + make + + text + + + + + + + + + + + + + + model + + text + + + + + + + + + + + + + + + + + + + + Indexes on makemodel + + + makemodel_make_key + lower(make) + + + + + + makemodel_model_key + lower(model) + + + + + + makemodel_parts_id_key + parts_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>oe</structname> + + + + + + + + Structure of <structname>oe</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + ordnumber + + text + + + + + + + + + + + + + + transdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + vendor_id + + integer + + + + + + + + + + + + + + customer_id + + integer + + + + + + + + + + + + + + amount + + numeric + + + + + + + + + + + + + + netamount + + numeric + + + + + + + + + + + + + + reqdate + + date + + + + + + + + + + + + + + taxincluded + + boolean + + + + + + + + + + + + + + shippingpoint + + text + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + closed + + boolean + + + + + + DEFAULT false + + + + + + + + + + quotation + + boolean + + + + + + DEFAULT false + + + + + + + + + + quonumber + + text + + + + + + + + + + + + + + intnotes + + text + + + + + + + + + + + + + + department_id + + integer + + + + + + + + + + + + + + shipvia + + text + + + + + + + + + + + + + + language_code + + character varying(6) + + + + + + + + + + + + + + ponumber + + text + + + + + + + + + + + + + + terms + + smallint + + + + + + + + + + + + + + + + + + + + Indexes on oe + + + oe_employee_id_key + employee_id + + + + + + oe_id_key + id + + + + + + oe_ordnumber_key + ordnumber + + + + + + oe_transdate_key + transdate + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>orderitems</structname> + + + + + + + + Structure of <structname>orderitems</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('orderitemsid'::regclass) + + + + + + + + + + + + trans_id + + integer + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + qty + + numeric + + + + + + + + + + + + + + sellprice + + numeric + + + + + + + + + + + + + + discount + + numeric + + + + + + + + + + + + + + unit + + character varying(5) + + + + + + + + + + + + + + project_id + + integer + + + + + + + + + + + + + + reqdate + + date + + + + + + + + + + + + + + ship + + numeric + + + + + + + + + + + + + + serialnumber + + text + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + + + + + + + Indexes on orderitems + + + orderitems_id_key + id + + + + + + orderitems_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>parts</structname> + + + + + + + + Structure of <structname>parts</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + partnumber + + text + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + unit + + character varying(5) + + + + + + + + + + + + + + listprice + + numeric + + + + + + + + + + + + + + sellprice + + numeric + + + + + + + + + + + + + + lastcost + + numeric + + + + + + + + + + + + + + priceupdate + + date + + + + + + DEFAULT ('now'::text)::date + + + + + + + + + + weight + + numeric + + + + + + + + + + + + + + onhand + + numeric + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + makemodel + + boolean + + + + + + DEFAULT false + + + + + + + + + + assembly + + boolean + + + + + + DEFAULT false + + + + + + + + + + alternate + + boolean + + + + + + DEFAULT false + + + + + + + + + + rop + + real + + + + + + + + + + + + + + inventory_accno_id + + integer + + + + + + + + + + + + + + income_accno_id + + integer + + + + + + + + + + + + + + expense_accno_id + + integer + + + + + + + + + + + + + + bin + + text + + + + + + + + + + + + + + obsolete + + boolean + + + + + + DEFAULT false + + + + + + + + + + bom + + boolean + + + + + + DEFAULT false + + + + + + + + + + image + + text + + + + + + + + + + + + + + drawing + + text + + + + + + + + + + + + + + microfiche + + text + + + + + + + + + + + + + + partsgroup_id + + integer + + + + + + + + + + + + + + project_id + + integer + + + + + + + + + + + + + + avgcost + + numeric + + + + + + + + + + + + + + + + + + + + Indexes on parts + + + parts_description_key + lower(description) + + + + + + parts_id_key + id + + + + + + parts_partnumber_key + lower(partnumber) + + + + + + + + + + + Tables referencing partstax via Foreign Key Constraints + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>partscustomer</structname> + + + + + + + + Structure of <structname>partscustomer</structname> + + + + + parts_id + + integer + + + + + + + + + + + + + + customer_id + + integer + + + + + + + + + + + + + + pricegroup_id + + integer + + + + + + + + + + + + + + pricebreak + + numeric + + + + + + + + + + + + + + sellprice + + numeric + + + + + + + + + + + + + + validfrom + + date + + + + + + + + + + + + + + validto + + date + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + entry_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>partsgroup</structname> + + + + + + + + Structure of <structname>partsgroup</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + partsgroup + + text + + + + + + + + + + + + + + + + + + + + Indexes on partsgroup + + + partsgroup_id_key + id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>partstax</structname> + + + + + + + + Structure of <structname>partstax</structname> + + + + + parts_id + + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + REFERENCES + + + + + + + + + + + chart_id + + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + REFERENCES + + + + + + + + + + + taxcategory_id + + integer + + + + + + + + + + + + + REFERENCES + + + + + + + + + + + + + + + Indexes on partstax + + + partstax_parts_id_key + parts_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>partsvendor</structname> + + + + + + + + Structure of <structname>partsvendor</structname> + + + + + vendor_id + + integer + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + partnumber + + text + + + + + + + + + + + + + + leadtime + + smallint + + + + + + + + + + + + + + lastcost + + numeric + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + entry_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on partsvendor + + + partsvendor_parts_id_key + parts_id + + + + + + partsvendor_vendor_id_key + vendor_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>pricegroup</structname> + + + + + + + + Structure of <structname>pricegroup</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + pricegroup + + text + + + + + + + + + + + + + + + + + + + + Indexes on pricegroup + + + pricegroup_id_key + id + + + + + + pricegroup_pricegroup_key + pricegroup + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>project</structname> + + + + + + + + Structure of <structname>project</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + projectnumber + + text + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + startdate + + date + + + + + + + + + + + + + + enddate + + date + + + + + + + + + + + + + + parts_id + + integer + + + + + + + + + + + + + + production + + numeric + + + + + + + + + + + + + + completed + + numeric + + + + + + + + + + + + + + customer_id + + integer + + + + + + + + + + + + + + + + + + + + Indexes on project + + + project_id_key + id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>recurring</structname> + + + + + + + + Structure of <structname>recurring</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + reference + + text + + + + + + + + + + + + + + startdate + + date + + + + + + + + + + + + + + nextdate + + date + + + + + + + + + + + + + + enddate + + date + + + + + + + + + + + + + + repeat + + smallint + + + + + + + + + + + + + + unit + + character varying(6) + + + + + + + + + + + + + + howmany + + integer + + + + + + + + + + + + + + payment + + boolean + + + + + + DEFAULT false + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>recurringemail</structname> + + + + + + + + Structure of <structname>recurringemail</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + formname + + text + + + + + + + + + + + + + + format + + text + + + + + + + + + + + + + + message + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>recurringprint</structname> + + + + + + + + Structure of <structname>recurringprint</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + formname + + text + + + + + + + + + + + + + + format + + text + + + + + + + + + + + + + + printer + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>shipto</structname> + + + + + + + + Structure of <structname>shipto</structname> + + + + + trans_id + + integer + + + + + + + + + + + + + + shiptoname + + character varying(64) + + + + + + + + + + + + + + shiptoaddress1 + + character varying(32) + + + + + + + + + + + + + + shiptoaddress2 + + character varying(32) + + + + + + + + + + + + + + shiptocity + + character varying(32) + + + + + + + + + + + + + + shiptostate + + character varying(32) + + + + + + + + + + + + + + shiptozipcode + + character varying(10) + + + + + + + + + + + + + + shiptocountry + + character varying(32) + + + + + + + + + + + + + + shiptocontact + + character varying(64) + + + + + + + + + + + + + + shiptophone + + character varying(20) + + + + + + + + + + + + + + shiptofax + + character varying(20) + + + + + + + + + + + + + + shiptoemail + + text + + + + + + + + + + + + + + entry_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on shipto + + + shipto_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>sic</structname> + + + + + + + + Structure of <structname>sic</structname> + + + + + code + + character varying(6) + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + sictype + + character(1) + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>status</structname> + + + + + + + + Structure of <structname>status</structname> + + + + + trans_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + formname + + text + + + + + + + + + + + + + + printed + + boolean + + + + + + DEFAULT false + + + + + + + + + + emailed + + boolean + + + + + + DEFAULT false + + + + + + + + + + spoolfile + + text + + + + + + + + + + + + + + + + + + + + Indexes on status + + + status_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>tax</structname> + + + + + + + + Structure of <structname>tax</structname> + + + + + chart_id + + integer + + + + + + + PRIMARY KEY + + + + + + + + + + + + + REFERENCES + + + + + + + + + + + rate + + numeric + + + + + + + + + + + + + + taxnumber + + text + + + + + + + + + + + + + + validto + + date + + + + + + + + + + + + + + pass + + integer + + + + NOT NULL + + + + + + + + + + + + taxmodule_id + + integer + + + + + + + + NOT NULL + + + + DEFAULT 1 + + + + + REFERENCES + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>taxcategory</structname> + + + + + + + + Structure of <structname>taxcategory</structname> + + + + + taxcategory_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + taxcategoryname + + text + + + + NOT NULL + + + + + + + + + + + + taxmodule_id + + integer + + + + + + + + NOT NULL + + + + + + + REFERENCES + + + + + + + + + + + + + + + + + + Tables referencing partstax via Foreign Key Constraints + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>taxmodule</structname> + + + + + + + + Structure of <structname>taxmodule</structname> + + + + + taxmodule_id + + serial + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + taxmodulename + + text + + + + NOT NULL + + + + + + + + + + + + + + + + + + + + + Tables referencing tax via Foreign Key Constraints + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>transactions</structname> + + + + + + + + Structure of <structname>transactions</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + table_name + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>translation</structname> + + + + + + + + Structure of <structname>translation</structname> + + + + + trans_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + language_code + + character varying(6) + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + + + + + + + Indexes on translation + + + translation_trans_id_key + trans_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>vendor</structname> + + + + + + + + Structure of <structname>vendor</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + name + + character varying(64) + + + + + + + + + + + + + + address1 + + character varying(32) + + + + + + + + + + + + + + address2 + + character varying(32) + + + + + + + + + + + + + + city + + character varying(32) + + + + + + + + + + + + + + state + + character varying(32) + + + + + + + + + + + + + + zipcode + + character varying(10) + + + + + + + + + + + + + + country + + character varying(32) + + + + + + + + + + + + + + contact + + character varying(64) + + + + + + + + + + + + + + phone + + character varying(20) + + + + + + + + + + + + + + fax + + character varying(20) + + + + + + + + + + + + + + email + + text + + + + + + + + + + + + + + notes + + text + + + + + + + + + + + + + + terms + + smallint + + + + + + + + + + + + + + taxincluded + + boolean + + + + + + DEFAULT false + + + + + + + + + + vendornumber + + character varying(32) + + + + + + + + + + + + + + cc + + text + + + + + + + + + + + + + + bcc + + text + + + + + + + + + + + + + + gifi_accno + + character varying(30) + + + + + + + + + + + + + + business_id + + integer + + + + + + + + + + + + + + taxnumber + + character varying(32) + + + + + + + + + + + + + + sic_code + + character varying(6) + + + + + + + + + + + + + + discount + + numeric + + + + + + + + + + + + + + creditlimit + + numeric + + + + + + + + + + + + + + iban + + character varying(34) + + + + + + + + + + + + + + bic + + character varying(11) + + + + + + + + + + + + + + employee_id + + integer + + + + + + + + + + + + + + language_code + + character varying(6) + + + + + + + + + + + + + + pricegroup_id + + integer + + + + + + + + + + + + + + curr + + character(3) + + + + + + + + + + + + + + startdate + + date + + + + + + + + + + + + + + enddate + + date + + + + + + + + + + + + + + + + + + + + Indexes on vendor + + + vendor_contact_key + lower((contact)::text) + + + + + + vendor_id_key + id + + + + + + vendor_name_key + lower((name)::text) + + + + + + vendor_vendornumber_key + vendornumber + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>vendortax</structname> + + + + + + + + Structure of <structname>vendortax</structname> + + + + + vendor_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + chart_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + + + + + + + Indexes on vendortax + + + vendortax_vendor_id_key + vendor_id + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>warehouse</structname> + + + + + + + + Structure of <structname>warehouse</structname> + + + + + id + + integer + + + PRIMARY KEY + + + + + + + + + + DEFAULT nextval('id'::regclass) + + + + + + + + + + + + description + + text + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + Table: + + <structname>yearend</structname> + + + + + + + + Structure of <structname>yearend</structname> + + + + + trans_id + + integer + + + PRIMARY KEY + + + + + + + + + + + + + + + + + + + + transdate + + date + + + + + + + + + + + + + + + + + + + + + + + + +
+ + + + +
+ + add_custom_field( character varying, character varying, character varying ) + + + add_custom_field( character varying, character varying, character varying ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + boolean + + + + + +DECLARE +table_name ALIAS FOR $1; +new_field_name ALIAS FOR $2; +field_datatype ALIAS FOR $3; + +BEGIN + EXECUTE 'SELECT TABLE_ID FROM custom_table_catalog + WHERE extends = ''' || table_name || ''' '; + IF NOT FOUND THEN + BEGIN + INSERT INTO custom_table_catalog (extends) + VALUES (table_name); + EXECUTE 'CREATE TABLE custom_'||table_name || + ' (row_id INT PRIMARY KEY)'; + EXCEPTION WHEN duplicate_table THEN + -- do nothing + END; + END IF; + EXECUTE 'INSERT INTO custom_field_catalog (field_name, table_id) + VALUES ( ''' || new_field_name ||''', (SELECT table_id FROM custom_table_catalog + WHERE extends = '''|| table_name || '''))'; + EXECUTE 'ALTER TABLE custom_'||table_name || ' ADD COLUMN ' + || new_field_name || ' ' || field_datatype; + RETURN TRUE; +END; + + +
+ + +
+ + avgcost( integer ) + + + avgcost( integer ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + double precision + + + + + + +DECLARE + +v_cost float; +v_qty float; +v_parts_id alias for $1; + +BEGIN + + SELECT INTO v_cost, v_qty SUM(i.sellprice * i.qty), SUM(i.qty) + FROM invoice i + JOIN ap a ON (a.id = i.trans_id) + WHERE i.parts_id = v_parts_id; + + IF v_cost IS NULL THEN + v_cost := 0; + END IF; + + IF NOT v_qty IS NULL THEN + IF v_qty = 0 THEN + v_cost := 0; + ELSE + v_cost := v_cost/v_qty; + END IF; + END IF; + +RETURN v_cost; +END; + + +
+ + +
+ + check_department( ) + + + check_department( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + + +declare + dpt_id int; + +begin + + if new.department_id = 0 then + delete from dpt_trans where trans_id = new.id; + return NULL; + end if; + + select into dpt_id trans_id from dpt_trans where trans_id = new.id; + + if dpt_id > 0 then + update dpt_trans set department_id = new.department_id where trans_id = dpt_id; + else + insert into dpt_trans (trans_id, department_id) values (new.id, new.department_id); + end if; +return NULL; + +end; + + +
+ + +
+ + check_inventory( ) + + + check_inventory( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + + +declare + itemid int; + row_data inventory%rowtype; + +begin + + if not old.quotation then + for row_data in select * from inventory where trans_id = old.id loop + select into itemid id from orderitems where trans_id = old.id and id = row_data.orderitems_id; + + if itemid is null then + delete from inventory where trans_id = old.id and orderitems_id = row_data.orderitems_id; + end if; + end loop; + end if; +return old; +end; + + +
+ + +
+ + del_customer( ) + + + del_customer( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +begin + delete from shipto where trans_id = old.id; + delete from customertax where customer_id = old.id; + delete from partscustomer where customer_id = old.id; + return NULL; +end; + + +
+ + +
+ + del_department( ) + + + del_department( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +begin + delete from dpt_trans where trans_id = old.id; + return NULL; +end; + + +
+ + +
+ + del_exchangerate( ) + + + del_exchangerate( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + + +declare + t_transdate date; + t_curr char(3); + t_id int; + d_curr text; + +begin + + select into d_curr substr(value,1,3) from defaults where setting_key = 'curr'; + + if TG_RELNAME = 'ar' then + select into t_curr, t_transdate curr, transdate from ar where id = old.id; + end if; + if TG_RELNAME = 'ap' then + select into t_curr, t_transdate curr, transdate from ap where id = old.id; + end if; + if TG_RELNAME = 'oe' then + select into t_curr, t_transdate curr, transdate from oe where id = old.id; + end if; + + if d_curr != t_curr then + + select into t_id a.id from acc_trans ac + join ar a on (a.id = ac.trans_id) + where a.curr = t_curr + and ac.transdate = t_transdate + + except select a.id from ar a where a.id = old.id + + union + + select a.id from acc_trans ac + join ap a on (a.id = ac.trans_id) + where a.curr = t_curr + and ac.transdate = t_transdate + + except select a.id from ap a where a.id = old.id + + union + + select o.id from oe o + where o.curr = t_curr + and o.transdate = t_transdate + + except select o.id from oe o where o.id = old.id; + + if not found then + delete from exchangerate where curr = t_curr and transdate = t_transdate; + end if; + end if; +return old; + +end; + + +
+ + +
+ + del_recurring( ) + + + del_recurring( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +BEGIN + DELETE FROM recurring WHERE id = old.id; + DELETE FROM recurringemail WHERE id = old.id; + DELETE FROM recurringprint WHERE id = old.id; + RETURN NULL; +END; + + +
+ + +
+ + del_vendor( ) + + + del_vendor( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +begin + delete from shipto where trans_id = old.id; + delete from vendortax where vendor_id = old.id; + delete from partsvendor where vendor_id = old.id; + return NULL; +end; + + +
+ + +
+ + del_yearend( ) + + + del_yearend( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +begin + delete from yearend where trans_id = old.id; + return NULL; +end; + + +
+ + +
+ + drop_custom_field( character varying, character varying ) + + + drop_custom_field( character varying, character varying ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + boolean + + + + + +DECLARE +table_name ALIAS FOR $1; +custom_field_name ALIAS FOR $2; +BEGIN + DELETE FROM custom_field_catalog + WHERE field_name = custom_field_name AND + table_id = (SELECT table_id FROM custom_table_catalog + WHERE extends = table_name); + EXECUTE 'ALTER TABLE custom_' || table_name || + ' DROP COLUMN ' || custom_field_name; + RETURN TRUE; +END; + + +
+ + +
+ + lastcost( integer ) + + + lastcost( integer ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + double precision + + + + + + +DECLARE + +v_cost float; +v_parts_id alias for $1; + +BEGIN + + SELECT INTO v_cost sellprice FROM invoice i + JOIN ap a ON (a.id = i.trans_id) + WHERE i.parts_id = v_parts_id + ORDER BY a.transdate desc, a.id desc + LIMIT 1; + + IF v_cost IS NULL THEN + v_cost := 0; + END IF; + +RETURN v_cost; +END; + + +
+ + +
+ + trigger_parts_short( ) + + + trigger_parts_short( ) + + + + + Function Properties + + Language + Return Type + + PLPGSQL + "trigger" + + + + + +BEGIN + IF NEW.onhand >= NEW.rop THEN + NOTIFY parts_short; + END IF; + RETURN NEW; +END; + + +
+ + +
+ + update_user( integer, text ) + + + update_user( integer, text ) + + + + + Function Properties + + Language + Return Type + + SQL + integer + + + + Takes int4 which is users.id and text which is username. Will update username based on id. Username is unique + + UPDATE users SET username = '$2' WHERE id = $1; + SELECT 1; + + +
+ + + + + diff --git a/doc/database/ledgersmb.zigzag.dia b/doc/database/ledgersmb.zigzag.dia new file mode 100644 index 00000000..51ead1b9 --- /dev/null +++ b/doc/database/ledgersmb.zigzag.dia @@ -0,0 +1,14219 @@ + + + + + + + + + + + + + + + + + + + + + + + + #acc_trans# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # source# + + + #text# + + + + + + + + + + + + + + + + + + + + # cleared# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # fx_transaction# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # memo# + + + #text# + + + + + + + + + + + + + + + + + + + + # invoice_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ap# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # invnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # paid# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # datepaid# + + + #date# + + + + + + + + + + + + + + + + + + + + # duedate# + + + #date# + + + + + + + + + + + + + + + + + + + + # invoice# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # till# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #ar# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # invnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # paid# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # datepaid# + + + #date# + + + + + + + + + + + + + + + + + + + + # duedate# + + + #date# + + + + + + + + + + + + + + + + + + + + # invoice# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # till# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #assembly# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # bom# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # adj# + + + #boolean# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #audittrail# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # tablename# + + + #text# + + + + + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # action# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #timestamp without time zone# + + + + #now()# + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #bigserial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #business# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #chart# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # charttype# + + + #character(1)# + + + + #'A'::bpchar# + + + + + + + + + + + + + + + + # category# + + + #character(1)# + + + + + + + + + + + + + + + + + + + + # link# + + + #text# + + + + + + + + + + + + + + + + + + + + # gifi_accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # contra# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_field_catalog# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # field_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # table_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # field_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_table_catalog# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # table_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # extends# + + + #text# + + + + + + + + + + + + + + + + + + + + # table_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #customer# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # contact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # phone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # fax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # creditlimit# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # customernumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # cc# + + + #text# + + + + + + + + + + + + + + + + + + + + # bcc# + + + #text# + + + + + + + + + + + + + + + + + + + + # business_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # sic_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #customertax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #defaults# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # setting_key# + + + #text# + + + + + + + + + + + + + + + + + + + + # value# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #department# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # role# + + + #character(1)# + + + + #'P'::bpchar# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #dpt_trans# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #employee# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # login# + + + #text# + + + + + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # workphone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # homephone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # role# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # sales# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # ssn# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # managerid# + + + #integer# + + + + + + + + + + + + + + + + + + + + # employeenumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # dob# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #exchangerate# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # buy# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sell# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #gifi# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # accno# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #gl# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #inventory# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # warehouse_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # orderitems_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # shippingdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #invoice# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('invoicei ... lass)# + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #integer# + + + + + + + + + + + + + + + + + + + + # allocated# + + + #integer# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # fxsellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # discount# + + + #real# + + + + + + + + + + + + + + + + + + + + # assemblyitem# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # deliverydate# + + + #date# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #jcitems# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('jcitemsi ... lass)# + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # allocated# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # fxsellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # checkedin# + + + #timestamp with time zone# + + + + + + + + + + + + + + + + + + + + # checkedout# + + + #timestamp with time zone# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #language# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #makemodel# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # make# + + + #text# + + + + + + + + + + + + + + + + + + + + # model# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #oe# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # ordnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # amount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # netamount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # reqdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + + + + + + + + + + + + + + + + + # shippingpoint# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # closed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # quotation# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # quonumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # intnotes# + + + #text# + + + + + + + + + + + + + + + + + + + + # department_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shipvia# + + + #text# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # ponumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #orderitems# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('orderite ... lass)# + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # qty# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # reqdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # ship# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # serialnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #parts# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # partnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(5)# + + + + + + + + + + + + + + + + + + + + # listprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # lastcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # priceupdate# + + + #date# + + + + #('now'::text)::date# + + + + + + + + + + + + + + + + # weight# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # onhand# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # makemodel# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # assembly# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # alternate# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # rop# + + + #real# + + + + + + + + + + + + + + + + + + + + # inventory_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # income_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # expense_accno_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # bin# + + + #text# + + + + + + + + + + + + + + + + + + + + # obsolete# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # bom# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # image# + + + #text# + + + + + + + + + + + + + + + + + + + + # drawing# + + + #text# + + + + + + + + + + + + + + + + + + + + # microfiche# + + + #text# + + + + + + + + + + + + + + + + + + + + # partsgroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # project_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # avgcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partscustomer# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # pricebreak# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # sellprice# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # validfrom# + + + #date# + + + + + + + + + + + + + + + + + + + + # validto# + + + #date# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partsgroup# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # partsgroup# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxcategory_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partsvendor# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # partnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # leadtime# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # lastcost# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #pricegroup# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # pricegroup# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #project# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # projectnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # parts_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # production# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # completed# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # customer_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurring# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # reference# + + + #text# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # nextdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + # repeat# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # unit# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # howmany# + + + #integer# + + + + + + + + + + + + + + + + + + + + # payment# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurringemail# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # format# + + + #text# + + + + + + + + + + + + + + + + + + + + # message# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #recurringprint# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # format# + + + #text# + + + + + + + + + + + + + + + + + + + + # printer# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #shipto# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # shiptoname# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # shiptoaddress1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptoaddress2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptocity# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptostate# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptozipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # shiptocountry# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # shiptocontact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # shiptophone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # shiptofax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # shiptoemail# + + + #text# + + + + + + + + + + + + + + + + + + + + # entry_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #sic# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # sictype# + + + #character(1)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #status# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # formname# + + + #text# + + + + + + + + + + + + + + + + + + + + # printed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # emailed# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # spoolfile# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #tax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # rate# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #text# + + + + + + + + + + + + + + + + + + + + # validto# + + + #date# + + + + + + + + + + + + + + + + + + + + # pass# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #integer# + + + + #1# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #taxcategory# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # taxcategory_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # taxcategoryname# + + + #text# + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #taxmodule# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # taxmodule_id# + + + #serial# + + + + + + + + + + + + + + + + + + + + # taxmodulename# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #transactions# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # table_name# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #translation# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #vendor# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # name# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # address1# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # address2# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # city# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # state# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # zipcode# + + + #character varying(10)# + + + + + + + + + + + + + + + + + + + + # country# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # contact# + + + #character varying(64)# + + + + + + + + + + + + + + + + + + + + # phone# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # fax# + + + #character varying(20)# + + + + + + + + + + + + + + + + + + + + # email# + + + #text# + + + + + + + + + + + + + + + + + + + + # notes# + + + #text# + + + + + + + + + + + + + + + + + + + + # terms# + + + #smallint# + + + + + + + + + + + + + + + + + + + + # taxincluded# + + + #boolean# + + + + #false# + + + + + + + + + + + + + + + + # vendornumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # cc# + + + #text# + + + + + + + + + + + + + + + + + + + + # bcc# + + + #text# + + + + + + + + + + + + + + + + + + + + # gifi_accno# + + + #character varying(30)# + + + + + + + + + + + + + + + + + + + + # business_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # taxnumber# + + + #character varying(32)# + + + + + + + + + + + + + + + + + + + + # sic_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # discount# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # creditlimit# + + + #numeric# + + + + + + + + + + + + + + + + + + + + # iban# + + + #character varying(34)# + + + + + + + + + + + + + + + + + + + + # bic# + + + #character varying(11)# + + + + + + + + + + + + + + + + + + + + # employee_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # language_code# + + + #character varying(6)# + + + + + + + + + + + + + + + + + + + + # pricegroup_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # curr# + + + #character(3)# + + + + + + + + + + + + + + + + + + + + # startdate# + + + #date# + + + + + + + + + + + + + + + + + + + + # enddate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #vendortax# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # vendor_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # chart_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #warehouse# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # id# + + + #integer# + + + + #nextval('id'::regclass)# + + + + + + + + + + + + + + + + # description# + + + #text# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #yearend# + + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + # trans_id# + + + #integer# + + + + + + + + + + + + + + + + + + + + # transdate# + + + #date# + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #acc_trans_chart_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #custom_field_catalog_table_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_parts_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_chart_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #partstax_taxcategory_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #tax_chart_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #tax_taxmodule_id_fkey# + + + ## + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + #taxcategory_taxmodule_id_fkey# + + + ## + + + + + + + + + + + + -- cgit v1.2.3