The Data API is a product developed to provide easy access to mass information requests (receipts of payments). The data is delivered in batches by requesting from a single API.

The following categories are liable for data extraction from the Data API:

  • BANKTRANSFEROUT: Data of the transfers performed by our Bank Transfers OUT API;
  • PAYMENTS: Data of payments realized by our Payments API;
  • P2P: Data of transfers performed by our P2P Transfer API;
  • RECHARGES: Data of mobile recharges done by our Recharges API;
  • TRANSPORTCARDS: Data of transport card recharges done by our Transport Cards API;
  • PURCHASES: Data of card purchases and withdrawals. This service is only available in the production (PRD) environment;
  • BANKTRANSFERIN: Data of the cash in transfers performed to payment accounts. Transfers according to the ISO 8583 are not included;
  • CASHIN_ISO8583: Data of the cash in transfers according to the ISO 8583 performed to payment accounts;
  • TEDIN_ALIAS: Data of the cash in transfers performed by Alias Motor;
  • TEDIN_PSTIS: Data of the cash in transfers performed by PSTIS Motor;
  • BILLET: Data of payment slips generated by our Billet API;
  • PAYMENTSLIP: Data of payment slips generated by our Payment Slip API.
  • PIX_TRANSFERS: Data of transfers and reversals performed by our Pix (FaaS) and Pix (BaaS) products.
  • VOUCHER: Data of voucher purchases performed by our Voucher API.
  • TRANSACTIONS: Data from an account statement, shown in the List Accounts Transacoes endpoint.
  • BALANCE: Data of 31 days of accounts balance historic.
  • CARD_DENIED: Data of denied card transactions.
  • CARD_DETAILS: List of cards registered in Dock's database.
  • ACCOUNT_DETAILS: List of accounts registered in Dock's database.
  • RECEIVABLES_CIP: Data of the Cash In transfers performed by Receivables (Alias Account only).
  • BANK_STATEMENT: Data of processed transactions from all accounts. Reflecting data of our /transacoes API.

📘

Data Availability

In order to guarantee the quality, i.e. that data will be correctly extracted, we recommend that the data extraction for the below services should be done after midday 12:00 PM (GMT-3):

  • PURCHASES
  • BALANCE
  • CARD_DENIED
  • ACCOUNT_DETAILS
  • CARD_DETAILS

Getting Started


In order to use our API service, it is required to configure an SFTP server in which the generated file will be available for download.

For such, you can request the creation of the SFTP server credentials by sending both an SSH public key (encrypted in RSA) and an email through the endpoint below. We will associate the public key with the SFTP server and share the SFTP access to your email.

POST Create SFTP Users

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQC+COeV+2RIx7l79iENIF+0OYNzAkt6+AWC3DLMd2c9okE+rahoE4XgCsWw30NgjD4ui2aNVKFzTW4BjZvMV79IEZBYkFsg7vjHHFygOLaHXqJfbbaDYYo4ida6IzbJHdgwhqT6R4KdYJBzosZDzpQ88zY54Ul26/gi48Q6q2ZZFwrrJOfwhwCQZQmjItapVAdU20h05asC5qsK6qRRHv6/+HMxhWuuwHirqGwmOV+Na8IZr9snCONUGqSbunM3iJhiFlOVdaOrtdUeYzu+rgBNCCU7iv9ZTRXcsMWwFladMUakhAL2n4OHWH5O6e/8AFv/mn1jF3XPdLaHYQemvLG4szAQWXv4CBiVEqBs7b71a1zpNsr89EoLdQZtnAyJ7u2nbffF3JnrKH70q3o1kojZJ22vMKEH375JqsjwyxP66NJP0QgG0YM2KRuVovpA1q/L7nVAuZR/1fuvxAU45HVvKdSRbL+koqyykuV2RLMo3i58PRg6TGSkWbA3+tT+Fn8=

Once the credentials are created, the "Information Security" team will send an email with the command to access the SFTP server where the data extraction files will be available for download. The example below presents the command to access the SFTP server, which contains the password (PRIVATEKEY), the user name (issuer_example), and the host (host.example).

sftp -i PRIVATEKEY [email protected]

🚧

Private Key

It is necessary to replace the word PRIVATEKEY with your SSH private key associated with the SSH public key shared.

If desired, the user management can be done through the documentation contained in Caradhras:
Touchless Setup

The files generated by the Data API will be available in the path "apidata" at sFPT server.

