Discounted Credit Rights Conciliation

Overview

The discounted_credit_rights_conciliation_assets report lists all payment events for discounted credit rights (e.g., commercial invoices) recorded on the reference date. Each row represents a payment event, containing the amounts received, the change in asset value, and the accounting result calculated.

File Structure

Attribute	Value
Format	CSV
Encoding	UTF-8
Delimiter	, (comma)
Header	Yes (first line)
Naming	{fund_short_name}_discounted_credit_rights_conciliation_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 asset.
originator_document_number	string	"12.345.678/0001-99"	Originator's CNPJ.
assignor_name	string	"Assignor S.A."	Name of the assignor of the asset.
assignor_document_number	string	"12.345.678/0001-99"	Assignor's CNPJ.
borrower_name	string	"Drawer Ltd."	Name of the drawer (asset debtor).
borrower_document_number	string	"12.345.678/0001-99"	CPF or CNPJ of the drawer.
asset_type	string (enum)	"duplicata_mercantil"	Asset type. Examples: duplicata_mercantil, duplicata_servicos.
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.
total_purchase_value	number	9800.00	Total amount paid by the fund for the acquisition of the asset (in BRL).
maturity_date	date	2024-02-20	Asset maturity date.
payment_date	date	2024-02-20	Accounting date on which the payment was recorded.
face_value	number	10000.00	Face value of the asset (in BRL).
payment_amount	number	10000.00	Total amount received in the payment event (in BRL).
old_asset_current_value	number	9950.00	Book value of the asset immediately before the payment (in BRL).
asset_reduction_value	number	9950.00	Change (reduction) in the asset's book value due to the payment (in BRL).
result_value	number	50.00	Accounting result from the payment event (in BRL).
new_asset_current_value	number	0.00	Book value of the asset immediately after the payment (in BRL).
payment_type	string (enum)	"installment_settlement"	Classification of the payment event type.
purchase_date	date	2024-01-15	Date the fund acquired the asset.
annual_internal_rate_of_return	number	0.15000000	Annual internal rate of return of the asset.
payment_delay	number	0	Difference in days between the maturity date and the payment date. A positive value indicates late payment.
contract_number	string	"NF-2024-00123"	Order number or contract number associated with the asset.