--- ABS-19965
-------------------------------   INVOICEHEADER   ------------------------------------------
ALTER TABLE INVOICEHEADER ADD (SPLITLEVEL NUMBER DEFAULT 0 NOT NULL
				CONSTRAINT SPLITLEVEL_VALID1_1 CHECK (SPLITLEVEL BETWEEN 0 AND 4));

COMMENT ON COLUMN INVOICEHEADER.SPLITLEVEL IS '0=No Split up
1=Per product grouping code
2=Per cost center
3=Rent / other services
4=Per Cost Center Group';

update invoiceheader ih
set ih.splitlevel = 2
where ih.splitupcode is not null;
commit;
