--Order 20012349.80

----CUSTOMER TABLE----



ALTER TABLE CUSTOMER
	ADD (TAXEXEMPTCERTIFICATEDOCUMENT VARCHAR2(1000));

ALTER TABLE CUSTOMER
	ADD (TAXEXEMPTCERTIFICATERECEIVED DATE);

COMMENT ON COLUMN CUSTOMER.TAXEXEMPTCERTIFICATEDOCUMENT IS 'Tax Exempt Certificate (Document) name including full path.
In fact only relevant when Taxable = ‘N’
';

COMMENT ON COLUMN CUSTOMER.TAXEXEMPTCERTIFICATERECEIVED IS 'Date the tax exempt certificate that is attached to this customer was received. 
In fact only relevant when Taxable = ‘N’
';
