DROP TYPE GETPEDCOLETA_TABLE
/

DROP TYPE GETPEDCOLETA_TYPE
/

CREATE TYPE GETPEDCOLETA_TYPE AS OBJECT
(
    CDREGIAO     VARCHAR2(3),
    NMREGIAO     VARCHAR2(200),
    CDOPERADOR   VARCHAR2(12),
    NMOPERADOR   VARCHAR2(200),
    CDFORNECED   VARCHAR2(21),
    NRINSJURFORN VARCHAR2(20),
    IDTPIJURFORN VARCHAR2(1),
    NMRAZSOCFORN VARCHAR2(200),
    NMFANTFORN   VARCHAR2(250),
    CDPRODUTO    VARCHAR2(10),
    NMPRODUTO    VARCHAR2(200),
    SGUNIDADE    VARCHAR2(10),
    CDPRODESTO   VARCHAR2(10),
    IDTPFRETFORN VARCHAR2(1),
    CDMARCA      VARCHAR2(5),
    NMMARCA      VARCHAR2(200),
    CDMARCAPADR  VARCHAR2(5),
    CDARVPROD    VARCHAR2(20),
    QTACOMPRAR   FLOAT,
    NRCOMPRA     VARCHAR2(10)
)
/

CREATE TYPE GETPEDCOLETA_TABLE AS TABLE OF GETPEDCOLETA_TYPE
/
