
DROP TYPE PRECOITEMPED_TABLE
/

DROP TYPE PRECOITEMPED_TYPE
/

CREATE TYPE PRECOITEMPED_TYPE AS
OBJECT (CDFILIAL     VARCHAR2(04),
        CDPRODUTO    VARCHAR2(10),
        CDCLIENTE    VARCHAR2(21),
        CDPRECOBASE  VARCHAR2(02),
        DTENTITPED   DATE,
        CDMODPGTO    VARCHAR2(150),
        VRPRECOBASE  FLOAT,
        IDITPEDDIFER VARCHAR2(01));
/

CREATE TYPE PRECOITEMPED_TABLE AS
TABLE OF PRECOITEMPED_TYPE
/