Column Type Size Nulls Auto Default Children Parents Comments
adjustment_id INT 10 null

primary key for adjustments

invoiceid INT 10 null
aqinvoices.invoiceid aqinvoice_adjustments_fk_invoiceid C

foreign key to link an adjustment to an invoice

adjustment DECIMAL 28,6 null

amount of adjustment

reason VARCHAR 80 null

reason for adjustment defined by authorised values in ADJ_REASON category

note MEDIUMTEXT 16777215 null

text to explain adjustment

budget_id INT 10 null
aqbudgets.budget_id aqinvoice_adjustments_fk_budget_id N

optional link to budget to apply adjustment to

encumber_open SMALLINT 5 1

whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no

timestamp TIMESTAMP 19 current_timestamp()

timestamp of last adjustment to adjustment

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc adjustment_id
aqinvoice_adjustments_fk_budget_id Performance Asc budget_id
aqinvoice_adjustments_fk_invoiceid Performance Asc invoiceid