--ABS-149313
ALTER TABLE ERP_I_CONTRACT MODIFY (OWNER_STREET VARCHAR2(40), ADDRESS_STREET VARCHAR2(40), ADDRESS_STREET2 VARCHAR2(40));
ALTER TABLE ERP_I_CONTRACT ADD (OWNER_STREET2 VARCHAR2(40) NULL, OWNER_STREET3 VARCHAR2(40) NULL, ADDRESS_STREET3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_COSTCENTER MODIFY (INVOICEADDRESS VARCHAR2(40), INVOICEADDRESS2 VARCHAR2(40));
ALTER TABLE ERP_I_COSTCENTER ADD (INVOICEADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_CUSTOMER MODIFY 
(MAILADDRESS VARCHAR2(40), MAILADDRESS2 VARCHAR2(40), 
 VISITADDRESS VARCHAR2(40), VISITADDRESS2 VARCHAR2(40),
 INVOICEADDRESS VARCHAR2(40), INVOICEADDRESS2 VARCHAR2(40),
 COVERPAGE_ADDRESS VARCHAR2(40), COVERPAGE_ADDRESS2 VARCHAR2(40));
ALTER TABLE ERP_I_CUSTOMER ADD (MAILADDRESS3 VARCHAR2(40) NULL, VISITADDRESS3 VARCHAR2(40) NULL, INVOICEADDRESS3 VARCHAR2(40) NULL, COVERPAGE_ADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_DELIVERYPOINT MODIFY (ADDRESS VARCHAR2(40), ADDRESS2 VARCHAR2(40));
ALTER TABLE ERP_I_DELIVERYPOINT ADD (ADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_INVOICEHEADER MODIFY (STREET VARCHAR2(40), STREET2 VARCHAR2(40));
ALTER TABLE ERP_I_INVOICEHEADER ADD (STREET3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_SUPPLIER MODIFY (STREET VARCHAR2(40), STREET2 VARCHAR2(40));
ALTER TABLE ERP_I_SUPPLIER ADD (STREET3 VARCHAR2(40) NULL);

ALTER TABLE ERP_I_INFOUSA MODIFY (STREET VARCHAR2(40));

ALTER TABLE ERP_O_CUSTOMER MODIFY 
(MAILADDRESS VARCHAR2(40), MAILADDRESS2 VARCHAR2(40), 
 VISITADDRESS VARCHAR2(40), VISITADDRESS2 VARCHAR2(40),
 INVOICEADDRESS VARCHAR2(40), INVOICEADDRESS2 VARCHAR2(40),
 COVERPAGE_ADDRESS VARCHAR2(40), COVERPAGE_ADDRESS2 VARCHAR2(40));
ALTER TABLE ERP_O_CUSTOMER ADD (MAILADDRESS3 VARCHAR2(40) NULL, VISITADDRESS3 VARCHAR2(40) NULL, INVOICEADDRESS3 VARCHAR2(40) NULL, COVERPAGE_ADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_O_INVOICEHEADER MODIFY (STREET VARCHAR2(40), STREET2 VARCHAR2(40), DELTOSTREET VARCHAR2(40), DELTOSTREET2 VARCHAR2(40));
ALTER TABLE ERP_O_INVOICEHEADER ADD (STREET3 VARCHAR2(40) NULL, DELTOSTREET3 VARCHAR2(40) NULL);

ALTER TABLE ERP_O_ROUTECONTROL MODIFY (ADDRESS VARCHAR2(40));
ALTER TABLE ERP_O_ROUTECONTROL ADD (ADDRESS2 VARCHAR2(40) NULL, ADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_O_SPM_CUST_SALESCOMISION MODIFY (DELTO_ADDRESS1 VARCHAR2(40),DELTO_ADDRESS2 VARCHAR2(40));
ALTER TABLE ERP_O_SPM_CUST_SALESCOMISION ADD (DELTO_ADDRESS3 VARCHAR2(40) NULL);

ALTER TABLE ERP_O_SPM_SALESCOMMISSION MODIFY (DELTO_STREET VARCHAR2(40),DELTO_STREET2 VARCHAR2(40),BILLTO_STREET VARCHAR2(40),BILLTO_STREET2 VARCHAR2(40));
ALTER TABLE ERP_O_SPM_SALESCOMMISSION ADD (DELTO_STREET3 VARCHAR2(40) NULL, BILLTO_STREET3 VARCHAR2(40) NULL);

ALTER TABLE ERP_O_INFOUSA MODIFY (STREET VARCHAR2(40));
