THIS VERSION IS FOR HISTORICAL PURPOSES - FOR CURRENT SPECIFICATION, REFER TO:

...

Current Owners:	Kay Chau
Status (Draft, In Review, Stable, Approved)	Stable

Table of Contents

Introduction

...

This feature is in the Admin section and will allow the User to import transactions

Actors

Preconditions

...

Column Name	Required	Description	Comments	Validations	Range	Example	Maps to Mifos
Receipt	No	Receipt ID	Receipt ID is exclusive to MPESA, we can ignore	None
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 to accept row. Other statuses throw an error	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	No		Ignore			Pay Utility
Other Party Info	No	Phone number, telephone number	Ignore			0722926212 - CYNTHIA OMONDI
Transaction Party Details	Yes	"Client account number assigned by MFI"	We will use this to have Client National ID and include short names) of product(s) applied to the client's accounts if it is different than the default order set in ImportTransactionOrder	Validate that ID matches a client's in Mifos, and validate 3-4 letter codes corresponds to a loan or savings product in Mifos	Just client ID, to client ID plus product(s)	1. 3029149635 2. 30556 AL1	1. Client's National ID 2. Client's National ID, and Advance Loan 1

...