Credit Rights Acquisition
This report documents credit operations (credit rights) acquired by the fund on a given date. It consists of two complementary files:
- Assets (
credit_rights_acquisition_assets) — consolidated view per credit operation, with total acquisition values and general asset characteristics. - Installments (
credit_rights_acquisition_installments) — breakdown of each individual installment of the operations acquired on the date, with values and maturity dates per installment.
Both files share the same reference date. To reconstruct the relationship between the two files, use the external_id field as the join key.
Assets (credit_rights_acquisition_assets)
Overview
The credit_rights_acquisition_assets file lists all credit operations acquired by the fund on the given reference date. Each row represents an operation (asset), with information about the parties involved, acquisition values, default provisions, and contractual characteristics.
File Structure
| Attribute | Value |
|---|---|
| Format | CSV |
| Encoding | UTF-8 |
| Delimiter | , (comma) |
| Header | Yes (first line) |
| Naming | {fund_short_name}_credit_rights_acquisition_assets_{YYYY-MM-DD}.csv |
Columns
| Column | Type | Format / Example | Description |
|---|---|---|---|
reference_date | date | 2024-01-15 | Report reference date. |
fund_class_name | string | "Example Fund FIC" | Fund class name. |
fund_class_document_number | string | "12.345.678/0001-99" | Fund class CNPJ. |
originator_name | string | "Originator S.A." | Name of the company that originated the operation. |
originator_document_number | string | "12.345.678/0001-99" | Originator's CNPJ. |
assignor_name | string | "Assignor S.A." | Name of the assignor of the operation. |
assignor_document_number | string | "12.345.678/0001-99" | Assignor's CNPJ. |
borrower_name | string | "Borrower Ltd." | Name of the debtor (credit borrower). |
borrower_document_number | string | "123.456.789-00" | CPF or CNPJ of the debtor. |
asset_type | string (enum) | "ccb" | Asset type. Examples: ccb. |
has_assignor_coobligation | boolean | true | Indicates whether the assignor has co-obligation on the operation. |
asset_key | string | "a1b2c3d4-e5f6-7890-abcd-ef1234567890" | Internal asset key generated by QI Tech (UUID). |
contract_number | string | "CCB-2024-001" | Contract number of the credit operation. |
external_id | string | "931e9437-d025-41ab-bb53-6b94e10fd361" | External identifier of the asset. |
index | string | "pre_fixed" | Interest rate indexer type. |
index_calendar_base | string | "252" | Calendar base used for indexer calculation (in business days). |
spread | number | 0.01500000 | Pre-fixed monthly rate of the operation. |
spread_calendar_base | string | "30" | Calendar base for spread calculation (in calendar days). |
issue_date | date | 2024-01-10 | Contract issue date. |
purchase_date | date | 2024-01-15 | Date the fund acquired the operation. |
maturity_date | date | 2025-06-30 | Final maturity date of the operation. |
total_purchase_value | number | 10000.00 | Total amount paid by the fund for the acquisition (principal + premium). |
original_principal_value | number | 9800.00 | Principal value of the credit operation at the time of issuance. |
original_premium | number | 200.00 | Premium paid on acquisition, calculated as total_purchase_value - asset_purchase_value. |
original_discount | number | 0 | Discount applied at acquisition. |
present_value | number | 10050.12 | Current value of the operation on the acquisition date. |
bad_debt_provision_value | number | 0.00 | Provision for doubtful debtors (PDD) on the operation (in BRL). |
bad_debt_provision_range | string (enum) | "AA" | PDD risk range. Possible values: AA, A, B, C, D, E, F, G, H. |
iof_value | number | 12.50 | IOF (financial transaction tax) amount on the operation (in BRL). |
Installments (credit_rights_acquisition_installments)
Overview
The credit_rights_acquisition_installments file details each installment of the credit operations acquired on the reference date. Each row represents an individual installment of an operation, allowing analysis of the future payment flow by maturity date and amount.
File Structure
| Attribute | Value |
|---|---|
| Format | CSV |
| Encoding | UTF-8 |
| Delimiter | , (comma) |
| Header | Yes (first line) |
| Naming | {fund_short_name}_credit_rights_acquisition_installments_{YYYY-MM-DD}.csv |
Columns
| Column | Type | Format / Example | Description |
|---|---|---|---|
reference_date | date | 2024-01-15 | Report reference date. |
fund_class_name | string | "Example Fund FIC" | Fund class name. |
fund_class_document_number | string | "12.345.678/0001-99" | Fund class CNPJ. |
originator_name | string | "Originator S.A." | Name of the company that originated the operation. |
originator_document_number | string | "12.345.678/0001-99" | Originator's CNPJ. |
assignor_name | string | "Assignor S.A." | Name of the assignor of the operation. |
assignor_document_number | string | "12.345.678/0001-99" | Assignor's CNPJ. |
borrower_name | string | "Borrower Ltd." | Name of the debtor (credit borrower). |
borrower_document_number | string | "123.456.789-00" | CPF or CNPJ of the debtor. |
asset_type | string (enum) | "ccb" | Asset type. Examples: ccb. |
asset_key | string | "a1b2c3d4-e5f6-7890-abcd-ef1234567890" | Internal asset key generated by QI Tech (UUID). |
external_id | string | "931e9437-d025-41ab-bb53-6b94e10fd361" | External identifier of the asset. |
contract_number | string | "CCB-2024-001" | Contract number of the credit operation. |
installment_number | number | 2 | Sequential installment number within the operation. |
maturity_date | date | 2024-03-15 | Maturity date of this installment. |
face_value | number | 1050.00 | Face value of this installment (principal + interest). |
purchase_date | date | 2024-01-15 | Date the fund acquired the operation. |
installment_purchase_value | number | 1000.00 | Amount paid by the fund for this specific installment. |
principal_value | number | 980.00 | Principal portion contained in this installment. |
spread | number | 0.01500000 | Pre-fixed monthly rate of the operation. |
iof_value | number | 12.50 | IOF (financial transaction tax) amount on the operation (in BRL). |