Step-by-Step


1) Request a data extraction ticket: After requesting the information, a ticket associated with the request is generated, and the data extraction processes are started. This data will be made available in a .csv file and compressed according to the request (.zip or .gz).
GET Request Data Extraction

📘

Account Receipts

It is possible to use the query string accountId to extract receipts for a specific account.

📘

Data Extraction Interval

It is possible to request data from D-1 (a day before the request), with a maximum range of 31 days (calendar days before the day requested).

2) Check the ticket status: It is necessary to check the ticket status to see when it changes from requested to finished, meaning that the file is available to download via SFTP in the host domain defined by our information security team.
GET Search Data Extraction

3) List tickets: You can list all of the tickets, which have been previously created, filtering by: status, date range and service.
GET Get Tickets

4) Check services status: Here you can check all of the status of the services, filtered by Available for Extraction or Unavailable for Extraction.
GET Get Services

File Nomenclature


The name of the file generated from the data extraction will follow the pattern below:

  • IDISSUER_SERVICE_YYYYMMDD_HHMMSS.csv.zip/gz

Where:

  • IDISSUER is the issuer identification code;
  • SERVICE is the service for which the data extraction was requested;
  • YYYYMMDD_HHMMSS is the timestamp of the file generation;
  • .csv is the data extraction file format;
  • .zip/gz is the compress format selected in the request (.zip or .gz)

Data Structure


All requested data is available in .csv format. The first line of the .csv file is the header and describes the fields related to the service in which the data was requested. The other lines bring the information of one transaction of receipt (the delimiter used to separate fields is comma).

The tables below present the name and description of each field returned by the services available in Data API.

BANKTRANSFEROUT

Field (database)

Description

Field Type

id

Transfer ID.

Integer

idAdjustment

Adjustment identification ID.

Integer

transactionCode

Code of the transaction.

String

idIssuer

Issuer identification code.

Integer

description

Banktransfer description.

String

idOriginAccount

ID of the origin account.

Integer

value

Transfer amount.

Number

typeAccountFavored

Beneficiary type. The types are "fisico" if natural person (NP) or "juridico" if legal person (LP).

String

nameFavored

Beneficiary name.

String

bankFavored

Beneficiary bank ID.

Integer

agencyFavored

Beneficiary agency number.

Integer

digitAgencyFavored

Beneficiary agency digit.

String

accountFavored

Beneficiary account number.

Integer

digitAccountFavored

Beneficiary account digit.

String

cnabFileName

CNAB file name.

String

statusTransfer

Transfer status.

String

tariffCode

Tariff code number.

String

transferenceDate

Date of the transfer.

String

transferSuccess

Is shows if the transfer was successful.

Boolean or NULL

codStatusTransfer

Transfer status code.

String

processDate

Processing date.

String

uid

Unique identification code of the transfer.

String

cpfCnpjFavored

Beneficiary document ("CPF" number or "CNPJ" number).

Integer

PAYMENTS

Field (database)

Description

Field Type

id

Receipt identification code.

Integer

idAccount

Payer account ID.

Integer

idAdjustment

Adjustment identification code.

Integer or NULL

idIssuer

Id from the issuer (10 digits).

Integer

barCodeNumber

Payment slip bar code number, also known as "linha digitável".

String

description

Payment slip description.

String

dueDate

Payment slip due date (ISO 8601 format).

String

fine

Payment slip fine. This value will not add to the “amount” field, which means that it’s simply informative to save the information about fine.

Number

assignor

Payment slip assignor.

String

transactionCode

Code from the payments transaction (it's generated even if the payment didn't happen).

String

transactionDate

Date when the transaction happened (ISO 8601 format).

String

status

Status of the Payment transaction.

String

idPaymentConfirmation

Id generated if the payment is concluded.

String or NULL

assignorDocument

Payment slip assignor document.

String(100)

discount

Payment slip discount. This value will not add to the “amount” field, which means that it’s simply informative to save the information about discount.

Number

interest

Payment slip interest rate (juros e mora).This value will not add to the “amount” field, which means that it’s simply informative to save the information about interest.

Number

amount

Payment slip amount.

Number

P2P

Field (database)

Description

Field Type

id

Receipt id.

Long

transactionCode

Unique identifier of the P2P transfer transaction.

String

originalAccount

The account ID of the Account that is the source of the P2P transfer transaction.

Long

destinationAccount

