CREATE TABLE fa_lease_schedule_items_int (
    LEASE_SCH_ITEMS_INTERFACE_ID    NUMBER(18, 0) ,
    TRANSACTION_DATE                DATE          ,
    BATCH_NAME                      VARCHAR2(120) ,
    LEASE_NUMBER                    VARCHAR2(120) ,
    BOOK_TYPE_CODE                  VARCHAR2(120) ,
    ASSET_SCHEDULE_NUM              NUMBER(18, 0) ,
    LINE_NUMBER                     NUMBER(18, 0) ,
    LEASE_INTERFACE_ID              NUMBER(18, 0) ,
    LEASE_BOOKS_INTERFACE_ID        NUMBER(18, 0) ,
    LEASE_SCH_INTERFACE_ID          NUMBER(18, 0) ,
    LEASE_SCHEDULE_ITEM_ID          NUMBER(18, 0) ,
    LEASE_ID                        NUMBER(18, 0) ,
    LEASE_SCHEDULE_ID               NUMBER(18, 0) ,
    TRANSACTION_NAME                VARCHAR2(960) ,
    TRANSACTION_TYPE_CODE           VARCHAR2(120) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    WORKER_ID                       NUMBER(18, 0) ,
    ERROR_MSG                       VARCHAR2(4000),
    LOAD_REQUEST_ID                 NUMBER(18, 0) ,
    POSTING_STATUS                  VARCHAR2(120) ,
    PAYMENT_TYPE_CODE               VARCHAR2(120)     NOT NULL,
    INVOICE_DATE                    DATE          ,
    INTEREST_DUE_DATE               DATE          ,
    PAYMENT_AMOUNT                  NUMBER        ,
    NUMBER_OF_PAYMENTS              NUMBER(4, 0)  ,
    INTEREST_RATE                   NUMBER        ,
    QUANTITY                        NUMBER        ,
    UNIT_OF_MEASURE                 VARCHAR2(100) ,
    PRICE_INDEX_ID                  NUMBER(18, 0) ,
    EXCLUDE_FROM_LIABILITY_FLAG     VARCHAR2(4)   ,
    EXCLUDE_FROM_COST_FLAG          VARCHAR2(4)   ,
    EXPENSE_CHANGES_FLAG            VARCHAR2(4)   ,
    PURCHASE_DATE                   DATE          ,
    TERMINATION_DATE                DATE          ,
    FLAT_INTEREST_AMOUNT            NUMBER        ,
    PERIOD_END_DATE                 DATE          ,
    PERIOD_END_LIABILITY_FLAG       VARCHAR2(4)   ,
    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) ,
    ATTRIBUTE16                     VARCHAR2(600) ,
    ATTRIBUTE17                     VARCHAR2(600) ,
    ATTRIBUTE18                     VARCHAR2(600) ,
    ATTRIBUTE19                     VARCHAR2(600) ,
    ATTRIBUTE20                     VARCHAR2(600) ,
    ATTRIBUTE21                     VARCHAR2(600) ,
    ATTRIBUTE22                     VARCHAR2(600) ,
    ATTRIBUTE23                     VARCHAR2(600) ,
    ATTRIBUTE24                     VARCHAR2(600) ,
    ATTRIBUTE25                     VARCHAR2(600) ,
    ATTRIBUTE26                     VARCHAR2(600) ,
    ATTRIBUTE27                     VARCHAR2(600) ,
    ATTRIBUTE28                     VARCHAR2(600) ,
    ATTRIBUTE29                     VARCHAR2(600) ,
    ATTRIBUTE30                     VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    LEASE_SCH_ITEMS_INTERFACE_ID    NUMBER(18, 0) ,
    TRANSACTION_DATE                DATE          ,
    BATCH_NAME                      VARCHAR2(120) ,
    LEASE_NUMBER                    VARCHAR2(120) ,
    BOOK_TYPE_CODE                  VARCHAR2(120) ,
    ASSET_SCHEDULE_NUM              NUMBER(18, 0) ,
    LINE_NUMBER                     NUMBER(18, 0) ,
    LEASE_INTERFACE_ID              NUMBER(18, 0) ,
    LEASE_BOOKS_INTERFACE_ID        NUMBER(18, 0) ,
    LEASE_SCH_INTERFACE_ID          NUMBER(18, 0) ,
    LEASE_SCHEDULE_ITEM_ID          NUMBER(18, 0) ,
    LEASE_ID                        NUMBER(18, 0) ,
    LEASE_SCHEDULE_ID               NUMBER(18, 0) ,
    TRANSACTION_NAME                VARCHAR2(960) ,
    TRANSACTION_TYPE_CODE           VARCHAR2(120) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    WORKER_ID                       NUMBER(18, 0) ,
    ERROR_MSG                       VARCHAR2(4000),
    LOAD_REQUEST_ID                 NUMBER(18, 0) ,
    POSTING_STATUS                  VARCHAR2(120) ,
    PAYMENT_TYPE_CODE               VARCHAR2(120)     NOT NULL,
    INVOICE_DATE                    DATE          ,
    INTEREST_DUE_DATE               DATE          ,
    PAYMENT_AMOUNT                  NUMBER        ,
    NUMBER_OF_PAYMENTS              NUMBER(4, 0)  ,
    INTEREST_RATE                   NUMBER        ,
    QUANTITY                        NUMBER        ,
    UNIT_OF_MEASURE                 VARCHAR2(100) ,
    PRICE_INDEX_ID                  NUMBER(18, 0) ,
    EXCLUDE_FROM_LIABILITY_FLAG     VARCHAR2(4)   ,
    EXCLUDE_FROM_COST_FLAG          VARCHAR2(4)   ,
    EXPENSE_CHANGES_FLAG            VARCHAR2(4)   ,
    PURCHASE_DATE                   DATE          ,
    TERMINATION_DATE                DATE          ,
    FLAT_INTEREST_AMOUNT            NUMBER        ,
    PERIOD_END_DATE                 DATE          ,
    PERIOD_END_LIABILITY_FLAG       VARCHAR2(4)   ,
    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) ,
    ATTRIBUTE16                     VARCHAR2(600) ,
    ATTRIBUTE17                     VARCHAR2(600) ,
    ATTRIBUTE18                     VARCHAR2(600) ,
    ATTRIBUTE19                     VARCHAR2(600) ,
    ATTRIBUTE20                     VARCHAR2(600) ,
    ATTRIBUTE21                     VARCHAR2(600) ,
    ATTRIBUTE22                     VARCHAR2(600) ,
    ATTRIBUTE23                     VARCHAR2(600) ,
    ATTRIBUTE24                     VARCHAR2(600) ,
    ATTRIBUTE25                     VARCHAR2(600) ,
    ATTRIBUTE26                     VARCHAR2(600) ,
    ATTRIBUTE27                     VARCHAR2(600) ,
    ATTRIBUTE28                     VARCHAR2(600) ,
    ATTRIBUTE29                     VARCHAR2(600) ,
    ATTRIBUTE30                     VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    CREATION_DATE                   TIMESTAMP(6)      NOT NULL,
    CREATED_BY                      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    LAST_UPDATED_BY                 VARCHAR2(256)     NOT NULL,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    CONSTRAINT pk_fa_lease_schedule_items_int PRIMARY KEY (LEASE_SCH_ITEMS_INTERFACE_ID, LEASE_SCH_ITEMS_INTERFACE_ID)
);
