--ABS-80769
ALTER TABLE ERP_I_CUSTOMER ADD 
 (SENDSTATEMENT NUMBER NULL
    CONSTRAINT CHK_ERP_I_CUST_SENDSTATEMENT CHECK (SENDSTATEMENT IN (1,2,3)),
  STATEMENTFREQUENCY NUMBER NULL);
  
COMMENT ON COLUMN ERP_I_CUSTOMER.SENDSTATEMENT
  IS '1=Always
2=Only if pass due
3=Never';

ALTER TABLE ERP_I_CUSTOMER
  ADD CONSTRAINT FK_ERP_I_CUSTOMER_STATFREQ FOREIGN KEY (STATEMENTFREQUENCY)
  REFERENCES INVOICEFREQUENCY (INVOICEFREQUENCY_ID) ON DELETE CASCADE;