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.
This report is described in business language in the QI Tech Reports Manual — revision 2, July 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. A type outside those lists makes the report fail. |
fund_class_key | only for discounted credit rights | 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 |
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. - 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 | "12.345.678/0001-99" | 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 | "11.222.333/0001-44" | 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 | "22.333.444/0001-55" | 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. |
borrower_document | string | "123.456.789-00" | 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). |
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. |
purchase_date | date | 2026-07-29 | Acquisition date. In this view, it carries the assignment date. |
total_duration | number | 30 | Total term, in days. |
present_duration | number | 30 | Current term, in days. |
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". |
asset_external_id or invoice_number | string | "10a20b30-0001-4bbb-9222-000000000201" | Credit operation: 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 file — in the discounted credit rights one the column is not emitted. |
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. |
borrower_birthdate | Birth date of the borrower (natural person). |
benefit_type | Benefit type of the first collateral of the operation. |
Enabling them is done by QI CTVM in the delivery configuration, per report. If you need any of these columns, tell the integration team which ones you want.