Estructura Archivos Conciliación
- Elizabeth Rivera Lazcano (Unlicensed)
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 | spoxstore |
3 | Terminal | VARCHAR | 16 | Terminal Number (TermID) | Generic value assigned by InComm Payments - No considered in the RTG transaction | SPOXspoxterm |
4 | Product | VARCHAR | 264 | Description of the goods or services available for sale | Product description - No considered in the RTG Transaction | 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-07-2022 |
10 | TransTime | TIME | hhmmss | Date that the transaction was processed | Time from dateTime | 04:48:11:740 |
11 | 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.
Nombre del archivo | Estructura de los campos |
|---|---|
| Organization,Account Number,Record Number,Logo,Record Type,Effective date,Transaction type,Transaction code,Transaction amount,Batch date,Posting date,Authorisation code,Credit plan number,Reference number,Description,Acceptor category code,Logic Module,Source,Plan Sequence,Posting flag,Card number,Card sequence number,Card block code,Card acceptor id,Insurance product,Usage code,Cash-back amount,FILLER,Original payment amount,Merchant country code,Interchange reference,Universal Cardholder Authentication Field Collection indicator,CAT level,Prepaid account indicator,POS entry mode,Unnamed: 35,Current transfer status,Forced posting indicator,Previous transfer status,Interchange fee,PPD Fee type indicator,Transaction-based Pricing Offer,Discount Offer,SKU Number,Salesperson,Ticket Number,GL Source,Store Number Sign,Store Number,Purchase Order Number,Base Filler,Transaction Original Amount,Transaction Tips,Transaction IVA Tax,Transaction IVA Amount,NIT Number,Priority Policy Number,Transaction Channel,Number of Installments,Sales Tax amount,operation_type,_id,userId,relatedTransactionId,createdAt,transactionType,amount,authCode,xTransactionId,isReversed,transferTransactionId,objectId,find_mongo,Merchant,Location,Terminal,Product,UPC,VAN,PAN,SerialNumber,TransDate,TransTime,MerchantRefNum,IncommRefNum,TransType,TransCount,TransAmount,conciled_provider |
| Merchant,Location,Terminal,Product,UPC,VAN,PAN,SerialNumber,TransDate,TransTime,MerchantRefNum,IncommRefNum,TransType,TransCount,TransAmount,conciled_provider,Organization,Account Number,Record Number,Logo,Record Type,Effective date,Transaction type,Transaction code,Transaction amount,Batch date,Posting date,Authorisation code,Credit plan number,Reference number,Description,Acceptor category code,Logic Module,Source,Plan Sequence,Posting flag,Card number,Card sequence number,Card block code,Card acceptor id,Insurance product,Usage code,Cash-back amount,FILLER,Original payment amount,Merchant country code,Interchange reference,Universal Cardholder Authentication Field Collection indicator,CAT level,Prepaid account indicator,POS entry mode,Unnamed: 35,Current transfer status,Forced posting indicator,Previous transfer status,Interchange fee,PPD Fee type indicator,Transaction-based Pricing Offer,Discount Offer,SKU Number,Salesperson,Ticket Number,GL Source,Store Number Sign,Store Number,Purchase Order Number,Base Filler,Transaction Original Amount,Transaction Tips,Transaction IVA Tax,Transaction IVA Amount,NIT Number,Priority Policy Number,Transaction Channel,Number of Installments,Sales Tax amount,operation_type,_id,userId,relatedTransactionId,createdAt,transactionType,amount,authCode,xTransactionId,isReversed,transferTransactionId,objectId,find_mongo,conciled_datptx |
Archivos TRANSIT
Son los archivos en formato CSV que contienen los registors que no hicieron match con la base de datos en Mongo y que requieren revisión adicional de forma manual.
Nombre del archivo | Estructura de los campos |
|---|---|
| Organization,Account Number,Record Number,Logo,Record Type,Effective date,Transaction type,Transaction code,Transaction amount,Batch date,Posting date,Authorisation code,Credit plan number,Reference number,Description,Acceptor category code,Logic Module,Source,Plan Sequence,Posting flag,Card number,Card sequence number,Card block code,Card acceptor id,Insurance product,Usage code,Cash-back amount,FILLER,Original payment amount,Merchant country code,Interchange reference,Universal Cardholder Authentication Field Collection indicator,CAT level,Prepaid account indicator,POS entry mode,Unnamed: 35,Current transfer status,Forced posting indicator,Previous transfer status,Interchange fee,PPD Fee type indicator,Transaction-based Pricing Offer,Discount Offer,SKU Number,Salesperson,Ticket Number,GL Source,Store Number Sign,Store Number,Purchase Order Number,Base Filler,Transaction Original Amount,Transaction Tips,Transaction IVA Tax,Transaction IVA Amount,NIT Number,Priority Policy Number,Transaction Channel,Number of Installments,Sales Tax amount,operation_type,_id,userId,relatedTransactionId,createdAt,transactionType,amount,authCode,xTransactionId,isReversed,transferTransactionId,objectId,find_mongo,Merchant,Location,Terminal,Product,UPC,VAN,PAN,SerialNumber,TransDate,TransTime,MerchantRefNum,IncommRefNum,TransType,TransCount,TransAmount,conciled_provider |
| Merchant,Location,Terminal,Product,UPC,VAN,PAN,SerialNumber,TransDate,TransTime,MerchantRefNum,IncommRefNum,TransType,TransCount,TransAmount,conciled_provider,Organization,Account Number,Record Number,Logo,Record Type,Effective date,Transaction type,Transaction code,Transaction amount,Batch date,Posting date,Authorisation code,Credit plan number,Reference number,Description,Acceptor category code,Logic Module,Source,Plan Sequence,Posting flag,Card number,Card sequence number,Card block code,Card acceptor id,Insurance product,Usage code,Cash-back amount,FILLER,Original payment amount,Merchant country code,Interchange reference,Universal Cardholder Authentication Field Collection indicator,CAT level,Prepaid account indicator,POS entry mode,Unnamed: 35,Current transfer status,Forced posting indicator,Previous transfer status,Interchange fee,PPD Fee type indicator,Transaction-based Pricing Offer,Discount Offer,SKU Number,Salesperson,Ticket Number,GL Source,Store Number Sign,Store Number,Purchase Order Number,Base Filler,Transaction Original Amount,Transaction Tips,Transaction IVA Tax,Transaction IVA Amount,NIT Number,Priority Policy Number,Transaction Channel,Number of Installments,Sales Tax amount,operation_type,_id,userId,relatedTransactionId,createdAt,transactionType,amount,authCode,xTransactionId,isReversed,transferTransactionId,objectId,find_mongo,conciled_datptx |
Ejemplo
Por conveniencia se encuentra aquí abajo adjunta también la estructura de los archivos de conciliación en un documento de texto (.txt).
