-- ABS-28871
ALTER TABLE ERP_I_SUPPLIERMODEL ADD (STOCKROOM_DEFAULTSUPPLIER VARCHAR2(12),
				     FIXEDEXTERNAL_DEFAULTSUPPLIER NUMBER DEFAULT 0 CONSTRAINT FIXEDEXTERNAL_VALID1_1 CHECK (FIXEDEXTERNAL_DEFAULTSUPPLIER IN (0,1)));

COMMENT ON COLUMN ERP_I_SUPPLIERMODEL.STOCKROOM_DEFAULTSUPPLIER IS 'When this is filled it means that this stockroom will have the SUPPLIERNUMBER as default supplier for this product size';

COMMENT ON COLUMN ERP_I_SUPPLIERMODEL.FIXEDEXTERNAL_DEFAULTSUPPLIER IS 'The attribute indicates whether the defined external supplier is fixed or not (e.g. in case a chain is defined, the chain is ignored when the supplier is defined as fixed) Possible values: 0 = Defined external supplier is not fixed 1 = Defined external supplier is fixed';
