-- ABS-95120 / ABS-97985
--- ROUTECONTROLEXTRAINFO ---
ALTER TABLE ROUTECONTROLEXTRAINFO ADD (VERTEXQUOTEBATCHID NUMBER NULL);

COMMENT ON COLUMN ROUTECONTROLEXTRAINFO.VERTEXQUOTEBATCHID IS 'Used for module VERTEXTAX and contains the batch ID used in the VertexTransactionLog table';

--- VERTEXTRANSACTIONLOG ---
ALTER TABLE VERTEXTRANSACTIONLOG ADD (TRANSACTIONTYPE VARCHAR2(15) DEFAULT 'SALE' NOT NULL
					CONSTRAINT CHK_VERTEXLOG_TRANSTYPE CHECK (TRANSACTIONTYPE IN ('RENT','SALE','MISCELLANEOUS','NOT APPLICABLE')));

COMMENT ON COLUMN VERTEXTRANSACTIONLOG.TRANSACTIONTYPE IS 'Tax type of the invoice line (RENT, SALE, MISCELLANEOUS, NOT APPLICABLE)';

