-- ABS-67852 / ABS-68497
--- CONTRACTCOMPONENTBILLING ---
ALTER TABLE CONTRACTCOMPONENTBILLING ADD (POREQUIRED NUMBER NULL
					CONSTRAINT POREQUIRED_VALID1_2 CHECK (POREQUIRED IN (0,1)));

COMMENT ON COLUMN CONTRACTCOMPONENTBILLING.POREQUIRED IS '0 = PO is not required
1 = PO is required';

--- CONTRACTATTRIBUTE ---
INSERT INTO CONTRACTATTRIBUTE
  (CONTRACTATTRIBUTE_ID, GROUPNUMBER, SEQUENCENUMBER, FACTORYNAME, INTERNALNAME, SYSTEMUSER_ID, TIMESTAMP, NOVALUERULE)
VALUES
  (178, 10, 32, 'PORequired', 'PORequired', GETMINSYSTEMUSER(), sysdate, 2);
COMMIT;