summaryrefslogtreecommitdiff
path: root/doc/database/ledgersmb.dot
diff options
context:
space:
mode:
Diffstat (limited to 'doc/database/ledgersmb.dot')
-rw-r--r--doc/database/ledgersmb.dot118
1 files changed, 118 insertions, 0 deletions
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 = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > source </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > cleared </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > fx_transaction </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > memo </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > invoice_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> </TABLE>> ];
+
+"ap" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
+
+"ar" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > invnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > paid </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > datepaid </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > duedate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > invoice </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > till </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> </TABLE>> ];
+
+"assembly" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > bom </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > adj </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ];
+
+"audittrail" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > tablename </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > action </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > transdate </TD><TD align="left" > timestamp without time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > bigserial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+
+"business" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"chart" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > charttype </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > category </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > link </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > contra </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+
+"custom_field_catalog" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > field_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > table_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > field_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"custom_table_catalog" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > table_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > extends </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > table_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"customer" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > contact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > phone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > fax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > customernumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > taxnumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> <TR><TD PORT="ltcol28" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol28"> </TD></TR> <TR><TD PORT="ltcol29" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol29"> </TD></TR> <TR><TD PORT="ltcol30" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol30"> </TD></TR> <TR><TD PORT="ltcol31" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol31"> </TD></TR> </TABLE>> ];
+
+"customertax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"defaults" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > setting_key </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > value </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"department" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > role </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"dpt_trans" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"employee" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > login </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > workphone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > homephone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > role </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > sales </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > ssn </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > managerid </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > employeenumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > dob </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> </TABLE>> ];
+
+"exchangerate" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > buy </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > sell </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+
+"gifi" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > accno </TD><TD align="left" > text </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"gl" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+
+"inventory" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > warehouse_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > orderitems_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > shippingdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> </TABLE>> ];
+
+"invoice" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > discount </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > assemblyitem </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > deliverydate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> </TABLE>> ];
+
+"jcitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > allocated </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > fxsellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > checkedin </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > checkedout </TD><TD align="left" > timestamp with time zone </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+
+"language" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"makemodel" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > make </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > model </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"oe" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > ordnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > amount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > netamount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > shippingpoint </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > closed </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > quotation </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > quonumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > intnotes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > department_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > shipvia </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > ponumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> </TABLE>> ];
+
+"orderitems" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > qty </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > reqdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > ship </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > serialnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+
+"parts" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(5) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > listprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > priceupdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > weight </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > onhand </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > makemodel </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > assembly </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > alternate </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > rop </TD><TD align="left" > real </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > inventory_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > income_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > expense_accno_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > bin </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > obsolete </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > bom </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > image </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > drawing </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > microfiche </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > partsgroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > project_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > avgcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> </TABLE>> ];
+
+"partscustomer" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > pricebreak </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > sellprice </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > validfrom </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > validto </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
+
+"partsgroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > partsgroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"partstax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > taxcategory_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"partsvendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > partnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > leadtime </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > lastcost </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> </TABLE>> ];
+
+"pricegroup" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > pricegroup </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"project" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > projectnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > parts_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > production </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > completed </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > customer_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
+
+"recurring" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > reference </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > nextdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > repeat </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > unit </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > howmany </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > payment </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> </TABLE>> ];
+
+"recurringemail" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > format </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > message </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+
+"recurringprint" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > format </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > printer </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> </TABLE>> ];
+
+"shipto" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > shiptoname </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > shiptoaddress1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > shiptoaddress2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > shiptocity </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > shiptostate </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > shiptozipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > shiptocountry </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > shiptocontact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > shiptophone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > shiptofax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > shiptoemail </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > entry_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> </TABLE>> ];
+
+"sic" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > sictype </TD><TD align="left" > character(1) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"status" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > formname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > printed </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > emailed </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > spoolfile </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> </TABLE>> ];
+
+"tax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > rate </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > taxnumber </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > validto </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > pass </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > taxmodule_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol6"> </TD></TR> </TABLE>> ];
+
+"taxcategory" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > taxcategory_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > taxcategoryname </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > taxmodule_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > FK </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"taxmodule" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > taxmodule_id </TD><TD align="left" > serial </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > taxmodulename </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"transactions" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > table_name </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"translation" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> </TABLE>> ];
+
+"vendor" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > name </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> <TR><TD PORT="ltcol3" ></TD><TD align="left" > address1 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol3"> </TD></TR> <TR><TD PORT="ltcol4" ></TD><TD align="left" > address2 </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol4"> </TD></TR> <TR><TD PORT="ltcol5" ></TD><TD align="left" > city </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol5"> </TD></TR> <TR><TD PORT="ltcol6" ></TD><TD align="left" > state </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol6"> </TD></TR> <TR><TD PORT="ltcol7" ></TD><TD align="left" > zipcode </TD><TD align="left" > character varying(10) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol7"> </TD></TR> <TR><TD PORT="ltcol8" ></TD><TD align="left" > country </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol8"> </TD></TR> <TR><TD PORT="ltcol9" ></TD><TD align="left" > contact </TD><TD align="left" > character varying(64) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol9"> </TD></TR> <TR><TD PORT="ltcol10" ></TD><TD align="left" > phone </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol10"> </TD></TR> <TR><TD PORT="ltcol11" ></TD><TD align="left" > fax </TD><TD align="left" > character varying(20) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol11"> </TD></TR> <TR><TD PORT="ltcol12" ></TD><TD align="left" > email </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol12"> </TD></TR> <TR><TD PORT="ltcol13" ></TD><TD align="left" > notes </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol13"> </TD></TR> <TR><TD PORT="ltcol14" ></TD><TD align="left" > terms </TD><TD align="left" > smallint </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol14"> </TD></TR> <TR><TD PORT="ltcol15" ></TD><TD align="left" > taxincluded </TD><TD align="left" > boolean </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol15"> </TD></TR> <TR><TD PORT="ltcol16" ></TD><TD align="left" > vendornumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol16"> </TD></TR> <TR><TD PORT="ltcol17" ></TD><TD align="left" > cc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol17"> </TD></TR> <TR><TD PORT="ltcol18" ></TD><TD align="left" > bcc </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol18"> </TD></TR> <TR><TD PORT="ltcol19" ></TD><TD align="left" > gifi_accno </TD><TD align="left" > character varying(30) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol19"> </TD></TR> <TR><TD PORT="ltcol20" ></TD><TD align="left" > business_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol20"> </TD></TR> <TR><TD PORT="ltcol21" ></TD><TD align="left" > taxnumber </TD><TD align="left" > character varying(32) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol21"> </TD></TR> <TR><TD PORT="ltcol22" ></TD><TD align="left" > sic_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol22"> </TD></TR> <TR><TD PORT="ltcol23" ></TD><TD align="left" > discount </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol23"> </TD></TR> <TR><TD PORT="ltcol24" ></TD><TD align="left" > creditlimit </TD><TD align="left" > numeric </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol24"> </TD></TR> <TR><TD PORT="ltcol25" ></TD><TD align="left" > iban </TD><TD align="left" > character varying(34) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol25"> </TD></TR> <TR><TD PORT="ltcol26" ></TD><TD align="left" > bic </TD><TD align="left" > character varying(11) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol26"> </TD></TR> <TR><TD PORT="ltcol27" ></TD><TD align="left" > employee_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol27"> </TD></TR> <TR><TD PORT="ltcol28" ></TD><TD align="left" > language_code </TD><TD align="left" > character varying(6) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol28"> </TD></TR> <TR><TD PORT="ltcol29" ></TD><TD align="left" > pricegroup_id </TD><TD align="left" > integer </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol29"> </TD></TR> <TR><TD PORT="ltcol30" ></TD><TD align="left" > curr </TD><TD align="left" > character(3) </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol30"> </TD></TR> <TR><TD PORT="ltcol31" ></TD><TD align="left" > startdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol31"> </TD></TR> <TR><TD PORT="ltcol32" ></TD><TD align="left" > enddate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol32"> </TD></TR> </TABLE>> ];
+
+"vendortax" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > vendor_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > chart_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"warehouse" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > description </TD><TD align="left" > text </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+"yearend" [shape = plaintext, label = < <TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR ><TD PORT="ltcol0"> </TD> <TD bgcolor="grey90" border="1" COLSPAN="4"> \N </TD> <TD PORT="rtcol0"></TD></TR> <TR><TD PORT="ltcol1" ></TD><TD align="left" > trans_id </TD><TD align="left" > integer </TD><TD align="left" > PK </TD><TD align="left" > </TD><TD align="left" PORT="rtcol1"> </TD></TR> <TR><TD PORT="ltcol2" ></TD><TD align="left" > transdate </TD><TD align="left" > date </TD><TD align="left" > </TD><TD align="left" > </TD><TD align="left" PORT="rtcol2"> </TD></TR> </TABLE>> ];
+
+
+
+"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"];
+}