CREATE TYPE QUERY_ITEM_DFS48000_TYPE AS
OBJECT(IDCHECKPRAF       VARCHAR2(1),
       CDFILIAL          VARCHAR2(4),
       CDARVPROD         VARCHAR2(20),
       NMPRODUTO         VARCHAR2(50),
       CDPRODUTO         VARCHAR2(10),
       SGUNIDADE         VARCHAR2(10),
       CDMARCA           VARCHAR2(5),
       CDMARCAOL         VARCHAR2(5),
       CDMARCAAF         VARCHAR2(5),
       NMMARCA           VARCHAR2(20),
       NRAUTOFORN        VARCHAR2(10),
       CDFILLANC         VARCHAR2(4),
       NRLANCTONF        VARCHAR2(10),
       IDBAIXITAFS       VARCHAR2(1),
       CDFILDEST         VARCHAR2(4),
       IDUTILITEM        VARCHAR2(1),
       CDALMOXARIFE      VARCHAR2(6),
       CDLOCALESTOQ      VARCHAR2(6),
       NRLOTEESTQ        VARCHAR2(20),
       NRSUBLOTE         VARCHAR2(4),
       IDUTQTESTRANG     VARCHAR2(1),
       CDCLIENTEEXT      VARCHAR2(21),
       CDARVPRODOL       VARCHAR2(20),
       NMPRODUTOOL       VARCHAR2(50),
       CDARVPRODEST      VARCHAR2(20),
       NMPRODUTOEST      VARCHAR2(50),
       CDPRODUTOEST      VARCHAR2(10),
       CDFILIOPELOG      VARCHAR2(4),
       NMFILIOPELOG      VARCHAR2(100),
       NMFILIAL          VARCHAR2(100),
       LISTAERRO         VARCHAR2(2000),
       DTPROGEMBARQ      DATE,
       DTPROGENTAF       DATE,
       DTPROGENPEOL      DATE,
       QTPROGENTAF       FLOAT,
       QTSAIDOPLOG       FLOAT,
       VRPREUNIAF        FLOAT,
       QTNFRELAFSAI      FLOAT,
       QTATENDPEDOL      FLOAT,
       VRPBRUTOPEDOL     FLOAT,
       VRPLIQUIPEDOL     FLOAT,
       QTATENDESTRANG    FLOAT,
       QTESTOQDIA        FLOAT,
       QTRESERVESTOL     FLOAT,
       ESTOQ_DISPO       FLOAT,
       RESERVA_ITEM      FLOAT,
       QTESTOQDIAEST     FLOAT,
       VRFATOCONVOL      FLOAT,
       VRFATOCONV        FLOAT,
       VRTOTAL           FLOAT);
/