CREATE TABLE jl_br_ar_bank_returns_all (
    RETURN_ID                    NUMBER(18, 0) ,
    BANK_OCCURRENCE_CODE         VARCHAR2(120)     NOT NULL,
    OCCURRENCE_DATE              DATE              NOT NULL,
    FILE_CONTROL                 VARCHAR2(80)      NOT NULL,
    ENTRY_SEQUENTIAL_NUMBER      NUMBER(6, 0)      NOT NULL,
    GENERATION_DATE              DATE              NOT NULL,
    PROCESSING_DATE              DATE              NOT NULL,
    DOCUMENT_ID                  NUMBER(18, 0)     NOT NULL,
    BANK_NUMBER                  VARCHAR2(120) ,
    OUR_NUMBER                   VARCHAR2(80)  ,
    TRADE_NOTE_NUMBER            VARCHAR2(184)     NOT NULL,
    DUE_DATE                     DATE          ,
    TRADE_NOTE_AMOUNT            NUMBER        ,
    COLLECTOR_BANK_NUMBER        VARCHAR2(120) ,
    COLLECTOR_BRANCH_NUMBER      VARCHAR2(100) ,
    BANK_CHARGE_AMOUNT           NUMBER        ,
    ABATEMENT_AMOUNT             NUMBER        ,
    DISCOUNT_AMOUNT              NUMBER        ,
    CREDIT_AMOUNT                NUMBER        ,
    INTEREST_AMOUNT_RECEIVED     NUMBER        ,
    CUSTOMER_NAME                VARCHAR2(960) ,
    RETURN_INFO                  VARCHAR2(200) ,
    BANK_USE                     VARCHAR2(100) ,
    COMPANY_USE                  NUMBER        ,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    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) ,
    CUSTOMER_ID                  NUMBER(18, 0)     NOT NULL,
    BANK_PARTY_ID                NUMBER(18, 0)     NOT NULL,
    COLLECTOR_BANK_PARTY_ID      NUMBER(18, 0) ,
    COLLECTOR_BRANCH_PARTY_ID    NUMBER(18, 0) ,
    BATCH_SOURCE_SEQ_ID          NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    BILLING_ORG_ID               NUMBER(18, 0)     NOT NULL,
    BRANCH_PARTY_ID              NUMBER(18, 0)     NOT NULL,
    BANK_ACCT_USE_ID             NUMBER(18, 0)     NOT NULL,
    ATTRIBUTE_CATEGORY           VARCHAR2(600) ,
    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          ,
    PIX_QR_CODE_EMV              VARCHAR2(2400),
    PIX_QR_CODE_URL              VARCHAR2(480) ,
    TAX_AUTHORITY_DOC_NUMBER     VARCHAR2(480) ,
    CITY_TAX_AMOUNT              NUMBER        ,
    STATE_TAX_AMOUNT             NUMBER        ,
    COUNTRY_TAX_AMOUNT           NUMBER        ,
    EXCISE_TAX_AMOUNT            NUMBER        ,
    RETURN_ID                    NUMBER(18, 0) ,
    BANK_OCCURRENCE_CODE         VARCHAR2(120)     NOT NULL,
    OCCURRENCE_DATE              DATE              NOT NULL,
    FILE_CONTROL                 VARCHAR2(80)      NOT NULL,
    ENTRY_SEQUENTIAL_NUMBER      NUMBER(6, 0)      NOT NULL,
    GENERATION_DATE              DATE              NOT NULL,
    PROCESSING_DATE              DATE              NOT NULL,
    DOCUMENT_ID                  NUMBER(18, 0)     NOT NULL,
    BANK_NUMBER                  VARCHAR2(120) ,
    OUR_NUMBER                   VARCHAR2(80)  ,
    TRADE_NOTE_NUMBER            VARCHAR2(184)     NOT NULL,
    DUE_DATE                     DATE          ,
    TRADE_NOTE_AMOUNT            NUMBER        ,
    COLLECTOR_BANK_NUMBER        VARCHAR2(120) ,
    COLLECTOR_BRANCH_NUMBER      VARCHAR2(100) ,
    BANK_CHARGE_AMOUNT           NUMBER        ,
    ABATEMENT_AMOUNT             NUMBER        ,
    DISCOUNT_AMOUNT              NUMBER        ,
    CREDIT_AMOUNT                NUMBER        ,
    INTEREST_AMOUNT_RECEIVED     NUMBER        ,
    CUSTOMER_NAME                VARCHAR2(960) ,
    RETURN_INFO                  VARCHAR2(200) ,
    BANK_USE                     VARCHAR2(100) ,
    COMPANY_USE                  NUMBER        ,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    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) ,
    CUSTOMER_ID                  NUMBER(18, 0)     NOT NULL,
    BANK_PARTY_ID                NUMBER(18, 0)     NOT NULL,
    COLLECTOR_BANK_PARTY_ID      NUMBER(18, 0) ,
    COLLECTOR_BRANCH_PARTY_ID    NUMBER(18, 0) ,
    BATCH_SOURCE_SEQ_ID          NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    BILLING_ORG_ID               NUMBER(18, 0)     NOT NULL,
    BRANCH_PARTY_ID              NUMBER(18, 0)     NOT NULL,
    BANK_ACCT_USE_ID             NUMBER(18, 0)     NOT NULL,
    ATTRIBUTE_CATEGORY           VARCHAR2(600) ,
    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          ,
    PIX_QR_CODE_EMV              VARCHAR2(2400),
    PIX_QR_CODE_URL              VARCHAR2(480) ,
    TAX_AUTHORITY_DOC_NUMBER     VARCHAR2(480) ,
    CITY_TAX_AMOUNT              NUMBER        ,
    STATE_TAX_AMOUNT             NUMBER        ,
    COUNTRY_TAX_AMOUNT           NUMBER        ,
    EXCISE_TAX_AMOUNT            NUMBER        ,
    CONSTRAINT pk_jl_br_ar_bank_returns_all PRIMARY KEY (RETURN_ID, RETURN_ID)
);
