-- ABS-124506 Adjust "send invoice by" options / ABS-126904

ALTER TABLE CUSTOMERBILLINGINFO ADD CONSTRAINT CHK_SENDINVOICEBY CHECK (SENDINVOICEBY BETWEEN 0 AND 8);
COMMENT ON COLUMN CUSTOMERBILLINGINFO.SENDINVOICEBY IS 
'0 = Send by Mail 
2 = Send by E-mail 
3 = Send by EDI 
4 = Esker – Order Number – Mail 
5 = Esker – PDF by Email 
6 = Esker – Order Number – PDF by E-Mail 
7 = Esker - <<Chorus pro>> 
8 = Esker - Mail
Option 4 – 8 are KLHCUSTOM only. Esker is an external company for printing and distributing invoices.';

ALTER TABLE INVOICEHEADEREXTRAINFO DROP CONSTRAINT SENDINVOICEBY_VALID2_1;
ALTER TABLE INVOICEHEADEREXTRAINFO ADD CONSTRAINT SENDINVOICEBY_VALID2_1 CHECK (SENDINVOICEBY BETWEEN 0 AND 8);
COMMENT ON COLUMN INVOICEHEADEREXTRAINFO.SENDINVOICEBY IS 
'0 = Send by Mail 
1 = Send by Fax 
2 = Send by E-mail 
3 = Send by EDI 
4 = Esker – Order Number – Mail 
5 = Esker – PDF by Email 
6 = Esker – Order Number – PDF by Mail 
7 = Esker - <<Chorus pro>>  
8 = Esker - Mail
Option 4 – 8 are KLHCUSTOM only. Esker is an external company for printing and distributing invoices.';
