CREATE TYPE QUERY_ITEM_CMP99000_TYPE AS
OBJECT(ID                VARCHAR2(100),
       IDCHECK           VARCHAR2(1),
       NRAPURPREC        VARCHAR2(10),
       CDFORNECED        VARCHAR2(21),
       CDFILSOLI         VARCHAR2(4),
       NMFILIAL          VARCHAR2(100),
       DSFILIALC         VARCHAR2(150),
       DSFILIAL          VARCHAR2(110),
       CDFILLAN          VARCHAR2(4),
       NRSOLICMP         VARCHAR2(10),
       CDPRODUTO         VARCHAR2(10),
       NMPRODUTO         VARCHAR2(50),
       CDARVPROD         VARCHAR2(20),
       SGUNIDADE         VARCHAR2(10),
       DSPRODUTO         VARCHAR2(80),
       CDMARCA           VARCHAR2(5),
       NMMARCA           VARCHAR2(20),
       DSMARCA           VARCHAR2(30),
       NRINSJURFORN      VARCHAR2(100),
       NMFANTFORN        VARCHAR2(50),
       CDEXPRODFORN      VARCHAR2(50),
       DSTIPO            VARCHAR2(15),
       NMPRODUTOOL       VARCHAR2(50),
       CDARVPRODOL       VARCHAR2(20),
       CDFILCENTCMP      VARCHAR2(10),
       SGESTADO          VARCHAR2(2),
       NMMUNICIPIO       VARCHAR2(30),
       DTPROGENTR        DATE,
       NRORG             NUMERIC,
       QTSOLIPROD        FLOAT,
       VRCUSTO           FLOAT,
       VRPRECUNIAP       FLOAT,
       QTDIAESTOQUE      FLOAT,
       QTCONSUMODIA      FLOAT,
       QTESTOQUE         FLOAT,
       QTDURACAEST       FLOAT,
       QTCONSUMODIASEST  FLOAT,
       QTITEMPED         FLOAT,
       QTPROGENTAF       FLOAT,
       QTENTRADAS        FLOAT,
       QTSAIDAS          FLOAT,
       VRCUSTOTOTAL      FLOAT,
       QTTOTAL           FLOAT);
/