|
Lines 3145-3151
CREATE TABLE aqinvoices (
Link Here
|
| 3145 |
-- |
3145 |
-- |
| 3146 |
|
3146 |
|
| 3147 |
DROP TABLE IF EXISTS aqinvoice_adjustments; |
3147 |
DROP TABLE IF EXISTS aqinvoice_adjustments; |
| 3148 |
CREATE TABLE IF NOT EXISTS aqinvoice_adjustments ( |
3148 |
CREATE TABLE aqinvoice_adjustments ( |
| 3149 |
adjustment_id int(11) NOT NULL AUTO_INCREMENT, -- primary key for adjustments |
3149 |
adjustment_id int(11) NOT NULL AUTO_INCREMENT, -- primary key for adjustments |
| 3150 |
invoiceid int(11) NOT NULL, -- foreign key to link an adjustment to an invoice |
3150 |
invoiceid int(11) NOT NULL, -- foreign key to link an adjustment to an invoice |
| 3151 |
adjustment decimal(28,6), -- amount of adjustment |
3151 |
adjustment decimal(28,6), -- amount of adjustment |
| 3152 |
- |
|
|