CREATE TABLE jv_generated_transactions (
    TRANSACTION_ID                 NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    JOINT_VENTURE_ID               NUMBER(18, 0)     NOT NULL,
    HEADER_ID                      NUMBER(18, 0)     NOT NULL,
    LINE_NUM                       NUMBER(18, 0)     NOT NULL,
    APPLICATION_ID                 NUMBER(18, 0)     NOT NULL,
    TRANSACTION_STATUS_CODE        VARCHAR2(120)     NOT NULL,
    TRANSACTION_DATE               DATE              NOT NULL,
    TRANSACTION_SOURCE_CODE        VARCHAR2(120)     NOT NULL,
    OVERHEAD_METHOD_ID             NUMBER(18, 0) ,
    LEDGER_ID                      NUMBER(18, 0)     NOT NULL,
    DEBIT_AMOUNT                   NUMBER        ,
    CREDIT_AMOUNT                  NUMBER        ,
    CURRENCY_CODE                  VARCHAR2(60)  ,
    CODE_COMBINATION_ID            NUMBER(18, 0) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    OWNER_DEFINITION_SHORT_NAME    VARCHAR2(120) ,
    STAKEHOLDER_ID                 NUMBER(18, 0) ,
    DISTRIBUTION_TYPE_CODE         VARCHAR2(120) ,
    ACCOUNTING_DATE                DATE          ,
    PERIOD_NAME                    VARCHAR2(60)  ,
    DESCRIPTION                    VARCHAR2(960) ,
    NOTES                          VARCHAR2(960) ,
    PROJECT_ID                     NUMBER(18, 0) ,
    TASK_ID                        NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID            NUMBER(18, 0) ,
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY             VARCHAR2(600) ,
    ATTRIBUTE_CHAR1                VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                VARCHAR2(600) ,
    ATTRIBUTE_CHAR10               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          ,
    TRANSACTION_ID                 NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    JOINT_VENTURE_ID               NUMBER(18, 0)     NOT NULL,
    HEADER_ID                      NUMBER(18, 0)     NOT NULL,
    LINE_NUM                       NUMBER(18, 0)     NOT NULL,
    APPLICATION_ID                 NUMBER(18, 0)     NOT NULL,
    TRANSACTION_STATUS_CODE        VARCHAR2(120)     NOT NULL,
    TRANSACTION_DATE               DATE              NOT NULL,
    TRANSACTION_SOURCE_CODE        VARCHAR2(120)     NOT NULL,
    OVERHEAD_METHOD_ID             NUMBER(18, 0) ,
    LEDGER_ID                      NUMBER(18, 0)     NOT NULL,
    DEBIT_AMOUNT                   NUMBER        ,
    CREDIT_AMOUNT                  NUMBER        ,
    CURRENCY_CODE                  VARCHAR2(60)  ,
    CODE_COMBINATION_ID            NUMBER(18, 0) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    ATTRIBUTE_CATEGORY             VARCHAR2(600) ,
    ATTRIBUTE_CHAR1                VARCHAR2(600) ,
    ATTRIBUTE_CHAR2                VARCHAR2(600) ,
    ATTRIBUTE_CHAR3                VARCHAR2(600) ,
    ATTRIBUTE_CHAR4                VARCHAR2(600) ,
    ATTRIBUTE_CHAR5                VARCHAR2(600) ,
    ATTRIBUTE_CHAR6                VARCHAR2(600) ,
    ATTRIBUTE_CHAR7                VARCHAR2(600) ,
    ATTRIBUTE_CHAR8                VARCHAR2(600) ,
    ATTRIBUTE_CHAR9                VARCHAR2(600) ,
    ATTRIBUTE_CHAR10               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          ,
    OWNER_DEFINITION_SHORT_NAME    VARCHAR2(120) ,
    STAKEHOLDER_ID                 NUMBER(18, 0) ,
    DISTRIBUTION_TYPE_CODE         VARCHAR2(120) ,
    PERIOD_NAME                    VARCHAR2(60)  ,
    DESCRIPTION                    VARCHAR2(960) ,
    NOTES                          VARCHAR2(960) ,
    PROJECT_ID                     NUMBER(18, 0) ,
    TASK_ID                        NUMBER(18, 0) ,
    EXPENDITURE_TYPE_ID            NUMBER(18, 0) ,
    ACCOUNTING_DATE                DATE          ,
    CONSTRAINT pk_jv_generated_transactions PRIMARY KEY (TRANSACTION_ID, TRANSACTION_ID)
);
