-- ABS-67076 / ABS-83213

---------------------- STOCKTRANSACTION --------------------

ALTER TABLE STOCKTRANSACTION DROP CONSTRAINT DOCUMENTTYPE_VALID;
ALTER TABLE STOCKTRANSACTION ADD CONSTRAINT CHK_STOCKTRANSACTION_DOCTYPE CHECK (DOCUMENTTYPE BETWEEN 0 AND 13);

COMMENT ON COLUMN STOCKTRANSACTION.DOCUMENTTYPE IS '0 = Stocktransaction
1 = Internal Purchase Order
2 = External Purchase Order
3 = Work Order
4 = Pick List (Internal movements)
5 = Truck Load List
6 = Sales Note
7 = Credit Note
8 = Stock Delivery (Internal PO)
9 = Stock Delivery (Direct)
10 = Mounting Order
11 = Dismounting Order
12 = Delivery Note
13 = Bull Packing Assistant';