CREATE TYPE EQUAL_FORNE_PEDCOLETA_TYPE AS
OBJECT( CDREGIAO      VARCHAR2(3),
        CDFILIAL      VARCHAR2(4),
        CDPRODUTO     VARCHAR2(10),
        CDARVPROD     VARCHAR2(20),
        NMPRODUTO     VARCHAR2(50),
        SGUNIDADE     VARCHAR2(10),
        VRFATOCONV    FLOAT,
        CDMARCA       VARCHAR2(5),
        NMMARCA       VARCHAR2(20),
        CDFORNECED    VARCHAR2(21),
        NMFANTFORN    VARCHAR2(250),
        NRPEDCOLETA   VARCHAR2(10),
        NRPEDIDOCOL   VARCHAR2(10),
        QUANTIDADE    FLOAT,
        DSPERIODO     VARCHAR2(50),
        VRPRECECON    FLOAT,
        VRPRECUNIT    FLOAT,
        VRTOTAL       FLOAT,
        DSPERIODOANT  VARCHAR2(50),
        VRPRECECONANT FLOAT,
        VRPRECUNITANT FLOAT,
        VRTOTALANT    FLOAT,
        VRTOTALPRECOBJ FLOAT,
        VRTOTALPRECREN FLOAT,
        NRORG          NUMBER,
        VRNEGOCIACAO FLOAT,
        VRPROBJETIVO FLOAT)
/