#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# #serial# # invnumber# #text# # transdate# #date# #('now'::text)::date# # entity_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# # person_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# #serial# # invnumber# #text# # transdate# #date# #('now'::text)::date# # entity_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# # person_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()# # person_id# #integer# # entry_id# #bigserial# #business# ## # id# #serial# # description# #text# # discount# #numeric# #chart# ## # id# #serial# # accno# #text# # description# #text# # charttype# #character(1)# #'A'::bpchar# # category# #character(1)# # link# #text# # gifi_accno# #text# # contra# #boolean# #false# #company# ## # id# #serial# # entity_id# #integer# # legal_name# #text# # entity_class_id# #integer# # primary_location_id# #integer# # tax_id# #text# #company_legal_name_check# #CHECK ((legal_name ~ '[[:alnum ... ext))# ## #company_to_contact# # To keep track of the relationship ... pany # # company_id# #integer# # contact_class_id# #integer# # contact# #text# #company_to_contact_contact_check# #CHECK ((contact ~ '[[:alnum:]_ ... ext))# ## #company_to_entity# ## # company_id# #integer# # entity_id# #integer# # related_how# #text# # created# #date# #('now'::text)::date# #company_to_entity_check# #CHECK ((entity_id <> company_id))# ## #company_to_location# ## # location_id# #integer# # company_id# #integer# #contact_class# ## # id# #serial# # class# #text# #contact_class_class_check# #CHECK (("class" ~ '[[:alnum:]_ ... ext))# ## #country# ## # id# #serial# # name# #text# # short_name# #text# # itu# #text# #country_name_check# #CHECK ((name ~ '[[:alnum:]_]'::text))# ## #country_short_name_check# #CHECK ((short_name ~ '[[:alnum ... ext))# ## #custom_field_catalog# ## # field_id# #serial# # table_id# #integer# # field_name# #text# #custom_table_catalog# ## # table_id# #serial# # extends# #text# # table_name# #text# #customer# # This is now a metadata table that ... ment # # id# #serial# # entity_id# #integer# # discount# #numeric# # taxincluded# #boolean# #false# # creditlimit# #numeric# # terms# #smallint# # customernumber# #character varying(32)# # cc# #text# # bcc# #text# # business_id# #integer# # sic_code# #character varying(6)# # iban# #character varying(34)# # bic# #character varying(11)# # language_code# #character varying(6)# # pricegroup_id# #integer# # curr# #character(3)# # startdate# #date# #('now'::text)::date# # enddate# #date# # invoice_notes# #text# #customertax# ## # customer_id# #integer# # chart_id# #integer# #defaults# ## # setting_key# #text# # value# #text# #department# ## # id# #serial# # description# #text# # role# #character(1)# #'P'::bpchar# #dpt_trans# ## # trans_id# #integer# # department_id# #integer# #employee# # Is a metadata table specific to employees # # id# #serial# # entity_id# #integer# # login# #text# # startdate# #date# #('now'::text)::date# # enddate# #date# # notes# #text# # role# #character varying(20)# # sales# #boolean# #false# # ssn# #character varying(20)# # iban# #character varying(34)# # bic# #character varying(11)# # managerid# #integer# # employeenumber# #character varying(32)# # dob# #date# #entity# # The primary entity table to map to ... acts # # id# #serial# # name# #text# # entity_class# #integer# #entity_name_check# #CHECK ((name ~ '[[:alnum:]_]'::text))# ## #entity_class# # Defines the class type such as ven ... oyee # # id# #serial# # class# #text# # active# #boolean# #true# #entity_class_class_check# #CHECK (("class" ~ '[[:alnum:]_ ... ext))# ## #entity_class_to_entity# # Relation builder for classes to entity # # entity_class_id# #integer# # entity_id# #integer# #entity_other_name# # Similar to company_other_name, a p ... son. # # entity_id# #integer# # other_name# #text# #entity_other_name_other_name_check# #CHECK ((other_name ~ '[[:alnum ... ext))# ## #exchangerate# ## # curr# #character(3)# # transdate# #date# # buy# #numeric# # sell# #numeric# #gifi# ## # accno# #text# # description# #text# #gl# ## # id# #serial# # reference# #text# # description# #text# # transdate# #date# #('now'::text)::date# # person_id# #integer# # notes# #text# # department_id# #integer# #inventory# ## # warehouse_id# #integer# # parts_id# #integer# # trans_id# #integer# # orderitems_id# #integer# # qty# #numeric# # shippingdate# #date# # person_id# #integer# # entry_id# #serial# #invoice# ## # id# #serial# # 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# #serial# # 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# # person_id# #integer# # notes# #text# #language# ## # code# #character varying(6)# # description# #text# #location# ## # id# #serial# # line_one# #text# # line_two# #text# # line_three# #text# # city_province# #text# # country_id# #integer# # mail_code# #text# #location_city_province_check# #CHECK ((city_province ~ '[[:al ... ext))# ## #location_line_one_check# #CHECK ((line_one ~ '[[:alnum:] ... ext))# ## #location_mail_code_check# #CHECK ((mail_code ~ '[[:alnum: ... ext))# ## #makemodel# ## # parts_id# #integer# # make# #text# # model# #text# #oe# ## # id# #serial# # ordnumber# #text# # transdate# #date# #('now'::text)::date# # entity_id# #integer# # amount# #numeric# # netamount# #numeric# # reqdate# #date# # taxincluded# #boolean# # shippingpoint# #text# # notes# #text# # curr# #character(3)# # person_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# # oe_class_id# #integer# #oe_class# # This could probably be done better ... tion # # id# #smallint# # oe_class# #text# #oe_class_id_check# #CHECK (((id = 1) OR (id = 2)))# ## #orderitems# ## # id# #serial# # 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# #serial# # 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# #serial# # partsgroup# #text# #partstax# ## # parts_id# #integer# # chart_id# #integer# # taxcategory_id# #integer# #partsvendor# ## # entity_id# #integer# # parts_id# #integer# # partnumber# #text# # leadtime# #smallint# # lastcost# #numeric# # curr# #character(3)# # entry_id# #serial# #person# # Every person, must have an entity ... _id. # # id# #serial# # entity_id# #integer# # salutation_id# #integer# # first_name# #text# # middle_name# #text# # last_name# #text# # primary_location_id# #integer# #person_first_name_check# #CHECK ((first_name ~ '[[:alnum ... ext))# ## #person_last_name_check# #CHECK ((last_name ~ '[[:alnum: ... ext))# ## #person_to_company# ## # location_id# #integer# # person_id# #integer# #person_to_contact# # To keep track of the relationship ... dual # # person_id# #integer# # contact_class_id# #integer# # contact# #text# #person_to_contact_contact_check# #CHECK ((contact ~ '[[:alnum:]_ ... ext))# ## #person_to_entity# ## # person_id# #integer# # entity_id# #integer# # related_how# #text# # created# #date# #('now'::text)::date# #person_to_entity_check# #CHECK ((entity_id <> person_id))# ## #pricegroup# ## # id# #serial# # pricegroup# #text# #project# ## # id# #serial# # 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# #salutation# ## # id# #serial# # salutation# #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# # Now a meta data table # # id# #serial# # entity_id# #integer# # 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)# # language_code# #character varying(6)# # pricegroup_id# #integer# # curr# #character(3)# # startdate# #date# # enddate# #date# #vendortax# ## # vendor_id# #integer# # chart_id# #integer# #warehouse# ## # id# #serial# # description# #text# #yearend# ## # trans_id# #integer# # transdate# #date# #acc_trans_chart_id_fkey# ## #ap_entity_id_fkey# ## #ap_person_id_fkey# ## #ar_entity_id_fkey# ## #ar_person_id_fkey# ## #audittrail_person_id_fkey# ## #company_entity_id_fkey# ## #company_entity_class_id_fkey# ## #company_primary_location_id_fkey# ## #company_to_contact_company_id_fkey# ## #company_to_contact_contact_class_id_fkey# ## #company_to_entity_company_id_fkey# ## #company_to_entity_entity_id_fkey# ## #company_to_location_location_id_fkey# ## #company_to_location_company_id_fkey# ## #custom_field_catalog_table_id_fkey# ## #customer_entity_id_fkey# ## #employee_entity_id_fkey# ## #entity_entity_class_fkey# ## #entity_class_to_entity_entity_class_id_fkey# ## #entity_class_to_entity_entity_id_fkey# ## #entity_other_name_entity_id_fkey# ## #gl_person_id_fkey# ## #inventory_person_id_fkey# ## #jcitems_person_id_fkey# ## #location_country_id_fkey# ## #oe_entity_id_fkey# ## #oe_person_id_fkey# ## #oe_oe_class_id_fkey# ## #partstax_parts_id_fkey# ## #partstax_chart_id_fkey# ## #partstax_taxcategory_id_fkey# ## #partsvendor_entity_id_fkey# ## #person_entity_id_fkey# ## #person_salutation_id_fkey# ## #person_primary_location_id_fkey# ## #person_to_company_location_id_fkey# ## #person_to_company_person_id_fkey# ## #person_to_contact_person_id_fkey# ## #person_to_contact_contact_class_id_fkey# ## #person_to_entity_person_id_fkey# ## #person_to_entity_entity_id_fkey# ## #tax_chart_id_fkey# ## #tax_taxmodule_id_fkey# ## #taxcategory_taxmodule_id_fkey# ## #vendor_entity_id_fkey# ##