aqbooksellers
| 欄位 | 型態 | 範例 |
| id | int(11) | |
| name | text | |
| address1 | text | |
| address2 | text | |
| address3 | text | |
| address4 | text | |
| phone | varchar(30) | |
| accountnumber | text | |
| othersupplier | text | |
| currency | char(3) | |
| deliverydays | smallint(6) | |
| followupdays | smallint(6) | |
| followupscancel | ||
| specialty | text | |
| booksellerfax | text | |
| notes | text | |
| bookselleremail | text | |
| booksellerurl | text | |
| contact | varchar(100 | |
| postal | text | |
| url | varchar(255) | |
| contpos | varchar(100) | |
| contphone | varchar(100) | |
| contfax | varchar(100) | |
| contaltphone | varchar(100) | |
| contemail | varchar(100) | |
| contnotes | text | |
| active | tinyint(4) | |
| listprice | varchar(5) | |
| invoiceprice | varchar(5) | |
| gstreg | tinyint(4) | |
| listincgst | tinyint(4) | |
| invoiceincgst | tinyint(4) | |
| discount | float(6,4) | |
| fax | varchar(50) | |
| nocalc | int(11) | |
| invoicedisc | float(6,4) |
