CREATE TABLE ben_bill_charges_ (
    BILL_CHARGE_ID            NUMBER(18, 0) ,
    PERSON_ID                 NUMBER(18, 0) ,
    BILLING_DATE              DATE          ,
    HOLD_BILL_FLAG            VARCHAR2(120) ,
    TOTAL_BILL_AMT            NUMBER        ,
    BILL_YEAR                 VARCHAR2(120) ,
    BILL_PERIOD               VARCHAR2(480) ,
    STATUS                    VARCHAR2(120) ,
    BILL_CAL_ID               NUMBER(18, 0) ,
    BILL_SOURCE               VARCHAR2(120) ,
    COMMENTS                  VARCHAR2(4000),
    BILL_GENERATED            VARCHAR2(120) ,
    BILL_GENERATED_DATE       DATE          ,
    PAST_AMT_DUE              NUMBER        ,
    BILL_NUM                  NUMBER(18, 0) ,
    BILL_REASON               VARCHAR2(960) ,
    OTHER_AMT_DUE             NUMBER        ,
    CURRENCY_CODE             VARCHAR2(120) ,
    PER_ACCT_NUM              NUMBER(18, 0) ,
    CURRENT_BILL_AMT          NUMBER        ,
    TOTAL_TAX_AMT             NUMBER        ,
    PER_BILL_INFO_ID          NUMBER(18, 0) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    LAST_UPDATED_BY           VARCHAR2(256) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256) ,
    CREATION_DATE             TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)  ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    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          ,
    BCH_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCH_ATTRIBUTE1            VARCHAR2(600) ,
    BCH_ATTRIBUTE2            VARCHAR2(600) ,
    BCH_ATTRIBUTE3            VARCHAR2(600) ,
    BCH_ATTRIBUTE4            VARCHAR2(600) ,
    BCH_ATTRIBUTE5            VARCHAR2(600) ,
    BCH_ATTRIBUTE6            VARCHAR2(600) ,
    BCH_ATTRIBUTE7            VARCHAR2(600) ,
    BCH_ATTRIBUTE8            VARCHAR2(600) ,
    BCH_ATTRIBUTE9            VARCHAR2(600) ,
    BCH_ATTRIBUTE10           VARCHAR2(600) ,
    BCH_ATTRIBUTE_DATE1       DATE          ,
    BCH_ATTRIBUTE_DATE2       DATE          ,
    BCH_ATTRIBUTE_DATE3       DATE          ,
    BCH_ATTRIBUTE_DATE4       DATE          ,
    BCH_ATTRIBUTE_DATE5       DATE          ,
    BCH_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER5     NUMBER        ,
    AUDIT_ACTION_TYPE_        VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_     VARCHAR2(4000),
    AUDIT_IMPERSONATOR_       VARCHAR2(256) ,
    BILL_CHARGE_ID            NUMBER(18, 0) ,
    PERSON_ID                 NUMBER(18, 0) ,
    BILLING_DATE              DATE          ,
    HOLD_BILL_FLAG            VARCHAR2(120) ,
    TOTAL_BILL_AMT            NUMBER        ,
    BILL_YEAR                 VARCHAR2(120) ,
    BILL_PERIOD               VARCHAR2(480) ,
    STATUS                    VARCHAR2(120) ,
    BILL_CAL_ID               NUMBER(18, 0) ,
    BILL_SOURCE               VARCHAR2(120) ,
    COMMENTS                  VARCHAR2(4000),
    BILL_GENERATED            VARCHAR2(120) ,
    BILL_GENERATED_DATE       DATE          ,
    PAST_AMT_DUE              NUMBER        ,
    BILL_NUM                  NUMBER(18, 0) ,
    BILL_REASON               VARCHAR2(960) ,
    OTHER_AMT_DUE             NUMBER        ,
    CURRENCY_CODE             VARCHAR2(120) ,
    PER_ACCT_NUM              NUMBER(18, 0) ,
    CURRENT_BILL_AMT          NUMBER        ,
    TOTAL_TAX_AMT             NUMBER        ,
    PER_BILL_INFO_ID          NUMBER(18, 0) ,
    LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    LAST_UPDATED_BY           VARCHAR2(256) ,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    CREATED_BY                VARCHAR2(256) ,
    CREATION_DATE             TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)  ,
    BUSINESS_GROUP_ID         NUMBER(18, 0) ,
    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          ,
    BCH_ATTRIBUTE_CATEGORY    VARCHAR2(120) ,
    BCH_ATTRIBUTE1            VARCHAR2(600) ,
    BCH_ATTRIBUTE2            VARCHAR2(600) ,
    BCH_ATTRIBUTE3            VARCHAR2(600) ,
    BCH_ATTRIBUTE4            VARCHAR2(600) ,
    BCH_ATTRIBUTE5            VARCHAR2(600) ,
    BCH_ATTRIBUTE6            VARCHAR2(600) ,
    BCH_ATTRIBUTE7            VARCHAR2(600) ,
    BCH_ATTRIBUTE8            VARCHAR2(600) ,
    BCH_ATTRIBUTE9            VARCHAR2(600) ,
    BCH_ATTRIBUTE10           VARCHAR2(600) ,
    BCH_ATTRIBUTE_DATE1       DATE          ,
    BCH_ATTRIBUTE_DATE2       DATE          ,
    BCH_ATTRIBUTE_DATE3       DATE          ,
    BCH_ATTRIBUTE_DATE4       DATE          ,
    BCH_ATTRIBUTE_DATE5       DATE          ,
    BCH_ATTRIBUTE_NUMBER1     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER2     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER3     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER4     NUMBER        ,
    BCH_ATTRIBUTE_NUMBER5     NUMBER        ,
    AUDIT_ACTION_TYPE_        VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_     VARCHAR2(4000),
    AUDIT_IMPERSONATOR_       VARCHAR2(256) ,
    CONSTRAINT pk_ben_bill_charges_ PRIMARY KEY (BILL_CHARGE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, BILL_CHARGE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY)
);
