Debit Sales
Transcrição
Debit Sales
1 Electronic Statement Technical Specification Electronic Statement of Debit Sales Technical Specification Maestro Visa Electron Cabal Sicredi Índice estamos todos ligados 2 Table of Contents Electronic Statement Technical Specification Índice 01 02 03 04 05 06 07 Product Description 3 Miscellaneous Information 5 Structure of the Information Layout 7 4.1 6 Maestro/RedeShop Electronic Statement of Debit Sales 7 Chart of Adjustments 18 File Exchange Vehicle 20 Acronyms 20 Electronic Statement Technical Specification 01 Product Description The Electronic Statement is a tool that offers to registered establishments every day1, the description of the transactions with Credit and Debit cards and Financial Information, in accordance with the conditions set forth in Commercial Contracts. It is composed of four files: • EEVD – Electronic Statement of Debit Sales Transactions with Debit cards – MasterCard Maestro and Rede Shop Flags. • EEVC – Electronic Statement of Credit Sales Transactions with Credit cards –MasterCard and Diners Flags. Request Information. • EEFI – Electronic Financial Statement It reports the credit and debit adjustments that will be carried out in D+1, from the date the file is sent, indicating the type of entry and specific record (scheduling cancelations of installments carried out). • Information relating to regular credit, credit originated from Advance Sales Summary (RAV)2, adjustments (debit and credit) and scheduling cancelations is grouped in a single file. • EESA – Electronic Statement of Outstanding Balances It describes all Sales Summaries and their respective credit amounts, which will be effected in the future, as of the 1st day (inclusively) of the reference month, originated from transactions with Credit cards, of the MasterCard and Diners Flags. • It is static information, i.e., it does not include occasional credit, debit and Net3 adjustments, and scheduling cancelations of installments. Índice 3 Electronic Statement Technical Specification Main Advantages for Automation • • • • • • • Systemic integration of the Sales and Financial Statement; Automatic Reconciliation of Receivables; Integrity on receipt of the information/data; Agility in obtaining results; Companies approved by Rede, for traffic of files; Safe environment for receiving files; It enables that your IT department or Conciliatory Company customizes the applications inherent to each sector; • Daily update; • Expert technical support. Except for the Electronic Statement of Outstanding Balances, which is made available only once a month. 2 Service offered by Rede, enabling the establishment to anticipate its future receipts. 3 Net – Process for offsetting debit adjustments, in the Summary of Future Credits. 1 Índice 4 Electronic Statement Technical Specification 02 Miscellaneous Information • If there is any sort of problem in file processing, redirect it to Rede, in order that it is analyzed in detail. • When there are no transactions, a file containing only the header and trailer records will be sent to the establishment. • In case the file is reprocessed: - To the header date (002 record – 004 to 011 positions), the date in which there is reprocessing will be attributed. - To the transaction sequence (002 record – 072 to 077 positions), ‘000001’ will be attributed. • The establishment that intends to receive the Electronic Statement shall hire a VAN (according to item 4), and inform the membership number and the products it wishes to receive: EEVC – Electronic Statement of Credit Sales EEVD – Electronic Statement of Debit Sales EEFI – Electronic Financial Statement EESA – Electronic Statement of Outstanding Balances • Nomenclatures: RV (Resumo de Vendas - Sales Summary) CV (Comprovante de Venda - Sale Receipt) NSU (Número Sequencial Único - Single Sequence Number) RAV (Resumo Antecipado de Vendas - Advance Sales Summary) AVS (Address Verification System) TO (Transmissão Off-line - Offline Transmission) OC (Ordem de Crédito - Credit Order) Índice 5 Electronic Statement Technical Specification 6 03 Structure of the Information Daily Transactions File – Debit Cards There are 11 (eleven) types of record in this file: 00 Type Record – File Header 01 Type Record – Sales Summary 02 Type Record – Overall of the Point of Sales 03 Type Record – Overall of the Main Establishment 04 Type Record – Overall of the File 05 Type Record – Detailing of the Sales Receipts 06 Type Record – Suspended REDESHOP/MAESTRO Summary 07 Type Record – REDESHOP/MAESTRO Summary, released for payment 08 Type Record – Scheduling Cancelling of Post-dated Sales (total or partial) 09 Type Record – Settled Post-dated Transactions 10 Type Record – Non-settled Post-dated Transactions (distributor) 11 Type Record – NET Adjustments 12 Type Record – Request Note: Records are created in our system with size of up to 1024 positions (VB) and are not fixed. Consider free field after the information in the last column of every record. Índice 7 Electronic Statement Technical Specification 04 Layout 4.1 Maestro/RedeShop Electronic Statement of Debit Sales In the file, fields are delimited by comma. 00 Type Record - File Header Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Main point of sales or Business Group Membership Nr. 3ª 008 Num Issuing Date 4ª 008 Num Transaction Date 5ª 039 Alpha “Daily Transactions – Debit Cards” 6ª 008 Alpha “Rede” 7ª 026 Alpha Trade Name of the Establishment 8º 006 Num Transaction sequence 9º 015 Alpha Type of processing (Daily/Reprocessing) 10º 020 Alpha File version (V1.04 – 07/10 – EEVD) Índice 8 Electronic Statement Technical Specification 01 Type Record - Sales Summary Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 008 Num Credit Date (When post-dated, it will be described as “zero”) 4ª 008 Num Sales Summary Date 5ª 009 Num Sales Summary Nr. 6ª 006 Num Amount of Sales Receipts 7ª 015 9(13)V99 Gross Value (For the Buy and Draw, this field will be composed of “Purchase Value” + “Draw Value”) 8ª 015 9(13)V99 Discount Value 9ª 015 9(13)V99 Net Value 10ª 001 Alpha Type of Summary (D – Down payment debit/P – PostDated) 11ª 003 Num Bank 12ª 006 Num Branch 13ª 011 Num Current Account 14º 001 Alpha Flag Índice 9 Electronic Statement Technical Specification 02 Type Record - Overall of the Point of Sales Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 003 Num Amount of Sales Summaries Heeded 4ª 006 Num Amount of Sales Receipts 5ª 015 9(13)V99 Gross Overall 6ª 015 9(13)V99 Discount Overall 7ª 015 9(13)V99 Net Overall 8ª 015 9(13)V99 Post-Dated Gross Value 9ª 015 9(13)V99 Post-Dated Discount 10ª 015 9(13)V99 Post-Dated Net 03 Type Record - Overall of the Main Point of Sales Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Main point of sales Membership Nr. 3ª 003 Num Amount of Sales Summaries Heeded 4ª 006 Num Amount of Sales Receipts 5ª 015 9(13)V99 Gross Overall 6ª 015 9(13)V99 Discount Overall 7ª 015 9(13)V99 Net Overall 8ª 015 9(13)V99 Post-Dated Gross Value 9ª 015 9(13)V99 Post-Dated Discount 10ª 015 9(13)V99 Post-Dated Net Índice 10 Electronic Statement Technical Specification 04 Type Record - Overall of the File Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Main point of sales or Business Group Membership Nr. 3ª 006 Num Amount of Sales Summaries 4ª 006 Num Amount of Sales Receipts 5ª 015 9(13)V99 Gross Overall 6ª 015 9(13)V99 Discount Overall 7ª 015 9(13)V99 Net Overall 8º 015 9(13)V99 Post-Dated Gross Value 9º 015 9(13)V99 Post-Dated Discount 10º 015 9(13)V99 Post-Dated Net 11º 006 Num Overall Records in the File Índice 11 Electronic Statement Technical Specification 05 Type Record - Detailing of the Sales Receipts Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 009 Num Sales Summary Nr. 4ª 008 Num CV Date (DDMMYYYY) 5ª 015 9(13)V99 Gross Value (For the Buy and Draw, this field will be composed of “Purchase Value” + “Draw Value”) 6ª 015 9(13)V99 Discount Value 7ª 015 9(13)V99 Net Value 8ª 019 Alpha Card Number 9ª 001 Alpha Type of Transaction* 10ª 012 Num CV Number 11ª 008 Num Credit Date 12ª 002 Num Transaction Status (01 – heeded) 13ª 006 Num Transaction Time (HHMMSS) 14ª 008 Alpha Terminal Number 15ª 002 Num Type of Collection 16ª 005 Num Reserved 17º 015 9(13)V99 Purchase Value (For the Buy and Draw ) 18º 015 9(13)V99 Draw Value (For the Buy and Draw) 19º 001 Alpha Flag 20º 007 Num Authorization Code Índice 12 Electronic Statement Technical Specification 06 Type Record – Suspended REDESHOP/MAESTRO Summaries Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Number 3ª 009 Num Sales Summary Number 4ª 006 Num Amount of Sales Receipts 5ª 008 Num Sales Summary Date (DDMMYYYY) 6ª 008 Num Original Credit Date (DDMMYYYY) 7ª 008 Num Suspension Date (DDMMYYYY) 8ª 015 9(13)V99 Gross Value 9ª 015 9(13)V99 Discount Value 10ª 015 9(13)V99 Net Value (suspended) 11ª 003 Num Bank 12ª 006 Num Branch 13ª 011 Num Current Account 14ª 001 Alpha Type of Transaction 15ª 001 Alpha Flag Índice 13 Electronic Statement Technical Specification 07 Type Record – REDESHOP/MAESTRO summaries, released for payment Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Number 3ª 009 Num Sales Summary Nr. 4ª 006 Num Amount of Sales Receipts 5ª 008 Num Sales Summary Date (DDMMYYYY) 6ª 008 Num Current Credit Date (DDMMYYYY) 7ª 015 9(13)V99 Gross Value 8ª 015 9(13)V99 Discount Value 9ª 015 9(13)V99 Net Value (suspended) 10ª 001 Alpha Type of Transaction (D - Debit) 11ª 003 Num Bank 12ª 006 Num Branch 13ª 011 Num Current Account 14ª 001 Alpha Flag Note: 6 and 7 records are related. A suspended summary will be described in the 6 record and after release, in 7 record. Índice 14 Electronic Statement Technical Specification 08 Type Record - Scheduling Cancelling of Post-dated Sales (total or partial) Column Field Maximum Size Field Description Tam Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 009 Num Sales Summary Nr. 4ª 008 Num CV Date (DDMMYYYY) 5ª 012 Num CV Number (NSU) 6ª 015 9(13)V99 CV Gross Value 7ª 015 9(13)V99 Cancelling Value 8ª 002 Num Cancelling Reason (00– Cancelling/01 –Chargeback) 9ª 008 Num Credit Date 10ª 015 9(13)V99 New Credit Value Alpha Type of Transaction V = Debit Card (RedeShop/Maestro) C = CDC T = Trishop S = Construcard E = VisaElectron B = Cabal O = VisaElectron Debit Card 11ª Índice 001 15 Electronic Statement Technical Specification 09 Type Record - Settled Post-dated Transactions Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 008 Num Settlement Date 4ª 015 9(13)V99 Settled Value 5ª 012 Num Transaction NSU Number 6ª 008 Num Transaction Date 7ª 008 Num Due Date 8ª 015 9(13)V99 Discount Value 9ª 015 9(13)V99 Gross Value 10ª 001 Alpha Flag 10 Type Record - Non-settled Post-dated Transactions (Distributor) Coluna Fim Tam Descrição do Campo Size Pic 1ª 002 Num Type of Record 2ª 009 Num Point of Sales Membership Nr. 3ª 012 Num Transaction NSU Number 4ª 008 Num Transaction Date 5ª 008 Num Due Date 6ª 015 9(13)V99 Net Value 7ª 015 9(13)V99 Gross Value 8ª 002 Num Non-settlement reason code 9ª 030 Alpha Non-settlement reason description 10ª 001 Alpha Flag Índice 16 Electronic Statement Technical Specification 11 Type Record - NET Adjustments Column Field Maximum Size Field Description Size Pic 1ª 002 Num Type of Record (“11”) 2ª 009 Num Adjusted POS number 3ª 009 Num Adjusted Sales Summary number 4ª 008 Num Adjustment Date (DDMMYYYY) 5ª 015 9(13)V99 Adjustment Value 6ª 001 Alpha D (Debit) 7ª 002 Num Adjustment Reason (Adjustments Chart Code) 8ª 028 Alpha Adjustment Reason (Adjustment Chart String) 9ª 019 Num Card Number 10ª 008 Num “CV” Transaction Date 11ª 009 Num Original Sales Summary number 12ª 015 Alpha Letter/Fax Reference Number 13ª 008 Num Letter Date 14ª 006 Num Reference Month (Services, POS, etc.) 15ª 009 Num Original POS Nr. 16ª 008 Alpha Original Sales Summary Date 17ª 015 9(13)V99 Transaction value 18ª 001 Alpha N (Net) 19ª 008 Num Credit Date 20ª 015 9(13)V99 Gross Value of the Original Sales Summary 21ª 015 9(13)V99 Cancelling Value required 22ª 012 Num NSU Number (16, 18 and 23 reasons) 23ª 006 Alpha Authorization Number 24ª 001 Alpha Type of debit 25ª 011 Num Debit order number 26ª 015 9(13)V99 Overall debit value 27ª 015 9(13)V99 Outstanding value 28ª 001 Alpha Origin Sales Summary Flag 29ª 001 Alpha Adjusted Sales Summary Flag Índice 17 Electronic Statement Technical Specification 12 Type Record – Request Column Field Maximum Size Field Description Tam Pic 1ª 002 Num Type of Record (“12”) 2ª 009 Num POS Number 3ª 009 Num Sales Summary Number 4ª 016 Alpha Card Number 5ª 015 9(15)v99 “CV/NSU” Transaction value 6ª 008 Num “CV/NSU” Transaction Date (DDMMYYYY) 7ª 015 Num Reference 8ª 015 Num Process Number 9ª 012 Num CV/NSU Number 10ª 006 Alpha Authorization Code 11ª 004 Num Request Code 12ª 008 Num Limit of documents sending (DDMMYYYY) 13ª 001 Alpha Flag Índice 18 Electronic Statement Technical Specification 05 Chart of Adjustments 1 2 3 4 5 6 7 8 9 10 11 13 14 15 16 17 18 19 20 21 22 23 24 28 29 30 34 35 36 37 38 39 40 46 48 49 51 Índice INTERCONNECTION FRANC. INQUIRY OF CHECKS DEBIT IN INSTALLMENTS FEE TX. DEBIT TX. MAN. OF TEF POS-INACTIV./CONNEC./PIN REGISTR./ADHESION MACHINE REPOS/ADDIC. MAESTRO CANCEL./CHBK. SECURECODE ADHESION SECURECODE MONTHLY FEE SECURECODE CONS. DEBIT FEE CHIP CARD CBK CI UNDUE CR. REVERSAL LOST POS INDEMNIF. SALES CANCEL. STATEMENT COPY POS-INACTIV./CONNEC./PIN MAESTRO CANCELLING SALES CONTESTATION SALES CONTESTATION CBACK EXCESS AD TRF AL.POS/PINPAD/CONNECT TX RECHARGE DEBIT DOLLAR. DESP. CANCEL. TARIFF MODEL AVS INQUIRY CV DEVOLUTION UNDUE CR. REVERSAL ADM. TX. REVERSAL REBATE REVERSAL MONTHLY STAT. TX. SPECIAL INSTALL. TX. AL.POS/PINPAD/CONNECT TX. POS-INACTIV./CONNEC./PIN SECURECODE CRED. 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 CBK DEBIT REVERSAL RECHARGE CREDIT LOWER SETTL. OVER. SALES SUM. NOT CONSID. SALES RECEIPT PROMOTION AWARD IN INSTALL. DISCOUNT PAYMENT RENT CREDIT MONTHLY REBATE FINAL REBATE HIGHER PAYMENT CRED DEV. TAX DIF. REGULARIZATION PRIOR DB REGULAR. SALES SUMMARY PAYMENT LOWER EFFECT. CR. COMPL. ADJUSTMENT INTEREST PAYMENT ADULTERATE SALES RECEIPT PAYMENT PGT.CV US$-P. TUR. AIRLINE PAYMENT BOND TRANSF. PAYMENT INSTALL. N S/J-1A PAYMENT INSTALL. N S/J-2A PAYMENT INSTALL. N S/J-3A PAYMENT INSTALL. N S/J-4A PAYMENT INSTALL. N S/J-5A PAYMENT INSTALL. N S/J-6A PAYMENT INSTALL. N S/J-7A PAYMENT INSTALL. N S/J-8A PAYMENT INSTALL. N S/J-9A PAYMENT COLLECTION CV OFF-TO CREDIT TUR. PACK. SALES FEE INCOME TAX W/O COMMISSION STA INCOME TAX ADDI. SALES SUMMARY PAYMENT DOLLAR PREPAID DOLLAR CANCEL. REVERSAL TIER PRICING Electronic Statement Technical Specification 19 05 Tabela de Ajustes 89 90 91 92 93 94 95 96 99 SERASA/AVS CONSERV. STAT. DOC. SEND. FEE REVERSAL LOST POS REVERSAL MONTHLY STAT. TX REVERSAL OUTSTANDING BALANCES STAT. REVERSAL ADHESION TX REVERSAL EST AL.POS/TX.CONNECT STAT. COPY TX REVERSAL NON-HEEDED DEBIT • All Alpha and Num files are separated by comma. • All Alpha fields are filled with whites after the information from right to left. • All Num fields are filled with zeros after the information from right to left. • The Type of Transaction field allows the following possibilities: V = Debit Card (RedeShop/Maestro) C = CDC T = Trishop S = Construcard P = Post-Dated • The Type of Summary field allows the following possibilities: D = Debit Summary P = Sales Summary (Post- Dated) The Transaction Status field allows the following possibility: 01 – Approved Índice Electronic Statement Technical Specification • Type of Collection 1 2 3 4 5 6 9 = = = = = = = Manual POS PDV TO Internet Track Reader Others • Type of Flag 1 3 4 9 H Índice = = = = = Maestro Visa Electron Cabal Sicredi Hiper 20 Electronic Statement Technical Specification 06 File Exchange Vehicle Files will be sent through VANS approved by Rede: Interchange/GXS [email protected] (0xx11) 2123 2500 / 2167 2600 / 0800 701 7444 TIVIT (Proceda) [email protected] (0xx11) 3626 6700 Nexxera [email protected] (0xx11) 2121 9600 / 2121 9665 / 98494 4499 Índice 21 Electronic Statement Technical Specification 06 File Exchange Vehicle Files will be sent through VANS approved by Rede: Mercador/Neogrid [email protected] (0xx47) 3043 7376 Accesstage [email protected] (0xx11) 3549 6987 Software Express [email protected] (0xx11) 3170 5354 Índice 22