--ABS-69071 / ABS-79203

-------- CUSTOMER --------

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

ALTER TABLE CUSTOMER
DROP CONSTRAINT SPLIINVOICES_VALID1_1;

ALTER TABLE CUSTOMER
ADD CONSTRAINT SPLITINVOICES_VALID1
CHECK (SPLITINVOICES BETWEEN 0 AND 5);


-------- INVOICEHEADER --------

ALTER TABLE INVOICEHEADER MODIFY SPLITUPCODE VARCHAR2(15);

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
5=Per customer reference';

ALTER TABLE INVOICEHEADER 
DROP CONSTRAINT SPLITLEVEL_VALID1_1;

ALTER TABLE INVOICEHEADER
ADD CONSTRAINT SPLITLEVEL_VALID1
CHECK (SPLITLEVEL BETWEEN 0 AND 5);