CREATE TABLE ap_idr_recognition_dyd (
    PERIOD                VARCHAR2(200) ,
    MATCH_TYPE            VARCHAR2(120) ,
    SUPPLIER_SITE_TYPE    VARCHAR2(400) ,
    DATA_STATE_TYPE       VARCHAR2(120) ,
    TOTAL_CREATED         NUMBER        ,
    TOTAL_CANCELLED       NUMBER        ,
    TOTAL_COMPLETED       NUMBER        ,
    PURCHASE_ORDER        VARCHAR2(400) ,
    SUPPLIER_NAME         VARCHAR2(400) ,
    SUPPLIER_SITE         VARCHAR2(400) ,
    INVOICE_NUMBER        VARCHAR2(400) ,
    INVOICE_TYPE          VARCHAR2(120) ,
    INVOICE_CURRENCY      VARCHAR2(120) ,
    INVOICE_AMOUNT        VARCHAR2(400) ,
    INVOICE_DATE          VARCHAR2(400) ,
    MODEL_TYPE            VARCHAR2(200) ,
    REPORT_TYPE           VARCHAR2(200) ,
    REQUEST_ID            NUMBER        ,
    CREATION_DATE         DATE          ,
    CREATED_BY            VARCHAR2(200) ,
    LAST_UPDATE_DATE      DATE          ,
    LAST_UPDATED_BY       VARCHAR2(200) ,
    LAST_UPDATED_LOGIN    VARCHAR2(200) ,
    REFERENCENUMBER_1     NUMBER        ,
    REFERENCENUMBER_2     NUMBER        ,
    REFERENCENUMBER_3     NUMBER        ,
    REFERENCENUMBER_4     NUMBER        ,
    REFERENCENUMBER_5     NUMBER        ,
    REFERENCENUMBER_6     NUMBER        ,
    REFERENCENUMBER_7     NUMBER        ,
    REFERENCENUMBER_8     NUMBER        ,
    REFERENCENUMBER_9     NUMBER        ,
    REFERENCENUMBER_10    NUMBER        ,
    REFERENCESTRING_1     VARCHAR2(1080),
    REFERENCESTRING_2     VARCHAR2(1080),
    REFERENCESTRING_3     VARCHAR2(1080),
    REFERENCESTRING_4     VARCHAR2(1080),
    REFERENCESTRING_5     VARCHAR2(1080),
    REFERENCESTRING_6     VARCHAR2(1080),
    REFERENCESTRING_7     VARCHAR2(1080),
    REFERENCESTRING_8     VARCHAR2(1080),
    REFERENCESTRING_9     VARCHAR2(1080),
    REFERENCESTRING_10    VARCHAR2(1080),
    REFERENCEDATE_1       DATE          ,
    REFERENCEDATE_2       DATE          ,
    REFERENCEDATE_3       DATE          ,
    REFERENCEDATE_4       DATE          ,
    REFERENCEDATE_5       DATE          ,
    REFERENCEDATE_6       DATE          ,
    REFERENCEDATE_7       DATE          ,
    REFERENCEDATE_8       DATE          ,
    REFERENCEDATE_9       DATE          ,
    REFERENCEDATE_10      DATE          ,
    PERIOD                VARCHAR2(200) ,
    MATCH_TYPE            VARCHAR2(120) ,
    SUPPLIER_SITE_TYPE    VARCHAR2(400) ,
    DATA_STATE_TYPE       VARCHAR2(120) ,
    TOTAL_CREATED         NUMBER        ,
    TOTAL_CANCELLED       NUMBER        ,
    TOTAL_COMPLETED       NUMBER        ,
    PURCHASE_ORDER        VARCHAR2(400) ,
    SUPPLIER_NAME         VARCHAR2(400) ,
    SUPPLIER_SITE         VARCHAR2(400) ,
    INVOICE_NUMBER        VARCHAR2(400) ,
    INVOICE_TYPE          VARCHAR2(120) ,
    INVOICE_CURRENCY      VARCHAR2(120) ,
    INVOICE_AMOUNT        VARCHAR2(400) ,
    INVOICE_DATE          VARCHAR2(400) ,
    MODEL_TYPE            VARCHAR2(200) ,
    REPORT_TYPE           VARCHAR2(200) ,
    REQUEST_ID            NUMBER        ,
    CREATION_DATE         DATE          ,
    CREATED_BY            VARCHAR2(200) ,
    LAST_UPDATE_DATE      DATE          ,
    LAST_UPDATED_BY       VARCHAR2(200) ,
    LAST_UPDATED_LOGIN    VARCHAR2(200) ,
    REFERENCENUMBER_1     NUMBER        ,
    REFERENCENUMBER_2     NUMBER        ,
    REFERENCENUMBER_3     NUMBER        ,
    REFERENCENUMBER_4     NUMBER        ,
    REFERENCENUMBER_5     NUMBER        ,
    REFERENCENUMBER_6     NUMBER        ,
    REFERENCENUMBER_7     NUMBER        ,
    REFERENCENUMBER_8     NUMBER        ,
    REFERENCENUMBER_9     NUMBER        ,
    REFERENCENUMBER_10    NUMBER        ,
    REFERENCESTRING_1     VARCHAR2(1080),
    REFERENCESTRING_2     VARCHAR2(1080),
    REFERENCESTRING_3     VARCHAR2(1080),
    REFERENCESTRING_4     VARCHAR2(1080),
    REFERENCESTRING_5     VARCHAR2(1080),
    REFERENCESTRING_6     VARCHAR2(1080),
    REFERENCESTRING_7     VARCHAR2(1080),
    REFERENCESTRING_8     VARCHAR2(1080),
    REFERENCESTRING_9     VARCHAR2(1080),
    REFERENCESTRING_10    VARCHAR2(1080),
    REFERENCEDATE_1       DATE          ,
    REFERENCEDATE_2       DATE          ,
    REFERENCEDATE_3       DATE          ,
    REFERENCEDATE_4       DATE          ,
    REFERENCEDATE_5       DATE          ,
    REFERENCEDATE_6       DATE          ,
    REFERENCEDATE_7       DATE          ,
    REFERENCEDATE_8       DATE          ,
    REFERENCEDATE_9       DATE          ,
    REFERENCEDATE_10      DATE          
);
