CREATE TABLE TAXAADMPARCFIL (	
 CDFILIAL 		VARCHAR2(4),
 CDTIPORECE      	VARCHAR2(4),
 VRPERCENTAXA 	FLOAT,
 NUMPARCTAXA      	NUMBER,
 NRORG 	       		NUMBER 		DEFAULT  SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
 IDATIVO		VARCHAR2(1)	DEFAULT 'S' 	NOT NULL
    CONSTRAINT CKC_IDATIVO_TAXAADMPARCFIL CHECK (IDATIVO IN ('S', 'N')),          
 DTINCLUSAO     	DATE           	NULL,
 NRORGINCLUSAO   	NUMBER        	DEFAULT 1	NULL,
 CDOPERINCLUSAO  	VARCHAR2(12)   	DEFAULT '1'	NULL,
 NRORGULTATU     	NUMBER         	DEFAULT 1	NULL,
 CDOPERULTATU    	VARCHAR2(12)   	DEFAULT '1'	NULL,    
	CONSTRAINT PK_TAXAADMPARCFIL PRIMARY KEY (CDFILIAL, CDTIPORECE, VRPERCENTAXA, NUMPARCTAXA)
)
/
CREATE TABLE TAXAADMPARC (	
 CDTIPORECE      	VARCHAR2(4),
 VRPERCENTAXA 	FLOAT,
 NUMPARCTAXA      	NUMBER,
 NRORG 	       	NUMBER 		DEFAULT  SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
 IDATIVO		VARCHAR2(1)	DEFAULT 'S' 	NOT NULL
    CONSTRAINT CKC_IDATIVO_TAXAADMPARC CHECK (IDATIVO IN ('S', 'N')),          
 DTINCLUSAO     	DATE           	NULL,
 NRORGINCLUSAO   	NUMBER        	DEFAULT 1	NULL,
 CDOPERINCLUSAO  	VARCHAR2(12)   	DEFAULT '1'	NULL,
 NRORGULTATU     	NUMBER         	DEFAULT 1	NULL,
 CDOPERULTATU    	VARCHAR2(12)   	DEFAULT '1'	NULL,    
	CONSTRAINT PK_TAXAADMPARC PRIMARY KEY ( CDTIPORECE, VRPERCENTAXA, NUMPARCTAXA)
)
/
ALTER TABLE CONTARECEBER ADD IDPARCAUTOFOS VARCHAR2(01) NULL
	 CONSTRAINT CKC_IDPARCAUTOFOS_CONTAREC  CHECK (IDPARCAUTOFOS  IS NULL OR (IDPARCAUTOFOS  IN ('S','N')))