Tanzania RnR Template Configuration
- Ian Manyama
This page aim to show how RnR templates are configured on Tanzania eLMIS instance
Redesign RNR Template Mapping
| Na. | Column Letter | Column Label | Description |
|---|---|---|---|
| 1 | S | Skip | Skip |
| 2 | O | Namba mpya ya MSD | Unique identifier for each commodity |
| 3 | R | Maelezo ya bidhaa | Primary name of the product |
| 4 | U | Kipimo cha Ugavi (U) | Dispensing unit for this product |
| 5 | A | Kiasi cha kuanzia (A) | Stock in hand of previous period. This is quantified in dispensing units |
| 6 | B | Kiasi kilichopokelewa (B) | Total quantity received in last period. This is quantified in dispensing units |
| 7 | C | Upotevu au Marekebisho (C) | All kind of looses/adjustments made at the facility |
| 8 | E | Salio la mwisho (D) | Current physical count of stock on hand. This is quantified in dispensing units |
| 9 | X | Siku Ambazo Dawa Haikuwepo Kituoni (X) | Total number of days facility was out of stock |
| 10 | C | Matumizi halisi (E) | Total Quantity Consumed in a month after adjusting for stockout days. |
| 11 | N | Makadirio ya matumizi baada ya marekebisho [E* 60]/]60-X] (Z) | Total quantity consumed in period after adjusting for stockout days. |
| 12 | H | Kiasi cha juu kinachohitajika [Z x 2] (Y) | Maximum Stock calculated based on consumption and max months of stock. |
| 13 | I | Kiasi kinachohitajika kilichokokotolewa [Y - D] (F) | Actual Quantity needed after deducting stock in hand. |
| 14 | J | Kiasi halisi kinachohitajika (G) | Requested override of calculated quantity.This is quantified in dispensing units |
| 15 | V | Kiasi cha kuagizwa [K/U] (H) | Total packs to be shipped based on pack size and applying rounding rules |
| 16 | W | Maelezo ya kiasi halisi kinachohitajika | Explanation of request for a quantity other than calculated order quantity |
| 17 | K | Kiasi kilichoindinishwa (K) | Final approved quantity. This is quantified in dispensing units |
| 18 | L | Maelezo ya kiasi kilichoidhinishwa | Any additional remarks |
| 19 | T | Bei (I) | Price per Pack. It defaults to zero if not specified. |
| 20 | Q | Gharama [H x I] (J) | Total cost of the product. This will be zero if price is not defined |
OpenLMIS: the global initiative for powerful LMIS software