-- ABS-130156 When using an undeliverable stop reason code for no restoring putups - ABS-140953

COMMENT ON COLUMN PACKINGNOTE.INVOICESTATUS is '0 = Completely not invoiced
1 = Partially invoiced
2 = Completely invoiced
3 = Cancelled (used when invoices are cancelled for an undeliverable stop and packing notes are not restored)';

ALTER TABLE PACKINGNOTE ADD CONSTRAINT CHK_PACKINGNOTE_INVOICESTATUS CHECK (INVOICESTATUS IN (0,1,2,3));
                
