CREATE TABLE CARGOVENDAS
(
    CDCARGO        	VARCHAR2(3) 	NOT NULL,
    NMCARGO        	VARCHAR2(255) 	NOT NULL,
    NRORG 	   	NUMBER 		DEFAULT 	SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO	   	VARCHAR2(1)	DEFAULT 'S' 	NOT NULL,
	CONSTRAINT CKC_IDATIVO_CARGOVENDAS CHECK (IDATIVO IN ('S', 'N')),          
    DTINCLUSAO      	DATE           	NULL,
    DTULTATU        	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_CARGOVENDAS PRIMARY KEY (CDCARGO)
)