CREATE TYPE PRODNACOMP_TYPE AS
OBJECT (CDREGIAO             VARCHAR2(03),
        NMREGIAO             VARCHAR2(30),
        CDOPERADOR           VARCHAR2(12),
        NMOPERADOR           VARCHAR2(100),
        CDFILIAL             VARCHAR2(04),
        NMFILIAL             VARCHAR2(50),
        DTPROGENTR           DATE,
        CDPRODESTO           VARCHAR2(10),
        CDARVPROD            VARCHAR2(20),
        NMPRODUTO            VARCHAR2(50),
        QTACOMPRAR           FLOAT,
        SGUNIDADE            VARCHAR2(10),
        DATAINI              DATE,
        DATAFIN              DATE,
        IDAFINCONS           VARCHAR2(01),
        IDPARTFILI           VARCHAR2(01),
        IDQUALIFMARCA        VARCHAR2(01),
        IDPRODNCOMP          VARCHAR2(01),
        IDREFORFIL           VARCHAR2(01),
        IDQUALIFFORN         VARCHAR2(01),
        IDPRODCMPFILI        VARCHAR2(01),
        IDCOTACAO            VARCHAR2(01),
        IDREFOREG            VARCHAR2(01),
        IDQFOPRODFORN        VARCHAR2(01),
        SISTEMA              VARCHAR2(03),
        ATENDIDA             VARCHAR2(01),
        IDPRODPREF           VARCHAR2(01),
        IDSTATCOT            VARCHAR2(01),
        IDSEMQTDEDISP        VARCHAR2(01),
        IDFUNCAOFILI         VARCHAR2(01),
        IDOPERADOROL         VARCHAR2(01),
        NRCOMPRA             VARCHAR2(10),
        DSPRODPREF           VARCHAR2(65),
        DSIDCDTIPPART        VARCHAR2(100),
        DSPARTFILIMARCA      VARCHAR2(1000),
        DSPARTIFILINRINSFORN VARCHAR2(20),
        DSPARTIFILINMFORN    VARCHAR2(1000),
        DSIDFORN             VARCHAR2(01),
        LISTA_NRSOLICMP      VARCHAR2(2000),
        IDRELACPRODOL        VARCHAR2(01),
        IDACORDO             VARCHAR2(01),
        IDPRCMPATIVO         VARCHAR2(01),
        CDMARCA              VARCHAR2(05),
        NMMARCA              VARCHAR2(20),
        IDITMCONS            VARCHAR2(01),
        LISTA_NRAUTOFORN     VARCHAR2(100),
        CDARVPRODAF          VARCHAR2(20),
        NMPRODUTOAF          VARCHAR2(50));
/