...
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 | 43.1 |
16 | IVA | Decimal |
| Tax |
| 6.9 |
17 | TOTAL | Decimal |
| Transamount + IVA |
| 50 |
...