CREATE TYPE COMPRAS_SUPPLYTEK_TYPE AS
OBJECT(CDFORNECED      VARCHAR2(21),
       NRINSJURFORN    VARCHAR2(30),
       NMRAZSOCFORN    VARCHAR2(100),
       NMFANTFORN      VARCHAR2(250),
       NMESTADO        VARCHAR2(30),
       NMREGIAOGEO     VARCHAR2(20),
       CDFILDEST       VARCHAR2(4),
       NMFILIAL        VARCHAR2(30),
       CDOPERLANC      VARCHAR2(12),
       NMOPERLANC      VARCHAR2(40),
       NRINSJURFILI    VARCHAR2(30),
       CDPRODUTO       VARCHAR2(10),
       CDARVPROD       VARCHAR2(20),
       NMPRODUTO       VARCHAR2(50),
       CDMARCA         VARCHAR2(5),
       NMMARCA         VARCHAR2(20),
       PRODFORNE       VARCHAR2(2000),
       VRPREUNIAF      FLOAT,
       QTPROGENTAF     FLOAT,
       TOTALITEM       FLOAT,
       PRECOANTERIOR   FLOAT,
       TOTALANTERIOR   FLOAT,
       DIFERENCA       FLOAT,
       NRORG           NUMBER)
/
