ALTER TABLE PARAMPEDIDO ADD IDGERCONTPREV VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_PARAMPEDIDO_IDGERCONTPREV CHECK ((IDGERCONTPREV IN ('S', 'N')))
/

ALTER TABLE TIPORECEFILIAL ADD IDGERAFINCLI VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_TIPORECEFIL_IDGERAFINCLI CHECK ((IDGERAFINCLI IN ('S', 'N')))
/
  
ALTER TABLE TIPORECE ADD IDGERAFINCLI VARCHAR2(01) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_TIPORECE_IDGERAFINCLI CHECK ((IDGERAFINCLI IN ('S', 'N')))
/ 