Host to Host
Do you manage a business with a high number of transactions and a large number of stores, which require centralized management of internal accounts? Transbank has a good alternative for these requirements. Host to Host, a solution that involves development in the application of your store's cash registers to integrate it with the equipment provided by Transbank, connecting via a dedicated link to our servers, which will provide robustness and great speed to the payment process and information flow. .
How does it work
Host to Host requires a high level of integration, which consists of the following stages:
Development Your business must carry out the development according to the specifications that Transbank will give you.
Quality Control This process will verify that the integration development that you did complies with what we give you in the specifications, or if it requires any correction or improvement.
Pilot stage In a place that we agree on together, we take your pinpad host point of sale to production, where with real clients we will jointly monitor its operation, for a limited period of 2 weeks. We evaluate the results, and agree on massification, also if any adjustment is required.
Overcrowding We jointly build an installation plan for the points of sale.
Sales Flow on Pinpad Host:
- The customer delivers the products or service he wants to buy to the seller.
- The seller makes the sale in his box system.
- The seller asks the customer how he wants to pay, cash, credit card, debit card and selects it at the checkout.
- The box invokes the pinpad, passing it the amount of the sale and the credit or debit payment method
- The client operates a card, selects installments if applicable, and enters his pin
- The pinpad assembles the sales request message and delivers it to the till.
- The box takes the message and delivers it to the merchant host and this in turn to the Transbank host (hence its name from host to host)
- The response message travels the reverse path until it reaches the pinpad
- The pinpad verifies the approved or rejected response and integrity of the message and returns the result to the box.
- The box prints the sales receipts.
Equipment and connections available
Verifone vx805
Fixed Computer USB or Serial Pinpad host
Driver
These devices work with both RS232 and USB serial ports (usually plug and play), for which you may need to install a verifone driver .
This driver is compatible with the following operating systems, reported by Verifone:
- Windows 10 32/64-bit
- Windows 8/8.1 32/64-bit
- Windows 7 32/64-bit
Per PCI regulations, merchants must not use an operating system that is obsolete. It is also very important to keep your Operating System with the latest patches installed, this is mainly due to a security issue.
Verifone vx680
Mobile equipment wifi Pinpad host
Verifone e355
Mobile Device Bluetooth Pinpad host
Payment features available in HOST
- Sale Credit, with or without fees, tip or donation
- Cancellation of sale Credit.
- Sale Debit, debit with change, tip or donation
- Sales in UNOS mode (business cards)
How to start
Next, you will see the documentation associated with how to print the vouchers. You can review the Reference to see information associated with communication and commands.
Voucher
The pinpad will deliver the voucher ready to print, but it will also deliver all the data necessary for the box itself to build the voucher itself. If it is required to obtain the duplicate voucher, the box must build the voucher, without the PEL data and adding the duplicate gloss.
Considerations
Type of transactions
These are the glosses that should be displayed in the header of the voucher:
Card Type | Transaction Type |
---|---|
CR | SALE CREDIT |
CR | CANCELLATION CREDIT |
DB | DEBIT SALE |
NB | NON-BANKING SALE |
NB | NON-BANKING CANCELLATION |
DB | PREPAID SALE |
CR | BOOKING |
CR | RESERVATION CANCELLATION |
CR | NO SHOW |
CR | NO SHOW CANCELLATION |
CR | CHECK-IN |
CR | CHECK-IN CANCELLATION |
CR | REAUTHORIZATION |
CR | REAUTHORIZATION CANCELLATION |
CR | CHECK OUT |
CR | CHECK-OUT CANCELLATION |
CR | DELAYED CHARGE |
CR | CANCELLATION DELAYED CHARGE |
DB | CASH WITHDRAWAL DEBIT |
CR | CASH CREDIT ADVANCE |
CR | CANCELLATION CASH ADVANCE CREDIT |
Card types
Consider that the cards issued by commercial houses under a brand such as VISA or Master are considered bank cards and not non-bank cards. Prepaid cards will be considered debit cards.
Code | Gloss |
---|---|
CR | CREDIT |
DB | DEBIT |
NB | NON-BANKING |
PR | PREPAID |
Card Brands
Name | Abbreviation |
---|---|
VISA | VI |
MASTERCARD | MC |
AMEX | AX |
DINERS | DC |
DISCOVER | DC |
MAGNA | MG |
PRESTO | TP |
MAS | TM |
RIPLEY | TR |
RIPLEY | RP |
CMR | TC |
DEBIT | DB |
ELECTRON | EL |
MAESTRO | MT |
PREPAID | PR |
Print order
The idea of this voucher is that it is the only way out for any type of Transbank voucher, since it is a unique voucher, regardless of the type of transaction, the same validations are always made, to see if each field is printed or not, whether it is a voucher of credit, debit or credit cancellation.
Two copies of the voucher must always be printed, one for the merchant and one for the client. In the case of voucher with signature, if the merchant wishes, it may not print on the merchant's copy, the signature lines, customer name and rut, in the merchant's voucher it must be signed if applicable.
The print order should be:
- TBK Award Voucher
- TBK Customer Voucher
- TBK Trade Voucher
Any variation to the order or format of the voucher must be authorized by Transbank
Other considerations
Some considerations in printing Transbank vouchers
- The vouchers must contain exclusively the information requested in this manual. Any exception must be authorized and formalized by Transbank.
- Customer name can be printed only on voucher with signature
- Return lines should not be printed if they are not being used.
- Donation or tip lines should not be printed if they are not being used.
- Award vouchers should NOT be printed on self-copying paper . In the event that the client only has printers that use carbonless paper, Transbank must be notified of this situation, and it is the latter who must authorize the acceptance of this type of printing, and the functionality of online promotions may be excluded .
- Only one copy of a prize voucher should be generated, in the face of any border condition if the voucher could not be printed, the prize is lost, the duplicate should not contain anything in this regard.
- It is NOT possible to reprint the prize voucher or make mention of the prize on the Transbank vouchers in case of printing a duplicate.
- The prize code and the glosses are delivered by the PINPAD after validating the response to the request.
- The voucher printing MUST be done automatically, when the transaction is approved, not optional or manual. Should not rely on a boxed enter to release the print
- For cases in which the cardholder's signature is necessary, the print MUST provide adequate space for said operation.
- The start of a new transaction MUST be done ONLY at the time the printing of the voucher of the previous transaction is finished, NEVER during its printing or reprinting, since the transaction is considered completed at the time of printing the voucher or its reprinting.
- The separation between the vouchers (transactions (original/copy), award) can be physical (cut) or delimited by dotted lines.
- The last thing to be printed is the Transbank voucher
- The voucher in fiscal printer goes between the glosses. “COMMENT START” and “COMMENT END”. Given the number of lines that can be printed on this type of printer, the elimination of blank lines is allowed so that the voucher can be printed correctly. Each voucher could be separated by a beginning and end of comment, this is the customer's voucher and the merchant's voucher.
Voucher of sale or cancellations
Voucher Pel and reprint
It is only allowed to print the original voucher and the PEL voucher once, if there is any problem with the printing of the original voucher, the printing must be aborted and a duplicate can be obtained.
Original:
- PEL Voucher
- Voucher 1 store/customer
- Voucher 2 trade/customer
Duplicates:
- Voucher 1 business/customer “duplicate without gloss pel”
- Voucher 2 merchant/customer “duplicate without gloss pel”
Voucher pel 1 - Online award
This voucher should be printed only if: COMMAND H505 VOUCHER TYPE FIELD = Point of Sale Delivery
Voucher pel 2 - Online award
This voucher must be printed only if: COMMAND H505 FIELD TYPE OF VOUCHER = |2| Deferred Delivery
Voucher pel 3 - Online award
This voucher should be printed only if: COMMAND H505 VOUCHER TYPE FIELD = |3| Refund to Cardholder
ONUS Annexed
Goals
This documentation describes the way of operating, the functionality and the details of the messaging of a TRANSBANK PINPAD working under the OnUs mode.
The application of the PINPAD supposes the existence of an intelligent ECR (for example a cash register) that will send the requirements to the PINPAD, so that it can process them and deliver the results when appropriate.
Audience
To fully understand this documentation, it is necessary to have transactional knowledge and to know the functions commonly implemented in PINPADs used in banking transactions.
In particular, this manual is aimed exclusively at UNOS businesses that have their own cards and use the Transabank pinpad to read their cards, but carry out and authorize the transactions themselves.
Scope
Applies to Verifone vx805 equipment (Serial or USB connection)
Applies to Verifone e355 equipment (Bluetooth connection)
You can review the Reference to see information associated with communication and commands.
Technical specifications and special outputs
Quadrature and liquidation
This section describes the scheduling and settlement files that are delivered to the customer who uses the Special Departures service. The quadrature files (reconciliation) are flat files that contain the records of the transactions (sales and cancellation) carried out in a business within a given period. The settlement files are flat files that contain the records of the credits and withholdings made on the merchant's account within a given period.
Distribution
The scheduling and settlement files are periodically placed in an SFTP box created exclusively for the respective business, so that it can download them to its own system. The following table indicates the frequency and schedule for placing scheduling and liquidation files in the box:
File, Archive | Period covered | box placement | File Copy Schedule |
---|---|---|---|
Quadrature | 00ºº hrs day – 00ºº hrs next day | Every day | 12:00 Tuesday 14:00 |
Settlement | 00ºº hrs day – 00ºº hrs next day | business day | 12:00 Tuesday 14:00 |
Access to the box
Merchants must use an SFTP client type application available on the market to access the mailbox, some of these may be Filezilla, WinSCP, PuTTY, MobaxTerm
The name of the files of the Special Outputs (SSEE) will be generated dynamically from the data entered in the enrollment plus the process date
<Formato de Salida>_<Periodo>_<Agrupación Archivo de Salidas>_<RutComercio ó CódigoComercio>_<Tipo Conexion>_<Agrupación de Transacciones>_<Número Agrupación>
Output format
- LDN: Debit Settlement
- LCN: Credit Settlement
- CDN: Debit Quadrature
- CCN: Credit Quadrature
Period
- Daily: A daily file is generated based on the process date
- Monthly: One file is generated per month. Date associated with the penultimate business day of the month
Output File Grouping
- RE: File with unique information associated with the enrolled RUT (Generates a file)
- CC: File with information separated by merchant code of the transaction (generates a different file for each merchant code)
Connection Type
- A single file is generated. File information is not separated by connection type (when it is a single file it is not part of the name)
- When a file is generated for face-to-face and non-face-to-face connection type transactions or NP: Non-face-to-face or PR: Face-to-face
Transaction grouping
- When it is grouped by RUT it is not included in the file name
- RB: Item
Grouping Number
- It will correspond to the number of the enrolled Item.
Credit quadrature file (L3)
The structure of the records of the credit scheduling files is described in detail below. Each file has a header record ("header"), then a record for each transaction carried out in the period covered and at the end a footer record ("footer"). The credit quadrature file contains the detailed record of the financial transactions carried out with a credit card. Contains both face-to-face and non-face-to-face transactions.
Header
Name | Description | Format | Length | Total |
---|---|---|---|---|
Dktt-Hr-Reg | "HR" | Alphanumeric | 2 | 2 |
Dktt-Hr-Fech-Proc | Date of process Format "YYMMDD" The day on which the file is processed is the business day immediately following the period covered. |
Numeric | 6 | 8 |
Dktt-Hr-Hora-Proc | Process Time Format "HHMMSS" | Numeric | 6 | 14 |
Dktt-Hr-Glosa | Merchant Name Trade Fancy Name |
Alphanumeric | 25 | 39 |
Filler | Available | Alphanumeric | 282 | 321 |
Footer
Name | Description | Format | Length | Total |
---|---|---|---|---|
Dktt-Tr-Reg | Valor fijo "TR" | Alphanumeric | 2 | 2 |
Dktt-Tr-Fech-Proc | Process Date Format "YYMMDD" | Numeric | 6 | 8 |
Dktt-Tr-Hora-Proc | Process Time Format "HHMMSS" | Numeric | 6 | 14 |
Dktt-Tr-Cant-Reg | Total records | Numeric | 7 | 21 |
Dktt-Tr-Acum-Monto | Total. 11 integers 2 decimals | Numeric | 13 | 34 |
Dktt-Tr-Fech-Desde | Minor date of Txs "YYMMDD" format. Among the transactions recorded in the file, it indicates the date on which the earliest was carried out. |
Numeric | 6 | 40 |
Dktt-Tr-Hora-Desde | Txs Minor Hour "HHMMSS" format. Among the transactions recorded in the file, it indicates the time at which the earliest was carried out. |
Numeric | 6 | 46 |
Dktt-Tr-Fech-Hasta | Major date of Txs. "YYMMDD" format. Among the transactions recorded in the file, it indicates the date on which the latest was carried out. |
Numeric | 6 | 52 |
Dktt-Tr-Hora-Hasta | Senior Hour of Txs. "HHMMSS" format. Among the transactions recorded in the file, it indicates the time at which the latest was carried out. |
Numeric | 6 | 58 |
Filler | Available | Alphanumeric | 263 | 321 |
Detail The following table describes each of its fields:
Name | Description | Format | Length | Total |
---|---|---|---|---|
DSK-DT-REG | Record Type Fixed value “DT” | Alphanumeric | 2 | 2 |
DSK-TYP | Transaction Type 0210 : online sale 0420 : reverse | Numeric | 4 | 6 |
DSK-TC | Transaction Code4 "10" : Purchase "18" : Purchase with change "30" : Withholding | Numeric | 2 | 8 |
DSK-TRAN-DAT | Transaction Date “YYMMDD” format. Corresponds to the date on which Transbank issued a response to the transaction |
Numeric | 6 | 14 |
DSK-TRAN-TIM | Transaction Time “HHMMSS” format. Corresponds to the time in which Transbank issued a response to the transaction |
Numeric | 6 | 20 |
DSK-ID-RETAILER | Provider Commerce Code | Numeric | 12 | 32 |
DSK-NAME-RETAILER | Merchant Name business fancy name |
Alphanumeric | 20 | 52 |
DSK-CARD | Card number Only the last 4 digits appear, the rest are masked with * |
Alphanumeric | 19 | 71 |
DSK-AMT-1 | Purchase Amount. 11 integers 2 decimals | Numeric | 13 | 84 |
DSK-AMT-2 | Return amount. 11 integers 2 decimals | Numeric | 13 | 97 |
DSK-AMT-PROPINA | Tip amount. 7 integers 2 decimals | Numeric | 9 | 106 |
DSK-RESP-CDE | Response Code Issued by Base-24. Values between 000 and 009 indicate approved transaction. |
Alphanumeric | 3 109 | |
DSK-APPRV-CDE | Approval Code "Or Authorization". Delivered by the Issuer. |
Alphanumeric | 8 | 117 |
DSK-TERM-NAME | Terminal code POS Terminal ID | Alphanumeric | 16 | 133 |
DSK-ID-CAJA | Box Identifier | Alphanumeric | 16 | 149 |
DSK-NUM-BOLETA | Ticket Number | Alphanumeric | 10 | 159 |
DSK-FECHA-PAGO | Payment date 1 business day after the file process date |
Numeric | 6 | 165 |
DSK-IDENT | host identifier Corresponds to the “Merchant Identifier” that appears at the beginning of the name of the file name |
Alphanumeric | 2 | 167 |
DSK-ID-RETAILER | Responsible Trade Code Code of the intermediary merchant (if any) between the Merchant and the cardholder |
Numeric | 8 | 175 |
DSK-ID-COD-SERVI | Service Code | Alphanumeric | 20 | 195 |
DSK-ID-NRO-UNICO | unique number Assigned by trade |
Alphanumeric | 26 | 221 |
DSK-PREPAGO | prepaid Value "P" for registrations that come from prepaid. Blank if it is a transaction for another product. |
Alphanumeric | 1 | 222 |
FILLER | Available | Alphanumeric | 18 | 240 |
Debit quadrature file (L3)
The debit statement file contains the detailed record of the financial transactions made with a debit card. Contains both face-to-face and non-face-to-face transactions.
Header
Name | Description | Format | Length | Total |
---|---|---|---|---|
Dktt-Hr-Reg | Type of register | Alphanumeric | 2 | 2 |
Dktt-Hr-Fech-Proc | Date of process | Numeric | 6 | 8 |
Dktt-Hr-Hora-Proc | Process Time | Numeric | 6 | 14 |
Dktt-Hr-Glosa | Merchant Name Trade Fancy Name |
Alphanumeric | 25 | 39 |
Filler | Available | Alphanumeric | 201 | 240 |
Footer
Name | Description | Format | Length | Total |
---|---|---|---|---|
DSK-TR-REG | Type of register. "TR" value | Alphanumeric | 2 | 2 |
DSK-TR-FECHA-PROC | Date of process | Numeric | 6 | 8 |
DSK-TR-HORA-PROC | process time | Numeric | 6 | 14 |
DSK-TR-TOT-REG | Total Records | Numeric | 7 | 21 |
DSK-TR-MONTO | Total amount. 11 integers 2 decimals | Numeric | 13 | 34 |
DSK-TR-MONTO-COM | Total Commission Amount. 11 integers 2 | Numeric | 13 | 47 |
FILLER | Alphanumeric | 193 | 240 |
Detail
Name | Description | Format | Length | Total |
---|---|---|---|---|
DSK-DT-REG | Record Type Fixed value “DT” | Alphanumeric | 2 | 2 |
DSK-TYP | Transaction Type 0210 : online sale 0420 : reverse | Numeric | 4 | 6 |
DSK-TC | Transaction Code4 "10" : Purchase "18" : Purchase with change "30" : Withholding | Numeric | 2 | 8 |
DSK-TRAN-DAT | Transaction Date “YYMMDD” format. Corresponds to the date on which Transbank issued a response to the transaction |
Numeric | 6 | 14 |
DSK-TRAN-TIM | Transaction Time “HHMMSS” format. Corresponds to the time in which Transbank issued a response to the transaction |
Numeric | 6 | 20 |
DSK-ID-RETAILER | Provider Commerce Code | Numeric | 12 | 32 |
DSK-NAME-RETAILER | Merchant Name business fancy name |
Alphanumeric | 20 | 52 |
DSK-CARD | Card number Only the last 4 digits appear, the rest are masked with * |
Alphanumeric | 19 | 71 |
DSK-AMT-1 | Purchase Amount. 11 integers 2 decimals | Numeric | 13 | 84 |
DSK-AMT-2 | Return amount. 11 integers 2 decimals | Numeric | 13 | 97 |
DSK-AMT-PROPINA | Tip amount. 7 integers 2 decimals | Numeric | 9 | 106 |
DSK-RESP-CDE | Response Code Issued by Base-24. Values between 000 and 009 indicate approved transaction. |
Alphanumeric | 3 109 | |
DSK-APPRV-CDE | Approval Code "Or Authorization". Delivered by the Issuer. |
Alphanumeric | 8 | 117 |
DSK-TERM-NAME | Terminal code POS Terminal ID | Alphanumeric | 16 | 133 |
DSK-ID-CAJA | Box Identifier | Alphanumeric | 16 | 149 |
DSK-NUM-BOLETA | Ticket Number | Alphanumeric | 10 | 159 |
DSK-FECHA-PAGO | Payment date 1 business day after the file process date |
Numeric | 6 | 165 |
DSK-IDENT | host identifier Corresponds to the “Merchant Identifier” that appears at the beginning of the name of the file name |
Alphanumeric | 2 | 167 |
DSK-ID-RETAILER | Responsible Trade Code Code of the intermediary merchant (if any) between the Merchant and the cardholder |
Numeric | 8 | 175 |
DSK-ID-COD-SERVI | Service Code | Alphanumeric | 20 | 195 |
DSK-ID-NRO-UNICO | unique number Assigned by trade |
Alphanumeric | 26 | 221 |
DSK-PREPAGO | prepaid Value "P" for registrations that come from prepaid. Blank if it is a transaction for another product. |
Alphanumeric | 1 | 222 |
FILLER | Available | Alphanumeric | 18 | 240 |
Credit settlement file (L5)
The credit settlement file contains a detailed record of the payments and withholdings on the merchant's account within a given period for credit card transactions.
Header
Name | Description | Format | Length | Total |
---|---|---|---|---|
Abono - Desde | Subscription period start date ddmmyyyy | Numeric | 8 | 8 |
Filler | Filling | Alphanumeric | 1 | 9 |
Abono – Hasta | Payment period end date ddmmyyyy | Numeric | 8 | 17 |
Filler | Filling | Alphanumeric | 1 | 18 |
Proceso – Fecha | Processing date, in ddmmyyyy format | Numeric | 8 | 26 |
Filler | Filling | Alphanumeric | 1 | 27 |
Abono - Fecha | Transaction payment date, in ddmmyyyy format | Numeric | 8 | 35 |
IF length of client code is less than 4
Name | Description | Format | Length | Total |
---|---|---|---|---|
Código cliente | Internal customer number | Numeric | 3 | 38 |
Nombre de cliente | Merchant Name | Alphanumeric | 20 | 58 |
Filler | Filling | Alphanumeric | 76 | 134 |
Filler | Contains "HEADER" | Alphanumeric | 6 | 140 |
Filler | Filling | Alphanumeric | 89 | 229 |
IF length of client code is greater than 3
Name | Description | Format | Length | Total |
---|---|---|---|---|
Código cliente | Internal customer number | Numeric | 5 | 40 |
Nombre de cliente | Merchant Name | Alphanumeric | 20 | 60 |
Filler | Filling | Alphanumeric | 74 | 134 |
Filler | Contains "HEADER" | Alphanumeric | 6 | 140 |
Filler | Filling | Alphanumeric | 89 | 229 |
Footer
Name | Description | Format | Length | Total |
---|---|---|---|---|
Sal - Contador | Number of transactions to pay | Numeric | 10 | 10 |
Filler | Filling | Alphanumeric | 1 | 11 |
Sal - Monto | Total amount of sales to be paid (11 integers, 2 decimals) | Numeric | 13 | 24 |
Filler | Filling | Alphanumeric | 1 | 25 |
Sal - Rret. | Number of retentions | Numeric | 10 | 35 |
Filler | Filling | Alphanumeric | 1 | 36 |
Sal - Ret. | Total amount of withholdings (11 integers, 2 decimals) | Numeric | 13 | 49 |
Filler | Filling | Alphanumeric | 1 | 50 |
Sal - Ceic | Total amount of commission plus VAT of the commission (Sale) (11 integers, 2 decimals) | Numeric | 13 | 63 |
Sal - caeica | Total amount of additional commission plus additional VAT of the commission (11 integers, 2 decimals) | Numeric | 13 | 76 |
Sal - dceic | Total amount of commission plus VAT of the commission (Withholdings) (11 integers, 2 decimals) | Numeric | 13 | 89 |
Sal - dcaeica | Total amount of additional commission plus additional VAT of the commission (Withholdings) (11 integers, 2 decimals). | Numeric | 13 | 102 |
Filler | Filling | Alphanumeric | 32 | 134 |
Filler | Contains "FOOTER" | Alphanumeric | 6 | 140 |
Filler | Filling | Alphanumeric | 89 | 229 |
Detail
Name | Description | Format | Length | Total |
---|---|---|---|---|
Liq-Numc | Commercial Code | Numeric | 8 | 8 |
Liq-Fproc | Process Date, in ddmmyyyy format | Numeric | 8 | 16 |
Liq-Fcom | Date of sale or retention, in ddmmyyyy format | Numeric | 8 | 24 |
Liq-Micr | Microfilm number | Alphanumeric | 8 | 32 |
Liq-Numta | Card Number IF numPedido is null | Alphanumeric | 19 | 51 |
Liq-Marca | Card Type. The values are, VI: Visa; MC: Master; DI: Diners; AX: Amex | Alphanumeric | 2 | 53 |
Liq-Monto | Amount of the sale or withholding (11 integers, 2 decimals) | Numeric | 11 | 64 |
Liq-Moneda | Type of currency. 0: weights; 1 dollar. | Numeric | 1 | 65 |
Liq-Txs | Transaction Type. If it is a sale: "VA" Sale to be paid "VP" Paired sale with retention ("RP"). If it is withholding: “RP” Retention paired with sale (“VP”) “RA” Total Retention Applied “RC” Withholding balance partially applied. “RE” Pending Withholding |
Alphanumeric | 2 | 67 |
Liq-Rete | Transaction attribute. If it is a sale to be paid or paired, it goes “0000”. If it is a 3CSI sale, it goes “C3C ” where it is the installment number. If it is sale Quotas Comercio, it goes “I&&&”, where &&& is the amount of quotas, aligned to the right. If it is sale NInstallments, it goes “nnSI”, where nn indicates the number of installments (02 to 24) and YES indicates: installments without interest. If it is retention, it goes the withholding code. | Alphanumeric | 4 | 71 |
Liq-Cprin | Code of the parent company of the business. If LiqNumc is the array, it carries "99999999". | Numeric | 8 | 79 |
Liq-Fpago | Payment date, in ddmmyyyy format | Numeric | 8 | 87 |
Liq-orpedi | Order Number or Barcode | Alphanumeric | 26 | 113 |
Liq-codaut | Transaction authorization code | Alphanumeric | 6 | 119 |
Liq-cuotas | Installment number that is being paid and that operates for sales made with the products Nquotas or Sales in installments without interest. | Numeric | 2 | 121 |
Liq-vci | Transaction Authentication Value (Sale) | Numeric | 4 | 125 |
Liq-ceic | Value of the commission plus VAT of the commission (Sale) | Numeric | 11 | 136 |
Liq-caeica | Value of the additional commission plus additional VAT of the commission | Numeric | 11 | 147 |
Liq-dceic | Value of the commission plus VAT of the commission (Withholdings) | Numeric | 11 | 158 |
Liq-dcaeica | Value of the additional commission plus additional VAT of the commission (Withholdings) | Numeric | 11 | 169 |
Liq-ntc | total number of installments of the original sale and that operates for sales made with the products NInstallments or Sales in installments without interest. | Numeric | 2 | 171 |
Liq_Nombre_banco | Bank name will indicate the name of the bank | Alphabetical | 35 | 206 |
Liq_Tipo_cuenta_banco | Type of bank account associated with the payment | Alphabetical | 2 | 208 |
Liq_Número_cuenta_banco | Number of the bank account associated with the subscription | Alphabetical | 18 | 226 |
Liq_Moneda_cuenta_banco | Currency of the selected credit account | Alphabetical | 3 | 229 |
Debit settlement file (L5)
The debit settlement file contains a detailed record of credits and withholdings on the merchant's account within a given period for debit card transactions.
Header
Name | Description | Format | Length | Total |
---|---|---|---|---|
Abono-Desde | Subscription period start date Format 'ddmmyy' | Numeric | 6 | 6 |
Filler | Available | Alphanumeric | 1 | 7 |
Abono-Hasta | Subscription period end date Format 'ddmmyy' | Numeric | 6 | 13 |
Filler | Available | Alphanumeric | 4 | 17 |
Liqu-Fecha | Settlement date Format 'ddmmyy' | Numeric | 6 | 23 |
Filler | Available | Alphanumeric | 1 | 24 |
Nombre-Fan | business fancy name | Alphanumeric | 25 | 49 |
Header | Register indicator “HEADER” | Alphanumeric | 6 | 55 |
Filler | Available | Alphanumeric | 160 | 215 |
Footer
Name | Description | Format | Length | Total |
---|---|---|---|---|
Liq-Ncom | Sum of detail records For detail records with Liq-Ttra = “00” | Numeric | 10 | 10 |
Filler | Available | Numeric | 1 | 11 |
Liq-Tcom | Sum of Liq-Amt1 field. 11 integers 2 decimals For detail records with Liq-Ttra = “00” |
Numeric | 13 | 24 |
Filler | Available | Numeric | 1 | 25 |
Liq-Nret | Sum of withholding detail records | Numeric | 10 | 35 |
Filler | Available | Alphanumeric | 1 | 36 |
Liq-Mret | Sum of field Liq-Amt1, for detail records with Liq-Ttra =”03”. 11 integers 2 decimals | Numeric | 13 | 49 |
Liq-Vret | Fixed values of “000000000” | Numeric | 9 | 58 |
Liq-Tret | Fixed values of “0000000000” | Numeric | 10 | 68 |
Footer | Record type indicator “FOOTER” | Alphanumeric | 6 | 74 |
Liq-Tot-Com-comiv | Sum of the commission plus VAT of the commission (Sale). 11 integers 2 decimals | Numeric | 13 | 87 |
Filler | Available | Alphanumeric | 1 | 88 |
Liq-Tot-decom-ivcom | Sum of the commission plus VAT of the commission (Withholdings). 11 integers 2 decimals | Numeric | 13 | 101 |
Liq-Fill | Alphanumeric | 114 | 215 |
Detail
Name | Description | Format | Length | Total |
---|---|---|---|---|
Liq-Ccre | Transbank's Internal Commerce Code It is the code assigned to the commerce by Transbank. Does not include the 5970 prefix. | Numeric | 8 | 8 |
Liq-Fpro | Processing date of the file Format 'ddmmyy'. Corresponds to the process date of the respective transaction. | Numeric | 6 | 14 |
Liq-Fcom | Date of purchase Format 'ddmmyy'. Corresponds to the date on which the transaction was made | Numeric | 6 | 20 |
Liq-Appr | Authorization Code Delivered by the authorizer | Alphanumeric | 6 | 26 |
Liq-Pan | Card number Only last four digits, other characters with asterisks | Alphanumeric | 19 | 45 |
Liq-Amt1 | Transaction amount. 11 integers 2 decimals | Numeric | 13 | 58 |
Liq-Ttra | Transaction type = 0 : purchase paid greater than 0 : retention |
Numeric | 2 | 60 |
Liq-Cpri | Fixed value “99999999” | Numeric | 8 | 68 |
Liq-Marc | Withholdings Value “RE”: for withholdings Blank if it is a paid transaction. | Alphanumeric | 2 | 70 |
Liq-Fedi | Settlement Date Format 'dd/mm/yy' Corresponds to the payment date of the respective transaction | Alphanumeric | 8 | 78 |
Liq-nro-unico | unique number | Alphanumeric | 26 | 104 |
Liq-com-comiv | Value of the commission plus VAT of the commission (Sale). 11 integers 2 decimals | Numeric | 13 | 117 |
Liq-cad-cadiva | N/A The length is filled with “0”. 11 integers 2 decimals | Numeric | 13 | 130 |
Liq-decom-ivcom | Value of the commission plus VAT of the commission (Withholdings). 11 integers 2 decimals | Numeric | 13 | 143 |
Liq-dcoad-ivcom | N/A The length is filled with “0”. 11 integers 2 decimals | Numeric | 13 | 156 |
Liq_prepago | Prepayment “P” value for registrations that come from prepayment. Blank if it is a transaction for another product. | Alphanumeric | 1 | 157 |
Liq_Nombre_banco | Name of the bank the name of the bank will be indicated | Alphabetical | 35 | 192 |
Liq_Tipo_cuenta_banco | Type of bank account associated with the payment | Alphabetical | 2 | 194 |
Liq_Número_cuenta_banco | Number of the bank account associated with the subscription | Alphabetical | 18 | 212 |
Liq_Moneda_cuenta_banco | Currency of the selected credit account | Alphabetical | 3 | 215 |
Grades
- All the “Process Date” fields explained in this document apply to the Process Date of the file
- The following table indicates which transactions can occur through both Host and Contingency POS, and which only through one of the two ways:
Transaction Type | |||
transaction code | 210 | 220 | 420 |
---|---|---|---|
10 | Host - POS | Host - POS | Host - POS |
13 | Webpay | Webpay | |
14 | POS - Webpay | Host | Host - POS - Webpay |
18 | Host - POS | Host - POS |
- For applications with SPDH 3.1 messaging, cancellation transactions carried out through the Host are considered as FS04 (offline), which would be represented in the file as a 220-14
- For purposes of matching transactions, only records with transaction code “10” (Purchases), “13” (WebPay) and “18” (Purchase with change) should be considered.
- For records corresponding to withheld transactions (Transaction Code “30”), only the following fields will be reported: o Transaction Date (Dktt-Dt-Tran-Dat) o Commercial Code (Dktt-Dt-Id-Retailer) o Unique Number (DSK-ID-NUM-UNICO) or Transaction Amount (Dktt-Dt-Amt-1)
- In the case of Settlement, the field (liq-vci), may contain the TSY values (correctly authenticated), since it shows only national ok authorizations. In the case of an international transaction, you will be able to see TSY and A (authentication attempt)
- In the cases of quadrature file, the field (Dktt-Dt-VCI) in addition to the previous cases, there will also be rejections with TO (TimeOut) and TSN (Transaction not authenticated).
Balance file
Considers the accounting balances pending payment for the Credit ($ and US$) and Debit products. It contains all the transactions that are processed until the accounting close (last day of processing until 2:00 p.m.) and that are pending payment (sales) or charge (withholdings).
Material available in the box
- Detail Accounting Balances Pending payment; File that contains all transactions pending payment that support the report available on the portal
- Detail transactions at the end of the month; File that presents the detail of transactions at the end of the month, that have not been processed within the month and that do not make up the balance report pending payment. A folder called CARTOLA_SALDOS will be created for each client mailbox, inside it will be all the files where their name will identify with PREFIJO_FECHA_RUT (DET_DDMMYYY_XXXXXXXXX).
DET_31102018_761349465. (.txt) COL_31122018_761349465. (.txt)
Text file structure
Field | Data Type | Length |
---|---|---|
FECHA PROCESO | DATE | |
RUT COMERCIO | STRING | 9 |
CÓDIGO COMERCIO | STRING | 8 |
TIPO CONTRATO | STRING | 2 |
DESCRIPCIÓN TIPO CONTRATO | STRING | 13 |
TIPO FLUJO | STRING | 4 |
DESCRIPCIÓN TIPO FLUJO | STRING | 2 |
FECHA VENTA | DATE | |
FECHA ABONO | DATE | |
TARJETA | STRING | 19 |
NRO CUOTA | NUMBER | 2 |
MONTO CUOTA | NUMBER | 17,2 |
LNIN SEC | NUMBER | 23 |
FECHA PROCESO TXS | DATE | |
MONTO VENTA | NUMBER | 17,2 |
CÓDIGO AUTORIZACIÓN | STRING | 6 |
ORDEN PEDIDO | STRING | 26 |
ID SERVICIO | STRING | 20 |
PAREADA | STRING | 2 |
Balance file name structure
The file names will have a new structure, as per the following detail:
<Formato de Salida>_<Periodo>_<Agrupación Archivo de Salidas>_<Agrupación de Transacciones>_<RutEnrolado ó CódigoComercio>_<Tipo Conexion><Modo Agrupación>
<Formato de Salida>
corresponds to the output format: LDN = Debit Settlement LCN = Credit Settlement CDN = Debit Settlement CCN = Credit Settlement
<Periodo>
corresponds to the date in DDMMAYYY format, according to the configured frequency:
- Daily: A daily file is generated based on the process date; this is the default frequency
- Monthly: One file is generated per month. Date associated with the penultimate business day of the month
<Agrupación Archivo de Salidas>
corresponds to the grouping nature:
- RE: File with unique information associated with the enrolled RUT (Generates a file)
- CC: File with information separated by merchant code of the transaction (generates a different file for each merchant code)
<Tipo Conexión>
corresponds to the type of connection of the commercial codes:
- A: A single file is generated. File information is not separated by connection type (when it is a single file it is not part of the name)
- SE: A file is generated for face-to-face and non-face-to-face connection type transactions
- NP: Non-face-to-face
- PR: face-to-face
<Modo Agrupación>
corresponds to the grouping mode of the commercial codes SC: Parent Branch (when it is grouped by RUT it is not included in the file name) RB: Item
Procedure link and connection Pinpad Bluetooth e355
Bluetooth Pinpad Link Flow
Pinpad Bluetooth connection E355
Power on equipment
Step 1
When turning on the equipment, it enters the main screen of the application.
Step 2
The “* 0 ” keys must be entered sequentially to enter the “Bluetooth Connection Menu.
Link devices
Step 3
In the bluetooth connection menu. Option 1> Bind Device is selected
Step 4
If a previous search was made, it will ask if you want to Search again , if you press 2> NO , it will show the devices found in the previous search.
The BT Name , which is the name that will be visible to other Bluetooth devices
Step 5
At the end of the search, it shows the devices found
Step 6
When selecting a device, this window will appear to confirm the link.
Step 7
When selecting the device, this window will appear to confirm the link.
A similar message will appear on the other device, the code that appears should be the same on both devices; In this case 648005 And we select YES and they will be linked
Step 8
Merchant must accept the Bluetooth connection.
The visit to the business must be coordinated - Contraparte Comercio
Check SPP enablement
SPP: Serial Profile interface (interface that emulates a serial port connection) must be configured if it is disabled
Step 1
In the main menu of the bluetooth manager. If it is required to enable SSP (Serial Port Profile) 3> Config MENU CONEC. BLUETOOTH SPP [Off]
Step 2
Select option 2 > SPP Server
Step 3
This screen will appear and you will return to the main menu
Delete linked equipment
Step 1
In the Bluetooth Manager Menu, select option 2> Paired Devices
Step 2
In this option, a menu will be displayed with all the devices that are linked to the e355 pinpad, the previously linked devices are registered.
Step 3
If we select the device, this menu will appear showing us 2 options. If we select YES we eliminate the link, and we return to the main menu.
Using the SDK
For the integration with the merchant's own applications, it is necessary to use the libraries included in the SDK of the Verifone e355 team in their own developments.
These are:
libPtr
libVmf
To facilitate the integration process, the reference to the “pinpad” resource is used, which contains functions for communication between Pinpad and the Merchant App. The structure and example code are included in the file demo_e355.zip
Import of libraries and Pinpad resource
Declaration of the main activity and PINPadTransport
Function for connection and disconnection
Example to send the command 0100 (read card to the pinpad) to the Pinpad
Function to receive the response from the Pinpad
Installation on Windows
When the link is made, 2 COM ports are created that are linked to Bluetooth. In order to review it, you must enter: Devices
Step 1
Step 2
Step 3
Step 4