ALTER TABLE INFADICPROD ADD NRREGSIFDIPOA VARCHAR2(10)
/

ALTER TABLE INFADICPROD ADD NRPALLET FLOAT
/

CREATE TABLE SERIALSSCC
(
	CDDIGEXTENSAO 		VARCHAR2(01) NOT NULL,
	CDSEQUENCIAL 		VARCHAR2(07) NOT NULL,
	CDSSCC 				VARCHAR2(18) NOT NULL,
	CDFILIAL 			VARCHAR2(04) NULL,
	NRORDPROD 			VARCHAR2(20) NULL,
	NRSUBORDPROD 		VARCHAR2(01) NULL,
	CDPRODUTO 			VARCHAR2(10) NULL,
	IDTIPOEMB 			VARCHAR2(01) NULL,
	NRPALET 			VARCHAR2(10) NULL,
	VRPESOBRUT 			FLOAT NULL,
	NRLOTEPALET 		VARCHAR2(250) 	NULL,
	CDCENTRALPALET 		VARCHAR2(03) 	NULL,
		CONSTRAINT PK_SERIALSSCC PRIMARY KEY (CDSSCC),
	NRORG             	NUMBER 	     		DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 	NOT NULL,
    IDATIVO           	VARCHAR2(1)     	DEFAULT 'S' 								NOT NULL
		CONSTRAINT CKC_IDATIVO_SERIALSSCC 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'
)
/