M-PESA - Import Loan Repayments plus Savings Deposits v2
Release | Leila E |
Current Owners: | Kay Chau |
Status (Draft, In Review, Approved) | Approved (Marie Valdez) |
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Introduction
...
Column Name | Required | Description | Comments | Validations | Range | Example | Maps to Mifos |
|---|---|---|---|---|---|---|---|
Receipt | Yes | Receipt ID is proof of payment and a unique MPESA identifier that can be cross-reference with clients phone receipt. Need to be imported into Mifos since needed in the KEEF Collection Sheet. | Receipt ID is exclusive to MPESA | Check that there is not an existing RECEIPT ID | Alphanumeric | Y29DW127 | Transaction Details - Receipt ID |
Date | Yes | Payment date |
| Validate date is in range (see above) | YYYY-MM-DD time | 2009-08-26 12:39:42 | Transaction Date |
Details | No | Contains information payment received from phone number, telephone number, MFI account number | Ignore |
|
|
|
|
Status | Yes | Completed | Check that Status says Completed. | Must be Completed, anything else IGNORE | Completed, Attempted, Cancelled, Declined | Completed |
|
Withdrawn | No | Amount paid from MFI | Only use for Disbursals, Phase 2 |
|
| 00 |
|
Paid In | Yes | Transaction amount paid to MFI |
| Validate it's an amount and check same validations in Mifos against digits after decimal | Should be digits after decimal = 0 | 200 | Transaction amount |
Balance | No | Balance of MFI | Ignore |
|
| 520,499 |
|
Balance Confirmed | No | automatic check in system | Ignore |
|
| true |
|
Transaction Type | Yes | Determines if this is a payment or disbursal | Check that this is Pay Utility, else ignore row | Must be Pay Utility, anything else IGNORE. | Pay Utility | Pay Utility | N/A |
Other Party Info | Yes | Safaricom generated phone number and name associated with phone number | Compare first 10 digits to phone number. If none exists, throw error. This will be used to identify where the transaction goes. | First 10 digits must correspond to a Phone Number | Numeric | 0722926212 - CYNTHIA OMONDI | Phone Number |
Transaction Party Details | Optional | Will include Mifos Product Code if there is one, and other information such as Client's Group ID, etc | We will use this to include short names) of product(s) applied to the client's accounts if it is different than the default order set in ke.co.safaricom.MPesaXlsImporter.ImportTransactionOrder | Validate 3-4 letter codes (everything before first space) corresponds to a loan or savings product in Mifos | Mifos product codes | SP1 | Savings Product 1 |
...