CREATE TABLE DM_ACOMP_ALIMENTAR_CUSTO
(
    CDANO_OPER VARCHAR2(4),
	 CDMES_OPER VARCHAR2(2),
	 CDANO_CTBL VARCHAR2(4),
	 CDMES_CTBL VARCHAR2(2),
	 CDFILIAL VARCHAR2(4),
	 CDSUPERVISOR VARCHAR2(12),
	 CDAREAGERE VARCHAR2(3),
	 CDGOPERAC VARCHAR2(12),
	 CDSEGMER VARCHAR2(5),
	 CDPLANEJADORA VARCHAR2(12),
	 DSTPCORTE VARCHAR2(100),
	 DSDTCORTE VARCHAR2(100),
	 DSDATAPROC VARCHAR2(20),
	 RECEITAORCADA FLOAT(126),
	 CUSTOALIMORCADO FLOAT(126),
	 RECEITAPREVISTA FLOAT(126),
	 CUSTOPREVISTO FLOAT(126),
	 RECEITANTERIOR FLOAT(126),
	 CUSTOALIMANTERIOR FLOAT(126),
	 VRCOMPARECEBEROL FLOAT(126),
	 VRCOMPRECEBIDASOL FLOAT(126),
	 VRMEDIACOMPRAPAP FLOAT(126),
	 NRORG NUMBER(10,0) DEFAULT 1 NOT NULL ENABLE,
	 DTINCLUSAO DATE,
	 DTULTATU DATE,
	 NRORGINCLUSAO NUMBER(10,0),
	 CDOPERINCLUSAO VARCHAR2(12),
	 NRORGULTATU NUMBER(10,0),
	 CDOPERULTATU VARCHAR2(12),
	 IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL ENABLE
)
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','5.85.XXX'); END;
/