Estructura Archivos Conciliación

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

60