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