...
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 | 3466spoxstore | ||||||
3 | Terminal | VARCHAR | 16 | Terminal Number (TermID) | Generic value assigned by InComm Payments - No considered in the RTG transaction | 3466002SPOXspoxterm | ||||||
4 | Product | VARCHAR | 264 | Description of the goods or services available for sale | Product description - No considered in the RTG TransactionProduct Description | Mexico Google Online POD 100 MXN | ||||||
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/-07-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 | |||||
12 | IncommRefNum | VARCHAR | 50 | Time that the transaction was processed | authID | 969896818 | ||||||
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 |
Archivos CONCILED
Son los archivos en formato CSV que contienen los registros conciliados que hicieron match con la base de datos en Mongo.
...