CREATE TABLE jl_br_ar_select_accounts_all (
    SELECT_ACCOUNT_ID          NUMBER(18, 0),
    SELECTION_CONTROL_ID       NUMBER(18, 0)    NOT NULL,
    BANK_ACCOUNT_ID            NUMBER(18, 0),
    GL_DATE                    DATE         ,
    SELECTION_DATE             DATE         ,
    CANCELLATION_DATE          DATE         ,
    FORMAT_DATE                DATE         ,
    REMITTANCE_DATE            DATE         ,
    PORTFOLIO_CODE             NUMBER       ,
    MIN_DOCUMENT_AMOUNT        NUMBER       ,
    MAX_DOCUMENT_AMOUNT        NUMBER       ,
    MIN_REMITTANCE_AMOUNT      NUMBER       ,
    MAX_REMITTANCE_AMOUNT      NUMBER       ,
    BANK_INSTRUCTION_CODE1     NUMBER       ,
    BANK_INSTRUCTION_CODE2     NUMBER       ,
    BANK_CHARGE_AMOUNT         NUMBER       ,
    BATCH_SOURCE_ID            NUMBER(18, 0),
    PERCENTAGE_DISTRIBUTION    NUMBER       ,
    ORG_ID                     NUMBER(18, 0)    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_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         ,
    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),
    BANK_ACCT_USE_ID           NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    RECORD_TYPE_CODE           VARCHAR2(120)    NOT NULL,
    SELECT_ACCOUNT_ID          NUMBER(18, 0),
    SELECTION_CONTROL_ID       NUMBER(18, 0)    NOT NULL,
    BANK_ACCOUNT_ID            NUMBER(18, 0),
    GL_DATE                    DATE         ,
    SELECTION_DATE             DATE         ,
    CANCELLATION_DATE          DATE         ,
    FORMAT_DATE                DATE         ,
    REMITTANCE_DATE            DATE         ,
    PORTFOLIO_CODE             NUMBER       ,
    MIN_DOCUMENT_AMOUNT        NUMBER       ,
    MAX_DOCUMENT_AMOUNT        NUMBER       ,
    MIN_REMITTANCE_AMOUNT      NUMBER       ,
    MAX_REMITTANCE_AMOUNT      NUMBER       ,
    BANK_INSTRUCTION_CODE1     NUMBER       ,
    BANK_INSTRUCTION_CODE2     NUMBER       ,
    BANK_CHARGE_AMOUNT         NUMBER       ,
    BATCH_SOURCE_ID            NUMBER(18, 0),
    PERCENTAGE_DISTRIBUTION    NUMBER       ,
    ORG_ID                     NUMBER(18, 0)    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_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         ,
    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),
    BANK_ACCT_USE_ID           NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    RECORD_TYPE_CODE           VARCHAR2(120)    NOT NULL,
    CONSTRAINT pk_jl_br_ar_select_accounts_all PRIMARY KEY (SELECT_ACCOUNT_ID, SELECT_ACCOUNT_ID)
);
