-- ABS-42717 / ABS-46376

------------ PAYMENTTERMS ------------ 
COMMENT ON COLUMN PAYMENTTERMS.PAYMENTTERMTYPE
  IS '0 = Net Cash 1 = Net Payment + Days 2 = Running month + Days 3 = Net Payment + Months 4 = Running month + Months 5 = Net Payment + days +running month (end of the month after the invoice date plus x days)';

ALTER TABLE PAYMENTTERMS
  DROP CONSTRAINT PAYMENTTERMTYPE_VALID1;
  
ALTER TABLE PAYMENTTERMS
  ADD CONSTRAINT PAYMENTTERMTYPE_VALID1
  CHECK (PAYMENTTERMTYPE IN (0, 1, 2, 3, 4, 5));
  
------------ INVOICEHEADEREXTRAINFO ------------ 
COMMENT ON COLUMN INVOICEHEADEREXTRAINFO.PAYMENTTYPE
  IS '1=Check
2=Credit Card
3=EFT
4=EDI
5=Accept Giro
6=Automatic Collection
10 = Approval for payment (Billet a ordre)
11 = Letter of intent to pay (L.C.R. Lettre de Change Relevé)';
