CREATE TYPE GERA_ACRES_PEDCOLETA_TYPE AS OBJECT
  (
   CDREGIAO       VARCHAR2(4) , 
   NMREGIAO       VARCHAR2(30), 
   CDOPERADOR     VARCHAR2(12), 
   NMOPERADOR     VARCHAR2(40), 
   CDFORNECED     VARCHAR2(20), 
   NRINSJURFORN   VARCHAR2(14), 
   IDTPIJURFORN   VARCHAR2(3) , 
   NMRAZSOCFORN   VARCHAR2(40), 
   NMFANTFORN     VARCHAR2(250), 
   CDPRODUTO      VARCHAR2(12), 
   NMPRODUTO      VARCHAR2(50), 
   SGUNIDADE      VARCHAR2(12), 
   CDPRODESTO     VARCHAR2(12), 
   IDTPFRETFORN   VARCHAR2(3) , 
   CDMARCA        VARCHAR2(5) , 
   NMMARCA        VARCHAR2(20), 
   CDMARCAPADR    VARCHAR2(5) , 
   CDARVPROD      VARCHAR2(12), 
   QTACOMPRAR     INT         , 
   NRCOMPRA       VARCHAR2(20)  
  );
/