-- ABS-77502/ ABS-78087
-- PACKINGNOTELINE TABLE --
ALTER TABLE PACKINGNOTELINE ADD (EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
                                          CONSTRAINT YNX_VALIDATION_PNL_EXPORTED CHECK (EXPORTED IN ('N','Y','X')));

COMMENT ON COLUMN PACKINGNOTELINE.EXPORTED IS 
'Extra attribute that can be used to indicate if this packingnoteline is exported Y(es) or N(o) or (X) special situation, so possible values ''N'', ''Y'', ''X'' ';

-- REPAIRHISTORY TABLE --
ALTER TABLE REPAIRHISTORY ADD (EXPORTED VARCHAR2(1) DEFAULT 'N' NOT NULL
                                        CONSTRAINT YNX_VALIDATION_REPAIRHIST_EXP CHECK (EXPORTED IN ('N','Y','X')));
 
COMMENT ON COLUMN REPAIRHISTORY.EXPORTED IS 
'Extra attribute that can be used to indicate if this repair is exported Y(es) or N(o) or (X) special situation, so possible values ''N'', ''Y'', ''X'' ';