--ABS-84931
ALTER TABLE SQ_WEEKLY_REVENUE ADD FINISHINGMETHODCODE VARCHAR2(6) NULL;
ALTER TABLE SQ_WEEKLY_REVENUE ADD SQ_WEEKCYCLES NUMBER NULL;
CREATE INDEX INDX_SQ_WEEKLY_REVENUE_CYCLES ON SQ_WEEKLY_REVENUE (SQ_WEEKCYCLES);
ALTER TABLE SQ_WEEKLY_REVENUE
  DROP CONSTRAINT UK2_WEEKLY_REVENUE;
ALTER TABLE SQ_WEEKLY_REVENUE
  ADD CONSTRAINT UK2_WEEKLY_REVENUE UNIQUE (INVOICEBUSINESSUNIT_ID, SQ_DATE, DELTOCUSTOMER_LINK_ID, TURNOVERGROUP_ID, INVOICELINE_CODE, INVOICELINE_DESC, SIZECODE, FINISHINGMETHODCODE);
ALTER TABLE SQ_WEEKLY_REVENUE
  DROP CONSTRAINT UK1_WEEKLY_REVENUE;
ALTER TABLE SQ_WEEKLY_REVENUE
  ADD CONSTRAINT UK1_WEEKLY_REVENUE UNIQUE (INVOICEBUSINESSUNIT_ID, INVOICEYEAR, INVOICEWEEK, DELTOCUSTOMER_LINK_ID, TURNOVERGROUP_ID, INVOICELINE_CODE, INVOICELINE_DESC, SIZECODE, FINISHINGMETHODCODE);