--Order 20011833.90 - External invoice printing

-----------------------------------------INVOICEHEADER TABLE----------------------------------

ALTER TABLE INVOICEHEADER
	ADD (EXTERNALPRINTRUN NUMBER  DEFAULT 0 NOT NULL);

CREATE  INDEX XIE27INVOICEHEADER ON INVOICEHEADER
(EXTERNALPRINTRUN   ASC);



-----------------------------------------BUSINESSUNIT TABLE----------------------------------
ALTER TABLE BUSINESSUNIT
	ADD (EXTINVOICESNUMBERPREFIX VARCHAR2(6) NULL,
	     EXTINVOICESNUMBERLENGTH NUMBER NULL);



-----------------------------------------PROCESS TABLE----------------------------------

INSERT INTO  PROCESS 
      (PROCESS_ID,
       DESCRIPTION,
       ACTIVE)
    VALUES
      (113,
       'Export Invoices for External Printing',
       'Y');
