Omoney's CSV reports contain 39 columns with different values regarding your transaction. You may refer to the list of definitions here
|
Columns |
Definition |
|
Txn No |
Transaction number, a reference number for the transaction |
|
Partner |
Name of the marketplace or platform that facilitated the transaction For marketplace sellers, the platform will be listed as the Marketplace. For payment links generated via Omoney's dashboard, the platform will be indicated as Omoney. For Sellers using Omoney on their own website, the platform will be registered business name |
|
Partner Reference ID |
Marketplace identifier value. Example, marketplace escrow number, auto generated value, etc. Will be returned as part of the response body and webhooks. |
|
State |
State of the payment. Refer to : /api/docs.htmldocs/escrow-object-states#all-possible-escrow-states |
|
Sub State |
Sub-state of the payment, depending on what state the payment is in. Refer to: /api/docs.htmldocs/escrow-object-states#all-possible-escrow-sub-states |
|
Payment Remarks |
Transaction success or failure code Provides further details for failed transactions (e.g., insufficient funds, Failed 3DS, etc) |
| Transaction Description |
Description of the transaction (for what this payment is for) This captures seller declared description / shopping cart information at the time of transaction creation |
| Invoice Currency |
The currency in which the invoice is provided. Transactions are permitted to be invoiced in either the buyer's currency, seller's currency or in Universal Currencies (USD, EUR, GBP) |
| Invoice Amount | The invoice amount |
| Total Transaction Fee |
Total transaction fee charged for the transaction (across both buyer and seller) This is displayed in invoice currency |
| Buyer Paid Txn Fee |
How much the fee percentage is taken from the buyer. Based on % fee split selected by the seller / platform |
| Seller Paid Txn Fee |
How much the fee percentage is taken from the seller. Based on % fee split selected by the seller / platform |
| Buyer Payable Amount |
The total amount the buyer has to pay in the transaction (in invoice currency) This is the invoice amount, plus any buyer paid transaction fees |
| Seller Receivable Amount |
The total amount that the seller will receive in the transaction (in invoice currency) This is the invoice amount, less any seller paid transaction fees |
| Settled FX Rate |
The FX rate charged for conversion to final settlement amount (if applicable) This is applicable only for completed transactions which have been settled |
| Seller Release Currency |
The currency to be released to the seller This is based on the primary bank account attached in the Omoney system |
| Seller Released Amount |
The amount to be released to the seller This is the seller receive amount, multiplied by the Settled FX rate |
| Mode of Payment |
Payment method used to fund the transaction A full list of payment methods that Omoney supports by country can be found here: https://Omoney.com/payment-methods |
| Created Date | When the transaction was created |
| Payment Received Date |
Date of successful payment For asynchronous payment methods, this is the date when funds are sighted by Omoney |
| Settled Date | Date when settlement for the transaction was initiated by Omoney |
| Seller Document Proof Upload Date | When the seller uploaded their documentary proof for goods/service delivery for a transaction (if applicable) |
| Initiator Role |
Indicator on the party initiating the transaction This can be either the seller, platform / marketplace or the buyer in certain circumstances |
| KYB Status of Seller/Initiator | KYB status of the recipient in the transaction |
| Buyer Platform Customer ID | Custom ID assigned to the buyer as determined by the marketplace/platform |
| Buyer Full Name | Full Name of the buyer |
| Buyer Company Name | Name of the buyer's company if it is a business entity |
| Buyer Email | Contact email of the buyer |
| Buyer Country | Country of the buyer |
| Buyer Contact Code | Country calling code of the buyer |
| Buyer Contact Number | Contact number of the buyer |
|
Seller Platform Customer ID |
Custom ID assigned to the seller as determined by the marketplace/platform |
|
Seller Full Name |
Full Name of the seller |
|
Seller Company Name |
Name of the seller's company if it is a business entity |
|
Seller Email |
Contact email of the seller |
|
Seller Country |
Country of the seller |
|
Seller Contact Code |
Country calling code of the seller |
|
Seller Contact Number |
Contact number of the seller |