CREATE TYPE TRACKING_AF_TYPE AS
OBJECT(CDFILDEST           VARCHAR2(4),
       NMFILIAL            VARCHAR2(50),
       CDFILLANC           VARCHAR2(4),
       CDFILCENTCMP        VARCHAR2(4),
       NRAUTOFORN          VARCHAR2(10),
       CDOPERADOR          VARCHAR2(12),
       NMOPERADOR          VARCHAR2(50),
       DTAUTOFORN          DATE,
       VRTOTALAF           FLOAT,
       DTPROGENTAF         DATE,
       IDBAIXAAF           VARCHAR2(1),
       IDTIPOLANCAF        VARCHAR2(1), 
       IDAFEXPIRADA        VARCHAR2(1),
       IDITAFMIGRADA       VARCHAR2(1),
       IDAUTOFORNEX        VARCHAR2(1),
       IDSITUATENDIMENTOAF VARCHAR2(1),
       TXJUSTIFICRECAF     VARCHAR2(2000),
       DTCONFATENDIMENTOAF DATE,
       IDCONFRECEBIMENTO   VARCHAR2(1),
       DTCONFRECEBIMENTO   DATE,
       CDOPERCONFAF        VARCHAR2(12),
       NMOPERCONFAF        VARCHAR2(40),
       NMPAIS              VARCHAR2(30),
       SGESTADO            VARCHAR2(2),
       NMESTADO            VARCHAR2(30),
       NMREGIAOGEO         VARCHAR2(30),
       NMMUNICIPIO         VARCHAR2(30),
       CDFORNECED          VARCHAR2(21),
       NRINSJURFORN        VARCHAR2(20),
       NMRAZSOCFORN        VARCHAR2(100),
       NMFANTFORN          VARCHAR2(250),
       CDFILLANNF          VARCHAR2(4),
       NRLANCTONF          VARCHAR2(10),
       NRNOTAFISC          VARCHAR(20),
       DTEMISSAO           DATE, 
       DTENTRSAID          DATE,
       VRNOTAFISC          FLOAT,
       NRACESSONFE         VARCHAR2(50),
       VRPBRUTOVOLU        FLOAT,
       VRPLIQUVOLU         FLOAT,
       IDTPNOTAFISCAL      NUMBER,
       NMOPERLANCNF        VARCHAR2(100),
       NRORG               NUMBER)
/