-- ABS-98325 / ABS-98976

---------- EDI_O_ADVSHIPNOTICELINE --------

ALTER TABLE EDI_O_ADVSHIPNOTICELINE DROP CONSTRAINT EDI_O_ADVSHIPNLINE_VALID2;
ALTER TABLE EDI_O_ADVSHIPNOTICELINE ADD CONSTRAINT EDI_O_ADVSHIPNLINE_VALID2 CHECK (SN103 IN ('EA','CA','PC'));

ALTER TABLE EDI_O_ADVSHIPNOTICELINE DROP CONSTRAINT EDI_O_ADVSHIPNLINE_VALID3;
ALTER TABLE EDI_O_ADVSHIPNOTICELINE ADD CONSTRAINT EDI_O_ADVSHIPNLINE_VALID3 CHECK (SN106 IN ('EA','CA','PC'));

COMMENT ON COLUMN EDI_O_ADVSHIPNOTICELINE.SN103
IS 'SN103 - Unit or basis for measurement code: code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
Possible values when filled:
"EA"= Each
"CA"= Case
"PC"= Piece';

COMMENT ON COLUMN EDI_O_ADVSHIPNOTICELINE.SN106
IS 'SN103 - Unit or basis for measurement code: code specifying the units in which a value is being expressed, or manner in
which a measurement has been taken
Possible values when filled:
"EA"= Each
"CA"= Case
"PC"= Piece';