-- ABS-115447
COMMENT ON COLUMN SUPPLIEREDISETTINGS.POEXPORTFILEFORMAT
IS 'Indicates if purchase order will be exported to supplier via EDI and which file format is used. Possible values:
0 = Not applicable
1 = ABS standard PO export
2 = Mulliez PO export
3 = Alsico PO Export
';

COMMENT ON COLUMN SUPPLIEREDISETTINGS.POCONFIRMFILEFORMAT
IS 'Indicates if purchase order confirmations will be imported from supplier via EDI and which file format is used. Possible values:
0 = Not applicable
1 = ABS standard PO confirmation
2 = Mulliez PO confirmation
3 = Alsico PO confirmation
';

ALTER TABLE SUPPLIEREDISETTINGS DROP CONSTRAINT POEXPORTFILEFORMAT_VALID1;

ALTER TABLE SUPPLIEREDISETTINGS ADD CONSTRAINT CHK_SUPPEDISETT_POEXPFILE CHECK (POEXPORTFILEFORMAT IN (0, 1, 2, 3));

ALTER TABLE SUPPLIEREDISETTINGS DROP CONSTRAINT POCONFIRMFILEFORMAT_VALID1;

ALTER TABLE SUPPLIEREDISETTINGS ADD CONSTRAINT CHK_SUPPEDISETT_POCONFFILE CHECK (POCONFIRMFILEFORMAT IN (0, 1, 2, 3));
