Assignment Assets Composition
Overview
The assignment_assets_wallet_composition report details the assets of one specific assignment, in the same format as the Assets Portfolio Composition report. It is the report used to check what entered the portfolio right after an acquisition, before the asset starts making up the daily positions.
- credit operations — one line per installment;
- discounted credit rights — one line per asset;
- contracts — one line per installment.
Also in PDF
This report is described in business language in the QI Tech Reports Manual — revision 3, October 2026. The manual is written in Portuguese and covers four reports: this one, the Assets Portfolio Composition, the Consolidated Acquisition and the Consolidated Credit Rights Reconciliation.
In that section of the manual the column names appear in uppercase. In the delivered file they always come in lowercase, as shown in the columns table below.
What you need to provide
| Variable | Required | Description |
|---|---|---|
external_id | always | Your own reference number for the assignment to be queried. |
asset_type | always | Defines which query is executed. Credit operations: ccb, structured_ccb, cce, structured_cce, structured_cci, structured_nce. Discounted credit rights: duplicata_mercantil, duplicata_servicos, discounted_contract, legal_fees, cte, check, promissory_note. Contracts: contract, financing_contract, debt_acknowledgment. A type outside those lists makes the report fail. |
fund_class_key | only for discounted credit rights and contracts | Fund class the report is generated for. For credit operations the filter is done only by the assignment, and the fund provided is ignored. |
File Structure
| Attribute | Value |
|---|---|
| Format | CSV |
| Encoding | UTF-8 |
| Delimiter | , (comma) |
| Header | Yes (first line) |
| Naming | {short_fund_name}_assignment_assets_wallet_composition_{YYYY-MM-DD}_{external_id}.csv |
The file name ends with the assignment identifier
Unlike the daily reports, this one appends the assignment's external_id to the end of the name. Since the external_id is required, the suffix is always present.
What the report carries
- All the assets of the provided assignment, except the discarded (
discarded) and the denied (denied) ones. For contracts, contracts with statusfailedorcanceledare left out. - The last columns vary according to the asset type — see
asset_external_id/invoice_numberandmonthly_ratein the table below. - Fields without a value come empty in the file.
Columns
| Column | Type | Format / Example | Description |
|---|---|---|---|
fund_name | string | "FUNDO EXEMPLO FIDC RESPONSABILIDADE LIMITADA" | Name of the fund class. |
fund_document | string | "11.222.333/0001-81" | CNPJ of the fund class. |
fund_date | date | 2026-07-29 | Current accounting date of the fund. |
originator_name | string | "ORIGINADOR EXEMPLO S.A." | Name of the originator. |
originator_document | string | "22.222.222/0001-91" | CNPJ of the originator. |
name | string | "CEDENTE EXEMPLO S.A." | Name of the assignor. Beware of the generic header: despite being called name, the content is the assignor, not the fund nor the borrower. |
document_number | string | "33.333.333/0001-91" | CNPJ of the assignor. Same remark as the previous column. |
borrower_name | string | "MARIA APARECIDA DE SOUZA" | Name of the borrower or of the drawee. Empty for contracts. |
borrower_document | string | "969.698.790-03" | CPF or CNPJ of the borrower/drawee. |
external_id | string | "10a20b30-0001-4bbb-9222-000000000201-1" | External identifier of the installment (credit operation) or of the asset (discounted credit right and contract). |
contract_number | string | "0900112233/EXA" | Contract or order number. |
asset_type | string (enum) | "ccb" | Asset type. |
face_value | number | 1678.90 | Face/nominal value (in reais). |
present_value | number | 1598.74210000 | Present value. In this view, equal to the purchase value. |
purchase_value | number | 1598.74210000 | Acquisition value (in reais). |
bad_provision_value | number | 0 | Allowance for doubtful accounts. Fixed at 0 in this view. |
bad_provision_range | string | "AA" | PDD range. Fixed at AA (the best range) in this view. |
report_date | date | 2026-07-30 | Report generation date. |
maturity_date | date | 2026-08-28 | Maturity of the installment or of the asset. |
business_maturity_date | date | 2026-08-28 | Adjusted maturity. In this view, it repeats the maturity_date. |
issue_date | date | 2026-07-29 | Issue date. In this view, it carries the assignment date (for contracts, the assignment's acquisition date). |
purchase_date | date | 2026-07-29 | Acquisition date. In this view, it carries the assignment date (for contracts, the assignment's acquisition date). |
total_duration | number | 30 | Total term, in days. |
present_duration | number | 30 | In this view, it repeats total_duration. |
asset_maturity_status | string (enum) | "on_time" | OVERDUE when the assignment date is later than the maturity; on_time in the other cases. |
assignment_irr | number | 0.0312 | Assignment rate. |
purchase_irr | number | 0.03187421 | Purchase rate of the receivable. |
has_assignor_coobligation | string | "False" | Assignor's co-obligation, as the text "True" or "False". For credit operations and discounted credit rights, it comes from the assignment configuration; for contracts, from the contract registration. |
asset_external_id or invoice_number | string | "10a20b30-0001-4bbb-9222-000000000201" | Credit operation and contract: external identifier of the asset (asset_external_id). Discounted credit right: access key of the NF-e (invoice_number). |
monthly_rate | string | "0.0231" | Pre-fixed monthly rate. It only exists in the credit operations and contracts files — in the discounted credit rights one the column is not emitted. |
installment_number | string | "1" | Installment number. It only exists in the contracts file, always as the last column. |
Optional columns
They can be requested when the report is generated and are appended at the end of the file, in this order. They apply only to credit operations.
| Column | Description |
|---|---|
installment_number | Installment number. |
disbursement_value | Value disbursed in the contract. |
cet | Total Effective Cost (CET) of the contract. |
issue_value | Issue value of the contract. |
interest_rate_type | Type of the interest rate of the operation. |
disbursement_target_document_number | CPF or CNPJ of the disbursement recipient. |
disbursement_date | Disbursement date. |
borrower_birthdate | Birth date of the borrower (natural person). |
benefit_type | Benefit type of the first collateral of the operation. Enabled by the benefit_number option. |
How to request the optional columns
Enabling them is done by QI DTVM in the delivery configuration, per report. If you need any of these columns, tell the integration team which ones you want.