Tanzania RnR Template Configuration
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