CREATE TABLE iex_dunnings (
    DUNNING_ID               NUMBER(18, 0),
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    REQUEST_ID               NUMBER(18, 0),
    PROGRAM_NAME             VARCHAR2(120),
    PROGRAM_APP_NAME         VARCHAR2(200),
    PROGRAM_UPDATE_DATE      DATE         ,
    PARTY_ID                 NUMBER(18, 0),
    CUST_ACCOUNT_ID          NUMBER(18, 0),
    SITE_USE_ID              NUMBER(18, 0),
    XML_REQUEST_ID           NUMBER(18, 0),
    XML_TEMPLATE_ID          NUMBER(18, 0),
    LETTER_NAME              VARCHAR2(120),
    STATUS                   VARCHAR2(960),
    CALLBACK_YN              VARCHAR2(4)  ,
    CALLBACK_DATE            DATE         ,
    DUNNING_METHOD           VARCHAR2(120),
    AMOUNT_DUE_REMAINING     NUMBER       ,
    CURRENCY_CODE            VARCHAR2(60) ,
    OBJECT_TYPE              VARCHAR2(120),
    OBJECT_ID                NUMBER(18, 0),
    DUNNING_LEVEL            VARCHAR2(120),
    FINANCIAL_CHARGE         NUMBER       ,
    INTEREST_AMT             NUMBER       ,
    DUNNING_PLAN_ID          NUMBER(18, 0),
    CONTACT_DESTINATION      VARCHAR2(960),
    CONTACT_PARTY_ID         NUMBER(18, 0),
    PARTY_LOCATION_ID        NUMBER(18, 0),
    DELIVERY_STATUS          VARCHAR2(120),
    PARENT_DUNNING_ID        NUMBER(18, 0),
    XML_DATA                 CLOB         ,
    DUNNING_IMAGE            BLOB         ,
    ATTRIBUTE_CATEGORY       VARCHAR2(120),
    ATTRIBUTE1               VARCHAR2(600),
    ATTRIBUTE2               VARCHAR2(600),
    ATTRIBUTE3               VARCHAR2(600),
    ATTRIBUTE4               VARCHAR2(600),
    ATTRIBUTE5               VARCHAR2(600),
    ATTRIBUTE6               VARCHAR2(600),
    ATTRIBUTE7               VARCHAR2(600),
    ATTRIBUTE8               VARCHAR2(600),
    ATTRIBUTE9               VARCHAR2(600),
    ATTRIBUTE10              VARCHAR2(600),
    ATTRIBUTE11              VARCHAR2(600),
    ATTRIBUTE12              VARCHAR2(600),
    ATTRIBUTE13              VARCHAR2(600),
    ATTRIBUTE14              VARCHAR2(600),
    ATTRIBUTE15              VARCHAR2(600),
    SECURITY_GROUP_ID        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    BU_ID                    NUMBER(18, 0)    NOT NULL,
    LOCALE                   VARCHAR2(80) ,
    DUNNING_ID               NUMBER(18, 0),
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    REQUEST_ID               NUMBER(18, 0),
    PROGRAM_NAME             VARCHAR2(120),
    PROGRAM_APP_NAME         VARCHAR2(200),
    PROGRAM_UPDATE_DATE      DATE         ,
    PARTY_ID                 NUMBER(18, 0),
    CUST_ACCOUNT_ID          NUMBER(18, 0),
    SITE_USE_ID              NUMBER(18, 0),
    XML_REQUEST_ID           NUMBER(18, 0),
    XML_TEMPLATE_ID          NUMBER(18, 0),
    LETTER_NAME              VARCHAR2(120),
    STATUS                   VARCHAR2(960),
    CALLBACK_YN              VARCHAR2(4)  ,
    CALLBACK_DATE            DATE         ,
    DUNNING_METHOD           VARCHAR2(120),
    AMOUNT_DUE_REMAINING     NUMBER       ,
    CURRENCY_CODE            VARCHAR2(60) ,
    OBJECT_TYPE              VARCHAR2(120),
    OBJECT_ID                NUMBER(18, 0),
    DUNNING_LEVEL            VARCHAR2(120),
    FINANCIAL_CHARGE         NUMBER       ,
    INTEREST_AMT             NUMBER       ,
    DUNNING_PLAN_ID          NUMBER(18, 0),
    CONTACT_DESTINATION      VARCHAR2(960),
    CONTACT_PARTY_ID         NUMBER(18, 0),
    PARTY_LOCATION_ID        NUMBER(18, 0),
    DELIVERY_STATUS          VARCHAR2(120),
    PARENT_DUNNING_ID        NUMBER(18, 0),
    XML_DATA                 CLOB         ,
    DUNNING_IMAGE            BLOB         ,
    ATTRIBUTE_CATEGORY       VARCHAR2(120),
    ATTRIBUTE1               VARCHAR2(600),
    ATTRIBUTE2               VARCHAR2(600),
    ATTRIBUTE3               VARCHAR2(600),
    ATTRIBUTE4               VARCHAR2(600),
    ATTRIBUTE5               VARCHAR2(600),
    ATTRIBUTE6               VARCHAR2(600),
    ATTRIBUTE7               VARCHAR2(600),
    ATTRIBUTE8               VARCHAR2(600),
    ATTRIBUTE9               VARCHAR2(600),
    ATTRIBUTE10              VARCHAR2(600),
    ATTRIBUTE11              VARCHAR2(600),
    ATTRIBUTE12              VARCHAR2(600),
    ATTRIBUTE13              VARCHAR2(600),
    ATTRIBUTE14              VARCHAR2(600),
    ATTRIBUTE15              VARCHAR2(600),
    SECURITY_GROUP_ID        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    BU_ID                    NUMBER(18, 0)    NOT NULL,
    LOCALE                   VARCHAR2(80) ,
    CONSTRAINT pk_iex_dunnings PRIMARY KEY (DUNNING_ID, DUNNING_ID)
);
