--ABS-119668
ALTER TABLE ERP_I_CONTRACT
  DROP CONSTRAINT FK_ERP_I_CONTRACT_CURRENCY;
ALTER TABLE ERP_I_CONTRACT
  ADD CONSTRAINT FK_ERP_I_CONTRACT_CURRENCY FOREIGN KEY (CURRENCYCODE)
  REFERENCES CURRENCY (CODE);
  
ALTER TABLE ERP_I_CUSTOMER ADD (PAYMENTMETHOD NUMBER(1));
COMMENT ON COLUMN ERP_I_CUSTOMER.PAYMENTMETHOD
  IS '1=COD
2=Charge';
ALTER TABLE ERP_I_CUSTOMER
  ADD CONSTRAINT CHK_ERP_I_CUST_PAYMENTMETHOD
  CHECK (PAYMENTMETHOD IN (1,2));