--- ABS-122437 / ABS-123739

----- CONTRACTCOMPONENTPAYMENT -------------

ALTER TABLE CONTRACTCOMPONENTPAYMENT DROP CONSTRAINT CHK_CONTRCOMPPAYM_PAYMENTTYPE;
ALTER TABLE CONTRACTCOMPONENTPAYMENT ADD CONSTRAINT CHK_CONTRCOMPPAYM_PAYMENTTYPE CHECK (PAYMENTTYPE BETWEEN 1 AND 13);
  
COMMENT ON COLUMN CONTRACTCOMPONENTPAYMENT.PAYMENTTYPE
  IS '1 = Check 
      2 = Credit Card 
      3 = EFT (Electronic File Transfer) 
      4 = EDI (Electronic Data Interchange) 
      5 = Accept Giro 
      6 = Automatic Collection 
      7 = Via Pay by Customer 
      8 = (Post) Bank 
      9 = Bacs 
      10 = Approval for payment (Billet a ordre) - France only. No functionality, just for redisplay 
      11 = Letter of intent to pay (L.C.R. Lettre de Change Releve) - France only. No functionality, Just for redisplay 
      12 = ACH (Automated Clearing House) - US Only 
      13 = Direct Treaty (Traité directe)';
   
     
----- CUSTOMER ----------------------------

ALTER TABLE CUSTOMER DROP CONSTRAINT CHK_CUSTOMER_PAYMENTTYPEGENERAL;
ALTER TABLE CUSTOMER ADD CONSTRAINT CHK_CUSTOMER_PAYMENTTYPEGENERAL CHECK (PAYMENTTYPE BETWEEN 0 AND 13);
COMMENT ON COLUMN CUSTOMER.PAYMENTTYPE
  IS '0 = Cash 
      1 = Check 
      2 = Credit Card 
      3 = EFT 
      4 = EDI 
      5 = Accept Giro 
      6 = Automatic Collection 
      7 = Via Pay by Customer 
      8 = (Post) Bank 9 = Bacs 10 = Approval for payment (Billet a ordre) 
      11 = Letter of intent to pay (L.C.R. Lettre de Change Relevé) 
      12 = ACH (Automated Clearing House) - US Only 
      13 = Direct Treaty (Traité directe)';
