ALTER TABLE SERVICOCIAFILI ADD IDFATVENDADEVOL VARCHAR(30) DEFAULT 'NFVENDA' NOT NULL
        CONSTRAINT CKC_IDFATVENDADEVOL_SERVICOCIA CHECK (IDFATVENDADEVOL IN ('NFVENDA','NFDEVOLUCAO'))
/

ALTER TABLE SERVICOCIAFILI ADD IDTIPOSERVICO VARCHAR(30) DEFAULT 'AMBOS' NOT NULL
        CONSTRAINT CKC_IDTIPOSERVICO_SERVICOCIA CHECK (IDTIPOSERVICO IN ('AMBOS','ITEMFATURAMENTO','ITEMMENUGRID'))
/

ALTER TABLE SERVICOCIAFILI ADD NRPADSERVICOM NUMBER
/