The account ID of the Account that will receive the P2P transfer transaction amount.

Long

amount

The amount of the transaction that will be transferred from “original_account” to the "destination_account".

BigDecimal

date

Date and time when the transaction happened ("yyyy-MM-ddTHH:mm:ss.sss" format).

String

description

Open field for inserting a description about the P2P transfer transaction.

String

idAdjustment

Adjustment identification code of the operation in the original account.

Long

idIssuer

Issuer identification code.

Long

tpAdjustment

P2P type.

Character

transactionTariffCode

Unique tariff code related to this transaction.

String

idAdjustmentDestination

Adjustment identification code of the operation in the destination account.

Long

RECHARGES

Field (database)

Description

Field Type

id

Recharge identification code.

Integer

accountId

Account identification code.

Integer

ddd

DDD number ("Discagem Direta à Distância" or "Direct Distance Dialing").

String

phoneNumber

Phone number.

String

dealerCode

Identification code of the mobile operator.

String

amount

Amount to recharge.

Integer

amountKey

Key of the specific amount used in the recharge.

Integer

idAdjustment

Identification code for debit transaction occurred.

Integer

orderId

Recharge order identification code.

String

transactionCode

Specific code of every recharge.

String

rechargeDate

Date that the recharge occurred (ISO 8601 format).

String

idIssuer

Identification code of the issuer.

Integer

TRANSPORTCARDS

Field (database)

Description

Field Type

id

Transport card identification code.

Integer

idDablam

SPTrans recharge identification code.

String

accountId

Account identification code.

Integer

idIssuer

Issuer identification code.

Integer

idAdjustment

Adjustment identification code.

Integer

cardNumber

SPTrans card number.

Integer

creditType

Identification code of the credit modality.

Integer

productCode

Identification code of the card's product.

Integer

value

Recharge amount.

Number

amount

Number of recharges executed in the card.

integer

transactionCode

Dock's recharge identification code.

String

date

Recharge date (ISO 8601 format).

String

PURCHASES

Field (database)

Description

Field Type

id

Receipt identification code.

Long

issuer

Issuer name.

String

issuerId

Issuer identification code.

Long

purchaseEventId

Event identification code.

Long

accountId

Account identification code.

Long

cardId

Card code.

Long

authorizationId

Authorization identification number.

String

transactionId

Transaction identification number.

Long

authorizationCode

Authorization identification code.

String

acquiringCode

Acquiring identification code.

String

targetCurrencyCode

Target currency code of the transaction.

String

sourceCurrencyCode

Origin currency code of the transaction.

String

installment

Number of installments.

String

status

Transaction status. The status that can be returned are: "Baixada por prazo", "Cancelada", "Estornada", "Processada".

String

middle

Purchase origin.

String

operation

Operation identification.

String

merchant

Merchant description.

String

brandMerchant

External merchant description.

String

mcc

Merchandise commercial code.

String

purchaseAmount

Total purchase amount.

BigDecimal

sourceAmount

Total purchase amount in origin currency.

BigDecimal

targetAmount

Total purchase amount in the target currency.

BigDecimal

installmentAmount

Amount of each installment.

BigDecimal

firstInstallmentAmount

Amount of first purchase installment.

BigDecimal

contractAmount

Purchase amount with charges. It is always in BRL currency.

BigDecimal

tacAmount

TAC amount.

BigDecimal

iofAmount

IOF amount.

BigDecimal

commissionAmount

Issuer commission amount.

BigDecimal

prossesDate

Processing date (ISO 8601 format).

String

purchaseDate

Purchase date (ISO 8601 format).

String

BANKTRANSFERIN

Field (database)

Description

Field Type

id

Receipt identification code.

Long

adjustId

Adjustment identification code.

String

idAccount

Account identification code.

Long

idIssuer

Issuer identification code.

String

amount

Total transference amount.

Float

processDate

Processing date (ISO 8601 format).

LocalDateTime

CASHIN_ISO8583

Field (database)

Description

Field Type

id

Receipt identification code.

String

idIssuer

Issuer identification code.

Long

idAccount

Account identification code.

Long

amount

Transaction amount. (Always in BRL)

BigDecimal

createDate

Transaction receiving date. (ISO 8601 format)

LocalDateTime

processDate

Processing date. (ISO 8601 format)

LocalDateTime

transactionCode

Transaction identification code.

String

identification

Card number attached to idAccount addressed to cashin.

