|
Lines 2786-2792
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
| 2786 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
2786 |
`gstreg` tinyint(4) default NULL, -- is your library charged tax (1 for yes, 0 for no) |
| 2787 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
2787 |
`listincgst` tinyint(4) default NULL, -- is tax included in list prices (1 for yes, 0 for no) |
| 2788 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
2788 |
`invoiceincgst` tinyint(4) default NULL, -- is tax included in invoice prices (1 for yes, 0 for no) |
| 2789 |
`gstrate` decimal(6,4) default NULL, -- the tax rate the library is charged |
2789 |
`tax_rate` decimal(6,4) default NULL, -- the tax rate the library is charged |
| 2790 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
2790 |
`discount` float(6,4) default NULL, -- discount offered on all items ordered from this vendor |
| 2791 |
`fax` varchar(50) default NULL, -- vendor fax number |
2791 |
`fax` varchar(50) default NULL, -- vendor fax number |
| 2792 |
deliverytime int(11) default NULL, -- vendor delivery time |
2792 |
deliverytime int(11) default NULL, -- vendor delivery time |
| 2793 |
- |
|
|