| Table of Contents |
|---|
Archivo InComm
Nombre del archivo= SpinByOxxo_Daily_MerchantTransationDetails_aaaammdd.csv
De forma temporal se tendrán dos archivos dado que las columnas de IVA y total no existen en el archivo original que maneja el proveedor, el correcto que agrega estás columnas por el momento se llama SpinByOxxo_Daily_MerchantTransationDetails_aaaammddTEMP.csv
Col | Campo | Tipo | Size | Description | RTG field | Example | |
1 | Merchant | VARCHAR | 264 | Retailer Name | Retailer Name | SPIN BY OXXO | |
2 | Location | VARCHAR | 264 | Location Number (StoreID) | Generic value assigned by InComm Payments - No considered in the RTG transaction | 3466 | |
3 | Terminal | VARCHAR | 16 | Terminal Number (TermID) | Generic value assigned by InComm Payments - No considered in the RTG transaction | 3466002 | |
4 | Product | VARCHAR | 264 | Description of the goods or services available for sale | Product description - No considered in the RTG Transaction | Product Description | |
5 | UPC | VARCHAR | 64 | Universal Product Code for the product | UPC | 799366123452 | |
6 | VAN | VARCHAR | 30 | Unique Card Identifier (typically on the physical card) | UPC for most of digital products or metafield PAN for some digital products | 799366123452 | |
7 | PAN | VARCHAR | 128 | Primary Account Number | UPC for some digital products/ Empty for most of the products | 799366123452 | |
8 | SerialNumber | VARCHAR | 30 | (This number is printed on the card and required for redemptions) | SNB metafield and/or serialNum metafield | 14693460707 | |
9 | TransDate | DATE | mmddaaaa | Unique Card Identifier | Date from dateTime | 11/7/2022 | |
10 | TransTime | TIME | hhmmss | Date that the transaction was processed | Time from dateTime | 04:48:11:740 | |
11 | IncommRefNum | VARCHAR | 50 | Time that the transaction was processed | authID | 09:11:48:237 | |
12 | MerchantRefNum | INT |
| System Trace Audit Number – TransactionID; Recommended for use in reconciliation | TransactionID | 3191a644-f798-4667-8677-91afed11b45f | |
13 | TransType | VARCHAR | 255 | InComm-generated transaction identifier | Transaction that represents the API used | Activation | |
14 | TransCount | INT |
| Type of transaction; for example, Activation, Deactivation, Reverse Activation or Reverse Deactivation | -- | 1 | |
Will equal: | |||||||
1 for Activations | |||||||
-1 for Credits, and Activation Reversals | |||||||
15 | Transamount | Decimal |
| Transaction Amount | amount | 6043.1 | |
16 | IVA | Decimal |
| Tax |
| 6.9 | |
17 | TOTAL | Decimal |
| Transamount + IVA |
| 50 |
Archivos CONCILED
Son los archivos en formato CSV que contienen los registros conciliados que hicieron match con la base de datos en Mongo.
...