CREATE TABLE jl_br_ar_occurrence_docs_all (
    OCCURRENCE_ID                    NUMBER(18, 0),
    DOCUMENT_ID                      NUMBER(18, 0)    NOT NULL,
    BANK_OCCURRENCE_CODE             VARCHAR2(120)    NOT NULL,
    BANK_NUMBER                      VARCHAR2(120),
    BANK_OCCURRENCE_TYPE             VARCHAR2(120)    NOT NULL,
    OCCURRENCE_DATE                  DATE         ,
    OCCURRENCE_STATUS                VARCHAR2(120),
    ORIGINAL_REMITTANCE_MEDIA        VARCHAR2(120),
    REMITTANCE_MEDIA                 VARCHAR2(120),
    SELECTION_DATE                   DATE         ,
    BORDERO_ID                       NUMBER(18, 0),
    PORTFOLIO_CODE                   NUMBER       ,
    TRADE_NOTE_NUMBER                VARCHAR2(80) ,
    DUE_DATE                         DATE         ,
    DOCUMENT_AMOUNT                  NUMBER       ,
    BANK_INSTRUCTION_CODE1           NUMBER(2, 0) ,
    BANK_INSTRUCTION_CODE2           NUMBER(2, 0) ,
    NUM_DAYS_INSTRUCTION             NUMBER       ,
    INTEREST_PERCENT                 NUMBER       ,
    INTEREST_PERIOD                  NUMBER       ,
    INTEREST_AMOUNT                  NUMBER       ,
    GRACE_DAYS                       NUMBER       ,
    DISCOUNT_LIMIT_DATE              DATE         ,
    DISCOUNT_AMOUNT                  NUMBER       ,
    CUSTOMER_ID                      NUMBER(18, 0),
    SITE_USE_ID                      NUMBER(18, 0),
    ABATEMENT_AMOUNT                 NUMBER       ,
    FLAG_POST_GL                     VARCHAR2(4)  ,
    GL_DATE                          DATE         ,
    GL_POSTED_DATE                   DATE         ,
    ENDORSEMENT_CREDIT_CCID          NUMBER(18, 0),
    ENDORSEMENT_DEBIT_CCID           NUMBER(18, 0),
    ENDORSEMENT_DEBIT_AMOUNT         NUMBER       ,
    ENDORSEMENT_CREDIT_AMOUNT        NUMBER       ,
    BANK_CHARGE_AMOUNT               NUMBER       ,
    BANK_CHARGES_CREDIT_CCID         NUMBER(18, 0),
    BANK_CHARGES_DEBIT_CCID          NUMBER(18, 0),
    BANK_CHARGES_CREDIT_AMOUNT       NUMBER       ,
    BANK_CHARGES_DEBIT_AMOUNT        NUMBER       ,
    DISCOUNT_CRED_ACCT_CCID          NUMBER(18, 0),
    FACTORING_DEBIT_CCID             NUMBER(18, 0),
    FACTORING_CREDIT_CCID            NUMBER(18, 0),
    FACTORING_CREDIT_AMOUNT          NUMBER       ,
    FACTORING_DEBIT_AMOUNT           NUMBER       ,
    FACTOR_INTEREST_CREDIT_CCID      NUMBER(18, 0),
    FACTOR_INTEREST_DEBIT_CCID       NUMBER(18, 0),
    FACTOR_INTEREST_DEBIT_AMOUNT     NUMBER       ,
    FACTOR_INTEREST_CREDIT_AMOUNT    NUMBER       ,
    REVERSE_CHARGES_CRED_CCID        NUMBER(18, 0),
    REVERSE_CHARGES_DEB_CCID         NUMBER(18, 0),
    REVERSE_CHARGES_DEB_AMOUNT       NUMBER       ,
    REVERSE_CHARGES_CRED_AMOUNT      NUMBER       ,
    REQUEST_ID                       NUMBER(18, 0),
    RETURN_INFO                      VARCHAR2(200),
    INTEREST_INDICATOR               VARCHAR2(120),
    RETURN_REQUEST_ID                NUMBER(18, 0),
    GL_CANCEL_DATE                   DATE         ,
    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),
    FACTORING_CHARGES_CREDIT_CCID    NUMBER(18, 0),
    FACTORING_CHARGES_DEBIT_CCID     NUMBER(18, 0),
    FACTORING_CHARGES_CRED_AMOUNT    NUMBER       ,
    FACTORING_CHARGES_DEB_AMOUNT     NUMBER       ,
    DISCOUNTED_BILLS_CREDIT_CCID     NUMBER(18, 0),
    DISCOUNTED_BILLS_DEBIT_CCID      NUMBER(18, 0),
    DISCOUNTED_BILLS_CRED_AMOUNT     NUMBER       ,
    DISCOUNTED_BILLS_DEB_AMOUNT      NUMBER       ,
    DISCOUNT_CREDIT_CCID             NUMBER(18, 0),
    DISCOUNT_DEBIT_CCID              NUMBER(18, 0),
    DISCOUNT_CRED_AMOUNT             NUMBER       ,
    DISCOUNT_DEB_AMOUNT              NUMBER       ,
    CASH_CREDIT_CCID                 NUMBER(18, 0),
    CASH_DEBIT_CCID                  NUMBER(18, 0),
    CASH_CRED_AMOUNT                 NUMBER       ,
    CASH_DEB_AMOUNT                  NUMBER       ,
    BANK_PARTY_ID                    NUMBER(18, 0)    NOT NULL,
    CANCEL_EVENT_ID                  NUMBER(18, 0),
    EVENT_ID                         NUMBER(18, 0),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    COLL_BATCH_ID                    NUMBER(18, 0),
    PARTY_ID                         NUMBER(18, 0)    NOT NULL,
    BILL_TO_PARTY_SITE_ID            NUMBER(18, 0)    NOT NULL,
    PAYMENT_SCHEDULE_ID              NUMBER(18, 0),
    OCCURRENCE_ID                    NUMBER(18, 0),
    DOCUMENT_ID                      NUMBER(18, 0)    NOT NULL,
    BANK_OCCURRENCE_CODE             VARCHAR2(120)    NOT NULL,
    BANK_NUMBER                      VARCHAR2(120),
    BANK_OCCURRENCE_TYPE             VARCHAR2(120)    NOT NULL,
    OCCURRENCE_DATE                  DATE         ,
    OCCURRENCE_STATUS                VARCHAR2(120),
    ORIGINAL_REMITTANCE_MEDIA        VARCHAR2(120),
    REMITTANCE_MEDIA                 VARCHAR2(120),
    SELECTION_DATE                   DATE         ,
    BORDERO_ID                       NUMBER(18, 0),
    PORTFOLIO_CODE                   NUMBER       ,
    TRADE_NOTE_NUMBER                VARCHAR2(80) ,
    DUE_DATE                         DATE         ,
    DOCUMENT_AMOUNT                  NUMBER       ,
    BANK_INSTRUCTION_CODE1           NUMBER(2, 0) ,
    BANK_INSTRUCTION_CODE2           NUMBER(2, 0) ,
    NUM_DAYS_INSTRUCTION             NUMBER       ,
    INTEREST_PERCENT                 NUMBER       ,
    INTEREST_PERIOD                  NUMBER       ,
    INTEREST_AMOUNT                  NUMBER       ,
    GRACE_DAYS                       NUMBER       ,
    DISCOUNT_LIMIT_DATE              DATE         ,
    DISCOUNT_AMOUNT                  NUMBER       ,
    CUSTOMER_ID                      NUMBER(18, 0),
    SITE_USE_ID                      NUMBER(18, 0),
    ABATEMENT_AMOUNT                 NUMBER       ,
    FLAG_POST_GL                     VARCHAR2(4)  ,
    GL_DATE                          DATE         ,
    GL_POSTED_DATE                   DATE         ,
    ENDORSEMENT_CREDIT_CCID          NUMBER(18, 0),
    ENDORSEMENT_DEBIT_CCID           NUMBER(18, 0),
    ENDORSEMENT_DEBIT_AMOUNT         NUMBER       ,
    ENDORSEMENT_CREDIT_AMOUNT        NUMBER       ,
    BANK_CHARGE_AMOUNT               NUMBER       ,
    BANK_CHARGES_CREDIT_CCID         NUMBER(18, 0),
    BANK_CHARGES_DEBIT_CCID          NUMBER(18, 0),
    BANK_CHARGES_CREDIT_AMOUNT       NUMBER       ,
    BANK_CHARGES_DEBIT_AMOUNT        NUMBER       ,
    DISCOUNT_CRED_ACCT_CCID          NUMBER(18, 0),
    FACTORING_DEBIT_CCID             NUMBER(18, 0),
    FACTORING_CREDIT_CCID            NUMBER(18, 0),
    FACTORING_CREDIT_AMOUNT          NUMBER       ,
    FACTORING_DEBIT_AMOUNT           NUMBER       ,
    FACTOR_INTEREST_CREDIT_CCID      NUMBER(18, 0),
    FACTOR_INTEREST_DEBIT_CCID       NUMBER(18, 0),
    FACTOR_INTEREST_DEBIT_AMOUNT     NUMBER       ,
    FACTOR_INTEREST_CREDIT_AMOUNT    NUMBER       ,
    REVERSE_CHARGES_CRED_CCID        NUMBER(18, 0),
    REVERSE_CHARGES_DEB_CCID         NUMBER(18, 0),
    REVERSE_CHARGES_DEB_AMOUNT       NUMBER       ,
    REVERSE_CHARGES_CRED_AMOUNT      NUMBER       ,
    REQUEST_ID                       NUMBER(18, 0),
    RETURN_INFO                      VARCHAR2(200),
    INTEREST_INDICATOR               VARCHAR2(120),
    RETURN_REQUEST_ID                NUMBER(18, 0),
    GL_CANCEL_DATE                   DATE         ,
    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),
    FACTORING_CHARGES_CREDIT_CCID    NUMBER(18, 0),
    FACTORING_CHARGES_DEBIT_CCID     NUMBER(18, 0),
    FACTORING_CHARGES_CRED_AMOUNT    NUMBER       ,
    FACTORING_CHARGES_DEB_AMOUNT     NUMBER       ,
    DISCOUNTED_BILLS_CREDIT_CCID     NUMBER(18, 0),
    DISCOUNTED_BILLS_DEBIT_CCID      NUMBER(18, 0),
    DISCOUNTED_BILLS_CRED_AMOUNT     NUMBER       ,
    DISCOUNTED_BILLS_DEB_AMOUNT      NUMBER       ,
    DISCOUNT_CREDIT_CCID             NUMBER(18, 0),
    DISCOUNT_DEBIT_CCID              NUMBER(18, 0),
    DISCOUNT_CRED_AMOUNT             NUMBER       ,
    DISCOUNT_DEB_AMOUNT              NUMBER       ,
    CASH_CREDIT_CCID                 NUMBER(18, 0),
    CASH_DEBIT_CCID                  NUMBER(18, 0),
    CASH_CRED_AMOUNT                 NUMBER       ,
    CASH_DEB_AMOUNT                  NUMBER       ,
    BANK_PARTY_ID                    NUMBER(18, 0)    NOT NULL,
    CANCEL_EVENT_ID                  NUMBER(18, 0),
    EVENT_ID                         NUMBER(18, 0),
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)     NOT NULL,
    COLL_BATCH_ID                    NUMBER(18, 0),
    PARTY_ID                         NUMBER(18, 0)    NOT NULL,
    BILL_TO_PARTY_SITE_ID            NUMBER(18, 0)    NOT NULL,
    PAYMENT_SCHEDULE_ID              NUMBER(18, 0),
    CONSTRAINT pk_jl_br_ar_occurrence_docs_all PRIMARY KEY (OCCURRENCE_ID, OCCURRENCE_ID)
);
