CREATE TABLE je_net_batches (
    BATCH_ID                        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    AGREEMENT_ID                    NUMBER(18, 0),
    BATCH_NAME                      VARCHAR2(720)    NOT NULL,
    BATCH_NUMBER                    NUMBER(18, 0)    NOT NULL,
    REVIEW_NETTING_BATCH_FLAG       VARCHAR2(4)      NOT NULL,
    BATCH_CURRENCY_CODE             VARCHAR2(60) ,
    BATCH_STATUS_CODE               VARCHAR2(120),
    TOTAL_NETTED_AMOUNT             NUMBER       ,
    TRANSACTION_DUE_DATE            DATE         ,
    SETTLEMENT_DATE                 DATE         ,
    RESPONSE_DATE                   DATE         ,
    EXCHANGE_RATE_TYPE              VARCHAR2(120),
    EXCHANGE_RATE                   NUMBER       ,
    GL_DATE                         DATE         ,
    CHECKRUN_ID                     NUMBER(18, 0),
    LEGAL_ENTITY_ID                 NUMBER(18, 0),
    NETTING_GROUP_CODE              VARCHAR2(120),
    GENERATE_SETTLEMENT_BU_ID       NUMBER(18, 0),
    PARENT_REQUEST_ID               NUMBER(18, 0),
    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,
    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),
    ATTRIBUTE_DATE1                 DATE         ,
    ATTRIBUTE_DATE2                 DATE         ,
    ATTRIBUTE_DATE3                 DATE         ,
    ATTRIBUTE_DATE4                 DATE         ,
    ATTRIBUTE_DATE5                 DATE         ,
    ATTRIBUTE_NUMBER1               NUMBER       ,
    ATTRIBUTE_NUMBER2               NUMBER       ,
    ATTRIBUTE_NUMBER3               NUMBER       ,
    ATTRIBUTE_NUMBER4               NUMBER       ,
    ATTRIBUTE_NUMBER5               NUMBER       ,
    TRANSACTION_START_DATE          DATE         ,
    TRANSACTION_END_DATE            DATE         ,
    CONVERSION_RATE_DATE            DATE         ,
    PAYMENT_CURRENCY_CODE           VARCHAR2(60) ,
    TOTAL_PAY_CURR_NETTED_AMOUNT    NUMBER       ,
    NETTING_LIMIT_AMOUNT            NUMBER       ,
    BATCH_ID                        NUMBER(18, 0),
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)     NOT NULL,
    AGREEMENT_ID                    NUMBER(18, 0),
    BATCH_NAME                      VARCHAR2(720)    NOT NULL,
    BATCH_NUMBER                    NUMBER(18, 0)    NOT NULL,
    REVIEW_NETTING_BATCH_FLAG       VARCHAR2(4)      NOT NULL,
    BATCH_CURRENCY_CODE             VARCHAR2(60) ,
    BATCH_STATUS_CODE               VARCHAR2(120),
    TOTAL_NETTED_AMOUNT             NUMBER       ,
    TRANSACTION_DUE_DATE            DATE         ,
    SETTLEMENT_DATE                 DATE         ,
    RESPONSE_DATE                   DATE         ,
    EXCHANGE_RATE_TYPE              VARCHAR2(120),
    EXCHANGE_RATE                   NUMBER       ,
    GL_DATE                         DATE         ,
    CHECKRUN_ID                     NUMBER(18, 0),
    LEGAL_ENTITY_ID                 NUMBER(18, 0),
    NETTING_GROUP_CODE              VARCHAR2(120),
    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,
    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),
    ATTRIBUTE_DATE1                 DATE         ,
    ATTRIBUTE_DATE2                 DATE         ,
    ATTRIBUTE_DATE3                 DATE         ,
    ATTRIBUTE_DATE4                 DATE         ,
    ATTRIBUTE_DATE5                 DATE         ,
    ATTRIBUTE_NUMBER1               NUMBER       ,
    ATTRIBUTE_NUMBER2               NUMBER       ,
    ATTRIBUTE_NUMBER3               NUMBER       ,
    ATTRIBUTE_NUMBER4               NUMBER       ,
    ATTRIBUTE_NUMBER5               NUMBER       ,
    GENERATE_SETTLEMENT_BU_ID       NUMBER(18, 0),
    PARENT_REQUEST_ID               NUMBER(18, 0),
    TRANSACTION_START_DATE          DATE         ,
    TRANSACTION_END_DATE            DATE         ,
    CONVERSION_RATE_DATE            DATE         ,
    PAYMENT_CURRENCY_CODE           VARCHAR2(60) ,
    TOTAL_PAY_CURR_NETTED_AMOUNT    NUMBER       ,
    NETTING_LIMIT_AMOUNT            NUMBER       ,
    CONSTRAINT pk_je_net_batches PRIMARY KEY (BATCH_ID, BATCH_ID)
);
