CREATE TABLE ce_cp_options (
    CP_OPTION_ID                    NUMBER(18, 0),
    BALANCE_DATE_THRESHOLD          NUMBER(18, 0),
    DEFAULT_TRANSACTION_CALENDAR    NUMBER(18, 0),
    EXTRACTION_DURATION             VARCHAR2(120),
    REPORTING_CURRENCY              VARCHAR2(60) ,
    BALANCE_CODE                    VARCHAR2(120)    NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128),
    CREATION_DATE                   TIMESTAMP(6)     NOT NULL,
    CREATED_BY                      VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    REPORTING_CONVERSION_TYPE       VARCHAR2(120),
    WEEKLY_EXTRACT_FLAG             VARCHAR2(4)      NOT NULL,
    WEEKLY_CALENDAR_ID              NUMBER(18, 0),
    PCF_SETUP_FLAG                  VARCHAR2(4)      NOT NULL,
    CP_OPTION_ID                    NUMBER(18, 0),
    BALANCE_DATE_THRESHOLD          NUMBER(18, 0),
    DEFAULT_TRANSACTION_CALENDAR    NUMBER(18, 0),
    EXTRACTION_DURATION             VARCHAR2(120),
    REPORTING_CURRENCY              VARCHAR2(60) ,
    BALANCE_CODE                    VARCHAR2(120)    NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128),
    CREATION_DATE                   TIMESTAMP(6)     NOT NULL,
    CREATED_BY                      VARCHAR2(256)    NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    REPORTING_CONVERSION_TYPE       VARCHAR2(120),
    WEEKLY_EXTRACT_FLAG             VARCHAR2(4)      NOT NULL,
    WEEKLY_CALENDAR_ID              NUMBER(18, 0),
    PCF_SETUP_FLAG                  VARCHAR2(4)      NOT NULL,
    CONSTRAINT pk_ce_cp_options PRIMARY KEY (CP_OPTION_ID, CP_OPTION_ID)
);