String

messageCode

ISO 8583 message code.

Allowed values: 0200 - Crédito, 0420 - Desfazimento

String

status

Transaction status. These status can be:

0 - Waiting processing;
1 - Process start;
2 - Success;
3 - Account does not exist;
4 - Card does not exist;
5 - Telephone does not exist;
6 - Queue exceptions;
7 - Another exception (Database);
8 - Another exception (Generic);
9 - Original transaction not found;
10 - Undo has already been done;
11 - Sum of the amount exceeds the daily limit;
12 - Amount greater than the original transaction;
15 - Person does not exist;
16 - Diverging documents.

String

authorizationCode

Authorization identification code.

String

TEDIN_ALIAS

Field (database)

Description

Field Type

id

Receipt identification code.

Long

amount

Total transference amount.

Float

beneficiaryBank

Beneficiary bank identification.

String

beneficiaryBranch

Beneficiary branch identification.

String

consignorBank

Consigor bank identification.

String

consignorBranch

Consignor branch identification.

String

description

Transfer Description.

String

idAccount

Account identification code.

Long

idAdjustmet

Adjustment identification code.

String

idIssuer

Issuer identification code.

Long

protocol

Protocol number.

String

transactionCode

Code of the transaction.

String

transactionDate

Date when the transaction happened (ISO 8601 format).

LocalDateTime

transactionStatus

Transaction status.

String

transactiontype

Transaction type.
Allowed Values: 1 - TEF; 21 - DOC; 31,32 - TED.

String

TEDIN_PSTIS

Field (database)

Description

Field Type

id

Receipt identification code.

Long

idAccount

Account identification code.

Long

idIssuer

Issuer identification code.

Long

idAdjustment

Adjustment identification code.

String

beneficiaryAccount

Beneficiary account.

String

beneficiaryAccountType

Beneficiary account type.

String

beneficiaryBank

Beneficiary bank identification.

String

beneficiaryBankName

Beneficiary bank name.

String

beneficiaryBranch

Beneficiary branch identification.

String

beneficiaryDocument

Beneficiary document number.

String

beneficiaryDocumentType

Beneficiary document type.

String

beneficiaryIspb

Beneficiary ISPB.

String

beneficiaryName

Beneficiary name.

String

amount

Total transference amount.

Float

cashInDate

Beneficiary account cash in date. (ISO 8601 format)

LocalDateTime

consignorAccount

Consignor account number.

String

consignorAccountType

Consignor account type.

String

consignorBank

Consignor bank identification.

String

consignorBankName

Consignor bank name.

String

consignorBranch

Consignor branch identification.

String

consignorDocument

Consignor document number.

String

consignorDocumentType

Consignor document type.

String

consignorIspb

Consignor ISPB.

String

consignorName

Consignor name.

String

description

Transfer Description.

String

transactionCode

Code of the transaction.

String

transactionDate

Date when the transaction happened (ISO 8601 format).

LocalDateTime

BILLET

Field (database)

Description

Field Type

idBilletPier

Receipt identification code.

Long

idIssuer

Issuer identification code.

Long

idAccount

Account identification code.

String

amount

Total purchase amount.

Float

beneficiaryCode

Beneficiary identification code.

String

digitableLine

Billet digitable line.

String

documentNumber

Document number.

String

internalNumber

Internal number.

String

cep

Postal code.

String

payerAddress

Payer address.

String

payerName

Payer name.

String

payerTaxId

Payer tax identification.

String

receivedDate

Received billet date (ISO 8601 format).

String

processingDate

Processing date (ISO 8601 format).

String

paymentDate

Payment date (ISO 8601 format).

String

dueDate

Due date (ISO 8601 format).

String

registeredDate

Billet registration date (ISO 8601 format).

String

status

Billet status.

String

PAYMENTSLIP

Field (database)

Description

Field Type

documentNumber

Document identification number.

String

branch

Favored branch number.

Long

bank

Favored bank number.

Long

payerName

Payer name.

String

payerNeighborhood

Payment neighborhood.

String

payerCity

Payer city.

String

payerCep

Payer postal identification.

String

barCode

Billet bar code identification.

String

amount

Billet amount.

Float

consolidatedAmount

Total amount.

Float

documentDate

Document date (ISO 8601 format).

LocalDateTime

paymentDate

Payment date (ISO 8601 format).

LocalDateTime

discountDate

