CREATE TABLE ben_bill_cycle (
    BILL_CYCLE_ID             NUMBER(18, 0) ,
    BILL_FREQ                 VARCHAR2(800)     NOT NULL,
    DUE_DAY                   NUMBER(18, 0)     NOT NULL,
    DAYS_OVERDUE              NUMBER(18, 0)     NOT NULL,
    NAME                      VARCHAR2(960)     NOT NULL,
    TYPE                      VARCHAR2(120) ,
    DESCRIPTION               VARCHAR2(1600),
    BILLING_DAY               NUMBER(18, 0) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)     NOT NULL,
    CONFIG_NUM_1              NUMBER        ,
    CONFIG_NUM_2              NUMBER        ,
    CONFIG_NUM_3              NUMBER        ,
    CONFIG_NUM_4              NUMBER        ,
    CONFIG_NUM_5              NUMBER        ,
    CONFIG_CHAR_1             VARCHAR2(960) ,
    CONFIG_CHAR_2             VARCHAR2(960) ,
    CONFIG_CHAR_3             VARCHAR2(960) ,
    CONFIG_CHAR_4             VARCHAR2(960) ,
    CONFIG_CHAR_5             VARCHAR2(960) ,
    CONFIG_DATE_1             DATE          ,
    CONFIG_DATE_2             DATE          ,
    CONFIG_DATE_3             DATE          ,
    CONFIG_DATE_4             DATE          ,
    CONFIG_DATE_5             DATE          ,
    BCL_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCL_ATTRIBUTE1            VARCHAR2(600) ,
    BCL_ATTRIBUTE2            VARCHAR2(600) ,
    BCL_ATTRIBUTE3            VARCHAR2(600) ,
    BCL_ATTRIBUTE4            VARCHAR2(600) ,
    BCL_ATTRIBUTE5            VARCHAR2(600) ,
    BCL_ATTRIBUTE6            VARCHAR2(600) ,
    BCL_ATTRIBUTE7            VARCHAR2(600) ,
    BCL_ATTRIBUTE8            VARCHAR2(600) ,
    BCL_ATTRIBUTE9            VARCHAR2(600) ,
    BCL_ATTRIBUTE10           VARCHAR2(600) ,
    BCL_ATTRIBUTE_DATE1       DATE          ,
    BCL_ATTRIBUTE_DATE2       DATE          ,
    BCL_ATTRIBUTE_DATE3       DATE          ,
    BCL_ATTRIBUTE_DATE4       DATE          ,
    BCL_ATTRIBUTE_DATE5       DATE          ,
    BCL_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER5     NUMBER        ,
    BILL_CYCLE_ID             NUMBER(18, 0) ,
    BILL_FREQ                 VARCHAR2(800)     NOT NULL,
    DUE_DAY                   NUMBER(18, 0)     NOT NULL,
    DAYS_OVERDUE              NUMBER(18, 0)     NOT NULL,
    NAME                      VARCHAR2(960)     NOT NULL,
    TYPE                      VARCHAR2(120) ,
    DESCRIPTION               VARCHAR2(1600),
    BILLING_DAY               NUMBER(18, 0) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE             TIMESTAMP(6)      NOT NULL,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    BUSINESS_GROUP_ID         NUMBER(18, 0)     NOT NULL,
    CONFIG_NUM_1              NUMBER        ,
    CONFIG_NUM_2              NUMBER        ,
    CONFIG_NUM_3              NUMBER        ,
    CONFIG_NUM_4              NUMBER        ,
    CONFIG_NUM_5              NUMBER        ,
    CONFIG_CHAR_1             VARCHAR2(960) ,
    CONFIG_CHAR_2             VARCHAR2(960) ,
    CONFIG_CHAR_3             VARCHAR2(960) ,
    CONFIG_CHAR_4             VARCHAR2(960) ,
    CONFIG_CHAR_5             VARCHAR2(960) ,
    CONFIG_DATE_1             DATE          ,
    CONFIG_DATE_2             DATE          ,
    CONFIG_DATE_3             DATE          ,
    CONFIG_DATE_4             DATE          ,
    CONFIG_DATE_5             DATE          ,
    BCL_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCL_ATTRIBUTE1            VARCHAR2(600) ,
    BCL_ATTRIBUTE2            VARCHAR2(600) ,
    BCL_ATTRIBUTE3            VARCHAR2(600) ,
    BCL_ATTRIBUTE4            VARCHAR2(600) ,
    BCL_ATTRIBUTE5            VARCHAR2(600) ,
    BCL_ATTRIBUTE6            VARCHAR2(600) ,
    BCL_ATTRIBUTE7            VARCHAR2(600) ,
    BCL_ATTRIBUTE8            VARCHAR2(600) ,
    BCL_ATTRIBUTE9            VARCHAR2(600) ,
    BCL_ATTRIBUTE10           VARCHAR2(600) ,
    BCL_ATTRIBUTE_DATE1       DATE          ,
    BCL_ATTRIBUTE_DATE2       DATE          ,
    BCL_ATTRIBUTE_DATE3       DATE          ,
    BCL_ATTRIBUTE_DATE4       DATE          ,
    BCL_ATTRIBUTE_DATE5       DATE          ,
    BCL_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCL_ATTRIBUTE_NUMBER5     NUMBER        ,
    CONSTRAINT pk_ben_bill_cycle PRIMARY KEY (BILL_CYCLE_ID, BILL_CYCLE_ID)
);
