ALTER TABLE SETORFILIAL ADD IDHABCANCDLV VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCDLV CHECK (IDHABCANCDLV IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABCANCBAL VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCBAL CHECK (IDHABCANCBAL IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABCANCMES VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCMES CHECK (IDHABCANCMES IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABCANCCMD VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCCMD CHECK (IDHABCANCCMD IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABCANCTHR VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCTHR CHECK (IDHABCANCTHR IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABCANCTGO VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDHABCANCTGO CHECK (IDHABCANCTGO IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDHABSCANCODE VARCHAR2(1) DEFAULT 'N' NOT NULL
CONSTRAINT CKC_IDHABSCANCODE CHECK (IDHABSCANCODE IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDAUMENTARESUMO VARCHAR2(1) DEFAULT 'N' NOT NULL
CONSTRAINT CKC_IDAUMENTARESUMO CHECK (IDAUMENTARESUMO IN('S','N'))
/

ALTER TABLE SETORFILIAL ADD IDIMPRPICKLIST VARCHAR2(1) DEFAULT 'N' NOT NULL
CONSTRAINT CKC_IDIMPRPICKLIST CHECK (IDIMPRPICKLIST IN('S','N'))
/