--Order 20013457.50

---REASONCODE---
ALTER TABLE REASONCODE
	ADD (ADJUSTCIRCFROMFIXEDDELIVERY VARCHAR2(1)  DEFAULT 'N' NOT NULL CONSTRAINT YN_ValidationField85 CHECK (ADJUSTCIRCFROMFIXEDDELIVERY IN ('Y', 'N')));

COMMENT ON COLUMN REASONCODE.ADJUSTCIRCFROMFIXEDDELIVERY IS 'The reason code marked with Yes is used as a reason code for the circulating inventory adjustment. Only 1 reason code can be marked as Yes.';


---PRODUCTLISTPERDISTRIBPOINT
ALTER TABLE PRODUCTLISTPERDISTRIBPOINT
	ADD (ADJUSTCIRCINVENTORY NUMBER  DEFAULT 0 NOT NULL CONSTRAINT AdjustCircInventory_valid1_1 CHECK (ADJUSTCIRCINVENTORY IN (0, 1)));

COMMENT ON COLUMN PRODUCTLISTPERDISTRIBPOINT.ADJUSTCIRCINVENTORY IS '0 = not applicable / do not update circulating inventory
1 = the fixed delivery is delivered to the customer, the difference between fixed and variation amount (soil count) is adjusted on the circulating inventory.
';
