Lines 3156-3162
CREATE TABLE aqinvoice_adjustments (
Link Here
|
3156 |
reason varchar(80) default NULL, -- reason for adjustment defined by authorised values in ADJ_REASON category |
3156 |
reason varchar(80) default NULL, -- reason for adjustment defined by authorised values in ADJ_REASON category |
3157 |
note mediumtext default NULL, -- text to explain adjustment |
3157 |
note mediumtext default NULL, -- text to explain adjustment |
3158 |
budget_id int(11) default NULL, -- optional link to budget to apply adjustment to |
3158 |
budget_id int(11) default NULL, -- optional link to budget to apply adjustment to |
3159 |
encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the finds when invoice is still open, 1 = yes, 0 = no |
3159 |
encumber_open smallint(1) NOT NULL default 1, -- whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no |
3160 |
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp of last adjustment to adjustment |
3160 |
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- timestamp of last adjustment to adjustment |
3161 |
PRIMARY KEY (adjustment_id), |
3161 |
PRIMARY KEY (adjustment_id), |
3162 |
CONSTRAINT aqinvoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE, |
3162 |
CONSTRAINT aqinvoice_adjustments_fk_invoiceid FOREIGN KEY (invoiceid) REFERENCES aqinvoices (invoiceid) ON DELETE CASCADE ON UPDATE CASCADE, |
3163 |
- |
|
|