--allowing/adding payment type option/number 7 for i_customer is added

-- Add comments to the columns 
comment on column I_CUSTOMER.PAYMENTTYPE
  is '1=Check
2=Credit Card
3=EFT
4=EDI
5=Accept Giro
6=Automatic Collection
7=Via Pay by Customer';
-- Create/Recreate check constraints 
alter table I_CUSTOMER
  drop constraint PAYMENTTYPE_VALIDATION;
alter table I_CUSTOMER
  add constraint PAYMENTTYPE_VALIDATION
  check (paymenttype IN (0,1,2,3,4,5,6,7));
