CREATE TABLE CONF_AJUSTE_ST_RS 
( 
NRSEQUENCIAL    VARCHAR2(20) 	NOT NULL,
NRSEQUMAPAPU   VARCHAR2(20) 	NOT NULL,
CDFILIALSAID   VARCHAR2(04) 	NULL,
CDMODELOSAID   VARCHAR2(04) 	NULL,
CDSERIESAID    VARCHAR2(10) 	NULL,   
NRCUPOM        VARCHAR2(20) 	NULL,
DTVENDA        DATE 			NULL,
CDARVPRODSAID  VARCHAR2(20) 	NULL,
NMPRODUTOSAID  VARCHAR2(50) 	NULL, 
CDPRODUTOSAID  VARCHAR2(10) 	NULL,
VRSAIDA        FLOAT 			NULL,
NRACESSOSAID   VARCHAR2(50) 	NULL,
CDTIPOSAID     VARCHAR2(04) 	NULL,
NRQTDESAID     FLOAT 			NULL,
CDFILIALENTR   VARCHAR2(04) 	NULL,
CDMODELOENTR   VARCHAR2(04) 	NULL,
CDSERIEENTR    VARCHAR2(10) 	NULL,
NRNOTAFISC     VARCHAR2(20) 	NULL,
DTENTRSAID     DATE 			NULL,
CDARVPRODENTR  VARCHAR2(20) 	NULL,
VRSTNFENTR     FLOAT 			NULL,
NRACESSOENTR   VARCHAR2(50) 	NULL,
VRSTENTR       FLOAT 			NULL, 
QTITEMPRODENTR FLOAT 			NULL,
NRORG          NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
IDATIVO                    		VARCHAR2(1)     DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDATIVO_CONFAJUSTESTRS CHECK (IDATIVO IN ('S','N')),
DTINCLUSAO     DATE             NULL,
DTULTATU       DATE             NULL,
NRORGINCLUSAO  NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')  NULL,
CDOPERINCLUSAO VARCHAR2(12)  	DEFAULT '1' NULL,
NRORGULTATU    NUMBER 			DEFAULT  SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
CDOPERULTATU   VARCHAR2(12)  	DEFAULT '1',
	CONSTRAINT PK_CONF_AJUSTE_ST_RS PRIMARY KEY (NRSEQUENCIAL, NRSEQUMAPAPU)
)