Table 19 - Financial securities
- This article presents the fields of the financial securities integration layout. To better understand the concept behind bonds, see our article on Financial Security Concept.
| Order | Field Description | Format and Size | Required | Version | Remarks |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=19 (2) | Yes | 1.4 | |
| 2 | Title Code (code) | Text (30) | Yes | 1.4 | For the title to be imported/updated, it is also necessary to fill in the “Parcel Number”. |
| 3 | Parcel Number (numParcela) | Text (20) | No | 1.4 | |
| 4 | Customer’s CPF or CNPJ (cpfCNPJCliente) | Text (20) | Yes | 1.4 | With mask |
| 5 | Date and Time of Issuance (dataEmissao) | DateTime | Yes | 1.4 | |
| 6 | Expiration Date (dataVencimento) | DateTime | Yes | 1.4 | |
| 7 | Title Type (tipoTitulo) | Text (50) | Yes | 1.4 | Ex. Boleto, Cheque, Carnê.. |
| 8 | Title Value (value) | Decimal | Yes | 1.4 | |
| 9 | Title Paid (paid off) | Integer (1) | Yes | 1.4 | 0 – Open 1- Paid off |
| 10 | Active (active) | Integer (1) | No | 1.4 | 0 – Inactive (Deleted) 1 – Asset |
| 11 | Accumulated value of Fines and Interest (valorMultaJuros) | Decimal | No | 2.10 | Some partners resend expired titles every day with the Value of Fines and Interest updated. |
| 12 | Customer Code (codCliente) | Integer (10) | No | 2.20 | |
| 13 | Last date update (dataUltimaAtualizacao) | TimeDate | No | 3.70 | This field is used by the Collections Registration module. All receipts registered after this time change the Customer’s available Credit Limit, while older entries are disregarded (we consider that the amount has already been deducted from the title). |
| 14 | Document number (numDocumento) | Text (50) | No | 3.70 | Can be used to send the Document Number that generated the title. EX: NF-e 1024 / Order 102345 |
| 15 | Payment date | Date | No | 4.14 | Title payment date. Attention: Only fill in this field if the title is paid off. |
| 16 | Amount of commission | Decimal | No | 4.14 | Amount of commission that the seller will receive. This field only needs to be entered if you have commission control based on the payment of financial securities, in this case we also recommend filling in the “Payment date” field. |
| 17 | Branch/Unit | Text (15) | No | 4.56 | Determines the code of the Branch to be which this title is linked to. |
| 18 | Seller Code (codVendedor) | Integer (10) | No | 5.14 | Optional field. If not informed:all sellers who serve the customer view the financial title. If informed: Only the salesperson and their managers view this title, that is, it will not appear to other salespeople who serve the same customer. |
Registration Example:
19|5349|1|10.449.962/0001-86|2020-01-02|2020-02-01|Duplicate|5792.00|0|1|0.00|4441|2020-02-28 14:30:00| NF-e 1024 / Order 102345 |