CREATE TABLE je_it_tp_declaration (
    DECLARATION_ID               NUMBER(18, 0) ,
    VAT_REPORTING_ENTITY_ID      NUMBER(18, 0)     NOT NULL,
    DECLARATION_TYPE_CODE        VARCHAR2(20)      NOT NULL,
    YEAR_OF_DECLARATION          NUMBER(4, 0)      NOT NULL,
    MONTH_OF_DECLARATION         VARCHAR2(60)  ,
    PERIOD_START_DATE            DATE              NOT NULL,
    PERIOD_END_DATE              DATE              NOT NULL,
    TRANSMISSION_TYPE            VARCHAR2(20)      NOT NULL,
    TRANSMISSION_PROTOCOL_NUM    NUMBER(18, 0) ,
    DOCUMENT_PROTOCOL_NUM        NUMBER(18, 0) ,
    REPORT_MODE                  VARCHAR2(4)       NOT NULL,
    LATEST_REC_FLAG              VARCHAR2(4)       NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    DECLARATION_ID               NUMBER(18, 0) ,
    VAT_REPORTING_ENTITY_ID      NUMBER(18, 0)     NOT NULL,
    DECLARATION_TYPE_CODE        VARCHAR2(20)      NOT NULL,
    YEAR_OF_DECLARATION          NUMBER(4, 0)      NOT NULL,
    MONTH_OF_DECLARATION         VARCHAR2(60)  ,
    PERIOD_START_DATE            DATE              NOT NULL,
    PERIOD_END_DATE              DATE              NOT NULL,
    TRANSMISSION_TYPE            VARCHAR2(20)      NOT NULL,
    TRANSMISSION_PROTOCOL_NUM    NUMBER(18, 0) ,
    DOCUMENT_PROTOCOL_NUM        NUMBER(18, 0) ,
    REPORT_MODE                  VARCHAR2(4)       NOT NULL,
    LATEST_REC_FLAG              VARCHAR2(4)       NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CONSTRAINT pk_je_it_tp_declaration PRIMARY KEY (DECLARATION_ID, DECLARATION_ID)
);
