--Order 20011522

DELETE FROM CSVEXPORT;
commit;


ALTER TABLE CSVEXPORT
  DROP COLUMN SIZECODE CASCADE CONSTRAINTS;




ALTER TABLE CSVEXPORT
  DROP COLUMN FINISHINGMETHODCODE CASCADE CONSTRAINTS;



ALTER TABLE CSVEXPORT
	ADD (SIZEDESCRIPTION VARCHAR2(30) NULL);



ALTER TABLE CSVEXPORT
	ADD (FINISHINGMETHODDESCRIPTION VARCHAR2(30) NULL);



COMMENT ON COLUMN CSVEXPORT.CODE IS 'InvoiceLineCode. In case of a weighing category, a prefix ‘W’ will be added to the code.
In case of special charge, a prefix ‘T’ will be added to the code.';



COMMENT ON COLUMN CSVEXPORT.DISCOUNTPERCENTAGE IS 'Discount %, taken from PLPC. In case of special charge invoice line type line, show its percentage.';