Discount date (ISO 8601 format).

LocalDateTime

closeDate

Close date (ISO 8601 format).

LocalDateTime

interestDate

Interest date (ISO 8601 format).

LocalDateTime

fineDate

Fine date (ISO 8601 format).

LocalDateTime

dueDate

Due date (ISO 8601 format).

LocalDateTime

deadlineAutomaticCancelation

Number of days to cancel billet automatically.

String

typeAutomaticCancelation

Type of automatic cancelation.

String

beneficiaryDocument

Beneficiary document number.

String

cobeneficiaryDocument

Cobeneficiary docuemnt number.

String

typeTitle

Payment Slip title type.

String

accountId

Account identification code.

Long

issuerId

Issuer identification code.

Long

digitableLine

Billet digitable line.

String

beneficiaryName

Beneficiary name.

String

subbeneficiaryName

Subbeneficiary name.

String

cobeneficiaryName

Cobeneficiary name.

String

paymentMethod

Payment method.

String

type

Payment slip type, which can be "Duplicata Mercantil" or "Duplicata de Serviço" (01 = "Duplicata Mercantil"; 02 = "Duplicata de Serviço").

String

typeContestation

Payment slip type contestation, also known as days left for "Protesto de Título" (01 = Has contestation; 02 = Doesn't have contestation).

String

status

Billet status.

String

billetType

Billet type.

String

subBeneficiayType

Sub Beneficiary type.

String

PIX_TRANSFERS

Field (database)

Description

Field Type

id

Transaction identification code.

Long

accountId

Account identification for the owner of DICT key.

Long

issuerId

Issuer identification code.

Long

adjustmentId

Adjustment identification code.

Long

amount

Transaction amount (always in BRL).

Float

correlationId

PIX transaction unique identifier generated by partner.

String

endToEndId

End-to-end payment identifier associated with the request. Used for rate-limiting.

String

payeeId

Payee identification code.

Long

payerAswer

Open field, partner insert information.

String

payerId

Payer identification code.

String

schedulingDate

PIX send date to SPI. This date will be used for scheduling (a function provided by BACEN in 2021) (ISO 8601 format).

String

transactionCode

Transaction code.

String

transactionDate

Transaction date (ISO 8601 format).

String

transactionStatus

Transaction status (EXECUTED, NOT_EXECUTED, PENDING or REVERSAL_EXECUTED).

String

transactionType

Transaction type (TRANSFER_DEBIT or TRANSFER_CREDIT).

String

transactionUuid

Non-mandatory idempotency key generated by the partner.

String

transferId

Transaction identification code.

Long

txId

Identifier for reconciliation of the recipient in cases of transfer originated by QR Code.

String

returnEndToEndId

End-to-end identifier of the return generated by the API after the confirmation of the return request. If the field is empty, it will be filled out later in the database. This field is returned as null if the transaction is not a reversal.

String

reversalCode

Identifying code of the reason for the return. Not null only for reversals. These codes can be:
0 - Duplicate payment order;
1 - Return due to the amount received not being in accordance with the expected;
2 - Return due to a PSP error;
3 - Return after technical problems, resulting in an incorrect transaction.

String

reversalReason

Open field for a description of the reason for the return. This field is returned as null if the transaction is not a reversal.

String

reversalStatus

Reversal status (REVERSAL_EXECUTED, NOT_EXECUTED or PENDING). This field is returned as null if the transaction is not a reversal.

String

reversalType

Reversal type (REVERSAL_DEBIT or REVERSAL_CREDIT). This field is returned as null if the transaction is not a reversal.

String

tarrifAmount

Pix tariff amount (always in BRL).

Float

type

Payment method used for transaction (0 - Manual; 1 - By key; 2 - static QRcode; 3 - dynamic QRcode).

String

updateDate

Last transaction update.

String

VOUCHER

Field (database)

Description

Field Type

id

Transaction identification code.

Long

idAccount

Account identification code.

Long

idIssuer

Issuer identification code.

Long

idAdjustment

Adjustment identification code.

Long

amount

Transaction amount.

BigDecimal

documentNumber

Individual national registration ID.

String

email

Individual e-mail.

String

description

Message that can be tracked by the user.

String

merchantId

Identification code of specific merchant.

String

orderId

Voucher request order identification code.

String

requestId

Unique identification for requisition tracking.

String

transactionCode

Code for the transaction of voucher requisition.

String

voucherCode

Code provided only after the transaction is completed.

String

transactionStatus

Transaction status (Allowed values: CONFIRMED or PENDING).

String

transactionDate

Transaction date (ISO 8601 format).

LocalDateTime

TRANSACTIONS

Field (database)

Description

Field Type

idTipoTransacaoNaoProcessada

Unprocessed transaction type identification code.

String

descricaoTipoTransacaoNaoProcessada

Unprocessed transaction type description.

String

idEventoAjuste

Identification code of the adjustment event.

String

descricaoAbreviada

Abbreviated description of the transaction.

String

idConta

Account identification code.

String

cartaoMascarado

Masked card number.

String

nomePortador

Card holder full name.

String

dataOrigem

Date the transaction occured (ISO 8601 format).

String

dataFaturamento

Billing date of the transaction (ISO 8601 format).

String

dataVencimentoReal

Expiration date of the invoice (ISO 8601 format).

String

modoEntradaTransacao

Mode used to perform the card dates reading to make the transaction.

String

taxaEmbarque

Amount of the Boarding fee in Real (BRL). Used when the transaction is related to the purchase of airline tickets.

BigDecimal

valorEntrada

Entry amount in Real (BRL). Used when the transaction is installment type with the payment of an entry amount.

BigDecimal

valorBRL

Transaction amount in Real (BRL).

BigDecimal

valorUSD

Transaction amount in american dollars (USD).

BigDecimal

cotacaoUSD

American dollar (USD) amount converted to Real (BRL).

BigDecimal

dataCotacaoUSD

Closing date of the american dollar (USD) quote (ISO 8601 format).

String

codigoMoedaOrigem

Identification Code of the currency used in the transaction (ISO 4217 format).

String

codigoMoedaDestino

Identification Code of the currency used in the transaction after the conversion (ISO 4217 format).

String

codigoAutorizacao

Authorization code of the transaction.

String

codigoReferencia

Reference code of the transaction when it is used a branded card.

String

codigoTerminal

Identification code of the transaction capture source.

String

codigoMCC

Identification code of the establishment category.

String

grupoMCC

Identification code of the establishment group.

String

grupoDescricaoMCC

Establishment group description.

String

idEstabelecimento

Identification code of the establishment.

String

nomeEstabelecimento

Establishment name.

String

nomeFantasiaEstabelecimento

Establishment trade name.

String

localidadeEstabelecimento

Establishment location.

String

plano

When the transaction type is "Installment", show the total number of the installments.

String

parcela

When the transaction type is "Installment", show the installment number.

String

flagCredito

When it is active, indicate that the transaction is the ‘Credit’ type.

String

flagFaturado

When it is active, indicate that the transaction was consolidated in an invoice.

String

idTransacaoEstorno

Identification code of the transaction (id) that generated the reversal.

String

status

Identification code of the transaction status.

String

idTipoAjuste

Identification code of the type of adjustment.

String

valorTAC

TAC amount.

BigDecimal

valorIOF

IOF amount.

BigDecimal

identificadorExterno

External unique identifier of the transaction.

String

descricaoEstabelecimentoExterno

Open field for details about the transaction. This field will always be returned in uppercase. It also removes "-" and replaces blank spaces for "_".

String

idEventoCompra

Identification code of the purchasing event.

String

idEventoPagamento

External unique identifier of the transaction.

String

BALANCE

The Staging Environment (HML) data does not reflect the real account balances in the Staging Environment (HML); it shows a mocked data for validation of the data structure.

Field (database)

Description

Field Type

id

Unique identification code.

String

idIssuer

Issuer identification code.

Long

idAccount

Account identification code.

Long

idLog

Balance log message identification code.

Long

balanceDate

Date of balance requested.

LocalDateTime

lastBalanceChangeDate

Date-time of the last time that the balance changed.

LocalDateTime

balance

Amount in account at the end of the day.

BigDecimal

CARD_DENIED

For this service, the field 'accountId' is not used.

Field (database)

Description

Field Type

id

Unique identification code.

Long

idIssuer

Issuer identification code.

Long

issuerName

Issuer name.

String

idMessage

Unique message identification code.

Long

idCard

Unique card internal identification code.

Long

typeTransactionCode

Type transaction code.

String

processingCode

Processing code.

String

institutionCode

Institution code.

String

zipCode

Brazil postal code.

String

countryCode

Country code.

String

authorizationCode

Authorization code.

String

responseCode

Response code.

String

descriptionCode

Description code.

String

originNumberNsu

Sequential unique number of transaction. (NSU - Número Sequencial Único)

Long

hostNumberNsu

Host sequential number.

Long

numberInstallments

Number of installments.

Long

entryNumber

Transaction entry mode.

String

currencyCode

Origin currency code.

Long

targetCurrencyCodeNumber

Target currency code.

String

transactionIdentificationNumber

Transaction code.

String

uuidTransactionNumber

Unique transaction identification uuid.

String

descriptionTransaction

Transaction description.

String

descriptionTerminal

Terminal description.

String

descriptionOriginTerminal

Origin terminal description.

String

cardDescription

Card description.

String

mccDescription

Merchant description.

String

descriptionEstablishmentCardBrand

Cardbrand establishment description.

String

authenticationOriginDescription

Origin authentication description.

String

answerDescription

Answer description.

String

odin

Odin description.

String

applicationDescription

Reason why a transaction was denied.

String

messageDescription

Return message description.

String

amount

Transaction origin amount.

BigDecimal

destinationAmount

Transaction destination amount.

BigDecimal

messageDate

Message date.

LocalDateTime

flagTransactionWithPassword

Flag indicates that the transaction was made with a password.
Allowed values: False, True

Boolean

flagTransactionWithToken

Flag indicates that the transaction was made with a token.
Allowed values: False, True

Boolean

flagTransaction3ds

3DS transaction flag.
Allowed values: False, True

Boolean

CARD_DETAILS

Field (database)

Description

Field Type

id

Unique identification code.

Long

idCartao

Card identification code.

Long

titular

Indicates if the cardholder is the account holder.
Allowed values: Titular or Dependente

String

idPessoa

Identification code of an individual. An idPessoa=4 indicates that the idCartao doesn’t have an individual assigned.

Long

sequencialCartao

Number equivalent to the card within the sequence of cards associated with the account.

Long

idEmissor

Issuer identification code.

Long

idConta

Account identification code.

Long

idProduto

Product identification code.

Long

cartaoVirtual

Indicates if the card is virtual or not. Allowed values: 0, 1

String

statusCartao

Card status.
Allowed values: "Normal","Cancelado Cliente","Cancelado Tarja","Cancelado Extraviado","Cancelado Perda","Cancelado Desativado","Cancelado Danificado","Cancelado Cartão Pré-Pago","Bloqueado","Bloqueado Senha Incorreta","Cancelado Roubo","Cancelado","Bloqueio Preventivo Falcon","Cancelado Vencido","Suspeita de Fraude - Preventivo","Cancelado Banco","Cancelado Susp.Falso","Bloqueado Prevenção","Cancelado Falec.Titular","Cancelado Definitivo - Fraude","Cancelado Deixado Loja"

String

dataStatusCartao

Date of the last status change (ISO 8601 format).

LocalDateTime

estagioCartao

Card stage.
Allowed values: "Desbloqueado sem Codigo", "Encaminhado", "Criado","Recolhido","Embossing - Inconsistente", "Embossing - Prévia","Enviado para Embossing","Desbloqueado com Codigo","Embossing - Inconsistência Liberada","Recebido","Revisado"

String

dataEstagioCartao

Date of the last stage change (ISO 8601 format).

LocalDateTime

numeroBin

BIN (Bank Identification Number) number. It is the first 6 numbers of a card.

Long

numeroCartaoHash

Hashed card number.

String

dataEmissao

Show the date when the card was created (ISO 8601 format).

LocalDateTime

dataValidade

Date of expiration of a given record or card (ISO 8601 format).

LocalDateTime

dataImpressao

Date of the card printing.

LocalDateTime

nomeArquivoImpressao

Printing card file name.

String

nomeImpresso

Cardholder name printed on the card.

String

ACCOUNT_DETAILS

Field (database)

Description

Field Type

id

Unique identification code.

Long

idEmissor

Issuer identification code.

Long

idConta

Account identification code.

Long

idProduto

Product identification code.

Long

idOrigemComercial

Indicates the origin of the partner / client registration. This number should be informed by the project leader.

Long

idPessoa

Account holder identification code.

Long

statusConta

Account status.
Allowed values: "Normal","Cancelada","Saldo a Recuperar - Pré Pago","Bloqueada Cadastro Incorreto","Bloqueado Prevenção","Cancelada Cliente","Bloqueada","Cancelamento Manual","Conta não ativada", "Liberado", "Creliq", "Perda"

String

valorRenda

Proven income amount.

BigDecimal

dataCadastro

Register date.

LocalDateTime

RECEIVABLES_CIP

Field (database)

Description

Field Type

id

Receipt identification code

Long

idAccount

Account identification code

Long

idIssuer

Issuer identification code

Long

amount

Transaction amount (always in BRL)

BigDecimal

idAdjustment

Adjustment identification code

String

transactionCode

Transaction identification code

String

transactionDate

Date when the transaction happened (ISO 8601 format)

LocalDateTime

settlementNumber

Identification number in CIP environment

String

consignorIspb

Consignor ISPB identification

String

consignorCipBranch

Consignor branch identification

String

consignorCipAccount

Consignor account identification

String

consignorCipName

Consignor identification (acquirer)

String

idCipStatus

Status code as follows:
00 - Credit done
01 - Scheduled credit done
02 - Canceled Receivable
04 - Blocked alias account (the amount is returned to the origin).
98 - Alias Account not available
99 - Transaction denied due to risk analysis

String

methodDescription

CIP description related to the transaction

String

methodCode

CIP code related to the transaction

String

BANK_STATEMENT

The account filter does not apply to this service.
To extract this service, it is required one (1) full day.

Field (database)

Description

Value

idTransacao

Processed transaction identification code.

String

idEventoAjuste

Identification code of the adjustment event.

String

descricaoAbreviada

Abbreviated description of the transaction.

String

idConta

Account identification code.

String

cartaoMascarado

Masked card number.

String

nomePortador

Card holder full name.

String

dataProcessamento

Date the transaction was processed (ISO 8601 format).

String

dataOrigem

Date the transaction occurred (ISO 8601 format).

String

dataFaturamento

Billing date of the transaction (ISO 8601 format).

String

dataVencimentoReal

Expiration date of the invoice (ISO 8601 format).

String

modoEntradaTransacao

Mode used to perform the card dates reading to make the transaction.

String

taxaEmbarque

Amount of the Boarding fee in Real (BRL). Used when the transaction is related to the purchase of airline tickets.

BigDecimal

valorEntrada

Entry amount in Real (BRL). Used when the transaction is installment type with the payment of an entry amount.

BigDecimal

valorBRL

Transaction amount in Real (BRL).

BigDecimal

valorUSD

Transaction amount in american dollars (USD).

BigDecimal

cotacaoUSD

American dollar (USD) amount converted to Real (BRL).

BigDecimal

dataCotacaoUSD

Closing date of the american dollar (USD) quote (ISO 8601 format).

String

codigoMoedaOrigem

Identification Code of the currency used in the transaction (ISO 4217 format).

String

codigoMoedaDestino

Identification Code of the currency used in the transaction after the conversion (ISO 4217 format).

String

codigoAutorizacao

Authorization code of the transaction.

String

codigoReferencia

Reference code of the transaction when it is used a branded card.

String

codigoTerminal

Identification code of the transaction capture source.

String

codigoMCC

Identification code of the establishment category.

String

grupoMCC

Identification code of the establishment group.

String

grupoDescricaoMCC

Establishment group description.

String

idEstabelecimento

Identification code of the establishment.

String

nomeEstabelecimento

Establishment name.

String

nomeFantasiaEstabelecimento

Establishment trade name.

String

localidadeEstabelecimento

Establishment location.

String

plano

When the transaction type is "Installment", show the total number of the installments.

String

parcela

When the transaction type is "Installment", show the installment number.

String

flagCredito

When it is active, indicate that the transaction is the ‘Credit’ type.

String

flagFaturado

When it is active, indicate that the transaction was consolidated in an invoice.

String

idTransacaoEstorno

Identification code of the transaction (id) that generated the reversal.

String

status

Identification code of the transaction status.

String

idTipoAjuste

Identification code of the type of adjustment.

String

valorTAC

TAC amount.

BigDecimal

valorIOF

IOF amount.

BigDecimal

identificadorExterno

External unique identifier of the transaction.

String

descricaoEstabelecimentoExterno

Open field for details about the transaction. This field will always be returned in uppercase. It also removes "-" and replaces blank spaces for "_".

String

idEventoCompra

Identification code of the purchasing event.

String

idEventoPagamento

External unique identifier of the transaction.

String


Did this page help you?